DATABASE ADMINISTRATOR
Harford County MD

Job Info

---

Nature of Work

Oversee and manage Agency SQL and Oracle databases; administer local database applications; develop SSRS, PowerBI, and Crystal Reports; manage Microsoft Report Server; schedule and perform upgrades to law enforcement applications, database environments, and related address servers; provide computer assistance and guidance to Agency personnel; handle help desk requests; conduct installation, maintenance and support for the file servers; administer the virtual and storage environment, provide support for the Sheriff's Office Agency phone system; troubleshoot network and data emergencies; participate in an on-call rotation schedule; perform other duties as assigned.
The Database Administrator position has opportunities for overtime and compensatory time.

Examples of Duties

Provide 24/7/365 support of agency servers, computer and telephone systems.

Extract data from SQL and Oracle databases.

Ensure all databases, applications, and related integrated applications are up to date by scheduling and performing upgrades.

Monitor the performance of database hardware and software.

Ensure preservation of database integrity.

Manage Microsoft Report Server, Analytics database and applications, and database applications.

Create, edit, and maintain new and current SSRS reports, PowerBI reports, and Crystal Reports reports.

Test upgrade versions of database applications.

Configure and install new/existing equipment and peripherals including Servers (virtual and physical), Computers, Laptops, Monitors, Scanners, Digital Cameras, Printers, Laptops, Handheld Devices, DVD/CD-RW/Blu-Ray Drives, Card Readers, Memory, Hard Drives, IP Camera Systems, Access Control applications, Phones, etc.

Provide computer and telephone support, email or telephone communication to Agency employees and agency vendors, working various around the clock shifts.

Plan and implement future resources and requirements of agency storage, server, computer and telephone needs.

Perform research and make recommendations for new and/or replacement equipment.

Maintain accurate and detailed documentation of inventory, addition and removal or users, data center environment, applications, and task directions.

Conduct domain administration of users by adding, deleting and changing permissions and folder access, creating public folders, and keeping antivirus up to date.

Participate in emergency response and off-hours maintenance/upgrades.

Assist with managing virtual server environment (VMware, Azure), physical environments, and backups.

Assist with managing multiple data centers.

Keep informed on current information technology practices by attending workshops and educational programs or reading specialized literature.

Attend meetings and participate in various teams when needed.

Perform other duties as assigned.

Minimum Qualification Requirements

Associate degree in computer science or related field or related certification (CompTIA, Azure, Security Administration, etc.).

Experience with SQL, Oracle, Microsoft Report Server, SSRS, and PowerBI required.

Minimum of two (2) years of professional experience in Information Technology.

OR equivalent combination of technical training and related experience.

Notes

Required Knowledge, Skills, and Abilities:

Ability to act as a representative of the Sheriff's Office to the public.

Thorough knowledge of the principles, practices and techniques of computer and network operations.

Knowledge of virtual and physical data center environments, DNS, and database administration.

Knowledge of computer security procedures.

Ability to establish priorities and organize workload effectively and efficiently to accommodate numerous deadlines.

Ability to establish and maintain effective working relationships with other staff; successfully communicate with other staff members, County staff, and members of the public; and work as a team.

Ability to maintain a pleasant and productive working atmosphere.

Ability to respond properly in emergency situations and complete assignments under pressure.

Ability to operate relevant computer systems, including hardware and software, and office machines.

Selected Candidate:

Must be 18 years of age or older and a U.S. citizen with 10 years of verifiable U.S. residency.

Must pass comprehensive background investigation and criminal record check; medical exam and drug/alcohol screening; polygraph exam.

Must have a valid driver's license with no more than three (3) points.

Must provide handwriting sample for review.

Must appear before and receive a favorable recommendation from an Oral Interview Board.

Must possess a history and exhibit the characteristics of honesty, reliability, integrity and good interpersonal skills. Any criminal conviction(s) and/or arrest(s) may be grounds for disqualification.

Benefits Package includes:

• Health, Dental & Vision insurance
• Flexible Spending Accounts
• State Retirement Plan and Deferred Compensation
• Long Term Disability, and Life Insurance for Employee, Spouse, and Children
• Generous Leave Package & Paid Holidays
• Tuition Reimbursement
• Employee Assistance Program

FRINGE BENEFITS
(Effective July 1, 2023)

ANNUAL LEAVE - Begin accruing first day of employment and cannot be taken until successful completion of probationary period, EXCESS of 40 DAYS [320 hours] will be deposited into an 106 Premium Reimbursement Account.

