Senior Database Administrator

9th Way Insignia•Columbia, WA

23d•Onsite

About The Position

9th Way Insignia is seeking a Senior Database Administrator to support the Veterans Benefits Administration Enterprise Data Warehouse (EDW), managed by the Office of Performance Analysis and Integrity. The EDW runs on an Oracle M8 Supercluster database and thirteen application servers. The team provides technical services to sustain and enhance EDW applications, including database and warehouse management, analytics, Tableau administration, architectural enhancement, cloud migration, and infrastructure support. The role aligns with the Engineer 3 professional level. Engineer 3 work includes planning and directing research or development on complex projects; engaging stakeholders in design and development; overseeing the design, development, implementation, and analysis of technical products and systems; and helping resolve complex technical problems. This position is primarily onsite five days per week at 1800 G St, NW, Washington, DC. It also serves as backup for the nightshift DBA when that person is unavailable; the stated nightshift hours are 11:30 PM to 8:30 AM. The salary range is $115,000–$120,000 USD. Applicants must be able to obtain and maintain the required security clearance.

Requirements

Bachelor’s degree in computer science, electronic engineering, or another engineering technical discipline; eight years of additional relevant experience may substitute 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.

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 on-premises to a cloud environment.
Experience implementing Oracle database performance tuning and improvement processes.
Experience supporting OBIEE applications.

Responsibilities

Serve as the nightshift backup when the nightshift DBA is unavailable.
Monitor Oracle, OBIEE, and Informatica servers using tools such as AppDynamics and Oracle Enterprise Manager to assess application and storage performance, availability, and usage.
Troubleshoot and resolve CPU performance issues and system resource bottlenecks.
Perform Oracle database performance tuning and improvement, 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, with particular emphasis on patching experience.
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 to develop and execute performance improvement strategies.
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.