PROFESSIONAL SUMMARY:

• Looking forward for an opportunity in a challenging environment, where I can utilize my experience and skills in contribution effectively to the success of the organization and also for the improvement of my personal skills.
• Over 10 Years of IT Experience in the field of in IBM TDS and SDS versions (6.1,6.3 and 6.4), SDS 8.0.1 in VA and IBM DB2 UDB Development V8.2, V9.1, V9.5, V9.7, V10.1, V10.5 and V11.1 on Windows, AIX, LINUX, Z/Linux and SOLARIS, ISAM9, Q - Radar and Ansible.
• Hands on experience on IBM TDS (LDAP 6.1) and IBM SDS 6.4.
• Installation of SDS 6.4 for new servers along with DB2 10.5 also Install and Configure IBM Tivoli Directory Server (TDS) V6. x.
• Installing and configuring the Security Directory Suite 8.0.1.5 in VA with external DB2 database V10.5.FP9.
• Hands on experience in idsgenderksf tool.
• Hands on experience on web Admin tool.
• Configure TDS Proxy Server and TDS High Availability.
• Hands on experience on DPF in single and multi-environment.
• Hands on experience on SAP-DB2 environment (Installations, Configurations, Patches, Upgrades..etc)
• Hands on experience on IBM TDS (Tivoli Directory Server) i.e Installation and configuration, Object creation, mapping, High availability, Performance tuning, Troubleshooting..etc.
• Hands on experience on Installation and upgrade of SAP DB2 from DB2 V9.1 to V10.1.4.
• Provide Production/Application support in DB2 UDB and Oracle RDBMS technologies.
• Knowledge on IBM Tivoli Directory Integrator.
• Knowledge in DB2 in a WCS (WebSphere Commerce Server) environment.
• Hands on experience on using COCKPIT, SAP transaction stgn for monitoring activities as part of performance issues.
• Define, Design and Deploy appropriate TDS Schema and In-depth understanding of Bind and Search requests within TDS and Performance tuning of TDS and DB2.
• Reasonable exposure towards schema extension, additional attributes mapping, etc., Reasonable exposure towards schema extension, additional attributes mapping, etc.,
• Experience on IBM TDS (Tivoli Directory Server) i.e Installation and configuration, Object creation, mapping, High availability, Performance tuning, Troubleshooting..etc.
• Experience to search ids using idsldapsearch on regular basis and delete ID’s by using idsldapdelete
• Design a robust monitoring and event notification system utilizing existing monitoring software.
• Experience using Deep Compression/Adaptive compression using ADMIN TABLE MOVE, SAP tools like db6conv.
• Experienced in DB2 on AIX, Linux, Zlinux and windows.
• Performed database system and SQL performance tuning by rewriting SQL and using Snapshot, Table Function, Event Monitor, and OS commands (topas, vmstat, and iostat), updating DB and DBM configuration parameters, using Explain Plain, db2exfmt, and db2expln tools, and running the reorgchk, reorg, runstats and db2rbind commands.
• Implemented and managed DB2 Security using OS group and user ID, DB Authentication,
• DB Authorization, and database object privileges.
• Planned, designed, implemented, and promoted the physical databases, table spaces, tables, views, Indexes.
• Experienced in OPM - Optim Performance Manager / DB2 Performance Expert.
• Experienced in Replication.
• Established backup and recovery strategies (Full, Online backup) using Commvault and TSM.
• Involved in implementing HADR (High Availability Disaster Recovery) environment by preparing Primary database and Standby database, configuring parameter, and cloning the primary database (backing up primary database and restoring to standby database).
• Actively involved in DR Testing.
• Designed and implemented logical and physical database modeling using Erwin tool.
• Planned, Designed, and implemented MQT, and Data partitioning for improving performance.
• Planned, designed and implemented backup schedules and procedures, and DB system monitoring system with Unix Shell scripts on the Develop, UAT, and Production environment.
• Developed and implemented backup (online, offline), runstats, reorg, rebind, and tablespace capacity monitoring report using Korn shell scripts on DEV, QA (UAT), and PROD system
• Perform database capacity analysis, predict growth trends and forecast ancillary needs.
• Participate in staff rotations of “on-call” responsibilities.
• Performed Db2 Database Server migration.
• Work directly with developmental staff and supervise level 1 database while implementing applications of packages.
• Execute and run commands by using CLP and CLI.
• Experience of db2pd, db2advis, db2expln..etc
• Interact regularly with internal technical, applications and operational staff to ensure database integrity, security and availability.
• Usage of BASH or KSH on Linux platforms.
• Worked on configuration/troubleshooting federated database environment.
• Performed Database migration/upgrades between multiple versions.
• Good knowledge on Incident / Problem and Change management process.
• Experience on preparing in project related documents.
• Dedications with an inner drive to succeed and accomplish goals.
• Ability to perfectly plan and execute the given job to perfection.

TECHNICAL:

Database Products: DB2 UDB V8.x, V9.1, V9.5, V9.7, V10.1 & V10.5, Netezaa, Oracle, SQL. IBM TDS (LDAP) 6.1 & IBM SDS 6.4, 8.0.1

Operating Systems: UNIX, Linux, Solaris, Z/Linux, Windows, HP-Unix.

Languages: C, C++, J2EE, SAP-BASIS

Tools: Champs, Clear Quest, Impact, TSRM, Maximo.

Software: Shell Script, IBM Tivoli TSM, HADR, DB2 Utilities, DPF, Replication.

PROFESSIONAL EXPERIENCE:

Confidential

Technical Architect

Environment: DB2 v9.7, V10.1 & V10.5, IBM TDS (6.1 and 6.4), IBM SDS 6.4, IBM TDI, ISAM9, Ansible, IBM Remedy, SQL. PL/Sql, JAVA, TSM, RLinux, WINDOWS, Replication, Nagios, Q-Radar

Responsibilities:

• Maintain all DB2 related work.
• Installation of SDS 6.4FP14 for new servers along with DB2 10.5FP8 also Install and Configure IBM Tivoli Directory Server (TDS) V6. x.
• Installation of SDS 8.0.1FP5 on new OVA servers along with DB2 10.5FP9.
• Install and configuration of UnboundID Directory Server applications (Data Store, Data Proxy, and Data Sync).
• Experience on idsimigr tool.
• Experience on idsdb2idif and idif2db utilities.
• Experience on data load by using idsbulkload utility.
• Experience on configure the local db2 database and SDS instance configure to talk with remote DB2 database.
• Worked on apply certificates Digi Cert, CA Cert, SSL Cert..etc
• Experience on implementing replication context, group, subentry, credential and agreements.
• Involved LDAP servers build end-to-end process.
• Investigate and resolve performance or operational issues that include LDAP authentication, searches, replication, authorization, etc.
• Design and implemented the load balancer concept in LDAP environment.
• Implemented new schema and modifying the existing schemas as per the requirement.
• Implemented replication agreements between the servers for Active-Active methodology.
• Implemented the auto scripts for the regular work like user search, Group search, User delete..etc.
• Support OS Patching work between the datacenters.
• Setting up HADR with multiple auxiliary standby databases adn maintain the automatic as well as manual switchover/failover.
• Support the LDAP environment and work with other groups that rely on the LDAP service to resolve issues and/or integrate (configure) application to best work with LDAP.
• Perform capacity management; including forecasting for space, memory, processors, and backup media. Proactively manage space needs of databases, including objects, logs, and freespace. Ensure backup media availability is adequate.
• LDAP side need to monitor the replication alerts. If any replication pending change count gradually increasing and sequence number not changing, then will do the replication recycle by using idsldapexop.
• Handles capacity planning and scalability of production database platform.
• Ability to review LDIF logs via grep and standard UNIX tools to research issues.
• Update the certs as per the company standards.
• Solid understanding of Database technology - DB2 UDB Distributed databases including DPF.
• Experience to search ids using idsldapsearch on regular basis and delete ID’s by using idsldapdelete.
• Automation of LDAP tasks leveraging shell scripting (KSH, BASH).
• Load testing of servers to determine if system is underutilized or over utilized.
• Analyze existing applications to see how they utilize the existing LDAP directory service and work with teams to improve their queries and overall usage of LDAP.
• Troubleshoot more difficult or complex production slowdowns or bottlenecks and determine if OS environment or network is causing problem.
• Create new schemas or changing existing structures as per requirement.
• Need to search ids using idsldapsearch on regular basis.
• Configure TDS Proxy Server and TDS High Availability.
• Need to apply certificates if any expiration will sooner.
• Supported developers to write SQL statements and test them before running it in production environment. And also collect the full offline backup for the database before running the dprop.
• Designing, modeling, configuring, testing, and installing DB2 databases in the test, development, and production environments.
• Performing and troubleshooting database backup, recovery, capacity, and security plans.
• Administering, maintaining, and implementing changes to existing databases to meet customer requirements.
• Used Mapping rules for attribute transformation to pass custom attributes to application based on LDAP attributes
• Helped Ansible team to create roles for ISAM9 deployments upgraded ISAM9.0 to ISAM9.0.3
• Installation, upgrade, maintenance, troubleshoot of ISAM9.0.X
• Configured Federations and partners for SSO between applications
• Created reverse proxy instances, ACL, Objects, DynURL
• Responding to test and production database problems and implementing immediate resolution efforts across technology areas.
• Trouble shoots the database problems using db2diag.log.
• Coordinating with other teams in troubleshooting.
• Perform Runstats and Reorg as per the requirement.
• Apply fixpaks as per customer requirement.
• Tuning DB and DBM CFG parameters if needed.
• Need to review the performance of the systems in monthly basis and send report to end Clients.
• Define, Design and Deploy appropriate TDS Schema and In-depth understanding of Bind and Search requests within TDS and Performance tuning of TDS and DB2.
• Responsible for ID delete request by using idsldapdelete.
• Responsible for schema changes.
• Responsible for adding new attributes to DN.
• Reasonable exposure towards schema extension, additional attributes mapping, etc.,Reasonable exposure towards schema extension, additional attributes mapping, etc.,
• Installation of SDS 6.4 for new servers along with DB2 10.5.
• Experience on IBM TDS (Tivoli Directory Server) i.e. Installation and configuration, Object creation, mapping, High availability, Performance tuning, Troubleshooting..etc.
• Database backups and restore related activities.

