Uploaded File
no photo
Sandeep
DB2 LUW DBA
W2 Arlington, TX
12/29/2024
Not looking
no photo
Sandeep
150
views
DB2 LUW DBA
2 recommendations
2
Recommendations
Average rating
150
Profile views
Data Replication DB2 DB2 LUW DB2 PE DBA Performance Tuning Shell Scripts UDB AIX Capacity Planning
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 Erwin Data Modler SQL
DB2 LUW DBA 11/11 - 09/13
DBA DB2 DB2 LUW DB2 PE Shell Scripts SQL Data Replication UDB Performance Tuning MySQL Perl HADR Database Backups Database Design Performance Testing Quality Assurance
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 DB2 Connect
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
Data Replication
2016
DB2
2016
DB2 LUW
2016
DB2 PE
2016
DBA
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