We provide IT Staff Augmentation Services!

Oracle Dba Resume

Chicago, IL

SUMMARY:

  • Over 8 years of experience of Oracle Database Administrator including 9i/10g/11g/12c databases.
  • Managed Databases on RHEL, OEL, CentOS, AIX, HPUX, Solaris and Windows.
  • Proficient in Administering 10g, 11g and 12c Oracle Instances.
  • Hands on experience in database administration and production support.
  • Extensive work in database installation, configuration and upgrades.
  • Proficient in Oracle quarterly patches.
  • Worked on tuning SQL and instance for faster response time.
  • Setup Disaster Recovery sites using Data Guard
  • Written shell scripting to automate procedures and jobs.
  • Excellent Experience as Production DBA with 24/7 supports.
  • Expertise in Developing Recovery Manager (RMAN) scripts for database backup
  • Build 2 - node and 4-node RAC clusters
  • Extensive expertise in export import and data pump.
  • Database Migration to Amazon Web Services (AWS).
  • Managed ASM instances
  • Upgrade databases
  • Worked on Data Center Migration.
  • Expertise in silent database installs
  • Clone databases using RMAN restore/recovery methods and RMAN duplicated database methods
  • Experience in tuning Different components and identifying bottle necks in performance of databases
  • Hands on Experience in Performance tuning and optimization
  • Analyze database performance using ASH, AWR and ADDM reports
  • 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
  • Written shell scripts
  • Setup replication using oracle GoldenGate.
  • Managed databases on Exadata.
  • Managed SQL Server 2008 and SQL Server 2012 instances.

TECHNICAL SKILLS:

  • RAC
  • ASM
  • Data Guard
  • ASH
  • Scripting
  • GoldenGate
  • Performance Tuning
  • AWS
  • RMAN
  • Patching
  • AWR
  • Security
  • Exadata
  • Instance / SQL Tuning
  • OEM
  • TOAD
  • Exadata
  • ADDM
  • RHEL / AIX
  • SQL Server

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Oracle DBA

Responsibilities:

  • Provided Operations support of 10g, 11g and 12c Databases.
  • Coordinated the migration of oracle instances to AWS.
  • Setup the disaster recovery site using Oracle Data Guard.
  • Managed databases on Exadata.
  • Apply Oracle Quarterly patches.
  • Setup instances on Amazon Web Services.
  • Worked on Instance Tuning.
  • Worked on SQL Tuning.
  • Used Data Pump to refresh schemas.
  • Performed backup, restore, recovery using RMAN.
  • Cloned Databases using RMAN Duplicate.
  • Setup alerts, threshold and jobs using 13c Cloud Control.
  • Oracle 11g with Physical Stand by Data Guard.
  • Written shell scripts.
  • Managing users, profiles, roles and table space according to the requirement.
  • Worked on Tablespace Management
  • Analyzed ASH/AWR and ADDM reports and guided application team.
  • Build 4-node 12c RAC Clusters.
  • Migrated Oracle database from file system to ASM.
  • Provided on-call support
  • Worked with onsite and offshore teams.
  • Setup GoldenGate replication.
  • Administered and maintained database security policies and procedures. Experience with administration of high-performance and large-scale multi-terabytes databases.
  • Used external tables and SQL*Loader to import data from flat files.
  • Created Documents for DBA processes and Procedures.
  • Refresh database and schemas using export/imports and data pump.

Confidential, St. Louis, MO

Oracle DBA

Responsibilities:

  • Oracle 12c, Windows OS, Physical/Standby setup
  • Create databases for new customers
  • RMAN backup/recovery, Data pump export/import, off-site Disaster recovery servers
  • Erwin Data modeling, Visual Studio source code management
  • Routine Schema management, SQL tuning
  • Windows Task scheduler, jobs/Alerts reporting
  • Created Documents for DBA processes and Procedures.
  • Refresh database and schemas using export/imports and data pump.
  • Clone databases using RMAN duplicate database.
  • Performed RMAN restore and recoveries.
  • Managed databases on SQL Server.
  • Installed SQL Server 2005 and 2008.
  • Performed Range Partitioning as a cause to improve the performance of the database.
  • Performed Cross platform migration using transportable tablespaces and RMAN.
  • Performed Import and Export using Oracle Data pump utilities
  • Administered and maintained database security policies and procedures. Experience with administration of high-performance and large-scale multi-terabytes databases.
  • Used external tables and SQL*Loader to import data from flat files.
  • Monitored database space requirements and adjusted for future needs.
  • Worked on project to move from standalone servers to RAC
  • Build physical Standby Data Guard.
  • Practiced DR by performing switchover and failover using data broker.

Confidential, Hoffman Estates, IL

Oracle Jr. DBA

Responsibilities:

  • Moved spreadsheets to Microsoft Access
  • Moved Access to SQL Server
  • Installed SQL Servers
  • Apply patches.
  • Deployment Microsoft office.
  • Troubleshoot Database networking issues.
  • Written and Fixed SQLs.
  • Followed documentation.
  • Worked with Developers with running any SQLs.
  • Provided support to offshore DBAs
  • Provided desktop support.
  • Installed oracle client.
  • Troubleshoot database networking issues.
  • Applied patches on Windows.
  • Applied CPU patches.

Hire Now