MySQL and PostgreSQL DBA

Staffworxs • Englewood Cliff, NJ

7h • Hybrid

About The Position

At Staffworxs, we don't just connect talent — we power transformation. Headquartered in Frisco, TX, with teams in Bengaluru and Hyderabad, we combine global reach with deep expertise. Our Digital & Data Analytics practice drives growth and innovation for some of the world's top brands, who continue to retain us as their trusted partner. If you're ready to make an impact, you're in the right place.

Requirements

• Strong MySQL fundamentals
• Open-source DBA experience
• Production troubleshooting under pressure
• ACID, normalization, transactions mastery
• Good with Shell Scripting or Python.
• Good with linux administration

Nice To Haves

• AWS (EC2, RDS) knowledge
• Automation exposure (Ansible, CloudFormation)
• Experience in HAProxy, Keepalived configuration and management
• Strong replication knowledge and the ability to perform on-demand database refreshes from production to non-production
• Scripting knowledge, including strong shell scripting, knowledge of Ansible, and AWS CloudFormation
• Understand, tune and write stored procedures

Responsibilities

• Install, configure, upgrade, and maintain MySQL, Redis, PostgreSQL and MongoDB databases in both on-premise and AWS environments.
• Manage Replication solutions for each Database based on application requirement for proper HighAvailability.
• Administer and Optimize AWS Managed database services (RDS, AURORA, ElastiCache, DynamoDB, S3, EC2).
• Automate routine tasks and infrastructure setup using tools like Ansible and AWS CloudFormation.
• Design and implement comprehensive monitoring and alerting systems (CloudWatch , PMM, Datadog, MonYog) to proactively identify performance bottlenecks and apply necessary optimizations or fixes.
• Perform daily maintenance, health checks, and capacity planning to ensure database reliability across all environments.
• Collaborate with application developers to design efficient schemas, optimize complex queries, and enhance database performance.
• Work closely with DevSecOps to ensure timely application of security patches and upgrades.
• Develop and manage robust backup and disaster recovery strategies ensuring minimal data loss and downtime.
• Generate ad-hoc reports and provide insights as requested by internal teams or stakeholders.

Benefits

• Staffworxs is an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive workplace for all employees, regardless of race, color, religion, gender, sexual orientation, national origin, age, disability, or veteran status.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed