We provide IT Staff Augmentation Services!

Oracle And Sql Dba Resume

Chicago, IL

PROFESSIONAL SUMMARY:

  • 8 years of IT Experience
  • Over 7 years of Managing Oracle Databases from 9i to 12c.
  • Over 3 years in Managing SQL Server Databases
  • Pose strong expertise in Building, Configuring, Troubleshooting and Managing Oracle RDBMS areas
  • Worked on the following OS in managing RDBMS
  • Linux, CentOS, Fedora
  • Windows
  • Solaris, AIX
  • Database Security Administration using roles/grants and Fine Grain Access Control.
  • Good understanding about Exadata features like Smart Scan, Compression, Flash Cache, etc.
  • Hands - on experiences in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine including upgrades and patching.
  • Provide and implement performance tuning recommendations of all components in Exadata database machine.
  • Worked on the Upgrade and Migration Project
  • Provided guidance and develop Disaster Recovery strategies
  • 24*7*365 DBA support for databases with a large number of users located all over the world.
  • Good understanding of PL/SQL, database triggers, functions and procedures/
  • Identified root cause of performance issue using ASH, AWR, ADDM,
  • Used SQL Advisor, tkprof, execution plan to enhance SQL/Instance Tuning
  • Install and supported Microsoft SQL Server 2008 and 2012 on Server 2012.
  • Setup Disaster recovery site using oracle data Guard.
  • Setup Oracle GoldenGate

AREAS OF EXPERTISE:

  • RAC
  • 11g Grid Control
  • Explain Plans
  • Grants / Privs / Roles
  • Data Guard
  • 12c Cloud Control
  • Oracle Security
  • Tablespace Management
  • ASM
  • User Management
  • Oracle Vault
  • RMAN restore / recovery
  • GoldenGate
  • RMAN Backups
  • Data Pump
  • 13c Cloud Control
  • Exadata
  • Shell Scripting dbLinks
  • Fine Grain Auditing
  • Export Import
  • Monitoring
  • Export Imports
  • Flash Recovery Area
  • Exadata
  • Compression
  • Smart Scans
  • Flash Cache
  • SQL Server
  • CPU / PSU patches tkporf
  • ASH / AWR / ADDM

PROFESSIONAL EXPERIENCE:

Confidential

Oracle and SQL DBA, Chicago, IL

Responsibilities:

  • Provided production and development support to Oracle database (9i, 10g, 11g and 12c.)
  • Build 11g and 12c RAC Clusters
  • Set up Active Data Guard and worked on the Disaster Recovery project
  • Worked with Storage team for ASM and other file system needs.
  • Set up uni-directional Golden Gate for replication.
  • Provided assistance to Customers in Solving ORA- errors
  • Provided assistance to Implement Huge pages /Large Pages in Unix platforms
  • Worked on many data refreshing tickets using Data Pump and RMAN Duplicated database.
  • Worked with Oracle Development for best practices
  • Provided assistance to customers in production Database Hung and non-responsive issues
  • Supported application and professional services to manage their data ranging from GB to TB in oracle database, solving of space problem, data loading problem.
  • Providing all round DBA support to resolve Application and DB outages on production, development, test and staging Customer environments across the Globe.
  • Involved in resolving issues after Installations, Upgrades, Cloning, patching (both DB and Applications), CPU patches, and one off patches.
  • Setup the RMAN Backups for all the Production databases satisfying RTO and RPO. Leading in performing periodic DR Drill and testing RMAN backups with various scenarios.
  • Evaluated Oracle Database Monitoring and PL/SQL tools.
  • Helped on Demand engineers in the dry run for disaster recovery test for On Demand Customer instances.
  • Investigate, diagnose, and quickly resolve performance related issues using OEM, dynamic view, SQL Advisor, ASH, AWR, ADDM, tkprof, explain plan, real time SQL Monitoring etc.
  • Install Oracle supplied tools to assist in database and SQL Tuning like SQLT.
  • Provides and supports the implementation of business solutions
  • Upgrade/Migration databases from Oracle 10g to Oracle 12c.
  • Setting up and testing the backup and recovery strategies
  • Worked in Tuning OS, Shared Pool, Buffer Cache, and Redo Log Buffer.
  • Applied various recovery scenarios for complete and incomplete recovery in case of failure
  • Support SQL Server database using SQL Server 2012 on Windows Server 2012.
  • Applied CPU/PSU and one off patches.

Confidential

Oracle and SQL DBA, Chicago, IL

Responsibilities:

  • New installations of Oracle RAC on Linux
  • Created Users/Roles, granted/revoked Permissions/Roles, defined quota on Tablespaces for users, and effective management of Locally Managed Tablespaces, Dictionary-Managed Tablespaces, and Temporary Tablespaces.
  • Used expdp/imp, data pump and dblinks to move the data
  • Worked on standard and enterprise edition of the Oracle RDBMS.
  • Worked on database backup using RMAN for HOT backup and scripts written for COLD backup.
  • Worked on schema Reorganizations for better space management
  • Tablespace management including, adding/resize data files, allocated quotas to user and managed disk space
  • Migrate standalone to RAC.
  • Migrate from NON-ASM to ASM.

Environment: PL/SQL, SQL, SQL*Plus, Oracle 9i, 10g, 9iAS; Sun Solaris Unix, Linux Windows XP, Oracle Forms 10g, Oracle Streams Oracle Reports 10g, Oracle Developer

Confidential, Chicago, IL

Oracle DBA

Responsibilities:

  • Used specific relational database management system structure and technology to create and maintain physical databases. Worked with Oracle 9i and 10G databases.
  • Interfaced with clients on a regular (daily) basis.
  • Implemented procedures and practices regarding database design, development, monitoring, access, and upkeep.
  • Installed and configured database management system software.
  • Developed and implemented backup and recovery strategies.
  • Implemented capacity planning for databases.
  • Served in an administrative role regarding database privileges, security, and migration.
  • Developed policies and procedures for system operations to better serve clients.
  • Presented database management solutions to internal clients
  • Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
  • Responsible for quarterly patching and bug fixes.
  • Installing, Monitoring, Upgrading Oracle 9i/10g/11g.
  • Created Physical standby Data Guard.
  • Configured Data Broker Configuration for Data Guard database.
  • Practiced switched over and failover for Disaster Recovery.
  • Database Backup, Database Restore and Database Recovery using various tools.
  • Database Reorganizations for better space management.
  • Performed Database Refreshes and Database Copies for Development, Test and Production
  • Supported multiple accounts on versions 9i to 11g
  • Installation of Oracle 11g, 10g, 9i under Windows, RH Linux, Sun Solaris and Upgrading to new versions and applying patches as required.
  • Install, tune and configure complex clustered database environments. Creating Database, Tablespaces, Rollback Segments etc.
  • Create and maintain users, roles and privileges.
  • Installed and configured Oracle Grid control.
  • Extensively used data moving utilities like export/import, Data pump, Migrated flat files from different sources into Oracle Database using SQL*Loader and Performed DB cloning.
  • Performed Online/Offline database backups.
  • Built and configured RMAN Recovery Catalog for Backup and Recovery strategy.
  • Involved in DB Security, Audit and Risk Management of DB systems.
  • Implemented backup strategies which involved taking an incremental backup and enabled the block change tracking feature.
  • Involved in monitoring the lock and latches processes, releasing locks in case of resource blockage and gathering statistics.

Hire Now