SUMMARY

• Having 8+ years of experience in IT industry as Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, performance tuning, backup and recovery, cloning, space management and database security on various platforms LINUX, AIX, UNIX, and SUN SOLARIS. Experience in Gloden gate; practicality of Data Guard, noledge of SQL Server databases.
• Excellent experience in production support, installation, configuration, upgrades.
• 24*7 production database support wif Support to developers & end - users.
• Extensive noledge on database administration of Oracle 9i, 10g, 11g, 12c, 18c and 19c wif experience on very large-scale databases ( ) environment.
• Expertise in Installation, maintenance and tuning of RAC Applications.
• Implemented Data guard (Physical Standby) for RAC databases.
• Proficiency in standby database (Data guard) installation, configuration, maintenance, and administration for disaster recovery.
• Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 12c, 11gR2 Grid and 10g on ASM, ACFS and OCSF2 file systems including teh engineered systems ODA and Exadata
• Created and administeredphysical standbyusing data guard set upSnapshotstandby using dg broker.
• Experience in Capacity Planning and Bench Marking.
• Perform root cause analysis on failures. Resolve performance tuning related issues and queries.
• Experience in Database Performance Tuning.
• Troubleshooting of Performance and Tuning problems in Oracle database using tools like AWR, OEM Grid Control and manual scripts.
• Migrations, patches, performance tuning, backup and recovery, cloning.
• Experience on database Migration using Transportable Tablespace on cross Platform.
• Experience in development, testing and implementation of Backup and Recovery Strategy Using RMAN, Data pump and Export/Import utilities.
• Knowledge in Red Hat Linux system administration.
• Extensive experience in database cross-platform migration and integration
• Extensive noledge of Oracle OEM 13c and 12c Architecture, Framework, and Infrastructure.
• Experience on Gloden Gate Uni-Directional and Bi-directional Replication.
• Expertise in Oracle Gloden Gate installation, configuration.
• Hands on experience in implementing gloden gate classic and integrated capture and integrated replicate process.
• Hands on experience in Installing, Migrating, Upgrading and Maintaining different oracle versions on UNIX, Linux and windows Platforms.
• Upgraded 19c and 18c grid infrastructure from 12c database version.
• Multitenant: Manage Tablespace in Container Databases (CDB) and Pluggable Databases (PDB) in Oracle Database 12c and 18c.
• Manage users and Privileges for container databases (CDB) and pluggable databases (PDB) in Oracle Database.
• Experience in fulfillingDBA daily activities, includingschema management,user management(creating users, synonyms, privileges, roles, quotas, tables, indexes, and sequence),space management,monitoring,scheduling jobs.
• Performed Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate wif Oracle support for bugs & issues resolutions and personal research.
• Managing Users, roles and privileges, space management Creating storage structures, Performance tuning.
• Expertise in Client-Server application development using Oracle 11g/10g, PL/SQL, SQL *PLUS, TOAD and SQL LOADER.
• Pleasant experience in SQL, PL/SQL, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Strong interpersonal skills, ability to interact wif people at all levels. Effective communication and presentation skills.
• Good Interpersonal communication skills and Documentation Skills.
• Extensive experience in writing and tuning complex sub queries, SQL, PL/SQL stored procedures, functions, and triggers.
• Excellentverbalandwrittencommunication skills. Willingness tolearn modern technologies, openness to innovative ideas and ability to learn very quickly.
• Good coordination and communication wif system administrators, business data analysts and development teams.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.

TECHNICAL SKILLS

Operating systems: Unix, AIX 4.3, AIX 5.3, Red Hat Linux RHEL 3, RHEL 4, RHEL5, Ubuntu, Solaris10,9,8, HP-UX. Windows

Database Skills: Oracle 19c, Oracle 18c pluggable and container databases,13c,12c, Oracle 10g/11gR2, Oracle 11g/10g, Oracle 11g/10g RAC, EXADATA.

Tools: Oracle Enterprise Manager (OEM),TOAD, SQL developer, RMAN, Data pump, Gloden Gate, Password Vault, Toad, SQL- Navigator.

Performance Tuning: Grid Control, AWR, ADDM, SQL performance analyser, Toad.

Oracle Utility: Export/Import, Data Pump, SQL*Loader, RMAN, 12C and 13C OEM.

Database Advance Feature: RAC, Data Guard, Standby Database, Oracle Gloden Gate, Grid Control, database Migration using Transportable table spaces

PROFESSIONAL EXPERIENCE

Confidential - Minneapolis, Minnesota

Oracle Database Consultant

Responsibilities:

• Experienced working on different database versions like Oracle 9i, 10g, 11g and 12c, 18c &19c databases.
• Provided production support for teh 24x7 Oracle database availability.
• Multitenant: Mange Tablespace in a container database (CDB) and pluggable database (PDB) in oracle Database 18c.
• Manage User and privileges for container database (CDB) and pluggable Databases.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Created database links to retrieve data from multiple servers.
• Working on Exadata X2, X3 and X6 machines which included Half Rack and Full Rack.
• Upgraded 19c and 18c grid infrastructure from 12c database version.
• Migrated 12c databases from 11g database by using Transportable Tablespace on cross Platform.
• Provide guidance and develop Disaster Recovery strategies for teh Exadata Database machine.
• Provide and implement performance tuning recommendations of all components in Exadata database machine.
• Installation, Configuration, Upgrade, patching of Oracle RDBMS and applications Work on different versions of Databases wif OEM Grid control to maintain teh database effectively.
• Worked extensively on 10G, 12C and 13C OEM and configured DB alerts for DBA.
• Worked wif database export &import, import scripts to backup database structures and automation procedures.
• Participate in teh design, development, testing, implementation, and maintenance of database structures
• Upgraded 10.2.0.4 Two Node RAC ASM Database to 11g R2 Two Node RAC ASM.
• Managed data warehouse projects improvement and growths.
• Monitor databases for resource utilization, providing trend analysis and forecasting of resource requirements.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, AWR and ADDM reports.
• Monitored CPU usage, I/O contention, memory paging and identified teh resource and performance bottleneck.
• Tuning which involved I/O, Memory, CPU utilization, SQL Tuning, SGA Tuning, Shared Pool Tuning, Buffers and Disk I/O tuning.
• Implemented and maintained Oracle 10g/11g Data Guard/standby databases for fail-over purposes.
• Implementing and maintaining database security (create and maintain users, roles and assign privileges).
• Extensively used Materialized views and DB links for remote instances to retrieve data from other databases.
• Used Oracle defined packages DBMS JOB, DBMS SCHEDULER for job scheduling.
• Created database objects and managed teh permission access on teh objects wif necessary security.
• Develop shell, PL/SQL, and SQL scripts to implement automation of ongoing administration and maintenance tasks.
• Reorganizing teh database objects by archiving teh data, moving teh tables wifin teh table space, and rebuilding teh indexes.
• Involved inmonitoring teh lock/block processes, releasing locksin case of resource blockage, and gathering statistics.
• Review alert logs and dump files to check for any problems related to teh database.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Refreshed non-production environment wif production using data pump.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Database Cloning/Exp/Imp to setup identical databases in teh production and development environments.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, AWR and ADDM reports.
• Review alert logs and dump files to check for any problems related to teh database.
• Develop shell, PL/SQL and SQL scripts to implement automation of ongoing administration and maintenance tasks.

Environment: ORACLE, SQL*Plus, PL/SQL, Oracle 9i/10g/11g/12c,18c &19c Gloden Gate, Red Hat Linux, SQL developer, UNIX, Sun Solaris, Oracle Enterprise Manager, Data guard, ASM, RMAN, Toad, SQL*LOADER,10g,12c and 13c OEM, Exadata.

Confidential - Dallas, Texas

Oracle Database Consultant

Responsibilities:

• Experienced working on different database versions like Oracle 10g, 11g and 12c databases.
• Provided production support for teh 24x7 Oracle database availability.
• Responsible for managing production, development & test databases, and applications.
• Developed some Unix Shell scripts to automate database operation and database monitoring.
• Involve in code test and migration on all teh environments. Handle requests from application team and resolve issues reported. Set up rules in OEM to monitor space for all teh environments and schedule scripts through OEM and crontabs.
• Simulated copy of production databases into test databases for teh application and upgrade testing.
• Built 4 node RAC 11gr2 Standby databases and set up DG Broker.
• Managed multi nodes Real Application Cluster databases on Red hat Linux advanced server 2.1.
• Involved in Design and implementation of oracle 11g Data Guard both physical/logical Standby databases for high availability and disaster recovery.
• Implemented several designs of Gloden gate which include Uni-directional, bidirectional, DDL, Schema level, Table level and handled teh project from gathering teh requirements to designing, implementing teh replication, and setting up teh monitoring.
• Installed and configured teh Oracle Gloden gate and involved in troubleshooting Glodengate issues.
• Setup gloden gate Uni-directional and bi-directional replication between 2 data centers.
• Good at managing and monitoring grants, roles, privileges to users, analyze tables to generate and gather stats including verify daily alert logs.
• Refreshed non-production environment wif production using data pump.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Database cloning/exp/imp to setup identical databases in teh production and development environments.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, AWR and ADDM reports.
• Review alert logs and dump files to check for any problems related to teh database.
• Develop shell, PL/SQL, and SQL scripts to implement automation of ongoing administration and maintenance tasks.
• Created encrypted passwords in UNIX and Linux servers by using SQL crypt utilities.
• Handled all database schema passwords and import all passwords into password vault tool.
• User Account auditing by auditing default tablespace, temporary tablespace assigned, grants, privileges, roles, profile, database links created for remote database connection, grants wif admin option, password management.
• Developed and managed alert system to monitor database errors, broken jobs, invalid object status, space, and locks on objects.
• Creation of database objects like tables, views, materialized views, procedures, and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Created teh index for increasing teh performance of data conversion process.
• Tuning of PL/SQL Stored Procedures using HINTS in Explain Plan.
• Created new functions, triggers, packages, and SQL*Loader scripts, and modified existing codes, tables, views, and SQL*Loader scripts.
• Created database links to retrieve data from multiple servers.
• Extensively used Materialized views and DB links for remote instances to retrieve data from other databases.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Handled PL/SQL compile-time, run-time errors, debugging of Stored Procedures for business logic modification, and responding to system events through triggers.

