My SQL Database Admin

Essential functions and responsibilities:

• Monitor the health of the DB servers through both automated and manual processes

• Recommend and implement solutions for performance monitoring and tuning.

• Analyze problems, anticipate future problem areas, and implement solutions.

• Perform environment setup and configuration, proactive monitoring and maintenance.

• Support the development of long- and short-term requirements for database administration and design.

• Participate in your change control process for all planned application and technical activities.

• Work with report writers to provide data needed for reports.

• Take on full roadmap items, work with other functional teams, and be able to deliver high quality results on time.

• Investigate and find the root cause for software problems reported by stakeholders

• Direct organization of requirements and data into a usable database schema by directing development of ad hoc queries, scripts, updates to existing queries.

• May perform database administration and maintenance, including database installation and configuration, backups, upgrades, patching.

• Review SQL code written by application developers to ensure compliance to coding standards and best practices as well as maximum performance.

• Evaluate performance of stored procedures and find time/resource consuming areas and give inputs to application developers to fix them

• Create deployment and rollback scripts for all database objects manually or auto generated.

• Analyze access patterns and propose the best combination of indexes, constraints, foreign keys, and queries.

• Proactively identifies technical opportunities and enhancements while addressing major incidents in a timely manner

• Manages and ensures the integrity, security, and retention of data

• Administers and maintains end user accounts, permissions, and access rights

• Participate in an on-call rotation providing 24-hour, 7-day support, and off-hours maintenance windows

• Qualifications
  • Education and background:
  • Bachelor's degree in computer science or related discipline is required; experience may substitute for the education requirement
  • 3-5 years' experience with Relational Databases e.g. MariaDB/Mysql/NoSQL and above required
  • 3-5 years' experience with automation utilizing Shell scripting (Shell, Perl, python, etc.) required