Database Administrator III

Database Management And Support

Under the general supervision of the Development, DBA, and Middleware Supervisor, this position provides advanced-level database management and support for the smooth and efficient delivery of highly complex, multi-platform mainframe and web-based business applications and systems. Our DB2 and SQL Server databases are expected to be available 24x7x365 and need to function reliably and securely. Management and support of the databases includes providing system administration, consulting, technical support and advanced-level data and database coordination between the application development teams and the Division of Enterprise Technology at the Department of Administration. Supported technologies and tools include but are not limited to DB2, SQL Server 2019, Squirrel, SQL, Ivanti, Jira, JCL, Windows, and other emerging tools.

This position performs work related to all phases of the systems development life cycle for database management, which includes analyzing and documenting current business processes, planning, requirements elicitation, design, development, testing, implementation, and maintenance. This position is expected to provide a high degree of support for the delivery of high-quality applications and associated end-products through cost-effective and efficient management of the database platform used by ETF’s application portfolio. This position coordinates and leads technical teams through the process for troubleshooting, recovering, adjusting, and modifying or enhancing automating of database integrations and data management within applications. This position acts as a liaison to provide expertise to technical staff and DET when problems arise with databases and as necessary will develop technical user instructions. This position initiates and effectively communicates with department development and infrastructure staff and other stakeholders; provides training direction for technical staff regarding the database platforms; and consults with technical staff to provide expert, specialized guidance for the use, input, and output of technology systems.

This position provides operational and project support services to developers and business intelligence and security teams for new application development and/or the enhancement or maintenance of application database. This includes developing the data model for transactional systems and the integration of existing databases with modernization efforts. This position is a participating member of operational projects within the Database team and is expected to partner with technology system and business system experts, the Office of Enterprise Initiatives (OEI), Data Management Bureau (DMB), the Bureau of Security Management (BISM) and ETF business analysts to lead, plan, and coordinate efforts related to assigned systems and processes, both automated and manual, throughout the department. Additionally, this position will assist with the research and analyzing of data as part of modernization efforts.

As an employee of ETF, the incumbent will support and create a diverse and inclusive work force.

Goals And Activities

45% GOAL A. Plan, coordinate, oversight of ETF’s database platform, including monitoring and tuning for performance and efficiency, upgrading, testing, backing up, recovery, etc.

• Provide ongoing monitoring of databases for performance, and tune databases as necessary.
• Evaluate reorganization, recovery, and restart needs for databases. Maintain table backups to ensure adequate recovery.
• Coordinate with DOA/DET, ETF and vendors the testing of new releases of database software, performance monitoring tools, utilities, and other database tools.
• Perform as ETFs technical lead with DOA/DET efforts to upgrade the database platform and patching. Keep current with new releases of database related software and implement new features as appropriate.
• Develop project and technical architecture review documentation that will flow through the governance process, recommending technology solutions and services, and configuration standards and best practices.
• Provide technical and subsystem-specific consultation and recommendations to technical and vendor staff modernization efforts. Interact with technical support, operations, and vendor staff to ensure coordination of changes with project team efforts.
• Provide expert consultation to determine, implement and support the standard database tools in cooperation with agency technical staff, technical architects, and other programmers.
• Investigate, recommend, and implement ETF, DET-mandated and vendors database security methods.
• Monitor ETF, DET, and other state agency technology choices and trends in IT hardware and software and consult with appropriate ETF staff on the impacts of those decisions.
• Participate in management and peer group reviews to ensure system quality and the development of tactical and strategic roadmaps.
• Continually improve operations by evaluating processes and automating them where possible.

Development of actionable key performance indicators (KPI’s), including setting goals and objectives, collecting measures, and calculating metrics.

Perform custom file maintenance to databases objects as necessary.

25% GOAL B. Perform administration, consultation, innovation, system maintenance and support in the design, integration, operations, and modernization of ETF’s database platform.

• Implement, manage, and support the enterprise database platform(s) in cooperation with agency technical staff, technical architects, and other DBAs. Respond promptly to system malfunctions and issues with the databases; documenting the problem and resolution within the ETF Incident and Request systems.
• Provide expertise to complete logical and physical data designs for data services.
• Provide expert consultation to developers and more junior database administrators regarding database platforms and software.
• Evaluate database requirements and create new, or alter existing, database structures.
• Provide leadership, support and design activities for data warehouse and business intelligence platforms
• Provide consultation and implementation services for data conversion.
• Lead the establishment and administration of database policies, procedures, and standards.
• Research, evaluate, and select new technology services and solutions as part of supporting and managing the database platform(s).
• Perform complex research and analysis of technical architecture issues that impact the functionality and management of the database platform including the review and verification of technical feasibility and security as well as the performance impact of new and innovative technologies.
• Perform custom file maintenance to databases objects as necessary.
• Perform prime-shift and non-prime shift on-call support as directed.

20% GOAL C. Provide research, analysis, and reporting with regards to data in legacy systems and the conversion and/or migration of data as part of modernization following ETF and state standards, policies, and best practices.

• Perform research and analysis of existing data structures to identify and report on the data they contain. When needed automate the on-going reporting of data analysis.
• Consult with IT staff and business users on data research, analysis, and reporting requirements.
• Facilitate the diagnoses and resolution of complex data problems.
• Analyze alternative methods of meeting business requirements to determine the most feasible and cost beneficial method of meeting the requirements.
• Perform data conversion from existing automated or manual systems to new ones to provide continuity of business functions and avoid unnecessary disruption.

10% GOAL D. Participation in training and employee development, performance of special assignments provision of training and assistance, and miscellaneous duties as assigned

• Stay up-to-date on database and development processes and modern technologies utilizing web resources, online training, books, internal documents, training sessions and workshops.
• Participate in activities of professional and technical associations to contribute to the development in the IT industry and in various agencies of government.
• Orient new employees to database standards, procedures, policies, and practices.
• Represent management on task forces and committees to respond to state and agency needs, interacting with staff in other agencies as required.
• Carry out special assignments that meet the needs of the agency.
• Prepare special reports or documents as requested.
• Additional duties as assigned.

Knowledge, Skills, and Abilities

• Advanced skills and knowledge of the administration, configuration, and maintenance of SQL Server databases, SSMS, SSRS such as T-SQL, Squirrel, etc.
• Advanced knowledge of logical and physical data modeling techniques and methods.
• Knowledge of data modeling tools such as Erwin, SQL Developer, etc.
• Knowledge of the uses and applications of stored procedures.
• Knowledge of structured application development and design methods.
• Knowledge and skills with incident, problem, and change management principals and software such as Ivanti, Cherwell, SharePoint, or Jira.
• Knowledge of application test methodologies and procedures.
• Knowledge of skills and knowledge of the administration, configuration, and maintenance of mainframe DB2 and tools such JCL, CICS, Control-M, etc.
• Knowledge of source code repositories such as GitHub
• Knowledge of monitoring tools such as AppDynamics
• Advanced ability to work on a team, create favorable experiences, and share information and expertise.
• Advanced ability to learn and work independently.
• Strong innovation skills with the ability to analyze and evaluate system modifications to ensure that accurate specifications are met.
• Advanced ability and willingness to