SUMMARY:

• Working as Oracle Database Administrator with 8 + years of experience in diversified and very large production and non - production environments in various domains with database implementations in various UNIX, Windows platforms with experience in environments such as Human Services, Retail, Health care, Financial Sectors.
• Oracle database (9i / 10g / 11g / 12c) administration and hands-on experiences in high-end enterprise environments (database size from 100 GB to 40 TB).
• Hands-on experience in Installation / Configuration / Performance Tuning / Troubleshooting Oracle Golden Gate in Oracle to Oracle homogeneous environments and heterogeneous environments (including Oracle to Oracle and Oracle to SQL Server).
• Experience in Data Pump / ASM / ASH / AWR / ADDM / Grid Monitoring / Oracle Enterprise Manager.
• Expert in Oracle database backup & recovery strategies plan and implementation such as user-managed backup, RMAN backup with/without catalog, cold and hot backup, full / incremental backup.
• Experience in Performance Tuning (I/O, Memory & SQL Tuning etc.) by using tools/utilities by AWR / ADDM / Explain Plan / Auto trace / Stats pack.
• Performed up gradation of databases from lower version (9i/10g) to higher version(11g)
• Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Data Guard
• Have good experience in migrating data from Solaris, HP-Unix to Linux
• Solid experience in disaster recovery, Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full back up, incremental, cumulative backup and implementing backup and recovery strategies
• System administration, Oracle Problem analysis and resolution and active cloning of databases from one server to another server
• Testing and implementing different physical (hot/cold) and logical backup and recovery methods including point in time, media recovery, full/partial, and data pump export/import
• Extensively used BMC Remedy, Pac 2000 ticketing systems.
• 24/7 on-call production database support.
• Experienced in installation and configuration of Oracle cluster ware and Automatic Storage Management (ASM) in RAC environment.
• Experience in conversion of SingleNodeInstance to MultiNodeRAC with ASM, and adding instance to existing RAC.
• Experience in Migration of Oracle Databases from non-RAC to RAC and non-ASM to ASM Instances.
• Experience in Real Application Clusters(RAC) setup with 4 nodes, configuration and cluster interconnection with Automatic Storage Management(ASM).
• Efficient in maintaining Data Guard to provide high availability by implementing physical standby database and snapshot standby and worked with Oracle 11g features, 11g Grid Control.
• Experience in using Golden Gate to support data replication monitoring, tuning and capacity planning.
• Experience in bi-directional and broadcast replication from source to target databases using Golden Gate 9.5 and Golden Gate 10.0.
• Implemented data load by replication methods like Materialized views, Golden Gate from OLTP systems into data warehouse databases.
• Experience in recovering Golden Gate corruptions and managing cluster maintenance mode blackouts.
• Performed Export/Import through Data Pump, worked with data pump to take the logical backups of databases.
• Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One- Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations.
• Good analytical and problem-solving skills with ability to work independently and in a team environment.
• Ability to anticipate problems and take proactive action.
• Strong organizational, administrative and problem-solving skills, statistical analysis skills, proficient with analytic and quality assurance.
• Proficient knowledge in business/user process and procedure, guidelines and documentation and project management, experience in managing multiple projects simultaneously.

TECHNICAL SKILLS:

• Database, databases, LINUX, Oracle, PL/SQL
• Operating systems Linux OEL 4.5,5.x,6.x,7.1, Red Hat Linux RHEL 2.1,3.x, 4.x, 5.x, Sun Solaris 9.0/10.0, HP- UX 10.x, 11.x.
• Databases Oracle 12c/11gR1/11gR2/10g/9i, Oracle Real Application Cluster(RAC), ASM, Golden Gate. Database tools
• SQL Enterprise Manager, SQL Profiler, DTS Import/Export, SQL Client Configuration utility, Backup Server, Replication Server, Microsoft OLAP Services, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), EDI
• Development skills Transact SQL (T-SQL), PL/SQL
• Languages SQL, PLSQL, UNIX Shell Scripting, Linux Shell Scripting.
• Hardware/Machines HP-UX, Intel PC, Sun Ultra Sparc, IBM-AIX Tools & Utilities
• RAC, OEM Grid Control, SQL* Loader, ASM, SQL Server, Export/Import,
• RMAN, NETCA, DBCA, TOAD, Exadata, Patch Management, SQLNET, ODBC Export/Import, Data pump, Data-Guard, VERITAS Net Backup, OEL,
• BMC remedy, Pac 2000, VMware, Log-miner, Cron-Tab, Erwin, Ms Visio, SSMS.

