Date Posted
Category
Salary
Job type
Level
Location
Company

Track Group, IncSee more

addressAddressNaperville, IL
type Form of workFull-Time
CategoryInformation Technology

Job description

Track Group is a global leader in providing end-to-end location monitoring and complimentary app-driven solutions that combine real-time tracking devices and professional monitoring services with advanced data analytics. The current focus is delivering electronic monitoring products and services for the global criminal justice market.

Position Summary: The Database Administrator is a key member of the Network Operations team and is responsible for MS-SQL Server installation, configuration, disaster recovery, performance analysis and tuning, index maintenance and monitoring of data. Performs database and software life-cycle activities to ensure the highest level of system performance and availability and compliance with business requirements. This is a "hands-on" position requiring solid technical skills as well as excellent interpersonal and communication skills. In this role, the Database Administrator will interface directly with internal teams and customers as well as external vendors as needed and provide day-to-day operational and technical support for databases across the enterprise. Participate in technical research and development to enable continuing innovation within the Track Group technology team. The Database Administrator reports to the Network Operations Manager.

Essential Duties and Responsibilities:

  • Manage MS-SQL Server databases across multiple environments, from development to mission-critical production systems.
  • Ensure uptime for mission critical systems and participate in rotating on-call coverage.
  • Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
  • Refine and automate complex processes using SQL Agent jobs, SQL Server Integration Services, etc.
  • Independently analyze, solve, and correct issues in real time.
  • Develop and maintain complex SQL code and ETL processes that include process logging, data validation and integrity checks.
  • Assist software developers with complex query tuning and schema refinement, participate in SQL code reviews.
  • Perform scheduled maintenance and support release deployment activities after hours.
  • Effectively document and communicate database changes/issues/risks to the appropriate Track Group stakeholders, partners, and vendors.
  • Respond to, troubleshoot and resolve/escalate issues in a timely and accurate manner.
  • Other duties as assigned by supervisor. Duties and Responsibilities are subject to change based on business needs.

Requirements

Education, Skills, and Experience:
  • Bachelor's degree in a related field. In some cases, substantial, relevant experience may be substituted for this qualification.
  • 5+ years of Microsoft SQL Server Administration experience required.
  • Advanced level SQL development and tuning skills (T-SQL and SSIS).
  • Experience with performance tuning and optimization, using native monitoring and troubleshooting tools.
  • Experience with backups, restores and recovery models.
  • Experience with Microsoft Reporting Services (SSRS).
  • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MS-SQL Server.
  • Advanced analytical and troubleshooting skills with ability to review trends/patterns and identify issues.
  • Impeccable attention to detail.
  • Ability to multi-task and context-switch between different activities.
  • Strong interpersonal and communication skills. Must be able to integrate and communicate clearly and easily with other team members, as well as end-users at all levels.
  • Experience with Azure SQL and related Azure database services is preferred.
  • Familiarity with Red-Gate tools is a plus.
  • Demonstrated ability to learn new technologies.

Benefits
  • Generous amounts of time away from work to promote a healthy work-life balance. We offer unlimited paid vacation days in addition to observing 11 major holidays per year.
  • Access to Medical, Dental and Vision insurances with a company contribution for you and any covered dependents.
  • Life Insurance, Short-Term Disability Insurance and an Employee Assistance Program provided to you at the company's expense.
  • Ability to contribute to a company sponsored 401(k) retirement plan with a company match on your contributions.
  • Opportunities for growth along our clearly defined Career Path, including mentorship and leadership development programs to help you achieve all of your professional goals.
Refer code: 6557895. Track Group, Inc - The previous day - 2023-11-10 16:55

Track Group, Inc

Naperville, IL
Jobs feed

Salix Territory Manager (Primary Care) - Camden, NJ

Bausch Health

US-NJ-Camden, New Jersey, US

Senior Buyer, Clinical R&D Services

Bausch Health

US-NJ-Bridgewater, New Jersey, US

Credit Analyst

COUNTY NATIONAL BANK

Jackson, MI

Senior Windows System Administrator

Absolute Business Solutions Corp

King George, VA

Assistant Athletic Trainer- Women's Swimming and Diving

University of Iowa

Iowa City, IA

Salvage Yard Parts Puller

LKQ Corporation

