Database Administrator

WE ARE LOOKING FOR AN OUTSTANDING CANDIDATE TO JOIN OUR TEAM TO JOIN OUR GROWING DATA ENGIENERING TEAM. THE POSITION WILL BE RESPONSIBLE FOR THE MANAGEMENT OF OUR DATA REPOSITORIES, ENSURING THEY ARE SCALABLE, OPTIMIZED AND ALL INFORMATIONAL ASSETS CAN BE FULLY LEVERAGED IN THE AGE OF BIG DATA

WHAT WE’RE LOOKING FOR:

· Creation, maintenance, versioning and ownership of all database schema elements

· Performance evaluation and ongoing real-time monitoring to reveal necessary optimizations (disk management, CPU utilization, memory pressure, I/O bottlenecks, etc.)

· Provision of technical expertise and direction in the databases implementation, query performance tuning and SQL development

· Administer the technical components of data governance, provisioning and integrity

· Administer our cloud data infrastructure and offering guidance towards best practices

· Implementation and maintenance of database backup and recovery procedures, including development datasets

· Transfer database information to integrated mobile devices

· Collaboration on application of Operating System and Software Upgrades / Service Packs

· Recommendations on native and 3rd party tools for effective administration

· Configuration of MS SQL Server for production, pre-production and non-production environments - implement industry best practices, tuning and optimization

· Creation of robust documentation, diagrams and technical reviews

REPORTING:

· Intimate knowledge of company data, and associated business rules governing growth / change

· Ability to produce one-off reports as requested by management with a high degree of quality

· Experience with creating, maintaining and administering reporting via Power BI

EDUCATION AND TRAINING:

· Bachelors degree with a major in Computer Science or related technical discipline

· 5+ years as SQL DBA, with mid to strong knowledge of the MS SQL Server DB architecture

· Active Directory of access control administration

· Critical thinking, organizational and troubleshooting skills

· Collaboration with developers of custom applications

· Effective team player with an ability to communicate both orally and in writing

Highly preferred:

· Familiarity with HIPAA/HITECH regulations and security as it pertains to healthcare

· Experience with ETL processing tools preferably GLUE and SSIS

· Experience working in the AWS cloud including knowledge of s3 and EC2

· Renormalization tasks for optimal data mining and machine learning

· Experience administrating AWS cloud-based SQL Server (RDS) databases

Job Type: Full-time

Experience:

· SQL DBA: 5+ years (Required)

· Data reporting: 3 years (Required)

· AWS EC2/RDS: 1+ years (Required)

· HIPAA/HITECH regulations and security: 2 years (Preferable)

Education:

· Bachelors