Application Production DBA

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.
• 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.
• US Citizenship (ability to obtain a Public Trust) and to successfully pass a DEA background investigation.