Senior Database Administrator

Davita Inc.; New York (NY); Remote; USD 120,000 - 160,000; Full time

Job summary

A leading management consulting firm is seeking a dynamic Senior Database Administrator for a remote position with the NY Department of Education. This opportunity involves managing database operations, ensuring quality, and supporting data initiatives within a mission-driven environment. Candidates must have extensive experience and a relevant educational background.

Qualifications

• 8+ years of experience in database management.
• Strong experience with Federal clients.
• Ability for security clearance.

Responsibilities

• Lead database creation and management through data modeling.
• Create logical data models in the form of data cubes.
• Improve data quality and restructure data for business users.

Skills

SQL Server

Data Integration

Performance Tuning

Query Optimization

Education

BS or equivalent

Tools

SSIS

SSRS

ETL

Shell scripting

PowerShell

Bash scripting

Job description

Description

Manhattan Strategy Group (MSG), a leading management consulting firm, is seeking a dynamic and experienced Senior Database Administrator for an upcoming opportunity with the NY Department of Education. This position will be remote.This role offers an exciting opportunity to lead high-impact initiatives in a fast-paced, mission-driven environment.

MSG specializes in delivering innovative solutions in program management, training and technical assistance, research and evaluation, marketing and communications, and IT and digital services to a range of federal clients, including extensive experience with the Departments of Education, Labor, and Health and Human Services. Join MSG and be part of a collaborative, growth-oriented firm that values excellence and impact.

As a key member of our team, the Senior Database Administrator will manage all operations consistent with database management. Ability perform and troubleshoot SQL Server Backups, Restore Strategies, Replication, SQL Server Performance Tuning and Query Optimization.This role will workwith multiple data owners and stakeholders to establish a monthly data extraction and reporting plan, advise, and execute data mapping, develop, and administer multiple databases and perform general operational support.

Job Responsibilities

• Leads the effort in database creation and management through data modeling.
• Expertise with creation of DataMarts.
• Expert in setting up Microsoft SQL Server database in virtual and clustered environments, along with experience in SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Create and/or implement logical data models that represent the abstract structure of assigned information in the form of data cubes and or star schemas.
• Support a single common data model for all data of interest, integrating the data regardless of the data's source using common design and normalization, while organizing and disambiguating repetitive data.
• Develop tables: heap or index-organized tables, and table or indexed clusters.
• Improve data quality, by providing consistent codes and descriptions, flagging, or even fixing/cleansing bad data.
• Restructure the data so that it makes sense to business users, making decision-support queries easier to write, while helping support the accelerated development of business intelligence and reporting capabilities.
• Restructure the data so that it delivers excellent query performance, even for complex analytic queries, without impacting the operational systems.
• Understand and optimize materialized views and partitioning schemes.

Basic Qualifications

• BS or equivalent and 8 + years of applicable experience.
• Strong prior experience consulting Federal clients or serving Government agencies in their data integration and management initiatives.
• Proven analytical skills and experience engaging decision makers autonomously while serving as a member of a team.
• Proficient in Technologies: SQL Server, SSIS, SSRS, XML, ODS, ETL, DWH, Shell / PowerShell / Bash scripting
• Ability to undergo fingerprinting and security clearances
• Legal authorization to work in the U.S.

Manhattan Strategy Group (MSG) is an Equal Opportunity Employer and considers all qualified applicants for employment without regard to race, color, religion, sex, national origin, age, disability, veteran status, or any other characteristic protected by law. Our hiring decisions are based solely on merit and qualifications, ensuring a fair and competitive selection process.