SUMMARY

• Have over 12 years of focused experience in IT industry in various fields like banking, insurance, finance, retail and manufacturing. Extensive experience in relational database design, analysis, modeling, migration, administration, implementation, troubleshooting and quality management.
• Comprehensive experience asa Oracle, SQL SERVER, INFORMIX and DB2 UDB DBA, proficient in Oracle 12C, 11g/ 10g/ 9i alongwith IBM DB2 11.1, 10.5,10.1, 9.7, 9.5 Administration andknowledge and trainings on various Database systems likeMongoDB, Postgre SQL, Tera Data, Netezza, DynamoDB, SQL Azure, Aurora.
• Professional experience in Oracle Installation, administration, performance tuning, backup & recovery with proven ability at Server side & Client side responsibilities.
• Expertise in Oracle RAC, Replication, Standby databases, and database designing.
• Expertise in handling 24X7 mission critical production databases, versions 11g/10g/9i primarily in AIX / UNIX based environments.
• Successfully upgraded databases from 9i to 10g & 11g.
• The expertise of Crontab to automate and schedule the various routine maintenance tasks.
• Administration of GoldenGate (10.x/11.x/12.x) replication solutions to facilitate data flow between heterogeneous (SQL Server / DB2 and Oracle) environments.
• Experience in Data warehousing and ETL.
• Experience in Database Security and Auditing.
• Experience in basic and advanced replication using Oracle Streams and experience in using OEM, TOAD, and Data Migrations using export/import, benchmarking using load testing tools.
• Training and Conceptual knowledge on MongoDB, Postgre SQL, Tera Data, Netteza, DynamoDB, SQL Azure, Aurora Databases.
• Professional experience in DB2 Installation, administration, performance tuning, backup & recovery with proven ability at Server side & Client side responsibilities.
• DB2 10.5, 10.1, 9.7, 9.5 database administrator functions including, database object creation and alters implementation, reorgs, statistics collection and analysis.
• DB2 DPF, Recoveries, performance tuning, schedule and manage maintenance of production application databases, disaster recovery testing.
• Job scheduling utilities and database management tools and utilities.
• Experience monitoring DB2 Databases sizes ranges from 500MB - 100TB.
• Problem determination and resolution for supported application databases and maintenance utilities.
• Perform change management activities using standard change processes in support of application database related changes.
• Use and learn standard DB2 utilities and DBMS related products to perform DBA tasks.
• Diagnosed and troubleshoot UNIX and Windows processing problems and applied solutions to increase company efficiency.
• Build database systems of high availability and quality depending on each end user’s specialised role.
• Design and implement database in accordance to end users information needs and views.
• Monitor database performance, implement changes and apply new patches and versions when required
• Time estimating, cost estimating, developing a budget and documentation.
• Risk analysis, managing risks and issues and monitoring and reporting progress
• Team leadership including DBA’s, SA, NSA.
• Strategic influencing, working with vendors, controlling quality.

TECHNICAL SKILLS

• Tech Lead, DB Manager, PMO
• DB2 10.5, 10.1, 9.7, 9.5 Administration
• Oracle 11g, 10g, 9i Administration
• Oracle 11g Exadata Administration
• MongoDB, Postgre SQL, Tera Data, Netteza, DynamoDB, SQL Azure, Aurora
• TSM, Net Backup, Disk backup and restore
• AIX, Linux, Unix
• Windows 10/8/7/XP/2008
• Windows Server 2008 - 2012
• OEM, OPM, Data Studio
• Toad (10.1/ 9.7/ 8)
• Putty, Ultra Edit
• MS Office 2013/2010/ 2007/ 2003
• PL/SQL Developer

PROFESSIONAL EXPERIENCE

Confidential

Tech Lead / Manager

Environment: IBM DB2 9.7, 10.1, Oracle 11gR2 Data Guard, Oracle OEM Grid Control 11gR2-12c, RAC, ASM, IBM AIX6.1, 7.1, Red Hat Linux 7 Windows 2012R2

Responsibilities:

• Installation, configuration, administration and tuning of Oracle 9i to 11gR2 Single Instance and RAC databases.
• OEM Grid control installation, configuration and administration.
• Proactive and Reactive Database Health checks and server reviews for client database and suggesting changes.
• Write and maintain generalized scripts to create databases, to get the definition of the existing databases, to monitor and maintain databases and their alert logfiles and listener log files, startup scripts, shutdown scripts, RMAN backup and restore scripts and export & import scripts.
• Oracle 10g-11g Dataguard setup and administration.
• RMAN Backups setup and recommending performance improvement during hot backups.
• Data warehousing and ETL.
• Creating DBLINKS.
• Performed backups and tested crash recoveries using conventional cold, hot & RMAN backups.
• Performance tuning using ExplainPlan, STATSPACK, SQL TRACE, TKPROF, ADDM.
• Basic and advanced replication using Oracle Streams and experience in using OEM, TOAD, Data Migrations using export/import, benchmarking using load testing tools.
• Build database systems of high availability and quality depending on each end user’s specialised role.
• Design and implement database in accordance to end users information needs and views.
• Define users and enable data distribution to the right user, in appropriate format and in a timely manner.
• Use high-speed transaction recovery techniques and backup data.
• Minimise database downtime and manage parameters to provide fast query responses.
• Provide proactive and reactive data management support and training to users.
• Determine, enforce and document database policies, procedures and standards.
• Perform tests and evaluations regularly to ensure data security, privacy and integrity.
• Monitor database performance, implement changes and apply new patches and versions when required
• Planning and defining project scope along with activity planning and sequencing.
• Resource planning according to workloads and developing schedules.
• Time estimating, cost estimating, developing a budget and documentation.
• Risk analysis, managing risks and issues and monitoring and reporting progress
• Team leadership including DBA’s, SA, NSA.
• Strategic influencing, working with vendors, controlling quality.
• Installation and configuration of the databases where applicable MS SQL, Informix.
• Created primary database storage structures (tablespaces) once developers have designed an application.
• Modified the database structure, as necessary, from information given by application developers.
• Manage Backup, Security, and Controls of databases. Enrolled users and maintaining system security.
• Controlled and monitoring user access to the database.
• Monitored and optimized the performance of the database.
• Engaged with application vendor support till problem resolution.
• Filled and close all assigned TTs correctly and keep DB documentation Files updated.
• Managed Storage & IO performance issues related to databases.
• Monitor the effectiveness and efficiency of database systems operation and recommend, lead implementation of performance improvements for database systems and user applications.

Lead DB2 & ORACLE DBA

Environment: IBM DB2 9.7, 10.1, 10.5, 11gR2, RAC, ASM, 11gR2 Data Guard, Oracle OEM Grid Control 11gR2-12c, IBM AIX 5.3, 6.1, 7.1, Red Hat Linux 5 & 6, Windows 2003-2008R2

Responsibilities:

• RAC and standalone Installation and implementation of the Oracle 11gr2 & 12c on AIX, Sun Solaris & Linux.
• Installation and implementation of the Oracle grid infrastructure 12c.
• Proficiently used TOAD, SQL developer and putty for access and monitoring purposes.
• Managed the databases for over 100TB size.
• Implemented the automated Hot Backup scripts for the Daily full backup created in Korn Shell.
• Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.
• Upgradation from Oracle 10g to Oracle 11g.
• Knowledge in replication using Golden Gate materialized views.
• Maintained standby databases, in both local and remote locations, for fail-over purposes.
• Implemented and maintaining database security (create and maintain users, roles and assign privileges)
• Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.
• Managed appropriate use of free space within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
• Expert with OEM Event and Job Managers, Change Manager, Diagnostics & Tuning Packs.
• Working knowledge of Oracle golden gate and Oracle streams.
• Performed Backup & recovery test including offline backup process and database log purging.
• Performed Database and server migration from DB2 9.7 to latest versions of DB2 10.5 along with latest Fixpacks.
• Implemented High Availability and Disaster Recovery techniques by implementing HADR in multiple standbys with multiple databases.
• Performed DB2 queries optimization and SQL evaluation for optimal performance.
• Used Reorg, Runstats, Export, Import and load utilities to facilitate Migration project.
• Proficiently used DB2 utilities like DB2LOOK, DB2MOVE, DB2PD, DB2DART along with LOAD, UNLOAD, CHECK, COPY, and RECOVER etc.
• Architecture and Analysis of Enterprise Content Management ECM Program using the ECM stack of solutions include FileNet, Documentum, Lombardi, Kofax, Captiva, and WebSphere. Enhances organizational goals through enterprise standards.
• Proficiently used third party monitoring tools like TOAD for DB2, IBM InfoSphereOptimPerformance Manager to monitor and identify emergent problems, Diagnose the root cause of problemsand isolate problematic components across applications, networks and databases.

Tech Lead Oracle & DB2 Database Administrator

Environment: IBM DB2 9.7, 10.1, Oracle 10g,11gR2, RAC, ASM, Oracle 10g-11gR2 Data Guard, Oracle OEM Grid Control 11gR2-12c, IBM AIX 5.3, 6.1,7.1, Red Hat Linux 5, Windows 2003-2008R2

Responsibilities:

• Architecting, planning, designing, developing, deploying and supporting RAC/ASM environment
• Installing & configuring Oracle Clusterware & Database Software (Troubleshooting using cluvfy & handling common issues that arise during integration of the whole - bugs, network issues, configuration files issues, OCR issue, deinstallation & cleanup of Clusterware)
• Testing and benchmarked the application prior to going into production to determine its effects on GES and GCS with a special focus on load testing for interconnect traffic.
• Upgrade of 10g R2 RAC to 11g R2 RAC
• Migrated Non-ASM Single Instance to ASM RAC Instance.
• Used BCV split/Data Guard technology to migrate over 13 TB Database.
• Supporting Data Warehouse Database i.e. over 30 TB in size.
• Experience in Oracle 9i/8i/8.x/7x - Installation, Migration and implemented new features.
• Experience in capacity planning, space management, database upgrades/migration
• Experience in working with RAID environment.
• Experience in clustered databases using AIX HACMP technology and Veritas Cluster on Solaris 8.
• Expert in ORACLE Database Administration including planning/implementing backup/recovery strategies using RMAN and without RMAN.

Confidential

Manager Databases

Environment: DB2 10.1, 9.7, Oracle 10gR2, 11gR2, IBM AssencialDataStage 7.5, IBM AIX 5.3, IBM P590/595 Servers, data studio, OPM, OEM

Responsibilities:

• Maintained database results by setting and enforcing standards and controls.
• Prepared for database expansion by studying plans and requirements; advising senior technical management; coordinating design and programming.
• Kept senior technical management informed by preparing reports on system performance and problems.
• Upgraded hardware and software by assessing transaction processing and database production options.
• Maintained database performance by troubleshooting problems.
• Accomplished platform upgrades and improvements by supervising system programming.
• Secured database by developing policies, procedures, and controls.
• Updated job knowledge by participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations.
• Accomplished information systems and organization mission by completing related results as needed
• As a Lead Database Administrator, I was Responsible for administration of over 300 Oracle databases.
• Leading the Team of 15 DBAs.
• Upgraded 10.2.0.4 Two-Node RAC ASM Database to 11g R2 Two Node RAC ASM
• Advanced Backup and Recovery using Oracle’s RMAN software; used offline/online for recovery in a production environment via Korn shell scripting.
• Mentor other DBAs in the effective use of RMAN software, and my scripts.
• Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.
• Data center Migration using Data Guard.
• Oracle Goldengate replication Administration.
• Knowledge on install and configuration of Goldengate
• Providing daily routine database administration services.
• Performance tuning of Production and development databases.
• Backup and recovery implementation using RMAN (Level 0/1 Offline and Online Incremental backups).
• Logical backups implementation using datapump for critical tables.
• Providing support to data warehouse ETL team and development of Unix shell scripts for batch operations.
• Applying Latest Patchset on Database Servers.
• Automatic Archival of old table partitions for database space reuse.
• Operating system performance monitoring and liaison with IBM support for OS related issues.
• AIX administration including Osusers creation, volume groups creationand management, LPAR’s physical resources management (memory, CPUs) using HMC console.
• System snapshots collection for problem troubleshooting, Resizing mount mounts etc.
• The over-all responsibility for all DB2 products in production and test environments. These include the DB2 software itself, the TMON monitoring tool, and the Platinum tools we have purchased (Plan Analyzer, and Database Analyzer).
• Monitors DB2 production servers for potential problems.
• Applies upgrades along with Business System Services to DB2 in test and production.
• Along with Business Systems Services, installs and maintains software used for supporting and monitoring DB2.
• Assists all development work on DB2. This includes helping with application development, designing and creating database objects.
• Serve as an overall DB2 resource and keep abreast of new developments in the DB2 world through journals, newsgroups, the Web, the DB2 user Group.

Confidential

Responsibilities:

• Fixation of all issue aroused during the upgrade process.
• Backup of the databases before and after the Upgrade.
• Preparation of the complete DB2 upgrade plan for Aix 7.1.
• RDBMS parameters setting as required running DB2 smoothly.
• Assists all development work on DB2. This includes helping with application development, designing and creating database objects, Migrating from test to production, and implementing batch schedules with the appropriate DB2 utilities.
• Reviews all data models for technical accuracy. This includes the enforcement of all modeling and naming standards. Performs all structural changes to DB2 databases.
• Upgrade documentation and other deliverables to client and training.
• Ensure integrity, availability and performance of DB2 database systems by providing technical support and maintenance.
• Monitor database performance and recommend improvements for operational efficiency.
• Assist in capacity planning, space management and data maintenance activities for the database system.
• Perform database enhancement and modification as per the requirements.
• Perform database recovery and backup tasks on the daily and weekly basis.
• Monitor databases regularly to check for any errors such as existing locks and failed updates.
• Oversee utilization of data and log files.
• Manage database logins and permissions for users.
• Experience developing stored procedures, scripting, SQL, and optimizing SQL