Oracle DBA

This is a fully remote position, open to applicants in District of Columbia, +1 more state.

📋 Description

• Assist in the operations, development, implementation, integration, and maintenance of the client's Oracle Federal Financial EBS on-premises system hosted on AWS.

• Define, support, secure, and manage Oracle databases to ensure optimal performance and availability.

• Implement Oracle patches and upgrades.

• Develop backup and recovery strategies, and execute both scheduled and ad hoc backups.

• Carry out performance tuning and optimization of the Oracle E-Business Suite.

• Ensure data integrity, security, confidentiality, and access controls are maintained.

• Assess and apply quarterly Oracle Critical Patch Updates and security vulnerability patches.

• Communicate with Oracle regarding critical incidents, patches, changes, upgrades, and service bulletins.

• Oversee concurrent managers, concurrent programs, request sets, request groups, and workflows.

• Troubleshoot issues related to databases, workflow mailers, notifications, and user-reported problems.

• Manage RMAN backups and Data Guard disaster-recovery replication.

• Utilize PL/SQL packages, Shell, and Perl scripts for task automation.

• Review, develop, recommend, enforce, and adhere to database policies and standards.

• Maintain and revise SOPs for the installation and configuration of Oracle EBS.

• Manage database storage capacity and identify opportunities for software upgrades or replacements.

• Recognize opportunities for innovation and automation.

• Create and maintain technical documentation and designs.

• Collaborate, share information, and deliver high-quality work products on time.

⛳️ Requirements

• Hands-on experience in providing database support for Oracle databases in conjunction with Oracle applications.

• Proficient in a wide range of database technologies.

• Experience in creating and managing standalone Oracle databases.

• Skilled in troubleshooting issues related to Oracle, SQL Server, and/or SQL Cluster, including error triage.

• Experienced in resolving Oracle application-related issues involving database development, support, and management.

• Familiar with analyzing Oracle patches and handling open service requests.

• Proven experience in responding to requests for change (RFCs) for maintenance and enhancements.

• Knowledgeable in performing server maintenance and installing software patches.

• Experienced in conducting impact analysis of Oracle product updates released periodically.

• Proficient in establishing and enforcing database security policies, user access controls, and data encryption.

• Skilled in monitoring and optimizing database performance.

• Experienced in planning, implementing, and managing backup and recovery strategies.

• Ability to create and maintain comprehensive database documentation.

• Capable of working independently as well as collaboratively within a team.

• Strong verbal and written communication skills.

• Bachelor's degree in Engineering, Computer Science, or a related field, or equivalent experience.

• 5+ years of relevant experience.

🏝️ Benefits

• Employees have the option to work remotely.

• Opportunities for technical and professional growth.

• A collaborative work environment.