Ref ID: 03270-0011067597
Classification: Database Administration
Compensation: $45.67 to $57.69 per hour
Robert Half Technology is partnering with an expanding company to find a PostgreSQL Database Administrator with a background in complex problem solving. This position would be a great fit for an efficient problem solver with fine-tuned decision-making skills. The PostgreSQL Database Administrator will be located in Charleston, South Carolina and is a long-term temporary-to-full-time opportunity. Your 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 on Linux, Windows, and Cloud platforms. Support for designing, testing, implementing and supporting PostgreSQL database system backups using an enterprise-class backup solutions, 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 tuning as part of remediation or proactive monitoring. DBA support to assist application teams for databases running in PostgreSQL for performance tuning to ensure new, upgraded, or migrated systems/databases run at optimal levels. Perform migrations from non-PostgreSQL platforms such as Oracle and MS SQL Server to PostgreSQL. Perform migrations/refreshes between non-production and production environments. Develop and document database policies, procedures, and standards for PostgreSQL databases. Automate existing PostgreSQL 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 database environments (including CIS benchmarks).