PostgreSQL DBA

Job Description:

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.