SUMMARY

• Oracle 10g Certified professional with Nine Plus years of Oracle Database Administrator experience in Database Design, Administration, Installation, Upgrade & Migration, RMAN backup and Recovery, Partition, Patching, Performance Tuning, Database Security, Development and Production support in Oracle 8i/9i/10g/11g/12c Database.
• Experience in High Availability, Disaster Recovery feature, RAC, Data Guard, ASM, FLASH BACK, Oracle Streams, Oracle GodenGate, and Oracle Exadata.
• Hands - on experiences in RMAN backup and recovery, DATAPUMP and export/import Utilities.
• Hands-on experience on oracle Exadata full-rack and quater-rack Machine.
• Experience in Oracle GodenGate Bi-directional configuration and administration.
• Extensive experience in DB Performance tuning and Application SQL tuning using AWR, ADDM, ASH, STATSPACK, DBMS SPM, SQLT, Explain Plan, DBMS SQLTUNE, TKPROF Utility.
• Hands-on experience in monitoring tools Oracle Enterprise Manager (OEM), TOAD, and DBArtisan.
• Experience in high availability OLTP, Data warehouse (OLAP), DSS Environment.
• Hands-on experience in Capacity Planning, Space Management and disaster recovery strategies.
• Experience in SQL, PL\SQL, T-SQL programming Language.
• Hands-on Experience in UNIX shell scripting, CRON, FTP, SFTP, Telnet, SSH, SCP.
• Experience in Data Modeling of SDLC phase as well as reverse engineering using tools Oracle Designer, Erwin, and ER/Studio.
• Experience in Designing, Developing, Documenting and Testing of ETL jobs and Mappings in Server Jobs in IBM DataStage to populate tables in Data warehouse environment.
• Experience in high data extraction, transformation, loading (ETL) using SQL Loader, oracle supplied Utility DBMS packages.
• Experience in managing database security through grants, roles, privileges, and profile.
• Hands-on experience in advanced security using Database trigger, Oracle Wallets, Auditing, Tablespace Encryption, SSL/TLS 1.2, TDE.
• Experience in writing PL/SQL scripts for the database objects like tables, views, procedures, functions, packages, database triggers, indexes and sequences.
• Hands-on experience in reporting tool crystal report 8.5.
• Experience in Change management software HPSM for Incident/change management.
• Able to provide On-call 24X 7 production supports. Willingness to work beyond regular hours.
• A Team player with excellent analytical, debugging, problem solving, technical documentation and communication skills.

TECHNICAL SKILLS

Databases: Oracle 12c,11g, 10g, 9i, 8i,MS SQL Server 2000/2005/2008, DB2 9.1, 9.5, MySQL

Languages: SQL, PL\SQL, C, C++, Basic, Pascal, PHP,XML

Scripting: UNIX Shell script (Korn, Bourne, Bash), Perl

DB utilities: Export/import, DATAPUMP,SQL*Loader, RMAN,AWR, STATSPACK, OPatch, DMU, SRVCTL, CRSCTL,ASMCMD, DBCA, ADRCI, DBUA,TKPROF, Explain Plan, OPatch, ORAPWD, Oracle Warehouse Builder, Crontab

Tools: Oracle Enterprise Manager 11G/12c, TOAD, DBArtisan, SQL*PLUS, iSQL*Plus, Crystal Report 8.5/10, Oracle Pro*C, Erwin 3.5/4.0, ER Studio, SQL Developer 1.2

Operating System: IBM AIX 4.3, 5.3,6.1, 7.1, HP-UX 10i, 11i, Red Hat Linux 4,5,6,7, SUN Solaris 8, 9, 10, 5.8, 5.9, Linux, Windows 2000/2003/XP/NT

PROFESSIONAL EXPERIENCE

Confidential, Woonsocket RI

Oracle DBA

Responsibilities:

