Existing employer? Sign in
St. Louis Community College
Administrator, SQL Database
T-SQL
SQL Server
Microsoft
Edtech.com's Summary
St. Louis Community College is hiring an Administrator, SQL Database. The role administers and supports the college's Microsoft SQL Server database environment, covering installation, security and access management, performance tuning, and backup and recovery for the databases behind College applications. The administrator works with technology staff, application owners, and vendors, and serves as a specialized technical resource for the college's technology support team.
Highlights
- Install, configure, and maintain Microsoft SQL Server instances and the storage, maintenance routines, and services that support College applications.
- Monitor database health, capacity, performance, and availability, and troubleshoot connectivity and performance problems, including inefficient queries, blocking, and deadlocks, by working with developers and vendors.
- Administer database accounts, roles, and permissions under College security standards, and review access and audit information to respond to suspected unauthorized activity.
- Build and monitor backup and recovery processes, test restoration procedures, and support high availability and disaster recovery through failover testing and recovery planning.
- Plan and carry out database upgrades, patches, and migrations, testing changes and documenting rollback procedures through the College's change management process.
- Write and maintain Transact-SQL scripts, scheduled jobs, and automation for routine administration, monitoring, maintenance, and security tasks.
- Document database configurations, dependencies, and recovery processes, and recommend changes to software, storage, and configuration based on capacity reviews.
- Bachelor's degree in computer science or a closely related field, or equivalent training and experience, plus five or more years in a comparable enterprise computing environment, at least three of them administering Microsoft SQL Server.
- Part-time schedule at $22.04 per hour, with occasional evening or weekend work for scheduled maintenance, upgrades, or incident response.
Administrator, SQL Database Full Description
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.
Salary: 22.04
Similar Jobs
Senior Network Engineer
UMass Boston
🇺🇸 Boston, Massachusetts
Client Services Analyst (Health Sciences IT)
University of Pittsburgh
🇺🇸 Pittsburgh, Pennsylvania
Technology Support Specialist
California State University - Northridge
🇺🇸 Hybrid - Northridge, California
Instructional Technology, Support Specialist II, Educational Media Center
Boston University
🇺🇸 Boston, Massachusetts
Field Engineer - Audio Visual Systems
Purdue University
🇺🇸 West Lafayette, Indiana
