We provide IT Staff Augmentation Services!

Senior Oracle Dba Resume

Lincolnshire, IL

PROFESSIONAL SUMMARY:

  • 8 years of experience in IT industry as an Oracle Database Administrator.
  • Installation and administration of Oracle 12c/11g/10g, PostgreSQL on OEL, RHEL, Windows, and UNIX and Solaris platforms.
  • Designing and building database structure and objects that best support operational and analytics application.
  • Upgrading and migrating databases, applying patches, patch sets and critical patch updates, replication and extraction of data using GoldenGate
  • Installing, creating and maintaining Oracle Data Guard and Oracle Grid Control.
  • Installing and configuring Oracle RAC with ASM file systems on multi - node systems, 12c, 11g, and 10g in different operating systems.
  • Performance tuning, SQL tuning services with EXPLAIN PLAN, TKPROF, AWR, ADDM, DBMS STATS to collect and maintain performance statistics and improve database performance.
  • Installing and configuring RMAN with and without Recovery Catalog on Oracle 12c/11g/10g/9i.
  • Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
  • Successfully resolved problems which involved in-depth knowledge of Oracle Architecture, Connectivity, Backup/Restore, Database Corruption and Security.
  • Participated in Problem determination and Trouble shooting in Development, Test and Production Environments.
  • Experience in implementing RAC Database in AIX platform.
  • Hands-on experience in Oracle Data Appliance (EXADATA) monitoring System utilization and performed health check on cell nodes.
  • Performed periodic maintenance tasks like Index rebuilds, data purge, Table Analysis and Partitioning to ensure efficiency and reliability of the applications and databases.
  • Preparation of High Level document, Detail Level Design document and other relevant documents for development process.
  • Having knowledge on developing software at the data layer in an Oracle/Hadoop environment using Transact-SQL Software development skills in object oriented programming.
  • Knowledge Transition by preparing plans, work schedule, understanding documents, managing transition calls and tracking transition status.
  • Refreshing, migrating and upgrading databases.
  • Conceptually strong knowledge on clustering.
  • Analysis and development of Batch Programs using the Business Rules and code of the existing system
  • Conceptually strong knowledge on Golden Gate integrated Extract Architecture.
  • Coordinating Oracle SR engineers for resolving the critical production Issues.

TECHNICAL SKILLS:

Core Strengths: Oracle Database (RAC and Standalone) Administration, SQL, PL/SQL UNIX.

RDBMS: Oracle 9i, 10g, 11g and 12c Administration

Operating Systems: LINUX, UNIX, AIX, HP-UX, Sun Solaris, Windows 2000, 2003, 2007

Programming Languages: SQL, PL/SQL, Shell Scripting, Perl, Php, and Python

Tools: Oracle Enterprise Manager, Oracle Grid Control (10g, 11g and 12c), TOAD, SQL Developer.

EXPERIENCE:

Confidential, Lincolnshire, IL

Senior Oracle DBA

Responsibilities:

  • Deploy database changes on production needed for new requirements, to fix application defects or performance issues on Sun OS, Linux and AIX.
  • Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
  • Hands-on experiences in resolving the EXADATA critical issues like Cell disk metadata corruption and loss of cell disk content (i.e. grid disk, ASM disk).
  • Knowledge Transition for database activities from the existing teams.
  • Perform activities of data maintenance, table maintenance, database re-organizations, data archival and other efforts typically undertaken to improve the efficiency and reliability of the applications and databases.
  • Oracle 11g/12c RDBMS installation, upgrade, configuration, backup, recovery, archiving and purging activities.
  • Installation, Configuration and Maintenance of Oracle Grid Control.
  • Perform database activities like schema backup/restore, import/export, expdp/impdp required for the health of the application and release processes.
  • Migrating databases from Windows to Linux.
  • Analyze database activity, perform application database performance and tuning activities and maintain development, test and production databases.
  • Installing and migrating databases including structure and scripts.
  • Hands-on experience in implementing Database Security and Auditing.
  • Oracle 12c DB Patching on 12.1.0.1.2.
  • Implementing Oracle 11g RAC (3 node) systems in High availability environment in AIX.
  • Configuring and managing active Data Guard for Production and Pre Prod databases for reporting purpose and monitored log transport services and log apply services in Physical/Logical databases.
  • Perform analysis and reporting of results from processing and database monitoring.
  • Developing materialized views for data replication in distributed environments.
  • Proactively maintain stability of production databases.
  • Hands-on experience in High-availability CRS, ASM and Active Data Guard
  • Hands-on experiences in scripting languages are Perl, php and Python.
  • Periodic data purge to follow retention policies and space constraints.
  • Work with application team and production support team to debug production issues.
  • Good Exposure in disaster recovery, routine maintenance for Oracle databases.
  • Good Exposure in Oracle cluster ware and HACMP cluster ware concepts.
  • Having expert knowledge in Configuring Recovery Catalog Database and maintaining RMAN.
  • Experience in Oracle GoldenGate 10.x/11.x installation, configuration, troubleshooting GG issues and GoldenGate replication implementation on Oracle 10g and 11g with different OS flavors.
  • Understand existing Oracle Golden gate Integrated extract architecture and provide recommendations to improve performance.
  • Replication and Extracting data and applying on production using GoldenGate.
  • Experience working in PCI, SOX and CPNI environments and processes related to management of such environments and disaster recovery activities.

Environment: Oracle 9i, 10g, 11g,12c, RAC, EXADATA,Active Data Guard, Oracle Data Appliance, SQL/PLSQL, UNIX Shell Scripts, Toad for Oracle, AIX, SUN Solaris.

