SUMMARY:

• An astute Oracle DBA with around 10 Years IT experience in Oracle products, both production and development environments
• Excellent interpersonal and strong analytical, problem - solving attitude.
• Administration of Oracle 10g, 11g, 12c and 18c RDBMS
• Installing, upgrading and maintaining Oracle RDBMS on UNIX, Linux platforms.
• A very good team player, self-motivated, dedicated in any work environment
• Hands on experience in administration of Production, Test and Development databases.
• Expertise in database administration, production support, installation, configuration, upgrades, patches, space management, database security, troubleshooting database design, UNIX shell scripting and documentation.
• Experience monitoring Oracle RDBMS availability
• Worked on standard and enterprise edition of the Oracle RDBMS.
• Oracle Real Application Cluster (RAC) for versions 11g/12c/18c
• Experience with Oracle 18c, 12c, 11g RAC Installation, Administration, Monitoring, Maintenance, Performance Tuning, Database Backup and Recovery.
• Experience in HP-UX, AIX, SUN SOLARIS, Linux and Windows environments.
• Excellent knowledge in Hot/Cold Backup, Recovery and Cloning of databases
• Build 18c, 12c RAC Clusters.
• Build Disaster Recovery sites using Oracle Data Guard.
• Installed and configured databases using silent install, OMF and via scripts.
• Has extensive knowledge in dynamic views and dictionary tables.
• Applied PSU, RU and bundle patches.
• Experience in taking HOT and COLD backup of the database and also the individual table spaces.
• Extensive experience in backup and restores using RMAN
• Implemented different backup policies for different servers using RMAN .
• Restored and recovered the databases in case of disk crash.
• Load data using SQL loader.
• Taken different type of backups on SQL Server.
• UNIX shell scripts for hot backups, SQL*Loader, export and import of database.
• Extensive experience in OS space and tablespace management.
• Worked on database security and Fine Grain Auditing.
• Extensive work on shell scripting and documentation.
• Excellent Experience as Production DBA with 24X7 supports.
• Managed databases on Exadata and GoldenGate.
• Configuration, troubleshooting GoldenGate issues
• Setup Uni-directional GoldenGate setup.
• Installed and managed Oracle GoldenGate.
• Managing, troubleshooting and resolving oracle database and application issues.
• Performed Explain Plan analysis for Query Optimization and SQL tuning.
• Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, AWR, TKPROF, Explain Plan, TOAD from Quest software (DB Tuning).
• Cloned databases using RMAN duplicate and used Data Pump for object level refreshes.
• Managed databases using Exadata.
• Experience in Migration of databases from standalone to RAC
• Excellent experience of data migration, data archiving and data access techniques
• Installed and applied patched to oracle database and application
• Hands on experience in Hot/Cold Backup, Recovery Cloning of databases using RMAN with TSM Backup.
• Experience in tuning Different components and identifying bottle necks
• Hands on Experience in Performance tuning and optimization of SQLs.
• Analyzed database performance using ASH, AWR and ADDM reports.
• Managed databases on Exadata. Strong experience in OEM (Oracle Enterprise Manager), Oracle Data Guard, SQL* Net, SQL * Loader and SQL*PLUS, STATSPACK, Explain Plan and TOAD .
• Experience with setting up and managing standby database using Data Guard
• Intensively used Automatic Workload Repository ( AWR ) & Automatic Database Diagnostic Monitoring ( ADDM ) reports for the health check of the databases
• Good knowledge of Flashback Technology, Flash recovery Area, Automatic Storage management (ASM)
• Tune queries using SQL Plan, SQL profiler, Baseline etc.
• Performed all aspects of database administration including installs, builds, upgrades, object sizing, object creation, backup/recovery, patches, monitoring, export/imports and SQL loader.
• Worked on SQL Server 2008 and 2012
• Worked extensively with ASM builds and disk group management.
• Experience in resource management like data files, online redo log files, control files, and allocating logical storage structures like tablespaces, segments and extents
• Implemented proactive monitoring scripts for production databases.
• Experience with installing and maintaining Oracle 13c Cloud Control
• Creating and Managing Users, Roles and Privileges with required security implementations
• Expert in encryption for databases using Wallet Manager
• Database replication using snapshot, materialized views and advance replication methods
• Flexible and excellent team player. Ready to work in any shift.
• Excellent troubleshooting skills and quick learner.
• Extensive coordination with offshore team.
• Provided on call support.

TECHNICAL SKILLS:

• 19c,18c, 12c, 11g and 10g Database Administration.
• Real Application Cluster (RAC)
• Data Guard (Standby Databases)
• Automatic Storage Manager (ASM)
• Linux, Solaris, AIX, Windows, Exadata,
• Duplicate databases, Cloning, RMAN restore/recover/point-in-time recovery
• Export Import / Data Pump
• Scripting
• Flashback
• Golden Gate
• Performance Tuning / SQL Tuning / Instance Tuning / ASH / AWR / ADDM / SQL Plan
• Documentation
• Patches
• Exadata
• Amazon Cloud (AWS)

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Oracle DBA

Responsibilities:

