SUMMARY:

• Over 17 years of progressive technical experience in database management with Oracle Database systems, I worked on Government and Commercial Insurance/banking Clients project implementations with different roles as Senior Oracle Database Administrator, Database Architect, Systems Analysts, Production DBA, Development DBA, Technical Lead, PL/SQL Developer
• Very strong team oriented skills with proven success at meeting customer requirements within budget and time constraints. Demonstrated success in implementing database solutions and improve service level business agreements and revenues.
• Expertise in Database design, deliver, administration, tuning and trouble - shooting advanced technology large-scale, highly-complex systems using the Oracle technologies with multiple environments Unix, Linux,Windows Operating Systems and Oracle Database Versions 8i,9i,10g,11gR1,11gR2,12C.
• RAC and non-RAC Install, configure, patch, upgrade/migrate, Design, plan and software Life cycle management. Software project life cycle development methodologies, database standards; conversion and modernization; prototyping; hardware and software integration; and evaluation of database concepts
• 24X7 Production mission critical databases support on Distributed client/server non-RAC and RAC environments.
• Backup tools,exp,imp and datapump, Rman Oracle Backup, Recovery with Media Mangers Legato, Net backup.
• Data guard implementation and maintained for 9i/10g/11gR2. Implemented Logical and physical standby with in RAC and Non-RAC environments.
• Routinely performing tasks such as installation, administration, tuning, backup and recovery and replication using materialized views, streams and Golden Gate, high availability design & implementation, troubleshooting, upgrades, storage capacity planning, application design and implementation.
• Data Center migrations with Planned and smooth implementations ; Security patches updates, Server Database upgrades from 9i to 10g and10g to 11gR2 Versions with non-RAC and RAC environments.
• Oracle Enterprise Manger Grid Control 10g/11g/12c software OMS/OMA/OMR and agents installed, configured and maintained . 11gR2 RAC GRID infrastructure with ASM for OEM tools used for performance and Diagnostic reports to resolve the Incident and trouble tickets.
• Team management and Technical guidance.
• Commercial: Insurance, Financial Systems and Investment Banking projects support.
• Database administration and architecture design Implementation and system tuning in OLTP, Data Warehouse and Data mart environments.
• Legacy system conversions for relational databases with non-RAC and RAC environments.
• Many system development efforts using Oraclesql, pl/sql, pro*c coding
• Unix (AIX/Sun Solaris),Linux Shell Scripts.
• Quest Tools Fog light/BMC tools/Impromptu/Informaticatools and ETL dataloads.

PROFESSIONAL EXPERIENCE:

Senior Oracle App. DBA

Confidential, Reston, VA

Responsibilities:

• Oracle DBA activities on these projects Functional testing, Databases backup/restores using expdpimpdpRman, Code reviews, Release deployments, Capacity planning and assessing systems interfaces, oracle performance tuning done using AWR, ASH, OEM monitoring, SPM.
• Database design including partition tables in FM used for applications by clients, business units, developers, and corporate offices. Troubleshoot done and assess root causes for production problems, and provided technical input to developers and less senior DBAs.Developed and document database models, data dictionaries, data flow diagrams for use by developers.
• Risknetproduction batch job long pending performance issue was resolved and provided with root cause analysis. This tuning was done with change in pl/sql code logic and adjusted dbms stats to avoid bad SQLplan, analyzed hash values for same sql id. In production this tuned SQL runtime was reduced from 5 hours to 5 seconds.
• CCP-UAT,DEMO,Prod,Acceptance Pricing and commitment Gemfireperformance issue drilldown, pre-checks before convertGemfire to Oracle. CCP project required Oracle 12Cfeaturesproof of concept done on partition and in-memory and multi-index options.
• CSP securitization, CSP Gateway and CSP data Conversion projects Sprint,Cruciblecode reviews, Release coordination, accounts profiles access management, deployments using Flyway are supported in coordination with multiple Teams.
• APV,LPV Price verification and security for asset projects databases production batch jobs performance issues root cause analysis done and resolved the complex APV,LPV projects performance issues resolved by implementing the SPM logic. Worked onOracle,Sybase and Sqlserverdatabases hosted by VM and Physical servers.

Technical Team Lead/Senior ORACLE DBA

Confidential, Washington, DC

Responsibilities:

• Disaster Recovery data synchronization for Stage and Production Databases
• Security hardening of Oracle database servers and databases before setting the Stage and Production environments and generating reports implementing DHS security guidelines.
• Release Deployments using the standard Version Manager/CRM supporting standards.
• Oracle Version upgrades and quarterly and interim patches deployment activities.
• Oracle Grid control OEM 10g/11g/12c OMS/OMA/OMR setup for monitoring and supporting Oracle Databases.
• Incident tickets and issues research and resolve performance problems and document root cause Analysis Reports. Monitoring the Oracle databases and related system services and resources. To resolve complex issues open Oracle SR and follow up.
• AWR/ADDM and ASH reports creation and ADRCI Creation and resolutions with oracle support and implement resolutions in production after testing on lab systems.
• Implemented security and controls inline with SOX guidelines for securing enterpris-wide Oracle Databases and prepared Standards Operational Procedures and streamlined the process.
• Backup strategies plan documented for Confidential supporting databases and deliverable to Government. Implemented and monitor backup strategies using Disk and Tape Media.
• Worked with a Team of DBAs and support CIS customers in setting long-range plans and goals for better performance.
• Periodic trends reports generation using Grid Control repository.
• Lead the key role on the upgrade of Oracle Databases.
• Upgraded multiple and Single instance Databases, Data Guard Databases and11g RAC Cluster Databases.
• Supported Arcsight audit Security implementation Plans as per DHS guidelines.
• Duties performed day to day monitoring Verify the consistency and synchronization of Data between source and destinations is monitored and integrity periodic monitoring alerts are implemented. Support not limited to day to day keep the systems stable with no downtime and unscheduled outages. Suggestions to Development Project Teams with pl/sql tuning scenarios.
• Responsible for Release deployments of all the below Projects including Data mart Releases associated Database changes implementation.
• E-business suite production installed and supported.
• Transactional Database for Enterprise Service Bus ESB Project:
• Ported Production database ESB from Windows environment to Sun Solaris Unix environment.
• Data Migration efforts done from Other Production and Stage sources using the Tagma Store. Input Data from other Databases BBSS, NPS, I131,ISRS and Data transmitted to US-VISIT/IDENT and VIS databases.
• ESB dependant Applications Release Deployments are supported for Production and Stage with 24X7 support and daily data validation checks performed.
• ESB-PCQS- Person Centric Query Services
• ESB-VIBE- ESB Vibe extracts data from independent source IIP Database

Senior Oracle DBA

Confidential, Maryland

Responsibilities:

• Prepared Plans and deployed Oracle HA and DR technologies such as RAC clusters, Data Guard Stand-by, ASM/ASM-lib, RMAN, Advanced Replication.
• Mentored, led and guided Junior and Mid level DBAs.
• Recommended and initiated and started Oracle shop at Confidential and converted Mainframe data into Oracle newly created Databases to different environments Sun-Solaris, AIX and Windows Platforms with Unix/Linux/Windows operating systems with latest versions to support the in-house applications.
• Efforts including various Oracle database activities which includes installation, database design, implementation, administration, maintenance support, tuning and backup strategies for all the databases on various platforms including Linux SuSE 10/9, IBM AIX Unix, Sun Solaris Unix, Windows. H/W IBM RS6000, RS690,RS570 and IBM RS H50 Clusters .IBM Blade Servers.
• Deployed the proven procedures with SOX compliance and continuous efforts to make the Database Servers stability and availability without Databases down time and with less time to recover from any kind of failures with no data loss.
• 24x7 PRODUCTION Support of all GECIO Oracle RAC Databases: IBU Claims, Sales, Services.
• 24X7 Production Support of all non-RAC Oracle Databases, With Data Guard OMS/OEM and Claims databases ECF, FPM and Imaging Databases FileNET.
• RAC Installation and Nodes configuration implementations, support and trouble shoot issues.
• LINUX SUSE o/s Database RAC Multi node Cluster issues in RAC installations.
• RAC trouble shoot Issues like: O/s Versions compatibility issues, after patch apply issues CRS registry corruptions and recreation of crs and cleaning of crs, backup and restore of crs.
• Conducted DBA interviews for new DBAs. Sharing DBA troubleshoot techniques and centralized administration procedures with the TEAM.
• Creation and Maintain and support for all production and non-production environments including Pre-production,QA Test and Development databases.
• Periodic Security Patches,Oracle Database Patches ( both interim and Release )
• Version upgrades,Version Migrations
• Cloning Databases using Rman and with conventional methods.
• Primary/Standby Databases - Data Guard,In-house app. Releases and Database support
• Backup using exp,imp, data pump, Rman with veritas NETBACKUP Virtual TAPE Library.
• DRP periodic tests and Recovery of Databases in case of failures.
• BCV backups verification and Restore and recovery
• IBM P690 to P570 Server to Server migration Databases
• HACMP cluster configuration and Database failover and failback setup
• RAC nodes and Databases health checks.
• RAC add/remove nodes troubleshoot and resolve issues.
• SQL code walk through and tuning suggestions to Developers.

Oracle Database Architect and Consultant

Confidential, VA

Responsibilities:

• As an independent consultant analyzed the mainframe systems and prepared the deployment plans and suggested the conversion of Mainframe and initiated the 1st Oracle shop at GEICO.
• Dedicated and unprecedented efforts with small Team of 3DBAs continued to bring the systems with proven Proof Of Concepts to management.
• All Confidential Commercial Projects: ECF and INTERNET RTQ, Confidential Oracle Databases Physical and Logical designs are done and deployed successfully. Initiated the efforts in bringing HA environments set-up by setting up Data guard for Claims, Sales finance related transactional databases.
• Electronic Insurance Claims (ECF) project supported on 24X7 with high availability
• Rate Quotes RTQ project for Car insurancedatabases using Oracle High availability options.
• Policy Holder Confidential project for Car insurance production databases are supported 24X7

ORACLE DBA and Systems Analyst

Confidential, VA

Responsibilities:

• Served as a Senior Oracle DBA and Systems Analyst for the Defense projects for Confidential .
• Monitored the activities of Y2K conversion process of TOPS defense project.
• Supported the administrative activities and tuned the databases.
• Maintained the backup and recoveries on Sun Solaris server and NT clients for East Coast for a short time assignment.
• Involved in the TOPS (Transportation Operational Personal Property Standard System) Defense project.
• Design and testing phases of life cycle support of Application software for DOD Project.
• PPSO, PPPO, JPPSO, Oconus PPSO systems on LMC TOPS LAN are connected using Xyplex terminal Server and responsible for these systems Database Administration, Support, and Tuning.
• Participated in the Oracle Version 8.x Server core level Software Development and code implementation of Oracle Security Project.
• This security and authentication is supported under Distributed Computer Environment (DCE) with advanced network option (ANO) utilizing Oracle native communication software.
• Converted data from different databases to MS Access and ORACLE RDB, and provided front end GUI using Visual Basic 4.0 in the Windows NT and Windows 95 environments.
• Data conversion efforts and database admin and systems support provided for short time.