• Installed and configured 5 node,3 node and 2 node oracle 11.2.0.3, 12.2.0.1 RAC cluster with ASM on IBM AIX 7.1, RHEL 7 for OLTP PT and Production environment.
• Installed and Configured oracle 11g,12c GI standalone (Oracle Restart) databases, RACOne node databases on RHEL7, AIX 6,7 for dev, uat and production environment.
• Upgraded and downgraded databases from 10.2.0.4, 10.2.0.5, 11.2.0.3 to 11.2.0.4, 12.1.0.2 on AIX and Linux.
• Migrated database using Data Guard Switchover method.
• Cloned GI and RDBMS home to create multiple RAC cluster.
• Applied 11.2.0.4 PSU6,PSU7,PSU9, 12.2.0.1 July/Oct2018 RU on for RAC Cluster and Oracle Restart using opatchauto and manual napply method..
• Configured 12c physical standby in maximum performance mode using Oracle Data Guard.
• Implemented Bi-directional replication (Active-Active configuration) using Oracle GoldenGate for tier-1 OLTP.
• Implemented HA solution for GoldenGate instance using Grid Infra. bundled agent (XAG).
• Applied GoldenGate bundle patches for integrated extract and replicates.
• Installed and configured oracle GodenGate servers and Veridata servers.
• Deployed GodenGate Monitoring Agent and Veridata Agent.
• Debugged GodenGate performance issue, Data issues, Extract/pump/replicate Abend issues.
• Migrated ~60TB data for Data warehouse applications from Legacy system to Exadata full-rack machine using DATAPUMP.
• Applied bug fix patches on Exadata machine during data migration.
• Created change request and incident for database modification and resolved day to day incident ticket using change management software HPSM.
• Configured Oracle ACFS on RAC cluster for non-database files.
• Supported Application minor and major release upgrade by creating database objects tables, indexes, sequences, constraints, views, synonyms.
• Performed database Restore and recovery as part of Disaster Recovery exercise.
• Restored/cloned UAT/Dev environment from Production cold backup gold image using RMAN.
• Installed 11GR1 OEM Agent on AIX using silent method and deployed 13c OEM agent from OEM 13c.
• Configured SSL/TLSv1.2 on Oracle RAC and standalone databases.
• Performed SQL tuning and created SQL Baseline using DBMS SPM package.
• Provided plan stability using SQL Baseline during major database upgrade.
• Installed SQLT and created SQL Profile to fix poor execution plan for existing SQL and New released SQL.
• Created SQL Profile (CoE) and migrated SQL profiles between two site using DBMS SQLTUNE.
• Configured Oracle Streams between source and target database using downstream capture.
• Performed character set conversion in dev, UAT and production databases using DMU Utility.

Environment: Oracle 10G,11G,12c, RAC, RACOne, IBM AIX 6.1, 7.1, Red Hat Linux 5.7,6.8,7.1, Tivoli, RMAN, TDP, SQL*Loader, DATAPUMP, DMU, Flashback, Oracle GodenGate, DataGuard, Stream, TOAD, OEM12c, 13c,HPSM

Confidential, Bloomington IL

Oracle DBA

Responsibilities:

• Installed, configured and maintained 11.2.0.2, 11.2.0.3 databases.
• Migrated 400+ oracle database from HP-UX to Red Hat Linux under Linux Migration Project.
• Upgraded oracle RDBMS from 10.2.0.3, 10.2.0.4, 11.1.0.6 to 11.2.0.3 on HP-UX and Red Hat Linux platform.
• Installed and configured 2 node 11GR2 RAC with ASM on Red Hat Linux 5.7
• Configured & Supported Red Hat Active/Passive Clustering for Mission critical application.
• Utilized ETL tool SQL*Loader to load data from DB2 Export files into oracle database
• Written Unix Shell scripts and setup Crontab to automate routine DBA tasks of taking backups, exports, monitoring space availability and database performance
• Created cloned databases from Production into Simprod and Development environments on demand from project teams.
• Extensively used DATAPUMP Export/Import utility to accomplish database migration and upgradation.
• Provided disaster recovery by configuring and maintaining Physical Standby database.
• Migrated mission critical databases using Data Guard Failover method with minimal outage.
• Installed and configured OEM 11GR1 Grid control on Red Hat Linux server.
• Applied patches using OPatch utility.
• Installed 11GR2 OEM agent on HP-UX and Linux platform.
• Created users and involved in database security by granting roles, privileges, and profile to users.
• Created database object like tables, indexes, views, synonyms, sequences.
• Developed and scheduled RMAN backup scripts to maintain standard backup strategy for oracle databases.
• Performed point-in time recovery for RAC databases and single-instance databases.
• Upgraded RMAN Catalog database from 10g to 11g.
• Involved in SQL tuning using Explain Plan, TKPROF with SQL Trace and SQL tuning Advisor.
• Extensively used AWR, ADDM, ASH reports for Database performance tuning.
• Hands-on experience on HP Service Manager for Incident/change management within whole infrastructure.
• Supported more than 15+ vendor applications. Some of the most notable are FileNet, Service manager, Control M, BenXL, PrimaVera, BAC, BSM, Optier, UCMDB, openview, DLP.
• Managed Primary and secondary on-call rotation to provide 24x7 production support.

