SUMMARY

• Oracle certified Expert, Oracle E - Business DBA Certified and Microsoft Certified Professional DBA with 15 years IT Experience in Oracle E-Business suite, Core ORACLE/SQL Server DBA in 24/7 Production/Development environment. Currently working as a Sr. Oracle Apps Architect/Database Consultant with demonstrated expertise in Planning and designing, Implementing Production Servers of Oracle Application, Oracle 12c/11g/10g/9i/8i and MS SQL Server 2012/2008/2005 /2000 and Working in 24x7 Total Technical Supports environment.
• Expertise and Interest include Database infrastructure Design, Administration, Multitenant Performance Analysis and troubleshooting of Production Complex Databases, Oracle E-Business suite and critical application.
• Worked in Government/Insurance/Financial sector. Planned and Designed Oracle RAC/Extended RAC and Microsoft SQL Clusters Environments by using Oracle 12c/11Gr2/10g/9i, RAC, Oracle ExaData database machine X2-2, Highly available E-Business 11i/R12, Oracle Active Data Guard for disaster recovery and failover, flashback technology and Oracle streaming on UNIX/Linux and windows environment.
• Experienced Oracle 12c container Database CDBS and PDBs and migrations.
• Expertise in design, implementation and administration of E-Business 11i/R12 Suite, upgrades and various database 9i/10g/11g upgrades, used Flashback and Active/Dataguard technologies minimal downtime.
• Oracle GRID Control 12c/11g/10g Implementation and customization to according business requirement. Various EM Management plug-ins configured.
• Experience in Oracle Middleware OAM, OIM, Single Sign-On, OID, Web logic configuration, Discoverer.
• Oracle tools SQLPLUS, RMAN, DGMGRL and SQL Tuning Advisor, Oracle ASM, AWR, ADDM, Statpack and support packs.
• Microsoft SQL Server 2012/2008/2005 /2000 Active/Passive clusters, AlwaysON availability, Database Mirroring, Replication and Disperse Clusters using various SANs HP/Compaq, IBM SAN, NetApp SAN replication and EMC replication
• Design Relational Databases model and Implementation as per business needs.
• Experience in extracting and transforming data using SSIS and DTS Import/Export Data, Bulk Insert, BCP and DTS, Oracle Exp/Imp, 10g Data Pump and Oracle SQL Loader Utilities.
• Experience in Performance Tuning, Query Optimization and Client/Server Connectivity.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Designing and implementing Virtualization platform by using Microsoft Hyper-V and VMWare.
• Active Directory Domain, Domain Controller and one way trust or two way trusts.
• Designed and Implemented Backup and Restore utilities and Disaster Recovery in various platforms. Microsoft Backup, VERITAS, EMC Legato, CommVault and ARCserve Backup Software using in Testing and Production Environment.
• Organized Exceptional and Professional Documentations, Trainings, Presentations and Oral/Written Interpersonal Communication Skills.

TECHNICAL SKILLS

Oracle Database: Oracle database 12c/11g, 10g, 9i/8i

MS SQL Server: Microsoft SQL Server 2012/2008/2005 /2000

Server OS: MS Windows Server 2012/2008/2003/2000 , SUN Solaris 10/9, Redhat Linux 6/5/4 and IBM AIX 6/5 Unix.

Architecture: ExaData, Oracle Application Cluster, ASM, OEM Grid Control, Oracle Streaming, DataGuard, MS Windows/SQL Cluster, Database mirroring, SQL replication and LOG shipping.

Applications: Oracle E-Business suite 11i/R12, PeopleSoft 9.0/9.1 CRM 4.0, Siebel CRM 8/7, SharePoint Services 3.0/Portal 2003.

Management: Oracle Enterprise GRID control 12c/11g/10g and MS SCOM, Idera.

Design Tools: ERWIN/ERX 4.1/7.1/7.3, Designer 2000

Development Tool: Oracle SQL developer, MS SQL Management Studio, Quest TOAD

