We provide IT Staff Augmentation Services!

Oracle Dba Resume

FloridA

PROFESSIONAL SUMMARY:

  • Over 8 years of hands - on experience working as DBA experience including Production support, Implementation, Configuration, Upgrades, Replication, Performance Tuning/ Optimization/AWR, ADDM, User/Security Administration, Backup/Recovery, Data/Network Administration and Maintenance, Database Migration, ASM
  • Expertise in attaining Performance tuning for Oracle databases using utilities like STATSPACK, TKPROF, Explain Plan, SQL TRACE, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes
  • Hands on experience in-migrating from Oracle 9i to 10g (10.2.0), 10g to 11g and applied Oracle patches
  • Oracle RAC 11gR2 Database Administration including Installation, configuration, Analysis, Design, Backup and Recovery (RMAN)
  • Extensive experience included in MS SQL Server Installation, Configuration, Migration, Upgrading, Performance Tuning, Client/Server Connectivity, Query Optimization, Backup/Recovery, Clustering, Mirroring, Log Shipping, Replications Database Maintenance Plans, Database Consistency Checks
  • Good experience in Shell Scripting, Partitioning, Logical and Physical Database Design, Backup and Recovery procedures
  • Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables - Implemented SQL tuning using SQL Tuning Advisor, SQL Access Advisor, SQL Profiler and SQL Optimizer
  • Experience using Oracle Enterprise Manager (OEM), SQLPLUS, TOAD and Grid Controlling using OEM
  • Experience in HP-UX, AIX, SUN SOLARIS, RED HAT LINUX and WINDOWS environments
  • Highly experienced in all the phases of Software Development Life Cycle (SDLC)
  • Experienced in implementing scripts using bash, k-shell, and writing scripts for backup purposes
  • Experience Upgrading/Migration of Databases from Oracle 9i to 10g and 10g to 11g as well migrating experience over cross platforms from Linux to Solaris, AIX to Solaris and from Windows to Linux
  • Strong analytical and problem-solving skills with ability to work within a team environment and independently when needed

PROFESSIONAL EXPERIENCE:

Oracle DBA

Confidential, Florida

  • Conducting sizing & capacity planning for Oracle databases
  • Upgrading production and development databases to Oracle 11g and 12c
  • Installation, Configuration and Administration of Oracle 12c PDB and CDB databases
  • Installation, Configuration and Administration of Oracle 11g and 12c RAC
  • Applied patches to Oracle Databases
  • Cloned/Refreshed Oracle Databases and Oracle Applications for development and testing
  • Responsible for optimizing the queries and application tuning
  • Worked on Data encryption by creation TDE wallet
  • Use OEM 13c for monitoring, tuning and scheduling backups
  • Perform SQL tuning and assist developers with coding PL/SQL
  • Provide DBA implementation and support for Oracle migrations and upgrades, including
  • Troubleshooting DATAGUARD related issues on a frequent basis like REDO shipments, LAG issues,
  • Oracle Golden Gate configuration and monitoring
  • Provide support for RAC environments working on different variety of Nodes Cluster across SDLC
  • Troubleshooting RAC related issues on a frequent basis like node eviction and another configuration
  • EC2 instance on AWS and Amazon Redshift
  • Cage switches at least 2 to 3 times per week in some of our DataGuard production environments.

Environment: Oracle 11g, 12c, OEM13C, SQL SERVER, DataGuard, RAC, Jira, Slack, Idera Diagnostic Manager, Red Gate, New Relic

Senior DBA - Oracle, SQL Server, MySQL

Confidential, Philadelphia, PA

  • Oracle configuration and installation
  • 24 X 7 production database administration, support and monitoring
  • Set up and implement Golden Gate replication across data centers
  • Bidirectional and Unidirectional Replication setup
  • Performed periodical checks on the Golden Gate setup making sure REPLICAT, PUMPS, EXTRACT are not lagging and data is being replicated
  • Performed database cloning to setup test and development database
  • Conducted sizing & capacity planning for Oracle databases
  • Upgraded production and development databases to Oracle 11g and 12c
  • Installation, Configuration and Administration of Oracle 11g RAC
  • Applied patches to Oracle Databases and Oracle Applications
  • Cloned/Refreshed Oracle Databases and Oracle Applications for development and testing
  • Responsible for optimizing the queries and application tuning
  • Perform SQL tuning and assist developers with coding PL/SQL
  • Provided support to Application Database Administrators in designing the database
  • Installed and Implemented Backup & Recovery procedures using RMAN
  • Automation of data load using Korn shell scripting and SQL
  • Modified new emergency email logic (emails and attachments generated straight from AppEngine) to use new directory / subdirectory standards
  • Created Run Control Page for Order Interface Report - Created Run Control Page for Auto Expedite Report
  • Created Run Control Page for Physical counting SQRs
  • Perform other regular DBA activities including space management and performance monitoring
  • Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN
  • Continuous monitoring of database performance during peak and non-peak loads using STATSPACK
  • Implemented the replication of data between multiple databases using Streams
  • Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters, Oracle Standby
  • Work on other RDBMS like MySQL, MemSQL as needed

