Role : DB2 LUW Database Administator
Location : Milwaukee,WI
Duration : 12 month
Required Skills:
DB2 LUW
Job Description:
System Software Engineer Consultant - The individual will function as the primary subject matter expert for DB2 LUW database administration service operations.
This involves performing incident and problem resolution, standard service requests, infrastructure monitoring and alert response, and consultation with application support and development staff.
The individual will be part of a 24x7 on-call rotation.
• Experience in DB2 LUW database administration skills including installation, patching, configuration, monitoring, performance tuning and trouble shooting.
• Skilled in supporting various DB2 LUW versions (v9.7 and V10.1)
• Provide application database support services: apply schema changes, restores, backups, data refreshes.
• Provide support for BCP exercises and actual disaster recovery.
• Participate in security audits by assisting investigators in gathering and documenting evidence.
• Experience in implementing DB2 LUW advanced features: HADR, range partitioning, compression and BLU technologies.
• Should have the intellect to resolve complex problems logically and methodically, and good judgment to involve and communicate with vendors, internal teams and management.
• Knowledge of other infrastructure technologies - e.g., Unix/AIX OS and storages subsystems and networking.
• Ability to write complex shell scripts ( kornshell, perl etc) for database maintenance automation and testing
• Monitors and refines processes, procedures, and systems to optimize effectiveness and/or integrity and recommends and/or implements improvements.
• Participate in security audits by assisting investigations, evaluating evidence, developing responses and action plans, and making appropriate modifications to technology, processes, and documentation.
• Competency in ITIL processes: Incident, Problem, Knowledge and Change Management The following skills, while not required, are also helpful:
• Knowledge of other database technologies: SQL Server, Oracle, Netezza.
• Knowledge of ETL and business intelligence tools: Informatica, Business objects.
• Familiarity with Web Applications: WebSphere, process server. .
• Agile/Scrum methodology knowledge.• Data modeling skills (Power Designer).