SUMMARY:

• Over 15 plus years of IT experience focusing on Oracle Database Management and Administration with experience in the Medical Industry (BMS) Banking/Finance ( Confidential, Confidential ) and Telecommunication (AT & Confidential ) industry as Database Manger /Lead/DBA.
• Involved in planning, designing developing database systems .
• Management and Administration of Oracle RAC (real application cluster) system from design architecture to Replication implementation.
• High Availability: Implemented Data Guard (logical &physical) for maximum protection, performance and availability.
• Manage team of DBA’s (infra structure) on site and off site spread across the globe. DBA categorized of Administration, Application, Operation, Production, Change Management, NOC, On - call support and performance optimization.
• Implemented the ITIL standard model of RDBMS for the DBA teams: Service Delivery, Service of Excellence and People for Managing and Maintaining Database systems.
• Defined the Cost saving structured Shared-Service Model for the operational DBA team servicing multiple projects. Defined Outsource model across continents for rapid DB service

TECHNICAL SKILLS:

RDBMS:   Oracle 11g/10g/9i/8i/ with RAC, Data Guard, OLAP, OLTP,DW,

Web application:   Oracle iAS, Web sphere, web logic, Tomcat, Jboss, portal

Hardware:   Solaris Sparc, IBM RS/6000, Intel Pentium IIx, HP C160, Sun Enterprise 450, Dell 6650

O/S:   Sun Solaris 5.10 sparc, IBM AIX 4.3.2, Red Hat 3.0 AS, HP UNIX 11.0, SCO UNIX, Red Hat Linux, SAMBA, Windows 2003/AS

Data warehouse:   Teradata, Exadata, Abinitio, Informatica, Data guard, Partitions, Crystal reports, Business objects

Database Tools:   OEM, RMAN, Data Guard, DATAPUMP, TOAD, Quest spotlight, Oracle Sql developer,

Backup Applications:   RMAN, Data guard, Net backup, EMC, Veritas , Tivoli Flashback , FRA , Data pump. Online and offline backups , cold backups, logical backups

Performance :   ADDM, AWR , Explain , Trace , Stats pack , OEM , DBMS STATS, CBO, Mercury , SQL Tuning Advisor

Languages :   SQL, PL/SQL, Perl scripts, C++, C, JAVA, HTML

PROFESSIONAL EXPERIENCE:

Database Architect 

Confidential , Washington DC 

Responsibilities:

• Managed 50 + enterprise-level Oracle 11g/10g database systems, achieving the goal of 99.99% availability at acceptable level of performance.
• Participated in vital planning for infrastructure setup of the Confidential databases which involved geographically dispersed sites across the nation
• Managed team of on-site DBAs and off-site DBAs across global locations . DBA categorized of Administration, Application, Production, Operation, Change Management, NOC, On-call support and Optimization. 
• Defined the Cost Saving structured Shared-Service Model for the operational DBA team servicing multiple projects. Defined Outsource model across continents for rapid DB service requests. 
• Managed and administrated database and database applications 24x7 that include Oracle 10g/11g/9i Databases, Siebel and Cognos application databases, Micro focus Cobol , RAC (real application cluster) clustering server, OEM Grid , High Availability, Data Guard , Web service applications (WebSphere and WebLogic) and IBM Rational products. 
• Successfully upgraded Confidential most critical RAC ( Real application cluster ) databases in minimum down time and almost zero outage time . 
• Implemented ITIL model of ticketing system to track the support service for the application, adhoc requirement and 24/7 support.
• Defined Policy/Standards and process for the database changes migration model flow drafted for the production. 
• Implemented Oracle RAC Replication from scratch for clustering the database server to support the increased number of daily transaction volumes and high availability of the database system by enabling Load balance and Instance failover features  
• Implemented Oracle Data Guard (physical and logical) for World Bankd Internet Sites Database systems in maximum availability and maximum performance mode; primary and standby sites were setup in different coasts for disaster recovery solution   
• Upgrading of Oracle RDBMS and Cluster CRS (cluster resource services) home with the oracle recommended patches and security alert patches  
• Implemented the ITIL standard model of RDBMS for the DBA teams: Service Delivery, Service of Excellence and People for Managing and Maintaining Database systems. 
• Implemented RMAN and Flashback technology (FRA) for Backup and Recovery solutions. Used RMAN for Hot//Cold /Logical backups and Database Recovery including Point in time recovery. Backup to tapes using OBS (Oracle backup solution) recommended VERITAS and Tivoli. 
• Configured Oracle Enterprise Manager Grid control for monitoring to manage and automate the alerts based on thresholds.  
• Performed performance tuning of the database for the accepted level using Broad brush approach (tuning of Design, Operating system, Database, Instance, Disk I/O and Application).
• Implemented database performance monitoring tools 
• Implementation of Oracle Partitions (Range and List) for very large objects storage and performance enhancements. Implemented purging partition archival mechanism for claims history 
• Implemented SOX security for finance databases. 
• Implemented Sun control point system ticketing system for change management and incident management for production database system  
• Managed the full database deployment life cycle including development, testing (including UAT), and pre and post-production environments (including the legacy and conversion and interface environments) according to quality standards  
• Used state-of-art technology and tools for performance tuning and enhancement of the database. 
• DBA team servicing multiple projects. Defined Outsource model across continents for rapid DB service requests. Defined the Cost Saving structured Shared-Service Model for the operational

 Environment: Oracle 11g/10G RAC, Data Guard, OEM Grid Control , Grid ,Cognos, , Quest spotlight, ClearCase and ClearQuest, RDBMS, Oracle 11g/10g/9i, Erwin, data warehousing, OLTP, WebLogic, WebSphere, Toad, Sun control point, Tivoli, VERITAS, SAN, OCFS, UDP

