Diversified Services Network, Inc. (DSN) is seeking a full-time Database Administrator (DBA) to join our team in Mossville, IL. We offer full benefits, PTO, 401k, and more! If you're looking to grow your career within an extremely reputable, stable Fortune 100 company - let's talk!
Position Overview
This role serves as the Database Administrator (DBA) for a small analytics team, owning the data architecture, data governance, and end-to-end user access management for multiple analytics programs and datasets. The DBA will play a key role in supporting the team's modernization initiative, migrating from a legacy SAS platform to a modern reporting framework, while partnering closely with Data Specialists, Data Scientists, and report builders to ensure a consistent, high-quality data experience.
Key Responsibilities
Serve as the Database Administrator (DBA) for a small analytics team, maintaining the intended data architecture, implementing data governance, creating and managing database objects, and documenting the architecture and program-specific flows.Own end-to-end user access management, including triaging access requests, obtaining approvals/denials, communicating results, granting access, and administering role-based access controls.
Serve as the Data/Product Owner for multiple analytics programs and datasets, collaborating with the broader team to ensure consistent architecture and user experience.Support the team's modernization initiative, migrating from a legacy SAS central platform to a modern reporting framework.
Coordinate, test, and implement changes to Snowflake databases, correcting errors and modifying databases/DBMS as needed.Author, troubleshoot, and performance-tune SQL views and queries; build and maintain data pipelines (ETL) and job orchestration, including cloud scheduling such as AWS Lambda.
Build and improve data sets and reporting for owned programs, and support customer inquiries on available data, enhancements, and general support.Advise and support the data needs of Data Specialists/Scientists and report builders, performing joint planning to avoid duplicative or conflicting outputs.
Assist in managing the team's broader technology footprint, which includes Snowflake, SAS, Oracle, Teradata, SQL Server, Power BI, and Tableau.
Team & Work Environment
Team of 6.
Onsite position based in Mossville, IL, with in-office collaboration.Frequent, detailed communication is required on a daily basis.
Requirements
Candidate Requirements
Education & Experience
Bachelor's degree preferred with 2-4 years of relevant experience.Associate's degree in computer programming or a related field required.
Top Skills
Snowflake database administration, including implementation, debugging/troubleshooting/tracing, and issue resolution.Data governance and architecture.
Strong SQL and query engineering, including data pipeline/ETL development, view/query authoring, troubleshooting, and performance tuning.
Additional Technical Skills (Required)
Python scripting and automation.
Version control systems and code review processes.Documentation of architecture and program-specific flows.
Additional Technical Skills (Desired)
BI tooling experience (Power BI and/or Tableau).SAS familiarity.
GitHub Copilot / agentic AI experience.LeanIX (architecture and dependency cataloging).
Soft Skills (Required)
Strong verbal and written communication.Customer-service and stakeholder orientation.
Independent time management and self-direction.Cross-team collaboration and joint planning.
Attention to detail.
Soft Skills (Desired)
Comfort with ambiguity during transition and modernization.
Ownership mindset.Documentation and knowledge-transfer discipline.Mentoring and peer-support skills.
Benefits
401(k)
Dental insurance
Vision Insurance
Disability insurance
Employee assistance program
Health insurance
Health savings account
Life insurance
Paid time off
Paid Holidays
Please follow the link to our website for a list of job openings in Engineering, IT, Project Management, and more! https://www.dsnworldwide.com
Salary expectations: $73,000-77,000 annually
Numbers & Facts
Location
Peoria, IL
Industry
Engineering Services
Salary
$73,000–$77,000 Per Year
Company Size
100 to 499 employees
Year Founded
1989
Website
http://www.dsnworldwide.com
About Company
Founded in 1989, Diversified Services Network, Inc. (DSN) provides IT, engineering, and enterprise solutions to Fortune 500 companies and state/federal government agencies, particularly those in industrial manufacturing, insurance and human services. DSN is a certified Woman Business Enterprise (WBE) by both the Women’s Business Enterprise National Council (WNENC) and the State of Illinois, as well as a certified Disadvantaged Business Enterprise (DBE).
Skills
AWS Lambdaunmatched
Access Controlunmatched
Artificial Intelligence (AI)unmatched
Business Intelligence Softwareunmatched
Cataloguingunmatched
Cloud Computingunmatched
Code Reviewsunmatched
Computer Programmingunmatched
Cost Controlunmatched
Customer Support/Serviceunmatched
Data Managementunmatched
Data Qualityunmatched
Data Scienceunmatched
Data Setsunmatched
Database Administrationunmatched
Database Extract Transform and Load (ETL)unmatched