Job Description
Posting Title: Oracle Database Administrator (Remote)
Location: Washington, DC (Remote)
Duration: Long Term Contract
Seeking Oracle Database Administrator- Senior – Data Management to support the Client Office of the Chief Financial Officer (OCFO), Office of Corporate Information Systems to provide Operations and Maintenance (O&M) Support Services of their Corporate Business Systems (CBSOM). As the Database Administrator – Perform systems database administration support services for Client applications. This support will be for all environments including but not limited to Development, Sandbox, Test, Performance, Training, and Production.
In this role, a typical day will include:
- Perform database administration support services for Oracle Portal, Client Procurement System (Unison PRISM) and core databases supporting client applications.
- Ability to design, setup and advice on all aspects of oracle Single sign on (SSO), Oracle OID, Oracle OAM.
- Perform Oracle Fusion Middleware product installs, patching, upgrade, troubleshooting and maintenance.
- Recommending and implementing database security policies.
- Recommending and implementing database backup, recovery, redundancy strategies and support disaster recovery related operations as needed.
- Implementing automated monitoring to ensure proactive handing of issues
- In collaboration with CBS and the OCIO Perform random database health checks and prepare a quality assurance and performance review that includes business requirements, testing, upgrades, architecture storage modifications, and adjustments.
- Provide break/fix support to include activities necessary to identify and resolve production defects and implement systems stabilization changes
- Recognizing areas for improvement in the systems and team
- Continuously monitor the databases for storage space, availability, and performance bottlenecks.
- working independently to perform database performance analysis, capacity planning, system sizing and ongoing maintenance.
- Maintain system documentation, including baseline configurations, installation, upgrades, security, and event logs.
- Work with system owners and CBS security staff to provide input for annual Authorization & Accreditations (A&A) and ATO.
- Establish and maintain SOPs to assure database security, integrity, and accuracy.
- Provide support to internal and external data calls.
- Review and provide feedback to system owners on the quarterly Critical Patch Updates (CPU) that come from Oracle. Coordinate with system owners and OCIO on the testing and implementation of these patches across all environments.
WHAT YOU’LL NEED:
- Bachelor's degree in Computer Science, Software Engineering, or relevant discipline from an accredited institution with 8 years relevant experience in Oracle Federal Financials and Unison Prism. Without a degree 9-10 years of relevant experience is required. Two thirds of the experience need to be as a database administrator supporting Oracle OID, OAM, SSO, with managing Oracle Portal and Prism implementations being preferred.
- Strong understanding of Oracle database, related utilities, and tools.
- Strong knowledge and experience in performance tuning and monitoring.
- Good knowledge about load balancers, storage, and cloud environments.
- Working knowledge of Windows Servers and IIS server.
- Strong knowledge of Oracle backup and recovery scenarios.
- Good understanding of Oracle security management.
- Good understanding of Oracle data integrity.
- Experience in code migration, database change management and data management through the various stages of the development life cycle.
Preferred qualifications (optional)
- Experience with ServiceNow for incident management, problem management, and service request management.