Database Administrator 3 - SQL DBA in Lansing, MI Hybrid Work

Job Description

Job ID: 158630

Location: Lansing, MI (Hybrid) Duration: 1 year with likely extension Schedule: Hybrid - 2 days onsite per week. Must be present onsite from day 1. No remote-only option.

Responsibilities:

• Review and comply with established 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 proficiency in utilities and production tools for data storage management to support applications.
• Utilize PowerShell or Python for automation.
• Design logical and physical databases, reviewing changes for impact on the physical database.
• Establish physical database parameters using SQL (DDL, DCL) and calculate optimum database parameters.
• Specify user access levels and control data access.
• Test and refine database changes.
• Create production databases using SQL.
• Monitor database performance using utility programs and third-party tools.
• Direct programmers and analysts in making changes to the database management system.
• Review and correct programs, and answer user questions.
• Confer with colleagues to assess the impact of database changes on other systems and costs.
• Modify database programs for performance tuning.
• Assist in planning, development, maintenance, and monitoring of integrated database systems, ensuring consistency between application design and database structure.
• Evaluate user requests for new data elements and systems, integrating them into the shared data environment and providing technical assistance.
• Coordinate data usage to ensure integrity and control redundancy, load, and reorganize databases as needed.
• Perform data modeling (logical and physical), design relational database models, and create physical models from logical ones.
• Execute security recovery procedures.
• Determine and implement database search strategies and storage requirements.
• Maintain the data dictionary, ensuring uniformity of definitions and setting 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 system monitoring.
• Assist with database software installation, analysis, design, and implementation.
• Assist with database benchmarking, threshold testing, and security control.
• Assist in the selection of database management software.
• Experience in computer systems analysis or computer programming.
• Knowledge of programming principles, systems design, computer operations, project control, data processing flowcharting, database structures, and current database technologies.

Requirements:

Database Administration Backup & Recovery:

• 3-5 years experience implementing native, cloud-native, and hybrid cross-site backup and recovery strategies.

Installation & Configuration:

• 3-5 years experience configuring SQL Server on physical hardware, VMs, and cloud IaaS virtual machines.

Security & Compliance:

• 3-5 years experience enforcing data masking, encryption (TDE), and Row-Level Security.

Database Maintenance:

• 3-5 years experience managing automated indexing, statistics, and integrity checks across fragmented environments.

PowerShell / CLI Automation:

• 2-3 years experience automating hybrid environment configuration using PowerShell, dba tools, and Cloud CLIs.

Performance Tuning & Monitoring:

• Hybrid Performance Monitoring: 2-3 years experience analyzing metrics across physical servers, IaaS VMs, and PaaS endpoints.
• Query & Index Optimization: 3-5 years experience identifying bottlenecks, rewriting T-SQL, and resolving locking/blocking issues.

Hybrid Infrastructure Management:

• 2-3 years experience managing connectivity between on-premises SQL Servers and cloud environments.

Azure SQL / AWS RDS/GCS:

• 2-3 years experience configuring Azure SQL Database, Managed Instances, or AWS RDS SQL Server.

Cloud Migration (Preferred):

• 1-2 years experience moving workloads from on-premises to cloud using Azure Database Migration Service or AWS SMS.

CI/CD & Database Versioning (Preferred):

• 1-2 years experience with schema deployment automation via Azure DevOps/GitHub Actions using Flyway or Redgate.
• Experience with Multi-Tenant environments.