Application DBA

ASRC Federal•Arlington, VA

6d•Hybrid

About The Position

ASRC Federal Agile Management LLC is seeking an experienced Application DBA to support our work with the DEA’s Diversion Division. This role offers a hybrid work arrangement, requiring two days a week onsite in Arlington, VA. The Application DBA will provide full SDLC support, from requirements analysis, development, design, testing, to deployment of custom Oracle applications. This position involves designing, implementing, and maintaining database design and data dictionary within a high-performance, agile, enterprise environment, with the opportunity to coach other application developers.

Requirements

A BS/BA in Engineering, Physics, Computer Science, Information Technology, Mathematics or related discipline is required
5-7 years of experience in the field.
Must be a US Citizen (ability to obtain a Public Trust)
Must be able to successfully pass a DEA background investigation.

Nice To Haves

Experience in Unix shell scripting is a plus.
Experience in AWS Oracle RDS environment is a plus.
Experience in Golden Gate replication is a plus.

Responsibilities

Full SDLC support from requirements analysis, development, design, test, to deployment of custom Oracle applications
Design, implement, and maintain database design and data dictionary
Work in a high-performance, agile, enterprise, with the ability to coach other application developers
Develop scripts in SQL, PL/SQL for data conversion, implementing custom algorithms
Practical, hands-on experience and demonstrable technical competence with development and operational tools
Experience with Oracle Database 19c
In-depth knowledge of Oracle database objects – tables, indexes, directories, sequences, triggers, packages, etc.
Must be able to support Development, Test and Production environments for database Operations and Support and data integrity.
Experience in writing complex SQL queries to provide reports on ad-hoc basis.
Experience in code reviewing for standards and performance before deploying to DEV/TEST/PROD environments.
Must be able to debug Oracle PL/SQL code for production issues.
Must be able to support Development, Test and Production environments for databases and Operations Support.