Manager, Oracle Database Administration - United States
- Our company is the world leader in delivering therapeutics that provide meaningful advances to patients who live with serious and life-threatening rare genetic diseases.
- We target diseases that lack effective therapies and affect relatively small numbers of patients, many of whom are children.
- These conditions are often inherited, difficult to diagnose, progressively debilitating and have few, if any, treatment options.
- Our company will continue to focus on advancing therapies that are the first or best of their kind.
- Our company’s Technical Operations group is responsible for creating our drugs for use in clinical trials and for scaling production of those drugs for the commercial market. These engineers, technicians, scientists and support staff build and maintain our company’s cutting-edge manufacturing processes and sites, provide quality assurance and quality control to ensure we meet regulatory standards, and procure the needed goods and services to support manufacturing and coordinating the worldwide movement of our drugs to patients. Come join our team and make a meaningful impact on patients’ lives.
- As part of IT Enterprise Architecture team, the candidate is required to work with different functional and Technical groups to provide guidance on current and future state of the Oracle Database/Technology Platform.
- The individual will lead architectural requirements, design and development.
- The candidate should have in-depth knowledge of Oracle Databases, RAC, Oracle Enterprise Manager, Encryption, Redaction, Masking, Cloning, Performance Tuning/Monitoring, Optimize Resource allocation for Databases and Applications, Backup and DR Strategy.
- Manage Outsourced DBA teams supporting Oracle and SQL Server Databases.
- Have in-depth knowledge around Oracle ERP and Client-Server Application Architecture.
- Estimate, Manage and Deliver Projects. Liaise with PMO office provide timely updates.
- Collaborate with functional business leads, IT leads and providing periodic “State of Union” updates of Database Platforms.
- Evaluate new technologies and assess their need for our company.
- Analyze, test, and implements physical database design supporting Oracle EBS versions Release 12.2 including base definition, structure, documentation, long-range requirements, and operational guidelines.
- To be responsible for the setup, patching, debugging, upgrading and installation of Oracle software applications and tool sets as they relate to application users. Documents and maintains consistent and current patches across test development and production environments for each country and application.
- Ensures data recovery, maintenance, data integrity, and space requirements for physical database are met through formulations and monitoring of policies, procedures, and standards relating to database management.
- Audits the current environments, provides capacity planning and best practices for the future production/development/test environments, which may include establishing new standards and procedures.
- Manage Install, upgrade, maintain, monitor, patch and tune Oracle E-Business, Oracle Application server, and related databases.
- Provide support to developers with troubleshooting and performance tuning, including System Global Area (SGA) analysis, latch contention analysis, disk subsystem tuning, and Structured Query Language (SQL) tuning of Oracle and custom views and queries.
- Maintain and develop backup/recovery process for Oracle E-Business Suite installations, using Recovery Manager (RMAN), BCV, or scripts for online and offline backups and disaster recovery.
- Identify and Create monitors and alerts for user sessions, concurrent processes, table extents, and locks for production and test/development systems
- Willing to learn and participate in installing, maintaining, patching and upgrading of SOA/WebLogic Application servers, Oracle Business Intelligence systems and other applications interacting with Oracle Applications.
- Develop strategy to Maintain and Support Oracle Database with a goal to maximize availability and uptime.
- Develop strategy to improve DR preparedness and Plans.
- Maintain and improve best practices and standardize processes across all IT groups.
- Partner with other IT Dedicated Support functions to share knowledge and drive continuous improvement.
- Develop, maintain and communicate an intimate understanding of Business and IT strategies.
- Identify opportunities for operational efficiency through innovation and integration.
- Analyze and evaluate systems for consolidation, optimization or operational efficiency.
- Lead continuous improvement effort assessing current use and intended use of technology and service and Maximize utilization of existing License agreements.
- Develop Cloud Migration Strategy and Plans.
Operational / Tactical:
- Prioritization of work delegated to the team.
- Manage the team and help them to achieve high levels of operational excellence
- Manage technical consultants to design, build, test, and implement new solutions
- Participate on change control boards and design review committees
- Assist teams by providing high level guidance around architectural, design, development efforts
- Work with cross-functional teams and provide solutions
- Identify areas for business/ IT process improvement and efficiencies; make recommendations to improve existing processes or system functionality.
- Coordinate and work with Partners/Vendors/ Consultants/System integrators to implement applications
- Author SOP’s, Configuration Specifications and related technical documentation.
DB Architect and Administration
- DB architect: Design, develop and maintenance of Databases (ERP applications, and non-ERP systems)
QA/ Change Management
- Maintain Documents and Qualification Support: Develop/Maintain SDLC documents, SOPs, User Training Document, GxP documents, IQ evidence
- Change control: Review change control, management of change control execution, documentation.
- Bachelor's degree in Information Systems from four-year college or university or significant relevant experience
- 12+ years’ experience in Managing Oracle Database Platforms, System Architecture, Solution design and delivery.
- Good to have: Biotech/Pharma/Life Sciences experience with IT/QA CSV
- Working technical experience with Oracle Products
- Working knowledge of SDLC documents, SOPs, User Training Documents, GxP documents & collecting IQ/OQ/PQ evidences
- Knowledge and experience of Oracle technologies and tools such as SOA/WebLogic, OBIEE, Workflow Builder, OID, Hyperion, Essbase, Informatica, Argus, Primavera, Golden Gate, OEM, Endeca, Active Data Guard, Data Guard, Encryption , Advanced Security, RAC, Application Management Suite, Partitioning, DB Vault, Audit Vault, DB Firewalls, SSO, IAM, VMWare and DB Virtualization
- Knowledge and experience with Sarbanes/Oxley and Health Insurance Portability and Accountability Act (HIPAA) regulations.
- Knowledge and experience in Shell, Perl and/or PL/SQL programming.