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 Open Shift platform.
- Experienced in setting up PostgreSQL clusters and supporting databases cluster in on-prem 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 high-scalable 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.
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, Couch base, Elastic search, 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.
MUST HAVES:
- ANSIBLE for Database Configuration Management on Cloud, Automating Tasks and Integration with Cloud Services
- TERRAFORM for Multi-Cloud Provisioning and database dependency management
- Experience in end-to-end process including Database Administration, Orchestration, failover procedures and Deployment