Database Administrator

We are seeking a skilled and detail-oriented Database Administrator to manage, maintain, and optimize our organization’s databases. This position is responsible for ensuring data integrity, security, and availability while supporting business operations with efficient database solutions. The ideal candidate has expertise in database architecture, backup and recovery, and performance tuning, along with strong problem-solving skills and a commitment to excellence.

The advertised salary range provided covers the entire compensation spectrum for the position classification. The anticipated hiring range for this role is between $93,911.76 to $115,041.91 annually. It's essential to note that the actual salary offered will be determined based on several factors, including skills, qualifications, experience, education, licenses, training, and internal equity considerations.

Special Requirement: Due to the supporting role of this position within the Police Department, a thorough background investigation, including a polygraph examination, will be conducted. 

• Recruitment Closing Date: Sunday, January 19, 2025 11:59 PM
• First round of interviews: Week of January 27, 2025
• Second round of interviews: Week of February 3, 2025
• Expected start date: February 17, 2025

JOB CLASSIFICATION SUMMARY
Database Administrators in this role manage, maintain, and optimize databases within the organization, ensuring data integrity, security, and availability. They play a vital role in supporting the organization's data needs and are responsible for database management.

DISTINGUISHING CHARACTERISTICS
This senior-level professional role requires extensive experience and expertise in database management. Database Administrators are pivotal in efficiently utilizing database resources to meet organizational goals.

ESSENTIAL DUTIES
The following are intended to describe core work functions of this classification.  While the level and broad nature of essential duties may not change, specific work tasks will vary over time depending on the Town’s needs.

• Design, implement, and maintain database systems to meet organizational requirements, including extracting and/or loading data.
• Monitor database performance, troubleshoot issues for optimal performance and availability, and configure servers and databases.
• Ensure data integrity, security, and compliance with relevant regulations, setting up cybersecurity measures, and ethically handling private data.
• Develop and implement backup and recovery strategies to protect critical data, preserving data integrity, and authenticating data.
• Optimize database systems for efficiency and scalability, including monitoring the performance of hardware and software, and ensuring all hardware and software are updated.
• Collaborate with stakeholders to integrate databases into applications and systems, providing technical support and guidance on database-related matters.
• Evaluate and recommend database technologies, tools, and methodologies for enhancing capabilities.
• Experience with Tableau, Python, SSRS, Power BI, and related data analytics tools.
• Performs related work as assigned.

MINIMUM QUALIFICATIONS (at job entry)

Education and Experience:
Bachelor’s Degree from an accredited college or university in information technology, business administration, public administration, or related field and 6 years of related experience; or an equivalent combination of directly related education and experience.LICENSING/CERTIFICATION REQUIREMENTS

• Driver’s License;
• Maintain all certifications/licenses required at job entry.

SPECIAL REQUIREMENTS
To be eligible, incumbents cannot be on the Office of Inspector General (OIG) list of Excluded Individuals/Entities (LEIE).

KNOWLEDGE

• Database management systems (DBMS) and their architectures.
• SQL (Structured Query Language) and database programming languages.
• Data modeling and database design principles.
• Backup and recovery strategies.
• Data security and compliance regulations (e.g., CJIS, HIPAA, etc.).
• Performance tuning and optimization techniques.
• High availability and disaster recovery solutions.
• Emerging trends and technologies in database management.
• Data analytics tools and techniques.

SKILLS

• Strong analytical and problem-solving skills.
• Excellent attention to detail and organizational skills.
• Ability to work independently and prioritize tasks effectively.
• Effective communication and interpersonal skills.
• Proficiency in database administration tools and utilities.
• Collaboration and teamwork.
• Adaptability to new technologies and methodologies.
• Continuous learning and self-improvement mindset.

OVERALL PHYSICAL STRENGTH DEMANDS:

Physical Strength for this classification is indicated below with an “X”
X	Sedentary: Exerting up to 10 lbs. occasionally or negligible weights frequently; sitting most of the time.
	Light: Exerting up to 20 lbs. occasionally, 10 lbs. frequently, or negligible amounts constantly OR requires walking or standing to a significant degree.
	Medium: Exerting 20-50 lbs. occasionally, 10-25 lbs. frequently, or up to 10 lbs. constantly.
	Heavy: Exerting 50-100 lbs. occasionally, 10-25 lbs. frequently, or up to 10-20 lbs. constantly.
	Very Heavy: Exerting over 100 lbs. occasionally, 50-100 lbs. frequently, or up to 20-50 lbs. constantly.

PHYSICAL DEMANDS:

C	F	O	R	N
Continuously	Frequently	Occasionally	Rarely	Never
2/3 or more time	1/3 to 2/3 of time	Up to 1/3 time	< 1 hour per week	Never occurs

Note: This is intended as a description of the way the job is currently performed. It does not address the potential for accommodation.

Physical Demand	Brief Description	C	F	O	R	N
Standing	Communicating with co-workers, observing work site, observing work duties			X
Sitting	Desk work	X
Walking	To other departments/offices/office equipment			X
Lifting	Supplies, files				X
Carrying	Supplies, files				X
Pushing/Pulling	File draws, tables and chairs				X
Reaching	For supplies, for files		X
Handling	Paperwork		X
Fine Dexterity	Computer keyboard, telephone pad, calculator, calibrating equipment	X
Kneeling	Filing in lower drawers, retrieving items from lower shelves/ground				X
Crouching	Filing in lower drawers, retrieving items from lower shelves/ground				X
Crawling	Under equipment					X
Bending	Filing in lower drawers, retrieving items from lower shelves/ground				X
Twisting	From computer to telephone, getting inside vehicles				X
Climbing	Stairs, step stool				X
Balancing	On step stool				X
Vision	Reading, computer screen, driving	X
Hearing	Communicating with co-workers and public and on telephone, listening to equipment	X
Talking	Communicating with co-workers and public and on telephone	X
Foot Controls	Driving				X
Other (Specify)

MACHINES, TOOLS, EQUIPMENT, SOFTWARE AND HARDWARE:
Standard office equipment; vehicle
 
ENVIRONMENTAL FACTORS:
    

D

W

M

S

N

Daily

Several Times Per Week

Several Times Per Month

Seasonally

Never

Health & Safety Factors

D

W

M

S

N

Health & Safety Factors

D

W

M

S

N

Mechanical Hazards

X

Respiratory Hazards

X

Chemical Hazards

X

Extreme Temperatures

X

Electrical Hazards

X

Noise and Vibration

X

Fire Hazards

X

Wetness/Humidity

X

Explosives

X

Physical Hazards

X

Communicable Diseases

X

Physical Danger or Abuse

X

Other (Specify Below

 

PROTECTIVE EQUIPMENT REQUIRED:
None
 
 
NON-PHYSICAL DEMANDS:

C	F	O	R	N
Continuously	Frequently	Occasionally	Rarely	Never
2/3 or more time	1/3 to 2/3 of time	Up to 1/3 time	< 1 hour per week	Never occurs
Description of Non-Physical Demands	C	F	O	R	N
Time Pressure		X
Emergency Situation			X
Frequent Change of Tasks			X
Irregular Work Schedule/Overtime		X
Performing Multiple Tasks Simultaneously		X
Working Closely with Others as Part of a Team		X
Tedious or Exacting Work		X
Noisy/Distracting Environment				X
Other (Specify Below)

PRIMARY WORK LOCATION:

X	Office Environment
	Warehouse
	Shop
	Recreation/Neighborhood Center
	Vehicle
	Outdoors
	Combination of Office, Vehicle and Field
	Other (Specify Below)

Salary : $93,912 - $136,172