Database Engineer

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.

ESSENTIAL DUTIES:

• 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:
o Correct issues reported in production system
o Support routine and ad-hoc IT DBA requests
o Update documentation, if required as part of correcting production issues
o Implement and monitor daily and nightly database maintenance jobs
o Monitor, diagnose, and respond to system failure and performance issues, taking appropriate measures to reduce system downtime and eliminate recurrence of the problem
o Work with USAC technical staff, including network engineers and software developers, to analyze and improve system performance
o Formulate and implement backup and monthly maintenance procedures for PostgreSQL Production clusters o 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

TECHNICAL EXPERIENCE:

• Experience with PostgreSQL database Administration 8+ Years
• Production support experience on (PostgreSQL) 8+ Years
• Experience with Puppet deployment tool 3+ Years
• Good understanding of Monitoring Tools such as PEM and TOAD 4+ Years
• Expert level of PostgreSQL knowledge and experience with PostgreSQL 9.5 5+ Years
• Experience with database characteristics such as table design, relationships, data partition, efficient indexes, storage allocation, Capacity planning, etc. 7+ Years
• High Availability Solutions (Master-Master, Master-Slave) and sharing 5+ Years
• Experience in performance tuning and load testing of database 7+ Years
• Knowledge of NoSQL database security concepts 5+ Years
• Experience in supporting PostgreSQL databases in Cloud (Google, AWS, etc.) 3+ Years
• Linux/Unix platforms and Linux Shell scripting 5+ Years
• Display strong ability in troubleshooting complex issues 5+ Years
• Experience in performance tuning and load testing of database 7+ Years
• Knowledge of database security concepts 5+Years
• Experience with high availability database and application architectures 3+ Years

DESIRED EXPERENCE:

• 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 circumstance