SUMMARY

• Over 7 years of experience as Oracle Database Administrator and over 3 years of SQL Server DBA
• Providing 24/7 on - call support
• Installed RHEL, setup configured 10g and 11g R2 Databases.
• Upgraded from 9i through 12c
• Migrated database from data center to another data center
• Performed hardware refresh.
• Applied CPU, PSU Patches,
• Worked with Oracle on issues.
• Used various methods of Backup and Recovery including user managed and RMAN
• Documented procedures
• Worked on Windows, AIX, Sun Solaris, HPUX, and RHEL with various flavors of Linux like CentOS, OpenSuse, Ubuntu etc.
• Performed various Instance Tuning activities like tuning SGA, PGA and memory parameters.
• Generated and analyzed statspack, ASH, AWR, ADDM to address areas of concern.
• Worked with Development team on gathering requirements and for performance tuning.
• Developed tip and techniques for capacity planning
• Poses expertise in Building RAC from scratch include OS deployement.
• Written Shell Scripts to automate jobs
• Provide DBA support with proactive monitoring using 10g 11g OEM and cloud Control.
• Experienced working with Golden Gate --Configure, Setup, Install, & support.
• Build multiple Oracle Data Guard environment for DR.
• Worked with Storage team to carve out partitions for ASM.
• Supported Oracle RAC with Data Guard environment.
• Familiar with Materialize Views set up and configuration for replication.
• Used Export/import and Data pump for data movement.
• Configured and Worked on Flash Recovery Area (FRA)
• Good understanding of Oracle Wait and Wait Classes.
• Used SQL Developer, TOAD for ERWIN as tools to manage databases.
• Good knowledge of explain plan and query tuning.
• Working knowledge on SQL Server 2005 and SQL Server 2008.
• Good knowledge on Management of schemas, objects & Partitioning teh tables & indexes.
• Build and administered Oracle GoldenGate uni-directional replication.
• Worked on Migration projects
• Used RMAN’s Duplicate Database feature to clone databases.
• Worked on Redo Log sizing to reduce waits.
• Identified performance bottlenecks and recommended usage of right indexing mechanism.
• Worked on consolidating databases project.
• Very good knowledge on Data Dictionary
• Poses working knowledge on PL/SQL

TECHNICAL SKILLS

Operating System: Linux, CentOS Window 2003/2008, Sun Solaris, UNIX, HPUX, AIX

Programming Languages: SQL, PL/SQL, SQL Tuning, Unix Shell Scripting

Databases System: Oracle 12c, 11g R2/10g R2/9i, MSSQL

Documentation Tools: MS Word, MS Excel, Microsoft Project, Visio.

Expertise: ASM, Data Guard, RAC, Repliction, Setting up Disaster Recovery

Tools: /Utilities Export / Import,SQL Loader,Data Pump,Explain plan,TKPROF,RMAN,OEM,Grid Control,Crsctl,Srvctl,asmcmd,TOAD

PROFESSIONAL EXPERIENCE:

ORACLE DBA

Responsibilities:

