DBA -Englewood Cliff, NJ - Hybrid (Locals Only)

 DBA 

Location: Englewood Cliff, NJ (Locals Only)

Hybrid: Yes, 3 days a week

Type: Contract on C2C

One in-person technical round at the client location

Minimum 10+ yrs of exp. is required.

Ideal Candidate Summary (One-Glance) of what the client is looking for

 Strong MySQL + PostgreSQL, Open-source DBA experience,  Production troubleshooting under pressure,  AWS (EC2, RDS) knowledge,  Automation exposure (Ansible, CloudFormation)  ACID, normalization, transactions mastery,  Fast decision-maker , Clear communicator

Job roles and responsibilities.

• This role requires strong knowledge of MySQL, Redis, PostgreSQL, and MongoDB. Most work is done in MySQL, PostgreSQL, and Redis.
• Candidates should have hands-on experience deploying, migrating, and experiencing blue-green deployments for upgrades and planning on EC2, AWS Aurora, RDS MySQL, and PostgreSQL.
• Experience in MongoDB is recommended but not mandatory, as the infrastructure is standardized and we rarely see requests.
• Experience in HAProxy, Keepalived configuration and management helps understand the infrastructure and excel.
• Strong replication knowledge and the ability to perform on-demand database refreshes from production to non-production are essential.
• Scripting knowledge, including strong shell scripting, knowledge of Ansible, and AWS CloudFormation, is recommended.
• Candidates may be expected to understand, tune and write stored procedures during interviews with the application management team and some leadership teams. So, this knowledge is recommended to crack the next level interview rounds