Job Title: Database Engineer
Location with zip code: Washington, DC 20002 (Hybrid)
Duration: 12+ months, Contract
Shift Timing (Day/ Evening/ Night): Day
Pay Rate: $60-70/hr on w2
Job Summary:
- 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.
Role & Responsibilities:
- 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
- Update documentation, if required as part of correcting production issues o 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.
Required 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 7+ Years design, relationships, data partition, efficient indexes, storage allocation, Capacity planning, etc.
- 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.
|