Senior Database Administrator – MySQL, SQL Server, AWS Cloud

This is a fully remote position, open to applicants in United States.

📋 Description

• Spearhead in-depth query optimization and performance diagnostics for MySQL, AWS Aurora MySQL, and SQL Server.

• Examine execution plans, index strategies, and memory utilization to identify bottlenecks and enhance response times.

• Evaluate, refactor, and optimize stored procedures, views, triggers, and inline queries.

• Implement schema refactoring, data transformations, and object migrations to AWS Aurora MySQL and AWS RDS SQL Server.

• Utilize native tools and AWS migration services, including AWS DMS/SCT.

• Assess database queries prior to deployment and uphold MySQL/Aurora indexing best practices.

• Guide software developers and engineering teams in query optimization techniques.

• Oversee AWS Aurora MySQL and AWS RDS SQL Server instances.

• Modify parameter groups, enhance the InnoDB buffer pool, manage indexes, and verify backups.

• Convert business requirements into relational data models and data transformation logic.

⛳️ Requirements

• Over 5 years of practical experience as a Database Administrator, primarily focused on MySQL and secondarily on SQL Server.

• More than 5 years of specialized experience in query performance optimization, index strategy refinement, and execution plan analysis, with a strong focus on MySQL/Aurora.

• Direct experience in analyzing and refactoring intricate SQL code, which includes stored procedures, functions, and transactional logic.

• At least 3 years of hands-on experience managing or migrating database workloads on AWS Aurora (MySQL) and AWS RDS (SQL Server).

• A minimum of 3 years of experience with relational data modeling, schema conversion, and database architecture.

• Profound knowledge in MySQL/AWS Aurora MySQL query performance tuning, engine internals, and index design.

• Familiarity with SQL Server.

• Experience in analyzing execution plans using EXPLAIN and Query Store.

• Strong understanding of relational schema design, indexing strategies, and locking/concurrency behavior.

• Preferred: Hands-on experience with AWS Database Migration Service (DMS) or AWS Schema Conversion Tool (SCT).

• Preferred: Background in supporting OLTP and analytical/data warehousing workloads.

• Preferred: Knowledge of Flyway, Liquibase, or Yuniql.

• Preferred: Experience with PowerShell or Bash scripting.

• A collaborative team player with strong problem-solving skills and effective technical communication.

🏝️ Benefits

• A values-driven culture.

• Opportunities for upward mobility.

• Professional development opportunities.

• Chances to learn and exchange ideas.

• Creative collaboration.