SUMMARY:

• 11+ years of IT experience involving database administration (DB2, Oracle & SQL Server) at all phases of software development lifecycle i.e. Architecture, Development, Analysis, Design, Testing, implementation and maintenance of databases using DB2 V8.x/ 9.1/9.5/9.7/10.1/10.5 to support applications on Unix, AIX, HP UX & Linux, Windows environments.
• Extensive experience supporting DB2, Oracle and SQL Server administration with L2 & L3 activities, application development, troubleshooting and resolving DB2 issues, performance tuning, monitoring data security and integrity.
• Install and Configure the Q Replication, Golden Gate, HVR for production databases
• Expertise in Installing Base code/Latest Fix packs and maintaining database environment including creating instances, databases, buffer pools, logical and physical design of database storages using DMS/SMS tablespaces (allocating containers).
• Versed in both In - place and Side-by-side migration of instances and databases to current version.
• Proficient in implementing Replication, backup & recovery Strategies, developing Architecture for building a database by using tools like Erwin.
• Database utility experience including re-org, runstats, rebind, export, import, load, auto-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.
• Worked extensively on features of DB2 Connect, DB2 Client and IBM Web Sphere Federation Server.
• 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 Setup HADR/HACMP between primary and secondary servers to ensure High Availability.
• Worked with Third party utilities like Quest Tools, IBM Data Studio, DBArtisan, Toad, Performance Expert, Foglight etc.
• Effective communication capabilities and being able to work productively with multilevel personnel.
• Extensive Experience in writing Korn shell scripts and using AWK, SED, GAWK.
• Proficient in Scheduling/Maintaining CRON/Db2 administrative scheduler jobs based on application requirement.
• Provide 24x7 on call support for databases supporting online applications and off-hours maintenance.

TECHNICAL SKILLS:

RDBMS: DB2 7.x/8.x/9.1/9.5/9.7,10.1,10.5 Oracle 9i/10g/11g, SQL Server

Database Tools: DB2 Client, DB2 Connect, DB2 Replication Center, DB2 Federation Server, IBM Data Studio, Quest Tools, Toad for DB2, DB Artisan for DB2 VERITAS NetBackup, DB2 Utilities

Application Server: WebSphere Application Server, WebSphere MQ, jBoss, Jetty, Apache, Operating Systems: UNIX (AIX 4/5/6x/7x Linux, HP-UX), Windows

Scripting/Languages: Shell Scripting (Bash, Korn), DB2 SQL PL, T-SQL, SQL/PL, Perl

Schedulers: Cron Jobs, Windows Scheduler, Db2 Administrative Scheduler

Automation: Ansible, RunDeck, CA Release Automation (Nolio)ERP: SAP ERP, SAP BW

Big Data: Apache Spark, Hadoop

PROFESSIONAL EXPERIENCE:

Confidential

Senior DB2 DBA

Responsibilities:

• Design, develop and maintain Production, staging, test and development DB2 databases on AIX/Linux and Windows platforms.
• Install and Configure the Q Replication for production databases
• Complete setup of HADR environment.
• Experience on replication using Replication Center
• Develop specifications for building New/Cloned DB2 database servers to meet the application requirements, verifying and validating servers after the build.
• Develop guidelines for migrating databases to new servers/cloned servers and execute migrations. Install Product base codes, Fix Packs (full and alternate), apply Emergency Fixes, create/upgrade/drop instances/databases on database servers regularly as per business requirement and need.
• Perform both In-place and side-by-side Migration of instances and databases from v9.5 to v9.7 and 9.7 to 10.5
• Implement LOGARCHMETH1, LOGARCHMETH2 & FAILARCHPATH to enable archival logging and Implications during recovery situations.
• Use db2greg tool to remove Instance, DAS, DAS Service, DB2 service registry entries from Global Registry on cloned servers while uninstalling older versions of DB2.
• Build new/cloned DB2 Connect servers, install DB2 Connect software and apply Fix Packs.
• Install and Upgrade various versions of DB2 Client on Database Servers/Application servers/Workstations.
• Perform Disk management by Monitoring volume groups/file systems growth, add additional disk space to volume groups/ file systems, create new file systems and allocate file systems to new databases.
• Run db2mtrk to provide complete report of memory status for instances/databases/agents, db2top and db2pd utilities to identify the cause of suboptimal performance and tuned databases.
• Create Automatic Storage Database, Self-Tuning Bufferpools, implement Self Tuning Memory Management (STMM) and performed several rounds of workload test and computed the configuration parameters to setup hard limits
• Used third party vendor tools like Quest Central v 5.0, Toad, for regular database administration.
• Expertise in SQL tuning, DB/DBM parameter tuning, different levels of memory allocations, various tools like export, import, load, autoloader and experience with all kinds of database snapshots.
• Work extensively with backups (Offline and online), restores, redirected restores and Unicode conversions.
• Recover data to a prior point in time using ROLLFORWARD recovery.
• Responsible for performance tuning, support, analysis and resolution of database problems that occurs during the critical time processing.
• 24X7 Production DBA support for application development, deployment and support activities.
• Golden Gate Implementation on SQL Server Cluster
• Responsible for the full lifecycle of all Microsoft SQL Server infrastructure within an environment
• Database Availability, maintenance and upgrades including: SQL Server 2000, 2005, 2008, 2008 R2, 2012 and 2014.
• In depth knowledge of SQL server that enables advanced troubleshooting of production performance and system issues.
• Expertise in Implementing high availability with failover clustering
• In-depth knowledge of high availability and disaster recovery solutions such as: database mirroring, log shipping, replication, Always ON, backup and recovery.
• Worked with multi-terabyte databases in OLTP Environment
• Handled OLTP (up to 25 TB) & Warehouse databases (up to 35 TB) with thousand transactions per second
• SQL Server operational support (24x7)
• Standardization of SQL Server environments
• Migrate / Upgrade of transactional & decision systems using golden gate
• Implementation of Oracle RAC databases (2 node cluster) with golden gate on a cluster mode
• Installing Oracle 12c, 11g software and configuring the RAC Databases on Linux, SunSolaris.
• Installing GoldenGate 12c, 11gR2 software and configured Bi-Directional & Peer to peer setup.
• Configured Oracle RAC databases on ASM and performing day to day activities on ASM instances.
• Expertise in RAC databases upgradations and Migrations from Oracle 10g to 11g and from SunSolaris to Linux.
• Supporting Oracle Data warehouse databases.
• Configured Oracle Enterprise Manger 12c/11g/10g for monitoring the database alerts.
• Expertise in database performance tuning-Memory tuning, Network, Parameter tuning and query tuning.
• Implementation of DB2 PureScale databases for the transactional systems
• Zero downtime upgrades for the Transactional systems (running in Oracle, DB2 & SQL databases) using replication technologies like Q replication and Golden Gate
• Performance tuning of the poor running SQL's across DB's
• Managing the build / engineering team to build the infrastructure for applications including Web, App and database technologies
• Exploring the new technologies including Big Data solutions and recommend them
• Performing POC's and designing Cassandra databases as replacement for the traditional RDBMS
• Automating the repetitive tasks includes application deployment and infrastructure builds using Ansible and RunDeck
• Automation of Production deployments using CA Release Automation tool (Nolio)
• Provide insight and recommend the long-term IT infrastructure architecture across multiple systems
• Convert business requirements to technical specifications and tasks for the project teams
• Prioritize recommendations and input on risks and benefits for infrastructure systems designs
• Overseeing and supporting team interactions with architects and principal consultants to ensure functional specifications are converted into system designs
• Reviewing and approving technical specifications
• Escalation point for issues related to requirements translation and its implementation
• Manages and owns the technical direction for the development and modification of infrastructure solutions
• Guiding and driving physical architecture design for new initiatives
• Managing the development of hardware and software configurations and the preparation of system components for installation to the infrastructure

