SUMMARY Install and maintain the databases and related software used to run application systems. Define and support a broad architecture for database modeling, design, and development of future applications and emerging technologies, such as data warehousing. Responsible for technical system administration of instructional software systems including testing, configuring, installing, and troubleshooting software as well as installation of third-party software.
ESSENTIAL DUTIES AND RESPONSIBILITIES
- Create, configure, and maintain the databases, including definition for disk and logical volume requirements, establishment of appropriate directories, environment setting, space allocations, OS configurations, and network configurations. Monitor activity against all databases, including sizing allocations, activity, usage, and licensing issues. Automate routine tasks using various OS and database
- As new systems are brought in-house, choose whether to use clustering, log shipping, mirroring, Microsoft SQL, My SQL, or other technologies. Troubleshoot SQL Server service outages as they occur, including after-hours and weekend. Configure SQL Server monitoring
- Tune databases for optimal performance and resource utilization, including, but not limited to, SQL tuning for the applications, memory allocations, buffers, and background processing.
- Troubleshoot production database performance issues and recommend appropriate remediation. Gather forensic data to recommend database, platform, and application improvements. Perform technical system administration activities related to existing client instructional software systems. Install, configure, and troubleshoot new instructional technology systems. When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes. Implement workarounds, patches, and updates when necessary to support the efficient and effective operations of client instructional
- Define and establish procedures for backup and recovery of the databases in conjunction with the system administration group. Practice various recovery scenarios. Document the client’s database
- Coordinate with project managers, system administrators, network administrators, developers, management, and end users on project and technical/infrastructure issues, including issues related to databases as well as OS technical issues and system
- Adhere to and enforce IT department Change Management procedures for all modifications to production environments.
- Monitor system load, swapping, inter-process communication, systems and site security. Act independently to diagnose and analyze computer and data communications operational problems, implement or coordinate necessary corrective actions, and work with software vendors to facilitate solutions to technical
- Study and obtain information related to OS, database, applications and new/emerging
- Collaborate with Infrastructure resources to research, recommend, and implement hardware and operating system software to support instructional technology systems.
- Collaborate with Network Support Services to coordinate desktop technical needs with instructional software
- Anticipate database growth patterns and application Plan for data archival and storage. Evaluate and recommend products, related tools, and new technologies.
- Build procedures documentation
- Install and maintain the software required to run the databases on the operating system, including initial configuration, patches, and
- Define and control database access/security at the OS and database level. Coordinate with application project managers regarding application
- Coordinate installation of development tools as they are integrated with the databases.
EXPERIENCE 5-7 years’ experience in information systems, including 1-3 years’ experience with enterprise class databases and 3-5 years’ experience with Microsoft Windows Server operating system. Must also have successful experience in the areas of facilities planning, capacity planning, vendor liaison, and customer service in a large technology organization.
EDUCATION AND TRAINING Bachelor's degree in computer science, information systems management, or related field, or equivalent experience. Training regarding relational database theory and databases.
Team and leadership skills, good organizational skills, accuracy, attention to detail, and global perspective. Knowledge of and experience with enterprise class server operating systems; relational database administration; applications and tools; Internet; desktop productivity tools; and bringing disparate systems into one information system infrastructure.
- Specific Skills Addendum
- SQL Server Database Administrator
- Skills Required
- 1-3 years managing enterprise class SQL Server databases
- Experience with a formalized software development lifecycle process
- Experience Microsoft database technologies (SQL Server, Reporting Services, Analysis Services, SSIS/DTS, )
- Experience with multi-dimensional/cube data and Microsoft Analysis Services preferred Infinite Campus or other student information system experience a plus
- Experience with ITIL process experience a plus
- MCDBA certification preferred