Backup Software: Oracle RMAN, MS Backup, VERITAS, CommVault and ARCserve.

Virtualization: Microsoft Hyper-V, Virtual Server 2005, VMware ESX Server

Hardware/ Servers: Compaq/HP Proliant and Blades Servers, IBM X series And Dell Power Edge Servers. HP/NetApp/EMC Storages.

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

Sr. Oracle Apps Architect/Database Consultant

Responsibilities:

• Successfully Designed, Implemented and upgraded Oracle 11g R2 RAC on IBM AIX 7.0 with Oracle 11g active data guard/Standby for Oracle E-Business Suite.
• Designed and Implemented Shared EBS Application tier file system. Web Application services Performance Tuning, Concurrent Manager/Specialized rules configuration and fine tuning.
• EBS App tier Load balancing using F5, DMZ self-service configuration and SSL Configuration.
• Implemented Oracle 12c RAC container Database CDBS and PDBs and migrations lower versions.
• Implementation, supporting and administration of custom modules P2P, O2C, R2R and H2R.
• Concurrent Parallel processing, Technology stacks, JVM/Forms performance tuning as per resource utilization.
• Oracle E-Business Rapid cloning for all tier, Masking HCM and other critical data, EBS Patching and Oracle performance tuning, Stats pack, AWR, ASH, ADDM, RMAN, troubleshooting.
• EBS Production support administrations and troubleshooting, Concurrent Managers administrations, workflow administration and troubleshooting.
• Oracle OBIEE administration and supporting and Performance Analysis and tuning.
• Designed and Upgraded Oracle Enterprise Manger GRID control 12c from 11g set advanced level configuration for monitoring and alerting system as per the requirement
• Developed and Implemented Technical standards and procedure for EBS and databases environment.
• Performed all aspect of database administration, tuned SQL queries and stored procedures using SQL Profiler and Database Engine Tuning Advisor (DTA).
• Upgraded Oracle database version from 9i/10g to 11g/ 12c and used Oracle optimal flexible architecture.
• Used Oracle Exp/Imp, Data Pump and Oracle SQL Loader Utilities. Microsoft Integration services, BCP.
• Other critical application, OAM, OID, OBIE and golden gate replication administration and troubleshooting.
• Assisting the development team with tuning and optimization of SQL and PL/SQL code for long running and highly used resource queries.
• Working with Oracle support to open, manage and resolve service issues with the Oracle products support via Oracle SR.

Confidential, Washington, D.C

Sr. Oracle Apps Architect/Database Lead with SME

Responsibilities:

• Successfully Designed, Implemented and administering Oracle Exadata database machine X2-2 and Oracle 11g R2 RAC on Oracle unbreakable Linux with Oracle 11g active data guard/Standby between two data center for Disaster recovery for Oracle E-Business Suite and other critical application databases.
• Upgraded Oracle database version from 9i/10g to 11g and used Oracle optimal flexible architecture.
• Successfully Designed, Implemented and upgraded Oracle E-Business Suite 11i/R12 Highly available Application with file sharing apps tier configuration and performance analysis and tuning.
• Implemented Oracle ASM, Flashback, Active/Dataguard technologies for recover human errors and with disaster recovery to reduce critical application downtime. Performance tuning for long running reports
• Implemented highly available with shared application tier with load balancing using F5. Parallel Concurrent Processing servers and Discoverer.
• Designed and Implemented Oracle Enterprise Manger GRID control 12c/11g, to proactively monitoring and administrate oracle ERP and databases. Implemented and configured Oracle 11g Middleware fusion SSO/OID. EBS management pack for Oracle Grid Control.
• Performed Oracle Middleware WebLogic implementation and configuration.
• Oracle E-Business Rapid cloning for all tier, Application tuning, Oracle performance tuning, Stats pack, AWR, ASH, ADDM, RMAN, Patches, Performed PCP performance tuning and troubleshooting and OATM model implementation. Technology stacks, JVM/Forms performance tuning as per resource utilization.
• Successfully Designed and implemented Microsoft SQL 2012 8 NODEs with AlwaysON and 2008 R2 enterprise 8 NODEs cluster with multiple instances on Microsoft Windows 2012/2008 R2 enterprise windows Multi Site Cluster with EMC Recovery Point SAN storage block level replication and configured Database Mirroring for Disaster recovery. Migrated Agencies databases to highly available production environment.
• Performed all aspect of database administration, tuned SQL queries and stored procedures using SQL Profiler and Database Engine Tuning Advisor (DTA).
• Used Oracle Exp/Imp, Data Pump and Oracle SQL Loader Utilities. Microsoft Integration services, BCP.
• Assisting the development team with tuning and optimization of SQL and PL/SQL code for long running and highly used resource queries.
• Working with Oracle support to open, manage and resolve service issues with the Oracle products support via Oracle SR.
• Testing and apply Oracle and SQL Server security patches and patchset updates on development and production database environment during maintenance windows.
• Implemented Window server 2012 Enterprise Cluster with SQL Server 2012 Ent with Always on feature in DEV and Pre-Prod environment.

