SUMMARY:

• Over 18 years of experience a Senior Oracle consultant in Database Administrator/Architect role, Database design, Solution Development troubleshooting Oracle Technologies as Oracle DBA on OLTP and OLAP environments.
• Providing Production support of large database, 7x24 supporting an active online applications
• Intensively involved in the area of installations of Oracle Software, Configuration for database and day to day routine works for database administration
• Database Management - Backup, & Recovery, Performance Tuning, Configuration Database, Tablespace administration, cloning, and managing data dictionary objects
• Specialized in Database Management, Maintenance and performance for OLTP, Web based application.
• Oracle RAC 12c(12.2 and 12.1) and 11g(11.2.0.3) Migration/deployments on UNIX (Solaris 10) and/or LINUX (RHEL 6) platforms with Physical and Virtual configurations.
• Troubleshoot Oracle RAC Production problems and working effectively with other team members
• Install and configure Oracle IDM product including Oracle Identity Manager
• Experience in Oracle IAM and IDM product suites, particularly OID, OAM
• Experience in database design SQL Navigator, PL/SQL functions, stored procedures, packages, cursors and triggers and Strong Data Modeling experience
• Excellent experience in performance tuning using STATSPACK, EXPLAINS PLAN, SQL TRACE, TKPROF, AWR, ADDM reports SQL Performance Analyzer (SPA).
• Experienced with SRVCTL, OCR, SCAN, ASM, ACFS, OCFS2,Veritas Cluster(VCS) and Voting Disk of 10g/11g RAC
• Migrating existing production oracle 10gR2 to 11gR2 and upgrade Oracle Databases from 9i to 10g and Migrated from Solaris to Linux.
• Experience with SAP and EBS 11i ERP Applications, PeopleSoft and Supporting tools.
• Prepared advanced state of the art security solutions using Streams and Implemented Streams configuration on Oracle10R2 and 11.2.
• Expertise in preparing and running Mappings, Sessions/Tasks, Workflows, Worklets, and Batch processes on Informatica Server
• Disaster Recovery: Backup/Recovery, Standby database, Data Guard and Oracle Forms Server administration experience.

TECHNICAL SKILLS:

Database: Oracle, MySQL, SQL Server, Sybase12.0, DB2

DBA: Oracle12c,11g, 10g, 9i, 8.1.7.4 SQL Server 2000/2005/2008 .

Operating Systems: Win NT/ Win XP/2003/2008, HP-UX 9.x/10.x/11.x, Linux, Solaris, AIX

Languages: SQL, PL/SQL, VB Script, COBOL, VC++

Tools: SQL server Integration Services, SQL Server Analysis Services,Toad, Erwin, PL/SQL developer, SQL Server Migration Assistant,SQL Server DTS, Crystal Reports

Scripting Languages: UNIX Shell Scripting, Perl, and python

ETL: ETL using Informatica(Staging only), Data mart design, OLAP, OLTP, Preparation of SQL scripts for Data Mart version maintenance using SQL*Plus, SQL*Loader on Unix as well as Windows.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Database Administrator

Responsibilities:

• Install and configure OEM 13c(13.2) on Linux and Solaris boxes.
• Relink Oracle Libraries of oracle home and grid home of 11.2.0.3 after AIX upgrade on DEV, QA and Production servers
• Install and configure Oracle IDM product including Oracle Identity Manager
• Applied PSU Patch on DEV, QA, Integration and Production servers
• Install Oracle Binaries and setup new server for developers to use and weblogic support
• Day to day Remedy/Incident tickets to resolve from developers and testers
• Working on golden gate 12c integrated extract and replicats.
• Using golden gate 12c to migrate database from data center to AWS
• Restore and recover 35 TB size database from backup
• Oracle EBS suite including 11i and R12 and did upgrade to R12 and SSO enable.
• Setup OS Watcher on Linux OS and get /sbin/ipconfig and load balancing of web services.
• Oracle 11g R2 RAC implementations on IBM AIX 6.1 LPAR platforms
• Testing switchover to another node in RAC one node 11g database.
• Supporting, troubleshooting and performance issues in golden gate 12c
• Implemented High availability using Golden Gate Replication. Implanted Bi-directional replication using golden gate.
• Experience in shell scripting to develop monitoring and automation scripts
• Data quality, ETL development, data-integration, ETL power center 9.6.1, SOA, TIBCO,JMS,JNDI and MDM
• Experience and working in Netezza for reporting data mart.
• Supporting and experience in 12c(12.2 and 12.1) database on Linux .
• Goldengate setup on QA servers and make sure it is replicating to twelve Bank locations.
• Working on Performance issue of Informatica Workflow hanging on QA and Production servers.