Environment: Oracle 10g, 11g, 12c, OEM13C, MySQL 5.5, MemSql Clustering versions 3.2, 4.1, Golden Gate, DataGuard, RAC, Jira, Slack, Windows Server 2007/2008, SQL Server 2008/2012, Idera Diagnostic Manager, Red Gate, TFS

DBA - Oracle/SQL Server

Confidential, Fort Lauderdale, FL

  • Provide DBA implementation and support for Oracle migrations and upgrades, including
  • Troubleshooting DataGuard related issues on a frequent basis like REDO shipments, LAG issues, network issues
  • Provide support for RAC environments working on different variety of Nodes Cluster across SDLC
  • Troubleshooting RAC related issues on a frequent basis like node eviction and another configuration issues, network issues
  • Implementing Switchovers in DataGuard environments for schedule and rolling Upgrades
  • Assisting Projects team and development team in building application and setting up RAC clusters
  • Configuring of ASM and CLUSTERING in High availability environments - Assisting End users to troubleshoot issues in the database and other request as needed
  • Implementing Change Request on Production database and other schedule jobs using scripts and data pump Jobs -Incident MANAGEMENT on a 24/7 rotation -Project management and coordination
  • Use Toad, putty, OEM12c, Ignite Confio, SQL Developer and sqlplus, Unix, AIX, DATAGUARD Broker for database management and related activities
  • Attend meetings and assist project teams in relation to capacity planning and other refreshes
  • Configuring of ASM and CLUSTERING in High availability environments
  • Participate in database Performance tuning and error resolution using Idera Diagnostic Manager
  • Monitoring database growth, managing Databases, data files, log files
  • Rebuilding the indexes at regular intervals for better performance, monitoring the Scheduled jobs
  • Worked on Data encryption by creation TDE wallet
  • Performing the database health activities using dbcc checkdb and dbcc checkalloc
  • Managed various issues like the Orphan user and transfer of logins etc., during the process migration of SQL Server 2008 to SQL Server 2012
  • Creating maintenance plan for consistency checks, maintaining indexes and statistics
  • Monitor SQL Server Error Log, Space usage
  • Strong on SQL Server Profiler, Extended Events, Database Engine Tuning Advisor, Performance
  • Export & Import data from Excel File, Flat file, CSV file to/from SQL Server Database using BIDS, SSDT
  • Strong knowledge and working experience in Database Backup and Disaster Recovery
  • Change the Compatibility level for 2012 for all database after upgrade from
  • Back up and Refresh Database from production to dev sit and UAT

Environment: Oracle 10g,11g,12c, OEM 12c, ASM, RAC, DataGuard, RED HAT Linux, Sun Solaris, Avamar, RHEL 5.2, Ignite Confio, Zenoss, RMAN, OEM 12c, TOAD, SQL Developer, SQL Server Management Studio, Oracle 11.2.0, Oracle 10.2.0.5, Oracle 9i, and Oracle 12c, ASM, RAC, Windows Server 2007,2008/2008, SQL Server 2008/20012, Idera Diagnostic Manager, Red Gate, TFS

DBA - Oracle/SQL Server

Confidential, Pittsburgh, PA

  • Backup and Recovery using RMAN
  • Database restoration for disaster recovery from Backups
  • Database refreshes and cloning using RMAN and DATAPU
  • Database performance tuning using Tuning Advisor like AWR, ADDM, SQL ANALYZER, and Explain Plan, also using command line in generating reports needed
  • Provide support for Oracle Enterprise Manager Grid Control 12c and Agents - Provide DBA implementation and support for Oracle migrations and Upgrades, including environments using Oracle DataGuard.
  • Troubleshooting DataGuard related issues on a frequent basis like REDO shipments, LAG issues, network issues
  • Provide support for RAC environments working on different variety of Nodes Cluster across SDLC
  • Troubleshooting RAC related issues on a frequent basis like node eviction and another configuration issues, network issues
  • Implementing Switchovers in DataGuard environments for schedule and rolling Upgrades
  • Assisting Projects team and development team in building application and setting up RAC clusters
  • Configuring of ASM and CLUSTERING in High availability environments
  • Assisting End users to troubleshoot issues in the database and other request as needed
  • Implementing Change Request on Production database and other schedule jobs using scripts and data pump Jobs -Incident MANAGEMENT on a 24/7 rotation, Project management and Coordination
  • Worked on Data encryption by creation TDE wallet
  • Use Toad, putty, OEM12c, Ignite Confio, SQL Developer and sqlplus, Unix, AIX, DataGuard Broker for database management and related activities
  • Work on Peoplesoft Version 7.2 - work with admins to do schema refreshes on a daily or weekly basis from Prod to Dev environments.
  • Created Run Control Page for Order Interface Report, Created Run Control Page for Auto Expedite
  • Report, Created Run Control Page for Physical counting SQRs
  • Creating maintenance plan for consistency checks, maintaining indexes and statistics
  • Monitor SQL Server Error Log, Space usage
  • Export & Import data from Excel File, Flat file, CSV file to/from SQL Server Database using BIDS, SSDT
  • Monitored Server Activity, Error Log, space usage, and solving problem as needed
  • Assist in running scripts and jobs from Admins during off hours for table updates
  • SQL Server administration such creating table, Performance tuning on SQL server databases and Clustering and backup and recovery

