We provide IT Staff Augmentation Services!

Oracle Dba Consultant Resume

Chicago, IL

SUMMARY:

  • 11 years of experience in Oracle database administration, system Analysis, implementation andTesting of Relational Database Management systems for Business solutions
  • Expertise in Installation. Configuration. Upgrading. Patching. Migration Trouble shooting and Performance tuning oforacle 9i/10g/11g/12c/18c databases on UNIX. LINUX and Windows platform.
  • Build and managed databases on AWS Cloud.
  • Experience in setting up backups using RMAN
  • Cloned and restored databases using RMAN backups and RMAN Duplicate.
  • Build configured and managed multi node 12c RAC Cluster on RHEL 7.
  • Managed databases using command line as well as 13c cloud control.
  • Experience in Oracle Data Guard, andSQL*PLUS, Explain Plan and TOAD
  • Worked on Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases.
  • Used OEM Grid Control Diagnostic and tuning packs to tune the application and SQL queries
  • Good knowledge of Flashback Technology Flash recovery Area, ASM and RAC
  • Experienced with tools/utilities:OEM, RMAN,TOAD, and Data Pump (expdp/impdp).
  • Supporting development 24/7production systems.
  • Providing on callsupportfor mission criticalapplications.
  • Build and configured Data Guard for Disaster Recovery site.
  • Performing backups and crash recoveries using conventional hot/cold backups and RMAN.
  • Tested DR scenarios.
  • Full control of tablespaces.
  • Fair knowledge ln writing UNIX Shellscripts to automate business process and daily backup.
  • Experience with testing and pre - production and production of Oracle 11g and 12c on RAC and standlone
  • Good knowledge in Hot/Cold Backup, Recovery, and Cloning of database using RMAN.
  • Performed all aspects of database administration including installs, builds, upgrades, object sizing, object creationbackup/recovery, patches, monitoring, and exports/imports.
  • Good experience in SQL, ShellScripting.
  • Experience with installing and maintaining Oracle Grid Control. installed and configured 11g RAC on LINUX platform with ASM disks for storage
  • Supported the system 24x7.Ability to work beyond regular hours

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, C/C++, OOPS, Visual Basic

Scripting: Unix/Linux bash shell programming, Windows batch files

OS Administration: Windows, Linux, AIX, Exadata, Solaris

Database: Oracle 9i, 10g, 11g, 12c, 18c, Microsoft SQL ServerConcepts & Administration

EC2 on AWS: Oracle Exadata as Appliance

Data Guard (standby): Real Application Cluster (RAC)

Automatic Storage Management (ASM): Golden Gate

FogLight: TOAD, SQL Developer

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Oracle DBA Consultant

Environment: Oracle 11g, 12c, 18c RAC, ASM - Linux, Solaris, Data Guard

  • Supported production, development and testing databases of Multi Terabytes DB sizes.
  • Skilled with Stats pack, AWR. And ASH to check health of database & hardware.
  • Used Performance tuning tools such as explain plans and SQL tune advisor (OEM).
  • Migrated databases to Amazon Web Services (AWS).
  • Setup data guard between AWS and on-premises databases.
  • Upgrade 12c to 18c databases
  • Migrated databases to different datacenter.
  • Experienced with SRVCTL, LSNRCTL, and CRSCTL tools of 12cRAC.
  • Handled RAC Node hangs and node failover tests.
  • Setup shell scripts to automate schema refreshes.
  • Build 2-node RAC Clusters.
  • Migrated databases from standlone to RAC clusters.
  • Maintained databses on half rack Exadata X7.
  • Maintaining schemas and tablespaces.
  • Performing root cause analysis on performance related issues.
  • Analyzed ASH and AWR reports.
  • Analyze and troubleshooting locking issues.
  • Provided on-call support.
  • Worked with offshore team.
  • Worked weekends to resolved issues.
  • Responsible for administration and supporting Oracle 18c, 12c and 11g databases.
  • Performing day-to-day database administration tasks like Tablespaces usage, checking alert log, monitoring disk usage,running SQL scripts against tables/schemas, table partitioning …etc.
  • Worked in Tuning OS, Shared Pool, Golden Gate monitoring, creating crontab jobs.
  • Experienced in using Data Pump (expdp/impdp) to transfer databases from one server to another.
  • Experienced in using BBDA to build servers/nodes, databases/instances, and RAC on Linux box.
  • Good experience in SQL Tuning, and performance tuning.
  • Experienced in supporting all version of oracle RDBMS
  • Applied PSU patches on quarterly basis
  • Worked with Oracle platinum services to patche Exadata.
  • Worked with lead DBAs for preparing cluster, configuring, installing Clusterware and Oracle.
  • 10g RAC on AIX and HACMP
  • Installation, Configuration, Upgrading, Migration and Maintenance.
  • Configure, maintain and deploy the Data Guard and grid control.
  • Installing and maintaining Oracle 13c cloud control
  • Configured Workload Management, JDBC FAN, TAF, ASM, and RMAN for maximum performance.
  • Extensive use of Oracle Data pump, Exports/imports utility for moving data among the servers.
  • Created indexes to facilitate easy user interface implementation and tuning.
  • Monitor (ADDM). Automatic Workload Repository (AWR) for monitoring database performance.
  • Performed administrative maintenance, monitoring on Oracle database systems in a global.

Confidential, NJ

Oracle DBA Consultant

