PROFESSIONAL SUMMARY:

Around 8 years of experience as Oracle Database Administrator in various domains and on a variety of UNIX and Windows platforms with Oracle 12c/11g/10g/9i/8i . Highly competent in Administration, Monitoring and specialized in Advanced DBA skills such as Performance Tuning, Database Backup and Recovery.

• Proficient experience as an IT professional along with extensive experience as an Oracle Analyst
• Proficient in Oracle 12c, 11g R1, 11g R2, Oracle 10g R2, 10.1.0.x, Oracle 9.2.0.x, Oracle 8.1.7.x
• Experienced in Oracle installations, upgrades, migration, configuring logical/physical architecture, SQL, Tuning, database access and Security and auditing
• Hands on experience on Oracle ExaData Database Machine Implementation and Maintenance.
• Oracle Database Administration experience in variety of different environments like HP-UX, SUN SOLARIS, AIX, RedHat Linux and Windows.
• Experienced in Installation of high availability RAC environment 2, 3 and 4 node clusters and upgraded standalone databases to 10g/11g/12c RAC environment.
• Experience in Real Application Clusters RAC setup, configuration and cluster interconnection with Automatic Storage Management ASM , configured user log on load balancing and failover on RAC database for high availability.
• Installed and Administered Oracle 11g ASM 10g RAC software with ASM OCFS2 File systems.
• Strong experience in migrating database from Non-ASM to ASM and Non-RAC to RAC.
• Administered Oracle ASM disk groups mirroring, compatibility with Oracle ASM Configuration Assistant ASMCA .
• Proficiency with Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicate.
• Implemented Golden Gate for data recovery and data migration for Oracle 11gR1 RAC multi nodes on IBM AIX and debugging Golden Gate issues such as extract, replicate rebuild and abend.
• Experience in using Golden Gate in moving large volumes of transactional data, with minimal impact to online systems.
• Performed data replication, transformation and delivery of database transactions using Golden gate replication tool. Supported a large number of Development Databases.
• Laid hands on new tools and experienced features like Data Replay, Log Miner and Flashback data Archive, Schema Management, Data guard and RMAN in Oracle 11g.
• Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.
• Performed backups and crash recoveries using conventional hot/cold backups and RMAN
• Extensive knowledge in Database Cloning using RMAN, VERITAS Net Backup, IBM Tivoli Storage Manager TSM .
• Monitoring and optimizing the performance of the database through Database Tuning Tuning Applications, Tuning Instance, and Tuning Disk Usage.
• Implemented Dataguard in the production environment.
• Excellent experience in various migration techniques like export/import, Data pump, backup restore, cloning, and data guard.
• Proficient in setting up Standby Database supported by ORACLE DATAGUARD for disaster recovery purpose.
• Implementing FSFO Fast start failover on databases and configuring disaster recovery site using Dataguard. Also proficient with new 11g features such as Active Dataguard and Snapshot standby database.
• Delivered SQL and Database performance tuning services via V /GV views, Explain Plan, TKPROF, AWR Stats pack reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager OEM , Grid control, analyzed SQL trace dumps for 9i/10g/11g.
• Configured database 10g, 11g for ORACLE FLASHBACK TECHNOLOGY.
• Managed Materialized Views for data replication purpose.
• Experience in Installing and configuration of IBM Optim on servers, using Informatica ILM and Optima tools for data archiving and data purging
• Transferring compressed files on FTP servers, on UNIX platform.
• Good experience in MSSQL Server 2000/2005/2008, T- SQL with knowledge of Server Clustering, SQL Profiler, Execution plan, Log Shipping, and Database Mirroring.
• Experienced with installing, configuring and administering SQL server 2000/2005/2008 databases including migration from MS SQL server to oracle.
• Solved many Network related problems in a database using Oracle Net Configuration Assistant NETCA , Oracle Net Manager, Net stat and ping utility, providing Oracle Networking Solutions tnsnames.ora, sqlnet.ora .
• Experience with Repository Manager to import Metadata for sources and targets and the mapping designer to map source to the target.
• Good experience in applying Critical Patch Update CPU Patches on Databases, Application Servers and Middle Tiers.
• Scheduling jobs through Oracle Job Scheduler, Cronjobs UNIX , Autosys jobs, Scheduled Tasks Windows .
• Supported a large number of Development Databases, mainly in tuning the SQL code to improve Performance

• Programming:

• Experience with SQL, PL/SQL coding, stored procedures, triggers, functions, packages.
• UNIX Shell Scripting, Partitioning, Indexes, ERWIN Data modeling, Logical and Physical database design.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle DBA

