Job Description :
Responsibilities
DBA support for all PostgreSQL non-production, production, and disaster recovery environments, including new database server installation and configurations, minor/major upgrades, system tests, and implementations.
Database deployments will be on Linux, Windows, and Cloud platforms.
Support for designing, testing, implementing and supporting PostgreSQL database system backups using an enterprise-class backup solution, such as Commvault, including backup validation through database restoration testing. Includes implementing logical and physical backup and recovery, and full or point-in-time recovery from hot, cold, or snapshots.
DBA support for PostgreSQL database monitoring and performance tuning to ensure new and upgraded systems/databases run at optimal levels. Includes performing resource contention analysis and system/statement tuning as part of remediation or proactive monitoring.
DBA support to assist customer application DBAs in PostgreSQL performance tuning to ensure new, upgraded, or migrated systems/databases run at optimal levels.
Perform migrations from non-PostgreSQL platforms such as Oracle, MS SQL Server, or MySQL.
Provide support for MySQL databases to ensure new and upgraded systems/databases run at optimal levels.
Perform migrations between non-production and production environments.
Develop and document database policies, procedures, and standards for PostgreSQL database systems. Follow and enhance existing MySQL database installation, configuration, and management standards and procedures based on industry best practices.
Establish and maintain access controls and security for non-production and production PostgreSQL and MySQL database environments.
Proactively maintain database systems at the latest security patch levels.
Perform routine database maintenance tasks, such as, vacuum, re-indexing, and archiving.
Develop automation procedures and provides proactive intervention to minimize downtime.
Implement database connection pooling and load balancing for large multi-user environments.
Prepare and update project charters and project plans to the division’s Project Server.
Administer and maintain the PostgreSQL and MySQL database installations, including troubleshooting, problem resolution, and on-call after hours and weekend support.
Develop and document PostgreSQL and MySQL database disaster recovery solutions, including configuring and implementing high availability (HA
Performs replication, including log-based and streaming replication, as well as,
failover/failback manually or automated/managed.
Monitor and perform capacity planning for all PostgreSQL and MySQL database installations, short-term and long-term.
Provide technical assistance to County application staff and County departments.
Document all technical work and enhance existing documentation.
Mentor County staff in the installation, configuration, and maintenance of PostgreSQL and MySQL databases, provide knowledge transfer as a regular part of day-to-day duties.

Skills
Three years of experience within the last five (5) years working with PostgreSQL version 9+ hosted on Linux or Windows platforms.
Two years of experience within the last five (5) years as a PostgreSQL database administrator designing and deploying PostgreSQL databases on Cloud platforms such as AWS and Azure.
Three years of experience within the last five (5) years as a senior PostgreSQL database administrator.
Three years of experience within the last five (5) years using programming languages such as: UNIX shell scripting, PL/pgSQL, Python, or Perl.
Three (3) years of experience within the last five (5) years using instrumentation tools such as: pgAdmin, pgAudit, pgBadger, Nagios, OpenNMS, or vScout.
Two years of experience within the last five (5) years using Ansible playbooks or YAML.
Two years of experience within the last five (5) years performing database performance analysis, system and statement SQL tuning.
Two years of experience within the last five (5) years as a senior database administrator supporting major configurations of highly available environments.
Two years of experience within the last five (5) years architecting and implementing PostgreSQL replication solutions using streaming replication including pgPool.
Two years of experience within the last five (5) years using pSQL.
Two years of experience within the last five (5) years migrating non- PostgreSQL databases to PostgreSQL, such as MS SQL Server, Oracle, or MySQL.
One year of experience within the last three (3) years deploying databases in containers such as OpenShift.

If you are interested please share your updated resume with your expected rate per hour.

Looking forward to hear from you,

Thank you