SQL DBA - Need locals to MI

Job Summary

This is a hybrid role requiring 2 days onsite per week in Lansing, MI, with no remote-only option. Candidates must be local to the Lansing, MI area (1-1.5 hours driving distance) at the time of submission. Occasional after-hours patching may be required (monthly).

Responsibilities

• Review and comply with policies and procedures.
• Perform data analysis and database management, including maintenance, enhancement, design of data dictionaries, physical and logical database models, and performance tuning.
• Gain knowledge in utilities and production tools for data storage management to support applications.
• Proficiency in PowerShell or Python is required.
• Design logical and physical databases, review changes for impact on the physical database.
• Establish physical database parameters using SQL (DDL, DCL) and define database objects and control access.
• Code database descriptions or direct others.
• Calculate optimum database parameters (e.g., memory allocation).
• Specify user access levels and data accessibility.
• Test and correct database errors, refining changes.
• Create production databases using SQL.
• Monitor database performance using utility programs and 3rd party utilities.
• Direct programmers and analysts on database management system changes.
• Review and correct programs, answer user questions.
• Confer with colleagues on the impact of database changes on other systems and costs.
• Modify database programs for performance tuning.
• Specialize in one or more database management systems.
• Assist in planning, development, maintenance, and monitoring of integrated database systems, ensuring consistency with structural parameters.
• Evaluate user requests for new data elements and systems, incorporate them into the shared data environment, and provide technical assistance.
• Coordinate data usage for integrity and redundancy control, load and reorganize databases as needed.
• Perform data modeling and prototyping, including logical and physical data modeling, relational database design, and creation of physical data models.
• Perform security recovery procedures.
• Determine and implement database search strategies and storage requirements.
• Maintain data dictionary for uniformity and set standards.
• Monitor database performance and recommend improvements.
• Create test database environments, including necessary libraries and procedures.
• Execute procedures for saving, retrieving, and recovering databases from failures.
• Assist with database security standards, disaster recovery procedures, and systems.
• Assist with database software installation, analysis, design, and implementation.
• Assist with benchmarking and threshold testing of databases and establishing/controlling security.
• Assist in selecting database management software.
• Experience in computer systems analysis or computer programming.

Required Skills & Experience

Database Administration Backup & Recovery (3-5 years)

• Implement native, cloud-native, and hybrid cross-site backup and recovery strategies.

Installation & Configuration (3-5 years)

• Configure SQL Server on physical hardware, VMs, and cloud IaaS virtual machines.

Security & Compliance (3-5 years)

• Enforce data masking, encryption (TDE), and Row-Level Security.

Database Maintenance (3-5 years)

• Manage automated indexing, statistics, and integrity checks across fragmented environments.

PowerShell / CLI Automation (2-3 years)

• Automate hybrid environment configuration using PowerShell, dba tools, and Cloud CLIs.

Performance Tuning & Monitoring (2-3 years)

• Analyze metrics across physical servers, IaaS VMs, and PaaS endpoints.

Query & Index Optimization (3-5 years)

• Identify bottlenecks, rewrite T-SQL, and resolve locking/blocking issues.

Hybrid Infrastructure Management (2-3 years)

• Manage connectivity between on-premises SQL Servers and cloud environments.

Azure SQL / AWS RDS (2-3 years)

• Configure Azure SQL Database, Managed Instances, or AWS RDS SQL Server.

Preferred Skills & Experience

Cloud Migration (1-2 years)

• Move workloads from on-premises to cloud using Azure Database Migration Service or AWS SMS.

CI/CD & Database Versioning (1-2 years)

• Schema deployment automation via Azure DevOps/GitHub Actions using Flyway or Redgate.

Additional Requirements

• References are required. Include a separate attachment with 2-3 professional references (name, email, phone, title/company).
• Include a LinkedIn link at the top of your resume, or note its absence.
• Local candidates ONLY (within 1-1.5 hours of Lansing, MI).
• Hybrid schedule: 2 days onsite per week.
• Occasional after-hours patching may be required.

Title : SQL DBA Location : Lansing, MI Duration : 12 Months Job Type : Contract