Summary

• Eight years of Information Technology experience includes Oracle Database Administration 12c/11g/10g/9i on different Unix operating environments like AIX, Sun Solaris, Linux Advance Server, HP UX and Windows Server.
• Database experience using Oracle 12c/11g/10g/9i , SQL,PL/SQL,SQL LOADER, Stored Procedures, TOAD ,Explain Plan, TKPROF FUNCTIONS , Materialized Views ,Database links and streams.
• Created and setup Oracle databases 12c.Created Container database and Pluggable databases.
• Experienced in Upgradation and Migration of Oracle Database across various platforms.
• Responsible for installation, upgrades, patches, TAR support, database tuning, concurrent manager administration, cloning of large databases.
• Duties included Database creation, Database up gradation, Database tuning/reorganization, SQL statement tuning, backup/recovery, general troubleshooting, develop/integrate relations, script development, documentation and DBA training.
• Worked on several OLTP,OLAP and Enterprise Data Warehouse databases and provided 7x24 support.
• Installed ,configured and upgraded OLTP,OLAP and Enterprise Data Warehouse databases on various platform linux,Solaris,AIX versions 10g and 11g.
• Involved in configuring and maintaining the Real Application Clusters RAC with ASM on four nodes and two nodes for high scalability and availability both 10g/11g .
• Created and maintained Oracle RAC/RAC One Node 11gR2
• Experince ASM, ACFS, OCFS2
• Wrote several scripts for RMAN Duplicate from Active Database as well as RMAN backup / recovery operations
• Upgraded 10g clusterware to 11g Clusterware on aix and linux platform and sun solaris platform.
• Upgraded multiple 10g databases to 11g databases both RAC and non RAC .Converted Single instance to Rac database and Vice Versa.
• Converted database from normal file system to ASM and from ASM to normal file system .
• Configured RMAN backups on tape for TSM for both test and production databases.
• Designed and implemented Backup and Recovery strategies by taking cold backup, hot backup through rman and logical backup through Data pump.
• Wrote scripts to take weekly full backup of production databases on tapes through rman and incremental backups daily of production and test databases.
• Cloned several databases through rman and also active database cloning through Rman.
• Administered and installed grid agents in OEM Grid Control on production and development database servers.
• Installed and administrated OEM Grid Console
• Experience in Oracle Disaster Recovery and High Availability Solutions RAC Data Guard .
• Experience in creating Logical standby and Physical standby databases on various platforms.
• Created and administered physical standby using data guard set up Snap Shot standby using dg broker
• Configured Active Data Guard for physical standby databases
• Supported failover and switchover of Standby Databases during Disaster Recovery
• Testing and implementing different physical and logical backup and Recovery methods like point in time, media recovery, full / partial export/import.
• Proactive database monitoring, administration and maintenance of 10g and 11G database.
• Configured and Worked on Replication like Materialized Views and Streams
• Set up Bi-Directional streams on both Rac and Non-Rac databases .
• Set up upstream and down stream for both rac and non rac production databases
• Performed Performance Tuning of Database, Application, System Global Area, I/O, Rollback segments using different tools like Oracle Enterprise Manager, Toad, Explain Plan, Tkprof reports , grid control and Awr reports.
• Worked on 10g and 11G new Partition techniques.Partitioned huge tables to resolve performance issues.
• Worked On call for 24X7 Production Support. Willingness to work beyond regular hours.
• Worked on Erwin ,IBM Information Sphere , Conducted team meetings and proposed data requirements, data mappings and verifications.
• Experience on PL/SQL Programming, Stored Procedures, Triggers and Transaction management. Experience in hardware and OS installations, implementation, integration, maintenance and testing in a client/server applications
• Provided after hour maintenance, coordinated with consultants for patches and upgrades.
• Applied rolling patches on 11g/10g grid and RAC homes.
• Applied PSU, CPU, Patch set and one off patches to RAC, ASM and databases . Applied rolling patches on 11g/10g grid and RAC homes.
• Involved in OBIEE upgrade to OBIEE 11g.
• WORKED FOR OBIEE and SAP integration for the client to implement the reporting in OBIEE
• Relinked oracle binaries after OS upgrades in aix and linux both RAC and NONRAC
• Worked as administrator for IBM Information Server Data stage
• Worked with Erwin Data modeler for setting up naming standards, data type standards and modeling.
• Worked on GoldenGate Replication . Configured Extract, Replicate processes for GoldenGate.
• Configured Golden Gate 11G for extraction and replication of transactional Data Manipulation Language DML operations and data definition language DDL changes.
• Analyzed and modified ETL logic using Informatica.Actively participate in discussions with various teams regarding implementation and design of solutions
• Performed and implemented rollout of Informatica Metadata Manager.
• Configured JDBC connection pools ,SSL and DataSources for Weblogic.
• Configured HTTP server functionality and Virtual Hosts for Weblogic.
• Managed database administration and support of MS SQL Server 2012/2008R2/2005 in Cluster Server Environments.
• Managed database security in production environments using SQL Server 2008.
• Experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server 2000 and SQL Server 2005/2008/2012.

Technical Skill-Set

• Operating Systems: AIX 5.1/5.3, Sun Solaris 2.7/2.8, Linux Advance Server, HP UX 10.20, 11i, Windows 2000/NT/XP/98/95
• Database Management: Oracle 12c/11g/10g/9i /
• Tools / Utilities: Oracle Enterprise Manager, Toad, Export, Import,
• SQL Loader, Oracle IAS, Business Objects, Oracle Discoverer, Forms, Reports, Apache Web server, ASP.Erwin4.1.4. RMAN, ASM, Grid Control, Golden Gate, EXP, IMP, Maximo,IBM info sphere
• Modules: Financials GL, AR, AP, Fixed Assets, Cash Management , iSupplier, procurement, Manufacturing, Order Management, Inventory, HR, Payroll, Projects, CRM, Oracle Supply Chain Management, MRP, Workflow, MWA Mobile Web Applications .
• Language: SQL, PL/SQL, UNIX Shell Scripting, Python, PERL, SQL PLUS, C, Java, Shell Scripting
• Hardware: IBM RS 6000 Servers, Sun Sparc E6500 with EMC Clarion,
• Raid 5 Disk Storage, Sun Sparc E4500/5000/450/420, HP 9000/E39, Dell Power Edge 2550/4550. Sun E6500, HP9000, RS/6000, Sun SPARC Servers, IBM System Z, IBM RS 6000, IBM p590, p690,p570, DELL,SQL-Server 2005/2008/2012

Professional Experience

Confidential

Oracle DBA/Analyst

Confidential

offers a wide range of investment products and services designed to meet our investors' specific financial needs, offering expert ways to help them control and manage income through retirement. My work as an Oracle DBA included maintaining and upgrading the Oracle database and providing production support.

Roles and Responsibilities

• Administrated and created production, development, and test Oracle 12c/11g/10g/9i databases hosted on Aix, Linux, Sun-Solaris and Windows Server.
• Created Oracle Real Application Clusters RAC/Grid 11g on aix/Linux with SCAN and ASM
• Defined database migration strategy to relocate production database to new Linux servers, AIX and windows server.
• Configured OEM 12c monitoring .Created rules to send out mission critical alerts from production database.
• Backup and recovered test and development databases using RMAN and DataPump.
• Defined Oracle11g upgrade strategy for production, development, and test databases.
• Measured the performance of the shell scripts by getting the expected results.
• Installed and configured Oracle 10G and Oracle11g Database on AIX and Linux advance Server on Development, Test and Production Systems.
• Installed and configured 10g/ 11g RAC databases with ASM/non ASM on Linux , aix and sun solaris two node,three and four node .
• Upgraded database from 10g to 11g both RAC and Non RAC including Standby databases.
• Supported failover and switchover of Standby Databases during Disaster Recovery
• Created and maintained Databases and their objects like tablespaces, tables, indexes, views.
• Experience in 10g RAC and 11g RAC configuration, maintenance and support.
• Experience in Oracle 10g/11G Real Application Clusters RAC , Oracle Data Guard, Oracle Automatic Storage Management ASM .
• Migrated Stand alone databases on file system to RAC databases on ASM.
• Upgraded crs from 10G to 11gR1/11gR2 grid infrastructure .
• Applied patches regularly on Oracle 11g/10g Clusterware and RAC databases.
• Installed, setup and configured Oracle Enterprise Manager Cloud Control 12c for administration, performance tuning, monitoring and alerts.
• Added and deleted RAC nodes as per the application requirement .
• Worked on major issues involving 10g/11g databases on 11g R2 Grid/RAC and 11g ASM.
• Configured ASM Cluster File System ACFS for 11gR2 Grid/RAC cluster.
• Create or clone the Oracle Instance and Databases on ASM. Perform database cloning and re-location activities.
• Configured RMAN backups on tape for TSM for both test and production databases.
• Created RMAN scripts for daily as well as monthly backup's using autosys.
• Worked on various Rman scripts for taking full backup and incremental backup for production databases .
• Wrote several scripts to automate cloning of database from production to test through rman on weekly basis.
• Performed Database cloning using Datapump , Rman Duplicate and Cold backup restore .
• Configured Bi-Directional Streams on production Rac databases both 10G/11G Rac and non Rac .
• Upgraded Multiple databases from 10.2.0.3 to 10.2.0.5 Rac and Non Rac and to 11gr1/11gr2
• Partitioned appropriate tables to optimize performance and simplified maintenance work.
• Tuned and optimized SQL Query, SGA, Disk I/O using Oracle Enterprise Manager and by monitoring the Awr report generated from snapshots taken at the peak business hours.
• Monitored and tuned rollback segment, temporary tablespaces, redo log buffer, sort area size.
• Implemented OUTLINES on Siebel Databases for queries which had performance issue .
• Worked with RAC Clusters Mask Problems Involving a Single Node
• Followed OFA to eliminate fragmentation of free space in the data dictionary, isolate other fragmentation, and minimize resource contention
• Added a node at the RDBMS layer in a RAC Environment
• Created multiple standby databases.Set up Snap shot standby database using data guard broker.
• Created many active data guard databases on aix and linux platforms.
• Supported disaster recovery by opening the standby databases in read write mode .
• Set up scripts to monitor log apply on Standby Database .
• Rebuilt Multiple Standby databases 10G and 11G
• Added virtual IPs for new nodes in RAC Environment
• Configured Materialized Views on remote databases .Wrote many scripts to monitor refresh times.
• Created numerous Materialized view groups involving huge tables.
• Worked on Performance tuning with AWR, ADDM, SQL Tuning advisor, SQL Trace and TKProf.
• Experince in Database design on OLTP and OLAP databases and maintained database security create and maintain users and roles, assign privileges .
• Coded BASH,PERL scritps to maintan database change management and data management .
• Coded BASH,PERL scritps to automate backup and recovery procedures for various versions of database.
• Developed the OBIEE Metadata repository .rpd model with the necessary logic that involved creating the Physical, BMM layers.
• WORKED ON Debugging, Optimizing and Performance Tuning of Oracle BI Dashboards/Reports
• Tuned database/cluster/ASM according to application requirements.
• Tuned long running queries by tk prof and explain plan and hints.
• Worked on all types of partitions .Set up partition strategy involving tables with million of rows to improve performance.
• Created Hash , Range partitions on huge tables and worked on Partition pruning on SQL.
• Worked on GoldenGate Replication . Configured Extract, Replicate processes for GoldenGate.
• Installed database for Siebel replication using Golden Gate 11g
• Configured streams on 10/11g databases. Configured down stream and up stream for production databases.
• Worked as administrator for IBM Information Server Data stage
• Set up jobs to automate startup and shutdown of IBM Information Server components.
• Performed software installations and upgrades to Informatica software packages.
• Upgraded and patched Informatica to newer versions.
• Experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server 2000 and SQL Server 2005/2008/2012.
• Installed necessary Service Packs for SQL server 2008.
• Experience in using SSIS SQL Server Integration Services , Experience in SQL Server 2005 Reporting Services SSRS
• Configured WebLogic Server resources active on the server, such as JDBC Connection Pools and startup classes.
• Worked on WebLogic J2EE Connectors and WebLogic Web Services.

Environment: Oracle12c/11g/ 10G ,Oracle 9i , Oracle 9iAS, HP-UX 11.0, RMAN, Cluster failover, Unix Shell Programming, SQL, PL-SQL, , TOAD,ERWIN 4.1.4,IBM-AIX,SunSolaris,Jboss,WebLogic,linux,windows2000/2003, OBIEE 11g, SQL Server 2005/2008/2012

Confidential

Oracle DBA/Coordinator

Confidential

is one of the largest property and casualty insurance companies in the United States and is part of GMAC Financial Services. The company provides a broad range of insurance and insurance-related products and services for individual consumers, as well as automotive dealerships and other businesses.

Roles and responsibilities

• Installed and configured Oracle 10g /11g on AIX platform and Sun Solaris
• Created and maintained high availability and high scalability Oracle 10g RAC Real Application Clusters - two nodes on sun solaris and linux
• Upgraded database from 10g Release to oracle 11g release 11.1
• Used to main RAC nodes by adding node to the cluster at the cluster layer , used to shutdown Individual nodes for maintenance while application users continue to work.
• Experience in using RMAN in a RAC / Data Guard environment
• Worked with Real Application Clusters to provide with guaranteed continuous availability of databases
• Worked on SQL Plan Management for database stability and performance tuning.
• Created multiple oracle 10g rac databases on sun solaris 2 node ,3node and 4 node
• Upgraded various databases from 10g/11g on aix , linux and sun solaris.
• Setup OEM Metrics to generate alerts from production and non production databases.
• Took logical and physical Backups using Export, Import and performed Recovery when needed. Used RMAN to perform back up and recovery.
• Used to work with RAC to handle instance recovery from surviving node.
• Performed Database Cloning to create new TEST and DEV instances from production
• Tuned Shared Pool, Buffer Cache, Large Pool, Redo log Buffer, Sort Area, Rollback Segments, I/O, Query Response Time, Hit/Miss ratio etc.
• Inspected alert log file, monitored tablespaces and partitions that span across several tablespaces.
• Monitored performance of Databases and Applications using various tools like OEM, Explain Plan, STATSPACK, Tkprof, Data Dictionary Dynamic Views and SQL Trace.
• Applied various patches as required.
• Applied DST patch on oracle 9i and 10g databases and checked if time zone is affected
• Responsible for physical and logical models of the database.
• Implemented security protocols for the database.
• Performance Tuning use of SQL diagnostic ADDM, SQL Adviser and Oracle utilities like AWR, STATSPACK, EXPLAIN PLAN, AUTO TRACE TKPROF
• Provided 24x7 on-call support. Supported systems beyond regular hours/ weekends/ holidays.
• Responsible for the Data modeling and populating the business rule using mapping into repository for meta data management and creation of referential tables.
• Involved in numerous Unix Korn Shell Scripting pertaining to the activities of the DBA.
• Used Enterprise Manager and Recovery manager to perform backup and recovery operations
• Cloned databases using RMAN duplicate
• Worked as a member of an application migration team to develop test and implement a database migration.
• Managed OLTP On Line Transaction Processing system about 10 databases at one time, biggest database around 300 GBytes 300GB supporting both production developments on Unix and WindowsNT/Windows 2000.
• Set up and configured Oracle databases in around 90 servers Sun-Solaris
• Worked with Very-Large databases VLDB up to 10 terabytes, data migration, against Oracle other databases such as MS Access, SQL Server.
• Used to develop the migration strategy, execute trial runs, data validation and implementing the final migration.
• Set up data guard for rac and non rac databases .
• Supported failover for standby databases during disaster recovery .
• Created multiple physical and logical standby databases.
• Wrote several scripts to detect gaps in standby databases.
• Used to automate jobs by writing scripts in perl and shell.
• Handled databases of size around 2 terabytes
• Worked with Data Guard to protect a standby database from corruptions that attempt to propagate from a primary database.
• Experience with high availability SQL Server solutions, including Replication Models Snapshot/Transactional and SQL Server clustering Active-Active, Active-Passive

Environment: Oracle11g/ 10G ,Oracle 9i ,Oracle 8i, Oracle 9iAS, HP-UX 11.0, RMAN, Cluster failover, Unix Shell Programming,windows200/2003SQL, PL-SQL, , TOAD,ERWIN 4.1.4,IBM-AIX,SunSolaris,Jboss,WebLogic,linux,SQLServer2005/2008/