Environment: Oracle Exadata IBM AIX 6.3,7.1, Sun Solaris 2.6/7/8, Red Hat Linux 6.0, Oracle 10g/11g/12c, PL/SQL, SQL PLUS, VNC, ORACLE ENTERPRISE MANAGER 9.2.0 , Oracle 12c GRID, QUEST SOFTWARE 5.0 , Oracle RAC, Data guard, Toad 8.6, Oracle Applications 11.5.8, Oracle Application server 10g, AD utilities, APEX 2.0/2.2,Sybase, SQL server

• Worked with IBM VERITAS Active - Passive clusters.
• Performed the code reviews for all the db code coming into the database and fine tuned it before hand.
• Worked under high stress situations many times and handled the situation very effectively.
• Utilized Accurev tool for code version change control activities.
• Handled all dba work for Business promotional activities.
• Contributed as an efficient/reliable team member for all business critical releases and changes.
• Worked with projects/operations/professional services team and co-ordinate multiple tasks at hand with expertise and solid plan.
• Documented all Oracle 12c installation/Up gradation work and delivered KT to all team peers.
• Extensive Experience with Change Board Meetings and Change Control Management for all database changes.
• Implemented OEM 12c Repository database, OEM 12c Agent and golden gate plugin Installations.
• Installed, Configured Oracle 12c Goldengate on Oracle 12c Database.
• Utilized rman recover table functionality and created proof of concepts for our pre-prod environment.
• Implemented oracle 12c flexi asm for pre-prod environment.
• Implemented oracle 12c active standby database for test database environment.
• Involved in 24x7 support for 4TB, 4 Node production RAC database with on-call pager
• Extensively worked on goldengate implementations in peer to peer topology.
• Responsibilities:
• Worked on upgrading of oracle databases from 11g to 12c.
• Worked on building and rolling out new 12c databases for test/dev/qa environments.
• Migrated Oracle database from Non Exadata machine to Exadata using datapump and goldengate.
• Installation and creation of 11g and 10g databases for Testing, Development and Production
• Installed Golden Gate 12c on IBM-AIX Platform.
• Implemented 12c/11g Data guard with one physical database
• Installed, upgraded Golden gate for Oracle database and enable real-time data integration and continuous data availability by capturing and delivering updates of critical information as the changes occur and providing continuous data synchronization across heterogeneous environments.
• Assist Programmers and Developers with Oracle problems.
• Designed, configured and maintained backup and recovery policies including RMAN backups.
• PL/SQL, Performance Tuning, Application Tuning and Monitoring.
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption
• Extensively worked with ASMCMD for managing ASM environment.
• Disaster recovery of Exadata Data guard Physical Standby. Failover/Switchover/Loss of Service/Rebuild/Corruption/Loss of datafile testing.
• Used Oracle 11g/12c AWR ADDM to monitor database activities and performance tuning.
• Backup of Database Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.
• SQL query tuning using tools like Explain Plan, SQL Trace, TKPROF and Statspack.
• Proactive performance monitoring, and capacity planning for future database and server growth using OEM.
• Performed Range Partitioning as a cause to improve the performance of the database.
• Performed Cross platform migration using transportable table spaces and RMAN.
• Planned and performed the database migration from SQL Server to Oracle using Golden Gate.
• Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations on an as needed basis.
• Transformed logical database designs into physical databases using ERWIN Data Modeling Tool.
• Build and implement test, quality assurance, and production databases and environments.
• Coordinated strategies to move data between databases using expdp/impdp.
• Composed maintained and monitored compliance to standards and practices.
• Assisted IT Analysts on technical database issues and features.
• Resolved data integration issues.
• Performed version upgrades and patch installs.
• 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.
• Solid discipline in providing end-users timely updates on their problems. Installing server software.
• ASM implementation maintenance. Migrating and upgrading the Oracle 9i database to Oracle 10g and incorporating the changes in the database design.
• Proficient in setting up Standby Database supported by ORACLE DATAGUARD for disaster recovery purpose.

Confidential

Sr. Oracle DBA

Environment: Oracle 11g/10g, SQL, PL/SQL, Erwin, TOAD 10.1 , Recovery Manager RMAN , Tivoli, Oracle Enterprise Manager OEM , SQL Loader, TKPROF, Data Guard, Shell Scripts, Golden Gate, AWR, ADDM, HTML, DHTML, Windows 2008, RHEL 4.0, AIX-5.3, JAVA

Responsibilities:

• Worked on Oracle RAC with SRDF Implementations for cross data center replication.
• Administered the tidal job scheduler for datacenter automation tasks.
• Worked on HP Quality Centre tool for test/dev/qa code drops and environment true-ups.
• Implemented oracle 11g golden gate for replication project.
• Implemented Oracle 11g Active Data guard for Disaster Recovery Solution.
• Worked on Implementing Oracle OEM 11g Agent cloning tasks for hundreds of servers.
• Extensive Experience with Change Board Meetings and Change Control Management for all database changes.
• Handled Vendor applications and interacted with vendors regularly to understand and optimize the database operations.
• Actively participated on war room bridges during major releases and escalated to dba management as needed.
• Participated in database audits and following compliance rules and regulations always.
• Worked with HP service guard on top of oracle 10g databases.
• Participated in requirements gathering meetings with customer while building out new db environments.
• Effectively communicating with PM'S while working on project related tasks.
• Prioritizing db related tasks on daily basis and completing most of them before the close of Business every day.
• Participated in internal db team meetings with peers and management for db work/project status update.
• Planning, Implementing and Validating various versions of Oracle Databases to 10g Release 2 10.2.0.1, 10.2.0.2 and 10.2.0.4 11g Release 1 11.1.0.6,11.1.0.7 upgrades on all the environments in a procedural approach Dev, Test, Stage and Production also Planning of back out procedures like downgrades/building parallel environments and also working on proof of concept for Oracle 11g upgrades.
• Always uploaded the common share point repository with all updated work related documents for sharing purpose.
• Worked with offshore team and co-ordinate with them always for any database changes by means of email/phone communication.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK Reports and AWR Reports.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Implemented Oracle Patches CPU, PSU on the Compliance databases Device a plan to patch them quarterly so that we can cover all the databases in a year.
• Application Team in identifying issues and provide solutions for various issues created via IBM-CMR,IMR in-terms of incidents and work orders of different severity levels like Sev1, Sev2, Sev3, Sev4 .Used IBM Mange Now.
• Production Support for Critical Application Databases, work closely with
• Responsible for installing manually , maintaining, performance tuning, and monitoring of Oracle databases version 10g and 11g on AIX-5.3 in dev, QA, test and production.
• Worked with developers and management team to ensure smooth life cycle progress from development through testing and production implementation.
• GoldenGate installation, configuration for replication.
• Helped in Performing Golden Gate replication monitoring, tuning, and capacity planning.
• Have set up the cronjobs for runalert, spacewatch monitoring, RMAN backup level 0 and level 1 and recovery, archive log purge, deletion of archive logs and AWR reports on AIX-5.3.
• Used normal import and export and also datapump import and export for exporting and importing schemas, tables etc from one database to another.
• Extensively worked with dba jobs, dba scheduler jobs, functions, procedures and packages.
• Responsible for tuning the database performance issues like query tuning and memory tuning SGA tuning and also partitioned the tables and indexes for better performance.
• Have used different tools like TOAD 10.1 , EXPLAIN PLAN, AWR, ADDM Oracle enterprise manager GRID CONTROL 10.2.0.4 to solve the performance issues.
• Kept tracking the database performance using oracle enterprise manager and checking the users sessions which consuming more CPU and taken the necessary steps to reduce the CPU usage.
• Monitored the databases and added the data files to the tablespaces or resizing the tablespaces and monitored the sessions running on the databases.
• Analyzed the tables and indexes manually whenever required. Manually refreshed the materialized views used for replication whenever the job fails to refresh them.
• Created new schemas, tables, indexes, jobs, tablespaces and granting the previleges to the user as per demand and also written pl/sql code to delete million rows by committing after every 10,000 rows.
• Monitored and checked the invalid objects like jobs, procedures etc and recompiled manually after solving the problem for objects to become invalid.
• Installed the oracle dataguard on 11g physical standby database on IBM-AIX-5.3for high availability, disaster recovery and used dataguard broker for switchover and failover using utility DGMGRL.
• Deployed the patches for grid agent and oms for the version 10.2.0.4 and troubleshooted the problems in uploading agent and securing agent.
• Troubleshooting application failures including performance and database connectivity problems and job failures.
• Performance tuning of corporate databases, using tools like sql trace, tkprof, AWR, ADDM, SQL Tuning.
• Administrated the automatic storage management ASM like adding the disk groups.
• Worked on Automatic Storage Management ASM for managing data in SAN. Worked with ASMCMD utility for monitoring the ASM and experienced in ASM like adding new disks, creating new disk groups and configuring these disk groups into ASM on AIX-5.3.

