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.
- 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.