We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Duluth, GA

SUMMARY:

  • with over 6 years + of experience in IT infrastructure and ERP implementations with strong technology leadership experience to technical engagements, along with a broad functional expertise. Ability to provide expert - level technical support in all aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning and backup and recovery. Self-motivated, able to forge and sustain positive business relationships using interpersonal acumen to garner customer satisfaction and achieve cooperate goals.
  • Full responsibility and expertise in database administration (DBA), performance tuning, database backup, database recovery, database security, database optimization, data migration of Oracle instance
  • Proficient in database administration, production supporperformance tuning, capacity planning, space
  • Proficient in Oracle 12C (Container and Pluggable database) Implementation
  • In-depth knowledge of TDE (Transparent data encryption (at rest) with network encryption in inflight
  • Performed FLASHBACK features to handle efficient database recovery
  • In-depth knowledge and understanding of Oracle Database features such as RMAN for backup and recovery, Materialized Views, Export/Import, Data Pump and Data Guard
  • Bulk loads and data migrations (using SQL*Loader, data pump import/export, FTP, ETL)
  • Expert in RMAN backups including full, incremental and cumulative
  • Experienced in Installation of high availability RAC environment and upgraded standalone databases to RAC environment
  • Experience in Real Application Clusters (RAC) setup, configuration and cluster interconnection with Automatic Storage Management (ASM), configured user log on load balancing and failover on RAC database for high availability
  • Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN
  • Experience in applying patches (CPU)/ patch sets (PSU) to multiple different databases
  • Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-prod

PROFESSIONAL EXPERIENCE:

Confidential, DULUTH, GA

ORACLE DATABASE ADMINISTRATOR

  • Experience in applying CPU/PSU patches to various versions of databases with minimum downtime.
  • Proactive monitoring, identifying areas that need to be improved in the application and database using ASH Analysis, EXPLAIN PLAN, SQL TRACE, ORADEBUG, AWR, ADDM, and 10g OEM Grid Monitoring.
  • Good experience in Oracle Clustering services (CRS), and High Availability features. Extensive Knowledge of 10g and 11g ASM.
  • Good Experience in Database Backups and Recovery Strategies Using RMAN and Expert experience in Hot and Cold Backup of databases.
  • Good knowledge in creating RMAN Duplicate Databases and FLASHBACK recovery features.
  • Design, document, implement, and maintain all backup, recovery including disaster recovery.
  • Worked with EXP/IMP, EXPDP/IMPDP data pump to refresh the schemas and tables
  • Strong Exposure on High Availability Concepts (GoldenGate, RAC, Standby) Database Cloning, and Oracle Streams.
  • Oracle GoldenGate experience with Installation, configuration and troubleshooting of Oracle GoldenGate 11g/12c replication setup across heterogeneous database servers and ensure data synchronization.
  • Proficient in Oracle Database Administration activities such as Upgrades, Patches, my oracle support

Confidential - IOWA CITY, IA

ORACLE DATABASE ADMINISTRATOR

  • Responsible for Oracle 11g and 12c logical and physical database design, implementation, and maintenance on Windows and Linux environments
  • Created new databases and users: set up backups, export, and other monitoring scripts
  • Deploying codes from one database to another and worked on resolving various performance issues
  • Implemented database refresh using expdp, provided improved database performance resolution and effective space management
  • Migration from one platform to another using transportable table space and import and export utilities
  • Managing database security automated data backup and restoration methodologies.
  • Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU)
  • Applied Patch Set Updates (PSU) for RAC and Stand - Alone instances as releases were made available by Oracle
  • Applied Oracle Patches to environments where problem tracking with Oracle Support suggested on RAC & Single Instance environments
  • Provided 24x7 Remote / on-call production supports
  • Provide technical support for database maintenance and disaster recovery
  • Supported Security User Management, Privileges, Roles, Auditing, Profiling, Authentication
  • Database monitoring and performance tuning using OEM (Oracle Enterprise Manager)
  • Index creation and management for optimization of DB Processes
  • Used Grid Control extensively and set up Rules for alert notification and schedule RMAN backups with Failure notification
  • Extensive experience implementing backup and recovery strategy for disaster recovery using Hot/Cold Backups and using the Oracle backup utility such as RMAN.
  • Analyzed Statspack/AWR Reports to identify on-going/proactive issues and worked with application teams to resolve
  • Performed policies on data confidentiality, integrity, availability, and auditability, based on Access controls for Access to Data at the database level.
  • Performed SQL and PL/SQL tuning oracle contention and monitored production database using Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and Automatic Session History (ASH).
  • Supported and maintained Development, Test and Production databases on various servers
  • Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints. Used hints for SQL tuning and optimization
  • Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins
  • Experience with database replication and scaling issues
  • Setup dataguard broker successfully; Configured Oracle Data Guard (standby database, both logical and physical)
  • Implemented and configured goldengate on a 2-node RAC cluster

