Job Description :

Hope you’re doing great.

This is Shivangi with KPG99 Inc. . I have the following job opportunity of DB2 Database Administrator in Pleasant Prairie, WI. Please see the job description below and let me know if you would be interested in it. You can either reply to this mail or call me at

DB2 Database Administrator

Pleasant Prairie, WI

6+ Months

Phone and F2F in NY or WI Office


RDBMS: SQL Server 2012 - 2016 (advanced); Oracle 11g,12c (RAC) (basic), DB2 LUW 11.1(purescale) (basic) 
OS: Windows 2012 - 2016; RHEL 6.5-7.5; AIX (at a level required to support RDBMS) 
ETL: SSIS (development, troubleshooting and optimizationadvanced) 
Reporting: SSRS (development, troubleshooting and optimizationadvanced) 
SQL Server replication (transactional, snapshot) (advanced) 
T-SQL; PL/SQL (development, troubleshooting and optimizationadvanced) 
OLTP performance troubleshooting (all RDBMS'''' listed aboveadvanced) 
RDBMS installation and configuration (all RDBMS'''' listed aboveadvanced) 
WSFC - Windows Server Failover Clustering (advanced) 
RDBMS upgrade/patching (all RDBMS'''' listed above) 
ORACLE RAC (basic) 
SQL Server Replication (to SQL Server and Oracle) (advanced)


DBMS: DB2 on iSeries (as400), MySQL, Cassandra, Elastic Search 
Data Modeling (physical/logical) - ErWin (basic) 
Attunity Replicate 
Vision Double Take Share 


Designs and executes overall database architecture strategy, standards and practices. 
Works closely with project teams to develop data models that support business processes. 
Works with application development to ensure database changes adhere to best practices and are properly prioritized and scheduled. 
Supports all areas of the enterprise - ensures that all databases run at optimal performance 
Proactively identifies and troubleshoots databases performance issues 
Ensures that industry wide security standards are properly implemented 
Develops and optimizes complex t-sql and PL/SQL code at advanced level 
Understands written business requirements and translates them into technical design 
Designs and develops SQL code; ETL processes and SSRS reports based on provided requirements 
Responds to business requests in a professional manner with high sense of urgency 
Works well under high levels of stress 
Participates in on-call rotation and occasional off-hours activities (DR tests; upgrades, etc 
Performs other duties as required or assigned which are reasonably within the scope of the activities enumerated above.

Thanks and Regards,

Shivangi Singh | Team Lead | KPG99, INC
Direct|  |