Database Administrator
Job Description
<div class="content-intro"><p>9th Way Insignia is a service-disabled, veteran-owned small business bringing transformative technology to our government customers so they can achieve their missions. Our specialties include cybersecurity, cloud modernization, software development, data analytics, enterprise architecture, enterprise IT, analytics, process automation, and artificial intelligence. Learn more about 9th Way Insignia at <a href="https://9thwayinsignia.com/">https://9thwayinsignia.com/.</a></p> <p>Application password: Niner</p></div><p><strong><u>Project Introduction </u></strong><br>The Office of Performance Analysis and Integrity manages and enhances the Veterans Benefits Administration (VBA) Enterprise Data Warehouse (EDW) which resides on one Oracle M8 Supercluster database and thirteen application servers. Our team provides the technical services required to sustain EDW applications to include Project Management, Data Warehouse Management, Advanced Analytics, Tableau Server Administration/Tableau Desktop Administration, Technical Collaboration Support, Lessons Learned, Executive Orders and Special Projects, Architectural Enhancement, and Cloud Migration. We also provide management, enhancement, integration, implementation, maintenance, modernization, and infrastructure support for EDW applications and enhancement and maintenance of business intelligence capabilities and predictive analytics. <br><br>9th Way Insignia is looking for a Database Administrator to join our team. </p> <p><strong><u>Professional Level Information:</u></strong><br>The Database Administrator aligns to the Engineer 1. Your duties may include assisting in the design, development, and testing of project components, identifying problems and discovering solutions, working on ongoing projects based on specifications or drawings, and collaborating with teams of other engineers. Typically performs multiple engineering-related tasks in various assignments within the project and firm. An Engineer 1 has strong technical skills and background, a knack for learning new technologies, and a blend of good problem-solving and innovation needed to resolve a wide variety of technical production challenges.</p> <p><strong><u>Responsibilities:</u></strong></p> <ul> <li>Monitor the EDW database environment and proactively manage and clean up disk space to maintain adequate capacity, system stability, and performance. Monitor database health, resource utilization, and capacity trends; conduct capacity planning to anticipate future data growth and system load and recommend appropriate scaling strategies.</li> <li>Support Delivery Readiness Review (DRR) activities and production implementations, including moving approved database code to Production and implementing and troubleshooting Data Definition Language (DDL) scripts using SQL scripting. Ensure database changes are implemented in a controlled manner and properly documented in accordance with established change management procedures.</li> <li>Develop, document, test, and implement database maintenance plans for scheduled and complex maintenance activities, including Oracle database time zone upgrades and related validation and rollback activities. Apply database software updates and patches in a timely and controlled manner, ensuring compatibility with the EDW environment and minimizing disruption to operations.</li> <li>Troubleshoot slow-running SQL queries and database performance issues by analyzing execution plans, resource utilization, database waits, and other performance indicators; implement appropriate tuning and corrective actions. Conduct ongoing performance monitoring and tuning to identify and resolve bottlenecks and maintain database responsive