PostgreSQL DBA - eTeam Inc.
Plano, TX 75024
About the Job
Technical Requirements:
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
- 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.
Source : eTeam Inc.