Bakersfield, CA

Northern California Territory Sales Manager

CANarchy Craft Brewery Collective

Sacramento, CA

Product Costing Engineer

DBSI Services, Inc.

Irvine, CA

Senior/Principal Electrical Engineer, Facilities

General Dynamics - Bath Iron Works

Bath, ME

Share jobs with friends

Related jobs

Database Administrator (Dba)

Practice Administrator - Chicago

BSM Consulting

Homewood, IL

8 hours ago

Physician- BHIP Psychiatrist

Veterans Health Administration

Danville, IL

9 hours ago

Engineering Information System Administrator

Vapor Bus International

Arlington Heights, IL

10 hours ago

Senior Benefits & Leave of Absence Administrator

CJ Logistics America, LLC

Des Plaines, IL

10 hours ago

Benefits Administrator/Administrative Assistant to Building and Grounds

Winnetka Public Schools

Winnetka, IL

10 hours ago

Middle School Administrative Assistant, Assistant to the Principal

Elementary School District 181

Willowbrook, IL

10 hours ago

System Administrator | Chicago, IL | 5+ Months

Genius Business Solutions

Chicago, IL

10 hours ago

Physical Scientist

National Oceanic and Atmospheric Administration

Romeoville, IL

10 hours ago

WebSphere / WebLogic Administrator

Cynet Systems

El Paso, IL

10 hours ago

Program Support Assistant (OA)

Substance Abuse and Mental Health Services Administration

Chicago, IL

11 hours ago

Legal Administrative Specialist (Estate and Gift Tax) - 12 Month Roster

Internal Revenue Service

Orland Park, IL

11 hours ago

IBM MQ Administrator

CYNET SYSTEMS

Bloomington, IL

11 hours ago

Elevator Mechanic

Veterans Health Administration

Chicago, IL

11 hours ago

Electronics Technician

Federal Aviation Administration

Des Plaines, IL

11 hours ago

Social Worker - HCHV/SSVF Substance Abuse Disorder Case Manager

Veterans Health Administration

Bloomington, IL

11 hours ago

Service Desk System Administrator (Escalations)

Empist

Chicago, IL

11 hours ago

Contracts Administrator

Diverzify

Itasca, IL

11 hours ago

Systems Administrator Senior

Northwestern University

Evanston, IL

11 hours ago

Jobs in the same category

Information Technology

Practice Administrator - Chicago

BSM Consulting

Homewood, IL

8 hours ago

Senior Image Quality Scientist (CT Medical Imaging)

Vital Chemicals USA LLC

Illinois, United States

8 hours ago

Data Analyst, Python

The University of Chicago

Chicago, IL

8 hours ago

Radiology Technologist Full Time Days

Advocate Aurora Health

Oak Lawn, IL

8 hours ago

Radiologic Technologist - Travel - Oak Lawn, IL

Sunbelt Staffing

Chicago, IL

8 hours ago

Travel Contract Radiologic Technologist- Oak Lawn, IL

Sunbelt Staffing

Oak Lawn, IL

8 hours ago

Grossing Technician

Trinity Health

Maywood, IL

8 hours ago

Assistant Manager, Implementation Research

The University of Chicago

Chicago, IL

8 hours ago

Open Rank Tenure Track Faculty - Computer Science

University of Illinois

Chicago, IL

8 hours ago

Document Control Admin - Engineering Services

Grayhill Inc.

La Grange, IL

8 hours ago

COBOL Senior Developer- Remote

Oldcastle BuildingEnvelope

Oak Brook, IL

8 hours ago

Sr. Data Engineer - 9131567

Siri InfoSolutions Inc

Northbrook, IL

9 hours ago

CAD/CAM Engineer

Entegee

West Chicago, IL

9 hours ago

Facilities Engineer

NSG Group

Ottawa, IL

9 hours ago

Data Engineer

Walgreens

Deerfield, IL

9 hours ago

Senior Network Engineer

Pyramid Consulting

Northbrook, IL

9 hours ago

Senior Security Remediation Analyst

TEKsystems

Chicago, IL

9 hours ago

Caregiver Full time hours Driver's license and reliable Car REQUIRED

Assisting Hands - Naperville

Naperville, IL

9 hours ago

Related keywords

Database Administrator (DBA)