Database Administrator

Emmi combines an intimate understanding of people and expertise in behavioral science to successfully engage people to become participants and partners in their care and, ultimately, owners of their health and well-being. Our technology-based solutions, including online, multimedia programs and interactive call campaigns, are expertly designed using a human-centered approach, to empower people to become active in their care.

Contributing to all aspects of the database subsystem including database administration, modeling & design, development, query optimization, performance tuning, scalability, and high availability.

• Primary duties will be data modelling, performance tuning, source control management and deployments to development environments.
• Participating with the technology team in all activities including architecture, analysis, development, quality assurance, and deployment
  • Working with technology team to plan and implement new features, bug fixes, and performance enhancements
  • Monitoring and performance tuning
  • Authoring database documentation, including data standards, procedures and definitions

Additional duties will include:

• Production DBA support
• SSIS development for both datawarehousing and custom vendor/Client ETL functions
• Work with business stakeholders to identify and implement reporting and analysis requirements

• Key characteristics of success in this role include leadership, project management, passion for data and databases, desire and drive to master the entire MS SQL stack, strong problem-solving abilities, and excellent interpersonal and organization skills.
• The following describes your perfect job environment
• Large clients with big expectations: hundreds of healthcare organizations who demand excellence and execution from Emmi Solutions
• Compelling consumer experience: millions of patients every year watch an Emmi program
• Fast-growing company with the associated challenges and opportunities
• Agile development methodologies
• Working and collaborating within small teams
• High-energy environment that constantly challenges and encourages everyone to speak freely: we value honesty and open dialog

These skills / experiences are a must :

• 3+ years of RDBMS experience
• 2+ years of hands-on experience with Microsoft SQL Server 2008 or greater
• Bachelor's degree in Computer Science or an equivalent combination of education and experience
• Strong experience with SQL Server as developer, including but not limited to:
  • Strong T-SQL skills, including new features in SQL 2012
  • Performance tuning
  • Source control/deployment
• Strong Experience with the Microsoft SQL Server technology stack (Database Engine, SSIS, SSRS, SSAS)
• Knowledge of data modeling and tools (relational design, normalization, referential integrity, entity relationship modeling) for web-enabled OLTP
• Knowledge of OLAP systems and dimensional design concepts (Data Warehouse/BI/Analysis Services)
• Experience building and scaling databases for web-based SaaS applications
• Experience with security and data encryption
• Ability and desire to lead and participate in multiple projects simultaneously
• Ability to analyze business requirements and architect a database solution
• Excellent communication skills, written and verbal
• While not required, you can further impress us by having the following skills or experience
• Knowledge of SSIS and strategies for ETL
• Experience with supporting frameworks and tools such as Hibernate and Spring Batch
• Experience with Business Intelligence/Visualization tools such as SiSense
• Healthcare domain and technology experience
• Experience in highly-regulated industries
• Equally important to technology skills is temperament… would you describe yourself as
• Excellent with time management and prioritization to meet aggressive deadlines
• Superior in communication – able to write clear documents and give/receive feedback appropriately
• Creative problem solver and researcher – able to provide multiple solutions
• High-energy self-starter who takes initiative but is flexible and casual – a team player