We are looking for an outstanding candidate to join our growing data engineering team. The position will be responsible for the management of our data repositories, ensuring they are scalable, optimized and all information 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 database's 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:
- Bachelor's 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
Salary: TBD
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)
Job Type: Full-time
Pay: $100,000.00 - $125,000.00 per year
Benefits:
- 401(k)
- Dental insurance
- Flexible schedule
- Health insurance
- Life insurance
- Paid time off
- Vision insurance
Schedule:
- 8 hour shift
- Monday to Friday
Work Location: In person
