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 Postgre
  
  SQL solutions.

• Support of production and non-production Postgre
  
  SQL 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 Postgre
  
  SQL database Administration

• 3+ Years production support experience on (Postgre
  
  SQL)

• 4+ years experience with Puppet deployment tool

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

• 7 Years expert level of Postgre
  
  SQL knowledge and experience with Postgre
  
  SQL 9.5
  
  Years 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 No
  
  SQL database security concepts

• 3+ Years experience in supporting Postgre
  
  SQL 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 Postgre
  
  SQL Certification

• You have experience with No
  
  SQL databases, such as Couchbase, Mongo
  
  DB 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