Oracle Database Administrator

Database Administrator

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.

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.

Preferred:

• Bachelor degree in Computer Science (or equivalent experience), Masters preferred.
• 7 years of experience as Oracle DBA. MS SQL and/or NoSQL.
• Knowledge/experience with Application Development and the systems development life cycle.
• Experience establishing guidelines, procedures and standards for database administration, writing technical documentation.

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

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

US & Puerto Rico applicants seeking a reasonable accommodation, click here to learn more:

Recruitment Fraud Alert

• AbbVie will never request sensitive personal information (such as bank account details, social security numbers, or payment of any kind) during the recruitment process.
• If you suspect you have received a fraudulent offer or communication claiming to be from AbbVie, please do not respond, open any attachments, or click on any hyperlinks.

If you have any questions or concerns regarding the authenticity of a communication alleged to have been made by or on behalf of AbbVie, please contact us immediately.

Protect yourself by verifying job offers and communications. Your safety is important to us.

1. Yes, 5% of the Time

Pay Range: $96500 - 183500 USD

Where We Work

Role is primarily site- or office-based but can occasionally be performed remotely. Employees who are site/office-based and can occasionally perform their role virtually work both in the office and remotely*, following the policies and regulations in place at their location. US Employees must be in the office on Tuesday, Wednesday, and Thursday with flexibility to work remotely on Mondays and Fridays. Three days in the office is the minimum; some individuals or teams may require more in-office days due to meetings, business/project needs or their role.