PostgreSQL Database Administrator (DBA)

<div> <div><b>Overview </b></div> <div> </div> <div>TekWissen Group is a workforce management provider throughout India and many other countries in the world. The below client is a global IT solutions and services provider for enterprise and midmarket clients, offering services such as cloud, cybersecurity, application modernization, and unified communications.</div> <div> </div> <div><b>Job Title: PostgreSQL Database Administrator (DBA)</b></div> <div><b>Location: Remote</b><br /> <b>Job Type: Contract</b></div> <div> </div> <div> <div><b>Job Description: </b></div> <ul> <li><b>Primary:</b> PostgreSQL </li> <li><b>Secondary:</b> Oracle & MS SQL Server </li> <li><b>Cloud: </b>AWS (RDS/Aurora PostgreSQL, SQL Server on RDS) </li> </ul> <div><b>Key Responsibilities:</b></div> <div><br /> <b>Database Reliability & Performance </b></div> <ul> <li>Own PostgreSQL availability, performance, and capacity; drive proactive tuning and optimization. </li> <li>Support core operations on Oracle and MS SQL Server (backups, indexing, basic tuning, user/security management). </li> </ul> <div><b>High Availability & DR </b></div> <ul> <li>Design and maintain HA/replication and failover for PostgreSQL (on-prem & AWS). </li> <li>Define and test backup/restore and disaster recovery runbooks (including RDS/Aurora snapshots and PITR). </li> </ul> <div><b>Cloud Operations (AWS) </b></div> <ul> <li>Administer RDS/Aurora PostgreSQL (parameter groups, maintenance windows, read replicas, monitoring). </li> <li>Implement secure access and encryption using VPC, Security Groups, IAM, KMS; optimize cost and scaling. </li> </ul> <div><b>Security & Compliance </b></div> <ul> <li>Enforce least-privilege access, patching cadence, encryption in transit/at rest, and auditing. </li> <li>Align database controls with organizational policies and audit requirements. </li> </ul> <div><b>Automation & Observability </b></div> <ul> <li>Automate routine DBA tasks (Shell/Python/SQL) and establish robust monitoring/alerting. </li> <li>Produce concise health dashboards and executive reports on availability, performance, and growth. </li> </ul> <div><b>Documentation & Incident Response </b></div> <ul> <li>Maintain playbooks for HA/DR, patching, and incident handling; drive RCA and remediation after incidents. </li> </ul> <div><b>Required Competencies </b></div> <ul> <li>PostgreSQL (primary): administration, performance tuning, replication/HA, backup & recovery, PITR. </li> <li>Oracle & MS SQL Server (secondary): operational support (backups, users/roles, indexing, basic performance). </li> <li>AWS Cloud: RDS/Aurora administration, CloudWatch/Performance Insights, IAM/KMS/VPC, snapshots/restore. </li> <li>Scripting & OS: SQL/PLpgSQL, Shell/Python, Linux fundamentals; strong troubleshooting and stakeholder communication.</li> </ul> <div> <div><b>TekWissen Group is an equal opportunity employer supporting workforce diversity.</b></div> </div> </div> </div>