Database Administrator

9th Way Insignia; Washington (District of Columbia); On-site; USD 76,000 - 90,000; Full time

Benefits offered by this job

Medical

Dental

Vision

401(k)

Paid holidays

PTO

Telehealth

FSA/HSA

Job summary

9th Way Insignia in Washington, DC is seeking a Database Administrator to sustain and optimize the EDW environment. You will monitor, tune, and secure Oracle databases, implement maintenance plans, and support cloud migrations for BI tools like OBIEE.

Collaboration with developers and data analysts is essential in this role. The position requires a technical degree or equivalent experience, plus data warehousing exposure and the ability to obtain security clearance.

Qualifications

• Bachelor's degree in a technical discipline; an additional 8 years of experience can substitute for the degree.
• 1+ years of experience in Data Warehousing.
• Authorized to work in the U.S. for any employer.
• Ability to obtain and maintain required security clearance.
• Currently cleared for Public Trust at tier 2 moderate level or higher.
• Experience with Oracle GoldenGate replication issues and data sync (preferred).
• Experience with Oracle Enterprise Manager (OEM) and RMAN.
• Experience migrating Oracle DB and BI tools to Cloud environments.
• Experience implementing Oracle DB performance tuning and improvement processes.
• Experience supporting OBIEE applications.

Responsibilities

• Monitor EDW database environment; manage disk space, capacity trends, and performance.
• Support DRR activities and production implementations; manage code in Production; document changes.
• Develop, test, and implement database maintenance plans; apply patches while minimizing disruption.
• Troubleshoot slow-running SQL queries; analyze plans and tuning opportunities.
• Process database access requests; enforce security controls and encryption.
• Perform schema and table refreshes between EDW environments.
• Design and implement database schemas and models for EDW data storage and governance.
• Develop backup and recovery plans; conduct disaster recovery testing.
• Ensure data accuracy, consistency, and integrity in EDW; address data quality issues.
• Serve as primary technical resource for database issues; collaborate with dev teams on production challenges.
• Maintain comprehensive documentation of the database environment and changes.
• Collaborate with developers, data analysts, and project teams to ensure DB services support EDW goals.

Skills

Data Warehousing

Database troubleshooting

Performance tuning

Security compliance

Collaboration

Education

Bachelor's Degree in a technical Discipline

8 years of equivalent experience in lieu of degree

Tools

Oracle Enterprise Manager (OEM)

RMAN

Oracle GoldenGate

Job description

Washington, District of Columbia, United States

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 https://9thwayinsignia.com/.

Project Introduction

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.

Professional Level Information:

The Database Administrator aligns to theEngineer 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.

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.

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.
• 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 (preferred).
• 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

Location

Five days per week onsite at 1800 G St, NW Washington, DC 20006

Salary Range

$75,995 - $89,500 USD

9thWay Insignia’s range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.

Clearance/Background Investigation

Applicants selected will be subject to a security investigation and may need to meet eligibility requirements for access to classified information.

Benefits

• Eligible employees will have access to our comprehensive benefits package which includes Medical, Dental, Vision, Voluntary Life Insurance, 401(k), Basic Life A&D, STD, LTD, PTO, Telehealth, paid holidays, FSA, HSA. Additional resources include our Employee Assistance Program (EAP) and Traveling Assistance.

Legal

We’re an equal employment opportunity employer that empowers our people to fearlessly drive change – no matter their race, color, religion, sex (including pregnancy, childbirth, lactation, or related medical conditions), national origin, age, marital status, sexual orientation, gender identity, disability, veteran status, military or uniformed service member status, genetic information, or any other status protected by applicable federal, state, or local law.