SUMMARY

• 8+ Years of Oracle DBA experience in Database Administration, Installation, Upgrade & Migration, RMAN Backup and Recovery, Performance Tuning, Advanced Replication, Distributed Database, Database Security, Development and Production support in Oracle 8i/9i/10g/11g in local and remote environments on Operating Systems viz. LINUX, Sun Solaris, HP - UX, IBM AIX and Windows 2000/NT Server in 24x7 basis.
• High availability OLTP, Data warehouse (OLAP), DSS, and SAN environment. BMC tools including Patrol forOracle, Web DBA, and SQL Explorer. SQL Server including 2005
• Capacity Planning, Space Management and disaster recovery strategies.
• Installation and administration of Oracle 9i/10g/11g Real application cluster (RAC) with shared storage ASM, network file system (NFS).
• Good Knowledge of Oracle E-business suite (OEB) 11i, Oracle APEX.
• Hands on experience in Oracle Cluster ware. Experienced withDatabaseVault, Audit Vault, Data Masking, alsoDatabasesecurity products.
• Installation of Oracle 10g Grid control to monitor various databases and servers.
• Oracle 10g FLASHBACK to provide fast and easy recovery at database, table, row and transaction level.
• Enterprise Resource Planning (ERP)-Supply Chain Management (SCM),Customer Relationship Management, (CRM), Front Office, Back Office, Collaborative Commerce
• Oracle utility OPatch application - apply patches on Oracle database servers.
• Proficient with Oracle Recovery manager 9i, 10g, 11g.
• Good knowledge of asset and change management software BMC remedy.
• Oracle 11g enhanced features such as Flashback Data Archive, RMAN Data Recovery Advisor, and 11g DATAPUMP.
• Oracle 11g Real Application testing solution such as Database Replay, SQL Performance Analyzer (SPA).
• Proficient with Oracle Streams and Replication 10g/11g
• Oracle 10g AWR, ADDM, ASH in collecting and maintaining performance statistics for problem-detection and self-tuning purposes.
• Database upgrade (8i, 9i, 10g, and 11g) using Database Upgrade Assistant (DBUA) and manual upgrade method.
• Performance tuning of database, instance, SGA, I/O, using Enterprise Manager (OEM), TOAD.
• UNIX shell scripting, Window batch programming, Perl scripting, SSH, SCP.
• Configured and maintain physical standby database using Data Guard for High availability configuration.
• Tested and implemented different physical and logical backup, and recovery methods like point in time (PITR), media recovery, full / partial backup, Export/Import and DATA PUMP.
• Backup and recovery using RMAN and user managed backup.
• Data Modeling tool Erwin, ER/Studio for forward and reverse engineering, and maintaining the database in sync with the data model.
• Performing high performance data extraction, transformation, loading (ETL) using SQL Loader, OWB ( Oracle warehouse Builder), IBM DataStage
• SQL, PL/SQL, Query Optimization using optimizer hints, Explain plan, SQL trace, Auto trace, TKPROF, SQL Analyzer.
• Partitioning and sub-partitioning (Range, Hash, List, Composite) of tables in Data Warehouse, OLTP environment.
• Oracle Advanced Queuing
• Replication of data using snapshot, M-view, Oracle Replication Manager.
• Creating and managing database object like tables, views, sequences, synonym, index, DB link and Materialize view.
• Proficient with Oracle GoldenGate V 11.2.1.0.2. 3 + years hands on experience at setting up CRS, TAF, VIP's and other latestOracleDatabases technologies setups like ASM and OCFS.
• Managing security through grants, roles, privileges, and profile.
• Advanced security using Database trigger, Auditing, Tablespace Encryption, TDE (Transparent Data Encryption).
• Oracle supplied utility DBMS package, v$ views, DBA views, DBA HIST tables.
• Writing SQL, PL/SQL queries, Stored Procedure, package, Function, Trigger to implement business logic.
• Tools like Oracle Enterprise Manager (OEM), TOAD for database performance monitoring, tuning of SQL / memory and maintaining backups.
• Monitoring, Tuning and Backup/Recovery using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Supporting IBM DB2 mainframe, MySQL database.
• Programming and debugging skills in PL/SQL, SQL, T-SQL.
• Delivering database design phase of Software Development Life Cycle (SDLC) to higher level management.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, C, C++, VB, C#, ASP.NET, ADO.NET, HTML, XML, CSS, JAVA

Databases: Oracle 7X, 8X, Oracle 8i, 9i, 10g, 11g, 12c, MS SQL Server 2000, MS SQL Server 2005 DB2 8, 9.5, Mainframe, MySQL

Scripting: UNIX Shell script (Korn, Bourne, Bash), Perl

