SUMMARY:

• 9 Years of experience as Oracle Database administrator including 3 years as MySQL database administrator (4.x and 5.x Versions), having hands on experience in database administration, production support, installation, configuration, upgrades, performance tuning, backup and recovery, cloning, space management, and database security with Oracle Software 11g/10g/9i/8i on Sun Solaris, Red Hat Linux, HP - UX, AIX, Exadata V2 (X2-2) and Windows Platform.
• Installation and administration of Oracle 11g/10g/9i on OEL, RHEL, HP-UX, Windows, UNIX and Sun Solaris in OLTP environment.
• Database Upgrade by applying patches, patch sets and critical patch updates.
• Installation and configuration of Oracle Server 11g RAC with ASM on multi node systems, 11g, 10g and 9i in different operating systems for OLTP environment on Very Large Databases (VLDB).
• Extensive experience on Oracle 11g/ASM/RAC and Upgrade of standalone databases to 11g RAC environment
• Experience in Configuring Automatic Storage Management (ASM).
• Developed database monitoring/health checkup alerts for database uptime/downtime status, and sizing issues using grid control (OEM) and extensively used Oracle Enterprise Manager to do the daily tasks regarding the performance and maintenance.
• Extensive experience in configuring and managing Data Guard on RHEL, OEL and Windows.
• Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-prod databases.
• Recovery / Restore of Oracle Databases in Disaster Exercises.
• Experienced in setting up physical standby databases for Disaster Recovery in critical production environments using Data Guard.
• Experience in Tuning oracle database on EXADATA V2(X2-2) machine that is only manufactured by oracle.
• Experience in installation and implementing OEM, TOAD and setup of Oracle Grid Control
• Experience on Data Replication using Snapshot, Materialized views, import/export and Oracle Streams.
• Agile Oracle Environments including installations/troubleshooting.
• Regular database synchronization for test database environments through automation.
• Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN (full and incremental)
• Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, export/import, expdp/impdp.
• Migration of databases from one platform to another platform.
• Experience of installing, configuring Golden Gate and troubleshooting Golden Gate issues.
• Detecting and diagnosing production system performance problem by analyzing STATSPACK reports, Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views.
• 24*7 on-call production database support and maintenance including remote database support
• Assisting in implementation of change control process in production.
• Professional and highly motivated DBA and Development work experience in the software industry withMySQL (4.x, 5.x)
• Experience of Database Administration, design, development, maintenance and production support of relational databases, business applications, new server setup, MySQL Server installation, upgrade, migration.
• Have successfully managed high availability of production systems for Corporate Sectors and Individual Organizations as MySQL DBA.
• StrongMySQLskills but also significant general system administration skills on UNIX/HP Open VMS, Linux and Windows environment. Proficient writing shell scripts as well as knowledge in general systems administration tasks.
• Experienced inPerformance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using different Utilities and MySQL Enterprise Monitor.

TECHNICAL SKILLS:

Operating Systems: HP-UX10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10,IBM-AIX, Windows 2000/XP, Red Hat Linux RHEL 3.x, 4.x, 5.x.,6.x,EXADATA V2(X2-2)

RDBMS: Oracle 11g,10g/9i, Oracle 10g and 11g Real Application Cluster (RAC) MySQL (4.x.x/5.x.x)

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

DB Management: TOAD, OEM

Tools: /Utilities: RMAN, OEM, Oracle Management Server, SQL*Loader, SQL Server, Export/Import, TOAD, Data pump, Query builder, Net Backup, VB, Crystal Report, MS Access, MySQL Monitor

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM,ASH

PROFESSIONAL EXPERIENCE:

Confidential, Frisco, TX

Oracle DBA

Responsibilities:

• Strong 24x7 Production database administration, intensively involved in the area of installations of Cluster ware and Oracle Software, Configuration for database and day-to-day routine works for database Administration.
• Configuring public and private network and VIP for new RAC databases.
• Involved SRVCTL, CRSCTL, OCR and Voting Disks11g RAC on ASM
• Involved to migrate oracle database normal file system to ASM disks.
• Creating database links and mapping to one schema to another schema.
• Involved to create standby dataguard and configured and troubleshooting redo gap issues.
• Managing 2node cluster with 2node dataguard, troubleshooting upgrade issues and redo gap.
• Involved in all phases of database development, from needs assessment to QA/QC, design, and support.
• Involved in Exadata Patching with oracle team.
• Worked on more than 300 refreshes of databases in QA, prod, Dev, FIT environments.
• Supported Oracle developers. Performed database tuning, created database reorganization procedures, scripted database alerts, and monitored scripts.
• Worked on AGILE Oracle Environments with Agile installations and troubleshooting issues.
• Analyze the database performance and performed database performance tuning.
• Created disaster recovery environment for company critical and essential databases.
• Performed data loads using Data Pump and export/import utility.
• Managed RMAN backups, conducted performance tuning analysis and modification, and developed standard operating procedures.
• Administered and supported 200+ global development and productiondatabases
• Proactively assisted developers in maintaining 20 + applications being accessed nationwide by employees and customers.
• Performed the database recovery multiple times in a remote area, with only internal network and backup sets available by RMAN restore and set up the dataguard environment without any issues.
• Maintained Data Guard environment, able to manage many schemas, create DDLs when needed, optimize and develop complex queries and execute weekly deployments to various environments.
• Took ownership of complex database incidents and problems and provided resolutions in a speedy and timely manner.
• Upgraded to latest Oracle release enhanced availability and introduced new features for ongoing support of these databases.

Environment: EXADATA,Oracle 11g/10g, Sun Solaris, Red Hat Linux, TOAD, RMAN, Agile Oracle, ASM,RAC,Data Guard, OEM, Grid Control, STATSPACK, AWR, Explain Plan.

Confidential, Thousand Oaks, CA

Oracle DBA

Responsibilities:

• Perform CORE DBA tasks such as Database Administration on Oracle 9i, 10g and 11g environments.
• Performance tuning, Schema creation, maintenance, and troubleshooting. Administers, maintains, develops and implements policies and procedures for ensuring the security.
• Implementing data models and database designs, data access and table maintenance codes; resolves database performance issues.
• Database capacity issues, backups, replication, and other distributed data issues over a highly volume Terabyte Database.
• Setup and manage RAC environments for our customers.
• Identify, monitor, recommend, and implement changes to database applications ensuring satisfactory end-user response time with reliable database connectivity.
• Implement physical database changes, testing, and performance tuning by reviewing database activity, progress, and performance reports.
• Maintain Oracle SQL and PL/SQL scripts, Unix Shell Scripts, debugging and tuning.
• Implement Production Control and Change Management.
• Ability to pro-actively understand and manage end user/customer expectations.
• Worked on EXADATA machine with oracle database and Tuning the database along with SQL.
• Used Smart scan leverage allowing bloom filters in EXADATA machines for oracle.
• Worked on RAC performance tuning by improving Interconnect Performance, Session waiting while suggesting OS tuning and Application Tuning.
• Provides best practices on new technologies and implementations.
• Provides expertise and makes recommendations for physical database design, architecture, testing, performance tuning, and implementation of Oracle DB.
• Performance issues (track and trend overall database performance and database area, index, and drive performance).
• Recommending application code changes (processing strategies, queries, use of RDBMS features)
• Great experience applying patches and performing DB Migrations.
• Plan and Design Backup/Recovery solutions using shell scripts and RMAN.
• Ensure that the database software infrastructure is in place and up to date to support other infrastructure components (e.g., operating system and hardware) and application development.
• Maintain more than 25 databases in-house for development/QA and 6 PROD databases for our customers.

Environment: EXADATA V2(X2-2), Oracle 11g/10g, Sun Solaris, Red Hat Linux, TOAD, RMAN, SQL server, ASM,RAC,Data Guard, OEM, Grid Control, STATSPACK, AWR, Explain Plan. ETL tools, Sales force.

Confidential, Foster City, CA