PROFESSIONAL EXPERIENCE:

Senior Oracle DBA

Confidential, New York, NY

Responsibilities:

• Extensively involved in Goldengate 12c installation, setup on Oracle Database for unidirectional and bidirectional replication.
• Worked on all database activities such as User management, space management, and database security management on 10g, 11g and 12c databases on SOLARIS, LINUX, IBM AIX and WINDOWS servers.
• Worked on administering 10 Production databases and more than 40 non-production databases of size ranging from 10GB to 5 TB on Solaris/AIX/LINUX servers.
• Performed high level Troubleshooting and Tuning on Goldengate 12c.
• Written Shell Scripts for monitoring performance and health checks in Goldengate 12c.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Involved with installation and maintenance of ORACLE 12c RAC and Standby Databases (Oracle DataGuard) for High Availability and Disaster Recovery purpose.
• Installed 11g/12c software and created databases in RAC and non RAC environments for new projects by interacting with multiple application teams.
• Applied Patches includes PSU and Bugfixes for database performance issues.
• Configured Physical Standby for Production databases and converted Physical standby to Snapshot Standby and ACTIVE data-guard.
• Performed Schema as well as Table Level Replication using Oracle Golden Gate and also did set up Disaster Recovery solution using Golden Gate.
• Writing UNIX shell scripts for backup and recovery, Import and export procedure, PL/SQL functions, procedures, packages and triggers.
• Hands on experience in creating new redo log groups on ASM and NON-ASM environment to resolve performance issues by extending the existing redo logs
• Evaluating the Backup and Recovery Procedures periodically & performing backups and recovery by using RMAN.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
• Employed security protocols as well as created databases for Dev, QA and Prod environments on primarily on Unix-like servers.
• Management of security, granting and revoking permissions to users/roles as and when required.
• Worked on a 24x7 Production database and applications support on an onshore/offshore model.
• Worked extensively with UAT and Parallel Testing teams during QA cycles as it pertained to Database and Golden Gate replication issues.
• Analyzed the user requirements, designed partitioned tables and created indexes for improving performance and manageability because many queries can prune partitions.
• Performance tuning and testing stored procedures, indexes and triggers using SQL server profiler, execution plans and Data Tuning advisor.
• Hands on experience in enabling auditing and finding the schemas failed login attempts
• Created and dropped users, granting and revoking rights as and when required.
• Experience in Oracle Home cloning and upgrading database on that home.
• Assisted IT Analysts on technical database issues and features. Involved in working on Oracle Pseudo columns like ROWID, ROWNUM, SYSDATE, SYSTEM TIMESTAMP, USER etc.
• Able to work effectively with multiple teams at once. Able to thrive in a fast-paced, time compressed and dynamic environment. Solid skills and discipline for Change Management practices processes.
• Performed timely database refreshes at schema and table level based on the requirement.
• Supported multiple services and multiple databases of medium complexity with multiple concurrent users, ensuring control, integrity and accessibility of data.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL
• Installed Oracle 11g database in the test environment and tested the upgrade from Oracle 10g to 11g. Applied upgrade patches, maintenance and interim patches on all the databases
• Implemented database refresh with the hot backup using full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Tested database performance issues (monitoring and tuning) to ensure database optimization.
• Involved in gathering requirements from end users.
• Estimate growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance.

Environment: Oracle 10g, 11g, 12c, RHEL 5/6, SOLARIS, IBM AIX, OEM, RMAN, Grid, RAC, ASM, Data- guard, Golden Gate, TOAD, TDE.

Senior Oracle DBA

Confidential, Deerfield, IL

Responsibilities:

• Worked on all database activities such as User management, space management, and database security management on 10g, 11g databases on LINUX and WINDOWS servers.
• My duties as an Oracle DBA was to primarily ensure well-being of the OLTP production systems, schema object management, database deployments, and proactive monitoring.
• Installed, Created and maintained 2 Node 11g RAC with ASM and created database for production, development and test environment on HP-UX platform.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, monitoring and optimizing database performance.
• Perform Backup and Recovery of Primary and Standby Databases using RMAN and external backup using NETBACKUP.
• Used oracle configuration assistants like DBCA (Database Configuration Assistant) for Creating databases, DBUA (Database Upgrade Assistant) for Upgrading databases and NETCA (Network Configuration Assistant) for creating a Client-Server environment using Listener, TNS names etc.
• Installation of 11g /10g / 9i oracle binaries & Designing / Creation / upgradation of Databases for DEV & Production environments on Solaris / UNIX and LINUX servers.
• Performed Oracle RAC Clusterware Installation of 10g (10.2.0.4) Cluster Ready Services on 3 nodes Configuration, RAC Database Creation, and Node Administration.
• Implemented code changes like DML and DDL by coordinating with Developers and Change Management team.
• Installed and Configured Golden Gate for replication of production databases to Reporting Databases and troubleshooted Golden Gate issues.
• Expert in Golden Gate (10.x and 11.x) replication solutions to facilitate data flow between heterogeneous (SQL Server and Oracle) environments.
• Installed, configured and supported uni-directional and bi-directional replicated environments utilizing Golden Gate 10.x and 11.x software and created manager, extract, replicate trail files. Tested data is flowing from heterogeneous source systems to oracle database.
• Cloned databases by using RMAN and Exporting and importing database using Data Pump.
• Worked on implementing cold/hot/logical backup procedures using shell (LINUX) scripting and using RMAN. Developing, testing & implementing strong backup and recovery strategy. Responsible for monitoring backups regularly.
• Responsible for creating RMAN catalog Database and Registering the Databases in Catalog Database and Cloned production RAC instances to development and QA systems using RMAN duplication. Taking care of day to day basis Archiving related issues.
• Proactively managed the databases; set up notifications, alarms using shell scripts for managing any exceptions in day to day management of the databases.
• Extensively worked in various areas of Dataguard i.e. Installation, Recovery, RTA (Real Time Apply), Patching, Tuning, Switchover, Switchback and Failover.
• Performing routine Monitoring of Oracle Instances, Users, Undo/Rollback Segments, various other DB Objects, Memory Structures, SQL queries and Alerts.
• Implementing CRON setup to automate constant monitoring / various maintenance/reporting and other batch jobs using written Shell scripts (cron setup) and dbms scheduler.
• Implementing & monitoring Database Security through Users managements (distributing/limiting privileges) & Auditing.
• GoldenGate: Installation, configuring, Monitoring, Troubleshooting and Tuning Oracle GoldenGate in number of RAC (Real Application Cluster) environments

Environment: Oracle 10g/9i, Sun Solaris, HP-Unix, AIX, Linux 4.0, RMAN, DBCA, Data Guard, EXPLAIN PLAN, Cloning, OEM, STATSPACK, TKPROF, Toad, PL/SQL.

Oracle DBA

Confidential, Somerset, NJ

Responsibilities:

• Involved with installation and maintenance of Oracle RAC for high availability.
• Involved in change control process and Upgraded the Oracle 10g database to 11g version and applied patch set and interim patches whenever required to make the database software up to date.
• Responsible for implementing Load Balancing in RAC Database and to make health checks in RAC instances using Crsctl and Srvctl utility.
• Worked with IT managers and application developers to ensure the database integrity, high availability and security.
• Performed Tuning, coding and Monitoring for Oracle Real Application Clusters (RAC) nodes, Production Standalone Servers via Toad.
• Configured Oracle Data guard for Oracle Disaster recovery. Achieved High Availability, Data protection and Maximum performance by maintaining both physical and logical standby databases.
• Implemented Oracle database backup & recovery solutions using RMAN. Restoration and Recovery of databases at the times of occurrence of critical failures.
• Configured DATA GUARD to provide high availability by implementing physical stand-by database and worked with various features: Streams and Automatic Storage Management (ASM).
• Performed Capacity Planning, Undo segments and Health check reviews in RAC
• Monitoring Day-to-Day Backups, Log's & recovering them as per the requirement.
• Created, monitoring database objects like Indexes, Views, Users, and DB Links
• Wrote scripts for database maintenance activities such as monitoring the growth rate of table spaces and extents. Also wrote UNIX scripts to process batch jobs.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle hints, for rule based optimization
• Monitored queries with high response time and high disk read per execution (Top SQLs) and tuning the same using Explain Plan, TKPROF and SQL tuning advisor.
• Extensively used features such as Data Pump, Flash Back Recovery, ASM, AWR, ADDM for Generating reports.
• Designed and effectively implemented the Database part of the full Data center migration from one city to another with minimal downtime with solid backup plan which involves databases of size greater than 1 TB.
• Worked with DW team on problem resolution and implemented change requests. - Performance tuning on DW such as Data extraction from production to Data warehouse.
• Installed and Configured Oracle 10g databases on Linux and also Upgraded Oracle databases from 9i to 10g version using Opatch.
• Maintenance of around 180 databases combined on all the production, development and testing environments on various databases (DB2, SQL servers 2005).
• Installation, Configuration and Administration of Oracle 10g RAC. Converted a single instance database to Oracle RAC 10g.
• Involved in RAC administration including 10g Database cloning, tuning, patching and monitoring concurrent manager processing etc.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Performed automated backups and scheduling using scripting.
• Working with QA and Development teams for the regular database support.
• Coordinated weekly team meetings for reviewing and tuning forms trigger and PLSQL code.
• Suggested performance improvements by implementation of database stored procedures instead of repeated validation codes done on forms level triggers. This improved the performance of the entire application several times more as benchmarked by QA and UAT team.
• Performing the daily Maintenance tasks and interacting with Oracle Customer service when required.
• Automation of data load and data parsing using Pl/Sql procedures, Korn shell scripting and Sql*loader. Involved in 24x7 production database maintenance and on-call support.
• Conducted time-to-time analysis and monitoring of the software and hardware requirements and act accordingly.

Environment: Oracle 10g/11g RAC, ASM, Red hat Linux 5.x, Solaris, RMAN, SQL*Plus, SQL, SQL*LOADER, Oracle OEM, Import/Export Data-pump.

Oracle DBA

Confidential

Responsibilities:

• Installed and configured Oracle and Oracle Products on Linux and Windows Environments.
• Involved in Installation and customization of Databases (10g&9i) in Linux and Solaris environments.
• Evaluated the hardware requirements before upgrading/migrating the database.
• Managed users, privileges, profiles and schemas.
• Developed and modified Triggers, Packages, Functions and Stored Procedures for data conversions and PL/SQL procedures to create the database objects dynamically based on user input.
• Good knowledge on joins, which are inner join, Left outer join and Hash join, Semi join.
• Implemented various automated UNIX shell scripts to invoke PL/SQL anonymous blocks, Stored PROEDURES / FUNCTIONS / PACKAGES using SQL PLUS session in silent mode.
• Experience in using automatic monitoring and management processes such as batch processing using Crontab for processes like import, export databases.
• Monitoring the alert logs and trace files regularly. Administering the Client's Oracle 10g Database.
• Extensive use of Oracle Data pump utility for moving data among the servers.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Compared schemas, databases, TNSNAMES.ora file and Table-spaces for better understanding of databases between test and production environment.
• Put SQL and PLSQL standards in place to ensure that all application design and code is produced with proper integrity, security and performance and perform reviews on the design and code frequently.
• Working Experience with latest TOAD having new features PLSQL & SQL Script Debugger, Database Health Checkup, ASM Manager, Diagnose Extents, Segment Advisor, SGA Trace, Query Builder.
• Involved in writing UNIX shell scripting for automating the jobs.
• Experience with SQL query tuning, SGA tuning and Histograms understanding and sound knowledge in SQL execution plan.
• Architecture reviews, Change management meetings and Team meetings.

Environment: Oracle9i/10g, Linux, AIX5.1, Hp-UX, Sun Solaris, SQL, PL/SQL Developer, Shell Scripting