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