Sr Oracle DBA

Professional Summary:

• *+ years of experience Oracle & SQL & MySQL database administration in heterogeneous system environment including Solaris, Linux and Windows.

• Supported variety of mission critical production applications in Enterprise and Financial environment.

• Extensive Experience in Oracle Database administration of DATAGUARD 9i & 10g & 11g.

• Extensive Experience in 11g, ASM Migration on mission critical databases.

• Extensive Experience in Oracle Streams, RAC administration.

• Extensive Experience in SQL Server Database administration on 2000, 2005, & 2008.

• Setting up Physical Standby & Logical Standby for the databases.

• Extensive Experience in MySQL Database administration on 5.0, 5.1 & now moving on to 5.2

• Extensive Experience in ORACLE FAILSAFE, implementation, configuration & administration.

• Experience in Implementing & Setup of ORACLE GRID CONTROL & OEM. And Also Setup up Backup Jobs for Databases via OEM.

• Extensive experience with Oracle database administration of Oracle 10g RAC with multiple nodes covered all aspects of administration like installation, configuration, migration, replication, sizing and space management.

• Have setup backup and recovery with expertise in performance tuning and troubleshooting of database.

• Understand the challenges of Production Environment, combined with outstanding leadership ability, team player and creative problem solving skills in both strategic and tactical areas.

• Worked on Extensive Data Warehouse environments sizing around 15-50TB

Key Strengths:

• Expertise in Oracle 10g/9i/8i database administration in high availability 24*7 production environment

• 10g/9i DATAGUARD & PHYSICAL STANDBY implementation & maintenance.

• 10g/9i Real Application Clusters (RAC) installation and maintenance on UNIX and Windows

• Solid experience in Oracle Recovery Manager (RMAN)

• Expertise in MS SQL database 2000, 2005 & 2008.

• Familiar with patching, configuration and implementing best practices

• Expertise in MySQL database 5.0 & 5.1 & 5.2.

• Performance monitoring/tuning/troubleshooting on Oracle, UNIX, Linux, and Windows NT/2000/2003 servers.

• Excellent interpersonal, analytical and problem-solving skills.

• Production Support is the main specialization.

Technical Skills:

Operating System: UNIX (Solaris/HP/AIX/Redhat/Ubuntu), Sun Sparc servers / HP Enterprise Class Servers, VMware ESX Server, Windows

Databases: Oracle 8i, 9i, 10g Databases, MS SQL 2000/2005/2008, MySQL 5.0, 5.1 & 5.2

Dev. And Admin Tools: Oracle Enterprise Manager, Developer 2000, PL/SQL, SQL*LOADER, Informatica Data Modeler, RMAN, Microsoft SQL Enterprise Manager, Retrospect (EMC2)

Applications: TIBCO Integration Application, Remedy Helpdesk Application, GSM, Oracle Apps.

Languages: SQL*Plus, PL/SQL, UNIX Shell Scripting, HTML, XML.

PROFESSIONAL EXPERIENCE:

MasterCard International, ST LOUIS, MO April 2008 – Till date

Sr. Oracle DBA & SQL DBA, Database Size: Total 10+ TB & above

(Cross Platform Expertise) -

Exp in current project - 2yr 9months and till date

No of Oracle Databases: 700+

DATAGUARD – 200+

RAC Databases: 10+

MS SQL Databases: 250+,

MySQL Databases: 50+

Team size: 24

Roles & Responsibilities:

• Installed Oracle 9i/10gR2 DATAGUARD, PHYSICAL STANDBY on PROD Environments & also RAC on a two node & 3 node clusters on Redhat Enterprise Linux – Prod Environment.

• Creating and maintaining Multiple ORACLE Instances /Databases for porting databases under various operating system platform (UNIX, Windows environment)

• Worked in Migrations & Upgrades of 9i & 10g Databases – and on DataGuards too.

• Implementation, Configuration & Administration of – ORACLE FAILSAFE on Windows Clusters.

• Installing and Maintaining environment including Creating Databases, Buffer pools, logical and Physical design of database storages

• Working on OEM & GRID CONTROL 10gR2. Scheduling Alerts setting up metrics, Scheduling RMAN Jobs VIA OEM.

• Have worked on Data Warehouse systems of very large sizes.

• Have worked on partitioning of tables.

• Have worked on Stage and Prod Data Warehouse systems.

• Have configured Data Guard using OEM too.

• Working as an ONCALL DBA for all Production databases 24*7 Support.

• Working pro-actively with UNIX Support, Web Group and Migrations Team to make sure all operating system and migrations issue are addressed in a timely passion.

• Creating various database objects and implementing referential integrity rules for complex databases

