Database Administrator (DBA) Mossville / Chillicothe, IL | On-Site Full Time | 12 Months Job Details
Estimated Start Date: ASAP
Building Location: IL-Mossville
Remote Possibility: On-Site Full Time
Daily Schedule: Regular 8 hours per day between 6AM-5PM (flexible start and leave time so long 8 hours are met)
Estimated Duration: 12 months
Job Description Summary The main function of a database administrator is to coordinate changes to computer databases (Snowflake), test and implement the database applying knowledge of database management systems. A typical database administrator is responsible for planning, coordinating and implementing security measures to safeguard the computer database. Job Responsibilities
Test programs or databases, correct errors and make necessary modifications.
Modify existing databases and database management systems.
Work as part of a project team to coordinate database development and determine project scope and limitations.
Write and code logical and physical database descriptions and specify identifiers of database to management system.
Review project requests describing database user needs to estimate time and cost required to accomplish project.
Skills
Verbal and written communication skills, problem solving skills, customer service and interpersonal skills.
Ability to work independently and manage one's time.
Basic mentoring skills necessary to provide support and constructive performance feedback.
Knowledge of computer hardware and software.
Github, Github copilot and Agentic AI experience a plus
Knowledge of computer languages/tools, such as SQL, Snowflake, Python, etc.
Education / Experience
Associate's degree in computer programming or relevant field required. Bachelor's degree preferred.
2-4 years experience required.
Position's Contributions to Work Group
The position fills the Database Administrator (DBA) role for a small analytics team, maintaining the intended data architecture (including for other team members), implementing data governance, creating and managing database objects, and documenting the architecture and program-specific flows.
Own end-to-end user access management: triage access requests, obtain approvals/denials, communicate results, grant access, and administer role-based access controls to keep users accountable and compliant.
Serve as the Data/Product Owner for multiple analytics programs and datasets, collaborating continually with the team where data sets and end-users often overlap to ensure consistent architecture and user experience.
Support the Analytics 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, and 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, and perform joint planning to avoid duplicative or conflicting outputs.
Why This Role?
The Strategic Procurement and Planning Division (SPPD) has recently re-organized to highlight the importance of Data Services to enhance business operations. As a key component of that commitment, the Digital Business Insights team can modernize its technology stack and develop a sustainable high-velocity platform to provide Business Insights. This role is pivotal to the design, implementation and sustainable management of that platform which will shape the BI efforts of Supply Chain and Procurement.
Typical Day or Week in the Role Typical Task Breakdown
Review and process access requests for data and reporting
Build or improve data sets or reporting for responsible programs
Manage data architecture for other members of the team
Support customer inquiries for support, available data to consume, and enhancements to existing tools
Assist team members with tasks to help balance workloads
Interaction with Team
Advise and support data needs for the rest of the team of Data Specialists / Scientists and report builders
Perform joint planning to avoid duplication of efforts or conflicting outputs
Assist the management of the footprint of technology (Snowflake, SAS, Oracle, Teradata, SQL Server, Power BI, Tableau)
Frequent and detailed communication is needed on a daily basis
Team Structure
Team of 6
Work Environment
In office collaberation
Education & Experience Required
Years of experience: 2-4 years
Degree requirement: Associate's degree in computer programming or relevant field required. Bachelor's degree preferred.
Do you accept internships as job experience: if skills can be showcased, yes