SUMMARY

• Over SEVEN years of IT experience as Oracle Database Administrator and MySQL Database administrator with expertise in Installation, Configuration, Implementation, Customization, performance tuning, backup & recovery of Oracle Servers (11g, 10g, 9i, 8i, 8.0 & 7.x), MySQL server (5.5, 5.1, 5.0) in Production, Test and development Environments.
• 24*7 production database support with Support to System Admins, developers & end - users.
• Extensive knowledge on database administration for Oracle7i, 8i, 9i, 10g, 11g and MySQL 5.5, 5.1, 5.0 with experience within very large scale database environment and mission critical large OLTP and OLAP systems.
• Extensive experience in Data guard, Grid control and Replication.
• Having good experience in MySQL replication and master, slave configuration.
• Database backups and recovery using RMAN, Import/Export, and MySQL dump, Hot/Cold Backups, Data Pump tools.
• Maintaining Very Large Database (VLDB) OLTP in 24x7 Production environments.
• Expertise in Oracle Enterprise Manager (OEM), Grid Control and Dataguard broker.
• Involved in Every Phase of SDLC (DEV, TEST, UAT and PRD).
• Good knowledge in FLASHBACK recovery features.
• Strong experience in implementingData warehousingsolutionsinvolvingDimension modelingandStar schema implementation.
• Setting the MySQL tunning parameters for better database performance.
• Setting up MySQL Slaves, backup and restoring databases, optimizing queries.
• Audited and tuned proSduction MySQL servers.
• Implemented system monitoring with Nagios and performance measurement with Cacti.
• Fixed bugs and added features to various MySQL server and client components such as mysqldump backup utility.
• Daily check up of slow query log and based on that tune the query and improve the performance of the database.
• Created dimensional model using Ralph Kimball methodology.
• Implemented 10gR2 and 11gR2 RAC (Clustering) on Linux.
• Expertise in supporting client server GUI software and Operating system.
• Vast experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by using tools/utilities like ESTAT/BSTAT, Statspack, Tkprof, Explain plan, Analyze, ASH, AWR and ADDM.
• Performance tuning and diagnosing DBMS and individual database.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS).
• Experience in a variety of hardware and software platforms including; UNIX/Linux MS-Windows 2000, 2003, NT Server.
• Experience in Auditing using Oracle packages.
• Guided ETL developers to develop the ETL processing.
• Strong knowledge on Database modelling using Erwin.
• Take care of the Database design and implementation
• A good knowledge of the physical database design and Logical database design
• Setup, configured and implemented Standby Database and managed Recovery as solutions for Disaster Recovery on Production Databases.
• Extensive knowledge and experience on Data Warehouse using ETL.
• Working on Oracle 11g environment builds.
• Experience in SQL*Loader, loading data from text files.
• Write and modify UNIX shell scripts to manage Oracle environment.
• Extensive knowledge of Oracle Architecture, SGA, PGA, Binary structure, Listener TNSNames, SQLNet, V$ and DBA views.
• Extensive knowledge on database backup/recovery strategy (RMAN), Import/Export & Data dump), standby databases Oracle configuration management, Dataguard, database cloning, refresh and patch management.

TECHNICAL SKILLS:

Operating Systems: Red Hat Linux RHEL 2.1, 3.x, 4.x, Unix, AIX 6.1, Solaris 10, 9, 8 HP-UX11i, Intel Machines with OS as Windows NT/00/03/08 Server and Windows 95/98/NT/2000/XP.

RDBMS: Oracle 11g R2/10g/9i/8.x/7.x, SAP, Hyperion Essbase, SQL Server.

Languages: SQL, PL/SQL, C#, C, C++, XML, UNIX Shell Scripting.

Software / Applications/ Tools: ORACLE 7.x/8.x/9i/10g/11g,OAS 11g/10g Recovery Manager (RMAN), STATSPACK, ERWIN, MS VISIO, Clusters, VERITAS net Backup, Confio Ignite for Oracle performanceCZX monitor, SQL Loader, Golden Gate, PeopleSoft, Informatica, Data Stage, Cognos, TOAD 7.6/7.5, PL/SQL DEVELOPER V6.0, SQL DEVELOPER 1.2,Oracle Enterprise Manager, Cacti.

Web Tools: HTML, XML, PHP

PROFESSIONAL EXPERIENCE:

Confidential, MA

Oracle and MySQL Database Administrator

Responsibilities:

• Working on REMEDY tickets Supporting 24*7 remote supports and on call for Production database and supporting developers & end-users.
• Created and managed database objects such as tables, indexes, partition tables and views.
• Created and managed users, roles, privileges, profiles, schemas.
• Performing day-to-day database administration tasks like Tablespace usage, Monitoring alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Worked on Automatic Storage Management (ASM) for managing Data Storage.
• Co-ordinate with UNIX Administrators for space management on various servers and help in Oracle installation, upgrading according to the standards & Quality assurance.
• Experience ensuring the high availability and integrity of databases.
• Setting the MySQL tuning parameters for better database performance.
• Setting up MySQL Slaves, backup and restoring databases, optimizing queries.
• Audited and tuned production MySQL servers.
• Having good experience in MySQL replication and master, slave configuration.
• Supported in Oracle 9i OLTP/OLAP Over TB 24*7 Production Environment.
• Security monitoring Auditing using Oracle packages (SA, FGA).
• Encrypting the Sensitive (Critical) Data as per the Firm Standards.
• Supporting the Middleware team for setting up the Web-logic (Data source) server to Oracle DB connections.
• Manage data architects, data administrators and client requests.
• Write scripts for creation of users, creation and assignment of roles, analyze space requirements and maintain Tablespace and other database objects and also did the patch management for Oracle upgrade.
• Worked on import/export, export data pump/import data pump and SQL- loader.
• Creating and rebuilding indexes and optimizing the code to improve the performance.
• Have done database backup and recovery using (Cold backup/ Hot backup/ Logical).
• Setup backup and recovery procedures using RMAN.
• Upgrade and Migration of Database from 10g to 11g.
• Set-up and configured two nodes RAC (11g) cluster on Linux.
• Implemented Oracle Dataguard for maintained Oracle disaster recovery.
• SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, AWR, Stats pack, Explain Plans and monitor the database performance on daily basis. Having stored outlines before and after Database tuning to stabilize and optimize the database by changing the parameters.
• Performed database and memory tuning using tools like Statspack, Tkprof, Explain Plan, Optimizer and SQL tuning advisor.
• Consulted with client management and staff to identifythe objective, business needs, and current operational procedures for creating thelogicaland physicaldata model.
• Implementing databasestandards and processesbyDesigningeffective data model.
• DevelopedLogical data model usingER diagramsin ERWIN.
• Designed and implemented aphysical data modelin ERWINto handle marketing strategies and to satisfy reporting needs.
• Set-up & Troubleshooting of Bi-directional Streams to replicate the data from Source DB to Target DB for Different applications.
• Have worked as Data modeler building complex logical data models using sophisticated modeling techniques and tools like Erwin.
• Responsible for Data Modeling and converting Domain model to Data model- logical and physical database design, implementation, transforming logical data models into physical databases and defining strategies for database implementation, high performance, failover and Disaster Recovery.
• Analysis and management of Oracle problems/defects using SRs and/or Metalink with Oracle and Follow Up with the Issues rose with Oracle Metalink support.
• Security User Management, Privileges, Roles, Profiling, OS Authentication.
• Used Triggers for database activities, like delete, update triggers.
• Trouble shooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.

Environment: Red Hat Linux, Sun Solaris 9.0, Rhel 5.2,Informatica, Data stage, SAP, Pl/Sql Developer V6, Toad, Erwin 4.1, AIX 6.1, ASM, AIX 6.1, HP-UX11i, Peoplesoft, DATA GUARD, Oracle 11g R2/10g/9i RAC, Golden Gate, Oracle 11g R2, Oracle Streams, Auto-Sys, SDLC, PLAN VIEW, IBM LOTUS NOTES, SQL*Plus, OEM, Grid Control

Confidential, Philadelphia, PA

Oracle and MySQL Database Administrator

Responsibilities:

• Involved in administration of Oracle instances.
• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases.
• Involved in the process of tuning and refining queries of various applications.
• Involved in team management, team building exercises for the Oracle team.
• Installed Oracle 9i Data guard.
• Wrote several shell scripts for checking Oracle errors in alert file and database backup log files.
• Cloning of application from production environment to test environment and application of patches.
• Setting the MySQL tuning parameters for better database performance.
• Setting up MySQL Slaves, backup and restoring databases, optimizing queries.
• Audited and tuned production MySQL servers.
• Having good experience in MySQL replication and master, slave configuration.
• Check up of slow query log and based on that tune the query and improve the performance of the database.
• Developed startup/shutdown guides, trouble shooting documents, root cause analysis documents.
• Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.
• Creating table spaces, sizing the system table space, allocating default table spaces for users.
• Creating tables and indexes, sizing their extent, partitioning and so on.
• Creating users with restricted access, with default and temporary table spaces.
• Creating roles and granting to users based on their group requirements.
• Creating profiles and attaching them with users.
• Involved in installing, implementing 32 bit and 64 bit 9i/10g RAC on Linux servers with ASM storage manager.
• Performing hot and cold backups. Restoration and recovery from backup.
• Conducting sizing and capacity planning for Oracle databases.
• Developed database system build sheets, code review check lists, code promotion process documents, outage reporting documents.
• Sizing the SGA, dB buffers, shared SQL area, log buffer based on the requirements.
• SQL issues and Tuning Considerations for Different Applications.
• Monitoring the table growth, database growth, current users and system resource usage and so on.
• Experience in SQL*Loader, loading data from text files.
• Knowledge in writing shell scripts for automating backups and restoration.
• Worked on Data modeling tool Erwin.
• Responsible for setting and managing User Management, Space Management Granting required privileges to users.

