SUMMARY

• 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 SQL Server, Informix Databases.
• Provide proactive and reactive data management support and training to users.
• 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.
• 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
• 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.
• 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.

TECHNICAL SKILLS

• Oracle 11g, 10g, 9i Administration
• Oracle 11g Exadata Administration
• Tech Lead, DB Manager, PMO
• DB2 10.5, 10.1, 9.7, 9.5 Administration
• SQL Server, Informix
• 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 Databases

Environment: Oracle 11gR2 Data Guard, Oracle OEM Grid Control 11gR2, Weblogic 12C, RAC, ASM, OLTP, Data Warehouse, IBM DB2 9.7, 10.1, 10.5, IBM AIX 6.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
• 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.
• 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.
• 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.
• Maintain database security and disaster recovery procedures.
• Resolve any database issues in accurate and timely fashion.
• Monitor databases regularly to check for any errors such as existing locks and failed updates.
• Manage database logins and permissions for users.
• Experience developing stored procedures, scripting, SQL, and optimizing SQL.

Lead DB2 & ORACLE DBA

Environment: OLTP, Data Warehouse, 11gR2, RAC, ASM, 11gR2 Data Guard, Oracle OEM Grid Control 11gR2-12c, IBM DB2 9.7, 10.1, 10.5,11.1, 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.
• Upgraded databases from Oracle 10g to Oracle 11g.
• Knowledge in replication using Golden Gate materialized views.
• 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 analysis of legacy data, data models, and advised project manager on the best way to migrate and manipulate client data on QA, Dev, UAT and Production environments or data warehouse repositories.
• Participated in establishing processes, best practices, and database management solutions including development standards, backup/recovery, quality control, DR/failover, monitoring, maintenance for Oracle databases.
• Provides leadership during system unavailability and triages high severity situations.
• Optimized the organization’s current data and database assets and recommended future initiatives. Optimized current strategies to enhance operational stability and availability of the database using operational best practices.
• Analysed new application requirements and associated database changes, Converted a new database logical design to physical design
• Performed Storage capacity planning, created new databases and configured parameter tuning.
• Created database standards and naming conventions, the physical design of DDL changes and Implemented DDL changes.
• Performance diagnosis setting up of performance monitoring troubleshooting database errors and automated repetitive and mundane tasks.
• Managed database scheduled jobs, reacted to database user complains and Performed database security review.
• Provided technical support to round Corner partners engaged in data migration.
• Managed data migration program. Formulated existing processes and scripts. Enforced migration of data. Assisted Technical and Field Services group. Evaluated database structures and data movement.
• Proficiently used Server and network tools like vmstat, netstat, iostat, nmon, smitty and topas etc.
• 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.
• Design and develop a system to extract existing TIFF images, COLD documents and associated metadata from the IBM Content Management System to IBM FileNet.
• Architecture, design and develop system using templates for workflows using the IBM FileNet Content Management System for workflow and process capabilities.
• 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

Confidential

Environment: OLTP, Data Warehouse, Oracle 10g,11gR2, RAC, ASM, Oracle 10g-11gR2 Data Guard, Oracle OEM Grid Control 11gR2-12c, IBM DB2 9.7, 10.1, 10.5, 11.1, IBM AIX 5.3, 6.1, 7.1, Red Hat Linux 5, Windows 2003-2008R2Responsibilities as Oracle DBA.

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 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.
• Has overall responsibility for all DB2 products in production and test environments. These include the DB2 software itself, monitoring tools.
• Installation and configuration of the new DB2 9.7, 10.1 and 10.5 DPF and non DPF databases.
• Monitoring DB2 24x7 production servers for potential problems.
• Applying 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.
• Architecture, design and develop system using templates for workflows using the IBM FileNet Content Management System for workflow and process capabilities.
• Assisting 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.
• DB2 UDB for iSeries basics knowledge and overview to key iSeries UDB concepts and definitions, such as iSeries Navigator Database and SQL.
• Developed and documented overall vision for DB2 in our environment.
• Provided information to developers and operators on all components of DB2 that are of interest through the Web, Infoshares etc.
• Administer the data server on which DB2 resides: monitor disk space and the DB2 log, backups, protect the integrity of the data.
• Serve as an overall DB2 resource and keep abreast of new developments in the DB2 world through journals, newsgroups, the Web, and the DB2 Users Group.

Environment: Data Warehouse, Oracle 10gR2, 11gR2, DB2 10.1, 9.7,9.8,10.5 IBM Assencial DataStage 7.5, IBM AIX 5.3, IBM P590/595 Servers, data studio, OPM, OEM

Responsibilities:

• 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.
• Performance tuning of Production and development databases.
• Backup and recovery implementation using RMAN (Level 0/1 Offline and Online Incremental backups).
• Providing support to data warehouse ETL team and development of Unix shell scripts for batch operations.
• Applying Latest Patchset on Database Servers.
• 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
• 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 Os users creation, volume groups creation and 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.
• 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.
• 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.
• Maintain database security and disaster recovery procedures.
• Resolve any database issues in accurate and timely fashion.
• Monitor databases regularly to check for any errors such as existing locks and failed updates.
• Manage database logins and permissions for users.
• Experience developing stored procedures, scripting, SQL, and optimizing SQL.

Confidential

Oracle FlexCube 12.0 Implementation

Environment: Oracle 11gR2, Oracle FlexCube 12.0, IBM WebSphere Application Server 8.5, IBM HTTP Server 8.5, AIX 7.1.

Responsibilities:

• Installation, Administration & maintenance of the Oracle 11gR2.
• Installation, Customization, Administration & maintenance of the Oracle FlexCube 12.0.15.
• Creation and managing Oracle FlexCube Application Profiles and users.
• Creation and managing Oracle FlexCube Application roles and accounts. Hardware sizing.
• Setup of Production Test and DR environments.
• Understanding the bank’s Business processes / operations, prior to walking the bank through Oracle.
• LEXCUBE system functionality and understanding the customization required to Oracle FLEXCUBE functionality.
• Identifying Project roles and responsibilities and agreeing on a communication plan.
• Periodic reporting to assess progress and report potential risks affecting the project.
• Mentoring of operational know-how to the bank to maximize the benefits of the solution (Oracle FLEXCUBE and Integration Platform).
• Installation, Customization, Administration & maintenance of the WebSphere Application Server (WAS 8.5) Installation, Customization, Administration & maintenance of the IBM HTTP Server 8.5 on AIX 7.1.

Confidential

Environment: Data Warehouse, IBM DB2 10.5,10.1, 9.7, 9.5, IBM AIX 6.1, 7,1, IBM P780/P795 Servers, IBM WAS 8.5, Weblogic 12c

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.
• Identify and recommend database techniques to support business needs.
• Assist in implementation of new features and program fixes in databases.
• Maintain database security and disaster recovery procedures.
• Perform troubleshooting and maintenance of multiple databases.
• 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