19 Sep
|
Programmers.io
|
Pune
19 Sep
Programmers.io
Pune
Job Description
Role Overview
n
We are seeking an experienced Senior SQL Server & PostgreSQL DBA to manage, support, optimize, and enhance enterprise database environments across on-premises and cloud platforms. The ideal candidate will possess robust expertise in database administration, SQL development, performance tuning, migration, and production support.
n
This role requires hands-on experience with SQL Server, PostgreSQL, and cloud-managed database services, along with the ability to collaborate effectively with application development, infrastructure, and DevOps teams.
n
Required Skills & Experience
n
n
- 5+ years of hands-on experience in Database Administration and SQL Development.
n
- Strong expertise in SQL Server DBA activities supporting mission-critical production environments.
n
- Hands-on experience with PostgreSQL administration, performance tuning, and troubleshooting.
n
- Proficiency in writing and optimizing complex SQL queries, stored procedures, functions, views, and triggers.
n
- Experience with query tuning, execution plan analysis, indexing, database optimization, and performance troubleshooting.
n
- Experience with database migration, schema conversion, data migration, and modernization projects.
n
- Hands-on experience with AWS RDS and Aurora PostgreSQL.
n
- Strong understanding of backup and recovery, high availability, disaster recovery, and database security best practices.
n
- Experience with scripting and automation using Python, Bash, or similar technologies.
n
- Familiarity with database deployment tools, version control, and CI/CD processes.
n
n
Preferred Skills
n
n
- Exposure to Flyway, Liquibase, Alembic, or similar database migration tools.
n
- Experience working in multi-cloud environments (AWS, Azure, GCP).
n
- Knowledge of database monitoring, observability, and capacity planning tools.
n
📌 Senior SQL Server & PostgreSQL DBA (Pune)
🏢 Programmers.io
📍 Pune