Environment: Oracle 11g/10g/9i, E-Business R11/R12, Solaris, MS SQL Server 2012/2008/2005 , Win 2012/2008/03 Oracle unbreakable Linux 5/6, Oracle Grid 12c/11g, Oracle Clustering, OLTP Applications, Database Performance Analysis and Tuning, Oracle Data Guard, Rman Backup and Recovery, Redhat Linux 5, Sun Solaris 9, IIS, FTP, DTS, SSIS, ASP, XSL, XML Web Services, Unix Shell Scripting, JavaScript, CSS, IIS 7/6 and SSRS and SSAS

Confidential, Philadelphia, PA

Sr. Oracle Apps DBA/Database Consultant

Responsibilities:

• Designed and implemented Oracle E-Business 11i/R12 suite on Oracle RAC 11g database on RedHat Linux Enterprise with Oracle physical standby database servers. Worked on administration and troubleshooting highly available application and databases.
• Provide on-call production support for Oracle E-Business Suite R12 application databases. Patching, EBS cloning, concurrent manager administrations and performance issues, Oracle discoverer. Worked on Middleware SSO application, Oracle OID, Reporting.
• Extensive experience with proactive monitoring, troubleshooting and tuning of all aspects of Oracle Suite and database environment.
• Performed Oracle database upgrades from 9i/10g to Oracle 11g with very minimal downtime. Used Oracle flashback and dataguard technologies
• Implemented and configured Oracle 10g Grid Control for monitoring all Oracle RAC databases, ERP application. Configured notification alerts and Problem Remediation Scripts via both homegrown scripts using Perl and Windows/VB scripting.
• Performed on daily application and databases administration and performance tuning by using utilities RMAN, AWR, ASH, SQL Tuning advisor, stats pack. Data Pump and Exp/Imp,
• Assisted the application development team with tuning and optimization of long running SQL and PL/SQL queries for better performance.
• Worked with Oracle support to open, manage and resolve service issues with the Oracle products support via Oracle SR.
• Successfully Designed, Implemented, and Administering Microsoft Windows Server 2008 and 2005 Cluster and Microsoft SQL Server 2008 and 2005 clusters.
• Monitor database files, data block corruption, segment fragmentation.
• Worked on Data Center migration and consolidation which include applications and Oracle 11/10g database and SQL Cluster 2008/2005 database servers.
• Designed and implemented comprehensive Backup plan procedures and disaster recovery strategies, Build and enhanced Oracle application, Oracle databases and SQL Servers best practices and security Standards.

Environment: Oracle 11g/10g, Oracle E-Business suite11i/R12, MS SQL Server 2008/05/00, Win 2008/03 Oracle Grid control, Oracle Clustering, OLTP Applications, Oracle Data Guard, RMAN, RedHat 5, IIS, FTP, DTS, SSIS, IIS 7/6 and SSRS and SSAS.

Confidential, Harrisburg, PA

