Employment
Full Time
Experience
4+ Years
Location
Ahmedabad
Open Positions
3
Job Code
AIPL/CORP/ITINFRA/DBA/2601
Essential Qualification:
- Bachelor’s degree in Computer Science, Information Security, or related field
- Proven experience as a PostgreSQL Database Administrator or similar database management role
- Strong expertise in PostgreSQL installation, configuration, backup, recovery, replication, clustering, and tuning
- Strong hands-on experience in SQL, query optimization, and indexing techniques
- Experience with PostgreSQL high availability solutions including streaming replication, logical replication, and failover mechanisms
- Familiarity with cloud platforms such as AWS, Azure, or GCP for database deployments
- Experience with Docker and Kubernetes for containerized database environments
- Strong scripting knowledge in Bash, Python, or Perl for automation tasks
- Good understanding of database security practices including authentication, encryption, and auditing
- Experience using database monitoring and performance analysis tools
- Excellent analytical, troubleshooting, and problem-solving skills
- PostgreSQL or database-related certifications preferred
Essential Area of Expertise:
- PostgreSQL Database Administration
- Database Installation, Configuration & Maintenance
- Database Performance Tuning & Query Optimization
- SQL Development & Indexing Strategies
- PostgreSQL Replication, Clustering & High Availability
- Backup, Recovery & Disaster Recovery Management
- Database Security & Access Control
- Database Monitoring & Troubleshooting
- Automation & Scripting for Database Operations
- IT Infrastructure & Production Database Support
Desired Area of Expertise:
- Cloud Database Deployment (AWS / Azure / GCP)
- Containerization Technologies (Docker / Kubernetes)
- DevOps Environment & CI/CD Integration
- PostgreSQL Extensions (PostGIS, pg_partman, etc.)
- Database Migration & Upgrade Management
- Performance Monitoring Tools (pg_stat_activity, pgBadger, etc.)
- Multi-Database Environment Exposure (MySQL / Oracle / SQL Server)
- Database Automation Frameworks & Maintenance Tools
- Disaster Recovery Planning & High Availability Architecture
Role and Responsibility
- Install, configure, maintain, and support PostgreSQL database environments ensuring high availability and optimal performance
- Monitor database health, performance, and availability while troubleshooting issues and conducting root-cause analysis
- Manage PostgreSQL clusters, replication setups, failover configurations, and high availability solutions
- Optimize database performance through query tuning, indexing strategies, and configuration enhancements
- Perform database performance assessments and implement best practices for efficient resource utilization
- Develop and manage backup, recovery, and disaster recovery procedures to ensure data integrity and business continuity
- Enforce database security standards including user access management, authentication, encryption, and vulnerability remediation
- Develop automation scripts for database maintenance, monitoring, alerts, and operational efficiency
- Collaborate with development and infrastructure teams to troubleshoot application/database performance issues
- Support database migrations, upgrades, deployments, and new feature implementations
- Maintain detailed documentation for database architecture, configurations, and operational procedures
- Stay updated with PostgreSQL advancements, industry standards, and database best practices to improve overall database operations
Apply as a
