SUMMARY:

• Strong experience in Information Technology industry specializing in the arena of Oracle Database Administration and developed core skill sets in installation, configuration, upgradation and maintenance of Oracle Server 9i/10g/11g/12c on various operating systems
• Proficient in handling multiple portfolios including DB administration and IT infrastructure management, which includes building of server architecture for production, testing and development environments
• Experience in prototyping and doing proof of concept work for new architecture design
• Strong experience in 24/7 production, testing and development environments
• Expertise in implementing Oracle Label Security and controlling and monitoring user access
• Experience in Oracle table Versioning (Workspace Manager)
• Experience in Installing and configuring Oracle 12c and OEM.
• Implementation of High Availability solutions with Oracle 10g/11g RAC, Physical and Logical Standby Databases (Data Guard)
• Hands on experience with Installation, Configuration, Migrations, Oracle Data Guard, Backup and Recovery using RMAN, Disaster Recovery and Patching, upgrading and administering of Oracle Databases
• Functional expert in Cable TV, Telecom, Healthcare, State Govt. and Aviation domains
• Hands on experience in Amazon RDS and AWS (Cloud Service)
• Experience in FME software
• Proficient in Agile and Waterfall methodologies
• Experienced in performing installation and configuration of VMware ESXI for Server Virtualization
• Good experience in conducting performance tuning specializing in SQL tuning and database/instance tuning
• Experience in data modeling using EA(Enterprise Architect).
• Experience in Oracle Spatial Technology.
• Management expertise on implementing the most cost effective deliverables for specific client needs.
• Experienced in performing database replication using snapshots, materialized views and advanced replication methods with extensive knowledge of Oracle Workspace Manager and table versioning process
• Experience in creating and deploying ETL packages using SSIS to load various format data into data warehouse for OBIEE from MS SQL DB
• Expertise in applying Quarterly patches and CPU, PSU, One - Off Patches to update Oracle version and to fix the bugs using Opatch utility
• Working with Oracle Advanced security products like TDE, Wallet manager etc.
• Experienced in developing and implementing backup and recovery strategies using RMAN and other utilties on Oracle 11g/12c
• Good experience in Roll out deployment of new Data model and Application on a monthly basis
• Experienced in setting up/installation and configuration of release 10g RAC/11g RAC with ASM
• Experienced in setting up rack-based servers and associating SAN storage in co-ordination with hardware team
• Extensive knowledge of Oracle Architecture, SGA, PGA, Listener, TNS Names, V$ and DBA views
• Experienced in performance monitoring using Dynamic Performance Views, EM Performance Monitor and statspack

TECHNICAL SKILLS:

Operating Systems: Windows NT/2000/XP/2003, Oracle Enterprise Linux, RHEL 5, Fedora 14 and Cent OS

Language: SQL, PL/SQL

GUI Tools: PowerBuilder, Visual Basic 6.0 and Seagate Crystal Reports 8.

Tuning Tools: Explain Plan, SQL Trace, Spotlight, AWR/ADDM Reports

ETL Tools: SSIS, GoldenGate

RDBMS: Oracle 9i/10g/11g/12c

Others: JIRA, Clearcase, EA, Power Designer, Oracle DBA Studio, Backup Scripts and TOAD,OEM, DBCA, GRID CONTROL, Nagios

PROFESSIONAL EXPERIENCE:

Confidential

Oracle DBA

Responsibilities:

• Implementing Oracle Advanced Security using TDE, Data Discovery, Data Redaction and Data masking techniques
• Installation and configuration of Oracle Database 12c
• Working with the DBA team in configuring, provisioning and maintaining Databases
• Working with Oracle spatial database
• Upgrading and migrating the existing databases from11g to 12c.
• Configuring Oracle Dataguard
• Database Patching
• Design and Data validation for new application deployment
• Performing Data refresh between Prod and Dev/QA databases using RMAN and datapump
• Create and maintain proper documentation and procedures for the repeating tasks.
• Performing backup and recovery operations on databases based on requirements.

Confidential, Denver

Oracle DBA/ Information Architect

Responsibilities:

• Doing capacity planning of the proposed DB architecture in compliance with the license policy
• Installation and configuration of Oracle Enterprise Manager (OEM) Cloud Control 12c
• Working with the DBA team in configuring, provisioning and maintaining Databases
• Supporting the ETL (Informatica) Team on the data analysis and migration logic
• Resolved replication issues in Goldengate.
• Managing of Oracle geodatabase
• Oracle spatial data management including data validation and feature manipulation
• Rollout of Data Models and application deployment on a regular basis.
• Installed Oracle Clusterware to provide infrastructure for RAC and configured 2 node Oracle 11g RAC with ASM.
• Working with the developers in optimizing the queries and performing their tasks more effectively
• Design, Data Migration and Management of AWS cloud based performance-testing environment.
• Installation and configuration of Oracle 12c database and resource management using OEM
• Oracle Spatial data analysis and migration support.
• Monitoring Oracle 12c OEM console for performance optimization
• Create and maintain proper documentation and procedures for the repeating tasks.
• Performing backup and recovery operations on databases based on requirements.

