Key skills
SQLNoSQLShellETLOraclePerformance OptimizationCommunication
About this role
Company Description
AbbVie's mission is to discover and deliver innovative medicines and solutions that solve serious health issues today and address the medical challenges of tomorrow. We strive to have a remarkable impact on people's lives across several key therapeutic areas – immunology, oncology, neuroscience, and eye care – and products and services in our Allergan Aesthetics portfolio. For more information about AbbVie, please visit us at www.abbvie.com. Follow @abbvie on X, Facebook, Instagram, YouTube, LinkedIn and Tik Tok.
Job Description
The database administration function provides in-depth technical expertise in Oracle Relational Database Management System (RDBMS), including database architecture, installation, and technical support of RDBMS software. Responsible for designing, building, securing, and maintaining data structures used to store company computerized systems data. Proficient in backup and recovery. Perform database administration activities such as modifications, enhancements, expansions, capacity planning, and lifecycle. Responsible for compliance with applicable company policies and procedures. Deliver advanced technical expertise for the maintenance, support, and performance optimization of Oracle database software. Offer technical assistance to IT clients in the design and tuning of application systems, as well as support for data extraction, transformation, and loading (ETL) processes.
Responsibilities
Responsible for compliance with applicable Corporate and Divisional Policies and procedures.
Review, validate and enhance logical database designs. Define and implement physical databases.
Perform database administration activities (e.g., modifications, enhancements, expansions).
Conducts production database performance monitoring and capacity planning. Install, test and upgrade database releases and associated products.
Diagnoses database-related issues (e.g., database outages, application performance).
Lead the development of database standards and procedures. Evaluate and recommend new database software, utilities, and tools.
Daily interaction with clients on divisional and enterprise wide projects and peer resources in other technical support organizations (e.g. hardware, storage, etc.).
Responsible for administration, security, configuration, and maintenance of Oracle Enterprise Manager (OEM) infrastructure. Focus on company database performance monitoring, automation of routine tasks, and ensuring high availability. Key duties include company Oracle database patching via OEM, incident configuration and management, and utilizing shell scripting to support operations in a 24/7 environment.
Qualifications
Required:
- Bachelor’s Degree with 6 years’ experience; Master’s Degree with 5 years’ experience; PhD with 0 years’ experience.
- Experience with Database design, building, implementation, administration, performance and tuning, patching, backup and recovery.
Experience with data retrieval and data access methods, testing, etc.
Experience with Unix shell and PL/SQL scripts
Experience with Oracle DBA
Excellent analytical, communication and consultative skills and the ability to work efficiently with clients and other IT management and staff.
Excellent analytical, communication and consultative skills and the ability to work efficiently with clients and other IT management and staff.
Preferred:
Bachelor degree in Computer Science (or equivalent experience), Masters preferred.
Minimum 7 years of experience as Oracle DBA. MS SQL and/or NoSQL are a plus.
Knowledge/experience with Application Development and the systems development life cycle a plus.
Experience establishing guidelines, procedures and standards for database administration, writing technical documentation is a plus.
Additional Information
Applicable only to applicants applying to a position in any location with pay disclosure requirements under state or local law:
The compensation range described below is the range of possible base pay compensation that the Company believes in good faith it will pay for this role at the time ofthis posting based on the job grade for this position. Individual compensation paid within this range will depend on many factors including geographic location,and we may ultimately pay more or less than the posted range. This range may be modified in the future.
We offer a comprehensive package of benefits including paid time off (vacation, holidays, sick), medical/dental/vision insurance and 401(k) to eligible employees.
This job is eligible to participate in our short-term incentive programs.
Note: No amount of pay is considered to be wages or compensation until such amount is earned, vested, and determinable. The amount and availability of anybonus, commission, incentive, benefits, or any other form of compensation and benefits that are allocable to a particular employee remains in the Company's soleand absolute discretion unless and until paid and may be modified at the Company’s sole and absolute discretion, consistent with applicable law.
AbbVie is an equal opportunity employer and is committed to operating with integrity, driving innovation, transforming lives and serving our community. Equal Opportunity Employer/Veterans/Disabled.
US & Puerto Rico only - to learn more, visit https://www.abbvie.com/join-us/equal-employment-opportunity-employer.html
US & Puerto Rico applicants seeking a reasonable accommodation, click here to learn more:
https://www.abbvie.com/join-us/reasonable-accommodations.html