Administrator, SQL Database Part Time
About The Position
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. Works an established part-time schedule and 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.
Requirements
- 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 or more years of experience in an enterprise computing environment of comparable complexity.
- At least three years of directly related database administration experience with Microsoft SQL Server.
Responsibilities
- 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 recoverability against established requirements.
- Supports high availability and disaster recovery configurations; participates in recovery planning, failover testing, and restoration of database services 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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Part-time
Career Level
Mid Level
