Application DBA

ASRC Federal•Arlington, VA

7d•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 involves full Software Development Life Cycle (SDLC) support for custom Oracle applications, including requirements analysis, development, design, testing, and deployment. The position requires designing, implementing, and maintaining database designs and data dictionaries, working in a high-performance, agile enterprise environment, and coaching other application developers. The Application DBA will develop scripts in SQL and PL/SQL for data conversion and custom algorithms, demonstrating practical, hands-on experience with development and operational tools. The role requires supporting Development, Test, and Production environments for database operations, support, and data integrity, writing complex SQL queries for ad-hoc reports, and performing code reviews for standards and performance before deployment. Debugging Oracle PL/SQL code for production issues and supporting databases and operations in all environments are key responsibilities.

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
Experience with Oracle Database 19c
In-depth knowledge of Oracle database objects – tables, indexes, directories, sequences, triggers, packages, etc.
Must be a US Citizen (ability to obtain a Public Trust) and 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
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