Database Consultant Manager

• Managed 30+ enterprise-level Oracle 11g/10g database systems, achieving the goal of 99.99% availability at acceptable level of performance
• Implemented High availability RAC systems for Loans and Security subsystems.
• Participated in vital planning for infrastructure setup of the Financial Data Warehouse setup which involved geographically dispersed sites across the nation
• Involved in developing Metadata Compare Application for Database multiple schemas across environment and E/R Studio models
• Setup Database system for the tool Kalido and ETL Abinitio for the Project CAPRI (Cost Allocation Profitability and Return Investment) .
• Upgraded Oracle RDBMS and Cluster CRS (cluster resource services) from version 10G to 11g.
• Configured Oracle Enterprise Manager Grid control for monitoring to manage and automate the alerts based on thresholds. Utilized Autosys for automate tasks.
• Involved in database design for a huge data mart(Account and Financials DW) built for consolidating accounts in Fannie Mae and participated in future state architecture discussions/implementations.
• Involved in planning discussion for Exadata setup for EBS(Event Bus Service) DW that used TIBCO software application.
• Utilized Remedy ticketing system and Rational products (Clearcase and clearquest) for tracking data changes.
• Implemented 11g feature Flashback Data archive on History archive tables.
• Technologies, languages, tools and environment:  RAC, OEM, Grid ,Rational Rose , ClearCase and ClearQuest, RDBMS, Oracle 11g/10g Erwin, data warehousing DW, OLTP, ETL Abnitio, Toad, Embarcadero DB Artisan, Remedy, Exadata, Autosys .

Confidential 

Database Consultant Manager

• Managed 100 + enterprise-level Oracle 11g/10g/9i database systems, achieving the goal of 99.99% availability at acceptable level of performance.
• Managed team of on-site DBAs and off-site DBAs across global locations.
• Managed and administrated database and database applications 24x7 that include Oracle 10g/11g/9i Databases, Cognos application databases, Deltek , e-business integration suite, RAC (real application cluster) clustering server, OEM Grid , High Availability, Data Guard , ETL Ascential , Web service applications (WebSphere and WebLogic) , IBM Rational products.
• Implemented Oracle RAC Replication Load balancing for performance bench marking for scalability of processing “n” claims in the Sun Lab in California. Mercury tool was utilized for system level monitoring.
• Managed the MMIS OLTP Database system to support 400 users 24x7, handling database-related issues and also supporting the MMIS applications.
• Implemented Oracle Data Guard (physical and logical) Database systems in maximum availability and maximum performance mode; primary and standby sites were setup in different coasts for disaster recovery solution.
• Administered the business intelligence and analytical application Seibel 7.0 Oracle database for customer relationship management (CRM) work flow process
• Managed the data warehouse database (40Tb) and the Cognos database to support report generation for 20 users and implemented FACT and Dimension Framework
• Implemented RMAN and Flashback technology (FRA) for Backup and Recovery solutions. Used RMAN for Hot//Cold /Logical backups and Database Recovery including Point in time recovery. Backup to tapes using OBS (Oracle backup solution) recommended VERITAS and Tivoli. Implemented Quest LiteSpeed for compression of data backups
• Managed the extraction, transformation, and load (ETL) process from the legacy to the Oracle databases for conversion and interface environments using Ascential and Informatica ETL tools and formulated the methodology for storing data.
• Configured Oracle Enterprise Manager Grid control for monitoring to manage and automate the alerts based on thresholds. Utilized OEM components (Diagnostics Pack, Tuning Packs, and Change Management Pack) for analyzing the database activities and improving the performance
• Performed performance tuning of the database for the accepted level using Broad brush approach (tuning of Design, Operating system, Database, Instance, Disk I/O and Application). Implemented database performance monitoring tools
• Implementation of Oracle Partitions (Range and List) for very large objects storage and performance enhancements. Partitioned claims-associated and managed care subsystems objects based on the adjudication purpose. Implemented purging partition archival mechanism for history data.
• Implemented and provided direction for all Oracle advanced security related initiatives, vulnerabilities etc. Conduct periodic SOX review and remediate deficiency uncovered during the review.
• Implemented Oracle Golden Gate direct load for replication of data from the legacy oracle database system in Red hat Linux to oracle database system in AIX.
• Implemented REMEDY ticketing system for change management and incident management for production database system
• Managed the full database deployment life cycle including development, testing (including UAT), and pre and post-production environments (including the legacy and conversion and interface environments) according to quality standards
• Used state-of-art technology and tools for performance tuning and enhancement of the database
• Implemented the ITIL standard model of RDBMS for the DBA teams: Service Delivery , Service of Excellence and People for Managing and Maintaining Database systems.
• Defined the Cost Saving structured Shared-Service Model for the operational DBA team servicing multiple projects. Defined Outsource model across continents for rapid DB service requests.
• Supported users and developers; developed queries; and optimized their stored procedures

Environment: RAC, Data Guard, OEM, Grid ,Cognos, Share plex replication, RDBMS, Oracle 11g/10g/8i/9i, Erwin, data warehousing, OLTP, ETL Ab Initio, WebLogic, WebSphere, Toad, Tivoli, VERITAS, SAN, OCFS, UDP

Confidential

Lead Database Administrator / Onsite DB Manager

• Managed more than 300+ databases of AT& Confidential which are residing on different types servers having different flavors of Unix such as AIX, HP, LINUX, SOLARIS.
• Administered 44 enterprise-level Oracle 11g/10g/9i Database Systems, achieving goal of 99.99% availability at acceptable level of performance
• Managed Team of 10+ DBA team members between onsite and offshore model structure
• Handled Critical, Emergency Issues in All Production Environments and On Call Supportver the weekend Oracle software (Oracle 11G, 10g) installations on various platforms like HP Unix, Linux, AIX etc.
• Carry out the day to day database related activities for Oracle 10G and 11g databases.
• Identified the issues and working with the team to find solutions.
• Created Packages, Stored Procedures, Stored Functions, Database Triggers and Unix Scripts
• Planning , hosting weekly meeting with the team to discuss the issues.
• Planning and Implementation of Critical Patch Update on all Oracle Collaboration Suite Components in every quarter.
• Capacity Planning for all the Production and Stage Servers (Performance Analysis, Storage Growth and Automatic Storage Management (ASM) and Grid Implementation)
• Gather Database and User Level Statistics and Analyze Overall System Performance
• New Production/Stage Environment Setups (Cluster and Non-Cluster)
• SQL/Database Instance Tuning by running STATSPACK and AWR/ADDM reports and analyzing, recommend any changes
• RMAN Database Backup/Recovery - Monitoring hot backups and Monitoring Archivelog Destinations
• Managed Data Guard and physical Standby Setups for disaster recovery. Aggressively participate in annual disaster recovery tests.
• Implemented and provided direction for all Oracle advanced security related initiatives, vulnerabilities etc. Conduct periodic SOX review and remediate deficiency uncovered during the review.
• Replication setups, configurations and data migrations using shareplex and Golden gate technology.
• Worked with UNIX team for supporting/maintaining existing systems. Also for new systems in order to configure servers for Oracle software and databases. Used systems range from standalone Solaris/Linux server, Highly Available symmetric VCS clusters, Highly Available asymmetric VCS clusters and RAC ready clusters using Veritas.
• Managed ASM instances on RAW files system environment Managed mission critical applications on RAC environment keeping the entire alert monitoring up to date.

Environment:  RDBMS, Oracle, Data Guard, Oracle 11g/10g/8i/9i, Perl, Data warehousing ETL, OLTP and OLAP, SQL, WebLogic, WebSphere, Crystal Reports, RAC, Erwin, Putty, Linux 

Confidential

Lead Database Administrator / Onsite DB Manager

Responsibilities:

• Managed a team of 5 dba team members and 30+ production/Test/Qa databases which were providing a backend support to Container Management Software (NAVIS EXPRES and SPARC).
• Responsible for Oracle7/8i/9i logical and physical databases design, implementation and maintenance on UNIX, Linux and Windows NT
• Database Refresh - Moved database Schema changes to stage or production
• Developed some Unix Shell scripts to automate database operation and database monitoring
• Implemented database refresh with the hot backup using DUPLICATE or full export
• Used EXPORT/IMPORT to do table level and full database defragmentation
• Provided on-call production database support
• Data loading using SQL Loader (from Text files to Database)
• Coding using PL/SQL, SQL and Unix Scripts
• Server and Clients Installations for New Clients
• Helped developer to install Oracle Client, troubleshoot and establish the connection to Oracle database through ODBC, JDBC
• Performed SQL Tuning by using explain plan and TKPROF
• Daily Monitoring Database and Table spaces Growth and Monitoring Space Availability at Operating System
• Mentored a new DBAs in our environment