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:
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 locationand 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 Companys soleand absolute discretion unless and until paid and may be modified at the Companys 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 & Puerto Rico applicants seeking a reasonable accommodation click here to learn more:
No
Employment Type :
Full-time
AbbVie is a global biopharmaceutical company focused on creating medicines and solutions that put impact first for patients, communities, and our world. We aim to address complex health issues and enhance people's lives through our core therapeutic areas: immunology, oncology, neuro ... View more