SUMMARY:

• 7 years of experience in System Analysis, Design, Development and Administration on Oracle 9i/10g/11g and 12c Database.
• Upgraded the Databases from Oracle 10.2.0.3 to 11.2.0.3 and applied patches according to the client requirement.
• Experience in Installation, Configuration, up gradation and Maintenance of Oracle Databases.
• Installed, Upgraded and Maintained Oracle RDBMS on Linux, UNIX & Windows platforms.
• ACHIEVED High Availability, Scalability and Performance by determining the Cluster architecture choosing the best MAA RAC servers and hardware configuring the raw devices for Oracle RAC.
• Installed and Monitored Oracle 11g/10 g RAC software and experienced on Performance Tuning on RAC.
• Implemented advanced features of Oracle 11g/10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
• Experience in Performance tuning, Application tuning and Query Optimization using Oracle supported tools such as EXPLAIN PLAN, TKPROF, AUTOTRACE, etc.
• Expertise in creating primary database storage structures (Table spaces) and primary objects (Tables, Views and Indexes).
• Hands on experience with tools like SQL*Plus, Export and Import Utilities along with Oracle Enterprise Manager (OEM), and TOAD.
• Hands on Experience in Space Management, Capacity Planning.
• Creating Users, Roles and Profiles, Privilege management with role - based security.
• Backup of database Logical and Physical (hot and cold) using Backup script procedures and also using RMAN.
• Experience in Auditing and Capacity Planning, Configuring & Managing Hot Standby Databases (Data Guard).
• Handling Tools such as Toad, SSH, SQL Navigator, and OEM.
• Ability to work under extremely tight deadlines and can maintain focus on objectives and processes and troubleshooting, implementation and development skills.
• 24x7 production database support.
• Keep abreast of current and emerging technologies to maintain skills levels necessary to provide quality service to customers.
• Proficient in documenting the processes.
• Good communication and Interpersonal skills.
• Commitment to team work concepts.
• Effectively handle multiple tasks simultaneously and have ability to acquire and apply knowledge rapidly.
• Co-ordination with Confidential for technical support, new products and releases, technical discussion/support.

TECHNICAL SKILLS:

Operating Systems: Linux, UNIX, Sun Solaris, AIX 4.2, HP-UX 11i.

Hardware Platform: Windows, HP-UNIX server, RHEL-AS 2.1.

Languages: SQL, PL/SQL, C, Bash & Korn Scripting, PERL Scripting.

Tools: /Utilities: SQL, Import/Export, Import/Export data-pump, RMAN, SQL*LOADER, AWR, TOAD,SQL*PLUS, Oracle Enterprise Manager, DBCA, OUI, Working Knowledge of Data Guard.

DBMS Tech: Oracle 9i, 10g, 11gRAC and 12c.

PROFESSIONAL EXPERIENCE:

Confidential, NH

Database Administrator

Responsibilities:

• Upgrading Oracle Golden gate 11.2.1.0.1 to 12.1.2.1.10
• Installing Oracle Golden Gate for Oracle and Mssql Databases
• Oracle and SQL server Database Capture using Oracle Golden Gate 12c
• Data Extract, Conversion and Load using Golden Gate
• Configuring Extract Parameters for Golden Gate EXTORA, RMTHOST, RMTTRAIL
• Configuring Replicate Parameters ASSUMETARGETDEF, REPOR, DISCARDFILE
• Creating GLOBALS for Golden Gate and Adding database checking points.
• Migrated data on different Oracle versions of 9i and 10g, 11g and on different operating systems of AIX/Sun Solaris/Linux.
• Migrated data from File System/Non - ASM to ASM storage.
• Migrated data from ASM disks to ASM disks by using Rebalancing techniques.
• Created an RMAN catalog databases and wrote an RMAN backup script for backing up more than 5
• Production databases and few development databases.
• Recovered data files from block corruption using RMAN.
• Reduced production outages by implementing best practices of patch management, purge/archival, code
• Optimization and applied rolling patches such as PSU and CPU on RAC after testing on DEV, QA and Staging.
• Taking backup of databases using RMAN.
• Used tools like export/import and datapump export/import.
• Involved in export and import of database objects in order to copy them from one database to another &for backup the tables.
• Created a physical standby for Disaster Recovery (DATA GUARD).
• Experienced writing UNIX scripts and troubleshooting issues.
• Upgraded Real Application Cluster (RAC) from Oracle 9i to Oracle 10g on HP-UX.
• Used tools like TOAD, SSH.
• Involved in Database Tuning for the performance of databases.
• Automated Database refresh from the Host system to Oracle using, SQL and PL*SQL procedures.
• Responsible for SQL query tuning and optimization. Performed database tuning and optimization using tools such as TKProf, STATSPACK, Explain plan and SQL*Trace.
• Responsible for all database activities such as User management, space management, database security management, rollback segments & creation of DB links between two oracle servers.

