10+ years of experience managing PostgreSQL databases in Linux environments.
In-depth knowledge of PostgreSQL utilities.
Experience with Amazon RDS PostgreSQL migrations and deployments, including versioning and on-premise familiarity.
Proficiency in shell scripting (Linux) and Python for automation.
Requirements:
Install, configure, monitor, troubleshoot, and optimize PostgreSQL databases; design and optimize schemas, tables, indexes, and queries for performance and scalability; implement robust backup and recovery strategies including point-in-time recovery and disaster recovery planning.
Monitor performance, identify bottlenecks, perform routine maintenance, and implement high-availability solutions such as replication to ensure continuous availability.
Implement and enforce database security standards including access control, authentication, and compliance; perform security log reviews for audit readiness.
Collaborate with developers, system administrators, and support teams; create high-quality documentation, provide training and mentoring to other DBAs, and participate in on-call 24/7 incident response.
Job description
PostgreSQL DBA Location: 100% Remote Duration: Long-Term Contract Rate: DOE
US Citizens and Green cards Preferred.
Technical Skills Required:
10 or more years' experience managing PostgreSQL databases in a Linux environment.
In-depth knowledge of Postgres utilities.
Experience managing Amazon RDS implementation, including Postgres migrations and deployments. Familiarity with managing versions and deployment in RDS and on-premise servers.
Experience in implementation of various monitoring tools.
Familiarity managing database, deployment, monitoring, and benchmarking statistics. Manage lifecycle support of database systems by applying patches, upgrades, and routine database.
Job Description/High-Level Task Assignment:
Support an enterprise class environment running PostgreSQL database management systems including installation, configuration, monitoring, troubleshooting, performance tuning, and security. Design and optimize database schemas, tables, indexes, and queries for performance and scalability. Implement robust backup and recovery strategies including regular backups, point-in-time recovery, and disaster recovery planning.
Monitor and manage database performance, identifying and resolving performance bottlenecks, and conducting routine maintenance tasks. Configure and run high availability solutions such as replication and ensure continuous database availability.
Implement database security standard methodologies including access control, authentication, and compliance standards.
Use strong analytical skills and problem-solving skills to diagnose and resolve database-related issues.
Perform database capacity planning and trend analysis. Use scripting and automation tools to perform database administration tasks and streamline operations.
Collaborate with multi-functional teams, including developers, system administrators, and L1/L2 support.
Build high quality documentation including database designs, standard operating procedures, and troubleshooting guides.
Perform security log reviews for audit compliance; detect, report, and escalate anomalies.
Deliver training, mentoring, and coaching to other Database Administrators through free flow of information, encouraging and appropriately evaluating feedback, encouraging innovation, and inspiring / motivating others. Provide on-call rotational 24/7 incident response to database alerts escalated by production monitoring.
