SUMMARY:

• Over 7 years of experience as an Oracle Database Administrator
• Worked on following projects
• Data Center Migration
• Upgrades
• Crossplatform Migration
• New client Builds
• Build and Administered RAC.
• Build Physical Standby Data Guard.
• Set up unidirectional Oracle Goldengate
• Familiar with oracle Exadata.
• Expert knowledge in SQL
• Worked on active Data guard.
• Refresh Databases using Data Pump
• Expertise in cloing databases using different methods
• Good Unix Administrative Knowledge
• Expert Linux Administation knowledge
• Good knowledge of RAID configuration.
• Build and manage ASM Volumes.
• Worked on Data Guard snapshot databases
• Worked on Performance tuning including:
• Statistic collection
• Reorg of database objects
• Instance Tuning
• SQL Tuning
• Analyze Various Reports
• Statspack
• ASH
• AWR
• ADDM
• SQL Performance Analyzer
• 12c Cloud control performance dashboard
• Invisible indexes
• Extensive work with 11g dynamic views & dictionary tables
• Worked on Capcity 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

T OOLS: 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

WORK EXPERIENCE:

Confidential, Hartford CO

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.
• 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

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
• Set up, 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: Oracle 10g, Windows, Linux, SQL Server, SQL *Loader, SQL*Plus, Export, Import, RMAN, Unix Shell Scripts, Oracle Enterprise Manager.