AbbVie logo

Senior Engineer, Technology I

AbbVie
On-site
North Chicago, IL
IT

Role Summary

Senior Engineer, Technology I specializing in Oracle Database Administration (RDBMS). You will design, build, secure, and maintain Oracle data structures, manage backup/recovery, perform capacity planning and performance tuning, and support OEM-based monitoring and automation. You will collaborate with IT clients and internal teams to design and tune applications, and you will operate in a 24/7 environment to ensure high availability.

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.
  • Required: Experience with Database design, building, implementation, administration, performance and tuning, patching, backup and recovery.
  • Required: Experience with data retrieval and data access methods, testing, etc.
  • Required: Experience with Unix shell and PL/SQL scripts
  • Required: Experience with Oracle DBA
  • Required: 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.
  • Preferred: Minimum 7 years of experience as Oracle DBA. MS SQL and/or NoSQL are a plus.
  • Preferred: Knowledge/experience with Application Development and the systems development life cycle a plus.
  • Preferred: Experience establishing guidelines, procedures and standards for database administration, writing technical documentation is a plus.