DATABASE ADMINISTRATOR INFORMATION TECHNOLOGY
Kenosha County is seeking a Database Administrator to install and monitor production databases while ensuring high levels of data availability. Kenosha County IT is focused on enabling the business with superior technology solutions and services backed by outstanding customer service.
Join our team and help make a difference!
Kenosha County is committed to Equity, Diversity and Inclusion and is an Equal Opportunity Employer.
2024 Hiring Range: $71,530 – $85,155
Position Summary and Job Duties
The Database Administrator is responsible for developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability of databases and their accompanying software. Additionally, this individual is responsible for data governance initiatives and assistance with dashboard creation.
• Assess and develop long-term strategic goals for production databases.
• Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.
• Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.
• Install and configure relevant network components to ensure database access as well as database consistency and integrity.
• Respond to and resolve database access and performance issues.
• Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.
• Monitor, optimize, and allocate physical data storage for database systems.
• Plan and coordinate data migrations between systems.
• Develop, implement, and maintain change control and testing processes for modifications to databases.
• Create, or support creation of, required reports and dashboards in response to business user needs.
• Perform database transaction and security audits.
• Establish appropriate end-user database access control levels.
• Develop routines for end users to facilitate best practices database use.
• Develop, maintain, implement, and test business continuity and disaster recovery strategies for data integrity and availability.
• When needed, provide application support across a wide variety of enterprise applications.
• Liaise with 3rd party support vendors and our customers to troubleshoot and resolve support incidents.
• In conjunction with data owners and department managers, develop data models and protocols for mining production databases.
• Assist in the development of data management policies and procedures.
• Configuration of Azure tenant management, managing resource consumption, and monitoring workloads in the Azure Portal
Job Requirements, Education, Training and Experience
Required Education and Experience
• Bachelor’s degree in computer systems design, computer science or a related field
• 3+ years of professional work experience with database administration or related field
Preferred Education and Experience
• Information Technology Infrastructure Library certification (ITIL)
• Microsoft Certified: Azure Database Administrator Associate
• Microsoft Certified: Azure Enterprise Data Analyst Associate
Other Requirements
• Must possess a valid driver’s license at time of hire and maintain during incumbency.
Success Factors
• Knowledge of database structures, theories, principles, and practices; applicable data privacy practices and laws.
• Knowledge of organization’s goals and objectives.
• Skill with designing, building, installing, configurating and supporting database services, including Microsoft SQL Server in an Always-On, clustered configuration.
• Skill with data preparation, processing, classification, forecasting, hands-on database tuning and troubleshooting experience.
• Skill in project management; customer service; SQL Serve Reporting Services (SSRS); SQL Server Integration Services (SSIS); Microsoft Visual Studio, Azure Portal and Power BI and/or Fabric.
• Ability to interact with inter-departmental projects and communicate with various stakeholders.
• Ability to communicate in both technical and user-friendly language.
• Ability to create and publish technical documentation.
• Ability to effectively prioritize and execute tasks.
• Ability to conduct research into database issues, standards, and products as required.
• Ability to work respectfully in a diverse and inclusive and a team-oriented, collaborative environment.
Benefits
• Health, dental and vision insurance effective first of month following 30 days of employment with the ability to reduce premium contribution through participation in a wellness program
• Flexible Spending Accounts
• Employee Assistance Program
• Paid Time Off
• Twelve Paid Holidays
• Retirement Plan: Participation in the Wisconsin Retirement System which includes county-paid life insurance
• Tuition Reimbursement
Physical Demands
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
• The position involves frequent light physical demands, such as exerting up to 10 lbs. of force frequently and seldom lifting and transporting of moderately heavy objects.
• Sitting for extended periods of time.
• Dexterity of hands and fingers to operate a computer keyboard, mouse, and other devices and objects.
• Physically able to participate in sessions, presentations, and meetings.
• Some travel may be required between County facilities.
Work Environment/Conditions
The work environment and exposures described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
• The selected candidate for this position will frequently work in an office or similar indoor environment.
• The selected candidate for this position will have occasional exposure to individuals who are rude or irate.
Selection Process
• Application Review – Qualifying.
• Oral Interview – Qualifying.
• Background Check – Qualifying.
• Drug Screen – Qualifying.
If you require accommodations at any point in the selection process because of a disability, please notify Human Resources in advance for arrangements.
To learn more about the Division of Information Technology, please visit:
https://www.kenoshacounty.org/101/Information-Technology
Applications must be submitted no later than Tuesday, October 1, 2024.
Kenosha County is a Wisconsin Retirement System participating employer. Your participation is required, which includes an employee contribution.
The pay grade for this position is E9 (Min. $71,530 – Max. $98,780).
This position is located in Kenosha County which is located along the shores of Lake Michigan and less than an hour away from Milwaukee and Chicago. To see why Kenosha County is a great place to live, work, and play, visit: https://www.visitkenosha.com/
Thank you for your interest in employment with Kenosha County!
Kenosha County is an affirmative action, equal opportunity employer.
https://www.kenoshacounty.org/jobs
Deadline Note: