SUMMARY:

• Oracle certified Expert and Microsoft Certified Professional DBA with 19 years IT Experience in Oracle ExaData, PeopleSoft, Oracle Application, Environment build and Lead skills. Currently working as a Sr. Technical Architect/PeopleSoft Consultant with demonstrated expertise in Leading planning, designing and Implementing Production Servers of PeopleSoft, ExaData, Oracle and SQL Servers and Working in 24x7 Total Technical Supports environment.
• Responsible to Plan, direct and oversee the IT Database Infrastructure design and Operational management, leading projects, cost saving and meeting goals. Implementing IT procedure policies and best practices.
• Expertise and Interest include Database infrastructure Design, Administration, Performance Analysis and troubleshooting of Production Complex Databases, Oracle PeopleSoft Databases and critical application.
• Worked in Government/Insurance/Financial sector. Planned and Designed Oracle RAC with disaster recovery, Oracle ExaData database machine X4 - 2/X3-2/X2-2, Highly available E-Business 11i/R12, Oracle Active Data Guard, Oracle Extended RAC and failover, flashback technology and Oracle streaming on UNIX/Linux and windows environment. Experience in Oracle 12c CDBs and PDBs and migrations to the Container databases.
• Expertise in design, implementation and administration of PeopleSoft 9.2/9.1 Environment, upgrades and DR Strategies. PeopleSoft database high availability and Disaster Recovery setups.
• Experience in ExaData Smart Scan, Storage Indexes, Smart Flash Cache, IORM, DBRM, Inter-leaved Grid Disks. CellCli, DCli ExaData grid disks ASM disk groups, IO Resource management using iormplan.
• 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, CellCLI Statpack and support packs.
• Microsoft SQL Server 2012/2008/2005 /2000 Active/Passive clusters, Always ON availability, Database Mirroring, Replication and Dispersed Clusters using various SANs Confidential /Compaq, IBM SAN, NetApp SAN replication and EMC replications.
• Experience in Load balancing F5, NetScaler, and providing recommendation as per the applications.
• 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, Data Pump and Oracle SQL Loader Utilities.
• Experience in Performance Tuning, Query Optimization and Client/Server Connectivity.
• Experience in Backup, Recovery and Disaster Recovery procedures. Azure/Oracle/AWS cloud services.
• 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. DNS/WINS
• 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 operational management skills, Technical understanding and documentations, Trainings, Project management, Visio, Presentations and Oral/Written Interpersonal Communication Skills.

TECHNICAL SKILLS:

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

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

Server OS: MS Windows Server 2016/2012/08/2003/2000 , SUN Solaris 10/9, Red hat Linux 6/5/4, Oracle unbreakable and IBM AIX 6/5 UNIX.

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

Applications : PeopleSoft 9.2/9.1/9.0/8.0 , PeopleTools 8.55/8.54/8.53/8.52/8.50 CRM 4.0, Siebel CRM 8/7, SharePoint Server 2010/07/03.

Management : Oracle Enterprise GRID control 13c/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 Server 2012/08 R2 Hyper-V, VMware ESX Server 5.0/5.1

Hardware:   Confidential ProLiant and Blades Servers, IBM X series And Dell Power Edge Servers. Confidential /NetApp/EMC Storages.

PROFESSIONAL EXPERIENCE:

Confidential, Hartford, CT

Sr. Technical Architect/Sr. PeopleSoft Consultant 

Responsibilities:

• Working with Program Manager, leading projects and lead the team of admins to analyze, planning and implementation of highly available PeopleSoft ERP 9.2 environment solutions with DR capacities to achieve minimal downtime to achieve better RPO/RTO.
• Designed, Implemented PeopleSoft 9.2 Environment DR Solutions for highly available VLDB Oracle databases on ExaData 12c/11g, PeopleSoft Virtualizations high availability and smooth failover capability.
• Designed and implemented PeopleSoft Active/Active between 2 data center environment.
• PeopleSoft upgrade 9.1 to 9.2 HCM, FSCM and CRM support and administrations and coordinating with PeopleSoft developers for performance analysis and performance optimizations.
• Working with PeopleTools 8.54/8.53 components, PeopleSoft update manager PUM, compare reports.
• PeopleSoft App Engines, Process scheduler, Web Servers configuration and administrations.
• PeopleSoft HCM, Financial, Pension modules performance tuning/optimizations, troubleshooting and working with developers and giving recommendations for long running App Engine, SQR,COBOL and EPM process tracing and performance troubleshooting. People code, PSBUILD and data execute scripts. BI publishers and Integration brokers.
• Oracle ExaDataV4, V5, ExaData RAC 12c/11g, Active Data guard implemented between two sites and Reporting purposes and PeopleSoft Application offloading PSQUERY jobs and others.
• Build PeopleSoft HCM/Financial databases and cloning to lower environments. Working with Teams and coordinating process, administrations and leading projects.
• Working with Project managers, PeopleSoft technical analysis and requirement gathering and build detailed design and documentations.
• Oracle OBIEE support and Database administrations
• Designed and Implement Oracle Enterprise Manger 12c set advanced level configuration for monitoring and alerting system as per the requirement. Golden gate replications for reporting.
• Review and make recommendations for F5 network load balancing LTM and GTM Enterprise solutions.
• Provided recommendations for Oracle ExaData V4, Grid/Cell Disk and ASM Configuration and balancing between various databases for better performance. Oracle ExaData RAC advance configuration. Oracle unbreakable configuration.
• Providing recommendations and best practices of SAN Storage, RAIDs, LUN, HBAs, MPIO, IP addresses,
• Oracle Active Data guard implemented between two sites for Disaster recovery and reporting purposes.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Database performance analyze and give recommendations. Working with Project Managers, team leads and members to coordinate and implement recommended solutions.
• Organized Exceptional operational management skills, Technical documentations, MS Office, Trainings, Project management, Visio, Presentations and Oral/Written Interpersonal Communication Skills.

Environment: PeopleSoft 9.2/9.1 upgrade, PeopleTools .8.54/8.54, Oracle 12c/11gr2, Oracle Linux, Grid control 12c/13c, Oracle ExaData, ASM, FTP, PIA, PUM, data conversion SQL, Compare Reports, OEM, RMAN, GoldenGate, SOA, XML, HTML, BI Publisher, Integration Broker, Middleware, Web Services, Unix Shell Scripting, JavaScript, MS Office, word, excel, PowerPoint, Visio, MS Project, Windows Server 2012 R2, SQL Servers 2012, Windows 10/7.

Confidential, Malvern, PA

Sr. PeopleSoft DBA/Database Solution Architect 

Responsibilities:

• Designed and Implemented and upgraded Oracle RAC 10g/11g R2 on Oracle Unbreakable Linux 6.4 Operating System.
• Planning and Implemented Oracle ExaData, Grid/Cell Disk and ASM Configuration and balancing between various databases for better performance. InfiBand Switches configurations. Oracle ExaData RAC advance configuration. Oracle unbreakable configuration.
• Oracle Active Data guard implemented between two sites for Disaster recovery and Reporting purposes.
• Implementation of PeopleSoft HCM Data warehouse EPM. Loading Data using ETL tools and customizing HCM reporting.
• Planning and implementation of 9.2 HCM, FSCM and supporting upgrade and maintenances.
• PeopleSoft technical analysis and requirement gathering, build detailed design and documentations.
• Clone PeopleSoft environment from Production to lower environment and Upgrade environments.
• Worked with PeopleTools 8.54/8.53 components, PeopleSoft PUM, compare reports. PSADMIN utilities.
• PeopleSoft App Engines, Process scheduler, Web Servers configuration and administrations.
• PeopleSoft HCM, FSCM modules and review performance tuning/optimizations, troubleshooting. Working with PeopleSoft developers and giving recommendations for long running App Engine, SQR, People code, COBOL, SQR, Integration brokers, BI publishers, XML, HTML and EPM, process tracing and performance troubleshooting. PSBUILD and execute scripts. Execute compare reports.
• Implemented Oracle ExaData Hybrid Column compression like ware house/Archive/online compression according to the requirement and better performance.
• Configured ExaData IORM and DBRM between the databases Instances CPU will be prioritized according to the requirement of Application database Instances.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Providing SAN Storage recommendation and space allocation and RAID allocations for Oracle Servers.
• Oracle Table partitioning and ExaData compression for Data compression and archiving.
• Designed, Implemented and upgraded Microsoft SQL Server 2014/2012 Cluster on Windows Server 2012 R2 Physical and Virtual Environment.
• Microsoft Hyper-V Virtualization and total cost saving strategies and deployments and DR Methods
• Designed and implemented comprehensive Backup plan and disaster recovery strategies for SQL Servers Database Environment for high availability and disaster recovery.
• Providing SAN Storage recommendation and space allocation and RAID allocations for SQL Clusters and Always On enabled Server on data centers.
• Implemented configured Oracle Enterprise Manger GRID control 12c to monitor Oracle ExaData and other Oracle Stacks.
• Database performance tuning, Stats pack, AWR, ASH, ADDM, RMAN, troubleshooting.
• Database Performance issues, security threat, locking and blocking issues, slow queries, query plans, statistics, resource issues CPU, Memory and I/O. Manage high volume transactional tables and indexes, reorganization/rebuild indexes and query optimization.
• Working with Oracle support and Database related issues and resolve or bugs with the Oracle products support via Oracle SR.
• Organized Exceptional operational management skills, Technical documentations, MS Office, Trainings, Project management, Visio, Presentations and Oral/Written Interpersonal Communication Skills.

Environment: PeopleSoft 9.2/9.1 upgrade, PeopleTools .8.54/8.54, Oracle 12c/11gr2, Oracle Linux, Grid control 12c, Oracle ExaData, ASM, FTP, PIA, PUM, data conversion SQL, Compare Reports, OEM, RMAN, Golden Gate SOA, XML, HTML, BI Publisher, Integration Broker, Middleware, Web Services, Unix Shell Scripting, JavaScript, MS Office, word, excel, PowerPoint, Visio, MS Project, Windows Server 2012 R2, SQL Servers 2012/2014, Windows 10/7.

Confidential, Arlington, VA, MN

Sr. ExaData Consultant 

Responsibilities:

• Worked with Program manager applications technical analysis and requirement gathering, build detailed designs and documentations.
• Planning and Implemented Oracle ExaData, Grid/Cell Disk and ASM Configuration and balancing between various databases for better performance. InfiBand Switches configurations. Oracle ExaData RAC advance configuration. Oracle unbreakable configuration.
• Implemented Oracle ExaData Hybrid Column compression like ware house/Archive/online compression according to the requirement and better performance.
• Configured ExaData IORM and DBRM between the databases Instances CPU will be prioritized according to the requirement of Application database Instances.
• Oracle Table partitioning and ExaData compression for Data compression and archiving.
• Implemented Migration Strategies of 40tb Data warehouse from SQL Server 2008 R2 to Oracle ExaData X3-2 Machines. ExaData features HCC compression, IORM, Instance caging and smart cache.
• Data center strategies and consolidation on Oracle ExaData, Oracle RAC 11g/10g Servers Databases consolidations and resource balancing.
• Oracle Active Data guard implemented between two sites for Disaster recovery and Reporting purposes.
• Database maintenance and performance troubleshooting.
• Organized Exceptional operational management skills, Technical documentations, MS Office, Trainings, Project management, Visio, Presentations and Oral/Written Interpersonal Communication Skills.

Confidential, Pittsburgh, PA

Sr. Database Architect 

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.
• Coordinating on new projects and working closely with Development and Functional team to implement new projects, bug fixes and add on features.
• 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.
• Worked on database performance tuning and troubleshooting, application performance.
• 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 and used Oracle optimal flexible architecture.
• Used Oracle Exp/Imp, Data Pump and Oracle SQL Loader Utilities. Microsoft Integration services, BCP.
• Other critical application support 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.
• Organized Exceptional operational management skills, Technical documentations, MS Office, Trainings, Project management, Visio, Presentations and Oral/Written Interpersonal Communication Skills.

Confidential, Washington, D.C

Sr. Database Architect with SME 

Responsibilities:

• Worked with Program manager, applications environment technical analysis and requirement gathering, build detailed designs and documentations.
• Successfully Designed, Implemented, and Administering Oracle 11g R2 RAC on Oracle unbreakable Linux for PeopleSoft, data warehouse with Oracle 11g active data guard/Standby between data center for Disaster recovery for critical application.
• Successfully Designed and implemented Microsoft SQL 2012/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.
• Implemented Oracle many Standalone Oracle 11g/10g/9i server as part of Agencies Data center migration.
• Designed and Implemented Oracle Enterprise Manger GRID control 12c/11g, WebLogic to proactively monitor and administrate oracle databases. Implementation, Supporting and troubleshooting application databases of PeopleSoft, UC4, Accela, FileNet, SOA, Motorola CSR, IQ and other inbuilt applications.
• Many Enterprise Application data extraction and Integration and processing WSDL, XML, XSD, XSL Architecture documents.
• Performed all aspect of business related data Extraction, integration, tuned SQL queries and stored procedures.
• Implemented, configured and Monitoring, Alert and Problem Remediation Scripts via both the OEM Oracle 11g Enterprise GRID Control Manager/Oracle Management Server. Homegrown scripts using Perl and Windows/VB scripting.
• Worked on cloud compute Amazon AWS, EC2 on testing and consolidations for DC Applications.
• 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.
• Organized Exceptional operational management skills, Technical documentations, Ms Office, Trainings, Project management, Visio, Presentations and Oral/Written Interpersonal Communication Skills.

Environment: Oracle 11g/10g/9i, PeopleSoft 9.1/9.0, MS SQL Server 2012/2008/2005 , Win 2012/2008/03 Oracle unbreakable, Oracle Grid, Oracle Clustering, Oracle Administration, OEM, OLTP Applications, Database Performance Analysis and Tuning, Oracle Data Guard, RMAN Backup and Recovery, Linux 5, IIS, FTP, DTS, SSIS, ASP, SOA, XSL, XML Web Services, Unix Shell Scripting, JavaScript, CSS, IIS 7/6 and SSRS and SSAS, MS Office, word, excel, PowerPoint, Visio and MS Project management.

Confidential, Philadelphia, PA

Sr. Database Consultant /PeopleSoft Consultant 

Responsibilities:

• Worked with Program Manager, PeopleSoft and databases technical analysis and requirement gathering, build detailed designs and documentations.
• Worked on Data Center migration Oracle 11/10g servers running in Red Hat Enterprise and performed administration. Backing and recovery of databases. RMAN utility, SQL Tuning advisor, Performance monitoring and tuning.
• Assisted the application development team with tuning and optimization of long running SQL and PL/SQL queries for better performance.
• Working with PeopleSoft tools 8.50 components, execute compare reports, PSADMIN utility, BI publishers, XML, HTMLs, WebLogic, Integrations brokers. PSBUILDS and execute scripts,
• PeopleSoft App Engines, Process scheduler, Web Servers configuration and administrations.
• Implementation and administrations PeopleSoft FSCM, performance tuning/optimizations, troubleshooting and working with developers and giving recommendations for long running App Engine, SQR,COBOL and EPM process tracing and performance troubleshooting. Execute data scripts, Data Mover.
• Designed and implement Oracle RAC 11G for the enterprise application PeopleSoft database, and administrated database.
• Provide on-call production support for PeopleSoft 9.0 FSCM, HCM and EPM environments on both Oracle and SQL server platforms.
• Full cycle implementation experience with Financials, EPM and Portal 9.0 w/Oracle on Linux
• Extensive experience with proactive monitoring, troubleshooting and tuning of all aspects of PeopleSoft architecture
• Implemented, configured and Monitoring, Alert and Problem Remediation Scripts via both the OEM and Oracle Management Server. Homegrown scripts using Perl and Windows/VB scripting.
• 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.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies. Building Oracle and SQL Servers best practices and security Standards.
• Monitor database files, data block corruption, segment fragmentation.
• Oracle and SQL Server 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.
• Worked on Idera SQL safe and Idera Diagnostic manager.
• Microsoft Hyper-V and VMware ESX virtualization used for consolidation of database servers and application servers.
• Organized Exceptional operational management skills, Technical documentations, MS Office, Trainings, Project management, Visio, Presentations and Oral/Written Interpersonal Communication Skills.

Environment: Oracle 11g/10g/9i, PeopleSoft 9.0, MS SQL Server 2012/2008/2005 , Win 2012/2008/03 Oracle unbreakable, Oracle Grid, Oracle Clustering, Oracle Administration, OEM, OLTP Applications, Database Performance Analysis and Tuning, Oracle Data Guard, RMAN Backup and Recovery, Linux 5, IIS, FTP, DTS, SSIS, ASP, SOA, XSL, XML Web Services, Unix Shell Scripting, JavaScript, CSS, IIS 7/6 and SSRS and SSAS

Confidential, Harrisburg, PA

Sr. Database Architect 

Responsibilities:

• Worked as a Database Architect and Integrator and I was responsible for requirement analysis, design, document, development, and enhancement and supporting SAP application on Oracle RAC.
• Architectural design and Data Modeling, data extraction and integration to SAP application from various Business Customers data from various source by using Web sphere MQ Series and Web sphere Integration WBI tools. Processing WSDL, XML, XSD, XSL Architecture documents as business model needs.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Implemented Oracle Data Guard for Disaster recovery, administration and troubleshooting.
• Implementation of Oracle 10g on AIX Servers for SAP ERP application, performed administration and performance monitoring.
• Worked with Project Manager, databases environment technical analysis and requirement gathering, build detailed designs and documentations.
• Oracle database backup and recovery, refreshing databases in Development, test and pre-prod environment.
• Designed and developed for data migration and ETL for loading data to data warehouse.
• 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 Perl’s 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 Stats pack, AWR, ASH, ADDM, RMAN, Oracle Universal Installer, and 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.
• Worked on SQL Server Data Partitioning, Snapshot replication and transactional replication.
• 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.
• Worked on VMware virtualization in development and testing environment.
• Organized Exceptional operational management skills, Technical documentations, MS Office, Trainings, Project management, Visio, Presentations and Oral/Written Interpersonal Communication Skills.

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

Confidential, Philadelphia, PA

Database Lead 

Responsibilities:

• 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, data conversion. 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.
• Organized Exceptional operational management skills, Technical documentations, MS Office, Trainings, Project management, Visio, Presentations and Oral/Written Interpersonal Communication Skills.

Confidential, Harrisburg, PA

Sr. Database Consultant 

Responsibilities:

• Various applications are running across Oracle RAC and data extraction and integration from multiple location for SAP application using Web sphere WBI. It involves around 3.1 TB of data coming from different data sources and is distributed on around 100 databases.
• Worked on Oracle 10g/9i on AIX Servers and performed Installation, administration and performance monitoring.
• Architectural design and Data Modeling, data extraction and integration to SAP application from various Business Customers data from various source by using Web sphere MQ Series and Web sphere Integration WBI tools. Processing WSDL, XML, XSD, XSL Architecture documents as business model needs.
• 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. Table spaces, data files, SQL/PLUS and PL/SQL.
• SQL Server and data conversion, 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. PeopleSoft/Database Consultant 

Responsibilities:

• Performed PeopleSoft 8 Financial and HR implementation on Oracle RAC 10g, configuration, administration and upgrade. Finished complete cycle of setting up Financial and HR PeopleSoft 8 environments from database creation to application server, process scheduler, web logic server and PIA configuration.
• Complete support for the PeopleSoft environment and Oracle Database. Creating and Maintaining Databases, Adding Users, Roles, and Groups and assigning privileges according to the project needs.
• PeopleSoft 8 environment support and administrations, maintenance. Working PeopleSoft developers. Worked with PeopleTools 8.47, Process scheduler, App Engine, PS admin utility. Application designer, compare reports, data mover, data conversions, Performance tuning and recommendations, resolving long running queries.
• PSBUILDS and execution scripts and running compare reports for changes.
• Created Database Maintenance plans, Managed Database Structures, Disk Spaces, scheduling Database RMAN Backups, Restoring Databases and Maintained data accuracy and consistency.
• PeopleSoft cloning database and PS environment configurations, dprod executions.
• Successfully Designed, Implemented, and Administered Microsoft Windows Server 2003 Cluster and Microsoft SQL Server 2005 Active/Passive cluster.
• Migrated DTS objects to SQL Server Integrated Services(SSIS) environment
• Setup transactional and snapshot replication, Implemented log shipping technology. Worked on Data partitioning and performance tuning.
• Analyzed, fine-tuned and optimized MS SQL Server Applications by using Performance Monitor, setting up traces using SQL Profiler.
• 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.
• Daily basis reviewed performance monitoring and Windows and SQL Event Logs and System Logs.
• Performed troubleshooting and maintained H/W and networking problems
• Tested Windows and SQL Server critical and security Patches on test LAB and installed in Production environment.
• Organized Exceptional operational management skills, Technical documentations, MS Office, Trainings, Project management, Visio, Presentations and Oral/Written Interpersonal Communication Skills.

Confidential, Stamford, CT

Database Administrator 

Responsibilities:

• Worked with Database Manager, databases technical analysis and requirement gathering, build detailed designs and documentations.
• 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. Data conversion, Oracle. AWR, Stats pack, ADDM, Oracle Universal Installer, Oracle Patch testing and applying in production databases.
• Worked on Data modeling and development. XML data processing as per business needs.
• 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.
• Migrated Microsoft SQL Server 2000 to Microsoft SQL Server 2005.
• 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.
• Organized Exceptional operational management skills, Technical documentations, MS Office, Trainings, Project management, Visio, Presentations and Oral/Written Interpersonal Communication Skills.

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

Confidential

Application Database Administrator Lead

Responsibilities:

• Installed, configured and administrated Oracle 9i on Windows environment, Performance monitoring and tuning. Performed Oracle user authentication, backup and recovery plan, Oracle maintenance tasks, Tuning Queries, Index reorganization/rebuild indexes, blocking and deadlocks issue and User access issues.
• PeopleSoft 8 administrations, maintenance and supporting users and developers. Worked with PeopleTools 8.43/8.44, Process scheduler, App Engine, PIA, PS Admin utility. Application designer, compare reports, data mover. Performance tuning and recommendations, resolving long running queries.
• PSBUILDS and data conversion, execution scripts and 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 Confidential Storage Area Network.
• SQL Performance tuning analysis and recommendations databases, application files, and access permissions. Providing user access according to the requirement, database maintenance plan, monitoring and troubleshooting.
• 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.
• Worked PeopleSoft and databases environment technical analysis and requirement gathering, build detailed designs and documentations, best practices and solutions.
• Organized Exceptional operational management skills, Technical documentations, MS Office, Trainings, Project management, Visio, Presentations and Oral/Written Interpersonal Communication Skills.

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.
• Technical documentations, MS Office, Trainings and Oral/Written Interpersonal Communication Skills.