Environment: Oracle 11g - AIX Unix, Windows Server 2008

  • Provided day to day operations support
  • Written shells scripts to automate weekly refreshes of schemas.
  • Troubleshoot connectivity issues.
  • PSU patching for both AIX and Windows servers’ databases.
  • Used Performance tuning tools such as explain plans and trace files to tune SQL Queries.
  • HOT/COLD RMAN backups for databases on all kind of servers.
  • Responsible for administration and supporting Oracle 11g and 12c databases.
  • Created, upgraded, and cloned Oracle databases for Development and testing databases
  • Experienced in using Data Pump (expdp/impdp) to transfer databases from one server to another.
  • 24x7 operational environments.
  • Involved in gathering requirements from end users.
  • Intensively used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.

Confidential, Chicago, IL

Oracle DBA Consultant

Environment: Oracle 10g, 11g RAC, ASM - Linux, Solaris, Data Guard

  • Involved in 24x7 support for production RAC databases.
  • Supported production, development and testing databases of Multi Terabytes DB sizes.
  • Installation of 9i, 10g and 11g clients/databases on Solaris and Linux.
  • Complete Build of 3-node 11g RAC Cluster on RHEL 5.x.
  • Migrated 10g database to 11g R2.
  • Skilled with Stats pack, AWR. And ASH to check health of database & hardware.
  • Used Performance tuning tools such as explain plans and trace files to tune SQL Queries.
  • Migrated databases to different datacenter.
  • Experienced with SRVCTL, LSNRCTL, and CRSCTL of 11g RAC.
  • Handled RAC Node hangs and node failover tests.
  • Maintaining schemas and tablespaces.
  • Responsible for administration and supporting Oracle 11g, 10g and 9i databases.
  • Created, upgraded, and cloned Oracle databases for Development and testing databases
  • Performing day-to-day database administration tasks like Tablespaces usage, checking alert log, monitoring disk usage, running SQL scripts against tables/schemas, … etc.
  • Experienced in using Data Pump (expdp/impdp) to transfer databases from one server to another.
  • Experienced in using BBDA to build servers/nodes, databases/instances, and RAC on Linux box.
  • Good Experience in SQL Tuning, and performance tuning.
  • Performed automated backups and scheduling using scripting.
  • Responsible for migration of databases
  • Worked with Data pump to take the logical backups of databases and Experienced in performing Point in time recovery using RMAN.

Confidential, Chicago, IL

Oracle DBA Consultant

Environment: Oracle 9i, 10g, 11g RAC

  • Installing ASM environment and migrating database from NON-ASM to ASM
  • Configure and manage tablespaces. Tables and users for custom applications.
  • Developed views materialized views. Functions, procedures, triggers, packages using PL/SQL & SQL totransform data between source staging area to target staging area.
  • Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
  • Experienced with Space Management and Security.
  • Experienced with GUI and CLI to manage database farm house.
  • Rebuilding of indexes for better performance and maintenance of Oracle Database.
  • Tuning high - resource queries introducinghints and creating indexes/parturitions. Changing the query ifnecessary.
  • Configured and Maintenance of SQL Server databases.
  • Implemented 10g, 11gPhysical Data Guard
  • Implemented Oracle high availability solution usingoracle RAC. Physical Standby and Golden Gate.
  • Importing data from flat files into database using SQL loader and External Tables.
  • Written shell scripts to automate the tasks
  • Supported 24/7 on-call pager support for mission critical financial databases.
  • Created users, roles and granted privileges according to the business requirements
  • Database performance monitoring. Application performance monitoring, tuning database and application with efficient database parameters.
  • Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
  • Experience with pre-production andproduction of Oracle 10gR2 with multi node RAC with ASM.
  • Applied latest patches as per evaluationrequirement.
  • Implemented Oracle database backup & recovery solutions using RMAN.

Confidential, Naperville, IL

Oracle DBA Consultant

Environment: Oracle 10g RAC, ASM, AIX, Linux, Solaris, Windows, RMAN, SQL*PlusSQL, PL/SQL, UNIX Shell Scripting, Data Guard, SQL*LOADER, Oracle

  • Installing, upgrading and maintaining Oracle RDBMS on UNIX Linux platforms.
  • Maintaining databases from all the environments from all pre-production to production, which are on RAC and monitoring the Analytics environment using Oracle Streams.
  • Experienced in ORACLE 11g installation configuration and upgrading.
  • Experience with rolling upgrade to Oracle 11g RAC
  • System Development Life Cycle (SDLC) methodology for designing, analysis, development and implementation.
  • Troubleshoot OCFS2 install issues and working with Enterprise Manager.
  • Design and implement Auditing and other security features for the existing Production systems.
  • Raised SR and TAR with Oracle Support.
  • Used Oracle Enterprise Manager (OEM) for administering several databases.
  • Backup of database Logical and Physical (hot and cold) procedures and also using RMAN.
  • Migration from Linux to Solaris and 32 bit to 64 bit.
  • Restore and Recovery of database in case of database crash, disk/media failure.
  • Applying patches and works closely with Oracle to make Application environment up to date.
  • Backups & Recovery Maintenance, Databases Performance Tuning
  • Typically involved in database Designing creation and maintenance.
  • Good working knowledge of SQL, PL/SQL, and shell scripting.
  • Created users and grant privileges according to the requirements.
  • Working knowledge on UNIX administration on AIX server.
  • Using OEM (Oracle Enterprise Manager) for routine administration database monitoring, replication process and performance tuning.
  • Provided System support for both development and 24/7 production environments.
  • Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.
  • Involved in designing logical and physical data models using Erwin.
  • Working Experience with Latest TOAD having new features PLSQL & SQL Script Debugger, Database Health.
  • Checkup, ASM Manager, Diagnose Extents, Segment Advisor, SGA Trace and Query Builder.
  • Created indexes to facilitate easy user interface implementation and tuning.
  • Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM).
  • Automatic Workload Repository (AWR) for monitoring database performance.
  • Tested database performance issues (monitoring and tuning) to ensure database optimization.

Hire Now