Confidential

TDS & DB2 DBA Lead

Environment: DB2 V9.1, V9.5, v9.7, V10.1 & V10.5, Clear Quest, Impact, IBM TDS 6.1, SAP-BASIS, ABAP, JAVA, TSM, AIX, WINDOWS.

Responsibilities:

• As a DB2 DBA LEAD prepare the account related docs and send it to Sending GEO approval.
• Provide DB2 DBA LEAD support in DB2 UDB / Oracle technologies to a large group of developers and testers.
• Monitor the use of the database to identify opportunities for performance improvements.
• Upgraded SAP DB2 UDB Databases from v9.1 Fix Pack 6 to V10.1Fix pack 4.
• Involved LDAP servers build end-to-end process.
• Design and implemented the load balancer concept in LDAP environment.
• Design and implemented the load balancer concept in LDAP environment.
• Implemented new schema and modifying the existing schemas as per the requirement.
• Implemented replication agreements between the servers for Active-Active methodology.
• Implemented the auto scripts for the regular work like user search, Group search, User delete..etc.
• Support OS Patching work between the datacenters.
• Deep Compression/Adaptive compression using ADMIN TABLE MOVE and SAP related tools like DB2CONV.
• Query tuning for the problematic queries sent by application developer or identified during database monitoring.
• Performance Tuning of all UDB instances - identifying performance degrading factors and taking corrective measures to improve server and query performance. The tuning efforts ranged from physical I/O tuning, memory cache optimization, Application Tuning included query optimization and Proper index selectivity.
• Monitor table space growth statistics for the production databases and estimate the size for the month/year by actively participating in Capacity Planning meetings with users and managements and drew out relevant statistics for upper management to study.
• System crash and hang analysis - collecting stack trace, running db2support and uploading the same to SAP Support to investigate PMR.
• Designed and implemented strategy for running data reorg/runstats on timely basis for large tables to avoid data fragmentation and improves performance and system throughput.
• Involved in HADR setup, monitoring, Rolling up upgrades.
• Involved in DR activity.
• Indentified and tuned the expensive SQL queries on SAP Transactions and batch jobs.
• Database monitoring (free space in table spaces, event monitor outputs, security audit reports, performance reports etc.).
• SAP Data Refresh Process to Landscape project servers, development, and stage and Quality systems.
• Performing Database backups & recovery (offline & online full backups and Incremental).
• Moved tables to other table spaces using DB6CONV to avoid reaching Max limit on DB2 UDB v9.
• Collecting performance metrics, resource utilization and reporting to management on monthly (table space growth, CPU, memory usage and Disk I/O).
• Perform ad-hoc backups in case of backup failures and before projects rollout to production.

Confidential

DB2 DBA Lead

Environment: DB2 V9.1, V9.5 & V9.7, DPF, Remedy, AIX 6.0,Redhat Linux, Windows 2003, TSM, SAP-BASIS, ABAP, JAVA.

Responsibilities:

• Involve space estimation of servers with different tables (RCD, NCD, MDC and STD).
• Involve applying fixpak on HADR servers (roling change and both instance down).
• Provided 24*7 supports to over 100 database instances. This includes 15 UAT, 25 Development and over 50 Production DB2 Mission Critical databases running on AIX, and Windows 2000 environment. Databases included OLTP Batch Processing systems.
• Migrated DB2 v9.5 databases to DB2 V9.7
• Change Management - Schedule change, get approvals, do broadcast and work on change tickets.
• Data refresh Confidential table level and database refreshes across prod/non-prod environments
• Performance Tuning of all UDB instances - identifying performance degrading factors and taking corrective measures to improve server and query performance. The tuning efforts ranged from physical I/O tuning, memory cache optimization, Application Tuning included query optimization and Proper index selectivity.
• Monitor table space growth statistics for the production databases and estimate the size for the month/year by actively participating in Capacity Planning meetings with users and managements and drew out relevant statistics for upper management to study.
• SAP Data Refresh Process to Landscape project servers, development, stage and Quality systems.
• Moved tables to other table spaces using DB6CONV to avoid reaching Max limit on DB2 UDB v9.
• Installed/ Configured CDC in LUW/AIX,Redhot-Linux
• Supported developers to write SQL statements and test them before running it in production environment. And also collect the full offline backup for the database before running the dprop.
• Trouble shoots the database problems using db2diag.log.
• Coordinating with other teams in troubleshooting.
• Perform Runstats and Reorg as per the requirement.
• Apply fixpaks as per customer requirement.
• Tuning DB and DBM CFG parameters if needed.
• Working with SM7, Star team ticketing tools.
• Involved in Performance related issue.
• Involved in Application related issues.
• On-call support & Weekend support too.

Confidential

Senior DB2 DBA

Environment: DB2 V8.1, V8,2, V9.1 & V9.5, DPF, AIX 5.3, Champs, TSRM, Linux, ZLinux, WAS, TSM, JAVA.

Responsibilities:

• Tuning of db and dbm configuration parameters.
• Administration of DB2 databases on AIX and windows.
• Routine Maintenance and health checks.
• Performance tuning including query tuning and optimization.
• DB2 Installation and up gradation of instance on AIX and windows.
• DB2 HADR setup.
• TSM Cross node recovery of DB2 databases.
• Database (DB2 UDB) maintenance and support.
• Responding on daily user queries.
• Worked with data movement utilities IMPORT, LOAD, and EXPORT under high volume conditions.
• Database refresh as per the requirement.
• Involved in fix packs upgrades.
• Reverse engineering, schema generation & Complete compare using Erwin tool.
• Monitored backup operations, and schedules manual backups as needed
• Performed Redirect restore.
• Performed Database migration/upgrades between multiple versions.
• Daily and weekly database Maintenance activities such as backup, reorgchk, reorg, runstats and all related activities for OLTP database.
• Resolution of user queries: Resolution for the user queries for all above tasks and application errors which are affected due to database level issues in day to day basis.
• Sending daily and weekly reports and handovers.
• Involved in 24x7 support and On-call support.
• Involved with client interaction.

Confidential

Software Engineer (DB2 DBA)

Environment: DB2 V8.1, V8.2 & V9.1, AIX 5.3, Linux, Windows, JAVA, .NET, WAS.

Responsibilities:

• Installation of DB2 on LINUX and AIX environment.
• Monitoring and Tuning Database.
• Usage oftools like DB2 Load, Import, Export and Reorg, Runstats, Reorg Check, Backup, Restore, Db2move, and Db2look
• Performed Redirect restore.
• Performed Database migration/upgrades between multiple versions.
• Developing the database codes, scripts for databases
• Deploying store procedures for application users.
• Federation of DB2 databases across the environments.
• Explain and Snapshots, Buffer pools performance optimization, SQL performance evaluation, analysis, and optimization.
• Working and troubleshooting on day-to-day problems via opening and closing tickets.
• Troubleshooting DB2 interaction with other product.
• Automation of Functionalities like health checks, performance maintenance using shell scripting.
• Coordinating with other teams in troubleshooting.
• Created and configured Instances according to requirement.
• Trouble shoots the database problems using db2diag.log.
• Performed RUNSTATS utility to update the statistics.
• Reorganization of database performed periodically for best performance.
• Prepared and implemented backup and recovery procedures for off-line and on-line Backup.
• Tuned the performance of the database using snapshots and event monitors.
• Applying Fixpaks.
• Mentoring of Junior Resources.