Our client is a leading distributor of industrial and packaging materials to businesses throughout North America. As an essential business, they are currently experiencing significant growth and are a proven industry leader that runs one of the largest e-commerce sites in the U.S.
Design and execute overall database architecture strategy, standards and practices.
- Design and execute overall database architecture strategy, standards and practices.
- Collaborate to develop data models for business processes.
- Work with the Application Development team to ensure database change timeliness and adherence to best practices.
- Identify and troubleshoot database performance issues in all areas of the enterprise.
- Ensure industry-wide security standards.
- Design and develop complex PL / SQL code and ETL processes.
- Participate in on-call rotation and occasional off-hours tasks (DR tests, DBMS upgrades, UAT refreshes, etc.).
- Performance tune complex SQL statements generated by Hybernate or COGNOS in a DB2 11.1 pureScale environment.
SKILLS, EDUCATION AND EXPERIENCE:
- Bachelor’s degree in information technology or related field.
- 10+ years experience in data integration, data movement and / or database administration preferred.
- Advanced RDBMS knowledge in DB2 LUW 11.1 (pureScale) with a focus on high volume OLTP production support.
- Experience in DB2 LUW 11.1 pureScale installation and configuration, including upgrading and patching.
- DB2 LUW HADR experience.
- Advanced experience tuning queries, interpreting execution plans, making index recommendations and an understanding of how to influence the SQL query engine.
- ETL experience, including data exports, imports and transformation.
- Proficient in PL / SQL development, troubleshooting and optimization.
- RHEL 6.5-7.5 and AIX proficiency.
TotalTek is a minority-owned Technology Company specializing in IT and Engineering solutions. Our workforce solutions and customized delivery in Project Outsourcing, Managed Resource Program and Staff Augmentation combined with our onshore and offshore capabilities offer unparalleled delivery options for our clients. We live our core value of Improving Lives for Clients and Consultants alike – it’s why we know TotalTek is a simple solution to your complex Engineering and IT problems.