SUMMARY:

• Confidential offers 14+ years of intensive work experience in the area of Production Oracle and MySQL Database Administration, Tuning, Backup & Recovery, Commercial application design, development & Testing using software like Oracle SQL, PL/SQL, D2K, REPORTS with basic Windows NT, 2000 administration with hardware troubleshooting.
• Very strong in Database Administration, data management, excellent understanding of database
• Architecture, Data Dictionary. Strong experience in managing and maintaining OLTP and
• Data warehousing databases. Strong experience in tuning, managing and supporting both Development and Production Database of very Large Size

TECHNICAL SKILLS:

Servers: IBM RS/6000, HP NT Server, Sun SPARC E20, E250, E4500,880, E6800, V3800, Hitachi SAN storage, Dec Alpha UNIX, server (4200, 4300), Power Edge 2450, Dell PowerVault storage device, IBM Filers.

O/S: UNIX (Sco, Solaris 5.x, Dec Alpha, Red Hat Enterprise and Advance serverCentos, Debian, Windows NT 4 & 2000 (Server & Advanced Server), Window 95/98.

Languages: SQL* PLUS 8.1.7, PL/SQL, UNIX Shell Script.

RDBMS: Oracle 7.3/8.X/8.1.X./9i, 10G RAC,11g Data Guard SQL SERVER (Ver 7, 2K)MySQL Server 5.x

Tools: Enterprise Manager, Sqlloader, Server Manager, Explain plan,Tkprof, Utlbstat/Utlestat, Stats pack, awr (Automatic workload repository)Export/Import, PL/SQL, RMAN, Oradim,Orapwd, Developer 2000(forms 5.0, Reports 2.5), Oracle ExpressServer installation (New instance creation, session management, Oracle 9iApplication server installation (Oracle 9i database cache configuration,Forms Server, Reports Server). IWATCH, SPOT LIGHT, GoldenGate.

Additional Skills: Basic Windows NT, 2000 System and Network Administration (Installation,Configuration, Backup, Recovery, System troubleshooting)

PROFESSIONAL EXPERIENCE:

Confidential, CA, Foster City

MySQL DBA

Responsibilities:

• Supporting Mysql databases on both Lunix and Solaris.
• Performance Tuning of database and sql statements, schema objects there was increasing TPS(transaction per second)
• Database upgrades.
• Monitoring the health of production database.
• Worked on percona tool for online schema changes.
• Monitoring backups to ensure backups are taken regularly and fixing any backup issues.
• Setting up High Availability features like Replication.(Master/slave, master/master)
• Doing database and storage capacity planning and informing the same to the Management to take care of future growth of the database.
• Interacting with Engineers to write efficient sql statements. Schema design, production deployment
• Writing shell scripts to automate routine tasks.
• Providing day - to-day database support to all the departments of the organization.
• Managing production/pre-production databases. Database deployments
• Closely working with sys admins and application admins to make sure, there is no issue with entire technology stack.

Environment: RHEL 6, Storage Array (SAN), MySQL 5.x, Solaris 5.x

Confidential

Sr. Oracle & MySQL DBA

Responsibilities:

• Installation and configuration of oracle RAC with ASM on production and pre-prod database servers for mobile money service used by Nokia Money Service, YES BANK, Union Bank of India, SOCIETE GENERALE (Senegal), Warid Paisa (Uganda), Yucash (Kenya), with more than a Million customers for each Geography in a span of 6 months.
• Configuration and management of Data Guard for High Availability. Done switchover from Primary TO DR. Performed DR drill as part of the db audit required by the BANK’s.
• Performed Datacenter Migration without any down time.
• Migrating database from NON-ASM to AMS.
• Setting up TAF for high availability of db sessions.
• Troubleshooting RAC and ASM related issues.
• Setting up NON-RAC database on ASM.
• Increased TPS (Transactions per second), by tuning sql and schema objects, thus enabling more revenue for the organization.
• Analyzing database growth pattern and doing storage capacity planning for future requirement andInforming the same to the top management.
• Interacted with customers across geographies and helping them understand better manageability of database and understanding their requirement and providing reports.
• Using SQL ADVISOR to improve the performance of the sql statements.
• Interacting with Engg team to help them to write efficient sql’s.
• Adding more disks to ASM disk groups.
• Setting up replication from OLTP to DW database and fixing any replication related issues.
• Database migration from ASM to NON-ASM and vice-versa.
• Improving sql performance, data manageability with Table/Index partitions and IOT tables.
• Upgrading oracle 10.2.4.0 to 11g (11.2.0.1.0 ).
• Database Migration from Solaris to RHEL using transportable tablespace, using data pump (expdb, impdb).
• Setting up monitoring scripts for monitoring health of all RAC database, table space usage, Session details, disk usage, backup monitoring, Data Guard health.
• Involving in logical and Physical design of database.
• Writing script to purge/archive data, to improve the performance of sql’s.
• Writing automated scripts to rebuild indexes at regular intervals.
• Tuned sql’s to improve performance of the db and site availability. Improved site availability from 50% to 95%.
• Setting up QA DB and PRE-PROD DB in RAC environment and ensuring its always in sync with production.
• Working with WebLogic administrator to fix database related issues.
• Mining WebLogic related logs to fix db related issues.
• Written automated backup scripts using RMAN to take daily hot backup.
• Tuned database objects to improve performance of the db.
• Interacting with QA Team to fix all db related issues.
• Apply db patches, upgrading db versions using OPATCH.
• Setting up CLONE, DUPLICATE database for PRE-PROD database’s and DR DB.
• Using awr report to monitor the health of the db and tuning sql’s doing high buffer and physical reads.
• Installing and configuring 11i R2 EBS, migrating 11iR2 to different datacenter will very less downtime. Wrote shell scripts to monitor availability of EBS service and alerting the DBA’s.
• Using OEM to monitor the HEALTH of the DB and monitoring Data Guard.
• Setting up multiple database instances on same RAC host with different time zone.
• Installation and configuration of MySQL on production, pre-prod and Dev infrastructure.
• Performance tuning, Backup using Enterprise Backup (ibbackup, mysqlbackup) and also backup using snapshot.
• Testing backups periodically.
• Setting up high availability, like replication, MySQL Cluster, MySQL cluster replication.
• Migrating standalone MySQL instance to MySQL Cluster setup.
• Making sure all read happens on the slave setup.
• Upgrading MySQL database from 5.0 to 5.1
• Setting up master-master replication.
• Interacting with Engineers for day-to-day db activities, new feature releases and bug fixes to pre-prod and production setup.
• Enabling Engineers to write efficient sql statements.
• Wrote Shell scripts for automation of application related activities, database health monitoring and other db related activities, monitoring health of db servers.
• Setting up multiple MySQL instance on the same host for pre-prod(QA) and Dev.

Environment: Oracle 11gR2, 10GR2 RAC, Data Guard, RHEL 4 and 5, EMC Storage Array (SAN), MySQL 5.x

Confidential

Sr. Oracle & MySQL DBA

Responsibilities:

• Installation and configuration of oracle software on Production database servers.
• Configured and Managed STANDBY databases for production database’s for High availabilityAnd keeping them in SYNC with production databases using scripts.Managing production database of more than 14 TB in size.
• Setting up 8 hrs lag standby database, to adhere to SLA with EBAY.
• Setting up CLONE database.
• Physical and Logical database design.
• Monitoring and tuning high OLTP 24*7 multiple Production Instances and Standby databases.
• Monitored, tuned Production databases running in cluster (Hardware Cluster) for high availability.
• Automated scripts to Generate report on high resource consuming sql. Report based on high Physical reads, Logical buffer reads, high number of sql executions using stats pack andAWR (automatic workload repository).
• Analyzing database growth pattern and doing storage capacity planning for future requirement andInforming the same to the top management.
• Analyzing DML activities on tables and setting storage parameters accordingly to improve performance.
• Tuned database based on data got from Stats pack and AWR report and reducing the database load from 95% to 50%.
• Automated Archiving of large database objects using scripts for Better performance of the SQL’s.
• Involved in Data Center migration during company consolidation by keeping the Services up andRunning during the move with minimum downtime.
• Improved Performance of the Database by creating IOT where required.
• Migrated 8.1.6 Database’s to 8.1.7.
• Written Shell scripts to monitor health of the DB’s and major database events.
• Creating Production and Development database with different Character Set (GERMAN) to cater todifferent geological regions.
• Monitoring, tuning and maintaining Reporting Database’s.
• Maintaining Development and QA database environment and keeping Development instances in sync with QA.
• Interacting and helping Developers in writing Efficient SQL statements for better performance of the Production Database and helping them in Logical database design.
• Created Read only schema’s to secure the Production Databases.
• Used SQL*LOADER for loading data from flat files into the database.
• Regular Rebuilding of Indexes on tables with high DML activity for Better performance of the sql’s.
• Configured INTERMEDIA Text for improving the performance of Pattern matching searches.
• Created CONTEXT index for searches involving PATTERN matching thus increased the performance of the database.
• Configured SPOTLIGHT for monitoring Different Production and Reporting Database’s.
• Tuned database backup when backup-using RMAN was running slow.
• Using RMAN to automate day-to-day backup of Production databases.
• Monitoring Backups and ensuring daily backups have run successfully.
• Testing backups using RMAN recovery to ensure backups are intact without any corruption.
• Recovered Database when there was BLOCK CORRUPTION.
• Authenticating users using Active Directory
• Installed and Configured RAC and DATA GUARD on 9i/10g database.
• Installation and configuring MySQL database on production servers using IBM Filers as storage.
• Tuned Mysql parameters to improve database performance.
• Configured MySQL replication to provide High Availability for all applications running on MySQL.
• Ensuring all reporting activity is done on Slave database to avoid load on primary database.
• Taking daily backups on slave using snapshots on IBM Filers.
• Setting up MySQL development and QA database. Ensuring QA and Development database objects are always in sync with production using automated scripts.
• Daily report generation of high resource consuming sql’s logged in slow query log using scripts.Tuned sql’s got from slowquery log report.
• Used mysqllogdump to restore deleted data.
• Maintaining sql server 2K for our customer support application. Enabling multi cpu utilization for better performance. Ensuring backup is happening at regular basis and providing report for CS VP for analyzing CS effectiveness

Environment: Oracle 8.1.6, 8.1.7, 8.1.7.4,9i,10G RAC, Data Guard,MySQL 5.0.4 Solaris 2.8, Sun Ultra, Sun sparc 250, 4500, 6800, Enterprise Manager, SpotLight, Hitachi Storage Array (SAN), Debi an

Confidential

SQL Server DBA

Responsibilities:

• Installed SQL Server client software on client machines running windows 2000 Professional.Setting up the Fail over Cluster Database (Instance Creation, Configuration, file allocation).
• Memory tuning.
• Capacity Planning: Setting storage parameters to take care of future growth of database.
• Moving objects between schemas.
• Exporting and Importing data from one database to another Database (DATA MANAGEMENT)
• Using BCP & DTS
• Documenting daily activities and reporting to the management for any resource need.
• Automating Backups.
• Trouble shooting client connectivity
• Provide 24*7 database support.
• Interacting with developers and helping them in sql tuning and database object design.
• Installed Java, Tomcat
• Configuring IIS to interact with tomcat
• Using SQL PROBE for monitoring the database for growth, alert notification etc.
• Trouble shooting tomcat issues.
• System and Network administration (OS installation, Configuring the client Machines, Troubleshooting system and network problems, Daily backups using CD Writer
• Authenticating users using Active Directory for single sign-on

Confidential, New Jersey

Oracle DBA

Responsibilities:

• Logical and Physical database DesignOracle server installation on NT, Linux v 7.1 and configured the client/server
• Installed oracle client software on windows 2000 workstations.
• Documented all the database events to be monitored.
• Documented daily activities performed and reporting to the management
• Installation of Oracle 9i Application server on NT.
• Capacity Planning: Designing tables, setting storage parameter to take care of future growth of the database, Memory Sizing
• Created locally managed tablespace to avoid database fragmentation.
• Provide 24*7 database support.
• Wrote SQL scripts for monitoring daily database activities.
• Configuring and using IWATCH for remote monitoring of the database and setting to mail notification in the event of any alert like table reaching max extents, archive destination being full, Disk running out of space act.
• Installing Java, Tomcat and Apache.
• Configuring Apache and Tomcat for interaction with .jsp pages
• Interacting with developers and helping them in application development.
• System and Network administration (OS installation, Configuring the client Machines, Troubleshooting system and network problems, Daily backups using CD Writer)

Confidential

Oracle DBA (Data Warehouse)

Responsibilities:

• Involved in Logical & Physical database Design.Oracle installation on Digital Unix and configured the client/server.
• Wrote shell script to validate Data coming from Progress RDBMS.
• Memory tuning (Monitoring Memory rations and keeping them within the required limits).
• Capacity Planning: Setting storage parameters to take care of future growth of database.
• Using ETT methodology for extracting, transforming and transporting data into the data warehouse database.
• Exporting and Importing data from one database to another Database (DATA MANAGEMENT)
• Transferring and managing data from progress RDBMS into oracle RDBMS using pl/sql procedures and sql loader.
• Rollback segment sizing and tuning and trouble shooting when exceeding optimal size.
• Documenting daily activates and reporting the management for any resource need.
• Data uploading using Oracle Utility SQL*LOADER.
• Wrote shell script to implement Backup strategies using CORNTAB.
• (Sunday full database export, Weekdays incremental export) and monthly cold backup.
• Implemented security using Product user profile
• Sql Statements tuning
• Application tuning.

Environment: Dec Alpha UNIX, Windows 95, Oracle 7.3, SQL, PL/SQL, Sql*Loader.

Confidential

Oracle DBA

Responsibilities:

• Increasing Database Performance by Tuning and Optimization using Hints and Optimizer.Rebuilding the indexes of tables undergoing high DML activities
• SQL Tuning using Explain plan and optimization of the Database resources by querying
• Dynamic performance views.
• Uploading Data using SQL Loader.
• Wrote stored procedures & Triggers for application developers.
• Generating database reports using ESTAT/BSTAT and then tuning and optimizing weak areas of the database.
• Defragmentation of the Database using Export & Import Utilities.
• Wrote ad hoc SQL queries for report generation, client and end user requirement.
• Also used Export and Import Utility for extracting data from the remote database and importing into the local database.
• Tuning of application, SQL, Memory usage, transactions, and physical storage.
• Documenting daily activates and reporting the management for any resource need.
• Security implementation: at user level using Product user profile.
• Setup backup & Recovery Strategies using shell script (CORNTAB). Performed both hot backup and cold backup.
• Exporting and managing data from UNIX OS and importing into Windows NT for testing purpose.

Environment:, IBM AIX, Windows NT, Oracle 8.1.5

Confidential

Hardware sales and service Engineer

Responsibilities:

• Making cold calls for sales of computers.
• Installing and configuring computers at customer places. TroubleshootingAll computer hardware related issues.
• Installing and configuring Windows, MS-Dos.