SUMMARY

• Oracle DBA with around 7 Years IT experience in Oracle products, both production and development environments
• Excellent interpersonal and strong analytical, problem - solving attitude.
• 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 with Oracle 19c,18c, 12c, 11g RAC/10g 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 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 CPU and PSU patches. Experience in upgrading database from 12c to 18c to 19c.
• Experience in working with 18c databases.
• Experience in database and cluster patching.
• Expertise in writing SQL from Oracle Dictionaries, tables, and views.
• Performed Data Center Migration.
• Experience in Tablespace and User management.
• Experience in managing database via 13c OEM.
• Experience in managing database from TOAD.
• 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.
• Built EC2 instances on AWS Cloud.
• Extensive work on shell scripting and documentation.
• Excellent Experience as Production DBA with 24X7 supports.
• Extensive experience in backup and restores using RMAN
• Managed databases on Exadata and GoldenGate.
• 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
• Installed and managed Oracle GoldenGate.
• Hands on Experience in Performance tuning and optimization of SQLs.
• Analyzed database performance using ASH, AWR and ADDM reports.
• Managed databases upto Exadata X-7
• 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

PROFESSIONAL EXPERIENCE

Confidential | Austin, TX

Oracle DBA

Responsibilities:

• 24x7 production support for several mission critical systems which utilize multiple Oracle databases.
• Installation of Oracle 11g RAC Databases includes CRS and Applying Patches.
• Upgrading databases to Oracle 12c from11g.
• Build and Managed Data Guard
• Created users and roles. Applied CPU and PSU patches. Experience in upgrading database from 12c to 18c to 19c.
• Experience in working with 18c databases.
• Experience in database and cluster patching.
• Expertise in writing SQL from Oracle Dictionaries, tables, and views.
• Performed Data Center Migration.
• Experience in Tablespace and User management.
• Experience in managing database via 13c OEM.
• Experience in managing database from TOAD.
• 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.
• Built EC2 instances on AWS Cloud.
• Extensive work on shell scripting and documentation.
• Excellent Experience as Production DBA with 24X7 supports.
• Extensive experience in backup and restores using RMAN
• Managed databases on Exadata and GoldenGate
• Used shell scripting for automation of job.
• 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
• Set up, configuration and maintenance of Standby Databases for disaster recovery, high availability and data protection.
• 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.
• Setup backup and recovery procedures using RMAN.
• Migrated from non-ASM instance to ASM instance.
• 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.
• Written SQL, PL/SQL programs such as functions, procedures, packages and triggers.

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.