OBJECTIVE:

Seeking an Oracle Fusion Middleware Engineer position in a challenging environment which will allow me to use my diverse knowledge and experience of the enterprise, distributed and wide range of relational database management systems to help meet organization's goals.

SUMMARY

Over 12 years of IT experience and 8 years' experience for Oracle Fusion Middleware products.

Extensive Oracle Apps DBA experience ranging from EBS versions 10.x thru R12 and databases ranging from version 7.x thru 11g.

• Experience in architecture, design, development, and production support for legacy applications leveraging the Oracle Fusion Middleware 11g technology stack.
• Possess a strong working knowledge of SOA and web services technologies and infrastructure engineering of Service Oriented Middleware deployments that support complex and essential web services across the enterprise, including shared and dedicated, production and non-production environments.
• Having hands-on design, build, deployment, and support for Oracle Fusion Middleware including SOA, OSB, BPM, ODI, ADF applications, including the WebLogic application server.
• Experience in installation, implementation, maintenance, and operations of middleware and related infrastructure components.

Experience in Administration of Oracle Databases 11g, 12c including maintenance, upgrades, patching, cloning, tuning, performance monitoring, installation, backup and restore

Experience in Best Practice Security Policies for Oracle Database and Ebusiness Applications

Developed and implemented policies, plans, procedures, and manuals

Experience in E-Business Suite Version 12.1.3 ,Patching , EBS Upgrades ,Rapid Cloning

Hands on experience of Ebusiness Applications on RAC

Managed VLDB global environments as large as 7TB

Lead DBA supporting implementations and upgrades of EBS 11i to R12 including platform migrations.

Extensive experience in Leading Oracle Apps DBA supporting Financials, HRMS, Supply Chain and Manufacturing.

Responsible Lead DBA for benchmark testing of global environment using Lode Runner tool.

Experience in Oracle Access Manager

Provided a health check of production EBS to address many instability and performance issues and documented findings and implement recommendations.

Versed all UNIX based platforms

Actively participate with project management team in strategic planning, goal setting and monitoring, providing status updates on a regular basis.

Aggressively ensures Service Level Agreements SLA goals are successfully met by DBA team

Proficient in multiple, large RDBMS Administration, Server Installation Performance Tuning, Security Management, Backup Recovery, Data/Code Migration Data Integration of Oracle11g,10g/9i/8i/8.x/7.x.

• Experience in designing , implementing, and supporting to meet customer's internal and external standards and service level requirements.
• Performing testing, tuning, and configuration of Middleware products including WebLogic, Oracle BPM, Oracle SOA Suite, and Oracle Identity Manager, Oracle Access Manager, OWSM, Oracle Portal, etc.
• Applying experience with monitoring tools and techniques for Fusion Middleware components including REST ful Management Services, SOA and OSB services.
• Supporting, troubleshoot, and resolve Middleware and related infrastructure issues.

Experience in performance tuning techniques, backup and recovery processes, database design and management, client interaction and support.

Strong troubleshooting problem analysis skills proven under high-pressure environments.

Setup and register databases with RMAN for daily full hot backups and frequent Archivelog backups using catalog.

Performing EXP and IMP and DataPump EXP/IMP of databases and schemas upon requests in hectic development environment.

Experience with Database Vault, Audit Vault, AES Security/Encryption

Experience with data replication by Oracle streams, GoldenGate and Shareplex.

Setup administration scripts to monitor the environment ranging from external component CRS, ASM, Filesystem, Network, DB Connectivity to internal DB components Session Info, SQL execution info, Memory usage, Tablespace storage .

Efficient in standardizing best database practices, processes and auditing databases for security. Expert in development of Unix Shell Scripts K, Bourne, C Shells for database operations.

• Perform installation of new Middleware software releases, system upgrades, and patches.
• Experience in setting up clustering highly available environments for Oracle Fusion Middleware stack.
• Experience in setting up security policies and SSO environment between external applications, Oracle Weblogic Server, OWSM and other technologies in Fusion middleware stack JVM and memory management, tuning, diagnostics and configuration

Excellent communication, project management and organization skills.

TECHNICAL PROFICIENCIES:-

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle Middleware Administrator/ Architect

• Extensive experience in mission-critical and 24/7 support of Oracle Fussion Middleware installing, performance and tuning, architecture and feature recommendations
• Provided architecture, design, development, and production support for legacy applications leveraging the Oracle Fusion Middleware 11g technology stack.
• Possessed a strong working knowledge of SOA and web services technologies and infrastructure engineering of Service Oriented Middleware deployments that support complex and essential web services across the enterprise, including shared and dedicated, production and non-production environments.

Experience in Administration of Oracle Databases 11g, 12c including maintenance, upgrades, patching, cloning, tuning, performance monitoring, installation, backup and restore

Extensive experience and expertise in deploying and supporting Oracle utilizing Linux and Solaris 9,10, 11 .Experience in installation , configuration and maintenance of RAC environment

Experience with managing, administering, designing, maintaining, supporting architecting infrastructure for Oracle Fusion Middleware products.

Provided architecture, design, development, and production support for legacy applications leveraging the Oracle Fusion Middleware 11g and 12c technology stack.

Responsible for working closely with cross-functional IT teams, business analysts, DBAs, and developers to ensure effective execution of Middleware services functionality including SOA, ADF, Queue JMS and data migration.

Possessed a strong working knowledge of SOA and web services technologies and infrastructure engineering of Service Oriented Middleware deployments that support complex and essential web services across the enterprise, including shared and dedicated, production

Experience, proficiency and hands-on design, build, deployment, and support for Oracle Fusion Middleware including SOA, OSB, OWSM, BPM, ADF applications, including the WebLogic application server.

• Provided hands-on design, build, deployment, and support for Oracle Fusion Middleware including SOA, OSB, BPM, ODI, ADF applications, including the WebLogic application server.
• Solved problems related to installation, implementation, maintenance, and operations of middleware and related infrastructure components.
• Experience implementing, monitoring and managing Dataguard and RMAN.
• Provided DBA's supporting in BI and Data Warehousing environment OBIEE,Microstrategy and Informatica
• Provided support on a wide range of database development functions in a RAC configuration, including running test queries, troubleshooting database problems, maintaining version control of database entities, advising customers on new database features, and leading studies to evaluate the effectiveness of current database methods and procedures, investigation of issues arising from data loss and corruption.
• Ensured that infrastructure systems are designed, implemented, and supported to meet customer's internal and external standards and service level requirements.
• Performed testing, tuning, and configuration of Middleware products including WebLogic, Oracle BPM, Oracle SOA Suite, and Oracle Identity Manager, Oracle Access Manager, OWSM, Oracle Portal, etc.
• Applied experience with monitoring tools and techniques for Fusion Middleware components including RESTful Management Services, SOA and OSB services.
• Provided Support, troubleshoot, and resolve Middleware and related infrastructure issues.
• Performed installation of new Middleware software releases, system upgrades, and patches.
• Experienced in setting up clustering highly available environments for Oracle Fusion Middleware stack.

Environment: Oracle 11g, 10g and 9i , SQL, PL/SQL, 11i/R12 EBusiness Applications, Database, Data Warehouse,Business Intelligence, OLAP, Portal, SOA/Fusion Middleware, Oracle Fusion Middleware including SOA, OSB, BPM, ODI, ADF applications, including the WebLogic application server

Retek, Aqualogic, Peoplesoft, JDE, Siebel/OBIEE and Hyperion Business Objects,MS SQL Server ,Oracle Designer, Sql Loader , TOAD, ERWIN 7.1/4.1/3.5.2/3.0, PeopleSoft ,ANT, Rational Rose, DAC/Informatica , J2EE, Panorama , ColdFusion,Weblogic,Sun Solaris , Unix ,SOA ,Linux, AIX and Windows , Terminal Services, Putty, Clear Case, Clear Quest etc

Confidential

Sr. Oracle Fussion Middleware Engineer

• Managed 17 Production and Non-Production ERP environments ranging from PeopleSoft, Oracle 11i to
• R12 instances. These environments are all Oracle Solaris 10 based utilizing zone partitioningtechnologies.

• Provided hands-on design, build, deployment, and support for Oracle Fusion Middleware including SOA, OSB, BPM, ODI, ADF applications, including the WebLogic application server.

Experience in Administration of Oracle Databases 11g, 12c including maintenance, upgrades, patching, cloning, tuning, performance monitoring, installation, backup and restore

Solved problems related to installation, implementation, maintenance, and operations of middleware and related infrastructure components.

Able to design and engineer infrastructure to delivery highly available applications.

Solved problems related to installation, implementation, maintenance, and operations of middleware and related infrastructure components.

Ensureed that infrastructure systems are designed, implemented, and supported to meet customer's internal and external standards and service level requirements.

Performed testing, tuning, and configuration of Middleware products including WebLogic, Oracle BPM, Oracle SOA Suite, Oracle Identity Manager, Oracle Access Manager, OWSM, Oracle Portal etc

• Ensured that infrastructure systems are designed, implemented, and supported to meet customer's internal and external standards and service level requirements.
• Performed testing, tuning, and configuration of Middleware products including WebLogic, Oracle BPM, Oracle SOA Suite, and Oracle Identity Manager, Oracle Access Manager, OWSM, Oracle Portal, etc.
• Applied experience with monitoring tools and techniques for Fusion Middleware components including RESTful Management Services, SOA and OSB services.
• Provided Support, troubleshoot, and resolve Middleware and related infrastructure issues.
• Performed installation of new Middleware software releases, system upgrades, and patches.
• Experienced in setting up clustering highly available environments for Oracle Fusion Middleware stack.
• Experienced in setting up security policies and SSO environment between external applications, Oracle Weblogic Server, OWSM and other technologies in Fusion middleware stack JVM and memory management, tuning, diagnostics and configuration

• Identified and resolved critical application issues including those relating to performance, Work Flow,
• forms, reports and concurrent processes.
• Experience with installation, upgrade, configuration, and administration of Oracle databases in both Linux and Windows environment.
• Assisted developers and/or users with identifying performance issues and tuning queries and scripts
• Experience in configuring, installing and maintain RAC implementations
• Expertise with RAC, ASM, Flashbakc, DataGuard, Grid Control / OEM, Streams / Golden Gate /CDC
• Experience in Oracle application server infrastructure suite of products bundled with 10gAS
• Experience in updating application server configurations, exporting instance configurations, creating clusters, importing saved configurations, creating OC4J containers and application contexts, and loading balance OC4J containers using islands across instances
• Experience in XML parsers, DTD specifications, SML based PDF generation, SSH specifications, and Public Key Encryption/Cryptography
• Did the ETL development by using Oracle ODI.
• Analyzed and resolved complex technical problems regarding the integration of object-oriented applications and infrastructure with relational database technology.
• Monitored databases and performs tuning enhancements to optimize their performance.
• Maintain Oracle Grid Control monitoring console to ensure all production systems are fully monitored and alerts/messages are configured appropriately and resolved.
• Monitored trouble ticketing system to ensure reported issues are resolved in a timely manner.
• Performed routine and advanced Oracle database development, planning, and coordinating, including base definition, structures, documentation, upgrades, long-range requirements, operational guidelines and protection RAC implementation and support.
• Performed database related activities: troubleshooting, recovery, tuning of the database, user security, RDBMS software installation and upgrades, resolving Oracle errors and failures, auditing activities, and resource utilization.
• Participated in semi-annual disaster recovery tests and make recommendations for improving secondary site activation procedures.
• Provided technical input to software developers and end users in the areas of hardware and database capabilities.
• Monitor all database activity for operational improvements to include, but not limited to CPU, Disk and Memory utilization, replication and consistency of all parameters across multiple sites.
• Managed access to databases to ensure corporate security practices are followed.
• Ensured all databases are backed up per Ops Tech specifications.
• Implemented changes into production environment per the change control board process.
• Responsible for release management that would ensure complete release success by Extensive interaction with development and co-ordination with various other teams.

Environment: Oracle 11g, 10g and 9i , 11i/R12 EBusiness Applications, Database, Data Warehouse,Business Intelligence, OLAP, Portal, SOA/Fusion Middleware,

Retek, Aqualogic, Peoplesoft, JDE, Siebel/OBIEE and Hyperion,

SQL, PL/SQL, OBIEE,Microstrategy,Informatica , MS SQL Server ,Oracle Designer, Sql Loader , TOAD, ERWIN 7.1/4.1/3.5.2/3.0, SOA ,PeopleSoft Business Objects, ,ANT, Rational Rose, DAC/Informatica , J2EE, Panorama , Weblogic,Sun Solaris , ColdFusion, Unix ,Linux, AIX and Windows , Terminal Services, Putty, Clear Case, Clear Quest etc

Confidential

Sr. Oracle Applications DBA/Architect

