SUMMARY OF QUALIFICATIONS

• Oracle Certified Professional / Microsoft Certified in database administration, offering over 12 years' qualitative IT experience and 10 years as Oracle/SQL providing 24/7 support of both development and production Oracle 12c/11gR2/11gR1/10gR2/10gR1/9i/8i RAC and Non-RAC databases on Various physical and virtual Platforms
• Over 5 years of experience provide support for MS SQL databases 2000/2005/2008/2012 versions on windows 2000/2003/2008/2012/2014.
• Hands on experience on SSIS, SSRS, Profiler, Tracing, DB Mirroring, Log Shipping and Replication.
• Over 6 years of experience working with Oracle RAC Real Application Cluster and ASM, completed 4 projects on RAC configure, implement and support.
• Over 6 years of experience installing, configuring and supporting oracle databases on SAP applications.
• Over 8 years of experience installing, configuring and working with oracle data guard physical standby and have successfully completed 5 projects.
• Over 8 years of experience in database reorganization, developing SQL Queries, Stored Procedures, Backup and Recovery, Troubleshooting, UNIX Shell Scripting, Documentation and End User training
• Over 5 years of experience working with Oracle Golden Gate, Quest SharePlex, Oracle streams with complete end-to-end support for Basic Advanced Replication Configure, Setup, Install, support
• Over 9 years of experience handling large databases using various technologies i.e. BCV Business Continuity Volume . Capacity Planning of such databases
• Expert in Performance Tuning and performance strategy of Database, SQL queries using TKPROF, Explain Plan, AWR, ADDM
• Over 9 years of experience in performance tuning of production and development databases
• Over 9 years of experience in developing efficient database backup recovery strategies
• Proficient in Database Administration activities such as Upgrades, Patches, CPUs, PSUs,TAR support, Cloning, duplicating, Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation
• Excelling experience in Installation, Setup and configuration of Oracle 10g, 11g, 12c in HP-UX, SUN SOLARIS, UNIX/LINUX and Windows environment
• Provide DBA support with proactive monitoring, identifying areas that need to be improved in the application and databases using Statspack, AWR, ADDM, and 11g OEM Grid Monitoring
• Experience in Installation and configuration of Oracle 11g on HP-UX, Solaris and Linux
• Hands-on Automatic Memory Management for an ASM instance
• Experience in using SQL Performance Analyzer to tune the database
• Knowledge in using Database Repair Advisor - a wizard/expert system that guides DBAs through the fault diagnosis and resolution process
• Experience in Installation, configuration of Oracle 11g RAC also used Oracle 11g features like RAT, Database Replay, SPA, SPM, Real-Time SQL Monitoring, Data Pump, Flashback technology, AWR, ADDM, Grid Monitoring, Recycle Bin and Transportable Tablespaces
• Experience using enhanced features in 12c like Real Application Testing, Table and partition recovery using RMAN, Invisible columns, DDL Logging
• Experience using 12c pluggable and container databases PDBs and CDBs .
• Excellent experience in using OEM, TOAD, Data Migrations using Export/Import,Data Pump benchmarking using load testing tools
• Experience with Data Modeling, Logical and Physical database design
• Management of schemas, objects Partitioning the tables indexes
• Performed backups and tested crash recoveries using conventional cold, hot RMAN backups
• Proficient in performance tuning using Explain Plan, STATSPACK, SQL TRACE, TKPROF, ADDM
• Efficient and best business practice RMAN Backup Strategy to Disk and Tapes
• Excellent experience in OLTP/DSS database systems, implementing and managing Large Oracle databases VLDB
• Knowledge on Oracle Support processes for technical requests through Metalink and other Support Procedures
• Familiar with Oracle Exadata.

TECHNICAL COMPETENCIES :

• Operating System : HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, IBM AIX 5.1, 5.2,5.3, 6.1, 7.1 RHEL2.1, 3.x, 4.x, 5.x, 6.x, Windows2000/ 2003/2008/2012 servers
• RDBMS : Oracle 8i/9iR1/9iR2/10gR1/10gR2/ 11gR1/11gR2/12c,
• SqlServer 2000/2005/2008/2012
• Languages : SQL, PL/SQL, UNIX Shell Scripting, PERL Scripting,C, C , VB, Java, FORTRAN, FoxPro
• Tuning Tools : TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, ASH
• Tools Utilities : RMAN, OAM, OEM, EXP, IMP, Data Pump, TOAD, SRDF, SQL Loader, Oracle Golden Gate, Oracle Streams, Shareplex, Data Guard Broker, RMAN
• Other : EMC, HP OmniBack, Veritas NetBackup, IBM TSM, NetApp, SOX, Oracle Vault

PROFESSIONAL EXPERIENCE:

Confidential

Sr Database Administrator/Architect

Environment: Oracle 9i, 10g /11g/12c with RAC, Oracle Golden Gate, Oracle Data Guard, RMAN, AIX 5.5/6.2, RHEL 6.x, TOAD, SQL Developer, MS SQL 2000/2005/2008/2008R2/2012 with Cluster configuration. Approx 300 Oracle Servers 1500 MS SQL Servers.

