Job description

Requirements

  • Entry level
  • No Education
  • Salary $45.67 - $57.69 gross per hour
  • Charleston

Description

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).

Requeriments
- 5+ years of database experience using PostgreSQL


- Adeptness in PL/SQL


- Demonstrated knowledge of Oracle databases


- Familiarity with relational database management systems


- Experience tuning queries to improve performance


- General familiarity with storage and server hardware required


- Experience building and maintaining documentation


- Experience with Linux/Unix environments


- Practical knowledge of disaster recovery


- Strong familiarity with database monitoring


- Command of Database Performance

  • access
  • oracle
  • pl/sql
  • sql
  • storage

About the company

Unrivaled Industry Insight. Sophisticated Matching Technology.
And a Personalized Approach.
It’s Why We’re #1.