Overview
Skills
Job Details
Job Title: Database Engineer
Location with zip code: Washington, DC 20002 (Hybrid)
Duration: 12+ months, Contract
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.
About our Company: -
22nd Century Technologies, Inc., is one of the fastest growing IT Service Integrator and Workforce Solution companies in the United States. Founded in 1997, 22nd Century Technologies is a Certified National Minority Business Enterprise with 6,000+ people including 600+ Cyber SMEs nationwide supporting our customers in all 50 states, Canada, and Mexico. With HQs in Somerset, NJ and Mclean, VA, 22nd Century has 14 offices throughout the United States. As part of our unrelenting focus on quality and compliance, 22nd Century Technologies delivery is based on Certified Matured Processes including CMMI L3 Dev & SVC, ISO 20000, ISO 27001, and ISO 9001 quality processes. With a strong focus on the public sector, 22nd Century currently holds government contracts with 14 out of 15 Federal Executive agencies including DoD, 37 other Federal agencies, 50 States, 115+ Local agencies, and 37 School Districts. In the last three years, we have expanded our services to Fortune 500 and other commercial clients and currently support 80+ commercial clients.
Recognized among Best Company to Work For by Forbes, 22nd Century Technologies, Inc., consistently exceeds our clients expectations by focusing on their absolute satisfaction with jobs while keeping our employees motivated. 22nd Century Technologies is an Equal Opportunity Employer" and s & all other parties authorized to work in the US are encouraged to apply."
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.