Sr. Database Administrator

Responsibilities:

• Worked as a Database Administrator and I was responsible for requirement analysis, design, document, development, enhancement and support of Oracle RAC Databases and MS SQL Server databases
• Involved in Architectural design for the databases and database tables and capacity planning.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Implemented Oracle DataGuard for Disaster recovery, administration and troubleshooting.
• Implementation of Oracle 10g on AIX Servers for SAP ERP application, performed administration and performance monitoring.
• Oracle database backup and recovery, refreshing databases in Development, test and pre-prod environment. RMAN utility, 10g Data Pump and Exp/Imp, SQL Tuning advisor. Database security and standards.
• Assisted the development team to developed tables, views, procedures, and packages with tuning and optimization of SQL and PL/SQL queries.
• Implemented and configured Enterprise GRID control Manager (OEM) for Monitoring, Alert and Problem Remediation and using perls and VB scripting.
• Worked with Oracle support to open, manage and resolve service issues with the Oracle products support via Oracle SR.
• Oracle performance tuning support pack and Statspack, AWR, ASH, ADDM, RMAN, Oracle Universal Installer, Oracle patches testing and applying in production databases during maintenance window.
• Successfully Designed, Implemented, and Administering Microsoft Windows Server 2008 Cluster and Microsoft SQL Server 2008/2005 Active/Passive clusters.
• Designed and developed for data migration and ETL for loading data to data warehouse.
• Worked on SQL Server Data Partitioning, Snapshot replication and transactional replication.
• Tuned SQL queries and Stored procedures using SQL Profiler and Index Tuning Wizard.
• Oracle RAC and Database Performance issues, security threat, locking and blocking issues, resource issues CPU, Memory and I/O. Manage high volume transactional tables and indexes, reorganization/rebuild indexes and query optimization.
• Verified backups and error logs on the servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with other department’s team.
• Responded to trouble tickets assigned and fixed any database issues promptly, worked on projects that initiated by higher management.
• Worked on VMware virtualization in development and testing environment.

Environment: MS SQL Server 2008/05/00, Oracle 10g, Win 2008/03 AIX Unix, Oracle Grid, Oracle Clustering, Oracle Administration, OEM, OLTP Applications, Database Performance Analysis and Tuning, Oracle Data Guard, Rman Backup and Recovery, IIS, FTP, MQ Series, SAP, WBI VB, ASP, XSL, XML Web Services, JavaScript, CSS, IIS 7/6, SSRS, SSAS SSIS.

Confidential, Philadelphia, PA

Database Lead

Responsibilities:

• Successfully Designed, Implemented and administration of MS Windows Server 2003 64bit with Oracle 10g and MS SQL Server 2005 for production and staging.
• Designed and supported to build Data Warehouse Star Schema by using Erwin Data Modeler.
• Designed and developed SQL Server Integration Services (SSIS) to pull full monthly and daily incremental data from Oracle OLTP Databases.
• Designed and developed ETL for loading data from staging to Data Warehouse. Scheduled SSIS packages.
• Implemented SQL Server Security, Backup and Restore policy. Scheduled jobs and alerts using SQL Server Agent.
• Developed T-SQL stored procedures as a part of database maintenance plan for new SQL Server 2005.
• Performed all aspect of database administration, tuned SQL queries and stored procedures using SQL Profiler and Database Engine Tuning Advisor (DTA).
• Supported for designing and implementation of Cognos Reporting.

Environment: MS SQL Server 2005, T-SQL, Win 2003, IIS, FTP, DTS, SSIS, Oracle 9i, Web Services, IIS 6.0 and Cognos 8 Reporting.

Confidential, Harrisburg, PA

Sr. Database Consultant

