Designs, develops, maintains, monitors, and supports databases of low to moderate complexity and scale.
This class is intended for use as an intermediate level role that designs, develops, maintains, monitors, and supports database management systems (DBMS) of low complexity. This role may oversee and provide leadership to the Database Specialist role, and may assist with work of higher complexity under the supervision of the Database Administrator II role.
Evaluates, analyzes, and normalizes data sources, business rules and processes, technical systems, data requirements, information needs, and data delivery requirements to develop database systems that support organizational needs. Develops, implements, and administers low complexity data management systems through effective analysis, planning, modeling, schema design, and normalization. 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, and available. Ensures data accuracy and integrity through the application 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. Collaborates with end-users, technical staff, and management in the production of integrated data-driven applications and effective data exchange and automation between systems. 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/export operations. Develops and maintains database and systems documentation, metadata, data dictionary, and technical specifications. Develops procedures and scripting automation for attended, unattended, and scheduled maintenance and operation of database systems.
Skill in the development, implementation, and administration of low to moderately complex database systems through effective analysis, planning, modeling, schema design, and normalization. Skill in developing SQL queries, views, joins, relationships, indexes, constraints, transactions; in performing database CRUD (Create, Read, Update, Delete) operations. Skill in data validation, integrity checking, escaping, quoting, and encoding. Functional knowledge of data security and protection techniques including data classification, user/group management, access controls, authentication, authorization, backups, business continuity, and disaster recovery procedures. Ability to utilize basic data warehouse tools for reporting, visualization, and data extraction. 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 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.
A high school diploma and work experience in systems development and maintenance, technical support, or the support of database management systems. A bachelor's degree in a related field may substitute for the required experience.