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.
We invest in the lives of our employees, both in and out of the workplace, by providing competitive pay and benefits packages. Benefits offered may include health care, dental, vision, life insurance; 401(k); education assistance; paid time off including PTO, holidays, and any other paid leave required by law. The salary offered will depend on several factors including, but not limited to, relevant experience, skills, education, geographic location, internal equity, business needs, and other factors permitted by law. Posted pay ranges are a general guideline only and are not a guarantee of compensation or salary.