• Worked on Oracle 10g/9i on AIX Servers and performed Installation, administration and performance monitoring.
• Oracle database backup and recovery, refreshing databases in Development, test and pre-prod environment. RMAN utility, SQL Tuning advisor. Database security and standards.
• Oracle database security and Users authentication. Tablespaces, data files, SQL/PLUS and PL/SQL.
• SQL Server and Oracle Performance issues, security threat, locking and blocking issues, resource issues CPU, Memory and I/O. Manage high volume transactional tables and indexes, reorganization/rebuild indexes and query optimization.
• Provide application deployment and code migration support to the project/team lead on deploying new Application, DB objects and data changes through the various stages of the development life cycle.
• Apply security patches to Oracle and SQL Servers; maintain regularly hot and cold backup and recovery, policies/procedures/scenarios for the databases.
• Involved in Architectural design for the databases and database tables and capacity planning.
• Verified backups and error logs on the servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with other department’s team.

Confidential, Richmond, VA

Sr. Oracle Apps DBA/Database Consultant

Responsibilities:

• Oracle Application and database implementation, upgrades and performance tunings.
• Designed and Implemented Oracle RAC 10g for Oracle E-Business 11i suite. Upgraded from Oracle 9i database to Oracle 10g database compatibility patches deployment and performance tuning and go live.
• Worked on complete cycle of setting up financial, HR and Manufacturing Modules.
• Oracle E-Business cloning for all tier, Application tuning, Oracle performance tuning, Stats pack, Application Patches, concurrent Manager optimization, Performed performance tuning and troubleshooting and Technology stacks, JVM/Forms performance tuning as per resource utilization.
• Complete support for the Oracle application and Databases. Creating and Maintaining Databases, Adding Users, Roles, and Groups and assigning privileges according to the project needs.
• Implemented disaster recovery by using Oracle physical standby database and backup plans and procedures.
• Performed Oracle application cloning all tiers, performance tuning by using ASH, AWR, ADDM, Stat packs and Database tuning advisers.
• Implemented and configured Oracle 10g Grid Control to monitoring highly available application databases.
• Created Database Maintenance plans, Managed Database Structures, Disk Spaces, scheduling Database Backups, Restoring Databases and Maintained data accuracy and consistency.
• Provided support to the Data Center team in their development and truncated the transaction logs to check the space of the exponentially expanding databases.
• Performed upgrade of OS, Applications & file system expansions as and when required. Used VB scripts.
• Managed the production database servers Taking daily backups by using VERITAS Net backup.

Environment: Oracle E-Business 11i Financial, HR and Manufacturing Modules, Oracle 9i/10g, windows 2003/2000 Servers, IIS, FTP, SQL Profiler, VERITAS, MS MOM 2005 Server, Oracle Grid, Oracle Clustering, OEM, OLTP Applications, Database Performance Analysis and Tuning, Oracle Data Guard, Rman Backup and Recovery, ASP.Net, C#.Net, ADO.Net, XML, XSL, XML Web services and Network Support

Confidential, Stamford, CT

Oracle Apps DBA/Database Administrator

Responsibilities:

• Designed and Implemented for Oracle E-Business 11i suite on production environment. Support many other application on oracle databases on Oracle 9i/10g databases.
• Upgraded Oracle 9i database to Oracle 10G databases, administration and patching and patching and troubleshooting.
• Worked on Oracle E-Business cloning on all tier, Concurrent Managers administrations and concurrent program performance issues and tuning.
• Application/Oracle Patching as per requirement, supporting and coordinating with development and functional team in order to implement solutions and fixes.
• Daily performance monitoring, supporting application users and responsibility related administration.
• Complete support for the Oracle application and Databases. Creating and Maintaining Databases, Adding Users, Roles, and Groups and assigning privileges according to the project needs.
• Installed, configured and administered and troubleshooting Oracle 9i and Oracle 10g high availability on SUN Solaris.
• Monitor database log files, data block corruption, segment fragmentation.
• Backing and recovery of Oracle databases. SQL/PLUS, PL/SQL, RMAN utility, SQL Tuning advisor, Performance and tuning, DBCC.
• Oracle Enterprise Manager, Export/Import Utility, Data Bump utility. Oracle. AWR, Statspack, ADDM, Oracle Universal Installer, Oracle Patch testing and applying in production databases.
• Implemented, configured and Monitoring, Alert and Problem Remediation Scripts via both the OEM Oracle 10g Enterprise GRID Control Manager/Oracle Management Server.
• Provide application deployment and code migration support to the project/team lead on deploying new Application, DB objects and data changes through the various stages of the development life cycle.
• Apply security patches to Oracle and SQL Servers; maintain regularly hot and cold backup and recovery, policies/procedures/scenarios for the databases.
• Oracle and SQL server databases performance issues, security threat, locking and blocking issues, resource issues CPU, Memory and I/O. Manage high volume transactional tables and indexes, reorganization/rebuild indexes and query optimization.
• Designed and implemented Backup plan and disaster recovery strategies
• Involved in trouble shooting and fine-tuning of databases for its performance and high availability.
• Implemented and administrated transactional and snapshot replication.
• Day to Day basis reviewing Performance monitor and Event logs on all Oracle Server and SQL Servers.
• Verify backups and error logs on the Oracle and SQL servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with technicians from other departments.

Environment: Oracle 9i/10g, Oracle E-business Suite 11i and Sun Solaris, Windows 2000/2003 MS SQL Server 2005/2000, Oracle Grid, Oracle Clustering, Oracle Administration, OEM, OLTP Applications, Database Performance Analysis and Tuning, Oracle Data Guard, Rman Backup and Recovery, IIS, FTP, ASP.Net, Unix Shell Scripting, C#.Net, ADO.Net, XML, XSL, XML Web services, JavaScript, CSS, IIS 6.0 and Crystal Reports.

Confidential

Database Administrator Lead

Responsibilities:

• Worked on Database Implementation and Administration and provided 24x7 supported in production Oracle Application and database Environment. Managed a team of 5 Network Support Engineers.
• Supported and administrated Oracle Business Suite 11/11i, Installed, configured and administrated Oracle 9i on Sun Solaris environment, Performance monitoring and tuning. Performed Oracle apps user and their responsibility administration and authentication,
• Oracle E-business backup and recovery plan, Oracle/Apps maintenance tasks, Tuning Queries, blocking and deadlocks issue and concurrent manager administrations and troubleshooting.
• Rebuilt the indexes at regular intervals for better performance
• Designed and implemented comprehensive backup plan and disaster recovery strategies Implemented and Scheduled Replication process.
• Analyzed long running slow queries and tune the same to optimize application and system performance.
• Successfully designed and implemented and administrated Windows 2003/2000 Cluster and Microsoft SQL Server 2000 Active /Passive cluster by using HP Storage Area Network.
• Designed, tested and implemented of DTS packages. Developed SQL Procedure, Views and Triggers.
• Automated SQL Server error log notification process. Used DBCC.
• Successfully Designed, Implemented, Supported and Administrated Windows 2003/2000 Active Directory Domain, Domain Controllers, Global Catalog Server, Sites, Organizational Units, File and Print Services, Groups Policies Objects, Auditing Policy and Restriction. Created trusts in multiple domain and forests by one way trust or two way trusts.
• Designed and tested Backups and Disaster Recovery strategies and applied in Production environment.

Environment: Oracle E-Business Suite 11/11i, Oracle 9i enterprise, MS SQL Server 2000, Windows 2000/2003, Oracle Application

Confidential

Database Administrator and System Administrator

Responsibilities:

• Worked as DBA and System Administrator in Technical support department, provide complete support to Implementation, Migration, Maintenance and end user support.
• Installed and administrated Oracle 8i on SUN Solaris. PL SQL Installed, Configured and administrated Microsoft SQL Server 2000/7.0. Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various groups and users.
• Worked on the Oracle Recovery Management and SQL Server backup, disaster recovery plan and data restoration
• Worked on T-SQL stored procedures as a part of database maintenance plan for SQL Server 2000. Used system stored procedures and DBCC commands.
• Successfully designed and implemented and administrated Windows 2000/NT4.0 Enterprise.