Postgres DBA

Skill: Postgres DBA

Location: Onsite (Las Vegas Nevada) from day1 onsite.

Job Requirements

• Must have 8 years DBA working experience with PostgreSQL 9.6 version and good understanding of Oracle Database and Microsoft SQL Server.
• Must be knowledgeable and experienced in managing PostgreSQL on multiple operating systems including Microsoft Windows Linux (RHEL) and Kubernetes in OpenShift platform
• Experienced in setting up PostgreSQL clusters and supporting databases cluster in onprem and hybrid cloud environment and specifically in AWS RDS instance.
• Strong skills in UNIX/Linux Shell Scripting
• Experience in implementing Postgres STIG implementation testing and other vulnerability remediation.
• Working Knowledge of connection poolers (pgPool and pgBouncer).
• Install monitor and maintain PostgreSQL software implement monitoring and alerting.
• Experience in building highscalable clusters failover and hot standby solutions based on Maximum available architecture
• Experience in architecting configuring setting up Enterprise Fail over manager or similar technology for High availability solution.
• Experience in leading efforts related to system and SQL performance tuning and assisting business process integration with various data sources.
• Ability to work well with development and infrastructure teams in doing database design changes and enhancement to new and existing applications
• Proven ability to provide High Availability and Disaster Recovery solutions.
• Maintain operational documentation (e.g. procedures task lists architecture blueprints)
• Strong Troubleshooting Skills
• Ability to maintain a positive attitude while working with high demands and short deadlines that leads to working after hours.
• Must have excellent communications and interpersonal skill

Not Required but Preferred:

• Experience with database replication is a plus.
• Enterprise DB Postgres Database Administration Certification.
• Knowledge of administering NoSQL databases such as MongoDB Couchbase ElasticSearch or HBase
• Experience in data modeling tools such as Oracle Data Modeler Erwin Toad Visio etc.
• Has strong Python programming skill and be able to develop dba applications for system automation and integration.