• Security Administration includes handling Instance / Database Level Authorities and Object Privileges. Creating and maintaining users, user groups and schemas for porting applications as well as controlling database access.

• Product support includes Data reorganization, Backup & Recovery of VLDB (version and roll-forward recovery) and Managing Log files.

• Cloning of entire database and refreshing production with new database name for testing and development purpose.

• Performance monitoring / Tuning with Event, Snapshot Monitoring and troubleshooting database issues by enabling various Diagnose level settings.

• Work with application developer and sql monitoring through gathering Explain data and advising SQL tuning tips.

• Database loading, Migration and Maintaining data with SQL*LOADER, EXPORT, IMPORT and RMAN utilities.

• Creating shell scripts & Cronjobs and Working pro-actively with Unix Support, Web Group and Migrations Team to make sure all operating system and migrations issue are addressed in a timely passion

• Was involved in writing some stored procedures, DB triggers in PL/SQL for customization works.

• Configuring and fine tuning Oracle configuration parameters for better response, throughputs and proper utilization of Global memory.

• Implemented ASM on RAC Systems and also on the single node instances.

• Architecting RAC Systems on REL Systems.

• Administration, monitoring, performance issues of RAC on Production systems.

• Database loading, Migrating and maintaining data with LOAD, EXPORT, IMPORT and RMAN utilities.

• Experience in Oracle RDBMS software installations.

• Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, and passwords.

• Applying patches to Production and doing DB releases on MS SQL Databases.

• Installing & Upgrading SQL Servers on Prod, stage & Dev environments.

• Creation of Jobs, DTS, Replications, Mirroring and also the Alerting of SQL Databases.

• Troubleshooting, performance tuning and maintenance of SQL Servers.

• Worked on MS SQL 2000 / 2005 /2008, creating backup strategies, Maintenance plans, Job Scheduling and User maintenance.

• MS SQL Client 2005 & 2008 installations for users.

• MySQL Database creation, installations & upgrades – of versions 5.0, 5.1 & 5.2.

• Creating Backups and working on scheduling and centralizing the entire databases in the organization for all MySQL databases.

• Tweaking, Optimizing, User Accesses, High Availability solutions like Replication and new Projects for MySQL Servers.

Environments: UNIX (SOLARIS 8 and 10), AIX, HP UX, REDHAT Enterprise Linux 3, 4, and Windows NT/2000/2003

DEVICESCAPE, SAN BRUNO, CA Sept 2007 – April 2008

Sr. DBA, Database Size: Total 1.5 TB users: 2000+

Roles & Responsibilities:

• Installed Oracle 10gR2 with RAC on a two node & 3 node clusters on Redhat Enterprise Linux.

• Creating and maintaining Multiple ORACLE Instances /Databases for porting databases under various operating system platform (UNIX, Windows environment)

• Installing and Maintaining environment including Creating Databases, Buffer pools, logical and Physical design of database storages

• Working pro-actively with UNIX Support, Web Group and Migrations Team to make sure all operating system and migrations issue are addressed in a timely passion.

• Creating various database objects and implementing referential integrity rules for complex databases

• Security Administration includes handling Instance / Database Level Authorities and Object Privileges. Creating and maintaining users, user groups and schemas for porting applications as well as controlling database access.

• Cloning of entire database and refreshing production with new database name for testing and development purpose.

• Performance monitoring / Tuning with Event, Snapshot Monitoring and trouble shooting database issues by enabling various Diagnose level settings.

• Work with application developer and sql monitoring through gathering Explain data and advising SQL tuning tips.

• Database loading, Migration and Maintaining data with SQL*LOADER, EXPORT, IMPORT and RMAN utilities.

• Creating shell scripts & Cronjobs and Working pro-actively with Unix Support, Web Group and Migrations Team to make sure all operating system and migrations issue are addressed in a timely passion

• Was involved in writing some stored procedures, DB triggers in PL/SQL for customization works.

• Configuring and fine tuning Oracle configuration parameters for better response, throughputs and proper utilization of Global memory.

• Implemented ASM on RAC Systems and also on the single node instances.

• Database loading, Migrating and maintaining data with LOAD, EXPORT, IMPORT and RMAN utilities.

• Experience in Oracle RDBMS software installations.

• Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, and passwords.

• Creating and Implementing Oracle Apps 11i on the Test bed. Planning for Production implementation and capacity planning

• Worked on MS SQL 2000 / 2005, creating backup strategies, Maintenance plans, Job Scheduling and User maintenance.

• Applying patches to Production and doing DB releases on MS SQL Databases.

• Administrating MySQL databases of version 5.0 and also deployiong new databases.

No of Oracle Databases: 20 – two database around 600-800 GB

RAC Database: 3

No of SQL Databases: 10

MySQL Databases: 15

Team size: 6

