We provide IT Staff Augmentation Services!

Oracle Dba Resume

Austin, TX

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.

Hire Now