Senior Oracle Dba Resume
5.00/5 (Submit Your Rating)
Lombard, IL
SUMMARY:
- 10+ years of experience in Oracle database administration, system Analysis, Design, Development, Implementation and Testing of Relational Database Management systems for Business solutions
- Proficient in maintaining 10g, 11g, 12c, 18c databases.
- Proficient in oracle dictionary and oracle dynamic views.
- Tuned SQL Queries SQL Access Advisor
- Worked on tuning using SQL Performance Analyzer
- Tuned SQL using SQL Plan Manager
- Worked on Table compression enhancement
- Managed Active Data Guard
- Managed and administered databases from command line and 12c/13c OEM
- Expertise in Installation, Configuration, Patching, Migration, Trouble shooting and Performance
- Tuning of oracle databases on UNIX, LINUX and Windows environments
- Upgrade databases to 11g, 12c to 18c
- Managed databases on Exadata x7
- Build configured and managed multi node RAC Cluster on RHEL.
- 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
- Tune queries using SQL Plan, SQL profiler, Baseline etc.
- Build RAC Clusters from scratch including deployment of Linux operating system.
- Experienced with tools/utilities: OEM, RMAN, Statspack, TOAD, SQL* Loader, Data Pump
- Experience in Oracle installations, upgrades, migration, designing logical/physical architecture, SQL*Net, Tuning, Capacity planning, database access and Security and auditing.
- Experience in datacenter migration.
- Supporting development 24/7 production systems.
- Providing on call support for mission critical applications.
- Performing backups and crash recoveries using conventional hot/cold backups and RMAN.
- Monitoring free space in tablespaces, space requirements of tables, indexes. Performing database.
- Maintained databases on Exadata X7
- Proficient in writing UNIX Shell scripts to automate business process and daily backup.
- Vast Experience with RMAN to implement Backup/Recovery strategies
- Clone databases using RMAN Duplicate.
- Implemented data replication through materialized views.
- Refresh database objects using Data Pump
- Good experience in SQL, PL/SQL, Shell Scripting
- Experience in Data Modeling using Data modeling tools such as Erwin and Toad.
- Skilled in setting up/Installation and configuration of release 11g RAC R2 with ASM and Raw Devices
- Worked on SQL Server 2008 and 2012
- Experience with installing and maintaining Oracle 13c Cloud Control
- Build and managed ASM Disks and Disk groups
- Migrated non - ASM database to ASM.
- Experienced in RAID, storage technologies and backup solutions
- AWR Baseline Enhancements
- Automatic Memory Management.
- Automatic SQL Tuning.
- Data Recovery Advisor.
- Read-Only Tables
- Flashback Enhancements
- RMAN Enhancements
- Table Compression Enhancements.
- Worked on Tablespace/Extent/Segment Management
- Worked on Backup and recoveries using user managed and RMAN.
- Setup Oracle Enterprise Manager (OEM)
- Maintain Oracle failover databases (Physical and Logical standby databases- Data Guard)
- Oracle Tuning Pack. Oracle RAC Good knowledge of Flashback technology in Oracle 10g, and 11g.
- Proficient in Oracle RDBMS - including SQL, PL/SQL and all areas of database Administration.
- Automated Storage Management (ASM) for 10g/11g databases.
- Installed and Administered Grid Control.
- Worked with Oracle on open issues.
- Discoverer Administration including the design and administration of Business areas.
- I have worked on virtual machines and created few in Aws
TECHNICAL SKILLS:
- Oracle 11g, 12c, 18c,
- 13c Cloud Control
- Oracle Automatic storage Management
- Real Application Clusters (RAC)
- Performance Tuning
- Security Administration
- Replication
- Partitioning
- Disaster Recovery Solutions
- Database Design
- SQL Server
- AWS
- Amazon Web Services (AWS)
- Recovery Manager (RMAN)
- Standby Database Solutions
- Oracle 9i, 10g, 11g Data warehousing
- Oracle Enterprise Manager (OEM)
- Data pump, RMAN, Shell Scripting
- SQL, PL/SQL
- UNIX, Solaris, HPUX, Tru64, AIX
- Windows Server 2003, 2008, 2012
- Golden Gate
- Exadata
- Data Guard
PROFESSIONAL EXPERIENCE:
Confidential, Lombard, IL
Senior Oracle DBA
Responsibilities:
- 24x7x365 administrative support staff.
- Manage offshore team on day to day to tasks.
- Migrated standalone databases to Exadata
- Implement disaster recovery with use of Exadata
- Involved in 24x7 support for production RAC databases with on-call pager
- Supported production, development and testing databases of Multi Terabytes DB sizes.
- Configuration, troubleshooting GoldenGate issues
- Setup Uni-directional GoldenGate setup.
- Setup and managed replication using Oracle Golden Gate
- Worked on Data Migration project.
- Migrated databases from Windows platform to Linux.
- Upgraded from 11g to 12c.
- Migrating database from NON-ASM to ASM.
- I have worked on virtual machines and created few in Aws
- 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
- Maintained databases and alerts from 13c cloud control (OEM)
- Migrated standalone databases to RAC on Exadata
- Oracle DBA in 12c, 11g, with 9+ year's professional IT work experience
- Worked on 12c Multitenant databases
- Setup unidirectional GoldenGate replication
- Rolling install oracle patch in Oracle RAC 11g and 12c
- Upgraded database from 11g to 12c R2
- Cloned databases using RMAN Duplicate
- Installation of 11g, 12c clients/databases on Solaris and Linux.
- Complete Build of 4-node 12c RAC Cluster on RHEL
- Skilled with statspack, AWR, ADDM, SAR to check health of database & hardware.
- Performed database Cloning to setup test and development database.
- Migrated databases to different data datacenter.
- Handled RAC Node hangs and node eviction issues.
- Maintaining schemas and partitioning tables.
- Experienced with all kinds (Status, Performance, and Trend Analysis) of DB Monitoring.
- Index management for better performance, maintenance of Oracle Database
- Developed RMAN scripts for database backup and recovery
- Responsible for administration and supporting oracle 11g, 12c databases
- Performed large batch jobs and tuning of SQL queries and database systems.
- Designed, configured and maintained backup and recovery policies including RMAN backups.
- Monitored database space requirements and adjusted for future needs.
- Performed version upgrades and patch installs.
- Perform database administration tasks as part of a scheduled change management task.
- Proficient in communicating directly with internal resources daily.
- Configuration, maintenance and tuning of 10g RAC
- Setup of Disaster Recovery databases (Data Guard)
- Refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins
- Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
- Involved in Database sizing, Capacity Planning.
Confidential, Seattle, WA
Oracle DBA
Responsibilities:
- 24x7x365 administrative support staff.
- Configured Data Guard to provide high availability by implementing Physical stand by database.
- Used RMAN duplicate database feature to move/clone databases on Linux, AIX and Solaris.
- Cluster Installation and Configuration, Administering databases in RAC for high availability.
- Installation, Configure, setup of 11g RAC on Linux.
- Add new nodes to RAC 11g Cluster to distribute the load.
- Installed and implemented 10g RAC with 4 nodes with ASM.
- Upgraded Databases from 10g to 11g and applied patches as per requirement.
- Worked extensively on data center migrations on multiple database versions. i.e, 9i, 10g and 11g.
- Responsible for installing and configuring Golden Gate on Oracle Servers.
- Database migration from 9i to 10g to 11g.
- Designed, configured and maintained backup and recovery policies including RMAN backups.
- Compared and contrasted multiple snapshots using AWR.
- Experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor.
- Responsible for setting up Oracle Golden Gate to help in propagating information between databases.
- Recovered databases and clone applications Using RMAN.
- Performed RMAN restores and recovered database.
- Extensively used AWR, ADDM, TKPROF, and SQL Trace for database performance statistics.
- OEM Grid Control installation and configuration for monitoring and performance tuning.
- Proactive performance monitoring, and capacity planning for future database and server growth.
- Applied CPU/PSU Patches
- 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.
- Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations on an as needed basis.
- Used external tables and SQL*Loader to import data from flat files.
- Monitored database space requirements and adjusted for future needs.
- Performed version upgrades and patch installs.
- Perform database administration tasks as part of a scheduled change management task.
- Proficient in communicating directly with internal resources on a daily basis.
- Able to work effectively with multiple teams at once.
- Good understanding of ticketing system and change control process.
- Solid discipline in providing end-users timely updates on their problems. Installing server software.
Confidential, Naperville, IL
Oracle DBA
Responsibilities:
- Oracle DBA duties involving development and production support such as installations, configurations, backup/restore & recovery, database monitoring & operating system configurations, database performance tuning, assisting in the logical/physical database design, applications profiling, tuning queries and providing support to developers.
- Used RMAN to backup database.
- Review alert logs and dump files to check for any problems related to the database.
- Used Export Import and Data Pump
- Used Database Partitioning
- Provided 24/7 Online support
- Create and maintain users, roles and privileges.
- Written Shell scripts
- Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans.
- Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
- Involved in Database sizing, Capacity Planning.
- Perform Space Management & Troubleshooting the database issues.
- Generated ASH, AWR, ADDM reports from Grid Control and command line.
- Setting up privileges to create local and remote objects
- Worked on Materialized Views
- Upgrading/Migration from Oracle 8i databases to 9i and to 10g.
- Applied CPU patches