SUMMARY

• More than 27 years of experience in Software Analysis, design, development, testing and implementation.
• Specializing in developing Application Software using IBM Mainframes, RDBMS and Client /Server environment.
• For more than 19 years, I am being involved in managing the database administration including SQL Server 7/2005/2008/2005/2010/2012/2014 , Oracle7/8/8i/9i/10g/11g, DB2 UDB 6/7./8.X/9, 10.5 /11 & DB2 on RDBMS’s on HP UNIX, Sun Solaris, and AIX & OS/390. Experienced in Infrastructure Deployment Installation, Configuration and Administration of ERP Applications such as PeopleSoft 8.3 HRMS 8.8, FIN8.1x/8.44, and PeopleSoft 8.1 x Supply Chain Management, EPM, Portal, Student Admin 8.21, and CRM 8.8/9.0/9.2 with Oracle 9i/10g/11g/12C DB2 UDB /DB2 V6/7/8 on OS/390 as backend in multi platform environments.

TECHNICAL SKILLS

Hardware: RS/6000 SP & Pseries, E Series, Power 5 Servers, SUNW sparc,,ESS - 800, DS4800,DS6800,DS8000,Ultra-Enterprise, HP Tru64, EMC CLARiion CX series. Dell 1650,6650, Dell PowerEdge 1950,2900, Blade Servers HS20-21

Operating Systems: Windows NT/2000 to 2012,MVS, Z/OS, AS/400, HP/UX 10.0, Sun Solaris 8/9/10, AIX 4.3/5.3,6.x/7.x, Linux 4 to 7

RDBMS: Oracle 7/8/8i/9i/10g/11g/12c, DB2 UDB V6.1/7.x/8.x/9/10/11 & DB2 V4,5,6,7,8,9,10 OS/390/Z/OS,SQLServer 2000/2005/2008/2012/2014/2016 , Informix, SYBASE

OSRDBMS: PostgreSQL

RDS: Oracle,MYSQL,PostgreSQL,SQL Server

Cloud Solution: Confidential Web Services (AWS ), Microsoft Azure, Google & IBM Softlayer

Big Data: MongoDB, Hadoop

ERP: PeopleSoft 8.14 (Supply Chain Management), PeopleSoft8.3, HRMS 8.8/8.9,Student Admin 8.42,9.0, EMP, Portal 8.4,9.0, 9.1 CRM PeopleSoft design tools, PSADMIN, Data mover, query, upgrade Assistant, Seibel V7.x,SAP V 3/4.6, DBACockpit,SAP DB2Admin, BRBACKUP, BRARCHIVE, BRRESTORE, BRRECOVER, BRSPACE, BRCONNECT, and BRTOOLS Utilities, Lawson HCM

Clustering Tools: IBM HACMP 5.1, TSA, Xkoto GridScaleServer, EMC, Veritas Clustering, Flash Copy, Peer to Peer remote Copy(PPRC), Oracle RAC ( Real Application Cluster),DataGaurd,ASM, Quest SharePlex for Oracle, DataGuard

Disaster Recovery: VMWare Tools, IBM Tivoli Storage Management(TSM), Flash Copy, Peer to Peer Remote Copy(PPRC)/, EMC SnapView,MirrorView, Sun's StorageTek Virtual Storage Manager (VSM). VERITAS

WebServes: IBM Web Sphere, BEA WebLogic,IIS, iPlanet, Oracle 10G application Server

Connectivity Tool: IBM DB2 Connect, Relational Connect, Oracle Gateway

Replication Tool: Data Propagator,DB2 Replication Center (SQL Replications, Q Replications), WebSphere ( information integrator), Oracle Streams

DBA Tools for Oracle: Platinum DBvision, Tsreog, BMC Patrol, SQL Backtrac, Oracle, Enterprise Manager, RMAN, Import, Export, Oracle Data Guard, Flash Back, Automate Storage Management(ASM), Grid Control, DBCA,DBUA, SQL*Loader, SQL*DBA, Replication Manager, Quest Database Admin Tools, Oracle Ware House Builder