• Provided day to day operation support.
• Migrated databases to Exadata x7.
• Build 18c RAC
• Upgrading databases to Oracle 12c from11g,10g and 9i
• Build and Managed Data Guard on Exadata
• Created users and roles.
• Used shell scripting for automation of job.
• Migrating database from NON-ASM to ASM.
• Migrated databases to AWS
• Build new servers on AWS
• Worked on project to migrate databases to AWS instance set up oracle instances on AWS cloud Installing, upgrading and maintaining Oracle RDBMS on UNIX, Linux platforms.
• A very good team player, self-motivated, dedicated in any work environment
• Hands on experience in administration of Production, Test and Development databases.
• Expertise in database administration, production support, installation, configuration, upgrades, patches, space management, database security, troubleshooting database design, UNIX shell scripting and documentation.
• Experience monitoring Oracle RDBMS availability
• Worked on standard and enterprise edition of the Oracle RDBMS.
• Oracle Real Application Cluster (RAC) for versions 11g/12c/18c
• Experience with Oracle 18c, 12c, 11g RAC Installation, Administration, Monitoring, Maintenance, Performance Tuning, Database Backup and Recovery.
• Migrated databases from Unix to Linux
• Creating and managing the database objects such as tables, indexes and views.
• Manage users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).
• Installation of ASM into various storage parameters like SAN and NAS.
• Oracle Database capacity planning, space management, storage allocation
• Managed the flashback space and performed recovery of dropped tables and data using flashback recovery
• Resolved gaps in primary/standby configuration.
• Monitoring of tablespaces, indexes, memory and logfiles.
• Data Refresh in Test and Integration Databases using Transportable Table spaces.
• Worked on Data Replication using GoldenGate and Materialized views
• Worked on import/export, export data pump/import data pump and SQL- loader.
• Installed and Implemented Backup & Recovery procedures. Implemented Hot, Cold and Logical backup plans
• Managed databases on Exadata and GoldenGate.
• Configuration, troubleshooting GoldenGate issues
• Setup Uni-directional GoldenGate setup.
• Installed and managed Oracle GoldenGate
• Installation and configuration of Oracle 11R2 client and database
• Worked with Offshore team
• Worked with Materialize Views.
• Worked on many performance issues.
• Performed SQL and Instance Tuning. Installation, configuration and migration of Oracle Financials database warehouse to Oracle ASM.
• Extensive experience with RAID and ASM configuration.
• Administered ASM from command line and grid control
• Upgrade of ASM from Oracle 11.2.0.2 to Oracle 11.2.0.3
• Configuration of security settings for Oracle Financials involved reconfigurations of Oracle roles, users, creation of triggers, procedures, synonyms and table constraints.
• Responsible for the creation of the ASM Operation(s) Manual and Quick Reference
• Setup backup and recovery procedures using RMAN.
• Migrated from non-ASM instance to ASM instance.
• Strong experience in OEM (Oracle Enterprise Manager), Oracle Data Guard, SQL* Net, SQL * Loader and SQL*PLUS, STATSPACK, Explain Plan and TOAD .
• Experience with setting up and managing standby database using Data Guard
• Intensively used Automatic Workload Repository ( AWR ) & Automatic Database Diagnostic Monitoring ( ADDM ) reports for the health check of the databases
• Good knowledge of Flashback Technology, Flash recovery Area, Automatic Storage management (ASM)
• Tune queries using SQL Plan, SQL profiler, Baseline etc.
• Performed all aspects of database administration including installs, builds, upgrades, object sizing, object creation, backup/recovery, patches, monitoring, export/imports and SQL loader.
• Worked on SQL Server 2008 and 2012
• Experience with installing and maintaining Oracle 13c Cloud Control
• Configured Streams to capture propagate; apply changes in multiple databases.
• Performed Database and SQL tuning by using various Tools like Statspack, TKPROF, Explain plan, AWR and ADDR.

Confidential, Chicago, IL

Oracle DBA

Responsibilities:

• 24x7 Production database and applications support
• Installation and Configurations of Oracle 11g RAC and 11g RAC.
• Involved in Design and Implementation of Standby Databases (Data Guard)
• Build and managed Active Data Guard
• Extensive experience using Oracle ASM
• Worked with developers in supporting deployment and releases
• Installed, configured, and maintained Oracle 11g and 12c.
• Upgraded from Oracle 10g to 11g to 12c
• Managed databases using command line, 12c cloud control and TOAD
• Performed the migration from Tandem to Oracle 11g.
• Performed Database Refresh from Production to Development databases.
• . Used PL/SQL (stored Procedures, triggers, packages), SQL* PLUS, SQL* LOADER of oracle database.
• Supported different Databases like Testing, Staging and Training.
• Performed installation and configuration of Oracle 10g/11g RAC databases on Linux.
• Upgraded the Oracle 10g database to 11gR2 version and applied patch set and interim patches whenever required to make the database software up to date.
• Installed RAC on Oracle 10g and worked on ASM feature of Oracle.
• Worked closely with developers during release
• Good experience in Performance tuning of large databases.
• Data Guard administration and maintenance.
• Monitoring Day-to-Day Backups, Log's & recovering them as per the requirement. Utilized Log Miner Technology & applied Application Database Transactions on other Databases.
• Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups.
• Taking the RMAN incremental and cumulative backups.
• Scheduling the databases backup using crontab and VERITAS net backup.
• Perform Logical backup using full/partial export/import and data pump.
• Creating Logical and Physical database structure, Creating and altering Tablespaces. Managing Users and Resources, Granting and revoking privileges through Roles.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.
• Creation of Users and granting them the required Roles and Privileges accordingly.
• Involvement in space management, managed quotas.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
• Configuration of Listener and Net Service names using NETCA and NETMGR.
• Cloned schemas, objects and data on new server using Data pump.
• Managing databases on multiple servers.
• Worked extensively on monitoring 10G grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.