Aliqan Services
Database Administrator - SQL Server & PostgreSQL
- Compensation
- Not disclosed
- Location
- Bangalore
- Work setup
- Not specified
- Seniority
- Not specified
- Employment
- Not specified
- Experience
- 6+ years
- Category
- Devops
- Posted
Skills
Full description
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)
- Streaming Replication
- 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