We provide IT Staff Augmentation Services!

Oracle Dba Resume

Irving, TX

PROFESSIONAL SUMMARY:

  • Over 7 years of experience as an Oracle Database Administrator
  • Build and Administered RAC.
  • Build Physical Standby Data Guard.
  • Build Cloud RAC databases
  • Set up unidirectional Oracle Golden gate
  • Familiar with oracle Exadata.
  • Expert knowledge in SQL
  • Worked on active Data guard.
  • Refresh Databases using Data Pump
  • Expertise in cloning databases using different methods
  • Good Unix Administrative Knowledge
  • Expert Linux Administration knowledge
  • Good knowledge of RAID configuration.
  • Build and manage ASM Volumes.
  • Worked on Data Guard snapshot databases
  • Worked on Performance tuning
  • Worked on Capacity planning
  • Experience in tablespace and user management.
  • Worked on yearly DR testing
  • Extensive work on shell scripting
  • Familiar with PL/SQL
  • Worked with Oracle in troubleshooting performance and other issues
  • Providing 24/7 production support for critical production databases.
  • Excellent analytical, problem solving, communication and interpersonal skills.
  • Strong Problem analysis and resolution skills.

TECHNICAL SKILLS:

OPERATING SYSTEM: RHEL,Solaris, Windows, HPUX, AIX

DATABASES: Oracle 9i/10g/11/12c, SQL Server 2005, 2008

LANGUAGES: SQL, PL/SQL, Unix Shell Scripting

DOCUMENTATION TOOLS: Microsoft SharePoint, Wiki, Google Docs

TOOLS: /UTILITIES: RAC, RMAN, Data Guard, SQL, TOAD, SQL Developer, SQL*Loader, Data Pump, Export, Import, RMAN, Erwin, OEM, RAC, Data Guard, ASM, ASH, AWR, ADDM, Grid Control, Cloud Control, GoldenGate

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Oracle DBA

Responsibilities:

  • Installing, upgrading and maintaining Oracle 10g/11g/12c on AIX and Linux platforms.
  • Migrated database to new build database and also migrated physical database to CITI cloud
  • Having experience migrating physical database to cloud database.
  • Managing and maintenance of Cloud databases such as ORAAS database
  • Database refresh and database capacity planning.
  • Troubleshooting performance issues on Database level.
  • Database Audit and Implementing database security.
  • Generating & Analyzing execution plan for high resource intensive SQL and provide new indices information to development team to implement the required indices.
  • Configuring OEM DB console.
  • Build 12g physical Data Guard.
  • Performed DR test by flashback and switchover method.
  • Support SAN migration and disk maintenance work on ASM.
  • Automated Schema level refresh which executes from crontab.
  • Implemented regular Gather Stats Job based on the application requirements to collect histograms.
  • Apply database patch PSU on RAC every quarter of the year to make application team up to date.
  • Install Oracle wallet certificate on two node RAC database.
  • Monitored databases using 12c Cloud control /OEM.
  • Database RMAN backup strategy.
  • Add 12c cloud control agents.
  • Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, trouble - shooting, back-up and recovery, installations and configurations on an as needed basis.
  • Performed automated backups and scheduling using script.
  • Created users and grant privileges according to the requirements.
  • Creating and managing the database objects such as tables, indexes and views.
  • Raised SR and TAR with Oracle Support.
  • Performed Import and Export using Oracle Data pump utilities.
  • Experienced with space management and Security.
  • Good working knowledge of SQL, PL/SQL, and shell scripting.
  • Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
  • 24x7 operational environments.
  • Performed administrative maintenance, monitoring on oracle database systems in a global.
  • Very good knowledge about CITI Service Now Request and INC creating and CITI systems.
  • Worked on many database cloning tasks.

Environment: Oracle 11g /12c RAC, ASM, RHEL, AIX, RMAN, SQL*Plus, SQL, SQL Loader, Oracle OEM, Import/Export Data-pump, Data Guard.

Confidential, Irving, TX

Oracle DBA

