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.