OBJECTIVE:

Seeking a challenging position as an Oracle DBA & Exadata DMA in an esteemed organization with good knowledge on Oracle 9i/10g/11g/12c and working experience on production and development environments, willing to make a significant contribution both as a team member and as an individual.

PROFESSIONAL SUMMARY:

• 10+ years of extensive experience as Oracle DBA in RAC and MS SQL servers
• Good Knowledge Mongo DB administrative activities including Mongo shell commands,
• Sharding, replica sets, user security, importing/exporting data into Mongo, etc.
• Strong understanding of MongoDB and NoSQL database concepts
• Experience in Amazon Cloud RDS databases.
• Involved in all aspects of Database Administration in MS - SQL Server 2005 and 2008.
• Focusing on Exadata Administration. With nodes ranging from 2 to 8 and incorporating dataguarded exadata clusters for maximum availability
• Worked on ESM Battery and disk replacement activities on Exadata servers
• Good knowledge in upgrading Cell storage servers from 12.1.1.1.1 to 12.1.2.1.1
• Installed, configured and maintained Oracle Real Application Cluster Databases
• Experienced on Adding a Node and Deleting Node in 11gR2
• Upgraded RAC Databases from 11.2.0.3 to 11.2.0.4
• Worked On cross platform migrations using GG and Delphix tools .
• Experience in Administer the Oracle Cluster using Command line Utilities
• Experience in oracle GoldenGate Installation,configuration,troubleshooting Golden Gate issues
• Design, Create and Maintain DB objects like tables, views, triggers etc.
• Maintain PL/SQL objects like packages, triggers, procedures etc.
• Implemented Uni-directional replication using Golden Gate
• Implemented Oracle 11g RAC and DATAGUARD for MAA on PROD databases
• Experience on Backup and Recovery using diverse techniques such as Physical /
• Logical backups.
• Perform Query tuning, Instance/Memory tuning by using various performance tools
• TKProf, Explain Plan, Statspack, ADDM, AWR, etc
• Experienced of managing and administering 24X7 running databases. prepared standard operating procedure(sop) documents for frequently used databases tasks and process
• Good Analytical and Strong interpersonal and excellent communication skills

TECHNICAL SKILLS:

Primary Skills: Oracle DBA(9i,10g,11g,12c),Exadata, Goldengate, Amazon RDS

Tools: Utilities Sql*Plus, OEM, Toad, Stats pack, Sql loader, Golden Gate,Exp/Imp,Rman,Srvctl,Crsctl, Asmcmd,OPtach,Dbua,Dbca

Languages: Sql/Plsql, PL/SQL, C, C++, C#, VB.NET, JAVA, XML, UNIX Shell Scripting.

Database: Oracle 9i, 10g,11g, SQL Server 2005/2008,Golden Gate

Hadoop Ecosystems skills Map: Reduce,Pig,Hbase,MongoDB,Hive,Oozie,Ambari

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr. Oracle DBA/Engineer / Architect

Responsibilities:

• 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
• Migrating AIX databases to Exadata x5 and C3 Cloud
• Cross platform Migration of databases using datapump,GG and Delphix tools
• Performing RAT test before and After migrations.
• Experience in F5 load balancer
• Installation, configuration, patching and upgrades of Oracle RAC.
• Developed PL/SQL packages, stored procedures, functions, Cursors, triggers.
• Experienced in Oracle SOX databases
• Implementing Change controls in production environment
• OEM Grid control to monitor all databases.
• Upgradation of database from 10g to 11g to 12c and applying patches whenever required
• Implementation of High availability solutions with Oracle 11gR2 RAC, 10g RAC Standby Database(Active Data Guard), Replication
• Ensuring regular RMAN backups are in place
• Worked on Active Standby Database and snapshot standby database
• Ensuring regular RMAN backups are in place
• Daily health checkup of databases
• Experience in replication using golden gate, materialized views
• Implemented and configured Goldengate in 2-node RAC cluster
• Perform DB patching, Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions and personal research.
• Database refresh, schema refresh, database creation, Implement table partitioning
• Co-ordinate with application team and developers in resolving issues andprepare deployment plans
• Configured and tested backup and recovery using RMAN
• Cloning of production database to the test environment using Recovery Manager (RMAN).
• Restoring the databases on the test server with the backed up files of live server.
• Provide support on production server to the clients after the live upgrade till the transition.

Environment: Oracle Exadata Database 12c, 11g, Golden Gate, Delphix C3 cloud, AIX, Amazon RDS, Oracle Linux 6,OEM, Emc Storage

Confidential, NJ

Sr. Oracle DBA/Engineer / Designer

Responsibilities:

• Focusing on Exadata administration. with nodes ranging from 2 to 8 and incorporating dataguarded eaxdata clusters for maximum availability
• Migrated Databases from X3-8 to X5-8 Exadata Machines
• Supporting customers for resolving their Critical Production Issues.
• Very strong Production Support (24X7) experience
• Involved in all aspects of Database Administration in MS-SQL Server 2005 and 2008.
• Knowledge of MongoDB performance/scaling/sharding concepts and best practices.
• Managing lifecycle of MongoDB database including database sizing, deployment automation, monitoring and tuning
• Installation, configuration, patching and upgrades of Oracle RAC.
• Experienced in Oracle SOX databases
• Implementing Change controls in production environment
• Upgrade/Migration of Databases from Oracle 10g to 11g.
• Maintain PL/SQL objects like packages, triggers, procedures etc.
• OEM Gridcontrol to monitor all databases.
• Planned and implemented high availability solutions using Oracle 11g RAC, Standby Database using Oracle Data Guard
• Worked on Active Standby Database and snapshot standby database
• Experience in oracle GoldenGate installation,configuration,troubleshooting Golden Gate issues
• Perform DB patching, Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions and personal research.
• Database Tuning, PL/SQL tuning using explain plan and used HINTS extensively to optimize the SQL statements, used cost based approach extensively and also used rule based methods to tune the SQL
• Database refresh, schema refresh, database creation, Implement table partitioning
• Co-ordinate with application team and developers in resolving issues andprepare deployment plans
• Proficient in using OEM and RMAN
• Configured and tested backup and recovery using RMAN
• Cloning of production database to the test environment using Recovery Manager (RMAN).
• Restoring the databases on the test server with the backed up files of live server.
• Provide support on production server to the clients after the live upgrade till the transition.
• Upgrades exadata databases from 11.2.0. .2.0.4.16
• Supported Disk and ESM Battery replacement Activities on X3 and X5 Exadata machines
• Converted Flash cache from Write-Through to Write-Back
• Applied the interim and Bundle patches for RAC and Exadata Databases
• Configured and tested backup and recovery using RMAN
• Worked with Oracle Support through TAR to resolve issues
• Building standby database for the replication of the primary database
• Restoring the databases on the test server with the backed up files of live server.
• Provide support on production server to the clients after the live upgrade till the transition.
• Implanted Uni-directional replication using golden gate

Environment: Oracle Exadata Database 12c, 11g, 10g,AIX, Golden Gate, Oracle Linux 6, Hitachi Storage

Confidential

Oracle RAC DBA

Responsibilities:

• Installed and configured of Oracle 11gR2 (11.2.1 and 11.2.0.3)Real Application Clusters on Production database.
• Installed & Configured of Oracle Cluster Software’s (11.2.0.3) (Placed OCR & Voting disk in Raw ASM file systems).
• Upgraded RAC servers from 11.2.0.1 to 11.2.0.3
• Installed and configured of OEM(11g grid control)
• Converted single instance database to cluster database.
• Configured ASM Instances and Migrated Non-ASM Databases to ASM databases Using RMAN
• Managing the oracle cluster ware using: crsctl, crs stat, ocrconfig, ocrdump utilities.
• Managing RAC instances using srvctl.
• Support Production, QA, DEV, UAT databases.
• Cross platform Migration of databases using export/import and datapump
• Applying rolling patches in RAC environment using Opatch AUTO
• Applying oracle PSU,Memory patches(CPU)
• Converted single instance database to cluster database.
• Worked on Active Standby Database and snapshot standby database
• Capacity Planning, Minimize the database down time.
• Configured and tested backup and recovery using RMAN
• Worked with Oracle Support through TAR to resolve issues
• Building standby database for the replication of the primary database
• Restoring the databases on the test server with the backed up files of live server.
• Provide support on production server to the clients after the live upgrade till the transition.
• Performed Database Reorg for faster Performance.

Environment: Oracle 11g RAC, OEM, RHEL 5, 6, IBM AIX, Hitachi Storage

Confidential

Oracle DBA

Responsibilities:

• Involved in installation and configuration of Oracle 10g Real Application Clusters on Test database.
• Responsible For Installation & Configuration of Oracle Cluster Software (Placed OCR & Voting disk in Raw devices)
• Converted single instance database to cluster database.
• Managing the oracle clusterware using: crsctl, crs stat, ocrconfig, ocrdump utilities.
• Configured and tested backup and recovery using RMAN
• Installed and Configured Oracle RDBMS software on various platforms.
• Cloning of production database to the test environment using Recovery Manager (RMAN).
• Tuned the database for better performance using Explain Plan and AWR
• Interaction and Co-ordination with clients. Resolving the problems like resize tablespace, Session lock/Killed, Deadlock, Schemas Refresh on Client request
• Uploaded the data between the databases using Export and Import Data pump Utilities
• Creating Database objects, Users, Roles, Profiles for the databases.
• Involved in reorganizing the tables and Rebuilding the Indexes that are highly fragmented to improve the performance.
• Monitoring performance Issues with AWR, ADDM & ASH Reports.

Environment: Oracle 11g, 10g, Solaris 10,11, Rhel, 5, 6

Confidential

Oracle DBA

Responsibilities:

• Daily monitoring the performance of database
• Performing oracle installations
• Performing Export and Import operations.
• Performing backup and recovery operations if needed
• Database Creation
• Managing Tablespaces, Datafiles, Control files, Redo Log files.
• Creating Databases, Creating table spaces with storage parameters.
• Creating Database objects, Users, Roles, Profiles for the databases..
• Checking alert log file.
• Cleaning up unused spaces from the server for backup process.
• Monitoring Space and Index usage
• Checking database locks and clearing the blocking sessions.

Environment: Oracle 11g, 10g, Solaris 10,11, Rhel, 5, 6