PostgreSQL Database Engineer (Senior)

 THE OVERALL PURPOSE OF POSITION:  

• The purpose of this position is to perform and manage tasks related to the operation, support, administration,  

• optimization, and maintenance of USAC owned databases and database tools.  

SCOPE OF WORK  

The position’s SCOPE OF WORK include the following:  

• Install, configure, patch, and upgrade database software PostgreSQL  

• Produce detailed technical architecture designs for PostgreSQL solutions.  

• Support of production and non-production PostgreSQL databases   

• Support of production and non-production databases:  

• Correct issues reported in production system  

• Support routine and ad-hoc IT DBA requests  

• Update documentation, if required as part of correcting production issues  
• Implement and monitor daily and nightly database maintenance jobs  

• Monitor, diagnose, and respond to system failure and performance issues, taking appropriate measures to reduce system downtime and eliminate recurrence of the problem  

• Work with USAC technical staff, including network engineers and software developers, to analyze and improve system performance  

• Formulate and implement backup and monthly maintenance procedures for PostgreSQL  

• Production clusters  

• Serve as technical support for any database related performance or access issue  

• Generate ad-hoc and routine reports and define metrics for database health and performance  

• Administer, maintain, develop and implement policies and procedures for ensuring the security and integrity of company databases.  

• Leading the team in providing technical support for any database-related performance or access issue  

• Perform or affect the performance of all database installations, patches, and planned upgrades.  

• Implement data models and database designs, data access and table maintenance codes.  

• Resolve database performance issues, database capacity issues, replication, and other database issues.  

• Perform database related development as dictated by departmental or project demands.  

• Design and perform data migrations and data transformations as required by application delivery teams or business customers.  

• Develop and maintain documentation, diagrams, and procedures and complies with company’s change management control process.  

• Ensure that all database designs adhere to industry best practices.  

• Work with application delivery teams during database design.  

• Possess substantial knowledge about application and database performance profiles of all databases under their management.  

• Represent the IT department in terms of database expertise in coordination with other departments.  

QUALIFICATION AND EXPERIENCE:                                                                        

• 8 Years experience with PostgreSQL database Administration 

• 3 Years production support experience on (PostgreSQL)                              

• 4 years experience with Puppet deployment tool                                                

• 5 years good understanding of Monitoring Tools such as PEM and TOAD    

• 7 Years expert level of PostgreSQL knowledge and experience with PostgreSQL 9.5Years experience with database characteristics such as table design, relationships, data partition, efficient indexes, storage allocation, Capacity planning, etc.  

• 5 Years high Availability Solutions (Master-Master, Master-Slave) and sharing     

• 7 Years experience in performance tuning and load testing of database                      

• 5 Years knowledge of NoSQL database security concepts                                                

• 3 Years experience in supporting PostgreSQL databases in Cloud (Google, AWS, etc.)  

• 5 Years Linux/Unix platforms and Linux Shell scripting                                                   

• 5 Years display strong ability in troubleshooting complex issues                                      

• 7 years Experience in performance tuning and load testing of database                            

• 5 years Knowledge of database security concepts                                                              

• 3 Years Experience with high availability database and application architectures             

NOTE: In addition, this is the desired experience.  

• EDB PostgreSQL Certification  

• You have experience with NoSQL databases, such as Couchbase, MongoDB etc.  

• Experience with agile software development such as SCRUM and XP  

SPECIAL SKILLS:  

• Analytical and problem-solving skills  

• Developing and/or creating new or more effective ideas, approaches, etc.  

• Developing and executing short-range plans/decisions  

• Excellent interpersonal and communication skills  

• Ability to exercise sound judgment across a broad range of circumstances