Senior Database Administrator

Job Functions, Duties, Responsibilities and Position Qualifications:

Position Summary

The Senior Database Administrator will be a pivotal role in defining the architecture of our informatics systems.  This role will be responsible for operational data across all verticals, enterprise-wide, flowing through a central pipeline, to facilitate a culture of data-driven insights and decisions. They must have the ability to exercise critical thinking and create efficient data queries and objects using various SQL technologies.  A solid understanding of healthcare, especially laboratory testing and related methodologies is a plus.  The ability to produce and understand operational data sets to satisfy business requirements is essential. Prepares and/or maintains documentation pertaining to programming, systems operation and user documentation. Translates business specifications into user documentation.  Understands and ensures HIPPA requirements are followed when dealing with any PHI.  Contributes to and assists with enterprise data initiatives. Other responsibilities will include providing technical leadership and mentorship to junior staff and providing some leadership in the SCRUM process.  You will also be involved in preparing and maintaining technical documentation pertaining to data systems.

Job Responsibilities

Essential Functions

• Planning and Design:
  • Take a lead role in planning, with a focus on ensuring each developer on the team understands the design & implementation decisions and how to apply them
  • Collaborate with product owners early in the planning process to help guide architectural decisions that will lead to more stability and sustainable design
  • Collaborate with peers and key stakeholders to create conceptual designs for new data pipelines and upgrades to existing systems
  • Assign complexity estimations to development efforts
     

• Development & Testing
  • Deliver clean, readable code that meets requirements
  • Contributes and reviews technical related entries into enterprise data dictionaries
  • Follow team standards for development practices
  • Provide appropriate documentation of development work
  • Collaborate with teammates on tasks
  • Subject all features to manual testing to ensure acceptance criteria are met with a focus on user experience
  • Participate in peer review on tasks
     
• Culture and Team Development:
  • Coach and mentor junior team members
  • Communicates proactively and effectively with team members, team leads, project managers, software developers, user personnel and management staff
  • Actively seek out opportunities to improve the team dynamic
  • Maintain a focus on breaking down silos
  • Foster an environment of fluid collaboration
  • Ensure that all data communications are secure as required by the Health Insurance Portability and Accountability Act (HIPAA) of 1996

Job Qualifications

Required

• 5+ years of experience developing traditional data streams (relational data warehouses, operational data stores)
• Expert knowledge of various SQL languages (PostgreSQL and MySQL Required)
• Excellent problem solver, with a focus on team success
• Excellent communication skills with ability to work cross-functionally across multiple teams
• 3-4 years of experience in Python, using frameworks or libraries to construct applications
• 2+ years of experience in data science.
• 2+ years of experience in Data Modeling for large amounts of data that are very transaction heavy.  
• 1+ years of experience in in machine learning/predictive analysis or automation of business rules.
   

Preferred

• Experience with BI tools such as Crystal Reports, SSRS, etc.
• Experience with ETL tools such as Pentaho, SSIS, Kafka, etc.
• Experience with scripting languages such as Bash, Ruby, etc.
• Experience with ELK stack or Docker.
   

Travel

• Ability to travel up to 20%.

Scheduled Weekly Hours:

Work Shift:

Job Category:

Company:

Sonic Healthcare USA is an equal opportunity employer that celebrates diversity and is committed to an inclusive workplace for all employees. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, age, national origin, disability, genetics, veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.