SUMMARY:

• To obtain a position as senior ORACLE / PS admin Database Administrator in a dynamic organization where I can contribute positively with my skills and get professional accomplishment.
• Install, configure, upgrade software, tools, and apply patches
• Monitor, tune, size, backup, recover, analyze, defrag, capacity planning and migration
• Design and implement DB security, user management and wallet
• High availability (RAC), Replication, standby/Data Guard database, RMAN
• Design/model DB structures to support a variety of software applications
• Design and implement backup methods and disaster recovery strategies
• Migrate DB between software versions, platforms, DB products
• Installation of data ware house builder 9i/10g and workflow
• Implementing new PIA, load balancing AS and Webservers by creating more AS and Web servers in Domain.
• Creating Domains for Application Server, Web server and Process Scheduler Domains. Setup the Configuration for Web Server, Application Server, Process Scheduler domains.
• Working with integrated Broker for sync or async messages
• Performed web server, Application Server configuration and set the parameters to get better performance in psappserv.cfg and configuration. Properties files. Monitoring the Servers.

TECHNICAL SKILLS:

Operating Systems: UNIX (Solaris, AIX 5/6/7, Linux 5.0, HP UX), Windows 2003,2008, VMWARE ESXi 5.5

Languages/Application: SQL, PL/SQL, ABAP, SAP 7.3, People Soft 9.2

Databases (RDBMS): Oracle 7.3.x, 8i/9i /10g/11g/12c, MS SQL 2000,2005,2008 R2

Development Tools: Informatica 9.x, SQL Developer, Toad, OEM 11g,12c

Oracle Peripheral: RAC, Data Guard, RMAN, ASM, Golden Gate 12.1.03, EXADATA, Data Pump

Application: PeopleTools 8.53, SAP 7.1 net weaver, SAP Hana

EMPLOYMENT:

Confidential

Oracle DBA

Environment: Oracle 12c/11g/10g, Linux /Win2013, ExaData X3 - 2, ExaLogic, OEM cloud 12c, Golden Gate 12c, EMC vBlock extreme IO, MS SQL 2008, PeopleSoft support

Responsibilities:

• Installation and patching for RAC, Data Guard.
• Setting up / trouble shooting Golden Gate 12c (downstream) and using GG for 0 down time migration.
• Working on POC 12c Database and upgrade from 11g to 12c Database. working as dba admin on MS SQL issue and support
• Creating Domains for Application Server, Web server and Process Scheduler Domains. Setup the Configuration for Web Server, Application Server, Process Scheduler domains.
• Working with integrated Broker for sync or async messages
• Performed web server, Application Server configuration and set the parameters to get better performance in psappserv.cfg and configuration. Properties files. Monitoring the Servers.
• Tracing and tuning on Queries after Migration
• ExaData HCC for OLTP and DW compression tables.
• Participating in replacing failed Cell Disk / Flash Disk in exadata
• Planning for migration DW for ExaData. Data pump / Transportable tablespace and CTAS
• Defining backup/restore strategies refreshes using rman duplicate between prod and uat or dev
• Installation/Upgrade of Oracle Binaries 10gR2 and 11gR2 and New Instances, ASM, OEM Agents. working on security, profiles of databases
• Implementation of Oracle 11g Wallet for password security.
• Performance tuning for poor SQLs

Confidential

Oracle DBA/PS admin

Environment: Oracle 11g, HP UX/ Linux, ExaData X3-2, OEM cloud 12c, Golden Gate 12c,Weblogic

Responsibilities:

• Installation and patching for PS application servers for full life cycle Training, Dev, Test, QA, Prod
• Tracing and tuning on Peoplesoft application for developers
• As an Administrator Created Domains for Application Server, Web server and Process Scheduler Domains. Setup the Configuration for Web Server, Application Server, Process Scheduler domains.
• Performed web server, Application Server configuration and set the parameters to get better performance in psappserv.cfg and configuration. Properties files. Monitoring the Servers.
• ExaData HCC for OLTP and DW compression tables.
• Planning for migration DW for ExaData. Data pump / Transportable tablespace and CTAS
• Defining backup/restore strategies
• Installation/Upgrade of Oracle Binaries 10gR2 and 11gR2 and New Instances, ASM, OEM Agents ASR and IORM
• Performance tuning for poor SQLs working on security, profiles of databases
• Testing / POC for Golden Gate 11 (downstream) for some SQL server to Oracle
• Implementation of Oracle 11g Wallet for password security.

Confidential

Oracle DBA/PS admin

Environment: Oracle 11g, PeopleSoft, Linux,ExaData X3-2, OEM,Weblogic cloud 12cProjects: People soft Databases migration to ExaData

Responsibilities:

• ExaData HCC for OLTP and DW compression tables.
• Planning for migration DW for ExaData. Data pump / Transportable tablespace and CTAS
• Performance issues of queries and PS SQR on non-ExaData servers. Using AWR, ADDM and ASH RPT for tuning and SQL query Profiling.
• Creating scripts / schedules for RMAN online Full / incremental backup /restore on Exadata and non ExaData. Using BCT feature on some high IO extensive environment
• Implementation of Oracle Grid control Cloud 12c with Exadata plugins
• Installation and patching for PS application server.
• Tracing and tuning on Peoplesoft application for developers
• As an Administrator Created Domains for Application Server, Web server and Process Scheduler Domains. Setup the Configuration for Web Server, Application Server, Process Scheduler domains.
• Performed web server, Application Server configuration and set the parameters to get better performance in psappserv.cfg and configuration. Properties files. Monitoring the Servers.
• Backup and restore for SQL server 2008 and some migration to Oracle 11g for PS ERP
• Creating shell scripting for automatic RMAN duplicate from active DataBase refreshes (RAC-to-RAC) and RAC to single instance. working on security, profiles of databases

Confidential

Sr. Oracle DBA/ PS admin (consultant)

Environment: Oracle 10g/11g, PeopleSoft, AIX 6.1, IBM TSM, Linux Red Hat 5, Sql server 2008 R2 ExaData X2-2, OEM cloud 12c, Web Logic, Tuxedo, oracle IDM

Responsibilities:

• ExaData POC (Smart scan /HCC /Storage Index etc.) and Cell Admin
• Planning for migration DW for ExaData. Data pump / Transportable tablespaces
• Installation/Upgrade of Oracle Binaries 10gR2 and 11gR2 and New Instances, ASM, OEM Agents
• Implementations, deploy, upgrades, security patches and the day - to - day operations of MS SQL Server 2005/2008 including Development, QA, UAT and Production systems. database refreshes from Production to non - production environments
• Participate in change control activities
• Oracle Data Guard using Data Guard Broker
• Creation of database monitoring alerts on Grid Control / CRON jobs
• Query tuning using Explain Plan / Stats Pack/ AWR / SGA tuning
• Creating or Refreshing QA and staging with preproduction by using RMAN duplicate.
• Setting up Oracle streams to reporting database.
• Supporting /patching / maintaining Data guard databases.
• Capacity planning and proper object sizing
• Working with Performance issues with RAC environment
• Supporting data warehouse. working on security, profiles of databases
• Table partitioning/ object resizing
• Resolving backup / restore issues with RMAN
• Working on releases for the rolled out projects.
• Creating shell scripting for RMAN and others database automation
• Administration and support for Production/Developments environments.
• Setup the Configuration for Web Server, Application Server, Process Scheduler domains.
• Performed Pre & post refresh steps for Developments environments during Database refreshes.
• Checked and cleared the Application server, Web server cache on a regular basis as a maintenance process.

Confidential

Sr. Oracle DBA/ SQL server DBA

Environment: Oracle 10g/11g, Solaris 10, AIX 5.3, Linux RED HAT 5.4, TomcatMS sql 2008 r2, oracle IDM

Responsibilities:

• Installation of Oracle Binaries 9i,10g/11gR1 and New Instances,
• Supporting more than 5 Production and 24 non-production databases
• Migration of legacy application oracle 10g from AIX to Solaris
• Apply security Patches and upgrades for Oracle and OS level
• Resolving backup / restore issues with RMAN
• Code deployment and working on new releases with developers.
• Working with ASM instances on Sun Solaris and Linux (red Hat 4.5)
• Creation of database monitoring alerts on Grid Control / Cron jobs
• Query tuning using Explain Plan / Stats Pack/ADDM/ AWR / SGA tuning
• Creating or Refreshing QA and staging with preproduction.
• Supporting /patching Data guards and RAC databases.
• Capacity planning and proper object sizing working on security, profiles of databases
• Working with Performance issues with RAC environment.
• PL/SQL, Procedure, triggers for Database maintenance
• Creating shell scripting for RMAN and others database automation

Confidential

Sr. Oracle DBA/ SQL server DBA

Environment: Oracle 9i/10g/11g, Toad, VERITAS Net Backup, Sun Solaris, MS SQL 2005 / Informatica Power Center 8.6.1, Linux red hat 5.0, oracle IDM

Responsibilities:

• Installation of Oracle Binaries 8i,9i,10g and New Instances
• Apply security Patches and upgrades for Oracle and OS level
• Resolving backup / restore issues with RMAN and VERITAS NetBackup.
• Baseline support for Data ware house and access security for Schemas
• Working with ASM instances on Sun Solaris and Linux (red Hat 4.5)
• Working with ORACLE STREAM to replicate set of schema to a DRP
• Code deployment and working on new releases with developers.
• Creation of monitoring alerts
• Query tuning using Explain Plan / Stats Pack/ AWR / SGA tuning
• Creating or Refreshing preproduction.
• Supporting /patching Data guards DB.
• Working with Oracle Ware house Builder
• Capacity planning and proper object sizing in Data warehouse
• RAC 10g Support for OLTP databases
• Working with Performance issues with RAC environment.
• Creating and delete nodes as per business requirements.
• Upgrading oracle cluster ware, binaries and databases for RAC 10g
• PL/SQL, Procedure, triggers for Database maintenance
• Supporting MS sql server 2005 database refreshes from Production to non - production environments
• Participate in change control activities for SQL server
• Design backup and recovery strategies for MS SQL 2005
• Working closely with developers and BA for new projects (logical /physical structures)
• Creating and supervising MOP for new releases or project deployments
• On call pager support for Databases and ETL Informatica production support
• Informatica App refreshes along with DB refreshes

Confidential

Oracle Production DBA (consultant)

Environment: Oracle 10g, HACMP, Oracle Rac 10g, AIX 5.1

Responsibilities:

• Installation of Oracle Binaries 10g
• Apply security Patches and upgrades for Oracle and OS level
• Working with ASM instances on AIX
• Creation of monitoring alerts
• Develop and crate new environment from scratch like Lab., Dev, QA, and Staging.
• Planning for Data Guard as high availability for 3 nodes RAC Production environment

Confidential, Richmond Hills

Sr. Oracle DBA/ SQL server DBA

Environment: Oracle 8i//10g, PeopleSoft, Net Backup, HP-UX, AIX, SQL server 2005, Oracle GIS

Responsibilities:

• Installation of Oracle Binaries 8i,9i,10g and New Instances
• Cloning production Databases to staging and QA
• Migration of oracle Databases & some legacy DBs from PeopleSoft/ Primavera to SAP (ECC 6.0)
• Scripting Backup and Restores by using RMAN with VERITAS NetBackup.
• Data warehouse: creating statistics and analyzing for partition and rebuilding indexes (in case of unusable indexes).
• Capacity planning and proper object sizing in Data warehouse.
• Retrofit of data warehouse at corner stone project.

Confidential

Oracle DBA/ SQL server DBA consultant

Environment: Oracle 9i/10g, OEM, Net Backup, MS SQL 2000, HP-UX

Responsibilities:

• Participate on ILM project. Restore using RMAN and imp DMP files.
• Using data pump for recovery or refreshing dev./QA/Staging from production
• Imp /exp between DBs or archiving Production partition Tables.
• Apply security Patches and upgrades for Oracle and OS level.
• Supporting one of the Data Ware house DB (6 TB)
• Using SQL Loader for flat files import.
• Supporting AMDOCS databases and some application side as well (with knowbility team)
• Supporting Non production Environments (staging, QA and Development)
• Splitting/Dropping of Partition Tables
• Creating or Refreshing preproduction.
• Supporting /patching Data guards DB.
• PL/SQL, Procedure, triggers for Database maintenance/ alerts and jobs.
• Creation of new DB, Cloning, Renaming the oracle 9i/10g DB.
• DB monitoring, Capacity management/planning
• Code deployment and working on new releases with developers.
• Using SQL Loader for flat files to DW staging
• Installation of ORACLE RAC 10g on sun Solaris 10/ Linux 4.5 with ASM instance
• Support and admin. RAC 10g like patching, adding node, gc performance issues
• Query tuning using Explain Plan / Stats Pack/ AWR / SGA tuning
• Installation of MS SQL server 2000/7.
• Using DTS for backup/restore.

Confidential

Sr. Oracle DBA/ SQL server DBA

Environment: Solaris 8, Oracle 8i/9i/10g, DBArtisan, Toad. 9i OEM, NetBackup, TSM 5.3, PeregrineDB2 UDB ESE, Webspehere

Responsibilities:

• Oracle administration and tuning.
• Working with Rollout team to Create SMS packages
• Implementation of 10g Grid and Grid Control agent
• Apply security Patches and upgrades for Oracle and OS level.
• Migration from MS SQL 2000 server to Oracle 10g
• Creating and managing Replica DB of SQL server 2000
• Servers monitoring and database capacity planning for Production DB.
• Supporting client side of DB2 UDB ESE
• DB2 UDB client installation
• TSM 5.3 for backup and recovery
• Capacity planning and proper objects sizing.
• Preparing Documentation for Lead DBAs regarding migration to oracle 10g.
• Migrating oracle 8i /9i to Oracle 10g