DB2 OS/390 tools: Platinum Database Analyzer, Plan Analyzer, Subsystem Analyzer, SQL Easy, RC/Migrator, RC/Security, Log Analyzer, CA Unicenter, CA7

DB2 UDB tools: BMC Patrol for DB2 UDB, IBM Relational Connect, DB2 Connect, Data Propagator, Quest Central for DB2 UDB/, BMC Web DBA, DGI SQL Guy, Wise Guy, MQ Series,IBM Data Studio .

Data Warehousing: Oracle Discoverer, Oracle Express, IBM Data Warehouse Center, IBM Ware House Manager, MicroStrategy,Informatica,Cognos

Design: Designer 2000, Erwin, ER - Studio

Front End: Developer 2000 - Forms 4.5, Reports 2.5, Graphics 2.5, Power builder 5.0

Languages: COBOL, C, Pro*C, JCL, Perl, Python

PROFESSIONAL EXPERIENCE

Confidential

SQL Server DBA

Responsibilities:

• Hands on experience in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server from 2005/2008 to 2012 on Clustered and Standby Environments.
• Expertise in complete Software Development Life Cycle (SDLC) - Analysis, Design, Development, Deployment and Testing.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Worked on logical and physical data base modeling with UML and ERWIN tools.
• Excellent knowledge in RDBMS concepts and constructs along with Objects creation such as Database, Table, Normalization, UDF, User Defined Data Type, Indexes, Views, Cursors and Triggers.
• Experience in using SQL Server Tools like DTS, Import/Export Wizard, SQL Server Enterprise Manager, SQL Profiler and SQL Query Analyzer.
• Master in performing administrative tasks: database files management, backup/restore, Security Management, Database Mirroring, Data Integration and Synchronization.
• Hands on experience with T-SQL (DDL, DML, DCL) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.
• Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2005/2008/2012/2014.
• Solid experience on high availability SQL Server solutions, including Replication Models (Snapshot/Transactional) and SQL Server clustering (Active-Active, Active-Passive).
• Experience in using SSIS (SQL Server Integration Services) for data extraction, transformation and loading across different databases like Oracle, MS Access and flat files using tools like Import and Export Wizard, Package Installation and SSIS Package Designer.
• Experience in designing/generating/using/deploying Visual Studio Business Intelligence Reports, SQL Server Reporting Services (SSRS), and Crystal Reports.
• Data replication from SQL Server to DB2 AS/400 using SSIS
• Also worked migration DB2 AS/400 to Open RDBMS like SQL Server and Oracle.

DB2 DBA

Confidential

Responsibilities:

• Database migrating from Oracle 8I to DB2 UDB 6.1 for BEA WebLogic
• More than 60 DB2 UDB Database upgraded/Migrated from V7 to V8 to V9,V9 to 10 and V10 to V11.
• Good experience in migrating databases from SYBASE, SQL Server to DB2 UDB.
• Upgrade more then 5 Oracle instances from V9i to 10g using DBUA
• Migrating database from one environment to another environment by using Redirect Restore process.
• Performance tuning for PeopleSoft, application (SQL) by using Quest Central & db2 index adviser (DB2ADVIS), database manager & Database parameters by using Snap motor, event monitor & Control center .
• Automating all database utilities, RUNSTATS, REORGCHK, REORG, QUIESCE, DB2RBIND
• Preparing DBA standards for DB2 UDB & Implementing for all the environments (DMO, DEV, SYS, QA1, QA2) for all software (PeopleSoft, Siebel, BEA WebLogic)
• Good exposure in migrating from DB2 to Oracle or Oracle to DB2, Migrated around 100 database from Oracl8i to DB2 UDB V7/8 on Solaris & AIX environments.
• Very much comfortable to designing distributed database, setting Database replication on UDB DB2 EEE/DPF .
• Configuring database partition, setting High Availability Cluster Multi-processing (HACMP)/HADR (High Availability Deserter Recovery) for Unix AIX for DB2 UDB.
• DR (Disaster Recovery) recovery strategies design & implementation for DB2 UDB ( HACMP,HADR, For IBM/EMC Snapview,MirrorView/Veritas Flash Copy, Peer to Peer Remote Copy (PPRC), setup Physical to Logical, Logical to Physical by using VMware and IBM TSM with Zero Down time & Desktop and Server Virtualization.

Oracle DBA

Confidential

Responsibilities:

• Setup one-way, bi-directional Oracle streams setup from Oracle, non Oracle databases
• Creation of database under Oracle 8.0.5/8i for Development and Production environments
• Laying out logical and physical designs, mirroring of redo logs and rollback segments.
• Creation of table spaces meant for storing data and index segments.
• Laying out strategies for the physical distribution of the control files, redo log files and data files related to the database across the disk volumes.
• Database designing, Creating instance, Creating Database.
• Configuring Database Manager & Database
• Creating backup & recovery strategies, Implementing Incremental & delta backup, Database disaster recovery
• Configured, implemented 10g RAC with ASM disk on Linux servers EMC /IBM·
• Performed several RDBMS upgrades from 8i to 9i, 8i to 10g, 11g on Multi platform.
• Expert in 10G Oracle RDBMS installation on Linux platforms (32 and 64 bit), upgrade, configuration, backup, recovery, archiving & purging activities· Used stats pack report to tune materialized views by creating materialized view logs to enable fast refreshes on master tables.
• Have well exposed with Golden Gate products, and setup Heterogeneous replication from Non-Oracle to Oracle using Golden Gate.
• Created physical standby database from hot backup of primary database·
• Created scripts to query performance views in an effort to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration· Created logical standby database from hot backup of primary database· Resolved gaps between primary and standby databases (Gap Resolution)·
• Designed, documented, implemented, and maintained all disaster recovery procedures · Setup physical standby on a 9i database to protect mission critical from any failures, errors or corruptions· Configured a cold-failover for 9i and 10G database using Sun clusters 3.1
• 10g RAC switchover and failover configuration, implantation, and testing· Installed Oracle 10g RAC on Linux platform using ASM for a storage manager·
• IBM Tivoli Storage Management configuration, setup & admin ( for Backup/recovery)
• AIX/Solaris SysAdmin work
• Hardware/software requirements estimation for client, based on their application or environment . which hardware, server best for client.
• DR (Disaster Recovery) recovery strategies design & implementation for either Oracle10g ( RAC/ASM/Data Guard) . Logical to Physical by using VMware and IBM TSM with Zero Down time & Desktop and Server Virtualization.

Confidential, Indianapolis, IN

Oracle /SQL Server DBA

Responsibilities:

• SQL Server 2012 & 2014 Installations, configuration and SQL cluster Installation.
• Experience as a MSSQL Administrator on large scale software development project.
• Involved in Datacenter Migration, one of the biggest datacenter in the world (WWT), with 1278 SQL Servers across the globe.
• Having hands on knowledge in migrating Database from SQL Server 7, SQL Server 2000 and SQL 2005 databases to SQL 2005, SQL 2008, SQL 2012 .
• Involved in the compliance project, where my role was to applying latest Service Packs to all the servers under baker environment and make it compliant to baker Standard.
• Backup and Restoration of System and User databases.
• Experience in Deploying and troubleshooting SSIS packages.
• Monitoring SQL Server Jobs and Troubleshooting on failure.
• Troubleshooting SQL Server production issues.
• Monitoring database growth, managing Databases, data files, log files.
• Performance Tuning of SQL Server Databases.
• Managing SQL Server security and logins.
• Experience with Active directory adding individual User ID's to Active directory groups.
• Dealing with performance issues on production servers.
• To analyze long running and slow queries and tune the same to optimize application and system performance.
• Setting up and supporting weekend/Interval database activities. (Reindexing, Backup and Restoration)
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Establish and maintain sound backup and recovery policies and procedures.
• Implement and maintain database security (create and maintain users and roles, assign privileges).
• System analysis, design, development implementation and Reverse Engineering and optimization.
• Ensuring high availability of the database using the concepts of mirroring, replication, Log shipping .
• Database & application tuning and performance monitoring.
• Oracle DBA support with multiple clients

Environment: SQL Server 2012/2014 on Windows 2008/2012 R2 Oracle 10gR2, 11gR2 on Linux with RAC 3 nodes.