SUMMARY:

• 16+ years of extensive work experience in Oracle Database Development and Administration.
• Experience includes 14 years of DBA work, handling mission critical VLDB of 10+ TB size, supporting 24*7 Production, Pre - Production, UAT, and Dev instances running Oracle 7.x, 8.x, 9.x, 10.x, 11.x & 12.x on HP 11i, Sun 8/9/10, Linux 2.6 and Windows servers 2005, 2008 and 2+ years as Java Developer & Weblogic Admin
• Experience on Sybase ASE versions 12.x to 15.x
• Extensive experience in Oracle Installations, configuration and upgrades.
• Upgraded databases across platforms(Solaris to Linux) of 10+ TB to 11202 through downstream capture using staging database
• Expertise in setting up High Availability - Installed, configured, support and tune 2 node OPS running 23 instances each on Sun 8/9/10 and HP 11i. Installed configured and supported Oracle 11g/10g/9i RAC on Sun and Veritas cluster, Oracle Clusterware and MC ServiceGuard, Oracle DataGuard, Snapshot Replication, Materialized Views and Streams.
• Installed and configured 12c multi-tenant Databases with Container database(CDB) and Pluggable databases (PDB)
• Upgraded 11g databases to 12c multi-tenant architecture
• Automated DBA tasks like backup, monitoring & Database cloning
• Worked extensively on ASM, OCFS, ACFS, VCS and Other Cluster File systems
• 3+ years of extensive work experience on Oracle security features including Transparent Data Encryption (TDE) and data masking and security wallet.
• Installed and configured EM Grid 10.1.0.3.0 and later upgraded to 10.2.0.5.0
• Lead a team to provide 24*7 remote DBA support to mission critical 10+ TB, over 100 DW and OLTP. Flexible to work either in a large team or to work as a only DBA
• Extensive experience in 10g Grid control installation, configuration, upgrades and target configuration for issue alerts. Monitor databases using BigBrother, Mercury Site Scope and OEM & Grid. Created and implemented scripts for monitoring and automating paging to on-call DBA for database Priority issues.
• Strong experience in Performance Tuning. Used Oracle trace files, Analyzed SQL statements and Statspack generation. Tuned databases by using tkprof, AWR (statspack), ExplainPlan, Disk I/O optimization, pinning frequently called PL/SQL blocks in SGA, fine tuning initialization parameters and kernel parameters.
• Experienced in trouble shooting of production databases. Liaison with Oracle Metalink support for bug fixing and SR management. Interacted with Oracle support regarding bugs resulted out of operations (8298753, 8496614, 8598847, 8708384)
• Performed Capacity Planning, Growth trend analysis and Prepared Reports.
• Designed and implemented backup policies for most critical, zero down-time databases and automated cold and hot (User managed, RMAN & SQL BackTrack) backups using Veritas NetBackup, Tivoli Storage Manager & BakBone NetVault. Archived current databases to archival databases by using transportable tablespaces.
• Implemented Flash back database / Flash back query / Flash back table features for faster fault recovery.
• Restored & Recovered databases from data files of two different incarnations due to lost file systems by setting “underscore” hidden parameters for recovery of critical data
• Designed and implemented Disaster Recovery policies carried out DR exercises and successfully recovered databases from crashes.
• Installation, configuration & administrations of Sybase ASE and Sybase Rep Servers. Successfully recovered Sybase ASE servers due to master DB corruption by rebuilding.
• Installation, configuration and administration of MySQL 5.x database servers. Automated backups and monitoring through shell scripts and also through MEM. Configured MySQL Replications
• Installation, configuration and administration of MS SQL Server 2005/2008 database servers. Installation and configuration of Transactional replication and database mirroring.
• Setup, configure and manage Oracle Message Gateway to interact with DB2 on Mainframes
• Design, implement physical and logical database models on ERWIN with forward and backward engineering
• Strong experience with Development and tuning of SQL and PL/SQL scripts, database Procedures and Triggers, Shell and AWK scripts, Oracle Forms 4.5 Reports 2.5. Developed Java code with WebLogic Application Server as backend.
• Experienced in Data center consolidation, move and de-commissioning databases for efficient use of Disk space, CPU and memory.
• Designed and implemented SOP for change control / Change management using Remedy, TreamTrack through trouble tickets and OSR (Operation Service Request) and prepared technical documentation.
• Installed and administered Mercury-ITG and Serena tools
• Successfully mentored team members as a part of team building

TECHNICAL SKILLS:

Databases: Oracle 12c/11g/10g/9i/8.x/7.x, Sybase 12.x/15.x, MS SQL Server 2005/2008, MySQL 5.x

Operating System: Sun Solaris 10, HP-UX 11i, RHE Linux 6.5, Windows 2003/2000/NT

Hardware: Sun M5K, Sunfire, HP 9000, NetApp Filers, Intel Servers

High Availability: OPS, RAC, RON, DataGuard, BCV, SRDF, Oracle Streams, Advanced Replication, VCS, MC-ServiceGuard, Sybase Replication, MySQL Replication, MS SQL Server Transactional Replication, Database mirroring

Backup tools: Veritas NetBackup, Tivoli Storage Manager, BakBone NetVault, RMAN, BCV, SQL BackTrack, CA ArcServer

Monitoring tools: OEM Grid control, OEM DB Control, Quest Spotlight, MySQL Enterprise Manager, BigBrother, Mercury SiteScope

Languages: Java 2, PL/SQL

Utilities: Datapump, SQL Loader, Exp/Imp, AWR, ADDM, Statspack, Optach, TOAD, DBArtisan, Erwin 7.3, Oracle Message Gateway, Sybase Central, Sybase Control Center

Scripting Language: Shell Script, AWK, SED, Java Script

Configuration Management: Serena, Mercury ITG

Web/Application: ServerOAS 10.1.3, WebLogic 5.1.0, IPlanet 6.0

PROFESSIONAL EXPERIENCE

Confidential, New York City, NY

Senior DBA

Responsibilities:

• DBA managing all Production, QA & Development databases in 24*7 environment running Oracle 12c/11g R2 with Dataguard, Sybase ASE 15.7 and Sybase Rep Server, MySQL 5.5.x with MySQL Replication and MS SQL Server 2005/2008 with Transactional Replication.
• Installed and configured Sybase and SQL Server plug-ins to monitor Sybase and MS SQL Server databases through Oracle EM Grid Control
• Installed and configured 12c multi-tenant Databases with Container database(CDB) and Pluggable databases (PDB)
• Upgraded 11g databases to 12c multi-tenant architecture
• Extensively worked on RMAN configuration, Block Change Tracking implementation and trouble-shooting
• Configured databases for “Flash Recovery” to have faster fault correction by using flash back database, flash back query and flash back table features.
• Rebuilt Standby database as databases was out of sync due to missing archive logs
• Performance tuning by through AWR & ADDM and explain plan
• Resource management configured using Oracle DBRM for optimum utilization of OS resources
• Setup backup strategies and implemented RMAN, logical backups and also Flashback feature to achieve fault tolerance. Scheduled backup jobs through RMAN
• Configured jobs through EM Grid control to manage standby host archive logs and other files through shell scripts by using remote ssh
• Used TOAD for administrative, query building and monitoring tasks
• Configured various house-keeping jobs for alert log & listener log rotation and cleanup of old trace files
• Setup monitoring in OEM Grid control and manage warnings & alerts for all relevant Database metrics
• Support day-to-day activities - Users requests, cloning, creation of new objects, modification to existing objects, code migration and data load etc.
• Installed, configured and administered Sybase ASE 15.7 and Sybase Rep Server 15.7.
• Installed, configured Java option in Sybase ASE
• Successfully recovered Sybase ASE server by rebuilding master database due to corruption caused coz of secondary truncation point.
• Upgraded Sybase ASE 11.9.2 to 15.7
• Configured Sybase HA with MSA Sybase servers through Sybase Replication Server
• Troubleshoot Replication Server issues due to data inconsistency & route failures
• Monitoring and Performance tuning through Quest Spotlight and sysmon utility for optimization of database performance
• Sybase product license management
• Performance tuning through show plan & optdiag and optimizing table stats and index management.
• Installed, configured and administered MySQL 5.5.x and 5.1.x database servers.
• Upgraded MySQL 5.1.x to 5.5.x and 5.6.x
• Configured database backups through mysqldump and cloned to non-prod servers.
• Setup monitoring scripts for database server load with script to execute automated resolutions
• Setup MySQL Replication on 5.5.22 database servers for HA
• Configured resource utilization limits through max connections parameters
• Installed, configured and administered MS SQL Server 2005/2008 database servers.
• Setup up Transactional replication and database mirroring for HA
• Troubleshoot transactional replication issues
• Monitor database servers through SQL Server Management Studio
• Restore crashed databases on to different host through Copy/detach/attach and also through CA Arc Server backup
• Support day-to-day activities - Users requests, cloning, creation of new objects, modification to existing objects, code migration and data load etc.
• Working on Datacenter migration project which involves modification of database architecture, cross-platform migration.
• Performance optimization through SSMS execution plan management

Environment:Oracle 12c/11g R2, Data Guard, ASM, Solaris 10, RMAN, TOAD, 10g Grid control, Sybase ASE 15.7, Sybase Rep Server 15.7, Sybase Control Center, MySQL 5.5.x, MySQL Replication, MySQL Enterprise Monitor, MS SQL Server 2008/2005, Transactional Replication, Database Mirroring, SQL Server Management Studio, RHEL 6.5, Solaris 10 SPARC & x86, CA ArcServer

Confidential, Raleigh NC

Sr. Oracle DBA

Responsibilities:

• Primary DBA Managing all Production, QA & Development databases in 24*7 environment running Oracle 11g/10g on SPARC Solaris 10 servers with DataGuard configuration.
• Support day-to-day activities - Users requests, cloning, creation of new objects, modification to existing objects, code migration and data load etc.
• Setup and manage Oracle MGW queues to transport data between Oracle and DB2 running on Mainframes
• Performance tuning of database and optimize queries for better performance
• Design, create and manage physical and logical database models through ERwin including reverse engineering methodology.
• Migrated databases from Non-ASM to ASM and vice-versa
• Installation and setup of OMS and 10g Grid control for monitoring of databases.
• Setup monitoring in OEM Grid control and manage warnings & alerts for all relevant Database metrics
• TOAD for query management and basic database monitoring
• TOAD Team Coding for version control and code management including code migration
• Setup backup strategies and implemented RMAN, logical backups and also Flashback feature to achieve fault tolerance. Scheduled backup jobs through RMAN, Veritas NetBackup (MML) & Datapump. Scheduled jobs through UNIX crontab & dbms scheduler
• Extensively worked on RMAN configuration, Block Change Tracking implementation and trouble-shooting
• Configured databases for “Flash Recovery” to have faster fault correction by using flash back database, flash back query and flash back table features.
• Worked on partitioning of tables for data warehouse operations for achieving faster response time. Partitioned tables based on range, list & hash methodology. Used dbms redefinition & exchange partition
• Planning, implementation and reclaiming databases through Disaster recovery by implementing quarterly DR exercises
• Setup strategies and prepare project plans for new projects, upgrade and backup activities
• Capacity planning for existing and new databases for Database size, CPU and memory
• Documented technical processes and set up SOPs

Environment:Oracle 11g/10g, Data Guard, ASM, Solaris 10, SQL Loader, Oracle Message Gateway, IBM MQ Series, VERITAS NetBackup, RMAN, Erwin 7.3, TOAD, 10g Grid control monitoring(10.2.0.5.0), EMC storage

Confidential, Raleigh NC

Sr. Oracle DBA (AVP)

Responsibilities:

• Primary DBA Managing 40 Production, QA & Development databases for OLTP & Data warehouse of 380 GB to 10 TB in 24*7 environment running Oracle 11g/10g on RHEL/SLES Linux and Solaris servers.
• Setup strategies and prepare project plans for new projects, upgrade and backup activities
• Supporting databases for various financial product vendor applications
• Working on feasibility and testing of 11g R2 RAC-One node architecture for Confidential databases
• Designed, Implemented and maintained RAC & DataGuard on both ASM, OCFS & VCS
• Installed 11g RON, RAC and created databases for 11g on RHEL/SLES Linux & Solaris
• Upgraded RAC & SI databases from 9.2.x to10.2.x to 11.1.0.7 and from 32 Bit version to 64 Bit on RHEL & Solaris, also converted databases from 64 Bit to 32 Bit version.
• Upgraded databases across platforms(Solaris to Linux) of 10+ TB to 11202 through downstream capture using staging database
• Installed & configured ASM for SI and RAC databases, Implemented 11g ASM feature of variable AU size.
• Upgraded ASM from 10.1 to 11.1.0.7 and converted single node ASM to cluster ASM
• Migrated databases from Non-ASM to ASM and vice-versa
• Configured databases for Transparent Data Encryption(TDE) with security wallet
• Configured database encryption for backups(RMAN and Data pump) and used encryption wallet and master key for security
• Used data masking for certain sensitive column data while transferring to non-prod databases.
• Co-ordinate with UNIX SAs for configuring Databases in Active-Passive cluster through VCS and DR through BCV & SRDF. Carried out quarterly testing of cluster failover and DR failover through SRDF
• Installation and setup of OMS and 10g Grid control for monitoring of databases. Upgraded Grid management from 10.1.0.3.0 to 10.2.0.5.0, which involves step-wise upgrading repository database from 9.0.1.5 to 10.1 & 11.1
• Setup backup strategies and implemented RMAN, logical backups and also Flashback feature to achieve fault tolerance. Scheduled backup jobs through RMAN, Veritas NetBackup (MML) & Datapump. Scheduled jobs through Control-M and also dbms scheduler
• Extensively worked on RMAN configuration, Block Change Tracking implementation and trouble-shooting
• Restored & recovered crashed production database from two different incarnations data files of a database due to lost file systems by setting “underscore” parameters with Oracle support and exported critical data from dis database
• Configured databases for “Flash Recovery” to have faster fault correction by using flash back database, flash back query and flash back table features.
• Worked on partitioning of tables for data warehouse operations for achieving faster response time. Partitioned tables based on range, list & hash methodology. Used dbms redefinition & exchange partition
• Planning, implementation and reclaiming databases through Disaster recovery by implementing quarterly DR exercises
• Capacity planning for existing and new databases for Database size, CPU and memory
• Sybase ASE Administration
• Server security administration of logins, users, roles, access
• Migrated Sybase ASE 15.x databases to Oracle 11gR2 schemas with halp of Ispirer’s SQLWays
• Sybase ASE server backups and restoration, database backup and copy to Dev/QA servers
• Troubleshoot performance, blocking related issues for optimal performance
• Install and configure Sybase ASE 15.x on UNIX servers
• Used SDLC(Software Development Life Cycle) methodology through Remedy change control system for new code promotion and code bug fixing
• Documented technical processes and set up SOPs

Environment:Oracle 11g/10g/9i, ASM, VCS, OCFS, Sybase ASE 15.x, Solaris 10, RHEL, SLES Linux, BCV, Veritas NetBackup, RMAN, RAC, Oracle Streams,10g Grid control monitoring(10.2.0.5.0), EMC storage, SRDF

Confidential

Sr. Oracle DBA

Responsibilities:

• Managed 35 Production, QA & Development databases for OLTP & Data warehouse of 800+ GB in 24*7 environment running Oracle 11g/10g on RHEL and Windows servers.
• Setup strategies and prepare project plans for new projects, upgrade and backup activities
• Configured databases for Transparent Data Encryption(TDE) and tablespace database encryption with security wallet
• Configured database encryption for backups(RMAN and Data pump) and used encryption wallet and master key for security
• Used data masking for certain sensitive column data while transferring to non-prod databases.
• Designed, Implemented and maintained RAC & DataGuard on both ASM, OCFS & File systems(ext3 & NTFS)
• Installed 11g and created databases for 11g on RHEL & Windows
• Upgraded RAC & SI databases from 10.1.0.5 to 11.1.0.7 and upgraded databases from 32 Bit version to 64 Bit on RHEL & Windows, also converted databases from 64 Bit to 32 Bit version.
• Converted SI database instances to 2-node RAC Instances through manual process and “rconfig”
• Created and maintained single node physical standby databases from primary database which is RAC configured
• Installed & configured ASM for SI and RAC databases, Implemented 11g ASM feature of variable AU size. Configured ASM disks from scratch and used asmtool / asmtoolg for stamping disks for ASM
• Upgraded ASM from 10.1 to 11.1.0.7 and converted single node ASM to cluster ASM
• Migrated databases from Non-ASM to ASM and vice-versa
• Installation and set up of 11g/10g DB Control for standalone management of databases
• Installation and setup of OMS and 10g Grid control for monitoring of databases. Upgraded Grid management from 10.1.0.3.0 to 10.2.0.5.0, which involves step-wise upgrading repository database from 9.0.1.5 to 10.1 & 11.1
• Maintained databases at the latest patch level by applying quarterly CPUs and one-off patches and updated Oracle support with the bugs resulted out of patch application. Applied patches in rolling manner to reduce downtime of cluster databases.
• Installed, configured MML BakBone NetVault server and client software & RMAN plug-in. Implemented backups to run directly to tape through NetVault RMAN plug-in. Upgraded BakBone NetVault from 7.4.5 to 8.2
• Setup backup strategies and implemented RMAN, logical backups and also Flashback feature to achieve fault tolerance. Scheduled backup jobs through RMAN, BakBone NetVault(MML) & Datapump
• Extensively worked on RMAN configuration, implementation and trouble-shooting
• Restored & recovered crashed production database from two different incarnations data files of a database due to lost file systems by setting “underscore” parameters with Oracle support and exported critical data from dis database
• Configured databases for “Flash Recovery” to have faster fault correction by using flash back database, flash back query and flash back table features.
• Cloned and refreshed databases from Production to Development through both logical and physical refreshes (restoration, recovery and control file recreate) methodology
• Worked on 11g feature of “Active duplication” to duplicate databases which eliminates need to have a RMAN backupset
• Built Linux and Windows boxes from scratch for Oracle installation. Extensively worked on physical design of databases and implemented for achieving optimum utilization of OS resources
• Worked with storage team for better implementation of NetApps storage devices for optimum performance of databases
• Implemented 11g secure logon, secure wallet, dump file encryption, tablespace encryption & RMAN backup encryption for added security
• Co-ordinate with application development for logical database design, optimal application design & implementation. Implemented 11g features like, virtual columns, invisible indexes to assist application team for better application design and trouble-shoot issues arising from applications
• Worked on partitioning of tables for data warehouse operations for achieving faster response time. Partitioned tables based on range, list & hash methodology. Used dbms redefinition & exchange partition
• Currently working on Real Application Testing for workload reply for halping optimum application design & implementation
• Worked with CTX preferences, stop lists, word lists to create and maintain domain indexes for enhancing text based search
• Improve database performance through tuning Oracle (AWR, ADDM & Statspack) and server resources like CPU, memory and 11g feature of Automatic Memory Management
• Developed shell/AWK scripts and windows batch files to automate database backups, database monitoring & data loads
• Planning, implementation and reclaiming databases through Disaster recovery by implementing quarterly DR exercises
• Capacity planning for existing and new databases for Database size, CPU and memory
• Datacenter consolidation, move and de-commission databases.
• Interacting with client and end-users for day-day activities and issues
• Documented technical processes and set up SOPs

Environment:Oracle 11g/10g, ASM, OCFS, RHEL 5.3, Windows 2003/2000 Enterprise & Datacenter, BakBone NetVault8.2/7.4.5, RMAN, RAC, DataGuard, 10g Grid control 102050, NetApps storage

Confidential, NJ

Sr. Oracle DBA

Responsibilities:

• Primary DBA for 65 Dev & Production databases for Data ware house & OLTP ranging in size from 120 GB to 6+ TB in 24*7 environment running Oracle 11g/10g/9i/8i/8 on HP and Windows servers.
• Interacting with client and end-users for day-day activities and issues
• Managed a team of 18 Off-shore DBAs as an activity based technical lead for carrying scheduled activities & incidents
• Setup strategies and prepare project plans for new projects, upgrade and backup activities
• Involved in setting up and implementation of SOX and IAPP policies as per FDA guide lines
• Installation and set up of 10g DB Control for standalone management of databases
• Installation and setup of OMS and 10g Grid control for monitoring of databases
• Schedule backup and monitor jobs through Tivoli Workload Scheduler
• Built UNIX and Windows boxes from scratch for Oracle installation
• Installation, patching and upgrade of Production databases of size varying from 350 GB to 6 TB. Upgraded many instances from 8i to 9i then to 10g also directly from 8i to 10g.
• Database security and one-off patching through Opatch utility
• Logical and physical design and implementation of databases
• Implemented & configured one-way upstream streams environment from production to reporting databases.
• Trouble shoot streams environment’s capture, propagation & apply processes.
• Migrated databases from 8i to 9i and 9i to 10g also directly from 8i to 10g through Logical backup restoration (Exp/Imp) and also by using migration utility.
• Lead DBA for Datacenter consolidation project to move and de-commission databases for optimizing CPU, Disk space and Memory usage
• Consolidated Confidential & Confidential ‘s 3 Data centers (Cincinnati OH, Raritan NJ & Albuquerque NM) into one Data center (Raritan NJ) which has enhanced optimum usage of Disk space, CPU and Memory resources.
• Analyzed various tools and methods for best use in Data center consolidation. Used IBM’s TDMF for replication at file system level(with alternatively presenting same SAN arrays for cut-over and cut-in processes) and RMAN Duplication of databases at database level
• Consolidated 100+ HP-UX, Windows servers & 250+ databases during the DCC project
• Troubleshoot of issues arising from databases, applications and networks
• Designed, Implemented and maintained RAC, MC ServiceGuard and Oracle DataGuard on ASM, OCFS and file systems
• Created and maintained physical standby databases with delay setting of 8 hrs to protect standby database from errors.
• Improve database performance through tuning Oracle (AWR, ADDM & Statspack) and server resources like CPU and memory
• Developed shell/AWK scripts to automate database backups for user initiated, BCVs and RMAN directly to tape through Veritas NetBackup interface. Extensively worked on RMAN implementation and trouble-shooting
• Planning, implementation and reclaiming databases through Disaster recovery
• Cloned and refreshed databases from Production to Development through both logical and physical refreshes (restoration, recovery and control file recreate) methodology
• Capacity planning for existing and new databases for size, CPU and memory
• Supported as a secondary DBA for MS SQL Server 2005 through installation, upgrade, login and user management, performance tuning, data copy, backup, restore & recovery
• Supported MySQL server databases for Installation, backup, restoration and trouble shooting
• Mentored junior DBAs in technical and procedural knowledge. Helped application developers in writing and tuning SQL statements. Scripted PL/SQL blocks per need of DBA functionality
• Used Remedy for change management, incident management and SDLC
• Documented technical processes and set up SOPs

Environment:Oracle 11g/10g/9i/8i/8, ASM, RAC, Oracle Streams, MC Service Guard & Data Guard, HP-UX B 11.10/11.11/11.23, Windows 2003/2000, Veritas NetBackup, HP-Omni backup, BCVs, RMAN, MySQL 4.5, MS SQL Server 2005, TWS, 10g Grid control monitoring

Confidential

Sr. Oracle DBA

Responsibilities:

• Administered 32 Production and 120 Dev and Test databases for Data warehouse & OLTP ranging in size from 350 GB to 3.2 TB in 24*7 environment running Oracle 8, 8i, 9i, 10g on HP and Linux servers.
• Built UNIX and Windows boxes from scratch for Oracle installation
• Installation, patching and upgrade of Production databases of size varying from 350 GB to 3.2 TB. Upgrade many instances from 8i to 9i then to 10g.
• Database security and one-off patching through Opatch utility
• Logical and physical design and implementation of databases
• Migrated databases from 8i to 9i through EXP/IMP and also by using migration utility.
• Troubleshoot issues arising from databases and networks
• Designed, Implemented and maintained RAC, MC ServiceGuard and Oracle DataGuard
• Created and maintained physical standby databases with delay setting of 8 hrs to protect standby database from errors.
• Improve database performance through tuning Oracle, and server resources like CPU and memory
• Designed and implemented database backup strategy for Development and Production environments
• Developed shell/awk scripts to automate database backups for user initiated and RMAN directly to tape through Veritas NetBackup interface
• Planning, implementation and reclaiming databases through Disaster recovery
• Cloned and refreshed databases from Development to Production through both logical (Exp/Imp) and physical refreshes (restoration, recovery and control file recreate) methodology
• Capacity planning for existing and new databases for size, CPU and memory
• Datacenter consolidation, move and de-commission databases.
• Supported MS SQL server databases for Installation, backup, restoration and trouble shooting
• Acted as a mentor to junior DBAs. Helped application developers in writing and tuning SQL statements.
• Scripted PL/SQL blocks as per need of functionality
• Managed version control through Serena (Change Management tool) and Mercury ITG (Configuration tool)
• Monitored databases through BigBrother and shell scripts, which will page on call DBA.
• Used Remedy for change management
• Documented technical processes and set up SOPs

Environment:Oracle 10g/9i/8i/8, RAC, MC ServiceGuard, HP-UX B.11.11, Linux 2.4.9, AIX 5.1, RMAN, SQL BackTrack, Veritas NetBackup, PL/SQL, MS SQL Server

Confidential

Oracle DBA

Responsibilities:

• Successfully administered 22 Production, 66 Pre-Prod & ITL (Integrated Testing Lab) and 2 SDM servers in 24*7 environment
• Prepared UNIX boxes from scratch for installing Oracle OPS and RAC
• Installed and administered databases in OPS/RAC and HP-ServiceGuard architecture
• Logical and physical design of databases, Patching and upgrading of databases
• Database security and one-off patching through Opatch utility
• Cloned and refreshed databases from Prod to Dev through both logical (exp/imp) and physical refresh (restoration, recovery and control file recreate) methodology
• Developed backup strategies for databases and implemented RMAN backups to disk and also directly to tape through Tivoli Storage Manager. Implemented BCV backups for large databases.
• Created shell scripts for automating database backups and daily monitoring
• Reclaiming databases through disaster recovery
• Worked on requests for data loads of ITL (Integrated testing lab), Pre-Production and Production databases
• Modifying database structural changes and performance tuning of databases
• Tuning of Oracle memory, UNIX server CPU and memory for better performance
• Worked with Oracle Security for user and password management
• Migrated OPS databases from 8i to 9i RAC through Exp/Imp and also by using migration utility
• Implementing Change Management (Operation Service Request) through TeamTrack tool
• Monitored databases through Mercury SiteScope for 24*7 availability
• Issue resolution and troubleshooting through trouble ticketing system of TeamTrack tool
• Technical process documentation and setting SOP
• Partly involved in WebLogic administration
• During initial stages of dis project worked as a Tech Support team member involving in outage resolution, and application & database monitoring by using tools like SiteScope and TeamTrack

Environment: Oracle 8i/9i, OPS/RAC, RMAN, BCV, Solaris 8, HP-UX B.11.11, RHEL 2.4.9, Weblogic, Tivoli

Confidential, Newark, CA

Sr. Backend Developer Oracle/Java/Sybase

Responsibilities:

• Carried out requirement analysis and system study. Member of BPR team for setting up existing business flow to system and project design.
• Implemented MVC architecture of J2EE’s model-2 by using Java Beans, JSPs and Servlets and developed components for database connections and display logic through JSPs.
• Designed and scripted PL/SQL functions and procedures for backend database (Sybase)
• Used Servlet’s “RequestDispatcher” functionality for client to server data communication.

Environment:Java Servlets, Java Server Pages (JSP), Java Beans, Java Script, Sybase 11.0, Solaris 7.0HTML, CSS, JDeveloper3.1, IPlanet (SE 6.0), SilkTest 5.0.3

Confidential

Backend Developer/DBA Oracle/Java

Responsibilities:

• Developed and implemented the project in WebLogic 5.1.0
• Installed and configured Oracle.
• Logical database design and data modeling. Completed physical design as per OS file system architecture.
• Develop SQL and PL/SQL scripts. Developed Oracle procedures, functions and triggers.
• Query optimization, Tune offending queries, table re-organization and logical backup of frequently updated tables
• Used XML for updating data at client side in preparing production plans and SQLJ for retrieving the data from the Oracle 8i and displayed in JSP (Presentation layer)
• Implemented MVC architecture of J2EE’s model-2 by using Java Beans, JSPs and Servlets.
• Developed components for database connections and display logic through JSPs. Used Servlet’s “RequestDispatcher” functionality for client to server data communication.
• Java script is used for client side data validation. Oracle Type-4 Database driver is used for connectivity with backend database (Oracle).
• Involved in Unit, Integrity and system level testing.

Environment: Java Servlets, Java Server Pages (JSP), Java Beans, Java Script, XML, Oracle 8i, Oracle 8i LiteSolaris 7.0, HTML, CSS, JDeveloper3.1, MS Front Page, WebLogic 5.1.0, Visual Source Safe

Confidential

Backend Developer Oracle/Java

Responsibilities:

• Carried out requirement analysis and system study.
• Installed and configured Oracle.
• Logical design of the database. Completed physical design as per the OS file system architecture.
• Developed SQL and PL/SQL scripts.
• Developed Oracle procedures, functions and triggers.
• Query optimization, Tuning queries, table re-organization and logical backup of frequently updated tables
• Servlets are used for server side programming and for presentation layer and Java script is used for client side data validation. Implemented HttpSession for session tracking.
• Implemented JDBC for database connectivity with backend database (Oracle). Involved in initial Unit, Integrity and system level testing.

Environment:Java Servlets, JSP, Java Beans, Java Script, Oracle 8, WebLogic 4.5.1, HTML, CSS, Windows

Confidential

Backend Developer Oracle/Java

Responsibilities:

• Installed and configured Oracle. Involved in logical design of the database. Completed physical design as per the OS file system architecture.
• Developed SQL, PL/SQL scripting. Developed Oracle procedures, functions and triggers.
• Query optimization, fine tuning of offending queries, table re-organization and logical backup of frequently updated tables
• Created user interfaces like Inbox, Send mail, Java Swing components JTable, checkbox, Message dialogue box etc. Created client socket and server socket for Java network communication using java.net package. Used multithreads at server end to entertain multiple clients.
• Java.io package various stream are used for communicating with the server for .txt, .gif. Implemented RMI for transferring Objects using Object Output Stream.
• Involved in initial Unit, Integrity and system level testing.

Environment:Java Swing, Oracle 8, Networking (TCP/IP), RMI, Windows NT 4.0

onfidential

Oracle Application Development & Support DBA

Responsibilities:

• Data modeling and logical design of database based on requirements
• Created tables and scripted PL/SQL blocks for fulfilling functionalities
• Prepared UNIX boxes from scratch for installing Oracle for OPS
• Installed and administered databases on windows platform
• Responsible in logical and physical design of databases
• Patching and upgrading of databases. Security and one-off patching through Owat utility
• Cloned and refreshed databases from Prod to Dev through both logical (Exp/Imp) and physical refresh (restoration, recovery and control file recreate) methodology
• Successfully administered Production, Pre-Prod, UAT and development databases in 24*7 environment
• Involved in reclaiming databases through disaster recovery
• Modifying database, make structural changes and performance tuning of databases
• Tune Oracle memory and query tuning
• Worked with Oracle Security for user and password management
• Upgraded databases from 7.3 to 8.0
• Involved in technical process documentation and setting up of SOPs

Environment: Oracle 7.3/8.0, Developer/2000 and Windows NT