Confidential

Oracle DBA

Environment: Oracle 10g/9i, Solaris, VERITAS, OEM, EXPLAINPLAN, TKPROF, AIX, Oracle 10g, RAC,TOAD

Responsibilities:

• 24/7 Production Database Administration Support
• Installed and Configured Oracle 9i/10g RAC.
• Worked on Multiple RAC clustered environments ranging from 2 nodes to 4 nodes per cluster.
• Experienced with SRVCTL, OCR and Voting Disk of 10g RAC.
• Managing two node RAC databases on Red hat Linux advanced server 2.1.
• Performed Database migration from Oracle 9.2.0. To 10.1.0.3
• Implemented Golden Gate for Standby Configuration and developed procedures for Replication.
• Creation of Test and production databases of Oracle Enterprise Edition 8.1.7
• Monitored the growth of the database objects for capacity planning.
• Has primary responsibility for Oracle Data Base and Application performance tuning, physical/logical design and optimization and availability.
• Used Flashback Technology-Query, Table, Drop and Database to undo specific transactions, provided point-in-time recovery of database objects, recovered database objects and rewind entire database to a particular time respectively.
• Perform requirements gathering, data mapping, metadata management and databasemodelling.
• Designed and implemented OLS oracle 9i label cache to enable use of Hibernate with OLS and to improve performance by eliminating repeated use of Oracle conversion functions.
• Optimized data loading using SQL Loader to load different types of data from flat files to the Oracle server.
• Configured the automated alerts for the production servers, which alerts DBA with the alert log errors and proactively space related errors.
• Cleaning the ORACLE HOME file system by cleaning the log files, alert log file and listener.log files
• Identified and trouble shot everyday issues like locking, scripts execution, Data Audits etc.
• Backup and recovery utilizing RMAN.
• Working with the application support people to resolve database related issues and running the scripts for the application support people.
• Creating users and database links, snap shots on production and development servers.
• Maintaining system security, defining of roles, profiles etc.
• Checking CRON jobs. Monitoring Application specific background processes.
• Creating materialized views and materialized view logs to implement the table level replication for the MIS databases.
• Use Oracle Metalink Support to resolve different issues related to database servers, security patches.
• Installed and Upgraded Shareplex 3.2 to 4.1 a replication tool for reporting environment.
• Performing Online and Offline database backups on schedule.
• Scripting of Automated backup for Cold / Hot backups.
• Implementation and Configuration of OEM Oracle Management Server for maintenance and monitoring.
• Installation and Maintenance of Shareplex Replication, Quest-Spotlight.
• Perform database cloning/exp/imp to setup identical databases in the production and development environments.
• Upgrade/Migrated the production and development databases from 9i to 10g.
• Involved in Database sizing, Capacity Planning.
• Identify Top SQL that are consuming heavy resources and provide support to the development team in identifying SQL queries that are consuming high resources and to see if these queries can be fine tuned for better performance.

Confidential

Jr. Oracle DBA

Environment: Oracle 9i/8i/8/7.13/6, NCR Mainframe/Servers, UNIX SVR4, Windows NT, PL/SQL, Bourne Shell, SQL Loader, EXP/IMP, SQL Forms, SQL Report, Pro C.

Responsibilities:

• Supported high availability for production databases and development databases by designing and implementing different backup and restore strategies using either OS/UNIX or Oracle Techniques.
• Ensured production database systems performance by monitoring and tuning memory, database and operating system parameters backed up database, restored data as needed.
• Assisted Sr. Oracle DBA in Performing production database health check, performance tuning, operation auditing. Replicated databases for Developer team and QA team by setting up testing database, testing environment, test cases and live/stress tests.
• Implemented database job processing via Oracle and UNIX crontab.
• Maintained Microsoft SQL Database Server 2003.
• Net8 Configuration for Clients Connection.
• Designed, implemented, troubleshoot and maintained database application systems including Payroll, Sales, Account Payables/Receivables, General Leger, Bank Leger, Inventory, and Customer Order.
• Performed data replication between units.
• Created users and set permissions.
• Analysed system requirements for over 10 database Oracle 6, 7, 8 applications, defined user interfaces and system functionalities, implemented systems using Oracle Forms, Reports, wrote SQL, PL/SQL procedures performed database upgrades.
• Assisted team in successfully maintaining, debugging, trouble-shooting 7 huge transaction-intensive enterprise databases achieved excellent performance, least planned down time.
• Managed database security using groups and roles.
• Created database objects and managed the permission access on the objects with necessary security.