Oracle/MySQL DBA

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Performed database cloning, Conducting sizing & capacity planning for Oracle databases.
• Upgraded Oracle databases from9ito10g,9i, 10gto11g, Upgraded all production databases to Oracle 11gR2(11.2.0.7) along with the Grid Upgrades in a RAC environment. Applied patches to Oracle Databases and Oracle Applications.
• Responsible for optimizing the queries and application tuning. Perform SQL tuning and assist developers with coding.
• Configuring database entries and monitoring all of the databases usingOracle Enterprise Manager (OEM). Used OSWatcher and collect the statistics on regular intervals.
• Installed and Implemented Backup & Recovery procedures. Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Implement Hot, Cold and Logical backup plans. Customization and development of CRON JOBS, shell scripts.
• Management of users, schemas, objects partitioning the tables & indexes.
• Perform other regular DBA activities including space management and performance monitoring.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN. Continuous monitoring of database performance during peak and non-peak loads using STATSPACK.
• Implemented the replication of data between multiple databases using Streams.
• Worked on EDW (Data warehouse databases), which used to report for CMLS Teams.
• Implemented Golden Gate Replication and Extracting data and applying on production using Golden Gate.
• Hard disk and Database space monitoring. Migrated file systems to ASM (Automatic Storage Management).
• Implemented disaster recovery exercises using Oracle Data Guard technologies including Fail-over and Switchover operations.
• On a regular Basis: Database administration including the management of instances, redo logs, temp space, rollback/undo segments and schema management.
• MySQL Administration and management of the entire development, QA and production environment.
• Managing/Troubleshooting MySQL 5.0.22 and 5.x.x in production and developer environments on both Linux and Solaris systems
• Performed installation, new databases design, configuration, backup, recovery, security, upgrade, and schema changes, and tuning and data integrity.
• Ensured production data being replicated into data warehouse without any data anomalies from the processing databases.
• Worked with the engineering team to implement new design systems of databases used by the company.
• Effectively configured MySQL Replication as part of High Availability solution.
• Performance Tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor.
• Developed stored procedures, triggers in MySQL for lowering traffic between servers & clients.
• Managed users, groups and set up restrictive permissions, configuration of the SUDO files etc.
• Performed MySQL Replication setup and administration on Master-Slave and Master-Master.
• Shell script is being used for data migration and backend work management.
• Handling Release management and user acceptance.

Environment: Oracle 11g/10g, Linux (RHEL), Windows 2003/2008, RDBMS, OEM Grid Control, ASM, RMAN, RAC, Data Guard, Golden Gate, SQLPLUS, PL/SQL, Shell Scripting, Stored Procedures, MySQL Servers, MEM.

Confidential, Orlando,FL

Oracle/MySQL DBA

Responsibilities:

• Responsible for life cycle development, testing and production performing 9i, 10g and 11g, RAC installations, configuration, tuning and troubleshooting on Unix & Windows operating systems
• Supported installation and setup of ORACLE Cluster’s and RAC database. Monitoring and Administrating ORACLE RAC databases on ORACLE 11g Clusters (6 Node with high availability)
• Table & Index partitioning to monitor performance issues and ensuring maximum uptime of the database. Importing of dumps using IMPDP/EXPDP utilities.
• Implemented Automatic Shared Memory Management (ASMM) and Automatic Segment Space Management (ASSM).
• Implemented cross platform migration from HP-UX to AIX, Solaris to Linux, Windows to Linux
• User accounts creation and Table Space Creation and managing the table spaces using the Oracle Default Compression.
• Implemented Oracle Advanced Security options such as data encryption for data privacy.
• Performed Patch set updates, CPU patches on RAC Databases to minimize the security issues and provide bugs fixes and Configured and Upgraded to Oracle 11gR2 from 10g.
• Installed Golden gate for replication of database and Configured parameters for replication, DDL support which also includes the Bi-directional replication.
• Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, troubleshooting, back up and recovery, installations and configurations on an as needed basis.
• Implementation and monitoring of all databases using OEM/Grid Control
• Also applied Interim (One-Off), Setting up physical and logical standby database/data guard at DR site for operational recovery.
• Performance tuning and monitoring of Databases through v$ views, AWR, ADDM, STATSPACK, etc.
• Analyzing the Tables and Indexes using DBMS STATS package.
• Implemented scripts, which monitor database health check at regular interval, upon error, send email to the concerned person.
• Establishing back-up policies and Restore activity, backup using User Managed Backup (Data Pump) and Recovery Managed Backup (RMAN).
• Provided 24x7on call support for all the production databases.
• Work with engineers on MySQL performance tuning, query optimization, index tuning.
• Monitor MySQL databases for problems and to diagnose issues in production and development.
• Test and improve backup and restore processes.
• Prototype and test new system images including MySQL, Linux and different hardware configurations.
• Provide 24x7 on-call Support MySQL databases (4.x.x) for production and development.

