Database Administrator

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 firms 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.

Company Overview:

Blue Orange Digital is a cloud-based data transformation and predictive analytics development firm with offices in NYC and Washington, DC. From startups to Fortune 500s, we help companies make sense of their business challenges by applying modern data analytics techniques, visualizations, and AI/ML. Founded by engineers, we love passionate technologists and data analysts. Our startup DNA means everyone on the team makes a direct contribution to the growth of the company.

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: $82,000 - $97,500 (annual salary range)

Background checks may be required for certain positions/projects.

Blue Orange Digital is an equal-opportunity employer.