Senior Database Administrator

9th Way Insignia•Washington, DC

10d•$115,000 - $120,000•Onsite

About The Position

9th Way Insignia is seeking a Senior Database Administrator to support the Veterans Benefits Administration (VBA) Enterprise Data Warehouse (EDW), managed by the Office of Performance Analysis and Integrity. The EDW resides on an Oracle M8 Supercluster database with thirteen application servers. The team sustains and enhances EDW applications and business intelligence and predictive analytics capabilities, providing data warehouse management, technical collaboration, analytics, architectural enhancement, modernization, infrastructure support, and cloud migration services. The role aligns with the Engineer 3 professional level. An Engineer 3 plans and directs research or development work on complex projects, engages stakeholders in design and development, and may assess costs and recommend new components. The role involves overseeing the design, development, implementation, and analysis of technical products and systems; performing multiple engineering-related tasks; and helping resolve complex technical problems. The administrator monitors and tunes Oracle databases and related OBIEE and Informatica systems, administers their security and performance, supports backups and recovery, and coordinates patching and upgrades with the VA’s Office of Information Technology. The position is onsite five days per week at 1800 G St, NW, Washington, DC 20006. When the nightshift DBA is unavailable, the administrator serves as backup for the 11:30 PM to 8:30 AM shift.

Requirements

Bachelor’s degree in computer science, Electronic Engineering, or another engineering technical discipline; eight years of additional relevant experience may be substituted for the degree.
At least two years of relevant experience.
Must be authorized to work for any employer in the United States.
Must be able to obtain and maintain the required security clearance.
Experience with patching OBIEE and Informatica servers is strongly emphasized.

Nice To Haves

Currently cleared for Public Trust at tier 2 moderate level or higher.
Experience troubleshooting Oracle GoldenGate replication issues and supporting data synchronization between source and target environments.
Experience with Oracle Enterprise Manager (OEM) and Recovery Manager (RMAN).
Experience migrating Oracle databases and BI tools from an on-premise environment to a cloud environment.
Experience implementing Oracle database performance tuning and improvement processes.
Experience supporting OBIEE applications.

Responsibilities

Serve as backup for the nightshift DBA when that employee is unavailable; the shift hours are 11:30 PM to 8:30 AM.
Monitor Oracle, OBIEE, and Informatica servers.
Use 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 object-level and data-level security to enforce least privilege.
Administer OBIEE and collaborate with developers to optimize dashboards, queries, and metadata models (RPD).
Collaborate with OBIEE, Informatica, Tableau, and Power BI developers on performance improvement strategies and execution plans.
Manage object partitioning and parallel executions.
Develop database compression strategies and improve 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 write-ups.
Perform other responsibilities as assigned.