Automating daily routine jobs in order to improve client time

 Cross platform migration using TTS and export and import.
 Migrating EBS database on to ODA from UNIX.
 Working on commvault tool (which is used for backups and restore)
 Creating database and maintaining it using ODA. Performed Administrative activities on ODA.
 Used Infosys iO2O tool for migrating databases from one platform to another platform and cross platform
 Oracle application migration and Configured data guard for production environment. Worked on data guard related issues.
 Worked on database performance (slow running queries/huge data import).
 Involved in every aspect of project life cycle, including collaborative requirements gathering, creating work plans, functional requirements and unit testing plans.
 Demonstrated ability to coordinate and work with colleagues in product development, training and production including interacting effectively with business stakeholders and technical teams.
 Refreshed the lower environment databases using RMAN from production.
 Maintaining the performance of database using oracle enterprise manager (OEM 14c) and configuring OEM.
 Involved in Oracle cloud related activities for migrating the Oracle database to cloud.
 Involved in Performance tuning activities after the migration. Supporting application in production environments.
 Configured Goldengate datapump extract to move the trail files from source database server to target database server.
 Installed Goldengate Director to have a web view of all the goldengate implemented servers.
 Used Goldengate Tokens to get the values of modified date, modified user and operation type from trails.
 Experienced in implementing Oracle Database advanced security practices.
 Table Partitioning, creating Index Organized tables, Creating Locally managed Table spaces.
 Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management and Security Administration.
 Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
 Manage users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager (OEM)
 Experience in cloning RAC databases using RMAN tool.

CAP is one of the biggest pharmaceutical company from America. It has huge volume of databases on various platforms and having multiple applications. The activities which involves database creations, performance tuning, managing database backups, restores, cloning, patching, and migration and up gradations and application support. Securing the databases and its data by applying/implementing various security options provided by Oracle.

 Automated the nightly RMAN backups for the Production and Test Databases in Crontab.
 Experienced in Design, implementation and generating documentation of Oracle 10g Data Guard on both physical/logical standby databases in high availability mode.
 Configured Physical Standby database for 2 node RAC database using Data Guard.
 SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, AWR, ADDM and monitor the database performance on daily basis.
 Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
 Assisted SQL developers to optimize the SQL queries and stored procedures.
 Creating and Scheduling Oracle Backend Process Jobs in Crontab.
 Cloning & duplicating databases using scripts as well as RMAN.
 Expertise in recovering the database. Performed complete recovery, data file recovery, incomplete recovery.
 Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
 Implemented VERITAS Net Backup using RMAN (Recovery Manager) as a media management layer.
 Applying security patches both Server side and Client side and Performed testing.
 Used Secure SCP & FTP extensively for the File transfers from machines to remote server.
 Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
 Implementation of Oracle & Application Software Patches and maintaining SW License and maintenance agreements.
 Raised SR’s with oracle in case of problems.

 Installation, configuration, maintenance and tuning of Oracle 11g and 10g on Red hat 5.4.
 Successfully migrated Oracle 10g (10.2.0.4) to Oracle 11g (11.1.0.7).
 Involved in Installation and configuration of Oracle 10g &11gRAC using Clusterware and ASM.
 Successfully Migrated Non RAC single instance to Real Application Cluster (RAC) database instances.
 Monitoring System Resources, understanding and troubleshooting Database issues in Production Environment.
 24x7 remote support and on call Database support for Database developers & end-users.
 Installing and configured 10g agents on various production servers.
 Experienced in implementing Oracle Database advanced security practices.
 Carrying out EXPORT and IMPORT operations on Oracle Database using the DATAPUMP utility.
 Table Partitioning, creating Index Organized tables, Creating Locally managed Table spaces.
 Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management and Security Administration.
 Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
 Manage users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager (OEM)
 Experience in cloning RAC databases using RMAN tool.
 Automated the nightly RMAN backups for the Production and Test Databases in Crontab.
 Experienced in Design, implementation and generating documentation of Oracle 10g Data Guard on both physical/logical standby databases in high availability mode.
 Configured Physical Standby database for 2 node RAC database using Data Guard.
 SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, AWR, ADDM and monitor the database performance on daily basis.
 Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
 Assisted SQL developers to optimize the SQL queries and stored procedures.
 Creating and Scheduling Oracle Backend Process Jobs in Crontab.
 Cloning & duplicating databases using scripts as well as RMAN.
 Expertise in recovering the database. Performed complete recovery, data file recovery, incomplete recovery.
 Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
 Implemented VERITAS Net Backup using RMAN (Recovery Manager) as a media management layer.
 Applying security patches both Server side and Client side and Performed testing.
 Used Secure SCP & FTP extensively for the File transfers from machines to remote server.
 Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
 Implementation of Oracle & Application Software Patches and maintaining SW License and maintenance agreements.
 Raised SR’s with oracle in case of problems.

 Responsible for administration and supporting Oracle 9i and 10g databases.
 24x7 Production database administration, support and monitoring to ensure a proactive problem
