Senior Database Administrator

Davita Inc.; New Jersey; Remote; USD 100,000 - 140,000; Full time

Job summary

A leading management consulting firm is seeking a Senior Database Administrator to manage database operations for federal projects. This role involves SQL performance tuning and data integration in a remote setting, contributing to high-impact initiatives in a mission-driven environment.

Qualifications

• 8+ years of experience in database management.
• Experience consulting federal clients in data initiatives.
• Proven analytical skills and ability to engage decision makers.

Responsibilities

• Manage database operations and performance tuning.
• Lead database creation and management through data modeling.
• Develop and administer databases for data extraction and reporting.

Skills

SQL Server

SSIS

SSRS

XML

ETL

DWH

Bash scripting

PowerShell scripting

Education

BS or equivalent

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.