Summary:

• Oracle Certified DBA with 10 years of professional experience in Design, Build and Support Oracle Databases from 8i 11g versions on all UNIX and Windows Platforms.
• Supported 24 X 7 mission critical large databases up to 90TB and more.
• Installed, configured and supported RAC and Data Guard for Oracle 10g and 11g on Solaris and Linux. Experience in configuring Automatic Storage Management ASM to administer the oracle related files.
• Worked on data warehouse tools. Involved in defining staging area Metadata, Data Mart , defining populating the Enterprise Model warehouse , Incremental Data loading
• Extensive experience in installing, upgrading and applying patches to various versions of oracle 11g/10g/9i/8i . Duties included raising Oracle SR support to deal with bugs and issues associated.
• Expertise in Upgrade and Migration of oracle database to higher version and other platforms using Oracle Data Migration Assistant.
• Automated operational DBA activities like refreshes, backups, space management, patching etc.
• Sized DBA efforts for new projects.
• Installed and configured Oracle 10g 10.2.0.2 Database on HP-UX and Linux advance Server on Development, Test and Production boxes.
• Used PL/SQL Stored procedures, triggers, packages , SQL PLUS, SQL LOADER and SQL tuning of Oracle database.
• Experience in Performance Tuning I/O, Memory SQL/PLSQL Tuning using EXPLAIN PLAN, TKPROF, and STATSPACK.
• Over 2 years of experience working with Oracle Golden gate for performing database upgrades, Cross platform migrations and Replications.
• Experience as Oracle DBA 11g/10g/9i/8i on different HP-UX, Sun Solaris, Linux, AIX, and Windows 2000/NT environment.
• Experience in full life cycle of database administration. Worked both as a development and a 24x7 Production Support DBA.
• Installed, configured and supported DB replication with Golden Gate.
• Strong knowledge on performance tuning, AWR analysis, SQL Tuning, TKPROF, Stats Pack, stored procs and shell scripting for DB and maintenance jobs.
• Proficient with Oracle Internals, Oracle Clusterware, RAC, ASM, Dataguard, RMAN, Oracle Tuning.
• 10 year's experience in Application Design and Development using Oracle including Data-modeling, Advanced PL/SQL, Performance Tuning, Partition Management, Index Strategies, Data pump, Shell Scripting, 24x7 Application Production Support and Release Management
• Built efficient queries by running explain plan and troubleshooting poorly performing queries.
• Extensive knowledge on oracle backups using RMAN and other third party tools.
• Experience in DB support for OLTP, OLAP and DSS systems in the capacity of production support and application support for various applications.
• Worked in Data warehouse environment to support ETL and Reporting tools like Informatica, BO etc.
• Strong experience Supporting Exadata, Oracle RAC and Golden Gate.
• Capacity planning, DB Design and build along with OS admin.
• Possess good working knowledge on configuring and support for Shareplex.
• Possess OS administration skills for UNIX and windows platform.
• Strong analytical and problem solving skills coupled with excellent written, verbal and inter-personnel communication skills. Good Team Player.
• OCA Oracle Certified Associate DBA

Technical Skills:

• Front End Tools: Power Builder 8, Visual Basic 6, Business Objects, Developer 2000, Oracle Discoverer, Oracle Reports 6i
• Internet : Cold Fusion MX, IIS, CF Script, ASP, WebSphere Application Server,
• IBM WebSphere MQ, Oracle Application Server 10g and 9i
• Back End Tools : Oracle 11g, 10g, 9i, 8i, SQL Server 2000, Sybase, Sybase SQL Anywhere
• Languages : SQL, PL/SQL, CFML, JavaScript, HTML, VBA, VBScript
• Utilities : SQL Plus, SQL Loader, SQL Net, Toad, ER-Win, ISQL, PVCS,
• Visual Safe Source, Subversion, PL/SQL Developer
• Database: ORACLE 11g/10g/9i, Real Application Clusters RAC , Data guard, RMAN, Grid control, ASM, ORACLE Utilities SQL Loader, Import/Export , SQL Net, MS SQL server 2000/2003, Oracle7.x/8.x/9i/10gR2/11gR2, SQL Server v7.x/2005/2000, Microsoft Access, OEM Grid Control, Data Guard, RMAN, Oracle 10g App Server
• Backup Utilities: RMAN, HP Omni Data Protector, SQL Backtrack, , VERITAS Net backup, Export/Import
• Oracle Monitoring Systems: OEM 9i/10g, Oracle 12c Cloud Control, Oracle Golden Gate Director
• Scripting: PL/SQL, Shell programming, C , Transact SQL, ABAP/4, COBOL
• ETL tools: Oracle Data Integrator ODI , Informatica Powercenter 7.1.1, 8.1.1, Erwin 4.1, ERStudio 5.5
• Software Applications/ Reporting: Business Objects XiR2, Erwin, Informatica, Oracle Warehouse builder, Cognos, Crystal Reports v9.x, Pro C, SQL Forms v3.x/4.x , Microsoft Office, Microsoft Visio, Microsoft Project, Remedy, Clarity
• Operating Systems: IBM AIX v5.3L, IBM MVS, HP Unix 11i 64bit Itanium, Sun Solaris 9,Enterprise Linux, Microsoft Windows XP/2000/NT/98/95, SOLARIS, LINUX, AIX
• DBA Tools : Oracle Enterprise Manager, RMAN, SQL Loader, Import/ Export, TOAD, TKPROF, StatsPack
• Methodology: QMO, CMM level 5
• Replication: Golden Gate, IXION, Oracle Multi-master Replication, Dataguard, VERITAS File System, Shareplex, Peoplesoft Oracle Fusion Middleware: WebLogic, Oracle SOA Suite, Oracle Service Bus, Oracle Transaction Manager BTM

Responsibilities:

Confidential

Sr ORACLE DBA

• Maintaining critical and production databases.
• Resolving Service Request tickets related to DB issues.
• Performed DB change requests and Code deployment / Code migration from Dev to QA to Prod Environments.
• Support as the core DBA the databases
• Provided support for replication using Shareplex and Golden Gate.
• Performed DB migration from Oracle 9.2.0.8 to Oracle 11.2.0.3 on Exadata.
• Upgraded several Oracle DBs from 10.2.0.4 RAC/Standalone to 11.2.0.3 RAC/Standalone on both Linux and Solaris platforms.
• Database performance tuning, and Troubleshooting.
• Production support and troubleshoot experience on Informatica ETL Jobs.
• Production Support experience on Real Application Cluster, Data Guard, Golden gate, shareplex and Peoplesoft.
• Script and automate DBA activities including Goldengate monitoring at process and checkpoint level.
• Manage and mentor junior DBAs users
• Enterprise Data Management using IBMInfoSphere Optim tool for Data Archive Performance Archive and Data Purge.
• Migrated Oracle Database from Solaris to Linux.
• Installed a new RMAN catalog database and successfully registered more than 20 databases.
• Export data from IBM INFORMIX database.
• Participated in the 24X7 on-call rotation with other DBA
• Import data from Flat files into Oracle using SQL Loader
• Installed and Configured OPTIM on Windows, UNIX and LINUX environments.
• Applied timely OPTIM Patches and Fix-Packs on all the Platforms.
• Performance tuning of SQL queries. Datamasking using OPTIM tool.
• Documenting the Process and deployment plan for execution.
• Co-ordinated with different teams and played key role in Migrating the Application from Solaris to UNIX environment.
• Senior DBA responsible for Installation, configuration, upgrade, migrate and patch Oracle databases in heterogeneous environment.
• DBA activities to support various production and development databases.
• Worked with DBA team to perform database performance analysis, capacity planning, system sizing and ongoing maintenance/tuning to ensure maximum performance.
• Directed a team of DBAs on activities like database upgrades, applying patches, data model changes, and security administration.
• Helped the DBA team to implement, tested and maintain backup and recovery procedures using RMAN
• Oracle DBA responsible database administration, SQL coding, database modeling and development experience. Advance level trouble-shooting and cleanup experience, years of schema design experience using ERwin, scripting experience in UNIX shell scripting variations. Modeled databases, including tables, constraints, triggers, stored procedures etc, to implement new products web-applications. Provide interface queries procedures for front-end Java application. Wrote shell scripts for automating load scripts.
• Configuring Data access through DG4ODBC to access the archived data from Oracle.
• Users are created in Oracle and required roles and privileges are granted.
• Windows DSN, Database alias, Access Definition AD , ArchiveRequest AR are created to archive the Data.
• Data Restored from Archive File into the Database using optim load request and optim Insert request.
• Data source names added in NAV UTIL bindings using optim connect studio.
• Shell scripts and SQL scripts are created to execute daily tasks of performance archiving and purge of data.
• Actively Participated in requirements gathering and review meetings and Documentation.
• Actively interacting with the Clients to understand the Business Standards and acting accordingly.
• Ensure development meets application requirements and is unit tested error-free.
• Strictly following the client security standards in all aspects of the Data Archive and Purge Process.
• Assist in the development, up keep and enforcement of database/coding standards.
• In-depth understanding and hands-on experience on IBM Optim
• Analysis of Data and providing the feedback for estimated time of the Total Archive and Purge Process.
• Provide timely response and resolution to Production issues, questions and defects.
• Worked as a team member to provide 24x7 on call, supporting Production databases for Archiving and Purge of data.
• Worked closely with senior DBA to understand the business and technical requirements as a DBA.
• Performed Installation, Upgrade, Patching, Tuning and Monitoring of Oracle databases.
• Performed Migration of major Oracle databases from Solaris to Linux.
• Configured Dataguard. Extensively used Dataguard Broker for Configuration and Administration.
• Performed Database Backup and Recovery using RMAN and Flashback database.
• Performed Installation and Configuration of Oracle
• Migration of DB from RAC to Oracle Exadata.
• Supporting for scheduled and unexpected backups using RMAN
• Routine DBA maintenance at onsite and coordinating with offshore.
• Generating weekly and monthly reports on progress and updates of the project.
• Upgraded Oracle database from 10g to 11g.
• Responsible for primary data warehouse, data mart, ETL tool and Business Objects repository database.
• Manage large compressed, partitioned 6 tera-bytes database on IBM AIX and Windows 7 platforms.
• Work with developers and change management team to ensure smooth life cycle progress from development through testing and production implementation.
• Managed database backup and recovery.
• Configuration of Oracle Enterprise Manager Oracle EM .
• Created statspack scripts for automatic periodic statistics gathering for performance tuning.
• Used ERStudio for data warehouse design, data modeling, data mart and DDL scripts.
• Worked as an Oracle DBA 9i/10g/11g on Linux, Sun Solaris, HP-Unix, AIX and Windows servers.
• Installed Oracle 10g Enterprise Manager Grid Control for diagnosing and monitoring performance related problems.
• Monitored and tuned databases and SQLs using tools like Oracle cost Based optimizer CBO , SQL analyzer, automatic checkpoint tuning, SQL Advisors, Performance Manager, and Stats pack. Installed and configured OEM GC and intensively used for Diagnostic tuning activities.
• Maintained Production databases upto 10TB.
• Configured RAC on oracle 11g R2.
• Implemented High availability
• Manage and mentor junior DBAs and ETL users
• Supported production databases as on-call DBA with pager for large number of production databases
• Script and automate DBA activities.
• Perform production system problem analysis and recommend corrective measures.
• Created ad-hoc query reports for the users and provided training for the reports.
• Shell scripting for automating several maintenance tasks.ETL Architect/Analyst responsibilities:
• Coordinate all the technical resources of assigned projects, ensuring the delivery of quality solutions in a timely manner consistent with the overall project objectives.
• Team lead data analysis and mappings for Claims, Drug, Family Care, Long Term Care, Prior Authorization, Provider, Pharmacy, Recipient, Third Party Liability subsystems in MMIS.
• Team lead data analysis and mappings for Child Support, Family Assistance, Home Energy Assistance, Income Eligibility Verification subsystems in DFD Division of Family Development .
• Supervised the migration of Informatica mappings and workflows from the dev to test environment and to the production boxes.
• Support as the core DBA the databases
• Created several metadata reports using the PowerAnalyzer.
• Developed OLAP solution for fast analysis of large volume of data, helped the users in creating complex reports in Business Objects and created several metadata reports using Power Analyzer.
• Performed upgrade of Informatica from version 5 to version 7.1.1
• Performed risk/impact analysis and conversion of several monthly load jobs to weekly load.
• Conducted User Group meetings, JAD Joint Application Development sessions.

Tools: Oracle 11g, Oracle Enterprise Manager, InformaticaPowercenter 8.1.1, PowerExchange, PowerAnalyzer, ERStudio, Business Objects, PL/SQL Developer, Shell, SQL Loader , SQL and MS Project, OPTIM 7.3/ 8.1/9.1, INFORMIX 7.3.1, Red Hat Linux 2.6,HP-UX 11.23,Solaris10, MS SQL Server 2005, TOAD 9.7.2, SQL, PL/SQL, Shell Programming.

Confidential

Sr ORACLE DBA

Role: Oracle DBA Release and Infra-Management, Compliance

The Federal National Mortgage Association, commonly known as Fannie Mae, was founded in 1938 during the Great Depression as part of the New Deal. It is a government-sponsored enterprise, though it has been a publicly traded company since 1968.

Responsibilities:

• Maintaining critical and production databases of size 90 TB
• CPU patching and DB PSU Patch application on quarterly basis.
• Upgrading Oracle Database from 9i to 10g on AIX/Linux/Solaris platforms.
• Resolving the Service Request tickets for all severity levels.
• Performed DB change requests for code deployment and migration from lower to upper Environments.
• Worked closely with senior DBA to understand the business and technical requirements as a DBA
• Worked with DBA team to perform database performance analysis, capacity planning, system sizing and ongoing maintenance/tuning to ensure maximum performance.
• Helped the DBA team to implement, tested and maintain backup and recovery procedures using RMAN
• Implemented Database
• Successfully upgraded Production and Test databases from Oracle 9i 9.2.0.8 toOracle 10g 10.2.0.3 on IBM-AIX nodes.
• Successfully upgraded Oracle 10g 10.2.0.4 to Oracle 11g 11.1.0.7 on IBM-AIX nodes.
• Instrumental in creating the backup/recovery and Disaster recovery strategies and helped the DBA team to follow them.
• Installation, configuration, maintenance and tuning of Oracle 11g and 10g.
• Involved extensively in planning phase of the EMERALD Data Centre migration.
• Co-ordinated with different Application Management Team regarding migration approach and planned accordingly.
• Managed and worked with the DBA team to adhere the standard operating procedures, database standards best practices and published them in SharePoint location, which in turn produced consistent results.
• Keep updating the knowledge in latest technologies of Database Servers, SAN arrays, Database features and provided the right direction for better cost effective solutions.
• Tracked the team on regular DBA activities like database upgrades, applying patches, data model changes, new database server setup, backup/recovery, 7 x 24 support, on-call rotation and security administration.
• Hands on experience in Oracle RAC, OLTP, Data warehouse, Very large Databases VLDB , Data Guard, RMAN backup/Recovery, Grid Control, SQL tuning, PL/SQL, and Shell scripts.
• Responsible for the DBA team to get Sarbanes-Oxley SOX and PCI compliance, and for satisfying SLAs.
• Driving the meetings and Co-coordinating with different teams.
• Proposed Migration methods Based on the dependencies involved at the Application Level.
• Gathered Server and Database configuration information and proposed Requirements for the New Data Centre.
• Co-ordinated with the OFF-SHORE team and provided the required Inputs.
• Gathered technical requirements in accordance to Application team and Database team.
• Documented technical specifications of Databases on various servers.
• 24x7 remote support and on call Database support for Database developers end-users.
• Installed a new Rman catalog database and successfully registered more than 100 databases.
• Automated routine DBA tasks like backup's and stats by using Grid control job's
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups with Export/Import Data pump utilities .
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository AWR , automatic database diagnostic monitor ADDM and automatic session history.
• Cloning duplicating databases using scripts as well as RMAN.
• Monitoring the database storage and day-to-day activities.
• Performed all aspects of Database Administration including Installs, Upgrades, PatchesBackup /recovery, Monitoring, Export/Imports
• Performed DBA tasks like Installation, Upgrade, Patching, Tuning and Monitoring of Oracle databases.
• Setup Oracle RAC and Dataguard for data-protection and for High Availability.
• Design Oracle Schemas, Performance Tuning, and Develop Partition and Index strategies for ETL Processes.
• Developed ETL processes for complex data-transformation using Oracle SQL Loader, PL/SQL and UNIX scripts.
• Performed Oracle SQL Performance tuning database size 1.5 TB on backend processes and Reports. Installing and configuring OEM for 160 database.
• Cloning every week activities
• Supporting and apply all required latest user request patches
• Supporting for OBIEE and fusion databases.
• Applied all CPU patches for all EBS environments.
• Applied all interoperability patches to Oracle R12.1.1/R12.0.4 environments.
• Applied all CRS PSU patches.
• Installed and configured VCP
• Installing and configuring GDVAULT.
• Performance monitoring of tablespace.
• Performance monitoring of concurrent programs.
• Performance monitoring of all EBS environments.
• Testing performance in UAT instance before going to production after adding any ebs module,
• Monitoring and oncall 24/7 production database.
• Attending and supporting oncall duties.
• Monitoring and resolving Siebel and Obiee database issues.
• Upgrade activities to all databases to 11.2.0.3 version
• Monitoring all databases via Oracle 11g grid agent.
• Refreshing schema as and when it is required by users.
• Resolving issues via ticketing system
• Administering system administration activities.
• Deployment of all production releases.
• Resolving and configuring workflow issues.
• Analyzed business requirements, design and development of datamarts and ETL load process.
• Support as the core DBA the databases
• Supervised the data integration from various sources including Oracle and Informix databases, COBOL flat files and excel spread sheets using Informatica PowerCenter 6.2
• Created sessions and workflows in PowerCenter 6.2 to schedule the ETL load process.
• Created reusable transformations to avoid complexity in mappings.
• The data loaded was used to generate reports and OLAP cubes using Cognos PowerPlay.
• Worked closely with senior DBA to understand the business and technical requirements as a DBA
• Improved and enhanced the multidimensional cubes in PowerPlay using Transformer utility.
• Created capacity and load distribution reports, compliance reports for MESA.
• Generated database tables, stored procedures and data insertion procedures to support various features of application in Oracle.
• Database performance tuning, and Troubleshooting
• Supporting for scheduled and unexpected backups and Data refresh using RMAN
• Routine maintenance
• Generating weekly and monthly reports on progress and updates of the project

Tools: Informatica PowerCenter 6.2, Cognos Impromptu, PowerPlay 7.0, Oracle9i, Shell, SQL, PL/SQL

Confidential

Sr ORACLE DBA

Responsibilities:

• Installed and configured 2 Node Oracle 10.2.0.4 RAC
• Built and configured 16 databases to support various applications
• Database performance tuning, and Troubleshooting
• Planned and formulated backups and recovery strategies
• Routine maintenance
• Administering Oracle Application System on sun4u sparc SUNW,Sun-Fire
• Administering Oracle database with RAC activities.
• Administering through Oracle Management Server OEM .
• Application System Administration and AOL
• Patching
• Implemented High availability using Golden Gate Replication. Implanted Bi-directional replication using golden gate.
• Worked closely with senior DBA to understand the business and technical requirements as a DBA
• Maintain the scheduling, distribution, and refresh for reports, views, and OLAP Performance tuning and support of application servers Defining and managing database connectivity to multiple sources and target databases.
• Reorganized data files, identified and eliminated contention factors like I/O, buffers and locks.
• Designed and implemented backup and Disaster recovery strategies with RMAN.
• Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL and Korn shell, Unix shell Scripting.
• Handled large database environments Data warehouse using Oracle Enterprise Manager OEM Grid control on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.
• Performed migration of databases, schemas, objects and data from 9i to 10g databases and single node to cluster databases using traditional export and Datapump.
• Perform Logical backup using and full/partial export/import and Data Pump.
• Developed UNIX shell scripts to perform the above tasks efficiently
• Instance planning from patch to production instances.
• Applying patches in production and test instances, using AD utilities to maintain the integrity of the Applications and Database.
• Installed Release 12 Development stage not Production yet
• Applying patches in production and test instances, using AD utilities to maintain the integrity of the Applications and Database.
• Day to day Application maintenance such as creating or modifying users, assigning Responsibilities to users, creating and running Request and troubleshooting.
• Day to Day code migrations.
• Creating custom responsibilities, request group, menus and concurrent program.
• Tackling the user issues accessing Applications if any.
• Taking care of backups of various instance that are critical for the new launches.
• Registered different types of Printers and customized the Style and Drivers to troubleshoot the printing issues for Oracle Application reports.
• Resolved various Problems that occurred while re-linking the application executables and generating report files.
• Run ADADMIN to compile APPS schema, regenerate forms, reports, generate Jar files.
• Administering oracle applications
• Creating the Users and groups in the O/S. Creating the NFS mounts in the system, setting up Printers on the UNIX machines.
• Interaction with Client and Oracle Support.
• Support as the core DBA the databases
• Trained the clients in the following:
• use of OEM using the web URL
• configure listener.ora and tnsnames.ora for the new oracle 10g server
• daily health checkup to verify that database is up and running using OEM
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of all Oracle databases.
• Documented the procedures for use by the clients.
• Manage and mentor junior DBAs users
• Facilitated database maintenance and support for the group.
• Performed daily tasks including backup and restore.
• Assisted the Performance/Load Test Team to prepare Performance Test environment. Ran statistics, finalized DB parameters and came up with database system settings to help maximize system performance. Sized tables, table spaces and sized SGA/PGA.
• Responsible for database security and performing physical and logical support of client's Data Repository. Worked on call in the support team for 24/7 production support, supporting OLTP Applications.
• Support as the core DBA the databases
• Trained the developers in Database connectivity Unit testing.
• 24 7 Production Database Support and maintenance.
• Working for oncall support periodically.
• Generating weekly and monthly reports on progress and updates of the project
• Installed and configured Oracle 10g and Oracle AS for FLEXCUBE
• Creation of databases
• Planned and formulated backups and recovery strategies
• Routine maintenance
• Generating weekly and monthly reports on progress and updates of the project

Tools: Oracle 11g/10g, RAC, Data Guard, UNIX, Solaris 10, TOAD, OEM, SQL, PL/SQL, TKPROF, EXPLAIN PLAN.

Confidential

Sr ORACLE DBA

Responsibilities:

• Installed and configured Oracle 10g and Oracle AS for FLEXCUBE
• Creation of databases
• Planned and formulated backups and recovery strategies
• Routine maintenanceWorked closely with senior DBA to understand the business and technical requirements as a DBA.
• Managing more than 120 production, test and development instances in 24 7environment.
• Administering ORACLE Databases 10g 10.2.0.4 , 11g 11.1.0.7 with over 5 TB in size.
• Involved in Installation of 11gR2 with ASM, Grid Control and Database upgrade from Oracle 9i to Oracle 11gR2 and applied patches as required.
• Setup of High Availability of the database using ASM enabled RAC for 10g/11gR2.
• Involved in 24x7 on-call support for 800GB 2 Node Production RAC database.
• Involved in construction of DR sites for all the Production environments.
• Performed Database Refresh from Production to QA, UAT and Development databases.
• Implemented and managed optimum physical database design tablespaces, datafiles, extents, redo logs, archive logs and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Extensive experience in RMAN recovery testing, RAC and stand alone database
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster RAC Databases
• Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests
• Monitoring Day-Day Backups, Log's recovering them as per the requirement. Utilized LOG MINER Technology applied Application Database Transactions on other Databases.
• Support as the core DBA the databases
• Successfully implemented Backup Recovery using RMAN which includeshotbackups and Cold backups.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
• Supported development teams by providing SQL statement tuning and optimizingETL procedures and removing load and query performance bottlenecks by usingtoolsEXPLAIN PLAN, STATSPACK, and TKPROF.
• Cloned schemas, objects and data on new server using exports from 10g database and imported in 11g using data pump.
• ONSHORE/OFF-SHORE MODEL - Lead Oracle DBA and Associate Project Manager team leader responsible for 3 onshore Oracle DBA's liaising with offshore team leaders to share a resource pool of 12 offshore India DBA's.
• Responsible for capacity planning, database security, recovery planning and installing patches
• Worked extensively on monitoring 10G grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.
• Complete installation and configuration of Oracle EBS 11i.
• Working on Production Database and application issues.
• Expertise in cloning and configuring Oracle Applications 11i.
• Expertise in cloning of RAC databases.
• Cloning of single node instance to multinode instance and visa versa.
• Working on 9i RAC Administration on Oracle Apps 11i environment.
• Complete installation and configuration of upgrade from 9i to 10g RAC on veritas cluster.
• Responsible for regular interactions with the UNIX teams to troubleshoot OS/Hardware issues.
• Performed Installation, Upgrade, Patching of Oracle E-Business Suite Oracle Financials .
• General Administration of Oracle Databases Back-up/Recovery, Tuning and Monitoring .
• Administration and configuration of Data guard for Oracle EBS databases.
• Creating Test and QA environments of Oracle EBS suite using RapidClone.
• Provided 24 x 7 Production Support.
• Responsible to ensure that the environments are stable and at acceptable performance.
• Worked on weekend implementations for critical projects and bug fixes.
• Regular Database activities like space management, user management, exports imports, troubleshooting database related issues, used Database tools like export, import, sql loader.
• Support as the core DBA the databases
• Oracle Applications System administration tasks like user management, responsibility creation, migration from instance to instance, Custom application registration, Multi-Org conversion, Concurrent Manager administration.
• Worked with Developers for performance issues.
• Patch application.
• Manage and mentor junior DBAs users
• 24 7 Production Database Support and maintenance.
• Installed patch for Oracle 10g in different environments
• Worked with up gradation of database from 9i to 10g.
• OATM implementation for RAC system and single node instances.
• Experience in installation of EBS R12.
• Working for oncall support periodically.
• Generating weekly and monthly reports on progress and updates of the project
• Installation of Oracle 9i
• Installation of the Oracle database server
• Creation of Table spaces, Schema and other related objects
• Database maintenance and tuning activities
• Performance monitoring and tuning of UNIX

Tools: Oracle 11g/10g, Oracle 10gRAC, Data Guard, Linux 4.x, AIX 6.1, OEM, PL/SQL, TOAD, Erwin, STATSPACK, AWR, EXPLAINPLAN.

Confidential

Sr ORACLE DBA

Responsibilities:

• Patch management
• Extensively involved in table and index sizing, rebuilding indexes for development, test and
• Production databaseson various platforms
• Scripting for day-to-day administration of the database
• Taking hot and logical backups and checking the database for performance
• Performance tuning
• Importing the logical backup dump of production database to Oracle database, finally to the
• Worked as an Oracle DBA 10g/11gR2 on Linux, Sun Solaris and AIX servers.
• Installed and administered Oracle Real Application clusters RAC 11gR2 on a 3 node Linux cluster using VERITAS Cluster File System V.C.F.S .
• Responsible for Installing, upgrading, Implementing and supporting oracle 10g R1/R2 and 11g R1/R2 databases.
• Involved in Installing and maintaining of Sun Solaris SVE Active/Passive Cluster on Oracle 11gR2.
• Involved in administration of over 150 Oracle 11g R1/10g R2 instances.
• Developing PL/SQL code, day to day DBA activity including the monitor and allocate storage space for data, Creation of the different databases environments for development, Testing productions Audit database usage, Tune the database.
• Implemented Stream, Golden Gates for Active-Active Replication between the Datacenter for High Availability.
• Hands on experience working with Golden Gate Director and configured ODI to use Oracle Golden Gate for Change Data Capture.
• Manage and mentor junior DBAs users
• Experienced with cross site active-active data replication using Golden gate.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Maintained Production, Development, Quality assurance database QA and Test databases.
• Support as the core DBA the databases
• Core DBA maintenance for DB's upto 7T.
• Designed and implemented backup and Disaster recovery strategies with RMAN.
• Assisted in implementing Oracle Financial Services Analytical Applications Infrastructure OFSAAI - Reveleus Basel products.
• Local database
• Controlling and monitoring user access to the database and other various database
• Related activities
• Configuring RMAN to manage multiple databases for backup and recovery
• Installation of Oracle 9i application server
• Creation and configuration of databases
• Formulating and implementing backup and recovery strategies
• Routine maintenance
• Performance monitoring and tuning other database administrative works

Tools :Oracle 9i/10g, UNIX, LINUX, Windows 2003 server, Oracle Dataguard,ShellScripting, PL/SQL, RAC, OEM, SQL Loader, Toad, SQL Plus, Oracle Configuration Assistant, Oracle Universal Installer.

Confidential

ORACLE Developer/DBA

Description: Project involved providing DBA support for Oracle Financials Implementation for I also provided Oracle Applications eBusiness suite support.

Responsibilities:

• Maintaining multiple Oracle 9i RAC Instances
• Support as the core DBA the databases for TCS
• Administering the database for space and performance issues
• Managing with backups for recovery
• Collecting database statistics and generating reports for statistics
• Maintaining production and test databases
• Installation and configuration of Oracle Database Software 10g.
• Oracle 9i, 8i, OEM, SQL plus, SQL Navigator, DBA studio, imp/exp, RMAN, SQL, PL/SQL, SQL loader, TKPROF, Oracle Tuning pack, Diagnostic pack, Red Hat Linux, and Windows 2000.
• Upgrading database from Oracle version 9i to 10g and migration of data.
• Involved in applying patches as per the requirements of the client and upgrade Oracle andDBMS software under Oracle.
• Involved in logical backup using and full/ partial export/import and Data Pump.
• Data modeling with extensive normalization activity.
• Data Migration from 9.2.0.5 to 10.2.0.1 on AIX 5.1, which is made on a Linux Advance Server.
• Setting up Physical Standby Database environment using Data guard in Oracle 9i and 10g.
• Performance tuning of application by identifying the SQL, which are not written well providing inputs to the application programmer correcting and implementing the right components.
• Using RMAN for backup and recovery.
• Created Oracle partition tables and applied patches as per the requirements of the partitioning module and applied patches for DBMS software.
• Installing and troubleshooting Red Hat Enterprise Linux 5.0 for Oracle 9i and 10g.
• Restoring backups from tape and importing into test database
• Installation of Oracle 9i on Windows
• Worked as an Oracle Production DBA 9i /10g/11gR1 on HP-Unix 11.x, AIX 5.2 and Solaris 10 servers.
• Installed and administered Oracle Real Application clusters RAC 10g on a 2 node Linux cluster using Oracle Cluster File System O.C.F.S and Automatic Storage Management A.S.M .
• Involved in Oracle partitioned tables and applied patches as per the requirements of the client and upgraded the Oracle and DBMS software.
• Upgraded the database from Existing Oracle 9i to Oracle 10g.Tune the application queries and identify the resource, database and design issues. Modify and implement new changes without affecting the functionality of applications and end-users for reporting server.
• Involved in the Migration of database from 9.2.0.6 to 10.2.0.1.
• Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL and Korn shell, Unix shell Scripting.
• Knowledge on stand-alone database using Oracle Data Guard feature for High availability configuration. Implemented Oracle Enterprise Manager Grid Control and configured agents.
• Worked as Oracle DBA 10g on HP-UX 11i v3.
• Installed and configured Oracle Database Software 10g.
• Upgraded the database from Existing Oracle 9i to Oracle 10g and Migration of database from 9.2.0.5 to 10.2.0.1 .
• Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL and UNIX shell Scripting.
• Implemented stand-alone database using Oracle Data Guard feature for High availability configuration.
• Manage and mentor junior DBAs users
• Implemented database refresh with the hot backup using full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Worked with Oracle partition tables and applied patches as per the requirements of the module. Used Oracle replication as databases for read only snapshots to maintain local copy of master tables in OLTP systems. Also done Patches for upgrading Oracle and DBMSsoftware.
• Used SQL loader to move data from legacy systems.
• Used PL/SQL Stored procedures, triggers, packages , SQL PLUS, SQL LOADER, Explain Plan, and SQL tuning of Oracle database.
• Troubleshoot Database performance issues using
• Creation of database, users and granting required privileges
• Creating SQL queries
• Administering the database for space and performance issues
• Managing various backup and recovery procedures
• Reorganize database objects like tables and indexes as and when required
• Database upgrade from 8.1.7.0 to 9.2.0.1.0
• Create database users and grant required privileges
• Monitor Table spaces for space issues
• Create database objects like tables, sequence and indexes as per the requirement
• Managing backup and recovery procedure

Tools :IBM P-595/P750 AIX servers, HP DL360/380 Linux Servers SUN SPARC/6500/V880, Oracle 8i/9i/10gR2 RAC, Oracle Grid Control, Data Guard, PeopleSoft, WebSphere, SQL Loader, PL/SQL, SQL, Java, J2EE, Veritas File systems, RMAN, Toad, Oracle TDE, DOM