Sr. Production Database Administrator Jaipur

About this role

We are seeking a seasoned DBA to join our team. You will have extensive experience in a mission-critical environment as a database administrator over a successful career. You will primarily work on the Supporting our Databases, AWS RDS (MySQL), and MongoDB/ Cassandra.

What You’ll Do

• Provide leadership in database scaling & monitoring. Maintain runbooks for our 24x7 SRE team.

• Assist in troubleshooting and resolution of database issues. Perform database upgrades and patches.

• Define and develop data pipelines between platforms in a mission-critical environment using DMS, Fivetran, Kafka, etc.

• Work with our developers to optimize and tune their SQL queries.

• Assist in application development, debugging, and optimization with respect to data concerns.

• Provide input in the design and implementation of backup, recovery, and DR strategy

• Review application and database design for compliance.

What You’ll Need

• Ability to script in a high-level language like Python, Ruby, etc for Automation.

• 8+ years of experience in AWS database services like RDS (Mysql), MongoDB/ Cassandra.

• 4+ years of experience in database design and DevOps on AWS.

• Must demonstrate a clear understanding of logical and physical database design and standards.

• Experience in columnar data warehouse solutions like Redshift or Snowflake.

• Must have extensive hands-on experience with MySQL in a large scale 24x7 production environment with millions of records.

• Bachelor of Science in Computer Science, Mathematics, or Engineering; or equivalent work experience

Bonus Points If You Have

• Experience with NoSQL solutions such as Cassandra/MongoDB etc.

• Experience with software development life cycle (SDLC) in an agile environment

• Hands-on production experience with Big Data applications such as Spark.

• Knowledge of development best practices (source control with Git, continuous integration, automated testing