MySQL and Postgres Database Administration

Crisil; Mumbai; On-site; INR 600,000 - 1,000,000; Full time

Job summary

A renowned financial services company in Mumbai is seeking a Mid-Senior level Database Administrator specialized in MySQL and Postgres. The role involves installing, configuring, securing, and maintaining databases, as well as performance tuning and troubleshooting. Ideal candidates will have over a year of DBA experience, strong analytical skills, and proficiency in Linux and scripting languages. Full-time employment with opportunities for growth in a dynamic IT environment.

Qualifications

• 1+ years of experience as a DBA with expertise in both MySQL and Postgres.
• Strong knowledge of database design, installation, configuration and performance tuning.
• Experience with Linux operating systems and scripting languages (e.g., Bash, Python).

Responsibilities

• Install, configure, and maintain MySQL and Postgres databases on Linux/RDS/GCP.
• Monitor database performance and optimize configuration and queries.
• Troubleshoot and resolve database-related issues including errors and performance problems.

Skills

MySQL

Postgres

Database Administration

Performance Tuning

Troubleshooting

Linux

Scripting (Bash, Python)

Cloud databases (AWS RDS, Google Cloud SQL)

Containerization (Docker)

Orchestration (Kubernetes)

Tools

Nagios

Prometheus

Grafana

Job description

MySQL and Postgres Database Administration

Join to apply for the MySQL and Postgres Database Administration role at Crisil

Key Responsibilities

• Database Administration: Install, configure, and maintain MySQL and Postgres databases on Linux/RDS/GCP platforms. Manage database security, including user authentication, access control, and encryption. Perform regular database backups and ensure data recovery procedures are in place.
• Performance Tuning: Monitor database performance and identify areas for improvement. Optimize database configuration, indexing, and queries for better performance. Analyze and troubleshoot database issues using tools like EXPLAIN, slow query log, and database monitoring tools.
• Troubleshooting and Support: Troubleshoot and resolve database-related issues, including errors, crashes, and performance problems. Provide technical support to developers and other teams, including query optimization and database design guidance.
• Capacity Planning and Scaling: Monitor database growth and plan for capacity upgrades and scaling. Implement database replication, sharding, or other scaling techniques as needed.

Requirements

• Technical Skills: 1+ years of experience as a DBA, with expertise in both MySQL and Postgres. Strong knowledge of database design, installation, configuration and performance tuning principles. Experience with Linux operating systems and scripting languages (e.g., Bash, Python). Familiarity with database monitoring and management tools (e.g., Nagios, Prometheus, Grafana) would be added advantages.
• Soft Skills: Excellent problem-solving and analytical skills. Strong communication and collaboration skills, with ability to work with technical and non-technical teams. Ability to work in a fast-paced environment, with multiple priorities and deadlines.
• Additional Technical Skills: Experience with cloud-based databases (e.g., AWS RDS, Google Cloud SQL). Familiarity with containerization (e.g., Docker) and orchestration (e.g., Kubernetes). Knowledge of programming languages (e.g., Java, Python, Ruby).

Seniority Level

Mid-Senior level

Employment type

Full-time

Job function

Information Technology

Industries

IT Services and IT Consulting

Referrals increase your chances of interviewing at Crisil by 2x