Database administrator
Share
Job Location:
Englewood Cliffs, NJ - USA
Monthly Salary:
Not Disclosed
Posted on:
2 hours ago
Vacancies:
1 Vacancy
Job Summary
Ideal Candidate Summary (One-Glance) of what the client is looking for
Strong MYSQL >60%
Postgres Sql> 40%
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
MongoDB-only profiles
Vendor-dependent DBAs
Weak MySQL fundamentals
Job roles and responsibilities are based on my experience.
- 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.
