Oracle DBA Manager

About the role

The Oracle DBA Manager is the organization’s most senior hands-on Oracle database resource and primary Oracle DBA, responsible for daily administration, support, reliability, performance, security, backup/recovery, and lifecycle management of Oracle databases and Oracle E-Business Suite (EBS). This is a hands-on senior technical role first, with supervisory responsibility for the Oracle DBA team and oversight of outside consultants. The role works alongside and collaborates with the Applications, Infrastructure, Security, and Networking teams within IT, and is responsible for disaster recovery planning, Oracle database and EBS upgrades, testing and installation of new software, security and recovery programs, and backup processes to prevent data loss.

The Oracle DBA Manager supports Oracle Data Guard, cloning, Incorta, Oracle Cloud initiatives, other Oracle-based or database-backed business systems, and other systems as needed. The role assesses company needs regarding data storage and access, creates and maintains database systems to meet those needs, oversees database uptime, diagnoses and repairs database issues, remediates vendor service requests, and leads work related to capacity planning, installation, configuration, design, monitoring, general database health and maintenance, performance tuning, and data integration and migration.

As leader of the Oracle DBA team, the position provides day-to-day technical direction, mentoring, work prioritization, and appropriate separation/split of duties while remaining the primary escalation point and most senior hands-on practitioner.

Responsibilities

• Supervise direct and indirect employees and outside consultants. Mentor and train direct reports as well as other IT team members.
• Evaluate systems and data requirements. Meet with analysts, developers, and other personnel to determine specific database needs. Translate those requirements and needs into the database systems.
• Assist the Enterprise Application team in the design, implementation, and performance tuning of Oracle applications and other systems as needed.
• Maintain a working knowledge of the Oracle eBusiness Suite technology stack.
• Ensure proper configuration of underlying OS environments in relation to database health.
• Collaborate with the Enterprise Applications team to drive innovation on new and enhanced system functionality for Enterprise Business Suite Applications.
• Ensure system availability of the Oracle E-Business Suite, Laboratory Information Management Systems (LIMS), ETQ Reliance, Incorta, and other databases.
• Lead disaster recovery planning, including database and application performance monitoring and tuning, security, backups, and failover, including data recovery.
• Provide hands-on support, leadership, and direction as the primary Oracle Database Administrator.
• Develop database architectures, standards, and quality assurance policies and procedures.
• Ensure the security of key corporate data.
• Develop backup, failover, and recovery procedures and guidelines compliant with NOW Health Group, Inc. security principles. Ensure all Oracle and related systems have proper backup procedures and monitor these procedures for appropriate execution and completion.
• Assist the Enterprise Applications Development team with the implementation, testing, and support of new system integrations, applications, and reports.
• Manage all instances of the Oracle databases and applications, including Production, test, development, DR, Patch, Sandbox, including implementation, reorganization, backup and recovery, and cloning processes.
• Conduct research and make recommendations on database products, patches, services, protocols, and standards to improve the reliability and usability of the entire Oracle database and application server environment.
• Administer Oracle EBS (Enterprise Business Suite) and Oracle Support for Service Requests.
• Apply patches/fixes as needed into the DEVELOPMENT instance, request functional users test in the TEST instance, and after certification, apply to the PRODUCTION instance servers.
• Provide both functional and technical advice on related Oracle database issues to users, peers, and senior management.
• Apply security knowledge and expertise to Oracle systems for day-to-day support and identify opportunities to enhance overall security.
• Monitor database performance and efficiency, troubleshoot database issues as they arise, and perform preventative maintenance.
• Provide capacity planning and performance tuning using various methods and tools.
• Collaborate with the Quality Department to maintain validation status for validated systems and support the ECC (engineering change control) process.
• Support data extraction and loading processes for analytic and BI systems.
• Manage Oracle Cloud systems operation and support on SaaS, IaaS, and PaaS platforms. Interface, oversee, manage, and audit service providers to ensure reliable cloud database and application systems.
• Comply with safety and GMP requirements.

Skills

• Strong analytical, problem-solving, and organizational skills.
• Detail-oriented and logical with the ability to understand technical architecture and programming, project scheduling, time management, and leadership.
• Strong verbal and written communication, as well as technical skills.
• Ability to resolve critical issues independently.
• Communication, teamwork, and mentoring skills.
• Ability to work under tight deadlines and pressure.
• Assess data storage and access needs for near-term and future growth.
• Create and maintain databases.
• Upgrade database systems and software as needed.
• Develop emergency data storage and retrieval plans.
• Collaborate with Applications and Server Infrastructure teams to help manage applications and data backup operations.
• Highly proficient in SQL, PL/SQL, and SQL Loader.
• Database systems: Oracle 11G/12C/19c/26ai, MySQL, Incorta, Microsoft SQL Server.
• Oracle E-Business Suite Applications: 12.2.x.
• Knowledge of database theory, design, and query languages (SQL, PL/SQL).
• Knowledge of MCP server/client configurations and integrations.
• Knowledge of RAG database models.
• Operating systems: Strong working knowledge and proficiency of AIX and Linux operating systems; knowledge of Microsoft Windows Server is a plus.
• Project management capabilities: project scheduling, time management, project risk remediation, and techniques to oversee database development and operations.

Qualifications

• Bachelor's degree (B.S.) in Computer Science or related field from a four-year college or university.
• Six years of minimum experience with Oracle’s suite of products.
• General working knowledge of various Relational Database systems, including installation and maintenance.
• Experience with Unix AIX, Linux, and Windows environments.
• Expertise in Data Warehousing, Oracle Parallel Server, and Web-based implementation.
• Experience with backup/recovery requirements in Oracle products, as well as performance tuning and database design.
• Oracle Certified DBA/ADBA is a plus.
• Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists.
• Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form.

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• The employee regularly sits at a stationary desk and uses a computer.
• The employee is occasionally required to stand and walk.
• The employee must occasionally lift and/or move up to 25 pounds.
• Specific vision abilities required include close vision, color vision, depth perception, and ability to adjust focus.

Schedule

Non-standard hours and/or extended work hours can be expected due to user/project requirements and/or deadlines, system or user issues, as well as workload backlog.