Applications Kronos, Cerner, Epic, Meditech, Allscripts etc

Roles Responsibilities:

• Oracle MAA: Installed, Configured, Setup, Maintained and Supported Oracle 10gR1, 10gR2, 11gR1, 11gR2 RAC, Physical and Logical Standby database for Test, Development and Production
• Involved in 24x7 on-call support for production 10g and 11g RAC databases using Oracle Enterprise Manager Grid Control Alert Monitoring and Notification System, SCOM monitoring
• MS SQL HA : Installed, configured, setup, maintained and supported MS SQL 2000, 2005, 2008, 2012 for Test, Development and Production.
• Successfully completed 10-12 projects for MS SQL Server Cluster design/architect configuration for 2 nodes and 4 nodes, active-active, active-passive.
• Configuration of MS SQL SSMS, SSRS, SSIS. Configured the MS SQL mirroring, replication.
• Successfully completed RAC and golden gate configuration projects
• Involve in meetings with top IT management to discuss platform migrations which involves migrating the databases to VMWare Clouds or Physical Servers.
• Discuss with Oracle Corp for licensing of new products
• Built Oracle MAA Physical Standby and Logical Standby and configure Data Guard Broker for High Availability/Disaster Recovery purpose
• Perform planned switchover and failover to physical standby database with and without Data Guard Broker to verify availability status
• Oracle Streams and Shareplex for Basic and Advanced Data Replication between Oracle Database Servers and Legacy Databases
• Extensively used Oracle 10gR2 new features automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file tablespaces, new EM Grid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, Flashback Database and several others
• Monitoring and Troubleshooting of Database Replication issues
• Performance Tuning of Oracle Database Objects using tools like EXPLAIN PLAN, SQL TRACE, TKPROF, STATSPACK for optimized results
• Working with Application Development team to address any issues they encounter and provide support and resolution action plan
• Resolve lock/latch and resource contention issues during production hours
• Performed database Cloning to setup test and development database
• Rebuilding of Indexes for better performance, maintenance of Oracle Database
• Reorganization of database / schema / tables
• Troubleshooting Data Guard archive gaps
• Creating and Managing Tablespaces with different block-sizes to prevent row chaining
• Write SQL scripts to monitor table space and extent growth
• Applying Critical Patch Update CPUs / Patch Set Update PSU every quarter in rolling mode with no downtime and applying Grid Patch GI yearly
• Data refresh from production to test and development
• Installing and configuring Recovery Manager RMAN efficient backup strategy to disks and tapes using best business practices
• Setting and Installing Oracle Enterprise Manager OEM and Enterprise Backup Utility
• Setting up new Development Production environments.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate
• Automation of Startup Shutdown on all Production and Development Database
• SQL Tuning for Performance of Objects
• Migrated MySQL database to MS SQL
• Platform across migration upgradation - Oracle on AIX to Linux, Solaris to Linux

Confidential

Senior Database Administrator

Environment HP UX/Solaris/Linux/Grid Control 11g 12c/Windows, CommVault backup tool, HPUX OVO monitoring, Shareplex, SOX databases, OEM, Grid 11g/12c, Citrix, Veritas clusters

Responsibilities:

• Provide DB administration support to approx. 150 Production databases as a Primary contact person 24/7 . Total DB support for 250 which includes SAP Oracle databases on various platforms i.e. HPUX/Solaris/Linux/Windows as well on clusters. Oracle versions 11gR2 / 10gR2 and some of the databases 9.2.0.8 which are SOX compliance
• Provided DBA support to SAP application databases
• Configuration of RAC 11g on Linux platform and upgradation from 11.2.0.1 to 11.2.0.3
• Configuration/upgrdation of dataguard set up, creation of physical standby databases / logical standby databases, snapshot database, flashback, active dataguard
• Database Creation, developing SQL Queries, Stored Procedures, deploying PL/SQL scripts, procedures
• Oracle database upgraded from version 10.2.0.4 to 11.2.0.2 / 11.2.0.3 on Linux / HPUX platforms
• Migration of databases from Solaris to Linux, 10g to 11g
• Virtualized from physical servers to virtual servers
• Planning and Applying patches PSU / CPU on the databases including RAC/Data guard quarterly
• Installation / Database refresh / Schema refresh / cloning etc. as and when required
• Backup configuration using RMAN / expdp / hot back up, backup monitoring/scheduling tool 'CommVault'. Sorting out the backup failures, recovery scenarios after a result of table deletion / wrong execution of script and all
• Database tuning using OEM 11g / OEM 12C / Tracing / AWR / ASH / ADDM / TKProf / Sql Profile / Sql Plan Management SPM / Sql Access Advisor and various dynamic views, statistics/matrix views
• Troubleshooting the dataguard sync scenarios, archive gap, sorting out the issues.
• Database re-organization / table re-organization on fragmentation.
• UNIX Shell Scripting for various backup / refresh of database from production to testing/development for cloning / renaming of database/applying PSU/CPU etc.
• Replication using ShaePlex / golden gate.
• Using the encrypting tools of Oracle i.e. TDE/SQLNET/SSL Wallet
• Documentation tickets i.e. SOX auditing / Discovery process compliance tickets
• Disaster Recovery tests half yearly
• On-call on rotations / flexibility in working on holidays.
• Documentation and End User training

Confidential

Senior Oracle DBA

Environment: HP UX/Windows/Linux RHEL 4/5, Applications - CRM, JDE, SAP, HRM, SEIBEL, Dataware Housing, Informatica, Cognos

Team Size: Global Support 150

Responsibilities:

• Provide DB administration support to approx. 3500 databases on various platforms i.e. HPUX/Solaris/Linux/Windows as well on clusters. Oracle versions 11gR2 / 10gR2 /9i/8i includes SOX compliance databases.
• Configuration of RAC 10g/11g on Linux platform.
• Configuration/upgrdation of dataguard set up, creation of physical standby databases.
• Golden Gate configuration, troubleshooting
• Database Creation, developing SQL Queries, Stored Procedures, deploying PL/SQL scripts, procedures
• Backup configuration using RMAN / expdp / hot back up. Sorting out the backup failures, recovery scenarios after a result of table deletion / wrong execution of script and all.
• Database design/architect/implement liaisoning with storage/Unix/middleware teams and finally implementing as per customer requirement
• LDAP / Listener configuration on new installation/upgradation
• Db refresh/ schema refresh using exp/imp and data pump.
• Creating Database Links / packages etc depending upon the customer requirement.
• Upgradation/migration from 9i to 11g, 10g to 11g on Linux / HPUX platforms/Salaris which includes platform change.
• Planning and Applying patches PSU / CPU/SOX quarterly
• Installation / Database refresh / Schema refresh / cloning etc. as and when required
• Disk image backup using BCV Business Continuity Volume for large databases i.e. in TB sizes. Capacity Planning of large volume databases
• Database tuning using OEM 10g/11g Tracing / AWR / ASH / ADDM / TKProf / Sql Profile / Sql Tuning Task/ Sql Access Advisor and various dynamic views, statistics/matrix views
• Troubleshooting the dataguard sync scenarios, archive gap, sorting out the issues.
• Database re-organization / table re-organization on fragmentation.
• UNIX Shell Scripting for various backup / refresh of database from production to testing/development for cloning / renaming of database/applying PSU/CPU etc.
• Database modeling Data warehouse and OLTP environments
• Using the encrypting tools of Oracle i.e. TDE/SQLNET/SSL Wallet
• Documentation tickets i.e. SOX auditing / Discovery process compliance tickets
• Disaster Recovery tests half yearly, to build scratch onwards i.e. to build OS ->Network configuration -> install oracle software -> restore backup from tap -> restore the database -> check the connectivity from the end users.
• On-call on rotation
• Process Oriented Environment, following ITIL / ITSM / ICFR processes, SOX compliance, security/auditing/documentation

Confidential

Senior Oracle DBA

Responsibilities:

• Migration of databases from various environments i.e. Windows/Unix of various versions i.e. 8i/9i/10g/11g from NA US to MOPS
• The migration was Physical to Physical / Physical to Virtual / Virtual to Virtual
• Installation of oracle software/database
• Decommissioning removing of software/database
• Ensure all the scripts i.e. backup/scheduling are configured
• Using the encrypting tools of Oracle i.e. TDE/SQLNET/SSL Wallet
• LDAP / Listener configuration on new installation/upgradation
• Coordinating with various agencies i.e. L1/L2/Backup Team/Scheduling Team/Unix Team and updating client for achieving the database date
• Process Oriented Environment, following ITSM processes, SOX compliance, security/auditing/documentation

Confidential

Designation: Oracle DBA

Responsibilities:

• 10g Upgradation and Migrations
• Configured 10gR2 RAC / node addition / node deletion/ administration
• Applying patches for up gradation
• Generation and analyzing AWR / STATSPACK report
• Managing Database users/schema, Tablespace, Database Security
• Gathering statistics of database on weekly basis
• Migration / upgradation from 9i, 10g to 11g
• Configuring RMAN policies for backup/restore and synchronizing it with Catalog Database with the help of automated scripts
• Carrying out Performance Tuning of Databases using SQL tracing, AWR, Explain Plan, and Query Optimization's tuning and Disaster Recovery
• Writing the shell scripts for the automation of daily database activity
• Configuration of online hot and offline cold , Export Logical backup
• Analyzing tables and indexes for better performance, Rebuilding and reorganizing Indexes/Monitoring Indexes
• Troubleshoot database related errors and abnormalities and performed database corrective actions after normal business hours
• Capacity planning.
• Performing any corrective actions required to address errors raised in the log files. Consistently monitoring the log files/trace file
• Establishing the connectivity between Servers and Clients Using Network utilities
• Estimation of system storage for the current and future requirements
• Weekly Monthly Reports on Performance, Issues Capacity Planning for Management.
• Writing the shell scripts for automation
• Onsite support and maintenance of the database as DBA on regular basis
• Maintaining Documentation as per the standard
• Enhanced the application performance by proactive tuning of database

Confidential

Role: Database Administration, Development

Responsibilities:

Ensure readily availability of required information from the database.