Oracle Application Database Administrator
Commercial Programming Systems, Inc. (CPS) is an Information Technology consulting and staffing company offering a broad range of services to help our clients deliver high-quality, cost-effective systems. Job Title: Oracle Application Database Administrator Full time employment, Direct hire and Remote work Opportunity: The desired candidate will work as an Oracle Application DBA part of an Oracle E-Business Suite (EBS) R12 integrated project team supporting a high-profile Department of War (DoW) multi-Agency program. As an experienced professional in clients's growing Digital and Network Solutions line of business, the candidate will be part of a team where complex problem solving, and communication skills are critical to success. This work environment provides an unparalleled opportunity to grow and advance, while changing the way the government delivers software applications. The candidate will support management and maintenance of multiple Oracle RDBMS instances part of an Oracle E-Business Suite (EBS) R12 shared-service solution. This includes readiness and flexibility to add additional instances based on capacity planning and emerging new government requirements. The selected candidate will ensure production uptime service levels are maintained and made available per requirements that include backup, recovery, refresh, performance tuning, and security. Responsibilities: Plan and respond to service outages including backups and restores Monitor system performance and diagnose software and hardware failures to resolution Provide patch management and distribution capabilities to prevent new threats with minimized physical infrastructure impacts Create and test data backups Provide data cleansing services, verify data integrity, and implement access controls Perform database configuration, monitoring, and tuning Provide routine maintenance including problem defect analysis and resolution, space, storage, object management, physical database layout, rollback segment management, and temporary space management Support logs and alerts, access rights and roles, database instance version control, new IDs, roles, authorizations, audits, locked/unlocked status, and revocation Perform memory usage monitoring, database parameter configuration, database resources, I/O distribution Ensure system health, maintenance, technical security, recovery, and basic application technical tuning Maintain Oracle Critical Upgrades and patch management schedules Support testing and fielding efforts as needed Support Systems Sustainment efforts as needed Supports software Development, Migration, and Integration efforts as needed Contribute to work plans for security analysis and recommendations. Required skills: Bachelorβs degree or equivalent, with five years of related work experience that includes large-scale Oracle ERP support Experience using WebLogic for Oracle EBS R12.2 web tier and Oracle OEM12c to manage and monitor environments Experience with OCI, including migration support Must have experience of installation and support of Oracle RAC, SuperCluster, R12.2 and 12c database Experience implementing or migrating to Cloud Service Provider (CSP) environments Experience upgrading Oracle databases Should have working knowledge of Maintaining DoD security Standards and Rules, including those related to the databases (e.g., Oracle CPU patching, access management, direct grant, db links, etc.) Should have experience of security monitoring, managing, and testing, such as IAVA's, patches, STIGs etc. Must have experience of designing and implementing single sign-on architecture of various supporting application such as SOA, OBIEE using available tools including but not limited to OAM/OID DoD 8570 IAT Level II certification (i.e., OCA WebLogic 11g SA, OCI Foundations 2020, Security+ CE) Must be a U.S. Citizen and able to obtain an IT-I background investigation. Nice to have skills: Prior Oracle EBS Federal Financial Management experience supporting Federal or DoD customers Commercial Programming Systems, Inc. (CPS) is an Equal Employment Opportunity Employer. CPS does not permit or condone any form of discrimination or harassment based on race, color, religion, national origin, gender, disability, protected veteran status, sexual orientation, or gender identity by the Company's managers, associates, or vendors.