Application DBA

ASRC Federal Agile Management LLC is seeking an experienced Application DBA to support our work with the DEA’s Diversion Division. Location: Hybrid / 2 days a week onsite in Arlington, VA 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. 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. 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) and to successfully pass a DEA background investigation.