Designs, develops, maintains, monitors, and supports integrated database management systems of moderate to high complexity and scale.
This class is intended for use as a senior level role that designs, develops, maintains, monitors, and supports integrated database management systems (DBMS) of medium complexity. This role may oversee and provide leadership to the Database Administrator I role, and may assist with work of higher complexity under the supervision of the Senior Database Administrator role.
Assists in developing long term strategic plans and budgets. Assists in developing 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 a comprehensive and integrated data architecture that supports organizational needs. Plans and manages projects of diverse scopes, complexity, and timeframes. Develops, implements, and administers moderately complex data management systems through effective analysis, planning, modeling, schema design, and normalization. Collaborates with end-users, technical staff/teams, and management in the production of integrated data-driven applications and effective data exchange and automation between systems. Determines 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. Integrates database systems with business systems, applications, and diverse consumers and producers of data, across multiple platforms and computing environments. Ensures data accuracy and integrity through the development of QA/QC procedures and data standards. Ensures data security and protection through the application of data classification, user/group management, access controls, authentication, authorization, accounting, logging, auditing, backup, business continuity, and disaster recovery procedures. Develops SQL queries, views, joins, relationships, indexes, constraints, triggers, transactions, stored procedures, and prepared statements as needed by application developers and data consumers. Derives summarized, filtered, or transformed data for output, export, or reports as requested by end-users and other business needs. Performs database CRUD (Create, Read, Update, Delete) operations. Performs data validation, integrity checking, escaping, quoting, encoding, cleanup, and reformatting of unstructured data during import and export operations. Develops and maintains database and systems documentation, metadata, data dictionary, and technical specifications. Monitors, audits, measures, and optimizes data management system performance to ensure suitable concurrent data availability to all customers. Optimizes performance of database servers (storage, hardware, and operating system) and the database management system through performance tuning and schema design improvements. Develops procedures and scripting automation for attended, unattended, and scheduled maintenance and operation of database systems.
Skill in the development, implementation, and administration of moderately complex data management systems through effective analysis, planning, modeling, schema design, and normalization. Functional 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.). Strong 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. Skill in developing SQL queries, views, joins, relationships, indexes, constraints, triggers, transactions, stored procedures. Skill in performing database CRUD (Create, Read, Update, Delete) operations; and in data validation, integrity checking, escaping, quoting, and encoding. Skill in utilizing data warehouse tools for reporting, visualization, data extraction, cleaning, transformation, loading, and refreshing. Skill in the use and management of the operating system, storage, and network technologies supporting the database environment. Proficient in the use of CLI utilities and scripting for maintenance, management, and automation. 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.