Uploaded File
no photo
Sandeep
DB2 LUW DBA
Arlington, TX
01/01/2025
Not looking
no photo
Sandeep
103
views
DB2 LUW DBA
2 recommendations
2
Recommendations
Average rating
103
Profile views
DBA AIX Stored Procedure Performance Tuning UDB Data Replication Capacity Planning Shell Scripts IBM WebSphere DB2 PE
Remove Note
View Note
Recent Experience
DB2 LUW DBA 09/14 - 03/16
DBA Database Backups Database Design DB2 DB2 LUW DB2 PE IBM WebSphere Shell Scripts Capacity Planning UDB Performance Tuning Stored Procedure Data Replication HADR AIX Windows Performance Monitoring Risk Management
DB2 LUW DBA 11/11 - 09/13
DBA DB2 DB2 LUW DB2 PE Shell Scripts SQL Data Replication UDB Performance Tuning MySQL Perl HADR
DB2 LUW DBA 03/09 - 10/11
DBA Data Replication DB2 DB2 LUW DB2 PE IBM WebSphere Capacity Planning Shell Scripts SQL AIX Performance Tuning Erwin Data Modler Stored Procedure Perl UDB Data Migration
Summary

* DB2 Database Administrator with 6 + extensive experience in Database design, development, deployment and administration on LUW platforms.

* Skilled experience in installing and configuring DB2 9.x versions and fix packs on UNIX, Linux or Windows operating system efficiently.

* Eternal knowledge in designing physical, logical and relational databases, development and maintenance.

* Experience working with very large databases on Data Partitioning Feature (DPF) environment.

* Developed many reusable shell scripts for monitoring and performing daily and weekly tasks. Developed automated system for production BACKUPS, REORGS, RUNSTATS.

* Expertise in Backup, Recovery and roll forward techniques.

* Efficient professional in working with movement and maintenance utilities like move, export, import, look, runstats, reorg, reorgchk, rebind, and flush package cache.

* High skills in monitoring and performance tuning a database using snapshots and event monitors. Troubleshooting SQL statements with the help of Explains, db2advis, db2exfmt schema changes and configuration changes.

* Experience in developing disaster recovery techniques in HADR (High Availability Data Recovery) environment.

* Skilled in developing SQL queries, packages, triggers and stored procedures.

* IBM Certified Database Associate.

Top 5 Skills
SkillsProficiencyLast Used
DBA
2016
AIX
2016
Stored Procedure
2016
Performance Tuning
2016
UDB
2016
Education and Certifications
IBM Certified Database Associate,
Preferences
Immediately
Willing to relocate?:Yes
Relocation preference
Any location
Prepared to Travel:No travel (0%)
Employment Type:Contract
Security Clearance:No clearance
Citizenship:Employment Authorization Document