Senior Database Administrator

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. The team provides technical services required to sustain EDW applications, including 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. 9th Way Insignia is looking for a Senior Database Administrator to join our team. The Senior Database Administrator aligns to the Engineer 3 professional level within 9th Way Insignia's career families. Five days per week onsite at 1800 G St, NW Washington, DC 20006.

Responsibilities

Monitor Oracle, OBIEE and Informatica servers; Use tools like AppDynamics and Oracle Enterprise Manager to monitor application and storage performance, availability, and usage; Troubleshoot and resolve CPU performance issues and system resource bottlenecks; Implement Oracle database performance tuning and improvement processes, including AWR analysis, SQL tuning, partitioning, and parallel execution; Monitor nightly Informatica processes; Execute daily backup and recovery strategies using tools such as RMAN; Upgrade, patch, and configure OBIEE and Informatica servers; Configure and maintain OBIEE security (object-level and data-level access) to enforce least privilege; Act as a strong OBIEE administrator, collaborating with developers to optimize dashboards, queries, and metadata models (RPD); Collaborate with OBIEE/Informatica/Tableau/Power BI developers to develop performance improvement strategies and plans for execution; Manage object partitioning and parallel executions; Develop database compression strategies and storage efficiency; Coordinate patching and version upgrades with the VA's Office of Information Technology; Prepare, deliver, and maintain reports and technical documentation, including root cause analysis (RCA) write-ups; Other responsibilities as assigned

Requirements

Bachelor's degree in computer science, Electronic Engineering, or other Engineering technical discipline (8 years of additional relevant experience may be substituted for degree); 2+ years of relevant experience; Must be authorized to work for any employer in the U.S; Must be able to obtain and maintain the required security clearance

Nice to have

Currently cleared for Public Trust at tier 2 moderate level or higher; Experience with troubleshooting Oracle GoldenGate replication issues and support data sync between source and target environments; Experience in Oracle Enterprise Manager (OEM) and Recovery Manager (RMAN); Experience migrating Oracle database and BI tools from on premise to Cloud Environment; Experience implementing Oracle database performance tuning and improvement processes; Experience supporting OBIEE applications

Benefits

Medical; Dental; Vision; Voluntary Life Insurance; 401(k); Basic Life A&D; STD; LTD; PTO; Telehealth; paid holidays; FSA; HSA; Employee Assistance Program (EAP); Traveling Assistance