• Managed 17 Production and Non-Production ERP environments ranging from PeopleSoft, Oracle 11i to
• R12 instances. These environments are all Oracle Solaris 10 based utilizing zone partitioning
• Provided architecture, design, development, and production support for legacy applications leveraging the Oracle Fusion Middleware 11g technology stack.
• Possessed a strong working knowledge of SOA and web services technologies and infrastructure engineering of Service Oriented Middleware deployments that support complex and essential web services across the enterprise, including shared and dedicated, production and non-production environments.
• Provided hands-on design, build, deployment, and support for Oracle Fusion Middleware including SOA, OSB, BPM, ODI, ADF applications, including the WebLogic application server.
• Applied experience with monitoring tools and techniques for Fusion Middleware components including RESTful Management Services, SOA and OSB services. Support, troubleshoot, and resolve Middleware and related infrastructure issues.
• Performed installation of new Middleware software releases, system upgrades, and patches.
• Provided 24/7 support via cell phone for severity 1 incidents.
• Experience in setting up clustering highly available environments for Oracle Fusion Middleware stack.
• Solved problems related to installation, implementation, maintenance, and operations of middleware and related infrastructure components.
• Ensured that infrastructure systems are designed, implemented, and supported to meet customer's internal and external standards and service level requirements.
• Performed testing, tuning, and configuration of Middleware products including WebLogic, Oracle BPM, Oracle SOA Suite, and Oracle Identity Manager, Oracle Access Manager, OWSM, Oracle Portal, etc.
• Experience in Administration of Oracle Databases 11g, 12c including maintenance, upgrades, patching, cloning, tuning, performance monitoring, installation, backup and restore
• technologies. Implemented 2 non-production environments using ASM RAC 11g
• Created and defined non-global zone partitioning for upgrade projects.
• SA responsible for creating user accounts, patching and mount points in non-global zones
• Creating, upgrading and administering databases in multiple 2/4-node RAC environments Development, Testing, QA and Production .
• Creating and administering Physical Standby production databases for multiple applications using DataGuard in RAC environment up to 4-node.
• Extensive Experience in setting up the Data Guard
• Upgrading 10g databases into 11gR2 databases by using DBUA,manual and silent mode
• Did the ETL development by using Oracle ODI.
• Installed and configured OEM 11g in Solaris 10.
• Experience in Oracle streams and Golden Gate 10g/11g design, installation, configuration , unit test , deployment and maintenance
• Expertise with setting up, Performance tuning and administration of Golden Gate.
• Golden Gate design documents as well as subsequent implementation of the designs.
• Experience in updating application server configurations, exporting instance configurations, creating clusters, importing saved configurations, creating OC4J containers and application contexts, and loading balance OC4J containers using islands across instances
• Experience in XML parsers, DTD specifications, SML based PDF generation, SSH specifications, and Public Key Encryption/Cryptography
• Experience in UNIX-based skills including RC4, Certification Authorities, SSL and Single Sign On, Korn Shell scripting, Perl and Java
• Setting up Standby DBs in OPEN mode with Flashback ON for testing purposes and restoring them back to read-only, and then synchronizing with primary DB back again.
• Resolving Log Gaps whenever occurred in Production Standby DataGuard environments. Also during major releases disabling the DataGuard broker configuration and enabling it back after the successful deployment and synchronize both Primary and Standby DBs.
• Setup replication between PROD and Datawarehouse DBs via Materialized Views.
• Setup and register databases with RMAN for daily full hot backups and frequent Archivelog backups using catalog.
• Experience in advanced SQL , PL/SQL, Application development, Data Modeling/Relational and Database Design.
• Performing EXP and IMP and DataPump EXP/IMP of databases and schemas upon requests in hectic development environment.

Environment: Oracle 11g, 10g and 9i , 11i/R12 EBusiness Applications, Database, Data Warehouse,Business Intelligence, OLAP, Portal, SOA/Fusion Middleware,

Retek, Aqualogic, Peoplesoft, JDE, Siebel/OBIEE and Hyperion,

SQL, PL/SQL, MS SQL Server ,Oracle Designer, Sql Loader , PeopleSoft , TOAD, ERWIN 7.1/4.1/3.5.2/3.0, Business Objects, ANT, SOA , DAC/Informatica , Rational Rose, J2EE, Panorama , ColdFusion,Weblogic,Sun Solaris , Unix ,Linux, AIX and Windows , Terminal Services, Putty, Clear Case, Clear Quest etc

Confidential

Sr. Oracle Applications DBA