Environment: Oracle10g, 11g, RAC, Red Hat Active/Passive cluster, ASM, SQL Server 2008, UNIX, Red Hat Linux 5.7, HP-UX 11i, OEM grid 11GR1,DBArtisan,RMAN,SAN, SQL*Loader, HP Service Manager.

Confidential, Providence, RI

Oracle DBA

Responsibilities:

• Actively involved in database performance monitoring and maintenance of oracle 9i/10g/11g databases.
• Day to day monitoring activities like availability of system, listener, database, alter log file, trace file.
• Installed and configured oracle 10g, 11g database in Dev/Test/Prod environment.
• Partitioned online production table with DBMS REDEFINATION package.
• Upgraded oracle RDBMS from 9.2.0.7 to 10.2.0.3 and 10.2.0.1 to 11.1.0.6 on Sun Solaris 10 Platform
• Used 11g DATAPUMP COMPRESSION parameter to compress the dump file during logical backup of database
• Developed PL\SQL stored procedure, function, package, triggers, cursors, and views
• Applied critical patch unit (CPU) Patch using OPatch utility.
• Back out the selected transactions using oracle 11g OEM Dependent Transaction viewing feature.
• Performed SQL query tuning (Optimization) using Explain Plan, TKPROF, and STATSPACK report.
• Troubleshoot database performance (instance) tuning using ASH, ADDM, AWR, and STATSPACK
• Created database objects like tables, indexes, views, synonyms, sequences, and triggers.
• Recovered block corruption in data file using 11g RMAN Data Recovery Advisor
• Performed, developed and maintained database backup and recovery using RMAN for various failures.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Agent, and SQL Server integration service.
• Developed physical data model from logical data model using ERWIN.
• Replicated high volume of transactional data between heterogeneous databases using Oracle Stream.
• Refreshed Test and development database environment from Production database.
• Actively involved in database security by granting roles, privileges, profile to users
• Extensively used Export/Import and DATA PUMP utility to migrate databases.
• Performing high performance data extraction, transformation, loading (ETL) using SQL Loader.
• Designed and generated reports from wide range of data source using Crystal Report 8.5.

Environment: Oracle 9i, 10g, 11g, 10GRAC, ASM, SQL Server 2005, UNIX, Sun Solaris 10, HP-UX 11 (64 bit), IBM AIX 4.0, RHEL 5.0, OEM, Erwin, RMAN, SAN, Crystal report 8.5, SQL*Loader, TOAD.

Confidential, Bismarck, ND

Oracle DBA

Responsibilities:

• Designed, installed and configured oracle 9i/10g databases on UNIX platform.
• Managed 100+ database instances with database size ranging 10GB to 2TB.
• Created physical data model from logical data model for oracle application database using ERWIN.
• Created users and privilege Management using roles and grants.
• Developed UNIX Shell scripts to automate database operation and database monitoring.
• Upgraded oracle 9.2.0.8 to 10.2.0.3 using DBUA.
• Used Export/Import to do table level and full database de-fragmentation.
• Created Physical and logical data model for student schema using Case tool ERWIN.
• Created Partitioned tables using Range, hash, list partitioning to improve performance.
• Created database objects, tables, indexes, sequences, constraints, views, synonyms.
• Developed backup and recovery policy using RMAN.
• Installed and configured oracle 10g RAC with ASM storage on RHEL 5.
• Migrated database character set using CSSCAN and CSALTER utility.
• Created UNIX shell script, RMAN script, schedule job using DBMS JOB, Crontab for daily monitoring and maintenance of database health.
• Created and configured physical standby database for production database
• Involved in database tuning issues using AWR, STATSPCK report
• Performed logical backup of database, tablespace, and table level using exp/imp and DATA PUMP.
• Utilized ETL tool SQL*Loader to load historical data from flat files into Data warehouse database.
• Worked on performance tuning, reporting, SQL query tuning, Query optimization, performance monitoring, resource usage and profiles.
• Analyzed database object tables, indexes to get statistics.
• Maintained the data integrity and Database security using integrity constraints and database triggers, Auditing.
• Worked on database cloning to make Production instance available for Test and Development.
• Created stored program units in the form of packages, functions, triggers, and procedures for implementing the database intensive business rules.

Environment: Oracle 9i, 10g, OEM, RMAN, TOAD, SUN Solaris 9, MY SQL, SQL Server, HP-UX, SQL*Plus, IBM AIX 4.3, SQL*Loader, ERWIN.