Designs, develops, maintains, and monitors integrated data management systems of very high complexity and scale.
This class is intended for use as a senior-level role that directs, plans, designs, develops, and implements integrated database management systems (DBMS) of very high complexity, critical availability, and of enterprise, cross-enterprise, or cloud-scale. This role may oversee and provide leadership to Senior Database Administrators and others.
Develops and directs long term strategic plans and budgets. Works across technical and stakeholder disciplines to understand and develop comprehensive data management strategies and technologies at and across enterprise, state, or cloud scales. Develops standards, specifications, policies, and procedures related to integrated data management systems. Evaluates, analyzes, and normalizes data sources, complex business rules and processes, technical systems, data requirements, information needs, and data delivery requirements to develop comprehensive and integrated data architectures that support the needs of agencies. Evaluates organizational readiness, future needs, and shifts in prevailing technologies to proactively plan for an organization’s future with respect to data management. Directs projects of large scope, high complexity, and often challenging timeframes. Plans, develops, and implements highly complex data management systems through effective analysis, planning, modeling, schema design, and normalization. Selects appropriate database technologies, models, and storage architecture to ensure that database systems maintain data integrity and are effective, secure, flexible, efficient, performant, reliable, maintainable, available, and scalable. Directs the integration of databases and data warehouses systems with business systems, applications, and diverse consumers and producers of data, across multiple platforms and computing environments. Ensures data security and protection through the selection and implementation of appropriate data classification systems, credential management systems, access controls, auditing, business continuity, and disaster recovery procedures. Directs the monitoring, auditing, optimizations, enhancements, and optimization of data management systems to meet or exceed performance and availability goals.
Skill in the development, implementation, and administration of highly complex integrated data management systems through effective analysis, planning, modeling, schema design, and normalization. Extensive knowledge of and ability to select appropriate database models (e.g., SQL/relational, data warehouse, NoSQL, object, graph, Entity–attribute–value model, etc.), and database storage and connectivity architectures (client-server, distributed, cloud, file-based/embedded, etc.). Extensive knowledge of and ability to perform data security and protection techniques including data classification, user/group management, access controls, authentication, authorization, accounting, logging, auditing, backup, business continuity, and disaster recovery procedures. Ability to develop and manage data warehouse systems for data analysis, data mining, business intelligence, predictive analytics, machine learning, artificial intelligence, and other advanced types of analysis. Extensive knowledge of diverse data management and warehouse management systems, networking, storage, and data center technologies. Ability to communicate clearly and effectively to technical and nontechnical audiences verbally, through presentations, and through the preparation of documentation and reports. Ability to establish positive working relationships with others and to train and supervise staff in the design and support of database management systems.
A bachelor's degree in computer science, information systems or a related field and experience in systems development and maintenance, technical support, or the support of complex database management systems. Related experience may substitute for the bachelor's degree on a year-for-year basis.