This role is heavily involved in strategic and tactical information design, business area analysis, security, and data modeling to meet data collection needs and support the transition of ETL processes from on-premises environments to cloud servers. This position serves as the Subject Matter Expert (SME) for the SLDS data warehouse and requires considerable independent judgment in directing and coordinating appropriate data administration and management methods, practices, procedures, and tools to complete assigned responsibilities.

PSR Associates is a consulting and talent solutions firm that connects qualified IT professionals with great opportunities. Whether you're looking for a contract or permanent position, we can help you find the right fit for your skills and experience. We have a team of experienced recruiters who know the IT industry inside and out, and we work with you every step of the way to ensure a smooth and successful transition. PSR Connecting Talent, Crafting Success.

SQL Database Administrator

We are seeking a SQL Database Administrator to join our team.The selected candidate will work a hybrid schedule consisting of two (2) days each week onsite (Wednesdays and Thursdays) in Lansing, MI and three (3) days each week remotely.

Position Overview:

This position supports an enterprise database environment, primarily for a Statewide Longitudinal Data System (SLDS) modernization initiative aligned with the Common Education Data Standards (CEDS).

The database environment includes:

• Multiple SQL Server instances.

• Multiple collection environments, including Development, Quality Assurance/Testing, Pre-Release, and Production.

• Numerous SQL Reporting Services servers.

• 35+ collection databases.

• 100+ analysis databases.

This position serves as the Subject Matter Expert (SME) for the SLDS data warehouse and requires considerable independent judgment in directing and coordinating appropriate data administration and management methods, practices, procedures, and tools to complete assigned responsibilities.

Expertise is required in Microsoft SQL Server database support, along with professional knowledge of CEDS standards.

This role is heavily involved in strategic and tactical information design, business area analysis, security, and data modeling to meet data collection needs and support the transition of ETL processes from on-premises environments to cloud servers.

Responsibilities also include identifying, analyzing, categorizing, synthesizing, designing, and supporting the productive use of business information. Additionally, this position ensures architectural frameworks are properly implemented and enforced while monitoring and upgrading the server infrastructure supporting the database environment.

Roles and Responsibilities

1. Data Pipeline Development and ETL Management

• Design, implement, expand, and maintain data pipelines by performing extraction, transformation, and loading activities.

• Manage data preparation jobs, data analysis, and data reporting.

• Perform technical troubleshooting and root cause analysis and provide technical expertise for ETL jobs.

• Collaborate with developers, business stakeholders, and other team members to design and deliver accurate, high-quality data while providing technical advice and support.

2. Database Analysis and Management

• Perform data analysis and database management.

• Maintain, enhance, and design data dictionaries, physical and logical database models, and performance-tuning processes.

• Apply knowledge of utilities and production tools used for data storage management to support application teams.

• Coordinate physical changes to computer databases.

• Code, test, and implement physical databases using database management system knowledge.

3. Database Design and Administration

• Establish physical database parameters.

• Use Structured Query Language (SQL) to define database objects using Data Definition Language (DDL) and control access to database objects using Data Control Language (DCL).

• Test and correct errors and refine database changes.

4. Database Performance and Production Support

• Write SQL to create production databases.

• Use database utility programs and third-party utilities to monitor database performance, including record distribution and available memory.

• Direct programmers and analysts in making changes to the database management system.

• Review and correct programs.

• Respond to user questions.

• Collaborate with coworkers to determine the impact of database changes on other systems.

5. Data Modeling, Integration, and Security

• Evaluate user requests for new data elements and systems, incorporate them into the existing shared data environment, and provide technical assistance.

• Coordinate data usage to ensure data integrity and control redundancy.

• Load and reorganize databases as needed.

• Perform data modeling and prototyping.

• Develop and maintain ETL processes.

• Perform logical and physical data modeling.

• Design relational database models and create physical data models from logical data models.

• Perform security recovery procedures.

6. Database Backup and Recovery

• Execute procedures necessary to save, retrieve, and recover databases from hardware and software failures in accordance with established procedures.

• Assist with determining, implementing, and enhancing database security standards.

• Assist with monitoring disaster recovery procedures and systems.

Top 3 Required Skills

• Azure Database Services.

• SQL data modeling and database structure.

• Extensive ETL development experience.

Minimum Experience Required

• 12 years of overall relevant experience.

Required Qualifications and Technical Experience:

• T-SQL: 8 10 years of experience.

• ETL Development: 6 8 years of experience.

• PowerShell: 5 years of experience.

• Azure DevOps: 5 years of experience.

• Scrum: 5 years of experience.

*** Please note that any false information on your resume or application could lead to the offer being withdrawn or even termination after hire.***