Database Engineer MYSQL .

We are looking for an outstanding Database Engineer with deep knowledge of and experience with a variety of relational and non-relational database technologies in a highly scalable environment. The ideal candidate should demonstrate superb technical competency in delivering mission-critical database platforms and services while ensuring the highest levels of scalability, availability, performance, and security.

Job Responsibilities

• Design, implement and manage database infrastructure on-premises and in the cloud.
• Collaborate with developers, network/system engineers, vendors, and support staff in an open and creative environment.
• Analyze procedures to control the access and allocation of data 
• Oversee real-time business metric aggregation, data warehousing and querying, schema and data management, and related duties 
• Maintain security controls in supported databases 
• Establish relationships with internal customers and team members to drive collaboration.
• Primary owner of 24x7 on-call external DB support team
• Database and SQL tuning, including reduction in I/Os, views and triggers.
• Creating indexes where required while taking a look at the fill factor for existing ones.

Skills And Qualifications

• Proven experience building and supporting highly available database platforms and services at scale in a fast-paced environment.
• Proficient in the following database technologies, MySQL, MongoDB, HBase
• Experience in performance tuning and optimization using native monitoring and troubleshooting tools.
• Proficient at scripting in at least one common scripting language.
• Experience supporting managed database solutions (AWS RDS, Dynamo DB, AWS Document DB, Firestore).
• Experience building/managing database platforms through Infrastructure as Code (IaC).
• Strong working knowledge of HA/DR best practice architecture.
• Strong documentation/training/communication skills.

Optional Skills And Qualifications

• Automation using Python , Shell scripts and PowerShell
• Automation using Chef/Puppet would be a plus
• Experience with config management systems 
• Strong analytical and problem solving skills
• Experience operating under SOX/PCI/PII governance
• Experience with Cassandra, Redis and/or Elastic Cache.
• Having 3 years of experience.

Knowledge of Installation, configurations and maintenance of Mysql database.
Experience in Provisioning MySQL instances, both in clustered and non-clustered configurations.
Handle common database process, such as upgrade, backup, recovery, migration, etc.
Set up monitoring / alarming for production DB environments.
Knowledge of High Availability (HA) and Disaster Recovery (DR) options.
Expertise in designing and maintaining MySQL .
Experience in Linux performance, memory management, I/O tuning, cluster management, Data durability, security, networking, and system crash analysis.
Experience in setting up and operating Highly Available MySQL.
Knowledge of shell scripting.
Experience in working with Percona and innoDB engine.

Qualifications and Education Requirements:-

 BE, B.Tech, M.Tech, MCA.