Sr DBA (oracle , SQL Server )

Scope of Work: The purpose of this work order is to obtain resources to provide services and support for the MS

SQL Servers and Oracle/UNIX Linux database operations, maintenance, and mission critical business applications. In addition, all resources will support other client/server and web base systems, provide guidance concerning application security, and give continual supportive information concerning best practices in planning, designing, and implementing emerging database management technology solutions

Position Description: The Database Management Specialist (Senior) shall provide highly technical expertise and support in the use of DBMS. This individual is responsible for performing the following tasks:

A. Evaluating and recommending available DBMS products to support validated user requirements;

B. Defining file organization, indexing methods, and security procedures for specific user applications;

C. Developing, implementing, and maintaining database back-up and recovery procedures for the processing environments; and

D. Ensuring data integrity, security, and recoverability are built into the DBMS applications.

Education: This position requires a Bachelor’s degree from an accredited college or university with a major in computer science, information systems, engineering, business, or a related scientific or technical discipline; or three (3) years of equivalent experience in a related field.

General Experience: The proposed candidate must have at least six (6) years of experience in DBMS systems analysis and programming.

Specialized Experience: The proposed candidate must have at least three (3) years of experience in using current DBMS technologies, application design utilizing various database management systems, and experience with DBMS internals.

Duties and Responsibilities:

1. Ensure servers are current with DBMS patches and security updates.
2. Perform all database security checks and manage all database securities.
3. Maintain security and integrity of data access policies losses and system downtime and by developing backup routines for the database management system software and for the stored data.
4. Configure and tweak the hardware and software, perform integration testing, create and restore server images, create and implement plans to rollover the MDOT MTA’s statewide systems from testing to production.
5. Install and upgrade servers and other related software on the MDOT MTA’s specified hardware to provide functional capabilities for the critical systems.
6. Configure a backup job to run on specified schedule, conduct routine maintenance and proactive monitoring on all databases.
7. Restore data files or tables from previous backup sessions.
8. Develop, maintain scripts, perform and monitor backups for mission critical servers at MDOT MTA.
9. Troubleshoot database connectivity and backup issues working with Vendors/Developers/Users/Project Managers and backup operators.
10. Perform system performance monitoring.
11. Trouble shooting and resolve complex and diverse Interface issues.
12. Prepare and implement disaster recovery plans for various server-based software systems.
13. Create upgrade, migration schedules and plans to minimize the impact on production and mission critical systems.
14. Conduct random health checks on the databases, prepare quality assurance and performance review to include; business needs, testing, upgrades, architecture storage modifications and adjustments. Provide and review a weekly report with the Database Manager.
15. Assist MDOT MTA Business Side System Administrators on database issues/errors and assist users and programmers with SQL queries and tuning.
16. Coordinate the installation and implementation of database management system software and related software tools with vendors, other data processing staff and system users.
17. Attend internal MDOT MTA staff meetings as requested with network team, project managers, business users, developers and upper management.
18. Independently research and find creative solutions to problems and share knowledge with other team members.
19. Create or review configuration change requests, hardware/software requirements, work breakdown structures, implementation plans and testing plans for database servers and database projects.
20. Perform the role of the Database Manager if warranted.
21. Perform other related duties as assigned by MDOT MTA management.