State of Maryland

A State Retirement Agency (SRA) Database Administrator Trainee is the entry level of work responsible for data persistence systems utilizing the appropriate best practice, tools, and technologies. Employees learn to create secure, optimized, stable, scalable, and recoverable designs 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 close supervision from an 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 SRA Database Administrator Trainee, SRA Database Administrator I and SRA Database Administrator II are differentiated based on the degree of supervisory control exercised by the supervisor over these employees. The SRA Database Administrator Trainee performs the duties under close supervision. The SRA Database Administrator I performs the duties under close supervision at times, and under general supervision at other times, depending on the complexity of the specific duty being performed. The SRA Database Administrator II performs the full range of duties and responsibilities under general supervision.

Learns to administer and support multiple databases of varying complexity;

Learns to maintain database user base by regulating appropriate levels of roles and access;

Learns to control server and database security by proper system configurations;

Learns to implement backup and recovery procedures for database instances;

Learns to support successful execution of data workflows using database technologies;

Learns to develop strategies for protecting Personally Identifiable Information (PII), Personal Health Information (PHI), and

Federal Tax Information (FTI) using encryption in transit and at rest;

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

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

Learns to promote adherence to data persistence best practice;

Learns to perform 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: None.

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.

Employees in this classification are eligible to receive overtime compensation. An employee who works more than the normal workweek is entitled to be compensated for that overtime, as provided by the State Personnel and Pensions Article, Section 8-305.

This classification is one level in a Non-Competitive Promotion (NCP) series. NCP promotions are promotions by which employees may advance in grade and class level from trainee to full performance level in a classification series. In order to be non-competitively promoted to the next level in a NCP series, an employee must: 1) perform the main purpose of the class, as defined by the Nature of Work section of the class specification; 2) receive the type of supervision defined in the class specification and 3) meet the minimum qualifications of the classification.