Administrator, SQL Database

Position Summary Performs duties necessary to administer and support the College’s Microsoft SQL Server database environment. Responsibilities include database installation and configuration, security and access management, performance monitoring and tuning, backup and recovery, and support for database availability and integrity. Coordinates database changes with technology staff, application owners, and vendors; maintains operational documentation; and recommends improvements to database reliability, security, and performance. Serves as a specialized technical resource to technology support staff. Primary Duties Performed

• Installs, configures, and maintains Microsoft SQL Server instances and databases supporting College applications. Configures database storage, maintenance routines, and related services within assigned environments.
• Monitors database health, capacity, performance, and availability. Troubleshoots database and connectivity issues, identifies root causes, implements corrective actions, and escalates issues to appropriate technology staff or vendors.
• Administers database security, authentication, accounts, roles, and permissions in accordance with College policies and established security standards. Reviews access and audit information and coordinates responses to suspected unauthorized activity.
• Develops, operates, and monitors database backup and recovery processes. Tests restoration procedures and verifies that databases can be recovered in accordance with established recovery requirements.
• Supports high availability and disaster recovery configurations. Participates in recovery planning, failover testing, and restoration of database services in coordination with infrastructure and application support staff.
• Analyzes database performance and tunes queries, indexes, and database configurations. Works with application developers and vendors to address inefficient queries, blocking, deadlocks, and other performance issues.
• Plans and implements database upgrades, updates, and patches. Tests changes, coordinates maintenance windows, and documents implementation and rollback procedures through the College’s change management process.
• Develops and maintains Transact-SQL scripts, scheduled jobs, and automation for routine database administration, monitoring, maintenance, and security tasks.
• Coordinates with application owners, developers, system administrators, and vendors to translate operational requirements into database configurations and support application implementations, integrations, and data transfers.
• Supports database migrations and the creation, refresh, and retirement of database environments. Verifies data integrity and coordinates changes with affected users and technology staff.
• Maintains documentation of database configurations, dependencies, operating procedures, troubleshooting activities, and recovery processes. Provides technical guidance and knowledge transfer to technology staff.
• Reviews database capacity and technology needs and recommends changes to software, storage, configuration, and operational practices.
• Performs other job-related duties as assigned.

Qualifications/Experience

• Bachelor’s degree in computer science or a closely related discipline, or an equivalent combination of education, training, and experience providing comparable knowledge and skills in database administration.
• Five (5) or more years of experience in an enterprise computing environment of comparable complexity, including at least three (3) years of directly related database administration experience with Microsoft SQL Server.

Working Conditions

• Works an established part-time schedule. Supports database services that operate continuously. Occasional evening or weekend work may be required for scheduled maintenance, upgrades, or incident response, as assigned and coordinated with the supervisor.

Benefits

This position is not eligible for benefits.