Job Title: PostgreSQL DBA
Location: Plano, TX (5 Days onsite) C2C
Experience :8+ Years
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.
Best Regards
|
|
From:
chaitanya,
conflux systems
chaitanya.p@confluxsystems.com
Reply to: chaitanya.p@confluxsystems.com