Skip to Main Content

Powered by JobAps

DATABASE SPECIALIST II

Recruitment #22-004480-0002

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

Main Purpose of Job

The main purpose of this position is to plan, design, develop, implement, maintain and control database management systems for computers. Frequently, the role requires hands-on participation in all elements of a full life-cycle development process.

POSITION DUTIES

The main purpose of this position is to plan, design, develop, implement, maintain and control database management systems for computers. Frequently, the role requires hands-on participation in all elements of a full life-cycle development process.

This position provides 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. This position impacts Agency day-to-day operations and has collaborative interaction and visibility at all levels of the organization.

 

Responsibilities include: Monitoring SQL Agent job completion and SQL Server health (space, performance, availability, other metrics); Troubleshooting and resolving issues; Reviewing developer T-SQL and SSRS/Power BI Report code for quality, efficiency, and security, and suggesting appropriate improvements; Assisting developers with T-SQL code and database design, with database permissions for compliance with policies, appropriateness and best practices; with requested database restores, with auditors’ and managers’ database-related information requests, with SSIS package/project deployment, and with reviewing and promoting database changes through the development environments.

MINIMUM QUALIFICATIONS

Experience: Two years of experience, one year of experience designing, developing, implementing, maintaining and controlling database management systems for computers 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.

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 one additional year of the required experience.

2. 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 graduation from an accredited high school or possession of a high school equivalency certificate.

3. Candidates may substitute the possession of 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 and one year of experience designing, developing, implementing, maintaining and controlling database management systems for computers for the required experience.

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 experience. 

SELECTIVE QUALIFICATIONS

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

Two years of experience with routine SQL Server maintenance  

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. 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. 
2. Experience backing up and restoring Microsoft SQL Server databases 
3. Experience in developing complex Transact-SQL (T-SQL) code 
4. MCSA or MCSE Certifications on Microsoft SQL Server

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.

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.



Click on a link below to apply for this position:

Fill out the Supplemental Questionnaire and Application NOW using the Internet. Apply Online
View and print the Supplemental Questionnaire. This recruitment requires completion of a supplemental questionnaire. You may view and print the supplemental questionnaire here.
Apply via Paper Application. You may also download and complete the Paper Application here.