Overview
Nonin Overview: You can count on Nonin. Our vision is to improve people’s lives by creating noninvasive medical devices people can count on, even in challenging conditions. Nonin’s culture is grounded in our mission and vision, and our values are reflected in our commitment to diversity, equity, and inclusion. Diversity, Equity, and Inclusion are more than words to us, they are our DNA. We aspire to advance our medical technology for the global diverse patients, customers and communities we serve. We embrace the unique backgrounds, perspectives and mindsets of our employees, and seek to enhance these qualities through our hiring and talent management strategies. Our employees are empowered to bring their full authentic selves to work and collaborate to build a more rewarding environment for all to work and thrive. With a career at Nonin, you can expect to work in an environment where diversity is celebrated and curiosity is rewarded. By joining Nonin, you will improve lives around the world, including your own.
Job Overview: The Database Administrator designs, develops, tests and maintains Extract, Transform, and Load (ETL) processes. The Database Administrator also documents, develops, and manages the creation of logical and physical data models. Additionally, technical expertise is applied to the design, development, and support of processing data of multiple databases and data formats involving both internal and external sources and targets. Highly tuned and efficient code, high levels of data quality and delivery excellence, effective and proactive verbal and written communication, excellence in customer service and partnerships, and teamwork are key success factors for this senior role.
Responsibilities
What you will do:
- Understand and apply database administration, management, and performance tuning techniques specific to SQL Server and Azure technologies
- Design, develop, test, and production support maintenance of data management and integration processes serving a highly visible, enterprise level customer base
- Apply initiation and leadership skills with analysts, business owners, and end users to define and document business, technical, financial, and operational support requirements
- Translate business requirements into technical solutions, dealing well with ambiguity, and concluding how deliverables meet business goals. Perform data analysis and data modelling to create source to target mapping documents Perform data profiling as one means to output proof of high levels of data quality
- Create, publish, distribute, and present design documents and other documentation, including logical or physical data models, end-to-end data integration diagrams, and Service Level Expectation documents
- Develop effective error handling, perform unit testing, and gain stakeholder acceptance as key implementation and production support readiness criteria
- Effectively balances and prioritizes workloads among project work development, support maintenance and operations (including on-call rotation), innovation and creativity, and initiative in a proactive, continuous improvement environment
- Completes complex work assignments independently, takes initiative to flush out gaps in requirements or hopeful business outcomes, documents and confirms key understandings, and produces products with extremely low production support footprints
- Performs consistently as a team player who shares knowledge, maintains effective working relationships, and puts yourself in service to others—maintaining extremely high customer service levels
- Contributes to the development of team process and technical standards, including the creation of reusable code base, highly efficient job scheduling and batch performance, service management excellence, and financial improvements
- As a continuous improvement environment, always seeks to learn, test, and incorporate new methods at any phase of the delivery and service management lifecycle
- Consult with Business and Project Leads to identify current operating procedures and to clarify program objectives
- Participate in evaluations of new software applications and upgrades
Qualifications
Education & Experience:
- Bachelor’s degree in a related area and at least 5 years of experience in the field or in a related area
- 3 years of strong database administration experience working with each of the following tools/technologies: Microsoft SQL Server, SSIS, Visual Studio, Power BI, SSRS, Windows Operating Systems, Azure, and PowerShell
- 3 years of experience with each of the following: (a) managing and database performance tuning, (b) performing SQL Server replication, mirroring, and partitioning, (c) deploying Power BI, and SSRS reports, (d) implementing Azure databases and, (e) upgrading SQL Server databases and migrating to virtual environments
- 3 years of experience with relational databases, database structures and design, systems design, data management, data warehouse
Knowledge, Skills & Abilities:
- Data mart structures and data management tools using SQL Server
- On Premise and Cloud based structures using Azure base servicers and storage structures
- Experience and Knowledge of datasets and view structure commonly used with Power BI
- Excellent analytical, problem solving skills and ability to find creative solutions
- Ability to communicate effectively both orally and in writing
- Ability to plan, organize and perform work with deadlines
- Ability to show initiative, find opportunities for process improvements, and be an independent worker
- ETL and SQL development experience, preferably Data Stage and SSIS or similar tools
- Delivering data quality outcomes, performing, and presenting data profiling results, working with relational databases and a multitude of file formats with medical devices
- Technical expertise to engage customers and recommend and deliver lean, cost-effective solutions
- Experience with logical and physical data modelling
- Experience with data warehouse design and methodologies, including change data capture, star schemas, snowflakes, cubes and dimensional modeling
- Proven ability to conduct root cause analysis and research into systems and data issues
Preferred Knowledge:
- Knowledge of Dynamics AX 2012R3 / Dynamics 365 F&O / Supply Chain
- Knowledge of Dynamics CRM 365 or similar CRM tools
- Experience with database security features within cloud, secrets/password vaulting, data encryption at rest/in transit.
- Intermediate knowledge of coding/scripting languages like PowerShell, Python, etc.
- Experience with infrastructure as Code using Terraform
- Experience deploying DB solutions on Azure and cloud migration tools
Physical Requirements:
- Sit/stand/walk 8 hrs/day
- Primarily remote position with on-site requirements as needed
Benefits:
- 401(k) & 401(k) matching
- Medical, Dental & Vision insurance, including flexible spending and health savings accounts
- Profit sharing
- Disability insurance
- Accident & Critical Illness Insurance
- Employee assistance program
- Life insurance
- Paid time off
- Parental leave
- Bereavement leave
- Employee referral program
- Tuition reimbursement
Nonin is an Equal Opportunity/Affirmative Action employer committed to creating a diverse workforce. We consider all qualified applicants without regard to race, religion, color, sex, national origin, age, sexual orientation, gender identity, disability or veteran status, among other factors.