Confidential - Ann Arbor, MI

Oracle Database Administrator Oracle DBA

  • Installation, configuration and administration of oracle databases. Experience in DB upgrades, patch application, db migration, performance tuning and all general database support
  • Ensure that daily and hourly database backups completed successfully and perform period database restore testing to ensure the database can be restored in the case of a disaster
  • Good knowledge on the Creation of table spaces, data files, roles, redo logs, rollback segments, and index rebuild. Performance and space management of the database
  • Extensive experience in Performance Tuning of database, instances, SGA, I/O, and Rollback segment using different methods and detecting locks
  • Experience in Implementing FLASHBACK technology and its various features in Oracle 10g/11g and 12c
  • Experience in applying several patches such as CPU/PSU patches, One - Off Patches, Interim patches, DST, Patch sets as per the oracle recommendations
  • Participated in planning and implementation of off-site Disaster-Recovery planning and testing
  • Duties included database creation, backup/recovery using RMAN, tuning/reorganization, user and security management, auditing, cloning, general troubleshooting
  • Extensively used Oracle Enterprise Manager (OEM) for maintaining and monitoring database
  • Expertise in database refresh, schema changes, backup and restore testing, database troubleshooting and db performance tuning
  • Worked closely with Developers, Application analysts, Database programmers and web developers.
  • .involved in converting a single instance database to oracle 12c, 11g, 10g RAC databases

Confidential - Colorado Springs, CO

Oracle Database Administrator

  • Supported Oracle on Linux Red Hat, HPUX, & AIX environment
  • Cloned Oracle environments using Recovery Manager(RMAN) for user acceptance testing of new releases
  • Applied Oracle Patches to environments where problem tracking with Oracle Support suggested on RAC & Single Instance environments
  • Capacity analysis of Oracle Databases and the Data warehouse
  • Review and Troubleshoot issues within the Oracle environment as issues presented
  • Work with application support to troubleshoot any performance issues within the environment
  • Analyze any issues and provide root cause analysis to the RCA Board
  • Managed Oracle 10g, 11g, and 12c databases
  • Create documentation for all issues and new implementations maintain, and fix shell scripts used to monitor the database
  • Monitor the database via OEM 12c and resolve any issues that presented
  • Database restoration and backup with RMAN a
  • Attend weekly change board meetings and ensure all changes to the database have proper visibility
  • Review, monitor, and resolve all tickets within the database ticket queue

TECHNICAL SKILLS:

Databases: Oracle 10g, 11g, 12c, Exadata

Database Tools: Oracle (Oracle Enterprise Manager, DB Configuration Assistant) Toad, OEM Grid, RMAN, Exp/Imp/Data Pump, AWR, DBCA, DBUA, ADDM, TKPROF, Toad, Putty, WinSCP, SQL Developer,, SQL*Plus, SQL LOADER, EXADATA OEM 12c. Oracle RDBMS 10g, 11g and 12C (Container and Pluggable databases)

Operating Systems: RedHat LINUX 5,6,7, UNIX, Solaris, WINDOWS, ), IBM AIX:

Other Skills: Oracle, DATA GUARD, GOLDEN GATE, RAC, SQL SERVER and Exadata

Hire Now