Avatar for Sportelos

DBA Support Engineer (MYSQL | AWS Aurora | DevOps)

₹5L – ₹7.5L
Apply now

Role and Responsibilities

  • Maintain configuration of Aurora instances including replication setup, parameter settings and identification of appropriate instance types/sizes.
  • Ensure performance, security, and availability of Aurora databases.
  • Recommend and implement performance tuning solutions, such as indexing and partitioning
  • Handle common database procedures, such as upgrade, backup, recovery, and migration.
  • Profile server resource usage, optimize and tweak as necessary.
  • Monitor production Aurora database(s) in AWS RDS, identifying emerging data-related issues, including system-level and SQL-level performance and database storage utilization, performing tuning and initiating proactive mitigating measures as appropriate; provides data-related incident response; and coordinates with others as necessary.
  • Maintain Aurora database monitoring tools and alerts and develops new monitoring and alerting capabilities as needed.
  • Respond quickly and effectively to production issues, troubleshooting solutions, and taking responsibility for seeing those solutions through resolution. Identify root cause and corrective actions for highly complex availability, capacity, security, performance, and quality issues affecting the database.
  • Review/deploy data-manipulation (DML) and data-definition (DDL) changes as needed.
  • Perform table maintenance as needed for business requirements.
  • Perform data cleanup in staging and production environments upon request.
  • Perform access management for authorized users.
  • Review and execute new queries as needed to support business requirements.
  • Stay current and continually increase expertise in database design, maintenance, administration, monitoring, tuning, continuous deployment, and AWS technologies. Skills and Qualifications
  • Strong proficiency in supporting, administrating, troubleshooting, and tuning of MySQL databases with a demonstrated thorough knowledge of MySQL
  • Experience with the various MySQL utilities
  • Strong knowledge of the innoDB storage engine and its affect/limits
  • Solid skills in performance tuning
  • Index creation and management
  • Partitioning creation and management
  • In-depth knowledge and experience with various database objects creation and maintenance
  • Working knowledge of the various logs and their usage
  • Working knowledge and experience using monitoring tools and instrumentation to proactively ensure optimum platform and application performance.
  • Experience in replication configuration and resolving replica database performance anomalies
  • Thorough knowledge of the various MySQL instance parameters governing overall database performance
  • Working knowledge of MySQL internals (incl. locking, transaction consistency, and recovery paths)
  • Thorough knowledge in identifying and resolving poorly executing SQL. Proficient in writing and optimizing SQL statements
  • Knowledge of and experience in de-facto standards and best practices in MySQL
  • Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases
  • Experience building and administering production databases
  • Experience interacting with customers, resolving database engine and system/infrastructure-related issues and providing guidance on systems architecture, data model, and SQL query reviews as needed
  • Strong knowledge of database systems theory
  • Proven track record mastering manual database-related tasks and building automation wherever possible to replace those tasks
  • Familiarity with Amazon Web Services and/or Cloud Computing
  • Familiarity with AWS/RDS, preferably Aurora
  • Excellent communication skills

More jobs at Sportelos

View all jobs

AWS Cloud Intern Developer

Apply now

Mobile Apps Developer Intern - Android

Apply now

Sports Content Writer - Intern

Apply now

Front End Engineer - Intern

Apply now