Senior Engineer, Technology I (Database Administrator - Redshift)
__jobinformationwidget.freetext.LocationText__
North Chicago, IL
- Corporate
- Full-time
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.
Work collaboratively with technology and business groups to conceive, design, engineer, and implement data, software, and technology solutions that solve significant scientific or business problems. Design and implement MPP database solutions that drive productivity and efficiency gains in own function and throughout multiple business areas. Contribute to advancement of AWS Redshift database software. Develop productive collaborations and communications with other groups across multiple disciplines.
Responsibilities:
- Conceive, design, engineer, and implement data, software, or technology solutions by studying information needs; conferring with users; studying systems flow, data usage, and work processes; investigating problem areas; routinely demonstrate initiative and creativity in developing technology solutions.
- Serve as technical expert or lead projects/programs and technical staff to develop, test, and implement significant new products, or operational improvements or devise new approaches to problems at the division/business unit.
- Analyzes and resolves technical problems using analytical problem-solving methods/techniques and associated tools/devices.
- Contribute to advancement of the company by studying state-of-the-art tools, techniques, and computing equipment; participate in educational opportunities and professional organizations.
- Demonstrate high proficiency across a wide range of technologies and platforms related to software design and development, programming languages, data integration, data warehousing, data analysis and visualization tools, data storage, network connectivity, and virtualization/cloud environments.
- Work in a highly autonomous and productive environment, requiring only minimal direction from or interaction with supervisor. Accountable for successful and timely completion of all tasks/projects under direct and matrix control.
- Initiate new areas of investigation that are meaningful, reliable, and can be incorporated directly into a scientific or business activity.
- Provides technical leadership and mentor less experienced staff in planning, methods, procedures, standards, and best practices. Demonstrate team player skills.
- Understand and adhere to corporate standards regarding applicable Corporate and Divisional Policies, including code of conduct, safety, GxP compliance, data security, and the software development lifecycle.
- Be responsible for the team technology documentation stand
Required
- Bachelor’s Degree with 6+ years Master's Degree with 5 years’ experience; PhD with 2 years’ experience
- Massively Parallel Processing (MPP) Platform Database Administration experience.
- Experience with Implementation, Installation, Database Administration, Performance Tuning, Troubleshooting, Backup & Recovery and Testing of Redshift.
- Possess thorough theoretical and practical understanding of MPP.
- Proven implementation of creative technology solutions that advanced the business.
- Experience writing technical Documents and Instructions.
- Ability to work effectively with clients, ensuring satisfaction and fostering long-term partnerships.
- Data Security permissions, access controls, and encryption measures to protect sensitive data
- Experience with Redshift features such as Workload Manager, Columnar databases, ETL Tools, etc.
- Strong UNIX/Python coding/scripting skills
- Basic AWS architecture knowledge
- Experience migrating databases from old to new versions, On Prem to Cloud, Cloud to On Prem, and Cloud to Cloud
- Clear interpersonal communication, proofreading, editing, and formatting skills
- Knowledge of the systems development life cycle
- Excellent Written and oral communication, analytical and consultative skills with management, clients, and peers
- High-quality decision-making and analytical skills with less than perfect information
- Ability to periodically work nights or weekends (On-Call)
- Coordinate and transfer knowledge to MSP for operational work
Beneficial:
- Experience in Health Care / Regulated Environment is a plus
- Proficiency in other MPP database management systems (DBMS
Tools:
- ServiceNow CMDB
- Python, Ansible, Shell scripting
- Cloud and Redshift monitoring tools
- Elevated Microsoft Office skills – PowerPoint, Teams, Word, Excel
- Query editor / SQL Workbench
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.
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 any bonus, commission, incentive, benefits, or any other form of compensation and benefits that are allocable to a particular employee remains in the Company's sole and 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, serving our community and embracing diversity and inclusion. It is AbbVie’s policy to employ qualified persons of the greatest ability without discrimination against any employee or applicant for employment because of race, color, religion, national origin, age, sex (including pregnancy), physical or mental disability, medical condition, genetic information, gender identity or expression, sexual orientation, marital status, status as a protected veteran, or any other legally protected group status.
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
- No