SUMMARY:

• 10 + years hands - on experience of Oracle 9i, 10g, 11g and 12c database administration.
• Extensive hands on experience of database performance tuning including RAC and SQL tuning experience with 10g R2 /11g RAC scalability, HA, robustness and load balancing, RAC performance tuning, instance availability and background processes monitoring, waiting events and log and trace files investigation for troubleshooting.
• Extensive working experience with 10g/11g RAC database installation, building, configuration and administration, ASM installation, configuration and monitoring and oracle CRS administration.
• Extensive working experience with 9i and 10g, 11g DATAGUARD/active DG to administrate both standby databases including installation, configuration, run-time monitoring and administration, performance tuning and trouble shooting.
• Experience with 10g/11g/12c OEM and GRID Control including installation, configuration, run-time monitoring and administration, patching and upgrading.
• 1 Year experience on exadata administration experience including providing advice and guidance for Disaster Recovery strategies for Database machines; Providing and implementing performance and tuning recommendations; providing upgrades and patching for exadata storage servers and InfiniBand switches or so.
• 3 years hand-on experience for Oracle Golden Gate for data replication for enterprise data centers including installation, configuration, administration, performance monitoring.
• Extensive working experience on business continuality including setup of database redundancy with RAC, active Data Guard, enterprise database replication with golden gate, database DR to provide backup recovery strategies using Oracle ZFS and NetApp DR backup/recovery strategies to practice database DR restore and recovery to achieve minimum system down time.
• Extensive working experience with administration of large-scale, massively concurrent, highly available distributed OLTP systems to monitor and administrate running on 24*7 within a team group.
• Extensive working experience of database backup and recovery with RMAN, DATA PUMP and exp/imp on 9i, 10g and 11g.
• Proficient in shell and PL/SQL scripting to develop database administration tools for database protective maintenance, security, performance tuning, backup/recovery, SQL tuning.
• Extensive working experience with database migration experience using ETL tools involved in multiple platforms including AIX, Solaris to RHEL with VM provisions, database capacity planning, migration roadmap preparation and verification, performance evaluation and testing, storage analysis and space expectation, database design and optimization.
• Experience in programming with Perl, Unix/Linux shell script, Oracle PL/SQL. Experience in database designing and developing.
• Excellent work ethic with ability to work alone and in a team environment. Strong analytical and problem solving skills.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle DBA/Architect

Environment: Oracle RAC Database 12c, 11g, 10g, AIX, Solaris11, RE Linux 6, Suse linux 11,OEM 12c

Responsibilities:

• Architected, Designed, Installed and configured a 3 node RAC Database on Solaris,AIX, and Linux platforms
• Ensure technical documentation is kept up to date
• Identify training needs within support organization and proactively create and deliver training sessions to address these requirements.
• Execute the collection of requirements, product comparisons, product research, and architecture
• Upgraded all production databases from 11g to 12c.
• Actively participating and/or serving in a supporting role to meet the customer’s obligations and mandates. Prepares status updates for management. Provide technical leadership to the Applications Support Team, Developers and System Admins.
• Support Production, QA, DEV, UAT databases.
• Performed data migrations using ETL tools.
• Provide level advanced technical system expertise, oversight, and accountability for resolution of outages, service level issues, and user/customer support needs in coordination with the Steady state support teams.
• Configured and maintained OEM 12c
• Established RMAN backups and recovery policies
• Upgraded production and all test databases from Oracle 10.2.0.3 to 11.2.0.4 to 12.1.0.2
• Cloned oracle production databases for development and testing
• Cross platform Migration of databases using export/import and datapump
• Daily health checkup of databases
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration ETL tools
• Replication and Extracting data and applying on production using GoldenGate
• Extensive working experience with 10g, 11g and 12c Active DATAGUARD to administrate bothstandby databases including installation, configuration, run-time monitoring and administration, performance tuning and trouble shooting.
• Participate in planning strategies for future database needs for business needs in perspective of capacity planning, performance and available technology.
• Configuration of Oracle Standby Databases(Active Data Guard) forhigh availability /Disaster Recovery Solution from Production Server to the DR Server
• Experience on Oracle Golden Gate for data replication for enterprise data centers including installation, configuration, administration, performance monitoring.
• Resolution of day to day related issues, documentation of Oracle DBA routine tasks
• Creating documentation during project planning, project execution and project maintenance phases.

Confidential

Sr. Oracle DBA/Engineer / Architect

Environment: Oracle RAC Database 12c, 11g, 10g, AIX, Solaris11, RE Linux 6, Oracle Data Integrator (ODI)/Oracle Warehouse Builder (OWB)

Responsibilities:

• Architected, Designed, Installed and configured a 3 node RAC Database on Solaris 11, and Linux platforms
• Established RMAN backups and recovery policies
• Upgraded production and all test databases from Oracle 9.2.0.8 to 10.2.0.3 to 11.2.0.4 to 12.1.0.2
• Execute the collection of requirements, product comparisons, product research, and architecture
• Implements, administers, manages, monitors, and tunes the assigned application databases in development, pre-production and production environments. Designs and implements performance tuning improvements and advises developers on tuning options. Ensures that data integrity and data security is maintained. Demonstrates advanced troubleshooting and analytical skills through problem resolution.
• Performed data migrations using ETL tools.
• Actively participating and/or serving in a supporting role to meet the customer’s obligations and mandates. Prepares status updates for management. Provide technical leadership to the Applications Support Team, Developers and System Admins.
• Support Production, QA, DEV, UAT databases.
• Provide level advanced technical system expertise, oversight, and accountability for resolution of outages, service level issues, and user/customer support needs in coordination with the Steady state support teams.
• Cloned oracle production databases for development and testing
• Configured and maintained OEM 12c
• Cross platform Migration of databases using export/import and datapump
• Daily health checkup of databases
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration ETL tools
• Replication and Extracting data and applying on production using GoldenGate
• Identify training needs within support organization and proactively create and deliver training sessions to address these requirements.
• Participate in planning strategies for future database needs for business needs in perspective of capacity planning, performance and available technology.
• Configuration of Oracle Standby Databases(Active Data Guard) forhigh availability /Disaster Recovery Solution from Production Server to the DR Server
• Experience on Oracle Golden Gate for data replication for enterprise data centers including installation, configuration, administration, performance monitoring.
• Resolution of day to day related issues, documentation of Oracle DBA routine tasks
• Creating documentation during project planning, project execution and project maintenance phases.
• Created zones in NetApp Storage and maintain Zones
• Created Zpool’s in zones
• Supporting Sun Blade Servers, T5-2 servers

Confidential

Sr. OracleDBA/Engineer / Designer

Environment: Oracle RAC Database 12c, 11g, 10g,AIX, Solaris11, RE Linux 6, Oracle Data Integrator (ODI)/Oracle Warehouse Builder (OWB)

Responsibilities:

• Provide technical leadership to the Applications Support Team, Developers and System Admins.
• Guided and mentored team members to support all production databases.
• P lans, coordinates and implements database management software installations and upgrades
• Performed and taken care of various node eviction issues
• Ensuring regular RMAN backups are in place
• Upgradation of database from 10g to 11g to 12c and applying patches whenever required
• Cloned oracle production databases for development and testing
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration ETL tools.
• Cross platform Migration of databases using export/import and datapump
• Daily health checkup of databases
• Experience in replication using golden gate, materialized views
• Implemented and configured Goldengate in 2-node RAC cluster
• Implementation of High availability solutions with Oracle 11gR2 RAC, 10g RAC Standby Database(Active Data Guard), Replication
• Resolution of day to day related issues, documentation of Oracle DBA routine tasks
• Creating documentation during project planning, project execution and project maintenance phases.
• Created LDOM’s in Oracle ZFS storage and maintaining LDOM’s
• Supporting Oracle Sun Sparc T5-4, T5-2 servers

Confidential

Database Engineer

Environment: Oracle RAC Database 11.2.0.4, 10.2.0.3, Solaris11,AIX,RE Linux

Responsibilities:

• Installed and configured Oracle database.
• 24*7 production support and monitoring to ensure proactive problem recognition and resolution of various issues related
• Installed and configured a 2 node RAC databases on Solaris 11 and Oracle Linux 6.
• Performed and taken care of various node eviction issues
• Ensuring regular RMAN backups are in place
• Upgradation of database from 10g to 11g and applying patches whenever required
• Cloned oracle production databases for development and testing
• Cross platform Migration of databases using export/import and datapump
• Maintained Standby Databases(Active Data Guard) for Production Databases
• Daily health checkup of databases
• Configuration of Oracle Disaster Recovery Solution (DR) from Production Server to the DR Server
• Resolution of day to day related issues, documentation of Oracle DBA routine tasks
• Creating documentation during project planning, project execution and project maintenance phases

Confidential

Oracle DBA

Environment: Oracle 11g, RHEL Linux 5,6, Solaris 10, 11

Responsibilities:

• 24*7 production support and monitoring to ensure proactive problem recognition and resolution of various issues related
• Installed and configured a 2 node RAC on Solaris 11
• Ensuring regular RMAN backups are in place and Validate RMAN backups Daily
• Cloned oracle production databases for development and testing
• Cross platform Migration of databases using export/import and datapump
• Daily health checkup of databases
• Configuration of Oracle Disaster Recovery Solution (DR) from Production Server to the DR Server
• Resolution of day to day related issues, documentation of Oracle DBA routine tasks
• Creating documentation during project planning, project execution and project maintenance phases.
• Supporting Exadata Systems, SUN Sparc Servers, Sun Blade Servers

Confidential

Oracle DBA

Environment: Oracle 9i, 10g, RHEL Linux 5, Solaris 10

Responsibilities:

• 24*7 production support and monitoring to ensure proactive problem recognition and resolution of various issues related
• Created instances and databases with appropriate initialization parameters and database structures
• Installed and configured Data Guardusing physical-standby for high availability and reporting
• Performed and taken care of various node eviction issues
• Partitioned large tables and created indexes to improve the performance
• Ensuring regular RMAN backups are in place
• Configured tnsnames.ora, listener.ora for sqlnet.ora and connectivity
• Upgradation of database from 9i to 10g and applying patches whenever required
• Cloned oracle production databases for development and testing
• Cross platform Migration of databases using export/import and data pump
• Daily health checkup of databases
• Making sure that proper RMAN backups are in place as part of a daily job
• Cloning of database from production to development and test databases using RMAN
• Resolution of day to day issues, and routine tasks
• Resolution of day to day related issues, adhering to the service level agreement
• Management of security, granting and revoking permissions to users or roles when required
• Resolution of day to day related issues, documentation of Oracle DBA routine tasks