Database Administrator

9th Way Insignia•Columbia, WA

31d•Onsite

About The Position

9th Way Insignia is seeking a Database Administrator to join their team, supporting the Office of Performance Analysis and Integrity. This role involves managing and enhancing the Veterans Benefits Administration (VBA) Enterprise Data Warehouse (EDW), which is built on an Oracle M8 Supercluster database and thirteen application servers. The team provides technical services for EDW applications, including Project Management, Data Warehouse Management, Advanced Analytics, Tableau Server Administration, Technical Collaboration Support, and Cloud Migration. They also focus on the management, enhancement, integration, implementation, maintenance, modernization, and infrastructure support for EDW applications, as well as enhancing and maintaining business intelligence capabilities and predictive analytics.

Requirements

Bachelors Degree in a technical Discipline, an additional 8 years of experience considered in lieu of degree.
1+ years; experience in Data Warehousing.
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 Haves

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

Responsibilities

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.
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.
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.
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 responsiveness, efficiency, and reliability.
Process database access requests in accordance with approved security procedures, including granting proxy access, creating database roles, assigning users to roles, and granting required table/object privileges to those roles.
Implement and maintain database security controls, including appropriate access controls, encryption, and auditing mechanisms, to protect sensitive data and support compliance with VA and federal data protection requirements.
Perform schema refreshes and table refreshes between EDW environments, including coordinating refresh requirements, validating source and target objects, executing the refresh, resolving errors, and confirming successful completion.
Design and implement database schemas and models that support the efficient storage, retrieval, and analysis of data within the EDW.
Ensure database designs align with project data governance and architectural standards.
Develop, maintain, and execute comprehensive database backup and recovery plans to safeguard data against loss or corruption.
Conduct disaster recovery testing to validate backup strategies and ensure data can be restored within required recovery objectives.
Support the accuracy, consistency, and integrity of data within the EDW through appropriate database-level validation and integrity controls.
Collaborate with data stewards, developers, and project teams to identify and address data quality issues.
Serve as a primary technical resource for database-related issues, providing expert troubleshooting and working with development teams to resolve database challenges associated with application design, implementation, and production operations.
Maintain comprehensive documentation of the database environment, including configurations, operational procedures, maintenance activities, security controls, and change management activities.
Generate and communicate database health, performance, capacity, and optimization information as required.
Collaborate with developers, data analysts, project managers, and other project team members to ensure database services effectively support EDW project goals.
Communicate database requirements, technical issues, risks, and recommendations effectively to both technical and non-technical stakeholders.