Environment: Oracle 10g, Solaris, VERITAS, OEM, EXPLAINPLAN, TKPROF, AIX, Oracle 10g RAC, TOAD, MySQL (4.x.x), MySQL Replication

Confidential

Oracle DBA

Responsibilities:

• Design and Create new databases based on requirements of the application / project
• Responsible for all the database related jobs for all the instances, performance tuning, backup and recovery, managing users & privileges, resource limits. Administration of database objects such as indexes, tables, views, constraints, and stored procedures.
• Performed database tuning using explain plan, TKPROF, stats pack and other custom utilities
• Installed, configured 10gRAC on two-node cluster, created databases in both in standalone and RAC environment.
• Developed RMAN backup scripts and automating the RMAN backup scripts.
• Implement partitioning and indexing strategies
• Create users, roles and profiles with different security levels. Grant and revoke privileges.
• Migrate changes to Oracle database objects and monitor/administer existing databases security with Oracle database environment.
• Provide DBA support to developers, developed stored procedures and triggers. Also Provide on call support related to Oracle DBA activities.
• Taking reviews of physical database models. Develop procedures to troubleshoot issues.
• Handled day-to-day database activities including performance monitoring and tuning to ensure the efficient and accurate operation of the database software. Scheduling maintenance and health check of the applications and databases.
• Analyzing the schemas and individual tables Expert in Oracle Backend programming in SQL and PL/SQL, Writing Stored Packages, Procedures, and triggers in a Multi tier environment.
• Performed rolling patch upgrades for RAC environment for bug fixing and also involved in applying PSU and CPU patches for Oracle Server.
• Planned and Implemented Disaster Recovery (DR) and HA using RAC, Data Guard, Streams and made sure that the database is always available for the users even at the critical times like failures and up-gradations.
• Cloned or refreshed the databases from production to development and test environments.
• As a member of the analyzing and designing team, the responsibilities were to understand the application requirements and build up system specifications.

Environment: Oracle 10g/9i, Red Hat Enterprise Linux 4.x and 5.x, AIX 5.2, OEM, Oracle 10g RAC, Sybase, STATSPACK, EXPLAINPLAN, IBM Data stage, C++, Web logic, SQL Server 2005.

Confidential

Oracle DBA

Responsibilities:

• Designed and Developed Oracle database logical and physical standards as needed.
• Architecture design based on objective rather than off-shelf applications documentation.
• Tuned the current Application Architecture to Optimal Performance Architecture.
• Backup and recovery utilizing RMAN.
• Worked in Oracle SQL, PL/SQL, SQL*Plus, IMP/EXP, Query performance tuning, Created database objects like Tables, Views, Indexes.
• Setup standby database via Data Guard for database disaster recovery.
• Installation of Oracle Patches.
• Writing PL/SQL procedures.
• Implemented flashback technology and materialized views.
• Performed ongoing tuning of the database instances.
• Installation and configuring the oracle software.
• Make the database Optimal Flexible Architecture Complaint.
• Managing of Table space of different user by granting quota on Default & Temporary Table spaces.
• Monitoring CPU resource utilization and database growth.
• Cloned database from Production to Testing.

Environment: Oracle 9i, Oracle, Oracle Enterprise Manager, MS SQL Server 7/2000,RDBMS, SQL, PL/SQL, TOAD7.5, Shell Scripting, HTML, Stored Procedures, Triggers.