Job Description :
Title: Database Manager Duration: 1 Year + Location: Hanover, Maryland Job Description Must be capable of managing the development of database projects. Must be able to plan and budget staff and data resources. Supports application developers in planning preparation, load analysis, and backup and recovery of data. When necessary, reallocates resources to maximize benefits. Must be able to prepare and deliver presentations on DBMS concepts. Provides daily supervision and direction to support staff. Monitors performance and evaluates areas to improve efficiency. 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. A Master's Degree is preferred. General Experience: Must have seven (7) years of experience in the development and maintenance of database systems. Specialized Experience: At least five (5) years of experience with database management systems, system design and analysis, operating systems software, and internal and data manipulation languages. The candidate should have at least twelve (12) years' experience in the following: A. Experience in performing IT project management activities of project scheduling and leading a project team. B. Experience with creating, testing, deploying, and supporting ETL processes. C. Experience with change control and SDLC procedures including related documentation. D. Experience interfacing and communicating with internal and external IT customers and users around project coordination, business requirements, service level agreements, problem resolution and systems down time. E. Supervisory skills and management experience of leading a team up to seven (7) people. Responsibilities: The personnel shall perform the following requirements: Ensure servers are current with Database Management Systems (DBMS) patches and security updates. Document, analyze and evaluate the various security procedures in place to provide system and data security for mission-critical business systems as defined by security standards. Provide access to this documentation to authorized personnel only. Maintain security, perform and manage all database security checks and integrity of data access policies, standards and methods by establishing database recovery plans to minimize data losses and system downtime and by developing backup routines for the database management system software and for the stored data. Develop standardized applications security procedures for applications and databases. Configure and tweak the hardware and software, perform integration testing, create and restore server images, create and implement plans to rollover the statewide systems from testing to production. Install and upgrade database servers, provide hardware/software specifications for various related systems to provide functional capabilities for the critical systems. Create software and database maintenance plans for efficient upgrades and maintenance. Implement the plan and update it regularly. Coordinate the database management system interfaces with other data processing units. Review and approve/disapprove database designs for new systems. Update all system documentation, including hardware and software versions as well as configuration parameters. Submit weekly report on Friday to the Manager of all updates and configurations changes performed to the existing hardware or software platform. Develop and maintain scripts, perform, and monitor backups for mission critical servers. Troubleshoot and resolve database connectivity, back up issues working with Vendors/Developers/Users/Project Managers and back up operators. Manage escalations and resolutions such as database connectivity and backup issues with internal team members and participating Vendors. Prepare and implement disaster recovery plans for various systems. Create upgrade, migration schedules and plans to minimize the impact on production and mission critical systems. Assist Business Side System Administrators on database issues/errors and assist users and programmers with SQL queries and tuning. Research, lab test, document and make recommendations to the Manager on a variety of new database related technologies, including cloud related services, that could be implemented and 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, other data processing staff and system users. Develop and implement new database management policies, procedures, and standards. Hold status meetings with ITG Management on various projects. Provide DBMS expertise whenever required. Attend internal staff meetings as requested with network team, project managers, business users, developers, and upper management. Create, collaborate, and review, hardware, software, configuration change requests, work breakdown structures, implementation plans, and testing plans for database projects and requirements. Receive and review all Weekly Status Reports from Database Administrators and compile for submission to the Manager. Receive and review weekly Quality Assurance/Performance Report from Senior Database Administrators. Prepare for submission to the Manager. Lead and support all Database Administrators assigned. Perform other related duties as assigned by the management. Perform the role of the Senior and Junior Database Administrators if warranted.