Confidential

Oracle DBA

Responsibilities:

  • Installation and Troubleshoot of Real Application Cluster (RAC) Database and Cluster ware.
  • To troubleshoot and resolve all the Database Issues, Network Issues and the Application Issues.
  • Worked in Production, Development, Testing and Implementation environment on Linux and AIX
  • Involve in various Implementations like (DB Creation, Patching, Cloning and Up gradation) on Database Tier.
  • Installing Oracle 10g/11g/12c stand-alone and RAC systems in High availability environment in different platforms including OEL, Linux, RHEL and VMware.
  • Setting up BACKUP strategy and disaster recovery procedures to ensureminimal downtime and data loss.
  • Good Exposure in disaster recovery, routine maintenance for Oracle databases.
  • Involved in Implementation of RMAN backup strategies.
  • Involved in configuring of ASM Databases and Migration of Non-ASM Databases To ASM databases Using RMAN
  • Handling alone in validating the Developed scripts for Hot and Cold Backup and Database Refresh
  • Implemented Symantec net backup.
  • Hands-on experiences in scripting languages are Perl and Python
  • Monitor physical and logical backup for Integrity and checking the Data files consistency using DBverify.
  • Check the log alert files if any problems occurred and necessary action to rectify them.
  • Having expert knowledge in Configuring Recovery Catalog Database and maintaining RMAN
  • Analysis and Documentation of the existing database architecture.
  • Applying the Critical Patch Update (CPU) based on the requirement
  • Preparation of High Level document, Detail Level Design document and other relevant documents for development process.
  • Providing support as required and mentoring team members while solving technical problems and providing technical guidance on solutions.
  • Hands-on experience in High-availability CRS, ASM, Data Guard and ACFS.
  • To Create the Standby Databases to improve the high availability, configuration and Management of Standby Data guard setup.
  • Monitor the Database Health Check, Capacity Management, Logical/Physical Backups and Server/Database parameters.
  • Developing complex Stored Procedures, Functions, Packages and Triggers using SQL, PL/SQL.
  • Developingmaterialized viewsfor data replication in distributed environments.

Environment: Oracle 11g RAC database, AIX, SQL, PL/SQL, UNIX Shell Scripts

Confidential

Oracle Database Administrator

Responsibilities:

  • Migration Oracle Server databases.
  • Database Administration and Maintenance.
  • Executing routine jobs/tasks as a part of every release and providing support during Implementation on Production for a release.
  • Managing Table space and Data files.
  • Managing Database Security (Creating users, logins and roles, granting permissions)
  • Query Performance tuning using Execution Plan, Hints and AWR.
  • Checked database locks and cleared the blocking sessions.
  • Worked on user managed backup strategies like online and offline.
  • Implemented Backup and Recovery strategies using RMAN(migrated from user managed backup to RMAN)
  • Performed Cloning of database.
  • Integration of Patches, Creation and Modification of tables in the database, Execution of Jobs, Bug fixing etc.
  • Resolving user requests for the technical issues as well as various other tasks for the development environments.
  • Responsible for migration of database from IBM DB2 to Oracle. Production database support and responsible to implement the high availability
  • Installation and Configuration of Oracle 10g Cluster, ASM and database on Linux environment.
  • Automatic Storage Management installation, configuration and management.
  • Performance tuning of databases using AWR, ADDM and OEM.
  • File management on Automatic Storage Management.
  • Applying the Critical Patch Update (CPU) based on the requirement.
  • Performed database backups - Cold backups, Hot backups, RMAN Incremental Backups, Data pump and Export utility.
  • Performed database duplication, database restore and recovery using RMAN
  • Database replication using SharePlex and Data Guard
  • Production database schema upgrade.
  • Production support for database availability and backup related alerts
  • Handling and Maintaining databases on Archive and No-Archive log modes.
  • Creating and scheduling the shell script on databases to carry out various database activities
  • Data loading using Oracle data dump and Import utility.
  • Report and Document preparation: Database growth and PRD

Environment: Oracle 9i, 10g, 11g, ASM, Toad for Oracle, AIX, SUN Solaris.

Confidential

Oracle Database Administrator

Responsibilities:

  • Installing and Configuring Oracle 10g, including service pack deployments.
  • Executing routine jobs/tasks as a part of every release and providing support during Implementation on Production for a release.
  • Automatic Storage Management installation, configuration and management
  • Migration of oracle databases.
  • Developing complex Stored Procedures, Functions, Packages and Triggers using SQL, PL/SQL.
  • Implemented disaster recovery plans.
  • Working Imports and Exports utilities.
  • Managing Security (Creating users, logins and roles, granting permissions)
  • Performance tuning of databases using AWR, ADDM and OEM
  • Creating Index & managing other objects of Database.
  • Analyzing the data of billing database and preparing the reports using the data.
  • Generation of consolidate bug report and prioritizing the severity of bugs.
  • Software release closure review with the design team and projects.
  • Releasing the software to the customer and tracking the status of installation/upgrade.
  • Involved in Hardware and software testing.
  • Creating and scheduling the shell script on databases to carry out various database activities
  • Production database schema upgrade.
  • Migration of database from file system to Automatic Storage Management
  • File management on Automatic Storage Management
  • Applied the Critical Patch Update (CPU) based on the requirement
  • Database version upgrades from 10.2.0.1.0 to 10.2.0.5.0 and from 10g to 11g
  • Responsible for database and configuration, db sizing, monitoring.

Environment: Oracle 10g, 11g, SQL, PL/SQL, Toad for Oracle, AIX, SUN Solaris.

Hire Now