Database Administrator - SQL Server & PostgreSQL

Key Responsibilities :

• Install, configure, administer, and maintain SQL Server and PostgreSQL databases.
• Monitor database performance and implement tuning and optimization strategies.
• Design and manage PostgreSQL High Availability (HA) environments.
• Configure and maintain Streaming Replication, Failover, and Clustering solutions.
• Deploy and manage CloudNativePG (CNPG) clusters in cloud-native environments.
• Perform database backup, recovery, disaster recovery planning, and maintenance activities.
• Troubleshoot database issues and ensure high availability and reliability.
• Implement database security, user management, and access controls.
• Collaborate with application, infrastructure, and DevOps teams to support database requirements.
• Automate routine database administration tasks and maintain technical documentation.

Required Skills &

• Experience:
• 6-10 years of experience in Database Administration (DBA).
• Strong hands-on experience with Microsoft SQL Server DBA.
• Strong hands-on experience with PostgreSQL DBA.

Expertise in :

• PostgreSQL High Availability (HA)

2.

Streaming

Replication

3.

Failover

Configuration

• PostgreSQL Clustering
• CloudNativePG (CNPG)
• Experience with database performance tuning, monitoring, backup, and recovery.
• Strong knowledge of SQL, database architecture, and database security best practices.

Preferred Skills :

• Experience with Kubernetes and containerized database deployments.
• Familiarity with Linux system administration.
• Experience with cloud platforms such as AWS, Azure, or GCP.
• Knowledge of automation and scripting using Bash, PowerShell, or Python.
• Experience with monitoring tools such as Prometheus, Grafana, or similar.

Key Competencies :

• SQL Server Administration
• PostgreSQL Administration
• High Availability &
• Disaster Recovery
• Streaming Replication &
• Failover
• CloudNativePG (CNPG)
• Database Performance Tuning
• Backup &
• Recovery
• Problem-Solving &
• Cross-functional Collaboration