Confidential,Washington

Oracle Database Consultant

• Responsible for analysis, support, maintenance and implementation of database in client location
• Configured Oracle Dataguard for data replication
• Provided technical expertise and support in designing database systems
• Executed cross platform migration of databases.
• Configuring and monitoring of Oracle database using OEM.
• User access and roles management in database
• Troubleshooting and fixing Goldengate errors.
• Setup and configured 2 node Oracle 10g RAC with ASM.
• Performed Oracle database upgrades from 10g to 11gR2
• Created RMAN Backup and Recovery scripts using UNIX Shell Programming and CRON
• Installed OBIEE on RHEL and configured RCU.
• Created ETL using SSIS for implementing Oracle BI

Confidential,CA

Senior Oracle DBA

• Installation, configuration and maintenance of Oracle databases on various platforms
• Provide Oracle and SQL Server database technology consulting services and solutions.
• Monitoring of server space and I/O
• Installation and configuration of Oracle Enterprise Manager (OEM)
• Rollout deployment of Data Models and application on a regular basis.
• Utilize Oracle Automatic Storage Management (ASM), Oracle Managed Files (OMF) and Recovery
• Manager (RMAN) to improve I/O performance, reduce administration overhead and provide a comprehensive backup and recovery strategy.
• Maintenance of Goldengate configuration
• Monitoring user access and management of user profiles
• Configure database backup (hot backup, cold backup and export/import).
• Involve in performance tuning based on issues reported.

Confidential

Senior Database Consultant

• Worked on implementing and testing disaster recovery system, using RMAN/Dataguard (physical standby) and custom written scripts
• Performed resizing of SGA and tablespaces, added data files as when needed.
• Managed disk and disk groups in ASM 10g/11g
• Setup classic capture replication using Goldengate
• Performed Oracle database upgrades from 10g to 11gR2
• Managing, troubleshooting and resolving oracle database, RAC and applications issues.
• Create and monitor user access policies and profiles.
• Prepare GoldenGate parameter files for Extraction and Replication.
• Ensuring Oracle license policy compliance while doing capacity planning
• Maintain focus on implementing the most cost effective deliverables for specific client needs.
• Automated RMAN Backup and Recovery through UNIX Shell Programming and CRON
• Cloned databases from production to test and development environments using RMAN

Confidential

• Involved in Oracle Spatial database configuration and schema creation
• Provided technical expertise and support in capacity planning and designing database systems
• Responsible for analysis, support, maintenance and implementation of database in client location
• Migrated 11g database from windows to Linux platform.
• Installed Oracle Clusterware to provide infrastructure for RAC and configured 2 node Oracle 11g RAC with ASM.
• Troubleshooting and fixing Goldengate errors.
• Configuring Oracle Goldengate Monitor
• Monitoring and maintenance of Oracle RAC environment
• Involved in configuring database backup (Rman, hot backup, cold backup and export/import).
• Involved in complete and incomplete recovery options using User Managed and RMAN
• Created and assigned roles, privileges and profiles to users.
• Setup and migrate the test database on Amazon RDS (AWS).

Confidential

Senior Oracle DBA

• Designed and modified database architecture to suit project requirements.
• Migrated existing data from Oracle 10g to 11g
• Provided technical expertise and support in designing database systems
• Deployed database in cloud based server architecture.
• Responsible for analysis, support, maintenance and implementation of database in client location
• Created databases and modified database structure.
• Configured database backup (hot backup, cold backup and export/import)
• Responsible for maintenance of replication mechanism based on Streams
• Executed complete and incomplete recovery procedures using custom scripts and RMAN.
• Created and assigned roles, privileges and profiles to users.
• Performing DB audit

Confidential

Senior Oracle DBA

• Conducted environment study to analyze present configurations
• Performed required steps to enable environment as DR ready
• Setup dedicated VPN between client and remote locations in US.
• Managed installation and configuration of Oracle on Linux 5.6 for recovery DB
• Configured Dataguard using Oracle 10g for replication
• Created custom scripts to monitor log apply and performance of DR.
• Configured database backup (hot backup, cold backup and export/import)

Confidential

Oracle DBA

• Analyzed present database architecture and provided suggestions for improvement.
• Co-ordinated the DB team in various installations and migrations
• Performed sample data migration for testing purpose.
• Installed, configured and maintained Oracle database
• Migrated the existing system data into new architecture.
• Configured backups using automated scripts
• Created standby servers based on requirements and criticality of data.
• Setup dedicated VPN between client and home office.