5 days ago
MySQL and Postgres Database Administration
Crisil
On Site
Full Time
₹800,000
Mumbai, Maharashtra, India
Job Overview
Job TitleMySQL and Postgres Database Administration
Job TypeFull Time
CategoryCommerce
Experience5 Years
DegreeMaster
Offered Salary₹800,000
LocationMumbai, Maharashtra, India
Who's the hiring manager?
Sign up to PitchMeAI to discover the hiring manager's details for this job. We will also write them an intro email for you.
Job Description
Overview
We are seeking an experienced Database Administrator (DBA) to join our team at Crisil, responsible for the administration, maintenance, and optimization of our MySQL and Postgres databases. The candidate should have a strong background in database design, development, and performance tuning, with expertise in both MySQL and Postgres administration.
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).
Key skills/competency
- MySQL
- Postgres
- Database Administration
- Performance Tuning
- Linux
- Cloud Databases (AWS/GCP)
- Scripting (Bash/Python)
- Database Monitoring
- Troubleshooting
- Capacity Planning
How to Get Hired at Crisil
- Research Crisil's culture: Study their mission, values, recent news, and employee testimonials on LinkedIn and Glassdoor.
- Tailor your resume: Customize your resume to highlight MySQL, Postgres, Linux, and cloud database administration experience, using keywords from the job description.
- Showcase problem-solving: Prepare examples of how you've optimized database performance and resolved complex issues in previous roles.
- Demonstrate technical depth: Be ready to discuss your experience with AWS RDS, Google Cloud SQL, Docker, Kubernetes, and scripting during technical interviews.
- Highlight collaboration: Emphasize your communication skills and ability to work effectively with diverse technical and non-technical teams.
Frequently Asked Questions
Find answers to common questions about this job opportunity
01What specific database platforms does Crisil primarily use for this MySQL and Postgres Database Administration role?
02What level of experience is Crisil looking for in a Database Administrator?
03Are there opportunities for cloud database exposure in this Database Administration role at Crisil?
04What tools should I be familiar with for monitoring databases at Crisil?
05How important are scripting skills for the Crisil Database Administrator position?
06Does the MySQL and Postgres Database Administration role at Crisil involve database design and development?
07What kind of troubleshooting scenarios might I encounter as a DBA at Crisil?
08Will I be involved in scaling databases in this Crisil role?
09What soft skills does Crisil value for this Database Administrator position?
10Is knowledge of containerization relevant for the Crisil Database Administrator role?
Explore similar opportunities that match your background