What are the responsibilities and job description for the PostgreSQL DBA position at eTeam?
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 :