• Experience with the Oracle/PeopleSoft HCM applications such as HRMS, eRecruit, and ELM.
• Experience with PeopleSoft development tools such as Application Designer, PeopleCode, and Application Engine.
• Experience with technical online development of PeopleSoft 8/9.x applications.
• Experienced in setting up security policies and SSO environment between external applications, Oracle Weblogic Server, OWSM and other technologies in Fusion middleware stack JVM and memory management, tuning, diagnostics and configuration
• Experienced in setting up clustering highly available environments for Oracle Fusion Middleware stack.
• Performed installation of new Middleware software releases, system upgrades, and patches.
• Provided Support, troubleshoot, and resolve Middleware and related infrastructure issues.
• Applied experience with monitoring tools and techniques for Fusion Middleware components including RESTful Management Services, SOA and OSB services.
• Managed upgrade project from 11i/10g to R12/11g HA multi-country/multi-language implementation on AIX in an 11g RAC environment.
• Architected and implemented 11g RAC in all non-production environments.
• Re-engineered change management process for client. Created change management standards documentation.
• Experience in Administration of Oracle Databases 11g, 12c including maintenance, upgrades, patching, cloning, tuning, performance monitoring, installation, backup and restore
• Defined and implemented standards for instance strategy. Trained development teams on deployment strategy.
• Identified and resolved critical application issues including those relating to performance, Work Flow, forms, reports and concurrent processes.
• Instituted proactive performance monitoring measures using ADDM, AWR to ensure SLA performance goals.
• Installation and configuration of Oracle Access Manager for Single-Signon integration with OID 11g and Active Directory
• Experienced in setting up security policies and SSO environment between external applications, Oracle WebLogic Server, OWSM and other technologies in Fusion middleware stack.
• Experience in JVM and memory management, tuning, diagnostics and configuration
• Experience with managing, administering, designing, maintaining, supporting architecting infrastructure for Oracle Fusion Middleware products.
• Provided architecture, design, development, and production support for legacy applications leveraging the Oracle Fusion Middleware 11g and 12c technology stack.
• Responsible for working closely with cross-functional IT teams, business analysts, DBAs, and developers to ensure effective execution of Middleware services functionality including SOA, ADF, Queue JMS and data migration.
• Conducted benchmark testing to stress published performance measures.
• Performed cloning activities to build development and test environments
• Architected and implemented Disaster Recovery procedures in compliance with SLA availability clauses which included RMAN setup and configuration and DataGuard installation.
• Implemented EBS security that leverages technical options with customers' demands
• Performed installation and configuration of the GRC Software
• Completed impact analysis of apps and database upgrade
• Installation, monitoring, maintaining, and configuring 11g databases on Sun Solaris in classified environment.
• Upgrading 10g databases into 11gR2 by using both silent mode and DBUA utility
• Installation and configuring the Weblogic for Oracle Enterprise manager installation
• Installing and configuring oracle Oracle Enterprise Manger
• Refreshing and restoring both testing and development environments
• Performance tuning and testing through Oracle Enterprise Manger
• Generating both AWR and ADDM reports
• Configuring Oracle 11g database development environment for development activities
• Installing and configuring the Oracle Wallet.
• Experience in Oracle DML, DCL , DDL scripting and in Oracle Data Integrator ODI development.
• Experience in DAC/Informatica Administration
• Planed, designed, developed, and maintained Oracle database schemas for development, testing, and production environments.
• Shared responsibility for data integrity with the applications development staff.
• Day-to-day user requests and troubleshooting the database related problems and requests
• Experience in advanced SQL , PL/SQL, Application development, Data Modeling/Relational and Database Design.
• Installation, configuration, data migrations, performance tuning, backup/recoveries for SQL Server Databases.
• Responsible for interfacing, communicating and collaborating with client stakeholders, system architects, system engineers and software engineers to establish a clearly defined and comprehensive view of all data and relationships necessary to support the system.
• Working with management on database Sizing and Infrastructure requirements
• Performed database tuning, performance monitoring, and capacity planning
• Performed database migrations to newer versions of the software as well as migrations from different platforms to Oracle.
• Analyzed the database objects using OEM and assigning and altering the profiles of the Database schemas for security purpose.

Environment: Oracle 11g , 10g, 11i/R12 EBusiness Applications, Database, Data Warehouse,Business Intelligence, OLAP, Portal, SOA/Fusion Middleware,

Retek, Aqualogic, Peoplesoft, JDE, Siebel/OBIEE and Hyperion,

SQL, PL/SQL,SQL Server , PeopleSoft , Data Pump, Sql Loader , TOAD, , J2EE, , Sun Solaris , Windows , ColdFusion, Business Objects,DAC/Informatica , CVS , OEM , Putty, SOA , Clear Case, Clear Quest , Humminbird etc

Confidential

Oracle Fusion Middleware Administrator/Architect

Responsibilities:

• Maintain Oracle Grid Control monitoring console to ensure all production systems are fully monitored and alerts/messages are configured appropriately and resolved.
• Performed testing, tuning, and configuration of Middleware products including WebLogic, Oracle BPM, Oracle SOA Suite, and Oracle Identity Manager, Oracle Access Manager, OWSM, Oracle Portal, etc.
• Ensured that infrastructure systems are designed, implemented, and supported to meet customer's internal and external standards and service level requirements.
• Solved problems related to installation, implementation, maintenance, and operations of middleware and related infrastructure components.
• Provided a health check of production EBS to address many instability and performance issues and
• Created post clone procedures that include modifying sensitive production data.
• Provide weekly clones of production for development and test instances.
• Patch analysis, planning and application to all environments per client request.
• Implemented RAC for test environment.
• Provide production support for Phase I, which included the Financials Suite on HP UX 11i using 11.5.10.2 CU2 on 10gR2.
• Lead Oracle Apps DBA supporting Phase II implementation of HRMS suite, which included Payroll and Advanced Benefits.
• Provided hands-on design, build, deployment, and support for Oracle Fusion Middleware including SOA, OSB, BPM, ODI, ADF applications, including the WebLogic application server.
• documented findings and implement recommendations.
• Provided strategic direction for instance creations and recommendations for data center disaster recovery.
• This included strategic plans for system growth and future capacity requirements
• Configured and implemented OEM to manage all instances.
• Implemented RMAN for production and test environments
• Created and implemented change management procedures for all environments.
• Worked in conjunction with Developers to resolve performance issues with custom code reports, forms, workflow, concurrent reports, mviews etc
• Wrote shell scripts to email and alert Production DBA team of server status
• Installation and maintaining Oracle Real Application Cluster with ASM for Oracle 10g.
• Provided 24X7 support and maintenance for several ORACLE 11 and10g databases running on a number of instances.
• Patching CRS and RAC databases using all-node and rolling patching methods
• Developed and executed plan to apply Oracle upgrades, maintenance, and security patches
• Developed, implemented and maintained database archival, backup and disaster recovery policies and procedures.
• Setup and Managed Standby databases for both Physical and Logical using Data Guard Created Entity-Relationship diagrams, data models and other database related information by reverse engineering, defined data dictionary, database entities, parent child relationship keys, identifying primary and referential integrity constraints, sequences, stored procedures.
• Installed, configured and maintained XA DataSource with Oracle 10g.
• Created physical and logical data models by using Erwin
• Experience in advanced SQL , PL/SQL, Application development, Data Modeling/Relational and Database Design.
• Responsible for planning, designing, documenting and maintaining the data architecture
• Data architecture includes requirement gathering, designing entities, attributes and relationships drawn from system, functional and legacy requirements to support the implementation of OLTP and OLAP solutions.
• Responsible for interfacing, communicating and collaborating with client stakeholders, system architects, system engineers and software engineers to establish a clearly defined and comprehensive view of all data and relationships necessary to support the system.
• Working with management on database Sizing and Infrastructure requirementsPerformed database tuning, performance monitoring, and capacity planning
• Performed database migrations to newer versions of the software as well as migrations from different platforms to Oracle.
• Installation, configuration, data migrations, performance tuning, backup/recoveries for SQL Server Databases.

Environment: , 11i/R12 EBusiness Applications, Database, Data Warehouse,Business Intelligence, OLAP, Portal, SOA/Fusion Middleware,

Retek, Aqualogic, Peoplesoft, JDE, Siebel/OBIEE and Hyperion,

Oracle 11g, 10g and 9i , SQL, PL/SQL, Oracle Designer, Sql Loader , TOAD, ERWIN 7.1/4.1/3.5.2/3.0, DAC/Informatica , ColdFusion, Business Objects, PeopleSoft ,ANT, Rational Rose, J2EE, Panorama , Sun Solaris , Unix ,Linux, AIX and Windows , SQL Server ,Terminal Services, SOA ,Putty, Clear Case, Clear Quest etc

Confidential

Oracle Fussion Middleware Administrator/Architect

Responsibilities:

• Maintain Oracle Grid Control monitoring console to ensure all production systems are fully monitored and alerts/messages are configured appropriately and resolved.
• Experienced in setting up clustering highly available environments for Oracle Fusion Middleware stack.
• Performed installation of new Middleware software releases, system upgrades, and patches.
• Provided Support, troubleshoot, and resolve Middleware and related infrastructure issues.
• Applied experience with monitoring tools and techniques for Fusion Middleware components including RESTful Management Services, SOA and OSB services.
• Performed testing, tuning, and configuration of Middleware products including WebLogic, Oracle BPM, Oracle SOA Suite, and Oracle Identity Manager, Oracle Access Manager, OWSM, Oracle Portal, etc.
• Installing and configuring Oracle 10g EM Grid Control in different environment
• Database administration support to the development team and Supported database synchronization
• Experience in Administration of Oracle Databases 10g, 1 1g including maintenance, upgrades, patching, cloning, tuning, performance monitoring, installation, backup and restore
• Ensured that infrastructure systems are designed, implemented, and supported to meet customer's internal and external standards and service level requirements.
• Performed complex database administration assignments essential to the production and development of database management systems DBMS applications. Assignments, which are in direct support of software development and maintenance teams, include database analysis, security support, design, software use, and performance monitoring and tuning.
• Provide technical analysis and implementation support for system and functionality upgrades.
• Strong knowledge and practical experience with Oracle Core technologies-RAC, GRID, ASM, RMAN, EM Grid Control, Data Guard, and Active/Passive Cluster Oracle technologies.Knowledge and experience with RAC-installation and setup, RAC characteristics and RAC maintenance.
• Installation, configuration, data migrations, performance tuning, backup/recoveries for SQL Server Databases.
• Did the ETL development by using Oracle ODI.
• Experience in DAC/Informatica Administration
• Regularly interacted with senior or executive management on matters concerning several functional areas, divisions, and/or customers.
• Extensive Experience with data replication by using Oracle Streams and Shareplex
• icating data, standby databases using SharePlex for Oracle.
• Involved in managing standby databases using Oracle Standby and SharePlex replication.
• Involved in optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized views, AWR,ADDM,Explain plan etc.
• Involved in installing, configuring, managing and patching Oracle 9i/10g and SQL Server 2000 on Sun Solaris, Linux and Windows.
• Metadata Integration Strategy for the Enterprise Data Standards Initiative
• Created physical models of all databases and logical models of strategic customer and product databases.
• Designed a Corporate Conceptual Model as an architecture migration target and developed procedures to map this model to the database models to facilitate information location.
• Provided an evaluation and Proof of Concept built a Star Schema using Oracle Warehouse Builder 10G R1 for the Oracle Business Intelligence products.
• Compared and contrasted Oracle BI solutions with other leading vendors and recommended a complete BI solution.
• Trained new data-modeler to work with DBA's to assure correct implementation of physical data model.

Environment: , 11i/R12 EBusiness Applications, Database, Data Warehouse,Business Intelligence, OLAP, Portal, SOA/Fusion Middleware,

Retek, Aqualogic, Peoplesoft, JDE, Siebel/OBIEE and Hyperion,

Oracle 10g / 9i / 8i, Shareplex, SQL, PeopleSoft ,PL/SQL,ERWIN,Oracle Desinger,ETL TOOLS Shell Script, Exceed, Unix , SOA ,Linux, AIX , DAC/Informatica,Sun Solaris 8, Windows 2000, TOAD, SQL Server ,Terminal Services, Putty etc

Confidential

Oracle Middleware Architect/Engineer

Responsibilities:

• Maintain OEM monitoring console to ensure all production systems are fully monitored and alerts/messages are configured appropriately and resolved.
• Performed testing, tuning, and configuration of Middleware products including WebLogic, Oracle BPM, Oracle SOA Suite, and Oracle Identity Manager, Oracle Access Manager, OWSM, Oracle Portal, etc.
• Ensured that infrastructure systems are designed, implemented, and supported to meet customer's internal and external standards and service level requirements.
• Solved problems related to installation, implementation, maintenance, and operations of middleware and related infrastructure components.
• Created and executed data manipulation commands for special data correction situations.
• Performed general database related troubleshooting for development teams.
• Performed database upgrades as needed.
• Responsible for overall administration, performance tuning, backup/recovery.
• Assured High Availability for all systems with production data no single point of failure Responsibility for ensuring that daily and nightly jobs run accurately and to completion.
• Experience in Administration of Oracle Databases 10g,11g including maintenance, upgrades, patching, cloning, tuning, performance monitoring, installation, backup and restore
• Supporting test and development environments to ensure smooth transition of applications into production.
• Installation of Oracle 10g,9i, 8i, and 8.x databases on Windows,SUN, HP and Linux
• Provided hands-on design, build, deployment, and support for Oracle Fusion Middleware including SOA, OSB, BPM, ODI, ADF applications, including the WebLogic application server.
• Utilize data modeling knowledge to provide designs that will meet performance and scalability requirements.
• Provided short and long-term vision for the overall data model and physical design.
• Evaluated and define how the data model interacts with external data sources such as the data warehouse, feeds, and third-party packaged solutions.
• Data Warehouse systems development, quality assurance, and implementation support,providing for support data management strategies, including data integration, partitioning, archiving and replication.
• Suggested and led the definition and implementation of process improvements within the organization related to efficient data warehousing.
• Mentor other members of the team on data warehouse design skills.
• Shared responsibility for data integrity with the applications development staff. Strong Oracle performance tuning and trouble-shooting skills with large database. Has experience with Oracle 10g and 9i RAC .
• Providing 24x7 production support for client server systems. Providing Oracle Database Administration support to numerous systems on Linux and Windows platforms.
• Participating in production support and implementation of databases, designing and tuning critical high volume OLTP databases, and contributing to database infrastructure enhancements.
• Perforating tuning backup and recovery processes, database design and management, client interaction and support.
• Hands-on experience in Oracle Standby databases.
• Providing DB admin support to number of databases for different departments
• Designing, developing and supporting ETL activities by using Abnitio.Managed and used case tools to create and maintain ERD and Data Diagrams and Data definitions.
• Installation, configuration, data migrations, performance tuning, backup/recoveries for SQL Server Databases.
• Managed Data modeling project from Logical design and implementation of Physical Database.
• Facilitated and leaded data modeling sessions.
• Direct interaction with Business Analysts and project team to assist in the designing of business entities and rules.
• Created physical and logical data models by using Erwin

Environment: , 11i/R12 EBusiness Applications, Database, Data Warehouse,Business Intelligence, OLAP, Portal, SOA/Fusion Middleware,

Retek, Aqualogic, Peoplesoft, JDE, Siebel/OBIEE and Hyperion,

Oracle 10g / 9i / 8i, Shareplex, SQL, PL/SQL,ERWIN,Oracle Desinger, Oracle Developer ,SQL Server, Shell Script, Exceed, PeopleSoft ,SOA , Unix ,Linux, AIX, Sun Solaris 8, Windows 2000, TOAD, Terminal Services, Putty etc

Confidential

Oracle DBA/Data Architect

Responsibilities:

• Maintain OEM monitoring console to ensure all production systems are fully monitored and alerts/messages are configured appropriately and resolved.
• Experienced with setting up synchronous/asynchronous messaging via the PeopleSoft Integration Broker
• Working Knowledge of PeopleSoft HCM 9.x to include Application Engine, PeopleCode, Query Designer, Workflow, JavaScript, PeopleSoft Security, and Process Scheduler
• Experience with PeopleSoft CRM Enterprise HelpDesk 9.1 to include the full system lifecycle Design, Development, System Test, QA, Implementation, and Maintenance
• Provide 24 X 7 on call production database support
• Cloning production database for testing, development, QA environment using export/import, cold backup, hot backup and RMAN.
• Involved in managing distributed database environment, replicating data, standby databases using SharePlex for Oracle.
• Involved in managing standby databases using Oracle Standby and SharePlex replication.
• Provide technical leadership for production database DBA team of 8
• Create/manage Database Standards, guidelines for DBA team
• Created physical and logical data models by using Erwin
• Updated job knowledge by tracking research regarding web design and usability participating in educational opportunities reading professional publications maintaining personal networks participating in professional organizations.
• Enhances organization reputation by accepting ownership for accomplishing new and different requests exploring opportunities to add value to job accomplishments.
• Validated information delivery by developing and completing usability test plans evaluating traffic patterns studying user feedback coordinating with Usability Specialists.
• Evaluate and execute backup and recovery policies, configured RMAN-VERITAS backup
• Educate RMAN backup/recovery procedure to the DBA team
• Assistance to application tuning and identifying inefficient SQL statements.
• Analyzed/resolved complex problems, performed maintenance and tuning of
• Oracle Database that increased performance by more than 50
• Performed Oracle database creation, upgrade, patches in Dev, Test Production
• Identify Oracle security alerts and co-ordinate to roll out to all the databases
• Research and identify required high availability method and implemented them
• Standby server, SRDF and Data guard
• Involved in Disaster recovery activities and created procedures.
• Involved in Unix migration HP-UX 9.04 to HP-UX 10.01 HP-UX 10.01 to HP-UX 11.11
• Oracle Financial database cloning for development and test databases.
• Creation and Maintenance of 'Startup and Shutdown' unix scripts for Oracle Financial and other databases.
• Identifying any security alerts and applying required patches.
• Capacity planning for production database growth before hand and make sure required disk space is available
• Approve the production database implementation tasks, Production install reviews
• Identify and create Production database health check alerts using 'Patrol' also by shell scripts
• Development/Test databases were refreshed with Production database using RMAN backup

Environment: Oracle 9i / 8i, Shareplex, SQL, PL/SQL, Shell Script, PeopleSoft ,Exceed, Sun Solaris 8, Windows 2000, Unix ,Linux, AIX ,TOAD, SOA , Terminal Services, Putty,ERWIN etc

Confidential

Oracle Fusion Middleware Architect

Responsibilities:

• Provided architecture, design, development, and production support for legacy applications leveraging the Oracle Fusion Middleware 11g technology stack.
• Possessed a strong working knowledge of SOA and web services technologies and infrastructure engineering of Service Oriented Middleware deployments that support complex and essential web services across the enterprise, including shared and dedicated, production and non-production environments.
• Provided hands-on design, build, deployment, and support for Oracle Fusion Middleware including SOA, OSB, BPM, ODI, ADF applications, including the WebLogic application server.
• Also scheduled jobs using the cron like taking full database backup, password aging check.
• Reorganization of database using export/import used this feature in OEM and as well Shell scripts.
• Expert in writing packages containing procedures and function using with DBArtisan and TOAD 8.5 for OLAP and OLTP systems.
• Providing Technical architecture and database engineering support to move databases from development to test and production for multiple applications.
• Plan and develop efficient databases designs based on analysis of user requirements.
• Developed procedure, functions and database triggers with advanced features like varrays, nested tables, locally managed tables using with PL/SQL.
• Created Physical Logical Data model Diagrams, Entity relationships, constraints using Erwin.
• Employed EXPLAIN PLAN and TKPROF utilities
• Efficiently managed over 35 concurrent databases in 24x7, VLDB, distributed database, globally accessed environments.
• Involved in Data migration from Ingress database to Oracle database using shell and automated procedures at development level and handling table spaces, Indexes, constraints, SQL loader and space issues.
• Analyzed the database objects using OEM and assigning and altering the profiles of the Database schemas for security purpose.
• Implementing databases according to production standards mostly in high availability environments. Providing support to solve production database problems and engineer production database changes.
• Providing on-call support to resolve production database problems and issues.
• Maintain OEM monitoring console to ensure all production systems are fully monitored and alerts/messages are configured appropriately and resolved.
• Identifying and fixing performance issues related to client applications and following up with respective vendors to provide patches for identified problems.
• Coordinated with developers in reviewing code for optimizing database performance during development and before going into production.
• Developed complex PL/SQL database procedures, packages and triggers to handle complicated business logic for Warehouse Product Database Informatica

Environment: Sun-OS 9, Win-NT 4.0 server, Oracle 9i, PL/SQL, Java, Xing client, Exp/Imp, RMAN, Server Manager, Unix ,Linux, AIX, Cold fusion, DB Artisan 8.0, OLAP, Informatica, OEM10g/9i, TKPROF, Erwin 4.5.