SUMMARY

• Over 5+ Years of total Oracle Database Administration experience in implementing, Design, Development, Testing and Production support in all industry verticals exclusively Telecom, Financial, Pharmaceutical, and Insurance Industries.
• Performed backup & recovery of large databases and provided 24X7 production support to high critical databases
• Good exposure of Oracle DBA tasks Installation, Patching, Cloning, and Upgrade of Oracle Databases.
• Management of schemas, objects & Partitioning the tables & indexes, USERS and PRIVILEGES.
• Design, development, and testing of backup and recovery to ensure complete recoverability.
• Solid experience in disaster recovery, routine maintenance for Oracle databases.
• Good experience in Logical and Physical Database Design, Backup and Recovery procedures.
• Proficient in using OEM (Oracle Enterprise Manager), SQL* Net, SQL Navigator, TOAD, Spotlight, Export, Import, data pump.
• Expertise in maintaining Database Security using security compliance auditing
• Experience in ORACLE Database administration including capacity planning, space management, Rollback segments and Undo segments, User Management, Password Management
• Participated in appropriate consulting, interfacing, and training for users.
• Delivered associated documentation for user interaction with the database environment
• Performed database tuning which involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning.
• Experience in on - call support and 24x7 DBA support for production environment.
• Configured and maintained Physical Standby Databases for the Production databases using Active Data Guard Installation, administration and maintenance of Oracle 11g
• Worked extensively on Oracle Installation, Oracle Version Upgrade, Migrations (from 10g to 11g) and patching
• Extensive experience in installation and implementing OEM and TOAD and setup of Oracle Grid Control.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS).
• Experience in Configuring Single instance to multimode, Oracle Real Application Clusters (RAC) and Automatic Storage Management (ASM) and Data guard and Streams.
• Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.
• Experienced in Systems Testing, Integration Testing, and Software Quality Standards, Training, Documentation and implementation in a business environment.
• Worked extensively on created development, testing, staging, production, RAC and standby databases for OLTP and Data Warehousing using customized shell scripts and stepwise.
• Excellent knowledge in Hot/Cold Backup, Recovery, Cloning of databases using RMAN, VERITAS Net Backup and Experienced in Linux and Solaris using 11g network configuration (NETCA) Extensive experience in 7*24 production database support.
• Expert in systems analysis and architecture, capacity planning, backup/recovery, installation, configuration, apply patches, troubleshooting, performance monitoring and tuning.
• Worked on Oracle 12c and a good knowledge on Golden Gate.

TECHNICAL SKILLS

Software development methodologies: RUP, SDLC, UML

Front-End Tools: MS Excel, MS Word, MS Visio, MS Project

Databases: Oracle 11g, Oracle 10g Oracle Database tools SQL*Loader, TKPROF, Toad, OEM, ToadTKPROF, EXPLAIN PLAN, STATSPACK, AWRADDM, ASH, SQL, Developer, Grid Control

Operating Systems: Solaris 10/9/8, Sun Sparc, RHEL 5.X/4.XOEL, HP UX 11i, Windows 2000/2003 server

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Oracle DBA

Responsibilities:

• Wrote scripts to create tables, views, indexes and synonyms required meeting developer needs. Working with Java J2EE developers to develop and formulate capacity planning for 11g databases.
• Worked on in house installation of Oracle on different platforms, loaded user data to reproduce the problem, applied new Oracle patch, managed database backup using RMAN, upgraded Oracle database 10.2.0.4 to 11.2.0.1
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.
• Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
• Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.
• Involved in converting a single instance database to Oracle 11g, 10g RAC databases.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Involved in design and enforcing of standards in place to ensure that all application design and code is produced with proper integrity, security and performance
• Refreshed schema using Export/Import. Created the database, tablespace, tables, indexes, set privileges and user logins
• Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins.
• Creating physical databases with multiple table spaces from logical and physical data model
• Prepared scripts to tune developer SQL codes to maximize result return time
• Worked on large databases in Oracle 11g with multiple instances using Veritas Cluster.
• Performed cold and hot backup using Oracle's Data pump.
• Cloned databases using scripts as well as RMAN. Installation, setup and configuration of Data guard
• Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.
• Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
• Refreshed/cloned databases using RMAN utility.
• Performed Database upgrade from Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.
• Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration
• Data migration between databases using both Oracle 10g and 11g export/import utility and Oracle 11g exp/imp data pump.
• Performed hot and cold Backups.
• Scheduled daily Exports/Imports to serve as temporary backups.
• Installation and configuration of Oracle 10g and 11g Enterprise Editions, OEM with Oracle Diagnostic and Tuning packs.

Environment: Oracle RMAN, Oracle 11g (11.2.0.2), DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Confidential, Greenville, SC

Oracle DBA

Responsibilities:

• Managed Oracle Databases on Windows and Linux platforms.
• Resizing and reorganization of database objects: Tables, Indexes, Rollback segments and Redo log files of existing production and development systems. Resizing Tablespaces, Tables, indexes, Rollback segments.
• Design of databases following OFA: Creating Databases schemas, profiles, database links, Snapshots and Synonyms of objects as required to ensure data quality and security to comply with company's business rules. Oracle scripting in Windows/ Solaris and UNIX platform.
• Backup / Recovery methodology specification for mission critical databases
• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both Oracle 10g Grid Control & SQL*Plus, as well as UNIX shell scripts.
• Performed activities like monitoring the database and provide maximum uptime.
• Created and granted users the privileges and roles and resizing the datafiles to manage database growth.
• Defined and implemented database backup and security strategies, tested the backups periodically for consistency and reliability
• Identified long-running database queries, refining queries for better performance, and working with end- users to implement changes
• Created primary database objects (tables, views, indexes) once application developers have designed an application
• Monitored the alert logs and troubleshot the errors.
• Scheduled the backup jobs such as export through cron job in UNIX environment.
• Rebuilt indexes and analyzed tables to ensure good performance of database.
• Installed Oracle 9i and 10g on multiple platforms.
• Performed up-gradation of 9i to 10g.
• Performed traditional Cold backup in appropriate environments via OS commands as well as logical exports.
• Created the database objects such as Tables, Indexes, Views, Database Triggers, Procedures, Functions, etc.,.

Environment: Oracle 10.2.0.1, Oracle 9i (9.2.0.8), RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN, HP-UX 11, Sun Solaris 10.0

Confidential, Birmingham, AL

Network Engineer

Responsibilities:

• Computer Hardware/Software installation
• Computer maintenance and repairs
• Policy configuration and management of firewalls
• Troubleshooting a variety of computer issues
• DNS changes as per client requests
• Planning about new product requirements, Contacting Vendors for product purchases
• Configuring computer network
• Integration of Cisco IP-Phones with Switches in VLAN environment
• Contacting Service providers to troubleshoot issues on WAN connectivity
• Setting up computer security measures
• Involved in planning and designing team for network upgrades/changes
• Responsible for implementation of new network infrastructure includes Cabling, Switching, Routing
• Establishing MAN Connectivity between their different braches
• Involved in Loop back tests and troubleshooting issues during establishment of T1 Line
• Dynamic VLAN implementation using IEEE 802.1x protocol and RADIUS Server
• Configuring NAT Policies, Global VPN Client Policies
• Establishing Site-Site VPN Connections
• Enabling high-availability and high-capacity features such as Spanning Tree and link aggregation on Switches
• Responsible for service request tickets generated by the helpdesk in all phases such as troubleshooting, maintenance, upgrades, patches, fixes, and all around technical support
• Configurations and Maintenance of various Switches, Routers, Firewalls and Wireless Access Points at different client locations
• Responsible for interaction with third party technicians on site
• Performed network support involving daily wiring maintenance of cabling, switch maintenance, network port re-enabling, and cable room
• Documentation of all new software installation procedures, troubleshooting procedures

Environment: Cisco 2900, 3560, 1800, 3700, 3800, 7200, 2900, 3500