Database Administration and Support
Database Support is responsible for upgrade, administration, migration, and maintenance of databases; primarily the Microsoft SQL Server and Oracle databases related to information services applications. It also includes the administration of web servers and deployment release of systems from development/test environments into production.
- Development of project plans for application design, development, testing, implementation, and maintenance.
- Evaluation of application solutions that support strategic initiatives and goals.
- Analyze departmental needs in order to design, develop, implement, and support applications.
- Efforts to analyze, review, and modify existing software to increase operating efficiency, adapt to new requirements, and repair application errors.
- Works independently to perform systems analysis, develop, and review programming code defined in project plans to meet design specifications, customer requirements, and/or applies vendor supplied upgrades.
- High interaction with TTUHSC El Paso IT leadership group.
- Adheres to all appropriate institutional policies (including IT OPs) and other relevant internal departmental policies.
- Learning Management System
- Curriculum Management System
- Web Entry Environments
- Production Deployments
- IT Migration Systems
- Application Development Systems Infrastructure
Web Server Administration (install, configure, migrations, tuning, reporting, and day to day operations monitoring and support).
- Monitors the web servers for issues with disk space, CPU usage, memory problems or other issues that may impact the end-users.
- Works with Application Development Organizations and various internal teams during application deployments.
- Test issues such as system integration, performance, and system security on a regular schedule or after any major program modifications.
- Develop or implement procedures for ongoing web application revision.
- Document installation or configuration procedures to allow maintenance and repetition.
- Reinforce deployment policies for production environment.
- Installing and upgrading the database server and application tools.
- Allocating system storage and planning future storage requirements for the database system.
- Modifying the database structure, as necessary, from information given by application developers verbally.
- Enrolling users and maintaining system security.
- Ensuring compliance with database vendor license agreement.
- Controlling and monitoring user access to the database.
- Monitoring and optimizing the performance of the database.
- Planning for backup and recovery of database information.
- Maintaining archived data.
- Backing up and restoring databases.
- Contacting database vendor for technical support.
- Generating various reports by querying from database as per need.