PostgreSQL DBAArchitect

Technical Requirements:

• PostgreSQL database Administration, in-depth hands-on experience is a must.
• Good experience PostgreSQL DBA activities.
• 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.