Environment: Oracle 10g/9i, Sun Solaris 10, 9, Red Hat Linux, Informatica, Data stage, HP-UX, Oracle Enterprise Manager, SQL, PL/SQL, TOAD, RMAN, TKPROF, STATSPACK, SQL* Loader, Windows NT/2000

Confidential, Philadelphia, PA

Oracle and MySQL Database Administrator

Responsibilities:

• Worked on different environments like production test, development databases.
• Involved in RMAN backup/recovery, performance tuning.
• Worked on OLTP and OLAP database systems.
• Installation and creation of Oracle 9i databases on Production and Test Solaris servers. Responsible for upgrade & migrating databases from 9i to 10g, applying patches.
• Experience in handling GUI software and OS.
• Database Restore using RMAN, Cold Backup and Export.
• Involved in Oracle E-business suite Profit logic price application.
• Setup, configured and managed Oracle 10g RAC database for high availability.
• Setup Dataguard for reporting and providing the test DB.
• Setting the MySQL tunning parameters for better database performance.
• Setting up MySQL Slaves, backup and restoring databases, optimizing queries.
• Audited and tuned production MySQL servers.
• Having good experience in MySQL replication and master, slave configuration.
• Implemented system monitoring with Nagios and performance measurement with Cacti.
• Fixed bugs and added features to various MySQL server and client components such as MySQL dump backup utility.
• Check up of slow query log and based on that tune the query and improve the performance of the database.
• Involved in Design and implementation of Oracle 10g Dataguard both physical/logical standby databases.
• Reviewing of database design document and creating ER diagrams, providing conceptual and logical data model and translating into physical database.
• Responsible for configuring database memory structure, managing storage allocation, creating user accounts, roles and privileges for DB operations and security maintenance.
• Managing database instances for production and test environments to ensure strong testing environment and smooth transition to production.
• Used Datapump and SQL- loader to load data into tables.
• Utilized Oracle Enterprise Manager (OEM), Grid control to manage users, privileges, profiles and schemas.
• Automated monitoring the databases, performance parameters and backup/recovery activities by RMAN running Cron jobs and write UNIX shells scripts for job automation.
• Performed database and memory tuning using tools like STATSPACK, TKPROF, EXPLAIN PLAN, OPTIMIZER and SQL tuning advisor.
• Interacted with data modelers, developers, application owners for gathering the required information and resolving various issues.

Environment: AIX 4.3.3, HP -UX 11.23, Solaris 9, Windows XP, Oracle 9i/10g, RAC, OEM, RMANGrid Control, DBCA, Data Guard, Putty, Java, HTML, XML, Load Runner 8.0, ErwinTOAD 8.1, UNIX, Linux 4.0

Confidential

Oracle and MySQL DBA/Developer

Responsibilities:

• Backup Script creation and Standardization.
• Performed Database Installation and upgradation.
• Created materialized views, table partition for Tuned databases.
• Created indexes, rebuild indexes and maintained indexes.
• Involved in user creation and user access control. Involved in Schema creation and management.
• Setting the MySQL tunning parameters for better database performance.
• Setting up MySQL Slaves, backup and restoring databases, optimizing queries.
• Audited and tuned production MySQL servers.
• Having good experience in MySQL replication and master, slave configuration.
• Check up of slow query log and based on that tune the query and improve the performance of the database.
• Implemented Oracle security features and audit mechanisms for Fine grained access control.
• Maintained the RMAN repository and customized recovery catalog.
• Performed database tuning for daily loads and slow response issues.
• Used Triggers for database activities, like delete, update triggers.
• Used Statspack, perf stat and TKPROF utilities for Tuning and analysis.
• Involved in session management and monitored the critical wait events in the database.
• Involved In query optimization and using rule based optimizers.
• Used SQL Loader * for data import from remote databases.
• Written the control files in SQL*Loader to load the files in database tables.

Environment: Oracle 8i/ 9i, SQL, PL/SQL, SQL plus, TOAD, Oracle Enterprise Manager, RMAN.