Marathon TS is seeking an experienced Application Production DBA to support our work with the DEA's Diversion Division.
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.
#cjjobs
