HOTLIST: DB2 UDB DBA Available Immediate

Skill: DB2 UDB DBA

Available Immediate

 

SUMMARY:

 

Ø  7 and half years of IT experience involving database administration at all phases of software development lifecycle i.e. design, development, implementation and maintenance of databases using DB2 V7.x/8.x/9.1/9.5/9.7 to support applications on AIX, Linux, Solaris, HP-UX and Windows environments.

Ø  Extensive experience supporting DB2 system administration, application development, troubleshooting and resolving DB2 issues, performance tuning, monitoring data security and integrity.

Ø  Expertise in installation of the IBM DB2 products and latest fix packs and maintaining DB2 environment including creating instances, databases, buffer pools, tablespaces and tables.

Ø  Proficient in implementing backup and recovery strategies, developing Architecture for building a database by using tools like Erwin, ER/Studio.

Ø  Worked on database utilities including re-org, runstats, rebind, export, import, load, backup, restore and roll forward utilities.

Ø  Database monitoring and tuning experience using DB2’s Performance Monitor, Snapshot Monitor, Event Monitor, Explain, Visual Explain, and Index Advisor performance tools.

Ø  Experience in DB2 compression to resolve unexpected data growth and save storage space.

Ø  Skillful in handling IBM Federation server issues. Creating Wrappers, Server definitions, Nicknames, User Mapping, Federated procedures from Sybase, DB2, Oracle, SQL Server and all kinds of files.

Ø  Experience in HADR/HACMP setup between primary and secondary servers to ensure High Availability.

Ø  Worked with third party utilities and tools like Quest Tools, IBM Data Studio, BMC Tools, DBArtisan, Toad, Performance Expert and Optim tools etc.

Ø  Excellent communication capabilities and being able to work independently with minimal or no guidance.

Ø  Extensive experience in writing Korn shell scripts and using AWK, SED, GAWK.

Ø  Proficient in scheduling/maintaining CRON/Autosys jobs based on application requirement.

Ø  Provide 24x7 on call support for databases supporting mission critical applications and off-hours maintenance.

 

 

 

TECHNICAL SKILLS:

 

RDBMS                        :                        DB2 7.x/8.x/9.1/9.5/9.7, SQL Server 2005, Oracle 10g, 11g

Operating Systems     :                   UNIX (AIX 4.x/5.L,6.1 Linux),Windows XP/NT/2000/2008

Database Tools           :                     DB2 Client, DB2 Connect, DB2 Replication Center, DB2 Federation Server, IBM Data Studio, BMC & Quest Tools, Toad, VERITAS NetBackup, IBM MTRK, DB2 Utilities, Optim tools

ETL Tools                     :                       Informatica 8.6.1, SSIS, Datastage

Reporting Tools           :     Business Objects (BOXI R2), SSRS

Application Servers     :                  Web sphere 4.x/5.0/6.0, Apache Tomcat Server

Languages                   :                      Shell Scripting (Bash, Korn), DB2 SQL PL, T-SQL, SQL/PL, .NET, C

Modeling                      :                     Erwin, IBM InfoSphere Data Architect

Query Software Tools  :                Advanced Query Tool v9

 

 

 

 

 

 

Regards,
 
Rao

Key Business Solutions, Inc.

|| Phone: 916 668 9539|| Fax: 916 646 2081 || || Email: rao@key-soft.com || Website: www.key-soft.com ||

Note: This email is not intended to be a solicitation.  Please accept our apologies and reply in the subject heading with REMOVE to be removed from our Mailing list.

P   7 Ways You Can Easily Save Paper and Avoid Killing the Environment