TECHNICAL SKILLS

• Over all 8 years of IT experience as an Oracle Database Administrator providing 24/7 production and development support of Oracle 12c, 11g ,10g and 9i.
• Proficient in Database Administration activities such as installation, database creation, sizing, RMAN backup and recovery, performance tuning and capacity planning.
• Experience in query optimization, cloning, patches, up gradation, migration, troubleshooting, TAR support, space management and UNIX Shell Scripting.
• Plan, install, configure and perform upgrades of Oracle software on various platforms.
• Implementation of high availability solutions with Oracle 10g, Physical and Logical Standby database Data Guard , Materialized views, Streams Replication, Golden Gate.
• Experience in database administration of OLTP and Data Warehousing applications.
• Experience with Systems Analysis, Design and Data Modeling.
• Excellence in Performance Tuning using STATSPACK, TKPROF, EXPLAIN PLAN, SQL TRACE, AWR, ASH, ADDM.
• Proactive monitoring, identifying areas that need to be improved in the application and database using AWR, ADDM and OEM Grid Control and TOAD.
• Experience in Hot and Cold Backup and Recovery, cloning of databases using RMAN
• Experience in ETL data using SQL loader, External Tables, ODI and GoldenGate.
• Task Automation using CRONTAB
• Worked on OLTP/DSS database systems, implementing and managing Large Oracle databases VLDB .
• Good Knowledge of SQL Server, MySQL.
• Good Knowledge of RAC
• Strong analytical and problem solving skills, a very good team player and also has the ability to work independently when needed and a quick learner of new technologies.
• Excellent written and verbal communication skills.

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA Developer

Responsibilities

• 4 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues
• Applied patches to Oracle Databases
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN
• Created the database objects based on the requirements for project requirement
• Performed Diagnosis Tuned database and SQL statements as and when required
• Created partitions indexes for better performance.
• Database Security and Auditing.
• Scheduled automated back-end jobs using CRONTAB
• Responsibilities include but not limited to daily configuration, Installation, administration, proactive monitoring and tuning, troubleshooting single instance databases on Linux Red hat Centos 5.3 . Regular backup, routinely checking alert log, trace files and monitoring space management.
• Provide technical support direction for database system enhancements, basic configuration, administration and maintenance.
• Migrated Oracle 8i on Windows server 2003 to 10g on unbreakable Oracle Linux using Exp/Imp'
• Upgraded Oracle 10g from 10.2.0.1. to 10.2.0.4 on Windows 2003 and Linux red hat 5.3.
• Upgraded Oracle 10g to 11.2.0.3 on Wind0ws 2003 and Linux red hat 5.3.
• Upgrade Oracle 11g to 12c on Oracle Linux using DBUA and transportable tablespaces.
• Cloned databases from one server to the other for test use, and refreshes of development environments as needed for upgrades from Oracle 10.2.0.3 to 10.2.0.4 and 9i to 11g using DBUA.
• Configure, Implement, document and test Oracle Data Guard, tuning for better database performance using Oracle's AWR and ADDM tools
• Troubleshoot and resolve Oracle or system errors trouble shooting or with Oracle's support through Meta link .
• Apply database CPU patches as recommended by Oracle.
• Configuring RMAN and implementing backups on Databases.

Confidential

Role: Oracle DBA, GoldenGate Administrator

Responsibilities

• Planed GoldenGate setup to achieve Uni-directional and Bi-directional replication
• Performed POC for testing DDL and DML replication across Databases
• Estimated SAN Storage needed for Replication across multiple sites
• Tested impact of multiple Extract and Replicat processes on a Single Node
• Prepared GoldenGate parameter files for Extraction and Replication
• Installed GoldenGate software in Test region to perform POC
• Investigated Replication failures using LogDump utility
• Tested initial Data Load option of GoldenGate during environment build
• Identified risks involved with replicating highly volatile tables with large data volume
• Setup GoldenGate Database Users with necessary privileges
• Created and configure Oracle Databases using both the DBCA and manually using database creation scripts.
• Created primary database storage structures tablespaces and objects tables, views, indexes etc. .
• Scheduled and perform various modes of backups using RMAN
• Monitor and proactively tuned Oracle databases via the OEM grid control 10g and 11g or using the Advisors SQL Access Advisor, SQL Tuning advisor, and SQL Repair Advisor or using scripts.
• Enhanced existing database designs for improved longevity, reduced maintenance, and improved performance.
• Database design, Maintenance, Configuration, Installation, Deployment and Administration using file system and ASM cluster file storage system.
• Assisted with the development and implementation of database architectures for new projects.
• Perform database migrations, conversions and upgrades
• Design, build, test, and deploy new/changed databases
• Maintained and administer databases and supporting automation e.g. database objects, security roles, capacity, performance tuning, import/export, alert rules
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Implement Hot, Cold and Logical backup plans.
• Work on High Availability, Backup and Recovery options.
• Design, implement and maintain database security procedures

Confidential

Role: Oracle DBA

Database: Oracle 9i,

Responsibilities

• Collaborate with the system Administrator to configure any software and hardware requirements that will function with the Oracle Database.
• Install and configure Oracle 9i and 10g on both Windows and UNIX platforms using OFA.
• Install and configure Oracle 9i and 10 and Enterprise Manager OEM on UNIX and Windows NT platform
• Monitoring and performance tuning in oracle 10g, 11g in Test, and Production environments on Oracle Enterprise Linux 4.5/5.2, Solaris and LINUX Red Hat 4.3
• Oracle ASM installation, configuration and administration on, Window server 2003, Oracle Enterprise Linux 5.2 in Test, Development and production environments
• Create and configure Oracle Databases using Oracle Database Configuration Assistant, manually by using SQL Scripts such as CATALOG.SQL, CATPROC.SQL, CATAUDIT.SQL for system security and the organization and easy identification of database files using the OFA database configuration method.
• Configuration and troubleshooting of SQL Net/Net8 utilities.
• Create database objects, Tablespaces, Application Users, Database schemas, profiles, granting privileges and roles, and create database links.
• Perform data migration using Oracle STREAMS
• Installed and used sql developer in test environment.
• Creating Stored Procedures, Triggers, scripting tables, views database objects
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Performed Data Modeling tasks and designed Entity Relationship Diagrams
• Performed 24/7 on-call duties, troubleshooting production servers, monitoring and performance tuning.

Confidential

IT Technical Support Associate

Responsibilities

• installing and configuring computer hardware operating systems and applications
• monitoring and maintaining computer systems and networks
• talking staff or clients through a series of actions, either face to face or over the telephone to help set up systems or resolve issues
• troubleshooting system and network problems and diagnosing and solving hardware or software faults
• replacing parts as required
• providing support, including procedural documentation and relevant reports
• following diagrams and written instructions to repair a fault or set up a system
• supporting the roll-out of new applications
• setting up new users' accounts and profiles and dealing with password issues
• responding within agreed time limits to call-outs
• working continuously on a task until completion or referral to third parties, if appropriate
• rapidly establishing a good working relationship with customers and other professionals, e.g., software developers