Administrator, SQL Database
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
+7 more
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.
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