Senior Database Administrator

Manhattan Strategy Group; New York (NY); Remote; USD 89,000 - 122,000; Full time

Job summary

Manhattan Strategy Group seeks a Senior Database Administrator to manage database operations for the NY Department of Education. The ideal candidate will have extensive SQL Server experience, particularly in a federal consulting context. This full-time role, offering remote flexibility, emphasizes high-impact initiatives in data management and integration.

Qualifications

• 8+ years of applicable experience in database management.
• Experience with federal clients or government agencies.
• Strong analytical skills and ability to engage decision-makers.

Responsibilities

• Lead database creation and manage operations.
• Optimize SQL Server performance and troubleshoot issues.
• Develop and administer multiple databases.

Skills

SQL Server

SSIS

SSRS

ETL

PowerShell

Data Modeling

Data Integration

Education

BS or equivalent

Job description

Join to apply for the Senior Database Administrator role at Manhattan Strategy Group

Join to apply for the Senior Database Administrator role at Manhattan Strategy Group

Get AI-powered advice on this job and more exclusive features.

Description

Manhattan Strategy Group (MSG), a leading management consulting firm, is seeking a dynamic and experienced

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 work with 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.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Business Consulting and Services

Referrals increase your chances of interviewing at Manhattan Strategy Group by 2x

Sign in to set job alerts for “Senior Database Administrator” roles.

Newark, NJ $89,301.33-$121,194.66 1 month ago

New York, NY $89,301.33-$121,194.66 1 month ago

Newark, NJ $114,816.00-$165,848.66 1 month ago

New York, NY $114,816.00-$165,845.33 1 month ago

New York, NY $100,000.00-$120,000.00 1 week ago

Newark, NJ $160,000.00-$200,000.00 3 weeks ago

New York, NY $70,000.00-$130,000.00 6 months ago

Englewood Cliffs, NJ $90,000.00-$100,000.00 1 week ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.