SQL Database Administrator

SQL Database Administrator

Duration: 12 Months

Location: Lansing, MI (Only Locals)

Top Skills & Years of Experience:

·         4+ years of Database administration specifically on SQL Server 16 and upwards.

·         Expertise in HA and DR solutions.

·         Transparent Data Encryption within SQL Server.

·         Over 2+ years of experience creating, updating and maintaining systems documentation.

Responsibilities:

·         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.