Database Administrator

Title : Database Administrator 2 138739
Location : Lansing, MI
Duration : 12 + Months
Job Type : C2C

Description :

As a Database Administrator, the resource, participates in 24×7 software and hardware support for complex applications in several versions of SQL Server, with high availabilty and Disaster Recovery support,  following industry and DTMB development standards. Helps 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 serves  as  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. 

Skills :

• 5+ years of Database administration specifically on SQL Server 16 and upwards. 

• 3+ years of experience creating, updating and maintaining systems documentation.

• Expertise in HA and DR solutions. 

• Transparent Data Encryption within SQL Server.