SUMMARY:

• Over 7 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.
• Upgradation of databases 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 Upgradation 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.
• 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 and TOAD and setup of Oracle Grid Control
• Experience on Data Replication using Snapshot, Materialized views, import/export and Oracle Streams.
• 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.
• Good analytical, problem-solving skills, verbal and written communication skills.
• Expertise on technical documentation as project plan, development strategy, user manual, test and implementation strategy.

SKILL:

Operating Systems: LINUX, SOLARIS, MS-DOS, NT, Windows 95/98/XP/7/ 2000, Windows Advanced Servers 2000/2003, EXADATA V2(X2-2).

Databases: Oracle 11gR2, 10gR2 RAC, 9i, 8i, SQL Server 2005. MySQL4.x.x,5.x.x

Tools: & Utilities: Export/Import, RMAN, Data Pump, Winscp3, ERWIN

Oracle Database Tools: SQL*Loader, TKPROF, Toad, OEM, SQL Developer, Grid Control, MySQL Enterprise Monitor

Data Warehouse Tools: SQL and ETL tools for above database environment

Languages: C, C++, UNIX shell scripts, PL/SQL

Web Tools: HTML and XML, SQL NET, ODBC, TCP/IP

PROFESSIONAL EXPERIENCE:

Confidential, Thousand Oaks, CA

Oracle/Exadata Database Administrator

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: Oracle8i, 9i, 10g and 11gr2, Linux, HP, AIX, SUN Solaris, Windows, PL/SQL. RMAN, RAC, Dataguard (Standby), Grid Control (OEM),Exadata V2(X2-2).

Confidential, Foster City, CA

Oracle/MySQL Database Administrator

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 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.
• 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 Switch-over 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 10g RAC/11g RAC, OEM (Grid Control), Oracle Data guard, ASM, RAC,PL/SQL, Unix Shell scripting,RMAN, Datapump, SQL*Loader, Data Guard, Import / Export, AIX, HP UX Sun Solaris and Red Hat. MySQL 5.x.x, Shell Script, Replication, LINUX, solaris,MEM

Confidential, Orlando, FL

Oracle/MySQL Database Administrator

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 9i/10g/11g/11gR2 databases, Data pump, Export/Import, Physical Backups, Oracle Streams, Solaris 9.0, AIX Windows 2000/XP, RHEL, HTTP, F-Secure SSH,, F-Secure FTP, Oracle Enterprise Manager, TOAD, ASM, Golden Gate, Data Guard and Oracle Tools.

Confidential

Oracle Database Administrator

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.
• Oracle Streams Enabled the feature: data replications and integration feature in Oracle 11g
• 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, develop 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.
• Migrated database from Solaris to Red Hat Linux.
• As a member of the analyzing and designing team, the responsibilities were to understand the application requirements and build up system specifications.

Environment: Oracle 11g/10g, Oracle Enterprise Manager Grid Control, ASM, Real Application Cluster Loader, Oracle Enterprise manager (OEM), TOAD, Red Hat Enterprise Linux (RHEL) and Oracle Enterprise Linux (OEL).

Confidential

Oracle Database Administrator

Responsibilities:

• Configured and installed Oracle 9i/10g Databases; handled migration/upgrades of databases from 8i to 9i and 10g manually and with DBUA.
• Data modeling / Logical database design and implementation (including index design)
• Performed Backup/Recovery using RMAN and established testing standards utilizing the advantages of 10g Flashback.
• Performance tuned application/table design, data access methods, memory allocation, disk I/O, CPU usage and resource contention.
• Worked on debugging of databases and applied Oracle patches.
• Monitored Oracle Databases using scripts and OEM for database connectivity, table spaces monitoring and object growth.
• Conducting technology audits and performing GAP Analysis.
• Analyzed tables and rebuilt indexes to improve performance. Managed rollback segments, server processes, SGA, online redo log files and data files.
• Experience in proprietary change management processes to prevent production disruptions and outages.
• Monitored the server’s memory, disk, CPU I/O and network to establish baseline and peak performance for applications using UNIX command-line utilities.
• Wrote SQL scripts for DBA functions. Designed and created database objects such as Tables, Indexes, synonyms, database links, views and snapshots.
• 24*7 production databases and handled all day-to-day database issues, upgrades and enhancements.
• Provided maintenance of User accounts and privileges. Using Data- Pump, Export/Import to ensure that the latest data is available in the development/test database.
• Resolving incident tickets in the production environment with a good Service level Agreement.

Environment: Oracle 9i/10g on Sun Solaris 8/9, Real Application Clusters, Sun Solaris, Windows 98/NT/2000IBMX Series,Oracle9i/10g,Oracle Enterprise Manager, EXPLAIN PLAN,RMAN.

Confidential

Oracle DBA/ Data analyst

Responsibilities:

• Designing and creating schema objects like Database tables, indexes, views, synonyms, and all schema objects in Oracle.
• Responsible for writing database programming to Store/Retrieve the information from the database using SQL.
• Wrote Stored Procedures according to specs and control files for input to SQL*Loader utilities for loading data from external files into the Oracle database.
• Creating databases, objects, roles and privileges.
• Partitioned large tables to increase the performance.
• Configured scripts to monitor activity with database.
• Implement Hot, Cold and Logical backup plans.
• Used Oracle UTL file features to create flat files and Procedures for Data Extraction.
• Worked on Oracle Configuration, oracle Tuning and Oracle Patch Administration.
• Knowledge experience with Ethernet and mobility systems.
• Creation of Table space, Data files, Indexes, Rollback Segment and monitoring them.
• Performed Database Tuning. Performed Database Security and Integrity.
• Wrote extensive Sub Queries, PL/SQL procedures, functions, database triggers and packages.
• Created partitioning of its types like Range, List & Hash by the specific use.

Environment: Oracle 9i, 8i, RMAN, SQL*Loader, Sun Solaris, RHEL, Oracle Linux and putty.