Environment: Oracle 10g, 11g,12c, OEM 12C, Golden Gate ASM, RAC, DataGuard, RED HAT Linux, Sun Solaris, Avamar, RHEL 5.2, Ignite Confio, Zenoss, RMAN, OEM 12c, TOAD, SQL Developer, SQL Server Management Studio, Service Now, Erwin Tool, SQL Server 2003, 2005, 2012, MySQL 5.5

Oracle Database Administrator

Confidential, East Syracuse, NY

  • Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms
  • Extensively used AWR, ADDM and explain plan for periodic performance tuning
  • Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN
  • Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager)
  • Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts
  • Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
  • Refreshed/cloned databases using RMAN utility
  • Implementing Data pump, conventional export/import utility of Oracle 11g, 10g for re-organizing
  • Databases/Schemas/Tables to improve the performance
  • Used import/export utilities for cloning/migration of small sized databases and Data pump import/export to move data between 9i and 10g/11g environments
  • Installed ASM environment and migrated databases from NON-ASM to ASM
  • Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control
  • Performed Database upgrade from Oracle 9i (9.2.0.7) to Oracle 10g (10.2.0.5) and Oracle 11g (11.2.0.3) - Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases
  • Achieved optimized performance for the databases by rebuilding indexes, implementing portioning methodologies (Range partitioning, List partitioning, Hash partitioning, Composite partitioning) on tables and indexes
  • Loading data from flat files to database using SQL Loader, External Tables
  • Used TOAD for database management
  • Configured Manager, Replicate and Extract processes and implemented unidirectional, bidirectional replication using Oracle 11g Golden Gate on RHEL 5 platform.

Environment: Oracle 9i,10g, 11g, ASM, RAC, DataGuard, RED HAT Linux, Sun Solaris, AvamarRHEL 5.2, Ignite Confio, Zenoss, RMAN, OEM 12c, TOAD, SQL developer, SQL Server Management Studio, Service Now, Erwin Tool, SQL Server 2003, 2005, 2012, MySQL 5.5

Oracle Database Administrator

Confidential, Bridgewater, NJ

  • Production support database on 9i, 10g and 11g versions with standalone and RAC environment
  • Supported database platform are Solaris 10 and AIX 5.3
  • Migrated databases from Oracle 10g on Solaris 10 to Oracle 11g on Linux on development, integration and production environment
  • Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs taken at the peak business hours
  • Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM)
  • Tuned database for optimum performance
  • Communicate and coordinate with Oracle using My Oracle for major database issues/ problems.
  • Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs
  • Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC
  • Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases
  • Implemented switchovers on primary and standby databases as a part of planned maintenance activities
  • Tested and Implemented different physical and logical Backup and Recovery methods like point in time, Media recovery, Full/partial export/import
  • Creation and configuration of Oracle database of various sizes 200GB, 400 GB, and 2TB in Dev, ITG, Model and Production environments
  • Worked on Auditing and security with Oracle databases
  • Monitor and Configured Oracle 10g databases using OEM
  • Worked with Flash Recovery Area
  • Created and Managed user, table spaces, data files and archive log
  • Performance Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the Stats pack report generated from snapshots
  • Worked on Oracle Public and Private Database Link
  • Perform User Management, creation, monitoring and management of database users, altering passwords of users and granting and revoking system/object privileges, roles, auditing user actions in the database.

Environment: Oracle 10g, 11g, ASM, RAC, DataGuard, RED HAT Linux, Sun Solaris, Avamar RHEL 5.2, Ignite Confio, Zenoss, RMAN, OEM 12c, TOAD, SQL Developer, SQL Server Management Studio, Service Now, Erwin Tool, SQL Server 2003, 2005, 2012, MySQL 5.5

Hire Now