Environment: Oracle 9i/10g/11g, Oracle RAC/ASM on AIX/Sun Solaris/Linux/WIN, Oracle Golden Gate 11g (11.2.1.0 and 11.1.1.), Toad, SSH, RMAN, SQL*Plus, SQL, Import/Export.

Confidential

Sr. Oracle Database Administrator.

Job Duties/ Responsibilities:

• Implemented 100TB of Backup system for Exadata databases machine
• Upgrade Grid Control from 11g to 12c
• Migrate 11g to 12c Database, Upgrade 11,2 Rac to 12c RAC -- Configure Containers, Implement Audit Vault and new database security features
• Upgrade Grid Control from 11g to 12c
• Migrate 11g to 12c Database, Upgrade 11,2 RAC to 12c RAC -- Configure Containers, Implement Audit Vault and new database security features
• Patched 11g Grid Infrastructure & RAC databases on Exadata Database Machines.
• Patched Oracle Exadata Machine 11g R2 Grid Infrastructure and RAC databases. Involved in Exadata switch patching and cell storage.
• Configured Oracle Grid monitoring system for Exadata database machine & Exalogic on separate network.
• Implemented Oracle Virtual Machine virtualization 2 node cluster on HP Blade G470c servers for different needs.
• Implemented Database Listeners on infiniband network from Exadata Machine to Exalogic Machine.
• Worked on Scan listeners for 11g grid infrastructure.
• Administering Cell Storage servers for Exadata Database Machines.
• Extensively Administered Oracle Apps r12, 11.5.10 e-business applications on RAC.
• Upgraded Oracle APPLICATION 11.5.9 to 11.5.10.
• Patched, Cloned and administered Oracle Apps 11i with ad utilities (ADADMIN, ADPATCH, ADCTRL, and ADMERGE).
• Solved issues related to Concurrent Manager on oracle apps 11i.
• Provided installation, configuration support of Oracle RAC9i, 10g, 11g RAC databases from building server to installing databases.
• Involved in upgrading Oracle9i to Oracle10g database
• Configure workflow notifications, printers, and form servlets in Oracle financial applications.
• Involved heavily in different kind of cloning requirements. Restoring databases in same cluster system and different cluster system to other database.
• Worked extensively on HP data protector and managed system wide backups. Configured backup polices for oracle databases and system wide backups.
• Involved in patching 10g ASM instances and CPU patching for RAC instances and single instances.
• Performed 10.2.0.3 Oracle RAC Cluster ware upgrade to 10.2.0.4. Upgraded 10.2.0.2. databases to 10.2.0.4

Environment: SQL Developer, TOAD, Spot Light, VMS Server

Confidential

Oracle DBA

Responsibilities:

• Administering 24x7 RealApplication Cluster (RAC) databases running on Cluster File system. Worked with senior DBA’s for preparing cluster, configuring and Installation of Clusterware and Oracle RAC on Linux. Startup and Shutdown of Individual instances on RAC database using Enterprise Manager.
• Experienced in working and monitoring the databases by using Oracle Enterprise Manager (OEM).
• Supporting both production and development activities.
• Creating of databases for Testing, Development and Production.
• Performance tuning for optimized results using tools like Explain Plan, SQL*Trace and TKPROF, STATSPACK.
• Setup of Standby database for faster disaster recovery and Data Guard setup for high availability.
• Written PERL and UNIX shell scripts for digitization the process.
• Load balancing, databases/schema/table re-organization for faster performance.
• Performing Capacity planning and evaluations with regular Maintenance cycles.
• Installation of Oracle version 10g on Linux.
• Applying patches whenever required.
• Migration of Database from 9.2.0.6 and to 10.2.0.2 using DBCA and Performed Validation tests.
• Upgraded from SQL SERVER 2000 to SQL SERVER 2005.
• Created and scheduled the packages using SQL serverDTS packages.
• Extensively used SQL serverBCP utility and IMPORT/EXPORT to load the database from text files received from different applications Continuous Performance Monitoring and Tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack, STATSPACK etc.
• Monitoring and Troubleshooting of Database Replication issues using Shareplex Tool.
• Maintenance of Oracle Database. Rebuilding of Indexes, creating and managing Tablespaces and allocation tables to different Tablespaces.
• Performance Tuning of Oracle Database Objects.
• Taking periodic Backup of the database and the software using RMAN.
• Handling Database storage, Reading Alert. Log and User trace Files and Diagnosing the Problem, Scheduling jobs through Oracle job Scheduler.
• SQL Tuning for Performance of Objects.
• Automation of Startup Shutdown on all Production and Development Database.
• Scripts for Startup and Shutdown, for Health Check of Databases and for Analyzing of Tables and Rebuilding of Indexes, Scripts for Cold Backups, Script to check Oracle errors in alert log file and Send Mails.

Environment: Oracle 10g, SQL SERVER, Oracle RAC on Linux, Toad, RMAN, SQL*Plus, SQL, PL/SQL, SQL*LOADER, Oracle OEM, Import/Export.

Confidential

Jr. Database Administrator.

Responsibilities:

• Migrated Database from 9.2.0.1 to 10.1.0 on HP-UX.
• Administered all database installation, creation, modification, and tuning issues of Oracle.
• Configured database using features of Oracle 9i like Undo-Tablespace, Locally Managed Tablespace, Sorting Parameters
• Analyzed the database so as to allow Oracle optimizer to choose best plan in executing the queries
• Run oracle stats pack to tune the databases.
• Wrote SQL scripts for DB monitoring, and online backups.
• Experienced in Installing VERITAS HA Clusterware to eliminate downtime, increase productivity and performance.
• Experience in Installing, Configuring and Maintaining Oracle9i Real Application Cluster Database for High Availability, Scalability and Performance which includes: Determining the Cluster architecture choosing the best MPP RAC servers and hardware configuring the raw disks for Oracle RAC. Installed Oracle9i RAC software on HP 11i PA RISC based servers.
• Implemented Oracle Replication to enable database fail over in case of system or database crash.
• Checking of Alert log and Trace files to monitor the database on a daily basis. Also wrote monitoring scripts to check reports for space, Max. Extents, coalescing etc. which are kept in CRONJOB
• Also worked for network management.
• Creating users granting the permissions and coping with the day-to-day demands and troubleshooting their connectivity, permissions and performance problems.
• Worked with users to determine system requirements.
• Database activities include allocation and maintenance of Rollback Segments, Automatic Undo Management, table spaces, data files, redo log files, mirroring of redo log files across multiple disks.
• Experienced in using utilities like Export/Import and SQL Loader.
• Developed PL/SQL packages, procedures, functions and triggers to support application.
• Provided 24*7 System support.

Environment: Oracle 9i/10g, HP UX, OEM, SQL*Loader, PL/SQL, SQL, TOAD, SQL*PLUS.