Database Administrator

Responsibilities

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

About you

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

Emmi Solutions is an Equal Opportunity Employer that welcomes and encourages diversity in the workplace.