SUMMARY:

• 18 + years of work experience as Team Lead/Project Lead/Senior Database Architect/Senior Exadata & RAC DBA/Exadata DMA. Extensive experience in supporting mission critical very large 10g/11g RAC/Exadata X2, Exadata X3,Exadata X4, Exadata X5 and Exadata X6 databases with up to 100TB database size. Installation and configuration of oracle 7.x,8,8i,9i,10g,11g,10g RAC,11g RAC, 11g Active Standby 12c,12c RAC, 12c RAC with ACFS and Exadata. Extensive experience in Performance tuning capacity planning, database performance optimization, high availability, database upgrades and migration, backup and recovery, disaster recovery. Experience in supporting OLTP and OLAP.
• Installations/Configuration/Migrations: Install and configure 2, 3, 4, 5 node ORACLE 10g,11g, 12C RAC on LINUX, SUN, AIX with ASM and Oracle Clusterware /Grid Infrastructure. Installed and configured Oracle 9i, 10g, 11g on Sun, AIX, HP - UX and REHL. Installed MS SQL server 2005, 2008 on windows. Migrated oracle 8i to 10g/11g, 9i to 10, 10g to 11g .Performed cross platform migrations from SQL server 2000 on windows to oracle 11g.
• High Availability/Business Continuity/Oracle RAC/MAA/DataGuard/Exadata X3, Exadata X4 Exadata X5 and Exadata X6: Extensive experience configuring and supporting Highly Available environment. Installed configured and provide support to oracle 11g RAC,10g RAC,11g Active standby,10g Data Guard, Golden Gate, SharePlex, Streams, Materialized Views, 2*2 node HACMP on AIX, 2 node VERITAS Cluster on Solaris. Design and implemented DR Sites and perform DR Drills.
• Exadata/RAC/Database Architect, Designs, Database Monitoring and Advance Performance Tuning: Monitoring database performance, identifying tuning errors ranged from physical I/O tuning, memory cache optimization, application tuning, OS/SQL tuning. Extensively used OEM tuning tools like ADDM, SPA, STS, and SQL Profiles. Monitored database health using tools like 11g/12C OEM, Tivoli TSM, Quest TOAD, Foglight.
• Backup and Recovery: Implemented robust hot backup strategies using RMAN for 40+TB database size. Used 11g compression. Experience in configuring and scheduling backups thru Enterprise Backup Tools like TSM, and VERITAS Netbackup. Extensive experience in complex recoveries with minimal downtime and data loss.
• Database Upgrades and Migration from Exadata X2 to Exadata X3, Exadata X4 and Exadata X5: Migrated more than 100+ database to Exadata. Upgrade the 10g RAC 4 node database to 11g RAC. Followed the Oracle/SAP Recommended procedure to upgrade by upgrading the CRS, ASM, and RDBMS. Also created an 11g active standby database. Used the 11g R2 ASM new features. Performed production non RAC 8i and 10g database upgrade to 11g 11g R2. Extensive experience in supporting post upgrade task/bugs/performance issues .Extensive experience in Support Exadata X2, Exadata X3, Exadata X4 and Exadata X5 systems.
• Database Consolidations/Data Center Relocation/Setup/DR Testing: Consolidated database by decommissioning and retiring legacy and small instances to larger more robust ones. Setup from scratch a new Database for a telecom client. (50+ IBM Blade and p550, 590 SERVERS, TSM, Multiple DS8000 storage, Oracle 9i RAC and AIX .Relocated the Confidential Datacenter with RAC database migration. Consolidation/Migration of database on Exadata.
• System Administration: Experience includes System Administration on IBM AIX5.2 (HACMP), SUN Solaris 8/9/10, Red Hat Linux AS4, tru64 and MS Windows. Build P 590/595, Dell/Compaq servers. Configured LPAR, HACMP, VERITAS Cluster, TRU Cluster, Tuned performance and take backups thru TSM, VERITAS Netbackup. Solaris Containers, Solaris Zones, Exadata Cells, Exadata X2,Exadata X3,Exadata X4 and Exadata X5.
• SAP/ORACLE APPS/SIEBEL Support/People Soft: Extensive experience in supporting SAP ECC,SAP CRM,SAP BW,SAP PORTAL,SAP SOLUTION MANAGER,SAP PRAYER DIRECT,SAP TDMS,SAP GRC,SAP TREX. Oracle APPS server 11.5.8, SEIBEL 7.6, PeopleSoft and 100+ SAP instance to 11.2.0.4
• Cloud Architect/Amazon AWS/Microsoft Azure/Oracle Cloud: Expertise in designing, Implementing and Supporting Cloud Based Solutions for RDBMS Database, NOSQL Database, Hadoop using Microsoft Azure, Amazon AWS, and Oracle Cloud. Expertise in migrating Oracle DB to Microsoft Azure, Amazon AWS and Oracle Cloud. Expertise in Design, Architect and Build a cloud based Database Solutions on Microsoft Azure, AWS, and Oracle Cloud.
• Big Data Hadoop: Experience in Big Data, Hadoop Ecosystem and Advance Analytics concepts.
• NOSQL MongoDB, Cassandra: Experience is supporting NOSQL, NOSQL MongoDB and Cassandra databases
• Data Science: Experience in Supporting database related support to Data Scientist's.
• Golden Gate and SharePlex: Extensive knowledge of Quest SharePlex and Oracle Golden Gate replication tool.
• Change Control/Change Management: Experience using Remedy, PPM, HP PPM and CA UniCenter.
• SQL Server 2000,2005 and 2007: Responsible for supporting 100+ SQL server database as a secondary DBA.

TECHINCAL SKILLS:

RDBMS: Oracle 12c/11g/10g/9i/8i,7.3,SQL Server 2005/2000/2008 , SAP HANA.

Operating System: AIX 5.2/5.3/5.4,SUN Solaris 8/9/10, Red Hat LINUX, TRU64, HPUX.

Cloud Solutions: Microsoft Azure, Amazon AWS, Oracle Cloud.

Languages: SQL, PL/SQL, C, C++, UNIX SHELL, J2EE,ABAP

Storage: IBM DS 800, IBM DS 4300, EMC, SUN, Netapp, EMC Symmetrix/CLARiiON, Exadata

ERP & CRM: SIEBEL,Oracle APPS, PeopleSoft,SAP ECC,SAP CRM,SAP BW,SAP SM,SAP GRC. Replication/DR 11g Active DG, 10g Data Guard, Quest SharePlex 4.7,5,6. Oracle Streams, Golden Gate.

TOOLS: TSM,ASM, VERITAS Netbackup, OEM,OCR,IBM HACMP,TRU64 CLUSTER,VCS/Sun Cluster for SUN, TOAD,TKPROF,SQL*Trace, Quest Foglight, Quest Spotlight, Quest Performance Analysis, Autosys, Weblogic, BCV, Swing bench, VERITAS Cluster, SRDF, SAP BR Backups, Hitachi. Double Take.

Other Software Used: ER-Win, Quest LiveReorg, Business Objects, IBM WEBSPHERE, MSIIS 4.0,Charles River db. MicroStrategy, PAM, Open Link, Golden Source, SAP,SAP on Exadata, OID,OIM, Oracle ZFS.Hadoop,Redshift,SAP HANA.

PROFESSIONAL EXPERIENCE:

Confidential, Issaquah, WA

Team Lead /Senior Database Architect /Exadata Database Machine Administrator/SAP Database Architect

Responsibilities:

• Responsible for Supporting/Migrating/Maintaining the Oracle Databases on Exadata Confidential ’s OLTP Systems and Huge Data Warehouse application. Perform evaluation/testing/benchmarking/reviewing of Oracle Exadata for SAP databases.
• Extensive experience in supporting Exadata X3,Exadata X4, Exadata X5 and Exadata X6.
• Design and Implemented the High Availability and Maximum Availability architecture for Confidential mission critical databases using Exadata Full RAC capabilities, DataGuard, Database Flashbacks, Database snapshots, Database restore points, Application level load balancing though Services.
• Expert/Extensive experience in supporting SAP ECC,SAP CRM,SAP BW,SAP PORTAL,SAP SOLUTION MANAGER,SAP PRAYER DIRECT,SAP TDMS,SAP GRC,SAP TREX.
• Responsible for Supporting Confidential 's mission critical database as primary engineer. Extensive experience and knowledge of all SAP.
• Responsible for performing the Confidential 's SAP databases migration from UCS Blades to Exadata X3,Exadata X4 and Exadata X5 systems with minimal downtime and DB upgrades:
• Reviewing the Oracle 12c In-Memory options for SAP Database. Install and Configure 12c RAC environment. Upgraded the SAP databases for 12c RAC for SAP environment.
• Database Tuning on Exadata, RAC,Non RAC and SAP: Responsible for leading the tuning initiative for SAP oracle databases on Exadata, Oracle RAC. Tuned the database by using the following tools and methods - reducing block re-mastering, reducing global cache contention, index rebuilds, index creations, AWR reports, ASH Reports. Maintain Exadata Stats, Maintain SAP Delivered Stats, SQLT, SQL Profiles, Stored Outlines, SQL Baselines, Used the 11g ASM new features.SAP Index Compression, SAP Table Compression.
• Responsible for Tuning SQL's for business critical system. Extensive experience in tuning complex application queries by Creating Btree Index, Hash Indexes,Reverse key Indexes, Function Based Index, SQL PROFILES,SQL Baselines, SQL Baselines for consistent SQL Plans, Result Cache Hints,10046 TRACE,10053 TRACE. Extensively used OEM,ADDM,ASH,SQL Tuning Advisor to tune SQL's. Used Oracle advance tuning method on Exadata like Exadata SMART SCAN, Exadata HCC Compress, Effectively using Exadata Flash ache.
• Responsible for creating the 11g RAC database for with ACFS. Created more than 6 five node RAC database as per Confidential 's business requirement. Configure ACSF as supported method for SAP Databases on RAC, Configure TAF for failover and database services for application level partitioning.
• Upgraded more than 150+ SAP database. Responsible for frequent Database refresh of SAP Databases.
• Responsible for applying SAP Bundle patch on Exadata and Non Exadata environments. Responsible for frequently applying SAP nodes based on OOS Notes recommendations.
• SAP HANA, SAP DBA Cockpit and SAP Tools: Extensive experience with SAP frontend tool to optimize the SQL's,
• Troubleshoot performance related issues. Installation and Configuration of BRTools.
• Extensive Experience in Using BRTools for database maintenance activities like tablespace monitoring, Stats collection methods, dictionary stats, systems stats, BRTools database and table space re-orgs, Extensive experience in supporting Oracle Instant Client. Oracle to SAP HANA Migration. SAP HANA Performance Tuning. SAP HANA HA Configuration. SAP HANA Backup and Recovery.
• SAP HANA Database Patching. SAP HANA Database Upgrade. SAP HANA Side CAR. SAP HANA Tuning the SLT replication. SAP HANA database security. SAP HANA Installation and Configuration. SAP HANA Studio. SAP HANA Replication. SAP HANA replication using service guard.SAP HANA SQL Tuning. SAP HANA PlanViz.
• Responsible for reviewing and fixing Exacheck. Monitor Exadata from OEM.
• Provided 24X7 support for Confidential database by off hours on call.

Environment: Oracle Exadata X3,Exadata 4,Exadata X5, 11g RAC, ZFS, CommVault, SAP ECC,SAP CRM,SAP BW,SAP PORTAL,SAP SOLUTION MANAGER,SAP PRAYER DIRECT,SAP TDMS,SAP GRC,SAP TREX,BODS, Informatica, OEM 12c,BODS,Microsoft Azure,Hadoop,SAP HANA.

Confidential, Wilton, CT

Project Lead / Senior DBA/Architect

Responsibilities:

• Responsible for Migrating/Implementing/Supporting/Migrating the Oracle Exadata Implementation for Confidential ’s Huge Data Warehouse application by evaluating/testing/benchmarking/review the Exadata Hardware. Extensive experience in supporting Exadata X2 and Exadata X3,Exadata X2 Half RAC, Exadata X3 Full RAX, Exadata X3 Quarter RAC. Responsible for Monitoring, Supporting, Backups, DR-Setup on the Exadata Quarter RAC. Compressed large tables using Exadata Hybrid Columnar Compression, Flash Cache, Exadata Storage cells, Using Exadata Storage with ASM and Migration Plan to Exadata. Migration from Exadata X2 to Exadata X3. Exadata Cell level Patches, QDPE, PSU Patches, DB Consolidation on Exadata.
• Investment Accounting environment is using 2X4 node RAC with ASM on Exadata X3,Exadata Half RAC Dataguard systems which will be open for batch processing during the EOD (End of Day) activities and during Month End. Responsible for supporting 1X4 node RAC QA and 1x4 nodes RAC for Development environments. Applied the oracle latest recommended patches/PSU/CPU on all the RAC environments.
• Extensive experience in Oracle Appliance (ZFS Storage): Creating Snapshots, Creating Clones.
• Upgrade the 10g RAC 4 node development database to 11g RAC. Followed the Oracle Recommended procedure to upgrade by upgrading the CRS, ASM, and RDBMS. Also created an 11g active standby database. Used the 11g ASM new features.
• Upgraded one production database from 8i to 11g using Golden Gate. Supported the post upgrade tasks, Bugs and Performance Issues.
• Golden Gate Installation/Configuration/Support/Tuning: Proposed Golden Gate solution for 8i to 11g upgrade. Completed the 8i to 11g upgrade using Golden Gate. Performed the design/setup/configuration/tuning /troubleshooting of Golden Gate for replication
• For reporting purpose Confidential uses 1x4 nodes Dataguard RAC systems, 3 Physical Standby Database which will be open in read write mode using Database Snapshots with guaranteed restore points. EMC SRDF/A is configured for DR site.
• Architect, Installed and configured 12c GRID server and agents for the database servers. Configure agent for VERITAS Cluster database, Oracle RAC database servers. Configure the templates and thresholds.
• Configure backup and recovery for 10G grid control, Tune metric collection and policies, Enabled patching features, Configure notification. Install management agent through agent deploy.
• Exadata Flash Cache tuning, Tuned RAC though load balancing, buffer busy waits, global recourse directory, Global cache service waits, Inter-Connect tuning, hot blocks tuning, jumbo frames,10046 trace,10053 trace, racdiag. Sql, ORADEGUG, RDA, partitioning hot blocks tables, pinning packages and objects into memory, shared pool tuning (through keep pool, recycle pool and default pool)
• Oracle Security: Architect and Setup the Database Security by designing the database security standards from Confidential .
• This includes - Setup complex user password policy, written complex database password VERIFY FUNCTION to check complexity, password life ECT. Also change the password for SYS and SYSTEM, Lock, remove or change passwords for default unused accounts, Lock, remove or change passwords for default unused accounts, Remove REMOTE OS AUTHENT, Protect the dictionary from unauthorized users, Revoke privileges from PUBLIC where not necessary, Verify database file security at OS, Lister password, Data Encryption, Apply Oracle latest CPU Patch, Create separate account for DBA’s. Installing and Keeping OS Patches current and OS Hardening.
• OLTP /DW Database Tuning: Responsible for leading the tuning initiative for oracle databases /Oracle RAC. Tasks include Diagnosing performance problems by analyzing oracle trace file, analyzing SQL statements, Measuring system and database performance problems by Analyzing Oracle trace file, Analyzing SQL statements, Measuring system and database activity, Querying Oracle dynamic performance views, Tuning Database and Application by shareable SQL statements, bind variables, detecting contentions and deadlocks, Pinning large packages and procedures, optimizing initialization parameters and operating system variables I/O distribution and striping, optimizing redo logs, rollback contention and archive process, Optimizing latch contention in the shared pool and buffer cache, Optimizing locks and enqueue contention, Tuning SQL*net, SQL statements tuning using Hints, Indexes with TKPROF,SQL trace EXPLAIN PLAN,TOAD and Stored Outlines, OS kernel tuning.
• Responsible for supporting 100+ Sql server database as a secondary DBA when the primary DBA is not available
• Proposed the reporting solution to Confidential to reduce the load from the production OLTP database and run the reports on SharePlex replicated database.
• Cloud Computing/Amazon AWS/Microsoft Azure/Oracle Cloud: Expertise in designing applications on Cloud Based Solutions for Database using Microsoft Azure, Amazon AWS, Oracle Cloud. Expertise in migrating Oracle DB to Microsoft Azure, Amazon AWS and Oracle Cloud. Expertise in Design, Architect and Build a cloud based Database Solutions on Microsoft Azure, Amazon AWS, Oracle Cloud.
• 24X7 Support: Provided 24X7 support for Confidential database by off hours on call and by carrying blackberry.

Environment: Oracle Exadata X2,Exadata X3, Oracle, 8i,9i,10g,Oracle 10g RAC,11g RAC,10g CRS,11g CRS 10g OEM Grid,10g Streams, Solaris, Linux, Golden Gate,, EMC,EMC SRDF/A, HITACHI, Quest Foglight, Quest PA. Network Appliance (Netapp), SQL SERVER 2000,SQL SERVER 2005.PeopleSoft, VERITAS Netbackup 6.0, DB Artisan, TOAD, Data Stage, J2EE, Web logic, SQL Server, SAP, Hitachi SAN, Golden Gate, Charles River Database, Princeton Financial System database, Charles River Database, Microstrategy, Golden Source, Open Link Portfolio Asset Management (PAM), Gardium, ZFS

Confidential, South Jersey

Project Lead/Senior Oracle RAC DBA

Responsibilities:

• Design/Install 5 nodes RAC. Installed 2,3,5 Node Oracle 10g RAC using ASM (ASM instance, ASMLIB, External Redundancy, ASM striping, failure groups, Rebalance, ASMlib and Multipathing utilities, Setting large AU for large databases, Tune the ASM instance parameters, used KFOD utility, Configure ASM on EMC Symmetrix and EMC CLARiiON storages,) OCR, CRS, and Voting Disk.
• Performed RAC monitoring and tuning with. Supported 3 RAC system with 2 node,3 node and 5 node which are Confidential OLTP database for Confidential provisioning.
• Evaluated/Tested Oracle Exadata for Confidential Billing application by evaluating/testing/benchmarking/review the Exadata Hardware, Exadata Hybrid Columnar Compression, Flash Cache, Exadata Storage cells, Using Exadata Storage with ASM.
• Streams Configuration, Setup and support: Configure 10g Down Streams which is used to replicated data for reporting purpose by creating capture queue, propagate queue, apply queue, created conflict resolution scripts.
• Performed tuning for faster apply process.
• Performed tuning for RAC database through, partitioning the large tables, creating local indexes, defining tables statistics strategy, tuning gc buffer busy wait, initrans, gc buffer busy waits, gc block busy waits, cache, buffer busy global cr, global cache busy
• Design the backup strategy for Confidential OLTP databases. Created Scripts for daily hot backups. Restored the database by using the duplicate database commands. Taken data pump exports, traditional exports of the database as and when required. Configure the Flashback Recovery area. Configure compress database backups using advance compression technology. Backup and restore the databases which are on ASM. Used BCV for backup copy on the DR site. Used Transportable tablespaces for monthly incremental backups for reporting/DR Purpose. Created scripts for flash recovery area backups and oracle backup copies.
• Configure physical standby database for RAC database from 3 nodes RAC to 2 nodes RAC. Configure flashback database for point in time recovery in case of disaster. Configure CRS callout scripts for automatic apply process after node reboots. Configure the data guard database with maximum availability and maximum performance modes. Tune the log transport service process. Configure the Data guard.
• Install and configure 5x2 node VERITAS cluster database, configure OEM agent for these database, Tune the OS kernel parameter for Solaris 10 and RHL4,5.Tune the oracle instance parameters for VCS stand alone database.
• Performed 8i to 10g upgrade for one of the Confidential billing database. Upgraded 9i RAC to 10g RAC for billing database.
• SharePlex V6 Installation/Configuration/Support/Tuning: Proposed the reporting solution to Confidential to reduce the load from the production OLTP database and run the reports on SharePlex replicated database. Installed and Configure SharePlex for the new reporting database. Responsible for frequent addition/removal of tables in SharePlex configuration. Tuned the SharePlex database inserts/update database by hints, init trans, indexes, dbms stats, SP ORD LDS ARRAY SIZE, SP ORD CDA LIMIT.
• Provided 24X7 support for Confidential database by off hours on call rotation and by carrying blackberry.
• Supported database from companies like Amdocs Advantech, Conceptwave, SAP, and Oracle E-BUSSINESS.

Environment: Oracle, 8i,9i,10g,Oracle 10g RAC,LINUX,SUN,HP-UX,SQL SERVER,EMC SYMMANTIX,E-Business, VERITAS Netbackup.ASMLIB,10g CRS,10g OEM Grid,10g STREAMS, Golden Gate. Oracle 11i, BCV, VERITAS Cluster, SHAREPLEX, Oracle 11g and Exadata.

Confidential, North Jersey

Senior Oracle Tuning Consultant

Responsibilities:

• Responsible for tuning and supporting many databases which are Lehman’s 24X7 highly critical Investment Banking database which is used by US/UK/ASIA/TOKIYO and other countries for their Global Exposure, Margin management, Risk Assessment, Fixed Income, Stock Borrow Stock Loan.
• Performed Detail health check of the databases and Tuned many banks OLTP and DSS databases by partitioning, Stored Outlines, Oracle Parallel Server Tuned the banks daily End of Day batch jobs which were taking long time by dividing buffer cache into keep pool, recycle pool and default pool. Keeping frequently used procedure, packages, and functions in memory. Optimized Instance parameters, Removed Chained rows by re-organizing the database, Hints, Batch Job tuning through 10046 trace,10053 trace, AWR,ADDM,EM,PL/SQL tuning of procedures, packages, Parallel Query Option, Buffer Busy Waits, Latch Contention, Increase number of database writers required for the databases, Increased the Redo Log size for few Batch processing databases. Extensive SQL statement tuning of complex SQL, procedure, packages, materialized views, views. Suggested the strategy for the Index Rebuilds, and Removing Unused Indexes. Tuned network settings through MTU, tcp sendspace, tcp recvspace. Tuned SQL*Net by changing the SDU and TDU in the tnsnames. ora file. Extensively used Quest Performance Analysis, Quest Toad, 10046 trace, Explain Plan, TKPROF for tuning. Partitioned most of the applications large tables using range or hash partition as per the requirements.
• Proposed/Installed/Configure: Oracle 10g RAC solution with Data Guard for DR site for one of the important OLTP database. Performed Oracle 10g RAC installation of 2 Node Oracle 10g RAC using ASM (ASM instance, ASMLIB, Normal Redundancy, External Redundancy), OCR, CRS, and Voting Disk. Performed RAC monitoring and tuning with EM,AWR,ADDM,SQL ADVISORY, 10046 TRACE,10053 TRACE, SQL*NET TUNING, Oracle Wait Interface, ORADEBUG, reduced Sequence and Index Contention.
• Performed Oracle 9i to 10g Upgrade for many of the bank’s databases by proper testing all the new features, SQL plan changes in 10g if any, New instance parameters for 10g.
• Involved in Re-Engineering of one of the Lehman Margin Call database by tuning most of the complex SQL, PL/SQL, mviews, views. Suggested the rewrite of few of the complex code.
• Implemented database security by enabling database on-logon trigger, Password aging and verification for non-application user id, Application user lockdown, Implement ROLE based security.
• Used Autosys jobs for schedule maintain daily tasks, weekly tasks, and monthly tasks.
• Tuned the PeopleSoft database complex queries and views.
• Improved the performance of the Quest SharePlex process by tuning the replication process, adding hints, changing the table structures for SharePlex Tables, Changed the table’s structure of the destination databases.
• Use Remedy for change management followed change control guidelines of the organization.
• Document standard operating procedures, User Guides, Best practice Guide, Cluster Configuration and other Technical documents as needed.
• Supported 100+ SQL server database, Performed Backup, Recovery, Tuning for banks OLTP applications on SQL server.

Environment: Oracle 7.x,8i,9i,10g,Oracle 10g RAC,LINUX,SUN,SQL Server, Quest SharePlex, Quest Performance Analysis, Autosys, EMC DMX, Network Appliance(Netapp),PeopleSoft, VERITAS Netbackup 6.0,DB Artisan, TOAD. Informatica Crystal Reports, J2EE, Weblogic, SQL Server, ASMLIB.

Confidential

Senior Oracle DBA

Responsibilities:

• Installed configured and provide 24*7 SUPPORT TO HIGHLY SENSITEIVE MISSION CRITIACAL INSTANCES (30 PRODUCTION, 25 DEVELOPMENT AND 30+ TEST INSTNACES) running 7.3.2, 8i, 9i and 10g ON AIX 5.2L Sun Solrais9 AND RHEL.50+ SQL SERVER databases.
• Configured Oracle 8i, 9i, 10g on AIX 4.3, 5.2 Sun Solaris 8, 9, HP 11i, RHEL 4and win2k following OFA. Configured and used ASM for storage management (oracle 10g).
• Installed and configured SQL Server 2000 and 2005 on Windows 2000, 2003 servers. Act as a backup SQL DBA and provide production support as and when needed.
• Provide backup support to Unix Admin Team. Install and configure Sun 8, 9, AIX5.2, 5, 3, HACMP and LPARS. Configured p590, p595, SF 440,480Compaq and Dell Servers.
• Responsible for logical and physical database design of both oracle and SQL server database .Provide production support to OLTP and Data warehousing Instances.
• Installed and configured Oracle 9Irac, 10g RAC on AIX5.Installed and Configured Quest SharePlex on source and target for replicating core banking database to a different machine for generating reports. Installed and configured oracle Standby .
• IFLEX: Responsible for supporting the FLEXCUBE application databases for Corporate Banking, Retail Banking, Internet Banking, Credit banking from IFLEX by tuning the SQL’s, creating the weekly partitioning, monthly partition, segregating the tables into different tablespaces, Keep the objects in keep pool, Re-organizing the tables, Rebuilding the indexes.
• Upgrade Oracle 7.3.2 to Oracle8i to oracle 9i and 10g.Performed cross platform migration of application running SQL Server 2000 ON Windows to Oracle 9i on AIX.
• Retired and consolidated legacy Servers and databases to bigger more robust databases. Improved application integration by consolidating multiple applications and application instances thus eliminating redundancies, increasing performance and reducing maintenance costs.
• Configured and used OEM, Foglight, Spotlight, STATSPACK, and performance Analysis for database monitoring. Achieve 99.99% uptime as per SLA's.
• Configured RMAN on Tivoli Storage Manager. Schedule Backups and ensured recoverability by implementing monitoring and periodically testing database RMAN Backups/Backup scripts. Improved performance of RMAN backups by adding critical parameter to backup scripts. Frequently duplicated production database to development environment through RMAN.
• Help plan and implement DR site, with the help of system administrators build the environment from scratch, Plan, implement and participate in DR DRILLS, Document DR Site.
• Monitored and Tuned Bank's batch jobs of End of Day, End of Month and End of Year operations.
• Analyzed and record growth statistics accordingly plan for capacity based on growth rate and generate needs of the org.
• Troubleshoot all database issue. Liaison with oracle Corp for fixing critical issues, Bug fixes and Backports.
• Implement and supervise the operations procedures outlined in data center manual to ensure error free operations and develop adequate skills to operators to handle database and media issues in the in the data center.
• Administration of C-TREE database for BASE-24 application.
• Support 50+ bank SQL SERVER databases in the ADCB bank’s branches. Performed maintenance tasks and optimized.
• Use Remedy for change management followed change control guidelines of the organization.

Environment: Oracle 7.x,8i,9i,10g,Oracle 9i RAC, Oracle 10g,Oracle 10g RAC,AIX5.2L,SUN,LINUX,Tivoli Storage Manager, Quest SharePlex, Quest Foglight, Quest Spotlight, Quest LiveRorg, MS SQL 2005 & 2007.

Confidential

Oracle DBA

Responsibilities:

• SEIBEL DATABASE TUNING/SUPPORT: Performed the tuning for SQL, Stored procedures, database Instance tuning for Seibel database. Extensive experience with working with Seibel application. Worked closely with SIBEL development team on development tasks like helping with the development code, tuning the code by creating Indexes, views, hints. Cloning the production database to development environment. Helping the development team to resolve the database integration issues.
• Install configure and provide 24*7 support to oracle 8i,9i instances(30+ prod,40 Dev & SIT) running on AIX5.2L.Database size range from 100GB to 6TB.Supported 40TB of storage of IBM ESS/DS 8000.Also provide production support to Oracle Application Server 11.5.9 AND Siebel 7 instances.
• Installed configured and support three 2 node Oracle 9i RAC on AIX5.2 using HACMP cluster technology. Maintained clients Clustered oracle Production servers on AIX 5.2L with HACMP.
• Responsible for tuning Very Large databases-Tasks include performing tuning at RAC Instance level,OS level, application level SQL tuning using statspack, TKPROF, Explain Plan, hints and stored outlines, Rebuild and re-structure tables and indexes, partition large tables and move them to different disks for better IO, parallel Query option, Direct Path Export/Import, Function-Based indexes, SQL*Net tuning, physical I/O tuning, CPU utilization, kernel tuning and Extensive SQL tuning of very complex queries of SIEBLE and Billing system.
• Designed and implement the backup strategy for client. Created backup scripts for Tivoli Storage Manager using TDPO & TDPOCONF. Schedule the backups at TSM.
• Troubleshooting all the database issues. Work with the system/network administrators to resolve bottlenecks and Tune OS and Networks. Apply OS patches and ensure database security.
• Proactive management of database and file systems for growth of tables, indexes and log files.
• Setup the New Data Center for Confidential . Installed new hardware from scratch, worked with System Admin for OS installs, Installed Oracle 9i RAC and 9i database, Moved databases from UAT to production. Setup and implement backup.
• Provide System Administration support on AIX 5.2 in absence of AIX Administrator. Provide support for critical AIX HACMP clustered production server and AIX Test Servers. Monitor database health through OS/Tivoli logs.

Environment: Oracle8i, 9i, Oracle9i RAC, AIX 5.2L, SIEBEL, Tivoli Storage Manager, Oracle APPS.

Confidential

Senior DBA

Responsibilities:

• Maintained Ministry of s Oracle8i database on TRU64Clustered Production Servers, TRU64 TEST Server, Windows Application Server, Linux Production Server and windows Production Server.
• Provide level III support for oracle issues.
• Implemented Oracle Database security with NESUS security scanner tool and applied patches accordingly.
• Resolve production support issues quickly and effectively including off-hours support when needed.
• Monitoring and optimizing performance of the database through SQL tuning, tkprof, sqltrace, explain plan, OS
• ITIL standards Setup/Implementation: Responsible for implementing ITIL methodologies for Ministry of . Created the Configuration Management Database, Setup Service Desk standards, Service Level Agreement, Capacity Management standards, Setup Incident Management standards, Setup the database by following the Service Continuity Management of ITIL. Implemented the ITIL stands using Remedy tool for incident management, change management, SLA's. Created the DR sites following ITIL standards.
• Analysis, development, maintenance, testing and implementation of programs in support of clients system in TRU64, SUN, LINUX and WINDOWS.
• Responsible for creating new servers by installing oracle and application for different ministry of Sites.
• Creating new strategies for Ministries upcoming sites which will be connecting to the ministry.
• Installed and Configured VERITAS Net Backup to Schedule database backups.
• Responsible for maintaining TRU64 UNIX production server, monitor jobs, OS level backups, logs, downloading and applying OS level patches, developed scripts to schedule jobs through crontab and overall server's health.

Environment: Oracle 8i/9i, TRU64 UNIX, LINUX, SUN Solaris, REFLICATION, TOAD, VERITAS Netbackup, ITIL.

Confidential

Oracle DBA/Technical Specialist

Responsibilities:

• Installed configured and provide 24*7 support (in house and remote) to mission critical instances(100 production servers,40 development and 30+ Test instances running Oracle 8,8i on AIX and Windows nt4.0
• Remotely administered the banks 350 branch server and supported team members on technical issues.
• Provide 3rd level support. Resolving all Escalated problems from JR DBA's.
• Team lead-As as a mentor to a 50 member Team. Guide them on critical issues.
• Guiding the team for applying the application patches on database (tables, views, and indexes) after application developers.
• Wrote extensive shell scripts for automation and backup and recovery.
• Supported Oracle in both UNIX AND Windows NT ENVIRONMENTS.
• Sysadmin Tasks at operating system level (AIX, SOLARIS, LINUX, WINDOWS): Monitored and maintained AIX server and Windows based server. Monitor Jobs, backups, logs and overall server's health .Appling downloads and patches. Taking backups at OS and database level.

Environment: Oracle 8i, Solaris 8, AIX 4.3, Windows NT 4.0, SQL Server 7

Confidential

ORACLE DBA

Responsibilities:

• Installed, Configure and Administer Oracle 7.3 Database using Oracle Server Manager.
• Creating/Altering/Modifying tablespaces, users, procedures, packages, triggers as and when required.
• Creating Oracle users, giving them security and permission.
• Configuration of Oracle Clients through SQL*Net Easy Configuration, connect them to Oracle Server.
• Tuning the application Server as per the recommendations from application vendor.
• Backup of all relevant data from the server using Data Manager.
• Implementing the ERP Financial, Distribution and Payroll System in company as per User requirement.
• Installed and configured Oracle 8 server. Provide support to 10 instances running on windows NT. Database size ranges from 50GB to 300GB.
• Responsible for logical and physical database design. Creating the logical storage structures, such as tablespaces, tables, views and indexes required by the application. Managing the physical storage structures, such as data files, control files and redo log files. Used Er-Win for logical design.

Environment: Oreacle8.0, Windows NT, TOAD, ERWIN