Database Administrator

Uline•Waukegan, IL

7d•Onsite

About The Position

Uline, Inc. seeks a Database Administrator in Waukegan, Illinois to perform database administration. This role involves designing databases, tables, stored procedures, views, triggers, and other database objects. The administrator will also design and develop ETL (Extract, Transform & Load) solutions, and optimize database performance through indexing, query optimization, and database design. Responsibilities include participating in periodic High Availability / Disaster Recovery tests, developing T-SQL code, SSIS ETL packages, and SSRS reports. The role also entails planning, testing, coordinating, and performing database version upgrades and applying security patches, as well as monitoring database performance, capacity planning, and resource consumption. Upgrading and patching DBMS's, ensuring databases and database objects are backed up according to business requirements, and testing/documenting recovery procedures are key duties. The Database Administrator will work closely with application development project teams to ensure optimal application performance and provide day-to-day support for databases and database applications. This position works 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.