State of Maryland

A State Retirement Agency (SRA) Database Administrator III is the lead or advanced level of work responsible for data persistence systems utilizing the appropriate best practice, tools, and technologies. Employees provide secure, optimized, stable, scalable, and recoverable design and implementations of database instances. Database Administrators interact with other Database Administrators, Database Developers and Software Engineers. They may also be required to collaborate with stakeholders and contributors on project activities. Employees in this classification do not supervise other positions.

Employees in this classification receive general supervision from a SRA Database Administrator Manager.

Positions in this classification are evaluated using the classification job evaluation methodology, which involves comparing the assigned duties and responsibilities of a position to the job criteria found in the Nature of Work and Examples of Work sections of this classification specification.

The Database Administrator III is differentiated from the Database Administrator II in that the Database Administrator III either assigns, reviews and approves the work of and trains SRA Database Administrators or participates in planning for long term database system solutions and upgrade strategies with directed research. The Database Administrator III is differentiated from the Database Administrator IV in that the Database Administrator IV performs expert level of work and participates in planning for long term databases system solutions and upgrade strategies with directed and non-directed research.

When functioning at the Lead Level:

Assigns, reviews and approves the work of lower-level SRA Database Administrators;

Trains lower-level SRA Database Administrators;

When functioning at the Advanced level:

Participates in planning for long term databases system solutions and upgrade strategies with directed research;

When functioning at both levels:

Administers and supports multiple databases of varying complexity;

Maintains database user base by regulating appropriate levels of roles and access;

Controls server and database security by proper system configurations;

Implements backup and recovery procedures for database instances;

Supports successful execution of data workflows using database technologies;

Develops strategies for protecting Personally Identifiable Information (PII), Personal Health Information (PHI), and Federal Tax Information (FTI) using encryption in transit and at rest;

Deploys and maintains SQL (structured query language) and NoSQL(not only SQL) database systems, which may be on-premises, hybrid or in the cloud;

Participates in development of Information Technology (IT) policies, security controls, and disaster recovery;

Promotes adherence to data persistence best practice;

Performs other related duties.

Knowledge of data administration and data standardization policies;

Knowledge of relational and NoSQL databases;

Knowledge of data mining and data warehousing principles;

Knowledge of database management systems, query languages, table relationships, and views.

Knowledge of query languages such as SQL;

Knowledge of sources, characteristics, and uses of the organization’s data assets;

Knowledge of line-of-business programs, their respective missions, and the role of information technology;

Skill in using relational database management toolkits and developing stored procedures;

Skill in allocating storage capacity in the design of data management systems;

Skill in conducting queries and developing algorithms to analyze data structures;

Skill in integrating database accounts with domain accounts, such as via Active Directory;

Skill in tuning enterprise databases to achieve optimum performance levels;

Skill in delivering solutions and achieving outcomes via IT;

Ability to analyze organizational needs, architect business solutions, and monitor/administer systems/software to optimize performance;

Ability to use acquired institutional knowledge to achieve organizational efficiencies;

Ability to trace and diagnose database performance issues;

Ability to mentor and provide guidance for staff performing data extractions and queries.

Education: Graduation from an accredited high school or possession of a high school equivalency certificate.

Experience: Four years of experience administrating, maintaining, and managing databases in SQL or NoSQL contexts utilizing supporting technologies.

Notes:

1. Candidates may substitute a Bachelor's degree from an accredited college or university in Information Technology, Computer Science, Management Information Systems, or other information technology related field for up to two years of the required experience.

2. Candidates may substitute an Associate’s degree from an accredited college or university in Information Technology, Computer Science, Management Information Systems, or other information technology related field for up to one year of the required experience.

3. Candidates may substitute six credit hours of coursework in data persistence and development using generally accepted computer programming languages or other developmental tools for six months of the required experience.

4. Candidates may substitute experience in one of the following areas: operating computers, scheduling, controlling input and output or maintaining backups or data storage, processing data on computers, evaluating, implementing, and maintaining hardware and software, on a year-for-year basis for the required education.

5. Candidates may substitute U.S. Armed Forces military service experience in Data Persistence Programming classifications or Data Persistence Programming specialty codes in the Information Technology field of work on a year-for-year basis for the required experience and education.

Employees in this classification may be subject to call-in 24 hours a day and, therefore, may be required to provide the employing agency with a telephone number where the employee can be reached. Employees may be furnished with a pager or cell phone.

Applicants for this classification may handle sensitive data. This will require a full scope background investigation prior to appointment. A criminal conviction may be grounds for rejection of the applicant.

Employees may occasionally be required to travel to field locations and must have access to an automobile in the event a state vehicle cannot be provided. Standard mileage allowance will be paid for use of a privately owned vehicle.

Class specifications are broad descriptions covering groups of positions used by various State departments and agencies. Position descriptions maintained by the using department or agency specifically address the essential job functions of each position.

This is a Skilled Service classification in the State Personnel Management System. All positions in this classification are Skilled Service positions. Some positions in Skilled Service classifications may be designated Special Appointment in accordance with the State Personnel and Pensions Article, Section 6-405, Annotated Code of Maryland.

This classification is not assigned to a bargaining unit, as indicated by the designation of S (Supervisor), M (Manager), T (Agency Head), U (Board or Commission Member), W (Student), X (Used by Agency or Excluded by Executive Order), or Z (Confidential). As provided by State Personnel and Pensions Article, Section 3-102, special appointment, temporary, contractual, supervisory, managerial and confidential employees are excluded collective bargaining. Additionally, certain executive branch agencies are exempt from collective bargaining and all positions in those agencies are excluded from collective bargaining.