Professtional Summary:

• Over 15 plus years of IT experience focusing on Oracle Database Management and Administration with experience in the Health Care (MMIS), Financials (Fannie Mae) and Telecommunication (WorldCom Inc) industry as Database Manger /Lead/DBA.
• Experience in Agile Technology and ITIL technical solutionsand certified in Customer Training.
• Involved in vital planning for infrastructure setup for the Health care systemfrom coast to coast.
• 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 Excellenceand 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.
• Involved actively in technical solutions in bidding proposal for future Business development.
• Implemented the ticketing system to support Database system 24 by 7 and track the activities for Pro-active approach solutions.
• Customized and Administered OracleDatabase for COTS products (CRM Siebel, Cognos and Business objects) to suite the Medicaid Medical information systems (MMIS).
• Administered and Engineered for the upgrade of Deltek products (Cost point and Timesheet) and Sage (payroll) supporting Oracle DB for HRMS.
• Managed Oracle database for Micro Focus Cobol application for MMIS Drug Rebate and Pharmaceutical applications.
• Implemented Geo Spatial (GIS) using the ArcGIS, ArcIMS and ArcSDE ESRI applications for mapping the Database information onto the geographical maps
• Managed Configuration Management oracle Database for IBM’s Rational products (Clear Quest & Clear Case ) for Defects and Ticketing system.
• Managed the Oracle E-business suite Balance scorecard for the high level management to forecast the budgets.
• Extensive experience in Database Lay out model and Managing Health Care (CLINICAL) domain information system from scratch to production. System includes MMIS (Medicaid Information systems), EMCS (electronic Medicaid Claim System), Inter-Clinical database (ICDB), COHORT (Composite Occupational Health and Operational Risk Tracking System) andNaval Research Laboratory (NRL).
• Experience in Oracle versions from Oracle 11G\10g\9i\8i.
• Security and Privacy of database: - HIPAA, FIPS, PHI, DITSCAP, DES3, Obfuscation, MHIS, Audit.
• Administered and Deployed Web application products (Oracle iAS , IBM Websphere , BAE Web logic, Tomcat , Jboss) for RDBMS ODBC setup and installation.
• Extensive experience in the architecture of Data warehouse, VLDB (over 20 TB), OLTP, DSS and OLAP. Implemented ETL tools informatics and Ascential.
• Migration from legacy servers to oracle using Oracle utilities (workbench).
• Involved in the planning design for Exadata in Data warehouse.
• Administered full phase cycle of the database. Administered Development, QA , Integration , UAT , Pre _Prod and Production environments including the legacy conversion and interface environment.
• RMAN for Cold and Hot backups and Recovery including Point in time recovery. FRA and Flashback Technology were implemented. Implemented RMAN and Data Guard for backups. Backup to tapes using veritos, Netback up , Tivoli and EMC.
• TCP/IP data networks performance analysis, Capacity planning, Customer billing and Cost modeling for VOIP (voice over internet protocol). Supported NetIQ , Foreview and Cascade views.
• Excellent communication skills and customer relation.

RDBMS : Oracle 11g/10g/9i/8i/ with RAC, Data Guard, OLAP, OLTP,DW, SQL Server , Sybase , DB2
Application Admin : Siebel, Cognos , HRMS (Deltek) , Sage FLS, Balance Score Card, E-business suite, 11i Financials ,Geo Spatial , Mercury , Ascential, Seebeyond , IBM Rational Clear & Clear Quest , Emprix., Microfocus Cobol
Web application : Oracle iAS, Websphere, 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, Novell 3.12, SAMBA, Windows 2003/AS
Data warehouse : Kaildo, Exadata, Ascential,Abinitio, Seebeyond, Informatica, Retek, DTS, , Data guard, Partitions, Crystal reports, Business objects , Microstrategy
Database Tools : OEM, RMAN, Data Guard, DATAPUMP, TOAD, ERWIN, Designer 2000, JAD, ESRI, GRID, RAC, Mercury, DbArtisian, Embarcadero Studio , Spotlite
Backup Applications : RMAN, Data guard, Netbackup, EMC, veritos , Tivoli Flashback , FRA , Datapump. Online and offline backups , coldbackups, logical backups
Performance : ADDM, AWR , Explain , Trace , Stats pack , OEM , DBMS_STATS, CBO, Mercury , SQL Tuning Advisor
Languages : DB wizard, SQL, SQl Worksheet, PL/SQL, Perl scripts, Pro *C , COBOL,C+, C, JAVA, XML , UML , HTML ,TSQL

TEAM SKILLS

Team Themes

Service Delivery , Service of Excellence and People
(Administration, Production, Operation,Application, Change Management, On-Call support, optimization, Infrastructure)

Certification / Education:

Oracle certified professional in Performance Tuning.
Oracle certified professional in Backup & Recovery.
Oracle certified professional in Architecture and Administration.
Oracle certified professional in PL/SQL.
Certificate of course completion on Oracle 10g RAC for Administrators
Certificate of course completion on Oracle 10g Administration of Workshop
Certificate of course completion on Oracle 10g Sql Tuning