• Build Database Clusters using RAC
• Build standalone Database Servers
• Installed 10g, 11g and 12c
• Worked on Multitenant databases
• Performed various silent installs.
• Worked Storage team with configuring disk partiotions for ASM
• Configured Grid Infrastructure for database servers.
• Installed SQL Server 2005 and 2008
• Restored and recovered SQL Server databases.
• Set up Log shipping.
• Configured and installed with SQL Server Performance Dashboard.
• Familiar with SQL Data Dictionary Views.
• Set up Linked Servers.
• Worked with Project Managers to gather requirements.
• Worked with Development team to work on performance related issues.
• Configured Data Guard as a DR
• Provided 24*7 Production Environments.
• Managed databases upto 3 TB in size
• Cloned databases using “Duplicate Database” feature of RMAN.
• Worked on Database refreshes using exp/imp, Data pump.
• Manually restored and recoved databases on requests.
• Setup uni-directional GoldenGate for a schema level replication.
• Worked on Migration projects.
• Worked on Upgrade projects.
• Developed shell scripts and used cron to schedule jobs.
• Worked on Performance Tuning of instances and Bad SQLs.
• Used different tools like STATSPACK, AWR, ADDM, ASH, ANALYZE, EXPLAINPLAN, SQLTRACE and TKPROF to get to teh root of teh bad SQLs.
• Used SQL Loader to load data.
• Used RMAN to schedule backups to tapes and remote servers.
• Used and maintained bitmap indexes, materialized views, DB links
• Experience in partitioning and sub-partitioning
• Applied CPU and one off patches to CRS and RDBMS homes.
• Conducting sizing & capacity planning for Oracle databases.
• Used Oracle support and Meta Link are utilized to troubleshoot teh problems and issues.
• Provided on-call support.
• Proactive database monitoring using 11g grid monitoring tool.
• Good knowledge on optimizer, RBO, CBO,
• Used SQL Trace, Tkprof, Explain plan, Statspack, AWR, ASH and ADDM.

Environment: Oracle 10g, 11g and 12c, TOAD, SQL plus, OEM RMAN, Unix, Solaris 10, Oracle RAC, Data Guard, ASM, GoldenGate

Confidential

Chicago, IL

Responsibilities:

• Responsible for administration and supporting Oracle 9i and 10g R2 databases.
• Provide ON-Call 24*7 Production Database Support having 3 TB in size.
• Implemented Data Guard for maximum availability.
• Cloned databases using exp/imp and duplicated database.
• Upgraded teh database to 10g, configure ASM
• Applied CPU and one-off patch.
• Worked on Database Grants and Permissions.
• Monitors and manages database access, storage, and utilization using DB Console.
• Have written shell scripting.
• Managed database on RAC
• Perform production system problem analysis and recommend corrective measures in a timely manner.
• Worked in Tuning OS, Shared Pool, Buffer Cache, and Redo Log Buffer.
• Applied various recovery scenarios for complete and incomplete recovery in case of failure
• Performed Security administration tasks, setup users accounts, passwords, roles, profiles and quota
• Monitored data files, logical data storage and data growth activities
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc
• Planned and Performed Daily, Weekly and Monthly Backups. Tested and implemented restore procedures for complete and incomplete recovery using RMAN.
• Perform capacity planning required to create and maintain database environments.
• Supported 24/7 on-call pager support for mission critical financial databases.
• Involved in designing new structures/procedures/views/functions
• Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Experience with pre-production and production of Oracle 10gR2 with multi node RAC with ASM
• Performed Database Refreshes
• Designed teh database schema and create any necessary database objects.
• Used TOAD for various database Administration tasks.
• Used SQL*Loader to move data from flat files into an Oracle database.
• Used SRVCTL utility for managing multiple instances and nodes.
• Worked with Real Application Cluster (RAC) databases.
• Managed and multiplex Voting Disk and OCR file for maximum RAC availability.
• Configured and Managed ASM disks and disk groups thru both Grid Control and ASMCMD utility.
• Upgraded oracle clients as per application needs.
• Applied DST patches on multiple platforms.
• Created scripts to monitor database alert activities, growth, and key performance indicators.
• Created scripts to automate and standardize various database maintenance tasks.
• Provided guidance to developers on data design, query tuning and security issues.
• Provided technical troubleshooting and give consultation to development teams.
• Database space management and Reorganization
• Performance Tuning of teh Database for better memory, me/O and OS Performance
• Reallocation of tablespaces to accommodate growth in data volume
• Assisted development team in Application tuning, query optimization and troubleshooting
• Automated tasks using Bash shell scripts.

Environment: Oracle 10g/11g, UNIX, Linux (Redhat), Data Guard, RMAN, Shell Scripting.Oracle 10g, SQL Server 2005