Oracle Database Administrator/Architecture

Responsibilities:

• Install and configure 12c cloud control on Linux and Solaris boxes.
• OEM12c upgrade from 12.1.0.2 to 12.1.0.3 on Linux
• Agent12c upgrade from 12.1.0.2 to 12.1.0.3 on Linux and Solaris servers
• Migrated and upgraded DEV and TEST DBs from 10.2.0.5 to 11.2.0.3 Two node RAC from Linux RHEL4.9 to 5.8
• Experience in Oracle IAM and IDM product suites, particularly OIM, OAM, OVD
• Active Database Duplication on oracle 11.2.0.3 RAC database
• Set it up for all databases for 12c cloud control and auto start Agent12c on server reboot.
• Setup Blackout on OEM12c for maintenance duration time.
• Added/Setup all databases on OEM 12c.
• Working on AWS cloud platform for Oracle databases
• Installation and setup of BI Publisher and database vault on Dev,Test and Production
• Supporting e-business suite(11i) on dev,test and production including work flow and.
• Upgrade of the Repository using the OWB 11.2 Repository Assistant.
• Migrated and upgraded from 10.2.0.5 to 11.2.0.2 Two node RAC databases on RHEL 5.8
• Install certificate on weblogic 11g server and golden gate 11g experience
• Added a high strength encryption and hashing function to Oracle 11g for securing sensitive data.
• Installed 11g java encryption specification AES256.
• Setup wallet and worked on setup security in database
• Experience in Oracle IAM and IDM product suites, particularly OIM, OAM, OVD
• Update the security JARs in Oracle’s embedded JVM with the Unlimited Strength Java Cryptography Extension (JCE) and java class file
• Performance tuning using STATSPACK, EXPLAINS PLAN, SQL TRACE, TKPROF, AWR, ADDM reports SQL Performance Analyzer (SPA).
• Configure and tuning the RAC clusters for optimal performance
• Install and configure Golden gate 11.1 on 5 nodes RAC 11.2.0.3 on Linux.
• Install 12c Agent on Linux and Solaris server for OEM cloud control
• Created solution guide for golden gate setup.
• Applied July2013 PSU Patch in RAC databases for Dev, Test and Prod environment.
• Set it up standby database for oracle 11.2.0.3 RAC for failover using data guard broker
• Upgraded 15 databases from 10.2.0.5 standalone to 11.2.0.3 RAC and all migrated from Tru64 to Solaris 10 and size was 3.0 TB.
• Working on WebLogic to deploy ear file repositories and upgradation of 10.1 to 11.1
• Created domain in WebLogic and make it for cluster.
• Created web frontend for accessing Oracle forms and report
• Worked on OID database to save all active user for accessing using link
• Working on Auto sys to start, stop or off hold the jobs.
• Install intelligent agent 11g for grid control and created response file for RAC Database
• Install and configure grid infrastructure 11.2.0.3 on Solaris 10
• Created Oracle RDBMS and Database 10g in grid infrastructure 11.2.0.3 home
• Data Pump Export and Import using parallelism
• Working on ASM instance to manage disk groups
• Working on golden gate replication one direction for disaster recovery solution
• Writing shell script to automate golden gate procedures.

Oracle Database Architect

Responsibilities:

• Setup RMAN backups, Export, and other monitoring scripts.
• Created solution guide for golden gate setup and WebLogic .
• Data Pump Export and Import using parallelism and Advanced Compression option.
• Installation and configuration of Grid Control infrastructure on standalone and RAC of 11gR2
• Grid infrastructure using ASM and created disk groups and fast recovery area.
• Installation and configuration of Grid Control infrastructure on standalone and RAC
• Created and maintain and data checker scripts for biological data within the Oracle DB
• Installing, configuring and maintaining Enterprise Manager Cloud Control to monitor and manage Exadata installed Oracle11.2 with Bidirectional Stream on linux5.7 and worked on Auto sys
• Grid infrastructure using ASM and created disk groups and fast recovery area.
• Moved database Schema changes to stage or production and Non ASM to ASM file system
• Working on Data Migration using Data Guard,Pre-build RAC and CLOUD
• Design and Planning of Data Migrating for CLOUD COMPUTING

Oracle Database Administrator

Responsibilities:

• Created new databases and users, setup RMAN backups, Export, and other monitoring scripts.
• Install and configure 11.2 and applied PSU patch 11.2.0.2.3 on Linux 5.7 version 86x64.
• Data Pump Export and Import using parallelism and did import from several tablespace into one tablespace of 300GB data dump and Implementation Advanced Compression option.
• Installation and configuration of Grid Control infrastructure on standalone and RAC
• Implemented High Availability - Real Application Clusters (RAC) on Linux Enterprise edition and Advanced Replication (Streams 11R2 and Golden gate).
• Worked on SSIS and SSRS for sql server 2008 and 2012.
• Worked on Restore and recover databases for 2008 and 2012 sql server.
• Updating statics in sql server databases and monitor database using visual studio.
• Setup 11g R2 Streams on 4 databases and snapshot standby database.
• Set up Physical data guard with Max performance on 11g R2.
• Provided primary administrative support for Oracle 11g, 10g databases in UNIX.
• Installed, upgraded and patched Oracle software. Setup brand new machines including
• Installing ODAC, JDBC, ODBC, Oracle client’s as per Application requirements
• Database server tuning. Proactively monitored hit ratios on different components of the SGA
• Responsible for online and offline backups, and recoveries of various Oracle databases using RMAN, Export and Import utility.
• Data Modeling/DB admin. Support to define/modify database objects.
• Performance Analysis and tuning for database accesses with AWR and ADDM reports.

Oracle Database Administrator

Responsibilities:

• Data Modeling, Responsible for installation, up-gradation of Oracle (11g, 10g, 9i, 8.1.7.4) software in different environments, creating and maintaining Oracle development and test databases.
• Responsible for online and offline backups, and recoveries of various Oracle databases using RMAN, Export and Import utility.
• Wrote shell, Perl and Python script for Automation and Experience with EDI transactions
• Using ERWIN/MS Visio for Logical and Physical database Modeling
• Software maintenance of the Database machine and applied patches of Oracle 11.2.0.2.1 and 11.2.0.2.3 and Worked on Autosys .
• Experience with general XML topics such as XML Schema, XQuery, XPath and XSLT
• Experience with applying PSU patches on Oracle RAC 10g databases(Rolling Upgrade)
• Worked on server size of 1200 GB Size of VLDB and Sound knowledge of ORACLE PL/SQL.
• Wrote database PL/SQL triggers and procedures, Function, Packages and Loading data using SQL*Loader
• Worked with REMEDY, Clear Quest, Clear Case, and using ICART to deploy code in Clear Case
• Created composite partition (List Range) on 11R2 and automated data loading into staging tables
• Help Java developer in connection problem with time out with database
• Effectively lead QA tests and create test scripts to ensure the environment is functional
• Create technical documentation to be used by staff for subsequent high availability installations.
• Experience using Grid Control monitoring(OEM) tools and experience with various PARTIONING /Reorgs of tables

Oracle Database Administrator

Responsibilities:

• Planning, Design, Management and maintenance of Streams environment for data replications and messages and Oracle CDC(Change Data Capture)
• Monitoring the operating system response in terms of CPU usage, disk space, and swap space by using various UNIX utilities like SAR, VMSTAT, IOSTAT and TOP.
• Working experience with Oracle Advanced Security (ASO/TDE) Option and database
• Audit database and OS environments for performance glitches
• Extensive experience with multiple technologies, Logical Data Modeling and Physical Data Modeling.
• In-depth knowledge of Oracle Wait Interface, DBA HIST tables, V$ views and wait event analysis
• Setup aggregates and summary using materialized views and partitioned tables
• Planning and design of MAA ( Availability Architecture) with local and remote sites
• Responsible for Oracle Application Server administration and tuning to support the batch processing performance and Experience with EDI transactions
• Involved in data modeling (logical and physical designs) activities for new/ old business processes in the effort for automating these processes
• Database performance monitoring and tuning through STATSPACK reports.

Environment: Oracle11g/10g/9i/8.1.7.4,SQLServer 2000/2005/2008, Linux/UNIX,TOAD, RAC, PL/SQL, SunSolaris9, ERWIN, Informatica, Forms 10g/6i.

Oracle Database Administrator

Responsibilities:

• Database Management - Backup, & Recovery, Performance Tuning, Configuration of Database, Data Modeling, Table space administration, User management, Index management, and managing data dictionary objects and Entity Relationship Modeling (ERM).
• Provided support on performance issues during project development resulting in improved response times and reduced contention
• Used DB Verify to deal with block corruptions and RMAN block recovery.
• Create new database and users, schemas and Conduct required performance tuning of RDBMS
• Performing data analysis to provide management with timely and accurate information
• SQL Server 2000 Database recovery experience with backup and restore.
• Responsible for logical and physical design for application and database tuning
• Oracle statistical analysis using inbuilt functions and Oracle product level upgrades and Patch maintenance
• Deploy application schemas for testing and development and productions.
• Create shell scripts for advanced backup routines and restorations.
• Extensively involved in Oracle database exports and imports.
• Individual work for query tuning partitioning, optimizer hints and code modification.

Environment:: Oracle10g, 9i, PL/SQL, SQLServer2000, TOAD, Windows2003 Sun Solaris, LINUX/UNIX, ERWIN, Abinitio, Informatica, Form 6i

Database Administrator

Responsibilities:

• Responsible for installing, maintaining, performance tuning and monitoring of Oracle database versions 8i & 9i in different Environments like development and production.
• Responsible for testing and debugging the applications.
• Ensuring security of the data in the database by monitoring environment to identify improper access.
• Accomplished quality, stability and efficiency of the database across the projects by undertaking initiation and coming up with several proposals.
• Design and implement backup and recovery system. Responsible for backup and recovery of the database.
• Responsible for monitoring of various Oracle databases in different environments like Development, Quality Assurance, and Production
• Implementing security of the database by creating profiles for each user.
• Plan for disaster recovery, develops and implements off-line and on-line backup functions as well as full, cumulative, and incremental exports that allowed for quick and efficient recovery
• Pl/SQL packages/trigger/functions for low level support
• Presentation for employees and contractors and on site training with document

Environment: Oracle 9i, PL/SQL, Sun Solaris, HP UNIX, Dec Alpha, Compaq 264

Confidential

Oracle Database Administrator

Responsibilities:

• Create and manage multiple databases, tables, indexes, views and partitions
• Partitioned large tables and indexes, optimized storage for performance.
• Improved file I/O for by eliminating important waits on resources.
• Export/Import data using multi volume option.
• Create and manage plan stability for frequently used SQL statements by generating Outline.
• Document all changes and Version control for new releases.
• Assisted in Automating scripts for statistics gathering and for daily full export and utility reports.
• Create maintenance scripts and document the changes
• Create stable SQL plans using optimizer statistics and other configuration.
• Troubleshooting day to day database issues

Environment: Oracle 8i, PL/SQL, Developer 2000 ODBC, UNIX, IPX, TCP/IP.