Top Prior—PostgreSQL – DBA — Plano, TX—–

Hi,

PostgreSQL DBA –

Plano, TX (5 Days onsite) 

Description:

Job Role: PostgreSQL DBA Technical Requirements: 

• PostgreSQL database Administration, in-depth hands-on experience is a must.

 • Good experience PostgreSQL DBA activities. 

• Strong experience in PostgreSQL Performance Tuning and Optimization 

• Hands on experience backup strategy and high availability in production databases 

• Skilled at optimizing large, complicated SQL statements in PostgreSQL. 

• Strong experience in performance tuning on SQL queries. 

• Experience in table partitions 

• Strong experience in JOINS and Subqueries

 • Skilled at optimizing large, complicated SQL statements and stored procedures, functions

. • Strong with common database procedures such as upgrade, patch, recovery, migration, High Availability 

• Ensure performance, security, and availability of databases. 

• Need to have strong experience in PostgreSQL HIGH Availability Solutions.

 • Design and develop PostgreSQL systems including statements, data modelling, tables, views, and indexes.

 • Knowledge of best practices when dealing with relational databases PostgreSQL. 

• Setting up the configuration parameters in PostgreSQL Database. 

Qualifications:

 • 8+ years of experience in PostgreSQL Administration

 • Extensive experience in PostgreSQL SQL and PLSQL (PG/PLSQL) Coding. 

• Experience in conversion of ETL mappings from Oracle to Postgres. 

• Good analytical and problem-solving skills for design, creation and testing of programs.

 • Good communication skills to interact with team members, support personnel, and provide technical guidance and expertise to customers and management. 

• Good interpersonal skills to interact with customers and team members.

 • Ability to work in a self-directed work environment. 

• Ability to work in a team environment.