SUMMARY

• Over 7 years of IT experience with emphasis on Database Administration, development, migration, Business Requirements Analysis, Application design, testing, implementation
• Maintenance of databases on DB2 UDB EE, DB2 UDB EEE and DB2 UDB ESE with DPF on LINUX, UNIX and Windows Platforms
• 7+ years of rich experience in Database Administration using DB2 UDB and with strong business knowledge of Financial, Insurance and Manufacturing projects
• Worked through all phases of system development life cycle and has performed as a senior DB2 UDB DBA
• Expertise in development support activities including installation, configuration and successful deployment of changes across all environments
• Migrating DB2 UDB databases and applying fix packs to keep DB2 at most recent level
• Provided production support for critical applications running on 24/7 basis
• Experience in implementing Backup and Recovery strategies, Q - Replication and developing Architecture for building a database by using tools like Erwin and writing necessary Shell scripts
• Running utilities like LOAD, COPY, IMPORT, EXPORT, REORG, RUNSTATS, REBIND
• Worked with third party tools like TSM, BMC Patrol, VERITAS Net backup, Remedy, and Toad.
• Database maintenance, backup, recovery, performance monitoring, tuning, maintenance of logs, problem identification and resolution, security and disaster recovery planning
• Extensive DB2 DBA and DB2 Connect experience with activities involving design, installation, configuration, requirements gathering, data modeling, tuning, security, backup, recovery and integration of database applications.
• Experienced in setting up backup policies and retention policies using Tivoli Storage Manager and Veritas net backup and do the alignment from db2 databases
• Test and schedule and report any failures and apply upgrades and maintain raise PMR with IBM for any unknown issues.
• Wrote Several Complex Stored Procedures, Functions and worked on performance tuning and wrote Perl, korn shell, Jmeter scripts for stress test.
• Familiarity and experience with data warehousing and DB2 Pure scale, Data center Replication Symmetrix Replication Data Facility (SRDF).
• Excellent analytical and functional skills with strong communication and interpersonal skills.
• Actively involved in the full project life cycle, user requirements to implementation. Willing to learn and adapt to new challenges
• We discovered that DB2 Health Monitor was causing heavy locking and slow connection times in our heavy transaction volume application.
• Every two hours, when DB2HMON would fire, it would drag the entire system down. We solved the problem by deactivating Health Monitor.

TECHNICAL SKILLS

Operating Systems: Linux (Redhat, SuSe), AIX 5L/V6.1/ V7.1, SUN Solaris 5.10/5.11, HP/UX and Windows 2007/NT/XP.

Hardware: IBM and SUN machines

Environment: DB2 V9.1, DB2 V9.5/V9.7 and DB2 V10.1, Oracle 11g, SQL Server 2000, IBM Informix

Tools: Quest Central, BMC Patrol, JS Console, DB Artisan, Control Center, Foglight and Visual Explain.

Computer languages: Perl, PL/SQL, C, C++, SQL, .Net, Vb.Net, PHP

Software Packages: Lotus Notes, MS Office XP, MS Visio, Rational Rose

Shell Scripting: KSH, Bash, Perl and C shell

PROFESSIONAL EXPERIENCE

Confidential, New York City, NY

DB2 UDB LUW DBA

Responsibilities:

• Involved in Design and development of logical and physical layers of databases.
• Installation and configuration. Of different versions of 10.x/9.x DB2 UDB on AIX 5.x.
• Worked on HADR setup with Tivoli System Automation (TSA).
• Created database and managed various database objects like indexes, tables and Tablespaces.
• Collected the database statistics using RUNSTAT, REORG, REORGCHK utilities and involved in analyzing the statistics
• Created scripts for backup, recovery and roll forward for the databases on weekly bases
• Used Import, Export and Load utilities in accordance with db2move command to populate large amount of data like databases.
• Designed and implemented back-up, recovery, archiving, and conversion strategies.
• Responsible for Database performance tuning analysis.
• Responsible for backup and logging/recovery policy.
• Developed database security strategy to provide access to large number of users in production environment.
• Install, configure and test new LDAP DB2 plug-in; work with Security Analysts to develop new DB2 security policy24X7 on-call support and problem resolution.
• Provided technical assistance and mentoring to staff for developing conceptual and logical database design and the physical database.
• Responsible for monitoring database and perform tuning when necessary.

ENVIRONMENT: DB2 V10.x/9.x, AIX 5.x, DBArtisan, Visual Explain, BMC Patrol, IBM Performance Expert, windows NT/XP, Server, Erwin, SAN.

Confidential, California

DB2 DBA

Responsibilities:

• Efficiently carried out backup and recovery processes including Redirected Restore.
• Worked on configuring and maintaining the High Availability Disaster Recovery (HADR) feature.
• Worked closely with the RUNSTAT, REORG and REORGCHK utilities, created the Reorg script to reorg tables that has high fragmentation ratio in the REORGCHK report.
• Proven Linux/UNIX experience, including shell scripting.
• Broad knowledge in the development and tuning of SQL.
• Proactively monitored large-scale production DB2 LUW database subsystems to avoid unscheduled outages.
• Supported the product development and test teams through the SDLC process. Produce technical documentation.
• Responsible for upgrading DB2 from V8 to V9. x.
• Installed Sybase on UNIX Systems and applied required patches by monitoring new patch releases
• Created Sybase user logins with appropriate roles, unlocked the logins, and monitored the user accounts.
• Checked for Sybase database consistency, fixing DBCC errors, monitoring of error logs regularly
• Provided exceptional technical expertise in supporting large-scale 24x7 operational production subsystems including maintenance
• Tuning,performance analysis, capacity and availability planning, resource utilization, utilities,security and troubleshooting.

ENVIRONMENT: DB2 UDB V9.x/V10, Sybase 11, AIX 5.3 64 bit, DB2 Development Center, WebSphere 5.x/6.x, and Erwin.

Confidential

DB2 DBA

Responsibilities:

• Perform database maintenance activities such as backup, reorg, runstats.
• Install and configure DB2 UDB new releases, upgrades, and patches.
• Scripting, design/analysis, installation, monitoring, maintaining, troubleshooting, and tuning UDB databases.
• Analyze DB2 UDB Event Monitor information, physical design, performance characteristics of tablespaces, physical I/O rates, and table access activities.
• Responsible for proactively monitoring performance, diagnosing problems and tuning queries and databases.
• Assisting with the creation and modification of primary database storage structures (tablespaces) and primary objects (tables, views, indexes)
• Implemented data security guidelines while making data available to those authorized to have access.
• Create and maintain documentation such as Functional design documents, detailed design documents, data flow diagrams, data entity relationships documents for all the internal projects.
• Interface with business analysts & developers with regards to application, logical & physical database design, create and maintain logical entity relationship diagrams, transform logical models into physical data models.
• Changing instance level and database level configuration parameters for database concurrency, authentication, performance and allowing remote clients accessing server.
• Provide 24X7 on-call support to troubleshoot issues with the Production schedule.

ENVIRONMENT: IBM and SUN machines, AIX 5.2 and 5.3, Windows NT/XP, DB2 V8.2, DB2 V9.1, Foglight and Quest Central.