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, querying, schema, and data management.
- 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.
- Perform database and SQL tuning, including reduction in I/Os, views, and triggers.
- Create indexes where required, considering fill factors 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 database technologies such as MySQL, MongoDB, HBase.
- Experience in performance tuning and optimization using native monitoring and troubleshooting tools.
- Proficient in scripting in at least one common scripting language.
- Experience supporting managed database solutions (AWS RDS, DynamoDB, AWS DocumentDB, Firestore).
- Experience building and managing database platforms through Infrastructure as Code (IaC).
- Strong working knowledge of HA/DR best practices and architecture.
- Strong documentation, training, and communication skills.
Optional Skills and Qualifications
- Automation using Python, Shell scripts, and PowerShell.
- Automation using Chef/Puppet is a plus.
- Experience with configuration management systems.
- Strong analytical and problem-solving skills.
- Experience operating under SOX/PCI/PII governance.
- Experience with Cassandra, Redis, and/or Elastic Cache.
- Minimum of 3 years of relevant experience.
Additional expertise includes installation, configuration, and maintenance of MySQL databases, provisioning MySQL instances (clustered and non-clustered), handling processes like upgrade, backup, recovery, migration, setting up monitoring/alarming, knowledge of HA/DR options, Linux performance tuning, and working with Percona and InnoDB engine.
Qualifications and Education Requirements: BE, B.Tech, M.Tech, MCA.