Skip to Main Content

IT ASSISTANT DIRECTOR II

SQL Server Senior DBA (DataBase Administrator)

Recruitment #15-004491-0001

Introduction

This is a position specific recruitment. The resulting list of eligible will be used to staff this position or function only. This list will be maintained for one year. You will need to reapply for any future recruitment for this job classification.

GRADE

21

LOCATION OF POSITION

1100 North Eutaw Street (Baltimore City)

Main Purpose of Job

This position supervises and manages, directs, organize the planning, data analysis, design and implementation of databases used within the DLLR. The incumbent is further responsible for assuring that the logical and physical data bases are designed and maintained to perform efficiently, effectively and accurately, with a minimum amount of resources to meet the programmatic needs of the division and to provide management with reliable information to make business decisions.

The key responsibilities of this position include but are not limited to the following:

 ·         Physical database design, construction, & implementation using current database technology

  ·         Collaborative design & development with programmers and business analysts

 ·         Problem analysis, diagnosis, and implementation of resolutions

 ·         Performance monitoring & tuning

 ·         On-call support for production systems, job streams, and processes

 ·         Database backup (archive) & recovery

 ·         Business continuity planning

 ·         Capacity planning, monitoring, and upgrade implementation

 ·         Software upgrade planning and implementation

POSITION DUTIES

Management - Manage and direct a team of data processing professionals engaged in a variety of technical functions. This includes: establishing work assignments, reviewing accomplishments, establishing an education plan, approving vacations and performance appraisals.

 Design,  Maintenance and Implement the logical and physical data models  and a DB2 Management System (DBMS) and SQL environment; including: Review and approve changes to data base design; evaluate the impact on systems; evaluate costs associated with changes to ensure that the performance of the system is not adversely affected; Code database descriptions and identifiers to the DBMS; Generate  required database objects necessary to effect a change; enforce standard  change control process for migration through testing and implementation in production; responsible for backup, recovery and reorganization of all production databases;  evaluate  the effect of re-design on other systems that interface with DLLR; Responsible for the establishment of referential integrity in the DBMS and the solution of any problems associated with the DBMS; Recognizes any database design that could result in a costly hardware/software upgrades or would not meet current hardware restraints.

Communication: Consults and interacts with the client community to assure all system goals are met. Consults or interacts with application analyst in program development and maintenance of existing systems

Budgeting and Procurement: Provide budget input regarding this position. Provide input into the procurement of hardware/software purchases used for databases for the department. Perform cost analysis of databases software and databases utility software. Security Administration: Security administrator for production data; establishes, maintains and enforces all security    relating to the DBMS; sets standards and policies relating to the DBMS production security access.

Performance and Tuning: Work with the database performance monitoring tools. Evaluate all adverse results and make recommendations regarding database performance.

MINIMUM QUALIFICATIONS

Education: Bachelor s degree from an accredited college of university in Computer Information Technology, Management Information  Systems, or other information technology-related field to include course work in local or wide area microcomputer or minicomputer networks.

Note:  Applicants may substitute graduate education in computer science or in directly related fields on a year by year basis for up to one (1) year of the required experienced OR:  Applicants may substitute additional management and/or supervisory experience as defined above at the rate of one (1) year of experience for one (1) year of education for up to two (2) years of the required college education.

 Education credentials from foreign countries must be evaluated by an approved education review service.  For further information, you may call the international Consultants of Delaware, Inc. at (302) 737-8715 or World Education Services at 1 (800) 331-2925.  The evaluation must be submitted with the application.

 Experience: 

·         3+ years of experience as a Senior Database Administrator (DBA) in Microsoft SQL Server and/or IBM  DB2 with experience in high availability, backup and recovery

·         4+ years of experience in a previous leadership position required (supervisor, manager, or project manager) Excellent leadership skills and the ability to provide technical direction to team members

·         6+ years of experience of working in Microsoft SQL Server and/or IBM DB2 environment

 ·         6+ years of experience of working in Microsoft Windows Server environment.

DESIRED OR PREFERRED QUALIFICATIONS

         Advanced knowledge of Windows Operating Systems

·         Proficiency with SQL and PowerShell scripting

·         Knowledge of DB2 in IBM Z/OS environment

 ·         Solid knowledge of database security features : Audit, user access restrictionCertifications in SQL Server and/or Microsoft technologies 

 ·         Written / Authored Documents Scope, Design --Project Planning (Budget, Other resources, Risk Management, Data Management, Schedule, Stakeholder Involvement) and MS Project

SPECIAL REQUIREMENTS

All candidates are subject to a background check against files maintained by the Division of Unemployment Insurance (DUI) to determine whether any monies are owed to DUI as a result of unemployment insurance overpayment and/or fraud.  Any unpaid debt may have an impact on whether or not a candidate is offered employment.

SELECTION PROCESS

Applicants must provide sufficient information on the application  to show they meet the qualifications for this recruitment.  All information concerning the qualifications, including submittal of any required documentation (diplomas, transcripts, certificates, licenses, etc.) must be submitted and received by the closing date. Failure to submit the required documentation will result in the application being disapproved. Documentation, information, or material submitted after this date will not be considered.  RESUMES ARE NOT ACCEPTABLE AND NOT CONSIDERED IN THE SELECTION PROCESS. 

Applications that meet qualifications will be referred to the hiring unit for interview selection. Units will select those candidates most closely demonstrating the qualifications for interview.

The certified list will be used by DLLR for a period of one year.

EXAMINATION PROCESS

The examination for this recruitment will be an evaluation and rating of the information provided on your application.  Therefore, it is essential that the application is filled out completely and accurately, listing all relevant education and experience and addressing the specific qualifications shown above.  Required documentation (diplomas, transcripts, certificates, licenses, etc.) must be submitted with the application and received by the closing date of the recruitment. Failure to submit the documentation will result in the application being incomplete and considered denied. RESUMES ARE NOT ACCEPTABLE AND NOT CONSIDERED IN THE EXAMINATION PROCESS.

Successful candidates will be placed on the eligible list categorized as Best Qualified, Better Qualified or Qualified.

BENEFITS

FURTHER INSTRUCTIONS

Military Veterans may qualify for additional bonus points towards certification. A copy of your proof of eligibility (DD 214) for Veterans’ Credit must be in this office and completely verified before Veterans’ Credit will be approved.  Permanent State employees do not need to submit proof of eligibility for Veterans’ Credit.

The MD State Application Form can be found online. Online application process is STRONGLY preferred. If online process is not available, or you encounter difficulty attaching required or optional documentation, please send your paper application by mail or deliver in person. Please be sure to include your name, identification number (Easy ID#) and job announcement number on any documentation to ensure timely processing.

Completed applications, required documentation, and any required addendum may be mailed to:

DLLR/Office of Human Resources

 Attn: IT Assistant Director II/15-004491-001/Elaine Phoebus

1100 N. Eutaw Street, Rm. 100

 Baltimore, MD 21201

PLEASE DO NOT FAX OR EMAIL UNSOLICITED DOCUMENTATION

 TTY Users: call via Maryland Relay

 The Department of Labor, Licensing and Regulation is an equal opportunity employer. It is the policy of DLLR that all persons have equal opportunity and access to employment opportunities, services, and facilities without regard to race, religion, color, sex, age, national origin or ancestry, marital status, parental status, sexual orientation, disability or veteran status.




Powered by JobAps