PlSql Dba

Job Title: PL/SQL DBA

Location: Remote

Clearance: Tier 3 (T3) Investigation

Job Summary:

Optimized Technical Solutions (OTS) is looking for a PL/SQL Database Administrator (DBA) to support the ERP CS shared services environments and associated Oracle Cloud Infrastructure (OCI) migration efforts. The PL/SQL DBA is responsible for developing maintaining optimizing and troubleshooting Oracle database procedures functions packages and scripts to support database operations application functionality and migration activities. This position works closely with the DBA Lead Mission Partner (MP) DBA team ERP CS technical teams and other stakeholders to ensure database performance integrity and operational readiness throughout the migration and post-migration sustainment phases.

Job Responsibilities/Duties:

• Develop maintain and optimize PL/SQL procedures functions packages triggers and scripts to support ERP CS database environments and application requirements.
• Work with the DBA Lead and ERP CS technical teams to support database migration activities and associated OCI infrastructure requirements.
• Support database migration planning execution validation testing and post-migration stabilization activities.
• Analyze and troubleshoot PL/SQL code SQL queries database performance issues and application-related database errors.
• Support database integration and operational requirements across the MilAUDIT Oracle Enterprise Manager (OEM) and Oracle Single Sign-On (SSO-OAM OIM OUD) environments as applicable.
• Execute Oracle-provided tools and database scripts necessary to support migration configuration and operational activities.
• Collaborate with System Integration Testing (SIT) and User Acceptance Testing (UAT) teams to identify troubleshoot and resolve database-related defects and support retesting efforts.
• Coordinate with Mission Partner teams infrastructure teams and product vendors to resolve technical issues and implement approved corrective actions.
• Monitor and optimize database queries stored procedures and other PL/SQL components to ensure performance reliability and data integrity.
• Develop and maintain technical documentation database scripts standard operating procedures and operational runbooks to support post-migration sustainment.

Contingent Upon Award

Requirements:

• Must be U.S. citizen
• Must hold an active CompTIA Security certification and maintain it throughout employment.
• Experience administering and supporting Oracle databases.
• Experience configuring administering or supporting Oracle Enterprise Manager.
• Working knowledge of OCI and database or monitoring-platform migrations.
• Understanding of SQL database performance tuning backup and recovery and database security.
• Ability to troubleshoot issues and collaborate across technical teams.
• Strong technical documentation and communication skills.

Work Environment

Office environment. Requires ability to provide clear concise accurate and timely communication both verbally and in writing (100%). Requires ability to interact professionally with co-workers management and client (100%). Occasional business travel may be required. Only requested and approved expenses will be covered by OTS.

EEO Statement

OTS is committed to hiring and retaining a diverse workforce. We are proud to be an Equal Opportunity/Affirmative Action-Employer. All qualified applicants will receive consideration for employment without regard to race color religion gender gender identity or expression sexual orientation national origin genetics disability age or protected veteran status. U.S. Citizenship is required for most positions.