Microsoft SQL Server Database Administrator- Database Management Specialist (Senior)
- At least five (5) years of experience with Microsoft SQL Server Database Administration
- At least five (5) years of experience with Microsoft SQL programming including troubleshooting and investigating complex database issues
- At least one (1) year of experience with Microsoft SQL Server High Availability
- Ensure servers are current with SQL Server patches and security updates.
- Analyze and evaluate the security procedures required for specific mission-critical business systems as defined by security standards.
- Perform all database security checks and manage all database securities.
- Create and implement plans for system security using a variety of technologies to provide data security and auditing functions for mission critical systems.
- Maintain security and integrity of data access policies, standards, and methods by establishing database recovery plans to minimize data losses and system downtime. Develop backup routines for both the database management system software and the stored data.
- Develop standardized application security procedures for applications and databases.
- Create, maintain, and monitor Always on Availability Groups (AAG) for High Availability.
- Maintain SQL Server test environment where upgrades and security patches can be tested.
- Perform integration testing, create and restore server imaging, develop and implement plans to roll over enterprise wide systems from testing to production.
- Install and upgrade SQL Server and other related software on specified hardware to provide functional capabilities for critical systems.
- Create software and database maintenance plans for efficient upgrades and maintenance. Implement the plan and update this regularly.
- Provide hardware and software specifications for various systems.
- Coordinate database management system interfaces with other data processing units.
- Review and approve or reject database designs for new systems.
- Configure backup jobs to run on specified schedules.
- Restore data files or tables from a previous backup session.
- Develop and maintain scripts and perform and monitor backups for mission critical servers.
- Work with vendors, developers, users, project managers and back up operators to troubleshoot database connectivity and back up issues.
- Prepare and implement disaster recovery plans for various SQL Server based software systems.
- Create and properly plan upgrade and migration schedules to minimize impact on production and mission critical systems.
- Research, lab test, document and make recommendations to the Manager on new database technologies that could be implemented. Provide recommendations about the migration and upgrade paths for various systems.
- Coordinate the installation and implementation of database management system software and related software tools with vendors, data processing staff and system users.
- Develop and implement new database management policies, procedures and standards.
- Collect data dictionary information on existing Microsoft Access 2003 databases.
- Consolidate data from multiple sources (including standalone Microsoft Access databases) onto a centralized Microsoft SQL Server.
- Develop and create new database solutions based on business unit requirements.
- Conduct random health checks on the databases and prepare performance reports.
- Assist System Administrators on database issues/errors and assist users and programmers with SQL queries and tuning.
- Perform routine maintenance tasks for proactive monitoring on the database servers such as deleting log files and dump files or correcting errors.
- Create repeatable processes to upgrade, test, and maintain databases and software systems. Monitor the systems to provide a minimum level of performance as part of Quality Assurance (QA).
- Monitor database performance and make modifications and adjustments to database architecture, storage methods and management system software to fine-tune the database for optimum response time.
- Prepare statistical and narrative reports of database management performance, activities and special projects.
- Troubleshoot problems related to availability of data to system users, space, database software, data flow, and data storage and data access.
- Migrate existing shared Microsoft Access data to Microsoft SQL Server and update existing Microsoft Access Databases to link to new data source.
- Create, modify, and troubleshoot reports in Microsoft SQL Server Reporting Services.
- Perform other duties as assigned.
Business Hours Support: TO Contractor shall assign TO Contractor Personnel to support Department business hours (7:30 AM to 5:00 PM), Monday through Friday except for State holidays.
Duties: Must be capable of providing highly technical expertise and support in the use of DBMS. Must be able to evaluate and recommend available DBMS products to support validated user requirements. Defines file organization, indexing methods, and security procedures for specific user applications. Develops, implements, and maintains database back-up and recovery procedures for the processing environments, and ensures that data integrity, security, and recoverability are built into the DBMS applications.
Education: A Bachelor's Degree from an accredited college or university with a major in Computer Science, Information Systems, Engineering, Business, or other related scientific or technical discipline or three (3) years of equivalent experience in a related field.
General Experience: Must have six (6) years of experience in DBMS systems analysis and programming.
Specialized Experience: At least three (3) years of experience in using current DBMS technologies, application design utilizing various database management systems and experience with DBMS internals.