Environment: ORACLE, SQL*Plus, OEM/12c, PL/SQL, PL/SQL Developer, Oracle12c, 11g/10g, Oracle 11g/10g,12c RAC, Shell scripting, Oracle Enterprise Manager, Data guard, RMAN, Gloden Gate, UNIX/LINUX, SOLARIS, Password Vault, Toad.

Confidential - Irving, TX

Oracle DBA

Responsibilities:

• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Worked as part of a team and provided 24/7 support when required.
• Involved in Database migration from Oracle10g to Oracle 11g.
• Managing users, roles & privileges, backup & recovery procedures using daily hot backups and weekly cold backups.
• Involved in Design and implementation of oracle 11g Data Guard both physical/logical Standby databases for high availability and disaster recovery.
• Create and manage documentation on teh configuration and support of teh Oracledatabases.
• Performed large batch jobs and tuning of SQL queries and database systems.
• Used EXPORT/IMPORT to do table level and full database defragmentation.
• Manage Schema Objects.
• Monitor Alert log Files and trace files.
• Involved in Installation and configuration of teh Oracle Gloden gate and involved in troubleshooting Gloden gate issues.
• Setup monitoring for teh gloden gate abends, lags.
• Administer database user accounts, create, modify, and deactivate user accounts; assign and monitor user access rights.
• Monitor teh user sessions and take appropriate action to kill teh inactive sessions.
• Evaluated new features and enhancements in later versions of Oracle (10g) for possible implementations like Data Pump (EXPDP/IMPDP), Transportable Table spaces, External Tables and Partitions.
• Creating users and database links, snap shots on production and development servers.
• Support migration and loading of data into oracle database using SQL*Loader.
• Identified and trouble shot everyday issues like locking, scripts execution, Data Audits etc.
• Loading teh data using SQL Loader.
• Created database objects like tables, indexes, synonyms, views etc. using SQL* Plus, usedSQL*Loadercontrol files to load data from external data sources into Oracle database.
• Tested teh loaded data and documented teh errors and reporting.
• Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning
• Performance monitoring, Alert Log monitoring and backup monitoring.
• Effectively made use of Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views & Query Re-Write
• Installed and configuredGrid Controlto monitor all databases centrally.
• Responsible for all database activities such as space management, database security management, rollback segments & creation of DB links between two oracle servers.

Environment: ORACLE, SQL*Plus, PL/SQL, Oracle 11g/10g, Gloden Gate, Red Hat Linux 5, UNIX, Oracle Enterprise Manager, Data guard, ASM, RMAN, Toad.

Confidential

Junior Oracle DBA

Responsibilities:

• Responsible for Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Handled teh Backup and Recovery using RMAN.
• Involved in Design and implementation of oracle 11g Data Guard both physical/logical Standby databases for high availability and disaster recovery.
• Maintained Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Implemented Monitoring Templates and Incident Rule notifications using OEM 11g for database alerting.
• Monitored teh user sessions and take appropriate action to kill teh inactive sessions.
• Created users and database links, snap shots on production and development servers.
• Created databases, tablespaces, tables, indexes, and other database objects.
• Performed Logical backup using and full/partial export/import and Data Pump.
• Effectively made use of Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views & Query Re-Write.
• Coordinated wif developers to design teh flow of operations to ensure proper synchronization between teh database and teh front end in both connected and disconnected modes.
• Created Indexes and Monitored Performance. Data loading using SQL Loader (from Text files to Database). Performed Daily Logical backups using exp.
• Managed users, roles & privileges, backup & recovery procedures using daily hot backups and weekly cold backups.
• Creation of database objects like tables, views, materialized views, procedures, and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Worked wif database export & import scripts to backup database structures and automation procedures.
• Planning and implementing Backup strategy for teh databases using RMAN & Scripting backups every two weeks on teh application database.
• Implementing and maintaining database security (create and maintain users, roles and assign privileges)
• Query optimization, PL/SQL Performance Tuning using Oracle Cost based Optimization techniques, Explain Plan, Trace, Hints, SQL and PL/SQL.
• Monitored teh Applications and database using OEM.
• Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) for Performance Tuning.
• Advanced Backup and Recovery using Oracle RMAN software; used offline/online for recovery in a production environment.
• Provide development and production support related to database.
• Design, development, testing, performance tuning, deployment, and support in Data warehouse system.
• Performance Tuning of Databases, Oracle instances, and Applications. Identified Performance Bottlenecks using AWR, and ADDM.