Administrator, SQL Database

St. Louis Community College
Hazelwood, MO, United States
11 days ago
Apply on www.indeed.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Part-time (≀ 32 hours)
Experience level
Experienced
Experience required
3 years minimum
Compensation
$45,843
Working hours
Shift work
Job source

Tech stack

Backup Devices Databases Data Integrity Database Security Database Storage Structures Disaster Recovery Identity and Access Management Microsoft SQL Server Performance Tuning SQL Databases Systems Integration Transact-SQL
+7 more
Software Application Delivery System Availability Database Performance Database Migration Information Technology Performance Monitor Database Installation

Job description

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., * 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.

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

Benefits & 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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.indeed.com
Prepare application

Good distractions

Loading talks and stories from around this role…