Masters in Science (Computer Applications) - MCA

Professional Experience

• 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 operationa

• 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 10.2.0.4 to 10.2.0.5.
• 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 .

• Managed 120 + 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, Siebel and 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, and SeeBeyond
• Designed and managed the MMIS database system for processing claims from the base HIPAA-defined electronic papers to process the claims till the payment generation to the provider which includes sub system for members, reference, prior authorization (PA), third party liability (TPL), provider, RA Managed care and common components subsystems
• 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) for MMIS Database systems in maximum availability and maximum performance mode; primary and standby sites were setup in different coasts for disaster recovery solution.
• Administered and engineered the upgrade of Deltek products (Costpoint and Timesheet) and Sage FLS (payroll) supporting Oracle DB
• Administered the business intelligence and analytical application Seibel 7.0 Oracle database for customer relationship management (CRM) work flow process and the contact center interactive voice response (CCIVR)
• Managed the data warehouse database (20Tb) and the Cognos database to support report generation for 20 users and implemented FACT and Dimension Framework
• Managed the configuration management Oracle database for IBM Rational products, including ClearQuest and ClearCase for Version Control and Defects & Ticketing system
• 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
• Implemented the Oracle Geospatial (System Multi dimensional) ESRI application ArcIMS and Geospatial ArcSDE Oracle DB
• 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 claims history
• Responsible for securing database based on the acceptance levels of HIPAA standards; implemented role-based security and audits; implemented the Obfuscation and DES3 utility for encryption and decryption of secured PHI columns; implemented RLS and FGAC at low level for data security; implemented Net8 Oracle Advance Security option single sign on net services
• Benchmarked and configured Websphere and Weblogic connection pooling mapping to Oracle Database parallel access for increase in claim adjudication throughput; used Mercury for collecting statistics for the operating system, database, Websphere, and Weblogic
• 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.
• Managed MMIS database systems in multi operating system platforms, including Unix (Solaris 5.10, AIX 6.1) and Windows platforms
• Administered and configured the Oracle e-business suite balance score card.
• 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
• 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

• Managed the replication global Oracle databases across North America, Asia, Europe, and South America
• Administered 44 enterprise-level Oracle 10g/9i Database Systems, achieving goal of 99.99% availability at acceptable level of performance
• Managed and administered the database and database applications 24x7 (including Oracle 10g/11g/9i databases; Siebel and Cognos application databases; e-business integration suite, RAC clustering server; OEM Grid; High Availability, Data Guard, and Ascential ETL, Web service applications (WebSphere and Oracle iAS), and VSS
• Implemented Oracle RAC (real application cluster) from scratch for clustering the database server to replicate the military personnel health information data in the distributed environment
• Implemented High Availability of data using Data Guard in physical mode for synchronizing data between all the Air Force bases; used maximum performance and maximum availability mode ; Used Data Guard broker for Data Guard Maintainace
• Served as the architect for the physical design and model of the Inter-Clinical database(ICDB), COHORT (Composite Occupational Health and Operational Risk Tracking System), and Naval Research Laboratory (NRL) using Erwin, JAD, and Rational Rose
• Implemented Oracle Geospatial (System Multi dimensional) ESRI application ArcIMS and Geospatial ArcSDE Oracle DB
• Administered Oracle Database for the Business Intelligence and Analytical Application Seibel for Customer relationship management for work flow process
• Managed and supported the e-business application product (NRL Agent) that collects data from all military sites across the globe and stores the data in the centralized database (6 terabytes); administered the central database 24x7; formulated methodology for storing the data; and executed extraction, transfer, and load (ETL) from Oracle API using Informatica and Ascential ETL tools
• Migrated the data conversion legacy servers (SQL server, Sybase, DB2, flat files, Oracle 8i/9i) into Oracle 9i/10g environment; implemented the Ascential and Informatica extraction, transformation, and load (ETL) tools for data mapping into the database; customized and administered the Ascential repository; managed OLTP and DSS warehouse (6TB of data)
• Upgraded the Oracle RDBMS and Cluster CRS home with the Oracle-recommended patches and security alert patches
• Responsible for securing database based on the acceptance levels of HIPAA,FIPS, PHI and DITSCAP; implemented role-based security and Audits ; implemented theHash5, Obfuscation, and DES3 utility for encryption and decryption of secured columns; implemented RLS and VPD at low level for data security
• Administered and configured the Oracle E-business suite Balance Score Cardused by senior management to make financial budget decisions
• Administered and configured the web application servers (Weblogic and WebSphere)
• Administered full phase cycle of the database, including from development through testing (including UAT) to production environments; deployed and tested application in a complete database cycle before deployed in production
• Configured Oracle Enterprise Manager Grid control for monitoring, managing, scheduling jobs, and automating the alerts based on thresholds; utilized OEM components (Diagnostics Pack, Tuning Packs, and Change Management Pack) for analyzing the database activities and improving performance
• 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 and crash recovery. Backup to tapes using OBS (Oracle backup solution) recommended Veritas and EMC. Implemented RMAN, Perl script and cronjob for backup automation in lower end environments.
• Implementation of Oracle Partitions (Range, Hash, and List) for very large objects storage and performance enhancements. Implemented Purging partition archival mechanism for history data.
• Managed Oracle database for Cognos and Seagate Crystal Reports for report generation in the data warehouse environments
• 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.
• Used the Toad Batch Optimizer and SQL Tuning Lab to tune batch jobs; used Quest spotlight to monitor the health of the database
• Managed Heather Care ICDB database systems in multi operating system platforms Linux, Unix (Solaris, AIX), and Windows platforms
• Technologies, languages, tools and environment:
  E-business Suite, Geospatial, Balance score card, ArcIMS, ArcSDE, Rational Rose, Informatica, RDBMS, Oracle, Data Guard, Oracle 10g/8i/9i, Perl, Data warehousing , data modeling Erwin tool , ETL, OLTP and OLAP, SQL,TSQL,SQL server, HIPAA, Ascential, WebLogic, Seibel, WebSphere, Crystal Reports, DB2, cluster, RAC, Erwin, Putty, Linux

• Performed lab testing for Voice over Internet Protocol (VoIP) in Cisco beds in Oracle environment for the Planning Division
• Administered eighteen enterprise-level Oracle database systems, achieving goal of 99.99% availability at acceptable level of performance
• Developed physical design of global UUNet Backbone network architecture based on hubs, routers, switches, circuits and customers mapped into the data warehouse
• Supported oracle Database for ForeView and OpenView for network traffic monitoring, where the data was collected based on 95th percentile
• Managed and administered database and database application servers including Oracle database, application, and financials servers; WebSphere; legacy data conversion; E-business integration suite; and HRMS server, RAC Replication clustering server, Seibel Application server, OEM Grid server, High Availability Data Guard Server, and Web service servers)
• Managed and customized Oracle Financials applications, including general ledger (GL), accounts payable (AP), accounts receivable (AR), fixed assets (FA),and cash management (CA) to meet business requirement needs
• Migrated of data conversion legacy servers (SQL server, Sybase, DB2, oracle earlier version) into Oracle later version environment
• Configured Oracle Enterprise Manager for monitoring, managing, scheduling jobs and automating the alerts based on thresholds, utilized OEM components for maintaining the database activities and improving performance
• Administered and configured the web application servers (Oracle iAS, Tomcat, and JBoss)
• Implemented RMAN for Backup and Recovery solutions. Used RMAN for Hot//Cold /Logical backups and Database Recovery including Point in time recovery and crash recovery. Backup to tapes using OBS (Oracle backup solution) recommended VERITAS and SAN; and implemented RMAN, Perl script and cronjob for backup automation of Databases.
• Managed the complete software development lifecycle cycle (SDLC) phases for the database from development through testing to implementation and production
• Executed 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); used Explain plan, Trace, and Tkprof for SQL application tuning
• Implemented control version system (CVS) VSS for storing java applications and used Samba to store data in Linux server
• Maintained automated alert notification program for alerts based on defined thresholds for the network operation center (NOC) group
• Performed capacity planning analysis on data traffic flow on network based on the setup of Back bone architecture
• Responsible for securing database; implemented role-based security and audits; implemented theHash5, Obfuscation encryption and decryption of secured columns; and implemented views at low level for data security
• Managed oracle database for Microstrategy 7.0 and Cognos to generate reports to plan critical business information
• Designed and published the Sales Analysis Report (growth trend, sales forecast) & Network Utilization Report (global BB of UUnet) from the data loaded to the Oracle Data warehouse using Informatica ETL and designed and published weekly report of UUNET backbone using multiple SQL queries
• Administered Oracle databases using Solaris, Linux, and AIX operating system environment
• Supported users and developers; developed queries; and optimized their stored procedures
• Technologies, languages, tools, and environment:
• Cisco, VoIP, GL,AP, Data Guard, stream, Oracle 8i/9i, C, C++, Perl, XML, developer 2000 data warehousing , data modeling, OLTP,ETL and OLAP, SQL,TSQL,SQL server, , Oracle Designer, Cognos, iAS, WebLogic, Visual SourceSafe, WebSphere, DSS, Crystal Reports, DB2,Putty, COBOL, XML, PL/SQL, Unix, Windows

• Supported the health care information database system for hospital environment
• Developed and administered database system used in billing, inventory control, order processing, and cloning and vendor billing for retail chain stores, including replication of database to remote sites
• Performed evaluation and qualification of Voice over Internet Protocol (VoIP) in Cisco beds for the Employee Information Online Project
• Technologies, languages, tools, and environment used and included in above projects:
• Developer 2000, RDBMS, Oracle 8/7i, C++, Perl, XML, data warehousing and data modeling ,SQL,TSQL,SQL, WebLogic r, Visual Basic, Visual SourceSafe, WebSphere, MS Access, DB2, Putty, COBOL, OOPS, XML, PL/SQL

References: Upon Request