SUMMARY:

• Experienced Oracle Database Administrator with over 10 years of IT experience with hands on experience in database administration and production support of large database environments.
• Around 1 year of Experience as System Administrator.
• Experienced in configuring high availability environments using Dataguard and Golden Gate.
• Outstanding ability in performing DBA activities involving multiple phases of application life cycle including requirements gathering, database design and promotion of database changes.
• Hands on experience in Oracle software installation, Databases creation and Upgrades.
• Experienced in Database upgrades and application of PSUs and Critical patch updates.
• Good Experience in Database Backups and Recovery Strategies using RMAN. Performed Database clones using RMAN Duplicate.
• Experience of Oracle Golden Gate installation, configuration and maintenance of Oracle Golden Gate.
• Experience in automation of database processes using Shell scripting and SQL.
• Solid experience in monitoring database performance and recommending tuning suggestions.
• Implemented Data Guard with maximum availability, protection and performance configurations and worked with Data Guard Failover and Switch over cases.
• Good experience of setup & configuration of Oracle 10g and 11gR2 RAC two - node on Linux with ASM.
• Experienced in providing 24/7 support for database systems including performance monitoring, performance tuning, troubleshooting.
• Good communication with excellent analytical skills, willingness to learn and improve and ability to work within a team and independently.
• Periodic validation of oversized indexes and index rebuild when required
• Recommendations for SQL statement tuning for SQL statements that are identified as impacting production performance.

TECHNICAL SKILLS:

Databases: Oracle 12c, Oracle 11g, Oracle 10g, MongoDB

Engineered Systems: Oracle Exadata

Operating Systems: Sun Solaris, Red Hat Linux, Oracle Linux, Windows-98/NT/XP, MS-DOS

Languages: SQL, PL/SQL, VB scripting, Basic, C, Pascal, Unix Shell Programming

Tools: Enterprise Manager for Oracle (OEM),AWR, ASH, ADDM, RMAN

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, CA

Lead Oracle DBA

Responsibilities:

• Responsible for installation, configuration, support and maintenance of Test and Production Oracle RAC databases.
• Implemented Disaster recovery environment for production databases using Active Data guard.
• Configured the uni-directional replication using Golden gate between data centers
• Diagnosed Golden gate issues using log files such as ggserr, and utilities such as logdump.
• Propagated Database changes to all the environments in coordination with Release management team
• Perform refreshes of Dev and QA databases using RMAN Duplication.
• Responsible for Performance monitoring and tuning the database using OEM, AWR and ADDM analysis
• Experience in the development of database procedures, triggers and SQL scripts for development teams.
• Maintained users, roles and privileges in Oracle database for the development team.
• Worked with Oracle support to troubleshoot performance/system waits experienced in Online and Batch window.
• Dramatically improved performance in the database by implementing Partitioned objectsappropriately.
• Provided 24*7 On-call DBA support.

Environment: 12c,11gR2 RAC, RMAN, Data guard, Golden Gate (GG), EM Grid Control, Shell Scripting, Linux

Confidential

Oracle Database Administrator

Responsibilities:

• Administration of Oracle RAC and single instance environments.
• Configure RMAN and implement best practices for database backup and recovery.
• Performed Database refresh from Production RAC environment to Performance RAC environment
• Converted physical standby to Snapshot standby and back to physical standby as per business requirement
• Assisted in disaster recovery procedures and recovery using Data Guard in both 11gR2
• Applied Data masking through scrubbing scripts on the development database, post cloning from Production database
• Analyzed the problematic SQL’s through tools such as TKProf and EXPLAIN PLAN, to generate traces, interpret execution plans, identify performance issues, deadlocks/contention and resolve them. Utilized wide variety of Performance tuning tools such as AWR, ADDM, OEM advisors.
• Created Standards & Guidelines document for setting standards for database to follow across theproject.
• Co-ordinated with UNIX administrators for space managements on various servers.
• Work closely with application developers to implement best practices for coding and design, and providing SQL and PL/SQL expertise.
• Identified the indexes which are fragmented and rebuilt those to improve the performance.
• Participate in functional test planning and unit testing of SQL and PL/SQL programs.
• Used data movement utilities such as expdp/impdp to refresh the schemas and tables.
• Perform code reviews submitted by application team to ensure all standards are met.
• Assist in performance analysis and tuning, using various tools such as AWR and ADDM reports.
• Troubleshoot and resolve database connectivity issues.
• Support application developers with database operations including development of SQL, and creation of stored procedures.
• Maintain data integrity and security through managing roles and permissions of database users.
• Document database standards, guidelines and processes as required.
• Reclaimed lot of space on the Server through Archival of data, and cleanup of unused schemas.
• Worked in various financial modules like Oracle Assets, Oracle General Ledger
• Participate in on-call rotation for production database support.
• Experience in writing Shell scripts to backup, restore database and automate daily activities.

Environment: 12c,11gR2 RAC, RMAN, Data guard, ASM, Oracle Streams, Golden Gate (GG), EM Grid Control, Shell Scripting, Solaris, Linux

Confidential

Oracle RAC and Golden Gate Training

Responsibilities:

• Built a strong foundation on administration of Oracle 11g RAC and got a conceptual understanding of the Oracle RAC architecture and how its components work and interact with each other.
• Tested installation and configuration of RAC database on two-node Linux cluster.
• Conceptual understanding of various Golden gate topologies, and its components.

Confidential

Oracle Database Administrator

Responsibilities:

• Installed patches, performed database version upgrades co-ordinating with the Sr.DBA support.
• Creating user accounts and appropriate privileges as well as maintaining Database security.
• Enabled the Database in Archive Log Mode / No archive log mode.
• Modifying the database structure, as necessary, to support activities of application developers
• Created Database storage structures residing in Data Tablespace, Index Tablespace.
• Managing user, resources and privileges.
• Creation of Materialized views and partitioned the oracle tables to improve reporting performance
• Creating and dropping of Users, granting and revoking permissions to users/roles as and when required.
• Experience in performing system backups and restoration.
• Involved in doing Hot, Cold backup.
• Involved in doing RMAN backup.
• Backups using export and import of schemas.
• Used Stats pack for troubleshooting SQL query performance issues.
• Monitoring growth of tables and undertaking necessary re-organization of database as and when required capacity planning & benchmarking using analysis from STATSPACK reports
• Creation of development and test databases using export/import of full database.
• Conducted time-to-time analysis and monitoring of the software and hardware requirements and act accordingly.

Environment: 11gR2 RAC, RMAN, Data guard, ASM, Oracle Flexcube, Oracle Weblogic EM Grid Control, Shell Scripting, Solaris, Linux and AIX

Confidential

System Administrator

Responsibilities:

• Installed and configured secured environments, VPN Internet connectivity of virtualized server environment and clients.
• Managed and administered Windows/Linux systems - Performed periodic maintenance, provided technical support and executed systems engineering.
• Implemented proper recovery procedures for disasters and administered user-accounts mailbox.
• Maintained the timely back-up of important data and management resources.
• Assisted in the timely recovery of data lost due to software crash or hardware failure.
• Conducted periodic performance tests on existing servers.
• Managed and advised the deployment of new system designs.
• Monitored the LAN/WAN network environment including routers, switches, firewalls, Internet access and software applications.
• Performed troubleshooting and diagnosis to hardware/software network failures, and provided resolutions.

Environment: 10,000+ Windows 2003 R2/2008 R2/ /Servers 20000+ Windows 8/7/XP Desktops/Laptops, Exchange Server, Symantec Antivirus.