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
