Senior Database Administrator

Database Engineer:

The day-to-day activities:

• As the Database Engineer, you will be responsible for monitoring day to day database systems in terms of operations and management.
• Proactively respond to production infrastructure alerts and warnings, mitigate production issues as they arise and transform incident lessons into automation, documentation and monitoring    Diagnose any database issues and employ measures to prevent recurrence.
• Work with the engineering and operations team in building tooling to drive scalability, reliability and performance.
• Research and develop new technologies and approaches for building highly available data persistence systems.
• Perform code reviews and answer datastore related infrastructure questions.
• Automate the daily task and complex problem to build the team proficiency.
• Proficient working knowledge on percona toolkit. 

The must haves:

• 3 to 8 years of experience in the Database reliability domain with installation, management, upgrades, backup and restore of large MySQL & PostgreSQL
• Exceptional knowledge of both MySQL and InnoDB
• Be a wizard with databases and associated technical configurations
• Knowledgeable about performance tuning, query optimization, & index tuning
• Strong hands-on experience on MySQL database engines is must, good to have understanding on PostgreSQL.
• Experience benchmarking, Good understanding on NoSQL datastores or data structure databases (such as Redis, ElasticSearch , MongoDB,Cassandra) is definitely a plus.
• Experience in troubleshooting and resolving database integrity, performance, blocking and deadlocking, connectivity, security issues, etc.
• Experience with Performance Tuning and Optimization using native monitoring and troubleshooting tools
• Ability to detect and troubleshoot database servers related CPU, memory, I/O, disk space, and other resource contention.
• Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
• Cloud Services such as AWS and RDS, Azure, GCP