IT Technical Support Specialist-Database Administrator
DATABASE SPECIALIST II
Recruitment #22-004480-0006
Department | Worker's Compensation Commission |
---|---|
Date Opened | 5/17/2022 09:40:00 AM |
Filing Deadline | 6/1/2022 12:00:00 PM |
Salary | $54,822.00 - $89,738.00/year |
Employment Type |
Full-Time
|
HR Analyst | Beth Richard |
Work Location |
Baltimore City
|
Introduction
Make a difference while pursuing a career to match your passion. At WCC, we are collaborative, innovative, and excited about our work. We thrive on initiative, creativity and challenges to the status quo by employees who are valued and empowered. Proud of our achievements, we consider excellence a continuous journey…not a destination end point. This is public service today. If you've got the right stuff: strong MS SQL 2012 or newer database administration skills, experience, and a passion for your work, come journey with us.
OUR MISSION
The Maryland Workers' Compensation Commission seeks to secure the equitable and timely administration of the provisions of the Maryland Workers' Compensation law on behalf of its customer, the injured workers and their employers, by providing an efficient forum for the resolution of individual claims.
OUR VISION
The Workers' Compensation Commission envisions a state wherein injured workers and employers are empowered to create an equitable partnership to facilitate prompt and fair resolution of workers' compensation matters.
ABOUT US
Together we profoundly touch the lives of so many people and have enormous responsibility to the community by fulfilling our mission of securing equitable and timely administration of the law. The Commission continues to provide services to our constituent partners at a level rarely met throughout the United States. The professionalism, work ethic, and technological acumen manifest in our operations allows us to smoothly and effectively manage the challenges which invariably arise. Every division within the agency plays a vital role in keeping us in the forefront nationally...
ARE YOU READY TO MAKE A MEANINGFUL DIFFERENCE IN YOUR COMMUNITY AND PURSUE YOUR CAREER PASSION WITH A NATIONALLY RECOGNIZED LEADER?
GRADE
LOCATION OF POSITION
POSITION DUTIES
The State of Maryland Workers' Compensation Commission is currently seeking a creative and energetic Technical Support Specialist Database Administrator (DBA). The DBA works as a member of the IT team to develop, test, implement, and upgrade Windows application servers and related database components for third party and in-house software development projects supporting internal and external customers.
The Tech Support Specialist DBA implements database solutions solving key business and compliance needs in an integrated and simple manner, building in extensibility and security, and balancing the need for flexibility and agility with conformance to best practices.in support of the Agency's mission and Enterprise Modernization
The ideal candidate will demonstrate a strong customer focus and the ability to deliver effective technology solutions that also delight customers. The ability to apply other current IT skills and experience in Windows server and PC support, IIS web server administration, PowerShell scripting, and VMware vSphere administration as well as the flexibility to adapt to a variety of database related assignments in addition to core SQL Server DBA responsibilities is highly desirable.
· Provide database support for WCC’s Enterprise Modernization Project
· Install, configure, and upgrade virtualized Microsoft Windows server operating systems and SQL server; define and implement optimal data designs and structures based on workload, and data security requirements
· Monitor and troubleshoot database and hosting servers’ performance; notify stakeholders and customers of issues affecting systems availability
· Develop, implement, and enhance data structures, stored procedures and other database-related components of web apps supporting WCC’s online services
· Develop, implement, and enhance data structures, stored procedures and other database-related components of Windows desktop and internal web based case management, document management, and routing workflow apps
· Work with WCC business units on business metrics and data analytics
· Develop and maintain reports using g Microsoft SQL Server Data Tools, Business Intelligence Studio, (BIDS) and SQL Server Reporting Services (SSRS)
· Develop and maintain extract,, transform, and load (ETL) and system integration packages using SQL Server Integration Services (SSIS)
· Create documentation and training plans for WCC IT staff and end-users
· Provide second level technical support for complex SQL server database and related virtualized Windows server operating system, and PC client/web server application issues
MINIMUM QUALIFICATIONS
Experience: Five years of experience, one year of experience designing, developing, implementing, maintaining and controlling database management systems for computers and an additional four years 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 additional four years 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.
2. Candidates may substitute graduation from an accredited high school or possession of a high school equivalency certificate and one 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 additional four years of the required experience.
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 graduation from an accredited high school or possession of a high school equivalency certificate.
4. 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.
5. 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
DESIRED OR PREFERRED QUALIFICATIONS
- Experience writing and
tuning t-sql queries and indexes, developing views, stored procedures,
triggers or constraints
- Experience
troubleshooting SQL Server and related Windows server, network and
application issues
- High Availability and
Disaster Recovery experience with SQL Server and similar technical
knowledge in a cloud environment
SPECIAL REQUIREMENTS
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.
BENEFITS
FURTHER INSTRUCTIONS
If you have any questions about this recruitment, please contact the Workers' Compensation Commission at 410-864-5230.
TO APPLY: Please include your resume along with your completed online employment application. During the online application process, use the Resume tab to select a method for including your resume (Upload Your Resume or Type or Copy/Paste Your Resume). Submission of a resume is strongly recommended and completion of the Supplemental Questionnaire is required to submit a completed application.
If you are unable to apply online, or encounter difficulty attaching required or optional documentation, you may submit via 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. Please include your resume along with your completed employment application.
PLEASE DO NOT FAX OR EMAIL UNSOLICITED DOCUMENTATION
A completed application, resume, and any addendums may be mailed to:
Workers' Compensation Commission
Attn: 22-004480-0006
10 E. Baltimore Street, Personnel Division
Baltimore, MD 21202
TTY Users: call via Maryland Relay
WCC is an equal opportunity employer. It is the policy of WCC 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.