Oracle Dba Resume
Peoria, IL
SUMMARY:
- Over 8 years of IT experience and 8 plus years of Oracle RAC DBA experience
- Build Managed and Administered 11g and 12c RAC.
- Build and manage 12c/13c Cloud Control.
- Worked as a lead in Data Center Consolidation on large database systems.
- Mentors the team on technology concepts and ensures team compliance to best practices for design
- Participates in code and design reviews to ensure quality and conformance to product standards
- Helps motivate team members to get the best out of team.
- Worked as a Primary support for database related issues with clients.
- Worked on multiple projects in parallel to daily DBA activities.
- Worked extensively on ASM Builds and management of ASM Filesystem.
- Implemented Disaster Recover Site with Data Guard and maintained Active Data Guard.
- Performed Database Tuning & Performance, Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management and Tuning SQL queries.
- Worked on Oracle Materialize Views, Oracle Golden Gate and Oracle Active Data Guard.
- Build 13c OEM Cloud Control and managed OMS and OMR.
- Configure 11g Active Data Guard.
- Managed databases on Exadata.
- Proficiency in analysis, design, development, testing, implementation and maintenance of applications in Oracle Application Express (APEX) and client/server configurations.
- Worked on Hybrid Columnar Compression (HCC) that provides dramatic reductions in storage for large databases
- Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
- Assisted in integration of Exadata applications into current IT actionable events and solutions.
- Migrating databases to Oracle Exadata Database Machine for different clients
- Analyzing database performance and tuning database on Oracle Exadata using Real Application Testing (RAT)
- Implementing Best Practices for migration E - Business Suite and regular databases to Oracle Exadata
- Installing, configuring and maintaining Enterprise Manager Cloud Control to monitor and manage Exadata and regular databases
- Used tools like TOAD, DB Console, Confio, and Grid Control to monitor database performance.
- Build and administer SQL Server 2005 and 2008 standalone and cluster databases.
- Provided analysis to other teams and keep them informed for better resource management.
- Evaluated Oracle features and Oracle related products to leverage existing hardware/software/incenses.
- Build, configured and managed 8i to 12c databases.
- SQL Access Advisor, Performance Analyzer, Plan Manager, Automatic SQL Tuning, SQL performance analyzer, Table compression and SQL access advisor, SQL plan management and Database replay
- Table compression enhancement,
- Worked with Network team for SCAN listener
- Build and managed container and pluggable 12c databases.
- Worked on Upgrade projects.
- Worked on Migration projects.
- Participated in design, document and deployment of database/
- Provides technical assistance for many platforms, during issues and/or outages. Areas include but are not limited to Oracle, Peoplesoft, homegrown monitoring applications, operating systems, hardware components and the network infrastructure.
TECHNICAL SKILLS:
Operating Systems: Windows NT/2000/XP, Sun Solaris, HPUX, Redhat Linux, AIX
Languages: SQL, PL-SQL
RDBMS: Oracle 12c/11g/10g/9i, MS Access, MS SQL Server 2000, DB2
Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ASH, AWR, ADD
Tools:: RAC, OEM Grid Control, SQL* Loader, ASM, SQL Server, Export/Import, RMAN, NETCA, DBCA, TOAD, Patch Management, SQLNET, ODBC Export/Import, Data pump, DataGuard, VERITAS Net Backup, VMware
PROFESSIONAL EXPERIENCE:
Confidential, Peoria, IL
Oracle DBA
Environment: Oracle 11g, 12c, Exadata, AWS, GoldenGate
- Supported database on Exadata X7
- Performed Silent installation on Exadata.
- Applied patches on computer nodes, Exadata home and storage cells.
- 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 GoldenGate
- Worked on Data Migration project.
- Migrated databases from Windows platform to Linux.
- Upgraded from 11g to 12c.
- Migrating database from NON-ASM to ASM.
- 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, 12cclients/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.
Confidential, Irving, TX
Oracle DBA
Responsibilities:
- 24x7 product database support
- Installed and maintained 10g/11g databases for testing, development and production
- Database Monitoring and administration of database using Enterprise Manager Grid control OEM
- Upgraded Oracle Database from 9i to 10g, 10g to 11g.
- Migration of the database from HP-UX to Linux.
- Planned and implemented Oracle 10g RAC, 11g RAC, Standby databases for High Availability and DR solutions
- Cloning of the database from Production to the Test and Development environments using RMAN and conventional methods.
- Applied security related CPU and One-off patches using Opatch utility, Applied RDBMS Patch set Utility PSU
- Installed and configured oracle grid control.
- Used Oracle Streams for replications of data between remote databases
- Performed Cold backup, hot backup using conventional backups and RMAN, recovered various and critical Production databases.
- Prepared backup schedule which include offline, online and logical backups.
- Used Export/Import, Data Pump Utilities to move the data between different databases and for backups.
- Worked on transportation of Table spaces, Data Archival, Re-organization of tables and restoration.
- Tuning of Shared Pool, Library Cache, and Data Dictionary Cache.
- Monitor CPU usage, I/O contention, memory paging on UNIX server. Identify resource and performance bottleneck. Provide technical direction to system administrators
- Rebuilding of Indexes for better performance, maintenance of Oracle Database.
- Generated performance reports and Daily health check up of the database using utilities like AWR, Stats pack and ADDM to gather performance statistics.
- Identified and tuned poor SQL statements using EXPLAIN PLAN, SQL TRACE and TKPROF, Analyzed tables, indexes for improving the performance of the Query.
- Analyzed SQL statements, re-organized database objects and created indexes to improve the performance of the queries.
- Partition of tables to improve performance.
- Created users and allocated appropriate table space quotas with necessary privileges and roles for all databases.
- Worked with Oracle Support for resolving the database related unresolved issues.
- Worked on SQL Loader to load data from flat files, Checking for Row Migration and Chaining on Highly used transaction tables.
- Configured TNSNAMES.ORA and LISTENER.ORA for SQL NET connectivity.
- Created DB links across databases and Solved Database connectivity issues by continuously monitoring the status of the listeners and instances.
- Monitored overall system performance and Database growth.
- Served as a member of 24-hour on call support staff.
- Checked alert logs and background trace files on daily basis and resolved problems.
- Scheduled jobs in the database using CRON Jobs and DBMS JOBS.
- Implemented backup for production database. Simulated few possible crucial recovery scenarios using the current available backups to check the effectiveness of the backup plans and also to get a rough estimate of the recovery time involved.
- Automated shell scripts and scheduled batch jobs.
Environment: Oracle 9i/10g RAC/11g RAC, Red Hat Linux, Windows, HP-UX, Sun Solaris, AIX, SQL Server, PL/SQL, Shell Scripting, RMAN, Grid control, Data Guard, SQL Loader, EXP, IMP, Data Pump, TOAD, TKPROF, EXPLAIN PLAN, AWR, STATSPACK, ADDM, ASH.
Confidential, St. Louis, MO
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.
- Performing Hot/Cold backups of the database through RMAN or User Managed method.
- Setup and configured Oracle Physical Standby database (Data Guard), where the standby database was used for disaster recovery.
- Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.
- Review alert logs and dump files to check for any problems related to the database.
- Perform database cloning/exp/imp to setup identical databases in the production and development environments.
- Create and maintain users, roles and privileges.
- Upgrade/Migrated the production and development databases from 11.2.0.3 to 11.2.0.4
- Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans.
- Setup and configured 2 node Oracle 10g RAC with ASM.
- Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
- Involved in Database sizing, Capacity Planning.
- Installation and configuration of OEM Grid Control 12c.
- Perform Space Management & Troubleshooting the database issues.
- Upgrading OEM Repository and Installing OEM 10Grid Control to monitor all the databases.
- Configured and managed agents to work efficiently with Grid Control.
- Lead coordinator between technical operations team (DBA) and applications users/information systems/processing specialists
- Setting up privileges to create local and remote objects
- Create materialized views to refresh data at regular intervals.
- Using materialized view logs to reduce the replication time costs for fast refreshes.
- Configuring Oracle databases to effectively use the DISM (Dynamic Intimate Shared Memory) to dynamically shrink / grow the SGA.
- Upgrading/Migration from Oracle 8i databases to 9i and to 10g.
- Installing of quarterly security patches on all non-production and production servers.
- Cloning/replicating/refreshing production databases to test/ development environments using RMAN scripts.
Environment: Oracle 9i, 10g /11g with RAC, Oracle Golden Gate, Oracle Data Guard, HP-UX 11i v3,, Sun Solaris 10, RHEL 6.x, TOAD, SUSE 10,11, Control-M, Autosys, PCS, SRDF Replication