Sr SQL Server & PostgreSQL DBA Professional

Job Summary

Senior SQL Server PostgreSQL DBA with 5+ years of hands-on experience in Database Administration and SQL Development. Strong expertise in SQL Server DBA activities supporting mission-critical production environments. Hands-on experience with PostgreSQL administration, performance tuning, and troubleshooting. Proficiency in writing and optimizing complex SQL queries, stored procedures, functions, views, and triggers. Experience with query tuning, execution plan analysis, indexing, database optimization, and performance troubleshooting. Experience with database migration, schema conversion, data migration, and modernization projects. Hands-on experience with AWS RDS and Aurora PostgreSQL. Strong understanding of backup and recovery, high availability, disaster recovery, and database security best practices. Experience with scripting and automation using Python, Bash, or similar technologies. Familiarity with database deployment tools, version control, and CI/CD processes. If you think you are a good fit and willing to work from Remote, India location.

Experience

• 5 to 8 Years

Responsibilities

• Administer and support SQL Server and PostgreSQL databases across development, testing, and production environments.
• Perform database installation, configuration, upgrades, patching, backup, recovery, and disaster recovery planning.
• Design, develop, and maintain complex SQL queries, stored procedures, functions, views, triggers, and other database objects.
• Analyze and optimize query performance through execution plan analysis, indexing strategies, partitioning, and database tuning techniques.
• Troubleshoot database performance issues, blocking, deadlocks, replication failures, and production incidents.
• Implement and maintain high availability and disaster recovery solutions such as Always On Availability Groups, replication, clustering, and PostgreSQL replication.
• Support database migration, modernization, and cloud adoption initiatives, including SQL Server to PostgreSQL migrations and on-premise to cloud transitions.
• Administer cloud database platforms including AWS RDS and Aurora PostgreSQL.
• Develop database deployment, automation, and maintenance scripts using SQL, Python, or Bash.
• Collaborate with development and DevOps teams to support CI/CD pipelines, database releases, schema changes, and application performance improvements.
• Monitor database health, capacity, availability, and security while ensuring adherence to operational and compliance standards.

Required Skills Experience

• 5+ years of hands-on experience in Database Administration and SQL Development.
• Strong expertise in SQL Server DBA activities supporting mission-critical production environments.
• Hands-on experience with PostgreSQL administration, performance tuning, and troubleshooting.
• Proficiency in writing and optimizing complex SQL queries, stored procedures, functions, views, and triggers.
• Experience with query tuning, execution plan analysis, indexing, database optimization, and performance troubleshooting.
• Experience with database migration, schema conversion, data migration, and modernization projects.
• Hands-on experience with AWS RDS and Aurora PostgreSQL.
• Strong understanding of backup and recovery, high availability, disaster recovery, and database security best practices.
• Experience with scripting and automation using Python, Bash, or similar technologies.
• Familiarity with database deployment tools, version control, and CI/CD processes.

Preferred Skills

• Exposure to Flyway, Liquibase, Alembic, or similar database migration tools.
• Experience working in multi-cloud environments (AWS, Azure, GCP).
• Knowledge of database monitoring, observability, and capacity planning tools.

Professional Expectations

• Strong ownership and accountability for critical production databases.
• Excellent analytical, troubleshooting, and problem-solving skills.
• Ability to manage multiple priorities in a fast-paced environment.
• Strong communication and collaboration skills with cross-functional teams.
• Commitment to database reliability, performance, security, and continuous improvement.

Disclaimer: This job posting and Location has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.