Position Overview:
BlueOrange is seeking an experienced, self-starter motivated database administrator, DBA, for an opportunity with a first-in-class healthcare records client who is expanding its business at a record rate. This role will support the firm’s rapid growth path with database and data warehouse skills, database maintenance and operations know-how, strong data forensics and SQL skills as well as a hands-on understanding of running large, commercial databases. A curious, quick mind for all-things-database will thrive in this environment as the range of work and entities is large and promising.
Responsibilities:
- Maintains, monitors, and performance tunes/optimizes databases.
- Supports teams developing and implementing data access and data warehousing programs.
- Supports production data warehouse databases.
- Experience working with large volume databases, TB, in production environments.
- Understands and takes all steps necessary to ensure data privacy and security compliance.
- Ensures the rigorous application of information security/information assurance policies, principles, and practices in the delivery of data management services.
- Communicates well cross-functionally and can serve as a “bridge” between technical and non-technical audiences in conversations.
- Collaborates effectively with the Financial, Business & Production Operations teams.
Requirements:
- 5+ years’ experience in database administration of SQL Server database environments.
- Thorough understanding of relational databases, T-SQL Scripting, database normalization best practices, database technologies, query plans, concepts, etc.
- Experience working with Microsoft SQL Server in production and non-prod environments.
- Experience with Database Design.
- Proficient with SQL development – ability to write and troubleshoot SQL code and design (procedures, functions, tables, views, triggers, indexes, constraints).
- Experience troubleshooting and resolving database integrity and performance issues.
- Experience with performance tuning and query optimization.
- Degree in computer science or related field.
- Experience in Microsoft SQL Server Replication.
- Experience operating effectively in a secure, compliant mission-critical environment.
- Experience with Microsoft SQL Server - a MUST.
- Experience with business intelligence systems – GCP Looker is a STRONG plus.
- Self-starter able to work independently and highly effectively.
Preferred qualifications:
- Professional technical curiosity, adaptability, and flexibility.
- Experience working in a HIPAA-compliant or similarly regulated environment.
- College degree in CS or data science, or equivalent training.
Salary: US $107.5k - $137.5k (annual salary range)