Responsibilities:

  • Installing, upgrading and maintaining Oracle 10g/11g on Solaris and RHEL platforms.
  • Setup Data Guard from scratch
  • Migrated Data Center to new Data Center.
  • Maintaining databases from all the environments from all pre-production to production which are on RAC and monitoring the Analytics environment using Oracle Streams.
  • Extensive work in ORACLE 11g installation, configuration, and upgrading.
  • Experience with rolling upgrade to Oracle 11G RAC.
  • Performed Cross platform migration using transportable tablespaces and RMAN.
  • Performed Import and Export using Oracle Data pump utilities
  • Administered and maintained database security policies and procedures. Experience with administration of high-performance and large-scale multi-terabytes databases.
  • Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations on an as needed basis.
  • Add new nodes to RAC 11g Cluster to distribute the load.
  • Create, maintain and support Oracle 11g databases and instances
  • System Development Life Cycle (SDLC) methodology for designing, analysis, development and implementation.
  • Worked with lead DBAs for preparing cluster, configuring, installing Clusterware and Oracle
  • Build 2-node and 4-node RAC cluster.
  • Worked on EMC SAN with ASM.
  • Installation, Configuration, Upgrading, Migration and Maintenance.
  • Configure, maintain and deploy the Data Guard and grid control.
  • Installing and maintaining Oracle GRID CONTROL
  • Troubleshoot performance related issues.
  • Design and implement Auditing and other security features for the existing Production systems.
  • Worked with system administrators, business analysts in designing and implementing backup and recovery procedures using RMAN, SAN based backups using EMC BCVS
  • Raised SR and TAR with Oracle Support.
  • Add 12c cloud control agents.
  • Backup of database Logical and Physical (hot and cold) procedures and also using RMAN.
  • Worked on tuning SQLs to get better performance.
  • 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.
  • Typically involved in database Designing, creation and maintenance.
  • Created users and grant privileges according to the requirements.
  • Using 12c cloud control to setup jobs and setup alerts.
  • Installed uni directional GoldenGate
  • Experience in replication using Golden Gate and Materialized Views
  • Replication and Extracting data and applying on production database’s using Golden Gate
  • Using Enterprise Backup utilities for backup.
  • Writing scripts for backup and recovery.
  • Used transportable tablespace to migrated database from Windows to Linux

Environment: Oracle 10g/11g RAC, ASM, Red hat Linux 5.x, Solaris, RMAN, SQL*Plus, SQL, SQL*LOADER,Oracle OEM, Import/Export Data-pump, Data Guard.

Confidential, Detroit, MI

Jr. Oracle DBA

Responsibilities:

  • 24x7 production support for several mission critical systems which utilize multiple Oracle databases.
  • Installation of Oracle 11g RAC Databases includes CRS and Applying Patches.
  • Upgrading databases to Oracle 11g from Oracle 10g and 9i.
  • System Study & Analysis, Design & Development.
  • Created users and roles.
  • Used shell scripting for automation of job.
  • Migrated databases from Unix to Linux
  • Creating and managing the database objects such as tables, indexes and views.
  • Manage users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).
  • Installation of ASM into various storage parameters like SAN and NAS.
  • Oracle Database capacity planning, space management, storage allocation
  • Managed the flashback space and performed recovery of dropped tables and data using flashback recovery
  • Setup, configuration and maintenance of Standby Databases for disaster recovery, high availability and data protection.
  • Monitoring of tablespaces, indexes, memory and logfiles.
  • Monitoring of Listener and TNS names.ora files and storage space for better performance
  • Data Refresh in Test and Integration Databases using Transportable Table spaces.
  • Worked on Data Replication using Materialized views, Snapshot, Streams.
  • Worked on import/export, export datapump/import datapump and SQL- loader.
  • Installed and Implemented Backup & Recovery procedures. Implemented Hot, Cold and Logical backup plans.
  • Setup backup and recovery procedures using RMAN.
  • Migrated from non-ASM instance to ASM instance.
  • Configured Streams to capture propagate; apply changes in multiple databases.
  • Performed Database and SQL tuning by using various Tools like Statspack, TKPROF, Explain plan, AWR and ADDR.
  • Written SQL, PL/SQL programs such as functions, procedures, packages and triggers.
  • Database Planning and Designing which involves deciding about Logical Storage Structures and Forecasting Future Expansions
  • Configuring database with suitable block size, multiple pools and storage parameters for best performance. Upgrade from Oracle 10g to 11g
  • Create, maintain and support Oracle 11g databases and instances
  • Automate database administration tasks with Oracle Enterprise Manager 11g Database Control
  • Experience on RAC Installation and Administration on Oracle 10g environment
  • Optimizing the SQL’s for optimum performance by using TKPROF, EXPLAIN PLAN & TOAD.
  • Logical Backup/Restoration strategy of Export and Import.
  • Working with Data guard scenarios relating to physical standby databases like Scenario 1: Creating a Physical Standby Database on the Same System Scenario 2: Creating a Physical Standby Database on a Remote Site Scenario 3: Accommodating Physical Changes in the Primary Database
  • Security Administration and Creation of Users, Managing their roles and privileges.
  • Control user access and ensure database security through privileges and roles in Oracle 11g
  • Hands on experience of Oracle Real Application Clusters (RAC)
  • Creation and maintenance of high availability databases using many techniques including Data Guard and standby databases. Shell scripting experience.

Environment: s: Oracle 10g, Windows, Linux, SQL Server, SQL *Loader, SQL*Plus, Export, Import, RMAN, Unix Shell Scripts, Oracle Enterprise Manager.

Hire Now