Senior Database Engineer I
Abbott
Posted Saturday, September 14, 2024
Posting ID: ABLAUS31096466ENUSEXTERNAL
Saint Paul, MN
Abbott is a global healthcare leader that helps people live more fully at all stages of life. Our portfolio of life-changing technologies spans the spectrum of healthcare, with leading businesses and products in diagnostics, medical devices, nutritionals and branded generic medicines. Our 114,000 colleagues serve people in more than 160 countries.
Title: Senior Database Engineer I
About Abbott
Abbott is a global healthcare leader, creating breakthrough science to improve people's health. We're always looking towards the future, anticipating changes in medical science and technology.
Working at Abbott
At Abbott, you can do work that matters, grow, and learn, care for yourself and family, be your true self and live a full life. You'll also have access to:
This position works out of our location in Maple Grove, MN in Abbott's Medical Device Division supporting R&D IT.
As the Senior Database Engineer I, you'll have the chance to create technical/functional specifications, support new and existing applications and processes to enable development teams to release medical device software and systems more rapidly. You'll work collaboratively with other IT operational and software engineering teams to deploy and operate our systems/platforms and support client utilization. You will also be responsible for automating and streamlining our operations and processes, along with building and maintaining tools for deployment, and monitoring setup for operational use.
What You'll Work On
Title: Senior Database Engineer I
About Abbott
Abbott is a global healthcare leader, creating breakthrough science to improve people's health. We're always looking towards the future, anticipating changes in medical science and technology.
Working at Abbott
At Abbott, you can do work that matters, grow, and learn, care for yourself and family, be your true self and live a full life. You'll also have access to:
- Career development with an international company where you can grow the career you dream of
- Free medical coverage for employees* via the Health Investment Plan (HIP) PPO
- An excellent retirement savings plan with high employer contribution
- Tuition reimbursement, the Freedom 2 Save student debt program and FreeU education benefit - an affordable and convenient path to getting a bachelor's degree.
- A company recognized as a great place to work in dozens of countries around the world and named one of the most admired companies in the world by Fortune.
- A company that is recognized as one of the best big companies to work for as well as a best place to work for diversity, working mothers, female executives, and scientists.
This position works out of our location in Maple Grove, MN in Abbott's Medical Device Division supporting R&D IT.
As the Senior Database Engineer I, you'll have the chance to create technical/functional specifications, support new and existing applications and processes to enable development teams to release medical device software and systems more rapidly. You'll work collaboratively with other IT operational and software engineering teams to deploy and operate our systems/platforms and support client utilization. You will also be responsible for automating and streamlining our operations and processes, along with building and maintaining tools for deployment, and monitoring setup for operational use.
What You'll Work On
- Configuring and maintaining the databases according to the environment strategy
- Engaging in capacity planning exercises to ensure adequate system resources
- Monitoring database size and health
- Creating and managing plans for maintaining statistics and indexes
- Understanding performance metrics, monitoring system performance, and troubleshooting issues
- Managing the logins for different types of access- Role based
- Applying RDMS upgrades and updates to production and non-production environments
- Performing database backups and verifying restores, prepare for audits.
- Maintaining and testing processes related to business continuity
- Installing and maintaining the administrative and monitoring tools necessary for high level of availability and performance of EMR system
- Follow vendor best practices for hardware and software configuration
- Participating in change control process for all planned application and technical activities
- Collaborating with technical teams and EMR vendor to ensure proactive support
- Troubleshooting and resolving ETL process errors
- Installing, updating, maintaining, and troubleshooting Interconnect-based tools
- Modifying the ETL processes to meet organizational reporting needs
- Adding new tables and columns to the data model as needed
- Working with Business Intelligence Developers to provide data needed for reports
- Responding to emergency and after-hours issues
- Collaborate with partner IT staff to improve processes and infrastructure setup. Identify manual processes within the organization and automate them
- Contribute to end-user training as needed and be comfortable providing day-to-day support
- Communicates effectively with management to enhance their understanding of the opportunities and limitations of information systems
- Conform to and enforce planned work priority in the face of continued interruptions
- Complies with U.S. Food and Drug Administration (FDA) regulations, other regulatory requirements, company policies, adheres to operating procedures, processes, and completes task assignments within the assigned sprint
- Develop necessary documentation, testing and change control procedures to satisfy internal product validation and update yearly for audit compliance
- Maintain accurate current state application architecture diagrams, documentation, and other data sources in a consistent and replicable manner
- Develops detailed implementation, test and roll-back procedures for planned changes and follows code promotion model utilizing change request approvals
- Bachelor's degree in a technical discipline or equivalent experience
- Technically proficient in analytical database platforms
- Ability to perform basic troubleshooting on Microsoft SQL Server, Oracle, Windows Server, and IIS
- Understanding of operating system concepts such as user and group ownership and file permissions, file system/volume group configuration, etc.
- Ability to create, understand, and follow processes to ensure successful execution of critical maintenance procedures
- Familiar with automated testing and test-driven development practices
- Excellent communication and customer service skills. Able to bridge communication between technical areas and business areas for a full and complete understanding of expectations
- Must be a self-starter and possess good analytical skills
- Comfortable partnering with engineers to understand and solve problems that will enable you to deliver reliable software faster
- Ability to work in a highly matrixed and geographically diverse business environment
- Ability to travel approximately 3%
- RDBMS certification
- EMR based application and (or) EMR based database administration certification
- 5+ years of technical database administration experience
- 5+ years of experience translating business requirements into technical designs
- At least 3 years' experience working in regulated environments
The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.