PostgreSQL DBAArchitect

Qualifications
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 Sub Queries
Skilled at optimizing large, complicated SQL statements and stored procedures, functions
Strong with common database procedures such as upgrade, patch, recovery, migration, High
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
10+ 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
Responsibilities
Setting up the configuration parameters in PostgreSQL Database
Job description
Job Title: PostgreSQL DBA/Architect

Plano, TX, 75075

Onsite

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 Sub Queries

• 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:

• 10+ 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.

Thanks & Regards,

Suresh Pudari

Technical Recruiter 

psuresh@futransolutions.com