Database Administrator

Uline•Waukegan, IL

8d•Onsite

About The Position

Uline, Inc. seeks a Database Administrator in Waukegan, Illinois to perform database administration. Design databases, tables, stored procedures, views, triggers, and other database objects. Design and develop ETL (Extract, Transform & Load) solutions. Optimize database performance through indexing, query optimization, database design. Participate in periodic High Availability / Disaster Recovery tests of database systems. Develop T-SQL code, SSIS ETL packages, and SSRS reports. Plan, test, coordinate, and perform database version upgrades and apply security patches. Monitor database performance, capacity planning, and resource consumption. Upgrade and patch DBMS’s. Ensure databases and database objects are backed up according to business requirements, and recovery procedures are tested and documented. Work closely with application development project teams to ensure optimal application performance. Provide day-to-day support for databases and database applications. Work under moderate supervision with some latitude for independent judgment.

Requirements

Bachelor’s degree in Computer Science, Information Technology, or a related field
5 progressive years of database administration experience
At least 5 years of experience in Microsoft SQL Server
At least 5 years of experience in monitoring database security, performance, optimizing through techniques including indexing, query optimization and database design
At least 5 years of experience in developing T-SQL code, SSIS ETL packages, and SSRS reports
At least 5 years of experience in planning, testing, coordinating, and performing database version upgrades and applying security patches
At least 5 years of experience in SQL Server Replication

Responsibilities

Perform database administration.
Design databases, tables, stored procedures, views, triggers, and other database objects.
Design and develop ETL (Extract, Transform & Load) solutions.
Optimize database performance through indexing, query optimization, database design.
Participate in periodic High Availability / Disaster Recovery tests of database systems.
Develop T-SQL code, SSIS ETL packages, and SSRS reports.
Plan, test, coordinate, and perform database version upgrades and apply security patches.
Monitor database performance, capacity planning, and resource consumption.
Upgrade and patch DBMS’s.
Ensure databases and database objects are backed up according to business requirements, and recovery procedures are tested and documented.
Work closely with application development project teams to ensure optimal application performance.
Provide day-to-day support for databases and database applications.