0 months - 3 years 1 day per month (12 days per year)
4 years - 9 years 1 ¼ days per month (15 days per year)
10 years - 15 years 1 ¾ days per month (21 days per year)
Over 15 years 2 days per month (24 days per year)

* Please note that leave is prorated according to your status determined by actual hours worked*

SICK LEAVE - Begin accruing first day of employment (UMLIMITED ACCUMULATION)

1 day is allowed after first month of employment
1 ¼ days per month accumulation

PERSONAL LEAVE - For new employees, personal leave is prorated according to schedule below, for the first year only. Any employee on board as of December 31st of each year automatically receives 8 days as of January 1st the following year. (NOTE: Personal Leave may not be taken until successful completion of probationary period; personal leave will be lost if not taken before December 31st of each year.)

1/1 to 1/31 6 days 4/1 to 4/30 3 days
2/1 to 2/28 5 days 5/1 to 5/31 2 days
3/1 to 3/31 4 days 6/1 to 6/30 1 day
7/1 to 12/31 0 days
FAMILY LEAVE - Up to 12 weeks per year

FUNERAL LEAVE - 3 days + 1 day for extended travel

MILITARY LEAVE - 3 weeks per year with no loss in pay for Reserve or National Guard Training, Active Duty and serving during emergencies.

CIVIL LEAVE - No loss in pay while serving Jury Duty.

RETIREMENT -
COUNTY EMPLOYEES: State Pension System 7% employee contribution
LAW ENFORCEMENT (TO INCLUDE TEMPORARY DEPUTIES): LEOPS 7% Employee Contribution
CORRECTIONS: SOPP 9% Employee Contribution

COUNTYFLEX - Provides the employee with a range of health care and other employee benefit options which gives employee the opportunity to design a benefit plan that best meets the employee's needs. Employee may use available credits to purchase the following:

HEALTH INSURANCE - CareFirst Triple Option and BlueChoice Opt-Out Plus Open Access and Kaiser Permanente (all plans include prescription drug coverage)

DENTAL INSURANCE - CareFirst Dental PPO Plus Plan and CareFirst Dental PPO Plan

VISION INSURANCE - Provided through BlueVision Plus

FLEXIBLE SPENDING ACCOUNTS - Provided through American Fidelity. Employees may fund health and child care expenses on a pre-tax basis.

PRE-TAX - All deductions for health, dental, vision and flexible spending accounts are subject to deductions from paycheck before federal and state taxes are applied.

LIFE INSURANCE -
Provided through MetLife - $50,000 policy - NO COST TO EMPLOYEE

SUPPLEMENTAL LIFE (TERM/WHOLE/UNIVERSAL AND AD&D)
Provided through MetLife.

LONG TERM DISABILITY - Provided through MetLife.

DEFERRED COMPENSATION -
Lincoln Financial Group - Retirement Consultant David Weiland
Phone 410-236-2494 Email- Dave.Weiland@LFG.com
[Customer Service Representative 1-800-234-3500]

RETIREE HEALTH CARE INSURANCE BENEFITS-
Employees hired on or after 7/1/2010 will have an automatic Retirement Health Savings account made available as the primary retiree healthcare benefit. This 105(h) Universal Reimbursement Account will only be able to be accessed upon separation of service and/or retirement whichever applicable. These accounts are employer funded, tax free, & portable with 20 different Nationwide investment options.
These funds are solely for the use of offsetting your premium health care cost, prescriptions, co-pays and deductibles. Upon death funds are made available immediately to the surviving spouse or qualified dependents (as defined by the IRC 152 (a).

DEATH BENEFITS - PAID BY COUNTY

50% of accumulated sick leave

All accumulated annual leave

Personal leave (maximum of 2 days)

$50,000 life insurance

One (1) month's salary

PAID BY RETIREMENT
One year's pay (after 1 year's service) plus employee's contributions refunded with interest.

HOLIDAYS - 11 per year:

New Year's Day January 1st
Martin Luther King, Jr. Day 3rd Monday in January
President's Day 3rd Monday in February
Memorial Day last Monday in May
Juneteenth June 19th
Independence Day July 4th
Labor Day 1st Monday in September
Veteran's Day November 11th
Thanksgiving Day 4th Thursday in November
Friday after Thanksgiving
Christmas Day December 25th

OTHER BENEFITS: Employee Assistance Program
Travel and Official Expense Reimbursement
Uniforms and Safety Clothing
Tuition Assistance
Legal Plan

Agency Harford County

Address 220 South Main Street

Bel Air, Maryland, 21014

Phone 410-638-3201

Website http://www.harfordcountymd.gov

---