Confidential

System Software Engineer

Responsibilities:

• Configuring & maintaining SAP ECC application & database
• SAP ERP and Net weaver Installation
• Upgrading existing systems to latest releases
• Kernel upgrade
• System Profiles and its maintenance
• User Maintenance
• Client copy
• Troubleshooting performance bottlenecks both in SAP and the database
• Backup Scheduling thru DB13 and monitoring thru DB12
• Cataloging Databases on various nodes.
• Upgradation of Fixpak
• Migration of the Databases from one Instance to other Instances.
• Restoration of the Database
• Extending Table space pages.
• Handling table space and file systems space issues.
• Implemented database policy for backing up data on daily basis.
• Used Utilities like DB2look, Export, Import, Run stats, Reorg.
• Update DBM, DB and Db2set parameters
• Using explain plan to check the cost of the query
• Running db2advis and give optimized query to the development team
• Writing scripts for backup, redirected restore, privilege, reorg, runstats and performance monitoring
• Implementation of Row Compression in SAP Environment and in Test DatabasesConfiguration and Maintenance of STMM in V9 and V9.5
• Implementation of Range Partitioning
• Implementation of LBAC in Test Environment
• Implementation of XML Databases in Test Environment

Confidential

System Engineer

Responsibilities:

• Gathering and understanding of the system / client requirements / functionality
• Instance Creation and maintenance
• Database creation, Maintenance of the Databases.
• Cataloging Databases on various nodes.
• Upgradation of Fixpak
• Migration of the Databases from one Instance to other Instances.
• Restoration of the Database
• Redirect Restoration of the database.
• Scripts rollout in Production, Development, and Staging Env.
• Tickets handling based upon the Priority (Like urgent, High, Medium, Low)
• The Complete design, Sizing of Buffer pool, Table Space etc.,
• Provided Support for application developers by providing SQL, testing SQL’s, Troubleshooting application problems.
• Extending Table space pages.
• Handling table space and file systems space issues.
• Resolving the Problem tickets of different severity levels during on-call support.
• Implemented database policy for backing up data on daily basis.
• Used Utilities like DB2look, Export, Import, Run stats, Reorg.
• Monitoring the scheduled jobs like backups, Runstats, reorg etc.,
• Backup and Recovery
• Update DBM, DB and Db2set parameters
• Using explain plan to check the cost of the query
• Running db2advis and give optimized query to the development team
• Writing scripts for backup, redirected restore, privilege, reorg, runstats and performance monitoring

Confidential

Project Engineer

Responsibilities:

• Installation, configuration and maintenance of the DB2 databases and its instances
• Cataloging Databases on various nodes.
• Fixpack upgrades
• Migration of the Databases from one Instance to other Instances.
• Restoration and Redirect Restoration of the database.
• The Complete design, Sizing of Buffer pool, Table Space, Index handling, tuning the database parameters to handle searching, sorting, creating views etc.,
• Extending Table space
• Handling table space and file systems space issues
• Backup and Recovery
• Reviewing the migration and space requirements
• Recording the configuration setting before migration
• Changing the diagnostic level
• Migration of non-partitioned database
• Updating the configuration settings
• Backing up and restoration of the database
• Worked on import, export and load utilities
• Configuring the nodes in DB2 which participates in the partition
• Creating the partitioned database
• Verifying the databases created in the partition
• Materialized query tables