Leading a team of: 4

CDC Software, Atlanta Georgia Dec 2004 - Sep 2007

Oracle & MS SQL DBA

Enhancement of existing CRM System, incorporating new developments, implementation, Oracle 9i and MS SQL database maintenance

Environment: Windows NT and 2003, these systems are running independently at the data center, with Linux systems for Test setup of 10gR2 RAC.

Database Size: Up to Size # 150 – 250 GB GB, Users- 175+

Roles & Responsibilities:

• Production support for Oracle database 9i/10g/10g RAC and SQL server 2000

• Involved in the Process of enhancement of various CRM modules, remodeling the Database backup plans for all MS SQL Database production servers, And remote monitoring of the App and the DB Server on Daily basis.

• Responsible for writing customized shell scripts to monitor the stats of performance issues.

• Created database triggers in PL/SQL for data security.

• Implemented ASM on RAC Systems and also on the single node instances.

• Working on Data Modeling concepts and development of Oracle Databases.

• Installing and maintaining environment including Creating Databases, Buffer pools, logical and Physical design of database storages and Creating and maintaining Multiple Oracle Instances / Databases for porting databases under various operating system platforms (UNIX, Windows environment).

• Database loading, Migration and Maintaining data with SQL*LOAD, EXPORT, IMPORT and RMAN utilities.

• Worked on Oracle Streams Replication.

• Worked on MS SQL 2000 / 2005, creating backup strategies, Maintenance plans, Job Scheduling and User maintenance.

• Applying patches to Production and doing DB releases on MS SQL Databases.

• Data Analysis and Modeling done on all the databases.

• Monitoring and Tuning oracle Database for optimum performance using oracle provided utilities and tools (TKPROF and Explain Plan utilities, UBSTAT/UESTAT reports)

• Implementation and Testing of 10gR2 RAC on test bed.

• Database loading, Migration and Maintaining data with SQL*LOADER, EXPORT, IMPORT and RMAN utilities.

• Handled Database Security Procedures (Create and Maintain Users, profiles, Roles with System and Object level Privileges) and periodical evaluation of security model.

• Implemented backup and Crash Recovery Procedure using Oracle suggested Online/Offline and logical Methodologies.

• Worked on MS SQL 2000 / 2005, creating backup strategies, Maintenance plans, Job Scheduling and User maintenance.

No of Oracle Databases: 10

RAC Database: 3

No of SQL Databases: 25

Team Size: 15

Leading a team of: 6

Ocwen Financial Corp, West Palm Beach, Florida Sep 2002 - Dec 2004

Oracle & MS SQL DBA

Focusing on Oracle 8i and 9i database Administration, Creation, Performance Tuning, Design, Test and Implement backup and recovery strategies, systems migration and application implementation and Network administration

Environment: Windows, Linux REL 5, all systems are running independently in the data center.

Database Size: Up to Size # 400 GB, Users- 200+

Roles & Responsibilities:

• Fully involved in the process of data migration, implementation, customization and enhancement of various modules. User and Database backup maintenance plans and strategies

• Installing and maintaining environment including Creating Databases, Buffer pools, logical and Physical design of database storages.

• Created database triggers in PL/SQL for data security.

• Creating various Database Objects and implementing referential integrity rules for complex databases.

• Working on Data Modeling concepts and development of Oracle Databases.

• Security Administration includes handling Instance / Database Level Authorities and object Privilege. Creating and maintaining users, user groups and schemas for porting applications as well as controlling database access.

• Database loading, Migration and Maintaining data with SQL*LOAD, EXPORT, IMPORT and RMAN utilities.

• Monitoring and Tuning oracle Database for optimum performance using oracle provided utilities and tools (TKPROF and Explain Plan utilities, UBSTAT/UESTAT reports).

• Communicating and maintaining standards across application development consultants and groups.

• Documented the entire Oracle instance.

• Worked on MS SQL 2000 / 2005, creating backup strategies, Maintenance plans, Job Scheduling and User maintenance.

• Applying patches to Production and doing DB releases on MS SQL Databases.

• Knowledge of MySQL databases and Architecture.

No of Oracle Databases: 40

RAC Database: 2

No of SQL Databases: 15

Team size: 16

Software Developer

Embed Innovation, Bangalore India Jan 2000 to May 2002,

Software developer

Using VB & Embedded C.

Project: Integrated Voice Recognition System.

Environment: Win NT, Microsoft Developer Studio, Embedded systems for testing.

Roles & Responsibilities:

• Designed and developed modules using C / VB.

• Developed and tested a module in VB to interpret the voice.

• Integrated the different modules in C and VB.

• Developed the GUI modules.

EDUCATION:

Bachelors of Engineering, Bangalore, India

Contact this candidate