DB utilities: Export/Import, DATA PUMP, SQL*Loader, RMAN, Streams, GoldenGate STATSPACK, TKPROF, Explain Plan, OPatch, ORAPWD, Oracle Warehouse Builder, Crontab

Tools: Oracle Enterprise Manager (OEM), TOAD, SQL*PLUS, iSQL*Plus, Adhoc SQL, Crystal Report 8.5/10, Oracle Pro*C, Erwin 3.5/4.0, ER Studio, SQL Developer 1.2, Informatica, Visio, MS Access

Environment: (OS) & Protocol: SUN Solaris 8, 9, 10, 5.8, 5.9, HP-UX 10i, 11i, IBM AIX 4.3, 5.3, Linux, Windows 2000/2003/XP/NT, Red Hat Linux, SAN, TCP/IP, IPV4, IPV6, FTP, SSH, DNS,

PROFESSIONAL EXPERIENCE

Senior Oracle DBA

Confidential, Irving, TX

Responsibilities:

• Installed, configured and maintained oracle 10g, 11g databases.
• Perform daily monitoring of alert log files, trace files, system and listener availability.
• Manage 100+ database instances with database size ranging 10GB to 2TB.
• Tasked to support multiple databases (including OLTP and DSS) including administration of development, staging and production on UNIX platforms.
• Use Data pump Export/Import, SQL*Loader and Transportable tablespace for very high speed data loading and unloading of database.
• Migrated Oracle Database from Sun Solaris to HP-UX platform using Export/Import Utility.
• Use 11g DATAPUMP COMPRESSION parameter to compress the dump file during logical backup of database.
• Installed and configured 2-node 10g RAC using ASM on Linux.
• Apply Oracle database patch (CPU) patching on all production DB servers.
• Develop physical data model from logical data model using ERWIN.
• Monitor all database status including CPU, memory, I/O, Space Management, block, and dead lock using OEM.
• Implemented/Installed and configured Oracle Exalogic Elastic Cloud. Oracle Weblogic, Oracle Coherence, Tuxedo, Exalogic Control, Exalogic Hypervisor on Oracle Exabus
• Upgraded oracle RDBMS from 9.2.0.7 to 10.2.0.3 and 10.2.0.1 to 11.1.0.6 on Sun Solaris 10 Platform.
• Develop RMAN scripts for database backup and recovery including hot and cold backup.
• Create physical standby database from hot backup of primary database using Oracle Data Guard 10.2.
• Involved in SQL tuning using Explain Plan, TKPROF with SQL Trace and SQL tuning Advisor.
• Involved in troubleshooting OHASD (OracleHigh Availability Services Daemons)
• Create DDL script to create database object.
• Administer and monitor SQL Server 2005 databases.
• Use SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and SQL code
• Create, maintain, and audit users’ access to production databases by creating profiles with resource limits, password complexity and expiration policies.
• Recover block corruption in data file using 11g RMAN Data Recovery Advisor
• Create indexes (B-tree, Bitmap, Function based, Reverse key, Index-organized table), Partitioning (List, Range, Hash), and Materialized View.
• Create cloned database from production into staging and development environments on demand from project teams.
• Prepare GoldenGate parameter files for Extraction and Replication
• Install GoldenGate software in Test region to perform POC
• Investigate Replication failures using LogDump utility
• Test initial Data Load option of GoldenGate during environment build
• Setup GoldenGate Database User with necessary privilege
• Installed and configured Oracle GoldenGate for replication of data to heterogeneous targets/databases.
• Implemented High availability using Golden Gate Replication. Implanted Bi-directional replication using golden gate.
• Implemented Stream, Golden Gates for Active-Active Replication between the Datacenter for High Availability.
• Develop ETL batch process using PL/SQL, SSIS, other ETL tools.
• Experience in OWI reports and various advisors like ASMM, Undo Advisor, and Segment Advisor.
• Installed and configured Oracle Streams for Oracle instances on RAC Cluster
• Utilize ETL tool SQL*Loader to load data from flat files into oracle database.
• Write PL/SQL stored procedures, functions, packages and triggers
• Troubleshoot database performance (instance) tuning using ASH, ADDM, AWR, and STATSPACK.
• Write Unix Shell scripts and used Crontab to automate routine DBA tasks of taking backups, exports, monitoring space availability and database performance
• Manage on-call Production DBA activities such as checking on table space problems, fragmentation, nightly/weekly backup problems, responding to Oracle errors, and deadlock conditions.
• Deployed Crystal Reports to Confidential Business Intelligence (EBI) Dashboard, and SONAR.

Environment: Oracle 12c, 11g, 10g, 9i, Red Hat Linux, Solaris, HP-UX11, AIX, Windows NT/2000, TOAD 8.6, Erwin 4.x, Visio, Data Guard, RAC, RMAN,TKPROF,SQL-Trace, ASM

Senior Oracle DBA

Confidential, Herndon, VA

Responsibilities:

• Installed and configured oracle 9i and 10g, 11g database on Dev/Test/Prod system.
• Day to day monitoring like availability of system, listener, database, alter log file, trace file.
• Patched Oracle Database Server 9i and 10g using OPatch utility.
• Managed 55+ database instances with database size ranging 5GB to 1TB.
• Performed upgradation of oracle database from oracle 9.2.0.3 to 10.2.0.3 using DBUA in development, test and production environment.
• Installed Oracle Applications E-Business Suite R12. Isntalled in Dev, UAT and Production. Used Rapid Clone for cloning systems.
• Installed and Configured SQL server 2005 databases.
• Installed oracle 10g Grid control on Linux server.
• Used oracle 11g Database Reply to change the default values of parameters and determine the optimal value of the parameters.
• Setting Up High Availability Oracle GoldenGate (OGG) systems on Oracle Clusterware 11g Release 2 and Oracle 11gR2 RAC environments. Troubleshooting typical OGG technical problems such as unique key violation / long transaction abending by using GGSCI / Logdump / discard file analysis etc. Performance Tuning OGG in extremely high data volume environments. Installing and configuring OGG heterogeneous environments ( from Oracle to MS SQL Server).
• Experience in replication using goldengate, materialized views.
• Replication and Extracting data and applying on production using Goldengate.
• Back out the selected transactions using oracle 11g OEM Dependent Transaction viewing feature.
• Migrated critical database from one server to other with minimal downtime using oracle Stream.
• Replicated data between two database using materialized view and DB link. Worked withoraclePublic and PrivateDatabaseLink.
• Developed UNIX shell script to monitor database.
• Configured Oracle Data Pump for unloading and loading data to Oracle data warehouse. Configured parallel streams for performance
• Planning installation/configuration of Test and development environments (3 and 2 node RAC cluster). Maintained and Administrated oracle 10g RAC with automatic storage management (ASM).
• Created and Modified Cron job to run Export/Import, Backup, monitoring script on daily, weekly, first of the month, and quarterly.
• Developed SQL Loader scripts to extract, transformed and loading (ETL) data into table.
• Performed Daily Monitoring of Oracle instances using OEM Grid Control, TOAD to monitor users, table spaces, memory structures, rollback segments, logs, and alerts.
• Created Partitioned tables using Range, hash, list partitioning to improve performance and manageability.
• Migrated database from 9.2.0.8 to 10.2.0.3 from HP-UX (64 bit) to Linux (IA-64 bit).
• Provided disaster recovery by configuring and maintaining physical standby database using oracle Data Guard.
• Worked on database cloning to make Production instance available for Test and Development.
• Created users and involved in database security by granting roles, privileges, and profile to users. Involved indatabaseschema creation.
• Configured Auditing to audit information about database activity.
• Created database object like tables, indexes, views, synonyms, sequences.
• Developed PL\SQL stored procedure, package, triggers, cursors, and views.
• Performed, developed and maintained database backup and recovery using RMAN for various failures.
• Work with Sales in Scoping calls with partners/VARS and customers/Pre-Sales Engineering and develop Statements Of Work (SOW)
• Performed logical backup of database, schemas, tables using Export/Import and DATA PUMP utility.
• Proficiency and use of Change Management and Release Management - ChangeMan, Clear Case, PVCS Tracker
• Troubleshoot database performance issues using AWR, STATSPCK report
• Analyzed database object tables, indexes to get statistics.
• Freeing up companies resources from historical database by archiving out old data to tape then removing or shrinking tablespace to high water mark if reasonable
• Work closely with Systems Analysts, Systems Engineers/Admins & Application Developers through the SDLC from Development to Production, via Tech-Test in Needs Assessment, Requirements Gathering (Server hardware/OS specifications for Oracle Installs), Database Designing (Physical & Logical) and Implementation, database user creation and database access both at role & table levels, as well as final Project Performance Assessment/Evaluation.
• SQL query optimizing using CBO, overhead, bind variable, Explain Plan, TKPROF, STATSPACK.
• Created physical data model from logical model for Oracle application database using ERWIN.

Environment: Oracle 9i, 10g,11g Sun Solaris 10, HP-UX 11i, IBM-AIX, SQL Server 2005/2008, IBM DB2 8, Red Hat Linux 5.0, Windows 2003, PL/SQL, Erwin, SAN, OEM, TOAD, RMAN and RAC

Oracle DBA

Responsibilities:

• Installed, patched, upgraded, performance tuning, space allocation and maintainedOracleServer according toOracleOFA Standards.
• Installed and configured oracle 9i and 10g on SUN Solaris, IBM AIX platform. Upgraded oracle database 9i to 10g using DBUA on Sun Solaris platform.
• Provided disaster recovery by configuring and maintaining physical standby database using oracle data guard.
• Plan for GoldenGate installation/configuration and Oracle EBS R12.
• Administered RAC databases with ASM storage.
• Performed regular Backups and Recovery using RMAN as per Organization Strategy to support the database and also maintain 24 hours uptime for the database while carrying out the activities.
• Supported 15 Terabyte Oracle Data Warehouse (Oracle 10g).Used Sybase PowerDesigner for development and support of Data Warehouse
• Responsible for taking logical backups of data using Export/Import and DATA PUMP.
• Performance tuning of Oracle RAC database and single instance database.
• Used PVCS for code management and deployment / Maven for build’s
• Migrated and configured Oracle database 9i (9.2.0.4.) to 10g (10.2.0.1) using Export/Import.
• Identifying bottleneck and rectifying it fine-tune store procedures to improve performance, database loads, performance improvements, proper setup of database files.
• Supported Oracle 9i RAC database administration.
• Performed SQL tuning by using Explain Plan, TKPROF and TOAD.
• Created Partitioned tables using Range, hash, list partitioning to improve performance and manageability.
• Used Microsoft SSMA (SQL Server Migration Assistant for Oracle v5.2.1259) Project (OracleToSQL). Used Microsoft SSIS to cleanse/massage data from Oracle 11g to SQL Server 2012
• Developed PL/SQL stored procedure, packages, triggers, cursors and views.
• Created data objects like tables, views, and indexes
• Created users, assigning appropriate roles, privileges to users depending on the user activity and auditing of database.
• Installed and configured IGNITE performance monitor for Oracle and Microsoft SQL Server production databases.
• Migrated 4 Oracle 10.2.0.3 to Oracle 11G production database instances on Sun Solaris.
• Planned the index rebuilding, analyze index and analyze table periodically.
• Pinning of packages, procedures and functions in SGA. Use of recovery strategy when required.
• Performance Monitoring, determines the size SGA/PGA, Hit Ratio, estimate the number of users, CPU, and Disk space management, ADDM, AWR, MTTR advisor, OEM.
• Creation of monthly IOT, creation and management of partitioned indexes and tables.
• Implemented and monitored all databases using Oracle Enterprise Manager (OEM) for maximum uptime.
• Supported Microsoft SQL Server 2008 in a production environment for the scheduling system (Blue Pumpkin) - 600 users.
• Installed and configured OVO HP Openview for Oracle - for monitoring of production Oracle servers.
• Created new ASM disk groups using RAW disks, LUNS and adding, dropping disk members from ASM.
• Created migration process / migrated Oracle Collaboration Suite 10.2.0.4 to Oracle Beehive - migrated mail accounts - all data, including mail attachments, calendar (Over 5 Terabytes).
• Load data from flat file to database table using ETL tool SQL* Loader, OWB.
• Extensive use of Crontab in UNIX environment for scheduling routine tasks.
• Designed and generated reports from wide range of data source using Crystal report.
• 24x7 production support DBA working on a primary/ secondary pager rotation.
• Supported Oracle Dataguard for off-site disaster recovery

Environment: Oracle 9i, 10g, 11g, RAC, SQL Server 2005, Windows XP, Sun Solaris 10, HP-UX 11 (64 bit), Red Hat Linux 4, SQL Server 2008, OEM, RMAN, RAC, Crystal report 8.5, SQL*Loader, TOAD, SQL Developer, Erwin

GIS/Database Analyst

Confidential

Responsibilities:

• Designed database ‘Akshaya Drishti’ based on the Route distribution Overlay Document V3.4 and documents based on Karnataka State Environmental regulations.
• Developed ‘IHF Drishti View’ ArcGIS application for real-time updating and viewing of Akshaya Patra vehicle transist reports.
• Install and support for RedHat Linux (5 servers) - VMware
• Assigned addresses, master street index, GIS street centerline, address point files for the First Phase of Food distribution. Ground Truth was done in January 2006.
• Designed GIS integration with ISKCON’s financial services software - Finsight.
• Recorded cartographic data using digitization and CAD drawings for the vehicle stations and its associated routes, inventories.

Environment: ArcGIS 8.x/9.x, ArcGIS Online, ArcView 3.3, VisualBasic (VBA and ArcObjects), C#, C++, HTML, CSS, Python, SQL Server 2000, SQL, MySQL, TileMill, XTools Pro for ArcGIS, Global Mapper, Google Earth, ENVI