Administrator III – Oracle DBA

Responsibilities:

• Provides system support for operating environment components such as databases, operating systems, network interfaces, storage systems, servers, and associated hardware.
• Verifies and approves plans for upgrading databases, recommends adding new structures or elements, and enables the use of data access tools and techniques to facilitate information access by business users.
• Verifies and approves plans for scheduled background logs and recovery backups, and coordinates with all stakeholders and users to deploy the same.
• Brings improvements in procedures and functions for accessing, maintaining, and populating databases; creating backups; managing access controls; and handling version upgrades.
• Acts as a senior Systems Administrator for enterprise applications by addressing system problems and enhancing system functionality based on stakeholder feedback.
• Provides expertise and day-to-day end-user support for CRM applications to all levels of the organization.
• Evaluates improvement recommendations and prioritizes changes/enhancements for improved system availability, reliability, and performance.
• Recommends and deploys structural changes to the operating environment in collaboration with infrastructure, information security, and vendor teams.
• Releases public area documentation and manages key information such as build and release procedures, dependencies, and notification lists.
• Works with application, system vendors, infrastructure, and IT solutions teams to assess operating environment requirements and ensure proper documentation.
• Assists in defining operating environment requirements, test cases, and action plans to ensure readiness for new installations or migrations.
• Participates in Change Advisory Board (CAB) meetings once a week as an acting member of the CAB.
• Creates and refines reports, dashboards, and processes to continuously monitor data quality and integrity, and assists users and stakeholders with analytics, report design, and management.
• Develops training materials and documentation, keeps materials up to date, coordinates new user and ongoing training sessions, and conducts trainings.
• Partners with stakeholdersincluding HR, Payroll, Finance, Audit, Benefits, Legal, associates, and vendorsto determine strategic needs, define functional/technical specifications, troubleshoot issues, and implement initiatives.
• Utilizes complex reporting tools to develop, document, and monitor cross-process data integration points in future-state business process designs; facilitates resolution of misalignment across process areas.

Work Experience:

• Over 8 years of hands-on experience in Oracle Database installation, configuration, maintenance, upgrades, and patching, ensuring optimal performance and reliability across enterprise environments.
• Proven expertise in Disaster Recovery and High Availability solutions, including Oracle Real Application Clusters (RAC) and Oracle Data Guard, delivering robust business continuity and minimal downtime.
• Experience in shell scripting and automation. Strong written and verbal communication skills.
• Install, configure, and upgrade Oracle software and products.
• Apply patches and updates to maintain database security.
• Perform database backups and recovery operations.
• Monitor database performance and capacity for optimal scalability.
• Conduct performance analysis, tuning, and troubleshooting.
• Proactively address performance or availability issues from alerts.
• Document configuration, maintenance, and troubleshooting processes.
• Support weekend on-call rotation (every 810 weeks) and out-of-hours projects.

Education:

• Bachelor's degree in computer science, Information Technology or any other related discipline or equivalent related experience.

Preferred Certifications:

• Oracle DBA Certification.

Skills and Knowledge

Behavioral Skills:

• Critical Thinking
• Detail Oriented
• Impact and Influencing
• Interpersonal Communication
• Multitasking
• Problem Solving
• Time Management

Technical Skills:

• Identity & Access Management
• Database Administration
• IT Support like Software & Hardware Installation, Troubleshooting
• Software Validation
• Systems Integration
• IT Regulatory Compliance like SOX Compliance

Tools Knowledge:

• Software Configuration Management Tools like Ansible, Puppet
• Citrix technologies like XenDesktop, XenApp, XenServer
• Operating Systems & Servers like Windows, Linux, Citrix, IBM, Oracle, SQL
• Enterprise Resource Planning (ERP) Systems like Sage, ASW, SAP
• Software like Case Management System, HR Information Systems, Kronos(Timekeeping Software), PHS Health and Safety Management System
• Java Frameworks like JDBC, Spring, ORM Solutions, JPA, JEE, JMS, Gradle, Object Oriented Design
• Microsoft Office Suite
• Relational Database Management System (RDBMS) Software
• Customer Relationship Management (CRM) Systems like Salesforce Marketing Cloud, Sales Cloud
• Internet Protocols like DNS, HTTP, LDAP, SMTP, Easy DNS, No IP