Job description

Marathon TS is seeking an experienced Application DBA/ Sr PL SQL Developer 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 Marathon TS is committed to the development of a creative, diverse and inclusive work environment. In order to provide equal employment and advancement opportunities to all individuals, employment decisions at Marathon TS will be based on merit, qualifications, and abilities. Marathon TS does not discriminate against any person because of race, color, creed, religion, sex, national origin, disability, age or any other characteristic protected by law (referred to as "protected status ").

Requirements

Must-haves

Marathon TS is seeking an experienced Application DBA/ Sr PL SQL Developer to support our work with the DEA's Diversion Division.
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.
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.

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.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlagileaws

Platform: jobdiva
Effort: medium

Benefits

Benefits detected in the listing.

Vision