Lead Database Administrator

Lead Database AdministratorThe Lead Database Administrator is accountable for the maintenance of the College's enterprise-wide data. The Lead Database Administrator understands database technology and trends at a strategic level; is versant in implementing new technologies; architects, creates, maintains, upgrades, and monitors systems for optimal availability and performance; and troubleshoots systems issues at their root cause. This role reports to the Director, Application Development.ESSENTIAL JOB FUNCTIONSIndependently performs all of the following tasks or supervises others in the performance of all of the following tasks:Systems Development and Maintenance: 50%• Administers, configures, tunes, and maintains both enterprise-wide and solution-specific database systems for the College, including MS SQL Server, DB2, and Oracle.• Administers both locally and cloud-based databases with a focus on highly performing, highly available, and highly secure solutions.• Uses the College's standard development tools, such as ASP.net and PeopleTools, to create sustainable, maintainable, secure, privacy-sensitive, efficient, and effective solutions.• Creates solutions that leverage enterprise database solutions through the use of SQL and other standard database interfaces.• Uses the College's preferred scripting and job scheduling solutions in both databases, such as MS SQL Server, DB2, and Oracle, and operating systems, such as Windows Server and Unix, to create automations and extracts from solutions that meet the needs of other departments.• Administers operating systems, including Unix and Windows Server, to achieve the database needs of the College.• Creates and maintains the strategy, standards, planning, and execution of database solutions, including software, updates, patches, and licenses.• Maintains subject matter expertise in databases, including the knowledge, skills, and desire to optimize the use of all features of the solutions to maximize their benefit to the College.• Accountable for the expert installation, configuration, and maintenance of databases on servers along with images to be installed on desktops.• Administers user access to data or works with Technology Support team to create and maintain access according to the College's policies and procedures, creating, changing and deleting user access and accounts per request.• Monitors, responds to, and mitigates security threats related to data in collaboration with the College's cybersecurity experts.• Manages the backup, storage, and restoration of configurations, access, and data related to database solutions in accordance with the College's policies and procedures.• Ensures restores from backed up systems are possible.• Creates and maintains database documentation, such as systems diagrams and configurations, processes and procedures.Support and Consulting: 20%• Creates, manages, and facilitates relationships with key users of database solutions in use at the College.• Expertly consults with key users to create clear expectations and requirements documents prior to configuration or customization of databases.• Addresses issues at their root level, using creative problem-solving techniques to achieve high-quality, highly efficient, highly effective resolutions.• Proactively identifies potential issues and resolves them before they become an issue.• Appropriately escalates issues to vendors and other College teams after an appropriate time or when issues require further expertise.• Able to interact positively with both internal and external partners to achieve high satisfaction in both consulting and problem resolution situations• Accurately documents and maintains all support requests and efforts in the ticket management system.• Ensures support tickets are appropriately transferred, escalated, and closed.• Keeps customers updated on the status of their open incidents.• Ensures that customers are satisfied upon ticket closure.Project Management: 20%• Manages consultants and their performance on projects that make use of third party consultants.• Able to manage multiple projects at once.• Executes project plans according to schedule, with attention to communication, risk management, training, and ongoing support and maintenance; setting and meeting expectations for project progress and completion; and ensuring that project deliverables are complete, sufficient, and of high quality.• Manages implementation of technology solutions, including the following elements:o Architecture and Designo Stakeholder communicationo Risk management• Qualities of service, such as Security, Accessibility, Performance, Availability, Disaster Recovery and Business Continuity, Manageability, and Monitoring.• Ongoing budget Education and training Support Identifies, categorizes, and prioritizes the College's database needs, and researches, assesses, selects, acquires, and implements technology solutions that best satisfy those needs.Other: 10%• Keeps track of and manages hardware and software maintenance agreement to ensure optimal value of database solutions to the College.• Manages solution providers and vendors according to a balanced scorecard to ensure high levels of collaboration, performance, and value.• Participates in user groups associated with database solutions administered by the position in such a way as to maximize knowledge of strategic leverage of the solutions, value from the solution and its provider, and skills for performing solution administration.• Maintains and shares subject matter expertise, staying current on industry trends and emerging technologies, identifying opportunities for further research, establishing and maintaining relationships with industry and professional colleagues, and attending conferences and seminars in order to recommend new solutions in service of student success and faculty and staff effectiveness and efficiency, while enhancing systems design, usage, security, performance, and availability.• Provides a consistent stream of new ideas to enhance the College's systems.• Assists in the development of IT processes and procedures.• Proactively works with members of other departments to identify and implement key opportunities for operational improvements, especially with regards to processes and leverage of data/information.• Performs other duties of a similar nature or level.MINIMUM QUALIFICATIONS - The following qualifications are required:• Masters Degree with three years of experience in an Information Technology role, at least three of which were in a role specific to this discipline OR Bachelors Degree with six years of experience in an Information Technology role, at least four of which were in a role specific to this discipline OR Associate's Degree with ten years of experience in an Information Technology role, at least six years of which were in a role specific to this discipline• Fundamental level understanding of the design, maintenance, and administration of relational databases.• Fundamental level understanding of physical and logical database design in an enterprise database platform.• Fundamental level understanding of of SQL performance analysis and tuning, log shipping, replication, SQL clustering, scalability and reliability issues, Transact-SQL scripting, SQL Server Integration Services (SSIS/DTS), SQL Server Reporting Services, bulk copy programs (BCP), and Open Database Connectivity (ODBC).• Knowledge of performance tuning, backup & recovery methods in DB2 & SQL Server platforms.• Effective and polished verbal and written communication skills• Ability to work effectively with a wide range of customers and a focus on diversity, equity, and inclusion• Committed to keeping up-to-date with the ever-changing technology landscape.• Reflect a positive, high-energy and professional demeanor• Demonstrated ability to work well on and improve the performance of a team• Demonstrated ability to prioritize and deliver according to deadlines while handling multiple tasks, ability to exercise judgment, handle confidential information, and function with minimal supervision• Demonstrated excellent organizational abilities and attention to detail• Ability to cogently explain technical concepts and procedures to non-technical users• Ability to problem-solve, analyze information to make informed decisions and/or recommendations• Ability to apply principles of logical thinking to a wide range of intellectual and practical problems.• Ability to work nights and weekends as needed.MINIMUM QUALIFICATIONS - The following qualifications are required:• Masters Degree with three (3) years of experience in an Information Technology role, at least three (3) years of which were in a role specific to this discipline OR Bachelors Degree with six (6) years of experience in an Information Technology role, at least four (4) years of which were in a role specific to this discipline OR Associate's Degree with ten (10) years of experience in an Information Technology role, at least six (6) years of which were in a role specific to this discipline• Fundamental level understanding