Database Administrator

Job Description

Interview Process: Virtual Interview via MS Teams video. May have a second-round interview onsite if needed.

Hybrid: Resource will be working a hybrid schedule. NO REMOTE ONLY OPTION. Will need to be onsite from day 1, two days a week. (Mon & Tues)

Local candidates ONLY

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

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

Education:

• A 4-year college level degree (Bachelors) in the field of Computer/Information sciences/Technology.
• In the case of candidates with lot of experience, education requirements could be relaxed, and an associate degree could suffice.