recognition and resolution of database issues.
 Successfully migrated databases from windows2000/2003 running oracle 9i over to Linux boxes 10g.
 Installation, Upgrade and Configuration of Oracle 9i and 10g Databases.
 Involved in designing of disaster recovery plan using Data Guard, and High Availability using RAC.
 Schemas refresh using Export/Import Pump, Creating the database table spaces, tables, indexes, setting privileges and user logins.
 Configuration, Administration and tuning of Oracle 10g and 9i RAC.
 Used cross platform transportable table space (TTS) to transport tablespaces across platforms.
 Data Refresh in Test and Integration Databases using Transportable Table spaces.
 Performed Setup Recovery Manager (RMAN) and Flash Recovery in RAC Environment.
 Oracle Streams Bi-Directional replication implementation at Table, Schema and Database Level.
 Implemented backup strategies using hot/cold, exp/imp used on the business req.
 Cloning databases using scripts as well as RMAN and performed Tablespace point in time recovery (TSPITR) using RMAN.
 Installed Oracle 10g Enterprise Manager (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on test databases.
 Assisted a team of DBA’s in migration of databases from Oracle 9i Release 2 to Oracle 10g Release 2.
 Worked on Automatic Storage Management (ASM) with SAN Storage for managing data in EMC Symmetrix.
 Monitoring and tuning using tools like Enterprise Manager GRID, Oracle cost Based optimizer (CBO), SQL analyzer, automatic checkpoint tuning, SQL Advisors, Performance Manager, and Statspack.
 Performed conversion single instance to Real Application Cluster (RAC) database instances.
 Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.
 Provided database/application tuning including as reducing lock contention, analyzing objects.
 Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 10g and Production to development refresh.
 Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.
 Experienced on Database Security by monitoring User Management, Privileges, Roles, Auditing, Profiling, Authentication and Risk management.
 Used Oracle Advanced Replication feature to set up multi-master replication, dealt with conflict resolution and performance issues.
 Unix Shell scripting in csh, ksh for automating startup/shutdown, backup and recovery, Import and export procedure of databases, getting system alerts.
 Experienced in documentation, Provided documentation for database design, analysis, modifications, creating schemas etc.
 Resolved TAR issues 24x7 while assisting the functional team and oracle support (Metalink)

International Game Technology PLC (IGT), formerly Gtech S.p.A. and Lottomatica S.p.A., is a multinational gaming company that produces slot machines and other gaming Technology. The company is headquartered in London, with major offices in Rome, Providence, and Las Vegas. It is controlled with a 51 percent stake by De Agostini. Lottomatica acquired Gtech Corporation, a U.S. gaming company, in August 2006, and later changed its own name to Gtech. This transaction created one of the worlds leading gaming solutions providers, with significant global market share and the broadest portfolio of technology, services, and content solutions. Gtech managed many state and provincial lotteries in the United States and also had contracts with local and national lotteries in Europe, Australia, Latin America, the Caribbean, and Asia.