Specialization: PostgreSQL & Microsoft SQL Server Employment Details
• Position: Database Administrator (DBA)
•

Experience:
3–5 Years
• Employment Type: Full-time
• Work Mode: On-site
•

Location:
Gurugram, Haryana
• Joining: Immediate joiners or candidates available within 15–30 days preferred.

About the Role
We are looking for a skilled and experienced Database Administrator (DBA) with strong hands-on expertise in PostgreSQL and Microsoft SQL Server to manage, maintain, optimize, and secure our production database environments. The candidate will be responsible for ensuring database performance, availability, reliability, scalability, and security across multiple applications and business-critical systems. This is a hands-on technical role requiring someone who can independently troubleshoot database issues, perform regular performance tuning, optimize queries, manage backups, resolve operational failures, and ensure databases remain stable and efficient. The ideal candidate should have strong troubleshooting capabilities and be comfortable managing both routine database administration and critical production-level issues.

Key Responsibilities
1. Database Administration & Management
• Manage, configure, maintain, and administer PostgreSQL and Microsoft SQL Server databases.
• Monitor database health, availability, resource utilization, and overall system performance.
• Perform regular database maintenance, upgrades, patching, and configuration management.
• Manage database schemas, tables, indexes, constraints, stored procedures, functions, and views.
• Handle database migrations, schema modifications, and deployment-related database changes.
• Ensure database environments remain secure, reliable, and accessible to authorized applications and users. 2. Database Performance Tuning & Optimization
• Conduct regular database performance analysis and optimization.
• Identify and resolve slow-running queries, inefficient execution plans, locking issues, and database bottlenecks.
• Perform query optimization, indexing strategies, partitioning, and execution-plan analysis.
• Monitor CPU, memory, disk I/O, connection utilization, and database resource consumption.
• Optimize database configurations and parameters to improve performance.
• Maintain and optimize materialized views, caching mechanisms, and indexing structures where applicable.
• Proactively identify performance degradation and implement corrective measures. 3. Production Support & Troubleshooting
• Act as the first point of contact for database-related technical issues across applications and development teams.
• Diagnose and resolve database failures, connection issues, deadlocks, transaction failures, and performance bottlenecks.
• Troubleshoot PostgreSQL and MS SQL Server errors, service interruptions, and unexpected database behaviour.
• Investigate root causes of recurring database issues and implement permanent corrective measures.
• Provide database-level technical support to development, backend, and infrastructure teams.
• Handle critical production issues and coordinate resolution with relevant technical teams. 4.



Backup, Recovery & Disaster Management
• Design, execute, and maintain scheduled database backup procedures.
• Implement and manage full, differential, incremental, and transaction-log backup strategies as applicable.
• Regularly validate backup integrity and perform restoration testing.
• Manage database replication and recovery mechanisms.
• Establish and maintain disaster recovery procedures and recovery plans.
• Participate in periodic disaster recovery drills and ensure data recoverability.
• Monitor backup failures and resolve issues proactively. 5. Database Security & Access Management
• Implement role-based access control (RBAC), user permissions, and database authentication policies.
• Ensure appropriate access restrictions and least-privilege database access.
• Monitor database audit logs, access activities, and suspicious database operations.
• Implement encryption mechanisms and secure database configurations.
• Identify and resolve database security misconfigurations and vulnerabilities.
• Support database security audits and compliance requirements. 6. High Availability & Scalability
• Configure and maintain database replication, read replicas, and high-availability mechanisms.
• Monitor database storage capacity and resource utilization.
• Support connection pooling, load distribution, and database scaling.
• Identify potential capacity constraints before they impact production systems.
• Ensure database environments can support increasing application workloads and data volumes.
• Support infrastructure and database scaling activities in coordination with the technical team. 7. On-Premise Infrastructure & Database Operations
• Administer database-hosting environments across Linux and Windows servers.
• Perform routine server maintenance, resource checks, monitoring, and patch management.
• Monitor disk utilization, storage growth, memory, CPU, and I/O performance.
• Coordinate database infrastructure requirements with system and infrastructure administrators.
• Maintain operational stability of production database servers. 8. Monitoring, Documentation & Development Support
• Configure and maintain database monitoring dashboards using Prometheus, Grafana, or equivalent tools.
• Monitor database alerts, logs, connections, replication status, and resource utilization.
• Maintain database documentation, configuration records, SOPs, and operational runbooks.
• Execute approved database schema changes, migrations, and configuration updates through established change-management procedures.
• Coordinate with developers to review database queries, schema designs, and database-related implementation issues. Required Skills & Qualifications




• 3–5 years of hands-on experience as a Database Administrator, Database Engineer, or in a closely related role.
• Strong practical expertise in PostgreSQL and Microsoft SQL Server.
• Excellent SQL programming and query troubleshooting skills.
• Strong understanding of database architecture, indexing, query optimization, execution plans, and transaction management.
• Experience in PostgreSQL administration, including VACUUM, ANALYZE, WAL, replication, and backup/recovery mechanisms.
• Experience with MS SQL Server administration, including SSMS, T-SQL, SQL Server Agent, backup/restore, and performance tuning.
• Knowledge of database replication, high availability, disaster recovery, and recovery procedures.
• Experience troubleshooting deadlocks, blocking sessions, connection issues, and database performance bottlenecks.
• Basic to intermediate Linux and Windows Server administration skills.
• Understanding of database security, authentication, authorization, encryption, and audit logging.
• Familiarity with database monitoring tools such as Grafana, Prometheus, or equivalent.
• Basic scripting and automation skills using Python, Bash, or PowerShell.
• Strong analytical, problem-solving, troubleshooting, and communication skills.
• Ability to independently handle database-related incidents and work with development and infrastructure teams. Preferred CertificationsCandidates with relevant professional certifications will be preferred:
• Microsoft Certified: Azure Database Administrator Associate.
• Microsoft Certified: Azure Data Fundamentals or equivalent Microsoft SQL Server certifications.
• PostgreSQL professional or associate-level certifications.
• EDB PostgreSQL certifications.
• Red Hat Certified System Administrator (RHCSA).
• Relevant database administration or cloud database certifications. Good to Have
• Experience managing large-scale production databases with millions of records.
• Experience with high-volume transactional systems and data-intensive applications.
• Exposure to multi-application database environments and enterprise-level database infrastructure.
• Experience implementing database monitoring and automated maintenance scripts.
• Practical experience in database migrations, version upgrades, and production deployments.
• Knowledge of cloud database services and hybrid database infrastructure.
• A portfolio of database optimization projects, automation scripts, technical case studies, or documented troubleshooting implementations. What We ExpectWe are looking for a technically strong DBA who can take ownership of day-to-day database operations and ensure that production databases remain optimized, secure, reliable, and available. The candidate should be capable of identifying database performance issues proactively, troubleshooting complex technical problems, implementing optimization measures, and resolving database-related incidents with minimal supervision. Solid hands-on expertise in PostgreSQL and MS SQL Server, practical problem-solving ability, and experience managing live production databases will be given significant consideration.

📌 Database Administrator (Gurugram)
🏢 Tesselonix Private
📍 Gurugram