Senior DB2 LUW Database Administrator in Pleasant Prairie, WI at Signature Consultants

Date Posted: 6/22/2020

Job Snapshot

Job Description

Senior DB2 LUW Database Administrator Summary:

Signature Consultants is seeking a Database Administrator for an opportunity with a client in Pleasant Prarie, WI.

Position Responsibilities:

  • 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.

Minimum Requirements:

  • 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.

About Signature Consultants, LLC

Headquartered in Fort Lauderdale, Florida, Signature Consultants was established in 1997 with a singular focus: to provide clients and consultants with superior staffing solutions. For the ninth consecutive year, Signature was voted as one of the "Best Staffing Firms to Work For" and is now the 14th largest IT staffing firm in the United States (source: Staffing Industry Analysts). With 28 locations throughout North America, Signature annually deploys thousands of consultants to support, run, and manage their clients' technology needs. Signature offers IT staffing, consulting, managed solutions, and direct placement services. For more information on the company, please visit www.sigconsult.com. Signature Consultants is the parent company to Hunter Hollis and Madison Gunn.

CHECK OUT OUR SIMILAR JOBS

  1. Developer Jobs
  2. DBA Jobs