Senior Engineer, Technology I

AbbVie • North Chicago, IL

22h

About The Position

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 . 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.

Requirements

• 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.

Nice To Haves

• 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.

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.

Benefits

• 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior