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.
• Created Oracle7.x 8.x, 9.x, 10.x , 11.x 12.x Database instances.
• Migrated from 7.x to 8 to 8i. Then from 8i to 9i and later to 10g/11g/12c.
• Built Servers from scratch for Oracle installations.
• Supported ERP/CRM Applications Oracle Financials/ HR
• 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 Server OAS 10.1.3, WebLogic 5.1.0, IPlanet 6.0

EXPERIENCE:

Confidential

Senior DBA Oracle, Sybase, MySQL MS SQL Server Backup Admin

Daily Racing Form is a media and entertainment company dealing with data management of current and past performances of race horses as a statistical service for handicappers of horse racing.

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
• Oracle Database EE:
• 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

Sybase ASE:

• 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 because 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.

MySQL:

• 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

MS SQL Server:

• 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

Sr. Oracle DBA

Dept. of Commerce State of NC supports all activities of NC State's finance commerce functionalities including Employment Security Commission.

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

Sr. Oracle DBA AVP

The Credit Suisse is a provider of wide-ranging financial services. It offers investment products, private banking and financial advisory services for private and corporate clients

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 Credit Suisse 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 this 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 help 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

Confidential is a leading library services provider for most of universities' libraries in USA and also back end supplier for majority of book publishers and sellers which includes Amazon.com

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 this 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 helping 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

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 Johnson Johnson'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 this 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 Storage Manager.

Confidential

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.0,
• HTML, 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 Lite,
• Solaris 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
• NT.

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

Confidential

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 Owhat 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