| Job Title: | Senior SQL Server DBA (Hybrid) |
| Location: | Lansing, MI |
| Duration: | 12 months |
| Pay Rate: | $80/hr on C2C / 1099 all inclusive (OR) $70/hr on W2 |
| Interview Process: | Candidates submitted must be willing to come onsite (Lansing, MI) for interviews. A screenshot photo of candidate will be required for any interviews as well as a vendor present at beginning of any MS Teams interview to validate candidate. |
| Note: | Remote or On-site: Accepting local candidates within 90 minutes of Lansing, MI ONLY. Position will be hybrid, in office 2 days a week upon start and there is NO REMOTE ONLY option. |
| Job Description | -
Participate in 24x7 software and hardware support including Disaster Recovery and incident response support, following industry and DTMB development standards. -
Help develop and/or submit for approval, plans for installation, patch management maintenance, upgrades and support for the Database systems. -
Evaluate impacts of change and new technology, recommend solutions to persistent problems, and serve as an Agency Services liaison to external consultants. Individual tasks related to the duty: -
Follow and enforce database standards, policies & procedures. Research and draft guidelines within the boundaries of current policies and standards. -
Monitor space allocation across databases. perform adjustments in test and development environments as necessary and as prescribed by predefined standards/guidelines. -
Calculate disk space requirements for existing and/or new installations of existing business needs -
Modify DBMS parameters based on capacity changes. -
Configure and execute database integrity checks. -
Monitor for database integrity checks. -
Install database base management software for development and test environments. -
Install database patches and service packs for development and test environments. -
Monitor and support clustered database environments. -
Monitor and support database replication and backup environments. -
Implement the strategy to release unused space or repair fragmentation in test and development environments. -
Execute (run) scripts provided by Systems Analysts or Database Architect/Designer for creating and modifying database objects (tables, views, constraints, indexes, etc.) -
Monitor database back-ups to ensure recoverability. Troubleshoot backup errors. -
Monitor database jobs and scheduled processes in development, test and production environments. Participate in troubleshooting. -
Monitor database environments (using alert logs, trace files, alert mechanisms, and other tools) for issues and problems with database functionality, connectivity, or downtime. -
Follow standards and guidelines for database space allocation based on best practices and implementation considerations based on business requirements. |
| Top Skills & Years of Experience | Skill Descriptions -
7+ years of Database administration specifically on SQL Server 16 and upwards. -
In-depth knowledge of Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure VMs, including their features, limitations, and best practices. -
Proven experience in implementing and managing HA / DR solutions like Always On Availability Groups, geo-replication, and point-in-time restore. -
Expertise in Transparent Data Encryption within SQL Server. -
Over 3+ years of experience creating, updating and maintaining systems documentation. -
Strong understanding of database security principles, including user management, role-based accesscontrol, data encryption, and compliance regulations. -
Proficient in designing, implementing, and testing robust backup and recovery strategies for Azure SQL databases. -
Experience with Azure Monitor, Azure Log Analytics, and other tools for proactive monitoring, alerting, and troubleshooting. -
Proficiency in scripting languages like PowerShell or Python for automating routine tasks, deployments, and management. -
Experience with migrating on-premises SQL Server databases to Azure SQL platforms. -
Familiarity with ETL processes and tools like Azure Data Factory or SSIS for data integration. -
Advanced skills in identifying and resolving performance bottlenecks, including query optimization, index tuning, and database configuration |
| Recruiter Details: | Name : Sameer at gsksolutions dot com Contact : Seven one nine two three nine Five five five five |