PostgreSQL DBA Consultant - remote - W2 only

Overview

Remote
Depends on Experience
Contract - W2
Contract - 12 Month(s)
No Travel Required

Skills

Postgre
PostgreSQL

Job Details

Role: PostgreSQL DBA Consultant

Location: remote

Duration: 1 year open-ended Contract to hire

W2 only

Looking for a Database Administrator DBA contractor to help manage the PostgreSQL environment.

Responsibilities:

Strong proficiency in PostgreSQL database administration and management.

You will be required to develop SQL Queries as required by Business Divisions

Develop Stored Procedures

Load Balancing and High Availability

Ensure System Optimization by improving and restructuring the databases.

Perform database Updates and Migrations

Synchronize multiple Database s in various branches.

Thorough understanding of database design performance tuning and optimization techniques.

Generate Comprehensive Documentation

Support database issues arising from Customer Queries

Proficient in troubleshooting solving complex performance problems.

Proficient in PostgreSQL Database Patching Upgrades Migrations.

Proficient in monitoring performance analysis

Experience working with or in an automated operation environment.

Experience managing operations on core cloud-based infra environments.

Investigate and troubleshoot database-related issues including connectivity problems performance degradation and data inconsistencies.

Provide timely resolution and root cause analysis for incidents.

Willingness for 24/7 shift support and on call support

Key skills:

Significant background in creating complex stored procedures and SQL scripts in PostgreSQL.

Understanding of database normalization concepts

A minimum of 7 years database administration experience

Proven SQL and PostgreSQL experience

Experience in designing and automating repetitive processes.

Good Hands-on scripting language

Excellent problem-solving and analytical skills

Effective communication and collaboration abilities.

Experience working with or in an automated operations environment e.g. Ansible

Thanks

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.