Skip to Main Content

DATABASE SPECIALIST II

Recruitment #21-004480-0008

Introduction

The Maryland State Retirement Agency (MSRA) administers the Maryland State Retirement and Pension System (MSRPS). The System is a multi-employer, public employees’ defined benefit retirement system supporting over 400,000 active members, retirees, and beneficiaries.

The Agency is involved in a multi-year re-engineering of its business processes, acquiring and integrating support technologies (e.g., member relationship management, document management, workflow management) and adapting existing pension administration programs to support secure online real-time transaction processing. In addition, the Agency manages a $55 billion trust fund, invested globally, the management of which is also undergoing considerable change.

This is an exciting time to join MSRA's technology team in this critical Systems Development unit position.

If you are a qualified technology professional, here’s what MSRA has to offer:

· Professional development opportunities

· Work with new technologies in a challenging environment

· Working in an organization that fosters continuous improvement, teamwork and cooperation

· Work only a few blocks from Baltimore’s Inner Harbor, convenient to Metro, Light Rail and busses (all at no charge to State Employees in the Baltimore metro area)

Enjoy other State of Maryland employee benefits.

GRADE

18

LOCATION OF POSITION

Maryland State Retirement Agency

120 East Baltimore Street,  Baltimore, Maryland 21202

POSITION DUTIES

This position provides senior technical knowledge and support in the Agency's Information Systems Division - a team that enjoys a positive and constructive reputation for getting work accomplished using Agile methods and current toolsets and practices. The incumbent provides specialized expertise in relational database management systems and programming to design, develop, and maintain the pension administration management systems used to support Agency staff, over 130 employers statewide, and pension plan participants. The incumbent also provides IT staff with support in product knowledge, resolving design and performance issues, and general troubleshooting. This position impacts Agency day-to-day operations and has collaborative interaction and visibility at all levels of the organization.

 

Responsibilities include: Monitoring scheduled SQL Agent job completion and SQL Server health (space, performance, availability, other metrics); Troubleshooting and resolving issues; Assisting developers with T-SQL code and database design appropriateness; Reviewing developer T-SQL code and SSRS Reports for quality, efficiency, security and suggesting improvements where appropriate; Assisting in reviewing database permissions for compliance with policies and best practices; Assisting with requested database restores; Assisting auditors and managers with database-related information requests; Assisting with reviewing and promoting database changes through the development environments (Development, Test, Staging, Production); Other duties assisting the Database Administrators.

MINIMUM QUALIFICATIONS

Education:   A Bachelor's degree from an accredited college or university in Computer Information Technology, Management Information Systems, Computer Science or other information technology related field to include course work in database management systems.

Experience: One year of experience designing, developing, implementing, maintaining and controlling database management systems for computers.

Notes:

1. Candidates may substitute graduation from an accredited high school or possession of a high school equivalency certificate plus thirty credit hours from an accredited college or university in Computer Information Technology, Management Information Systems, Computer Science or other information technology-related field to include course work in database management systems for the required education.

2. Candidates may substitute graduation from an accredited high school or possession of a high school equivalency certificate and one additional year of experience designing, developing, testing, implementing and maintaining applications systems and programs using generally accepted computer programming languages or maintaining and modifying operating systems for computers for the required education.

3. Candidates may substitute possession of experience operating computer systems; or scheduling, controlling input and output or maintaining a tape library to process data on computer systems; or converting data from project specifications by developing program code using generally accepted computer programming languages on a year-for-year basis for high school education.

4. Candidates may substitute U.S. Armed Forces military service experience as a commissioned officer in Database Administration classifications or Database Administration specialty codes in the Information Technology field of work on a year-for-year basis for the required education.

SELECTIVE QUALIFICATIONS

Applicants must meet the selective qualification(s) to be considered. Include clear and specific information on your application regarding your qualifications.

 

1. Training and experience maintaining and optimizing Microsoft SQL Server databases.

2. Training and experience in maintaining IT security at the database level. 

3. Training and experience writing and maintaining SQL/Transact-SQL (T-SQL) code. 

DESIRED OR PREFERRED QUALIFICATIONS

Preference will be given to applicants who possess the following preferred qualification(s). Include clear and specific information on your application regarding your qualifications.

 

1. Experience with large relational database systems (e.g. hundreds of gigabytes, tens of thousands of                records, multiple databases, cross-database relationships.)

2. Experience developing, monitoring and maintaining SQL Server Agent jobs, preferably including utilizing        multi-server jobs (MSX). 

3. Experience with MS SQL Server Always On Availability Groups. 

4. MCSA or MCSE Certifications on Microsoft SQL Server Databases

5. Experience developing, configuring, and administering MS SQL Server Power BI Report Server on-                premises implementations.

6. Experience developing, configuring, and administering MS SQL Server Integration Services (SSIS) and          MS SQL Server Reporting Services (SSRS) implementations.

SPECIAL REQUIREMENTS

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

Due to confidential nature of the work, selected candidates must undergo and pass a background check.

SELECTION PROCESS

Please make sure that you provide sufficient information on your application to show that you meet the qualifications for this recruitment. All information concerning your qualifications must be submitted by the closing date. We will not consider information submitted after this date. Successful candidates will be ranked as Best Qualified, Better Qualified, or Qualified and placed on the eligible (employment) list for at least one year.

EXAMINATION PROCESS

The assessment may consist of a rating of your education, training, and experience related to the requirements of the position. It is important that you provide complete and accurate information on your application. Please report all experience and education that is related to this position. 

For education obtained outside the U.S., a copy of the equivalent American education as determined by a foreign credential evaluation service must be provided prior to hire.

BENEFITS

FURTHER INSTRUCTIONS

Please enclose/upload a resume and cover letter with the application (required). Resumes will NOT be accepted in lieu of completing the application, however – you must do both. Also, enclose/upload any related certifications.

The online application process is STRONGLY preferred. If online access is not available, you may mail a paper application and supplemental questionnaire (if applicable) to:

DBM Recruitment & Examination Department

301 West Preston Street, Room 608

Baltimore, MD 21201

All mailed documents must include the applicant's name and the job number and must be received by the closing date. Resumes will NOT be accepted in lieu of completing the application. If you have any questions concerning the recruitment process for this position, please call 410-767-2584.

We thank our Veterans for their service to our country and encourage them to apply.

TTY Users: call via Maryland Relay

As an equal opportunity employer, Maryland is committed to recruiting, retaining and promoting employees who are reflective of the State’s diversity.

People with disabilities and bilingual candidates are encouraged to apply.




Powered by JobAps