Oracle Manager

Kejal Vaz

Oracle Database Administrator

Email: *****.*******@*****.***, Phone: 612-***-**** & 952-***-****

Profile Summary

• Over 6 years of experience in IT, Responsible for database administration, production support, installation, configuration, upgrades, patches, backup and recovery, database security, auditing and space management.

• Installation and configuration of Oracle 8i, 9i, 10g, 11g databases in SOLARIS environments.

• Planned and implemented Oracle 10g, 11g and Standby Databases (Data Guard) for High availability and Disaster Recovery (DR).

• Experience in upgrading the database from Oracle 9i to Oracle 10g & oracle 10g to oracle 11g and migration of the databases using transportable database, tablespaces export/import, data pump utilities.

• Used Opatch utility for applying CPU and One-off patches & RDBMS patch set Upgrade (PSU).

• Installed and configured oracle Grid control and deployed agent on managed targets.

• Good experience with Oracle grid control, Oracle enterprise manager (OEM), ASM, AWR, ADDM, Flashback Technology, SQL tuning advisor, SQL access advisor, and SQL server undo advisor.

• Have good knowledge on ORACLE RAC

• Experienced on creating DB links across databases and performed advanced

• Designed and implemented centralized backups and recovery strategies using recovery manager (RMAN).

• Expertise on performing cold backups, hot backups, advanced recovery with flash back recovery method.

• Cloning/replication of the databases

• Experience in using SQL, PL/SQL stored procedures, indexes, materialized views, shell scripting, partitioned and non-portioned tables, packages and triggers for improved performance of the database.

• Performance Tuning: Experience in identified poor SQL statements using EXPLAIN PLAN, STATSPACK, TKPROF, SQL TRACE, OEM Grid Monitoring.

• Experience in using the oracle support (Metalink) for Service Requests (SR database log files related performance issues, Remote Diagnostic Agent (RDA).

• Good experience in managing Very Large OLTP and Datawarehousing databases.

• Involved in Data modeling, logical and physical database designs and worked as on-call support team member for administering OLTP 24X7 production databases.

• Excellent communication skills, strong analytical & logical abilities, problem solving skills and fast learning.

• Creating shell scripts for monitoring purposes.

Technical Skills:

Databases: Oracle 7i, 8i, 9i, 10g, 11g, SQL Server 2005 and 2008, Teradata, Informix, DB2, Mainframe

Operating Systems: Red Hat Linux, HP-UX, Sun Solaris and Windows.

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

Utilities: RMAN, Oracle 10g Grid Control, Data Guard, SQL*Loader, EXP, IMP, Datapump, SQL developer, VERITAS NetBackup, APEX

Tools: TKPROF, TOAD, EXPLAIN PLAN, AWR, STATSPACK, ASH, AUTO Trace, Toad, Pl/Sql Developer, ERWIN, appworx, putty.

Certifications:

Oracle Certified Associate (OCA) in Oracle 9i.

Oracle Certified Professional (OCP) in Oracle 9i.

Six Sigma GB Certified.

Professional Experience

Wells Fargo, MN Dec 2010 - Till date

Access Management analyst

Responsibilities:

• Provisioning user access on various database platforms Oracle 10g, 11g, SQL Server 2005 and 2008, Teradata, Informix, DB2 for over 1500 databases

• Solving problem tickets for database access issues

• Work on daily requests for user creation, modification or deletion

• Review and modify procedural documents

• Work on Unix shell script for automation of processes

• Attending to user related issues.

• Work on project activities including process improvements.

Highlights:

• Created UNIX shell script to connect over 1500 databases to check and verify the connection.

General Electric, MN Dec 2005 - Jul 2010

Oracle DBA

Responsibilities:

• Database Monitoring and administration of database using Enterprise Manager Grid control (OEM) and automated UNIX shell scripts

• Upgraded Oracle Database from 7i to 10g and 11g, 8i to 10g, 9i to 10g, 10g to 11g

• Managed and supported more than 1000 databases including Test, Qa, Dev and Prod

• Cloning of the database from Production to the Test and Development environments using RMAN and conventional methods.

• Applied security related CPU and One-off patches using Opatch utility, Applied RDBMS Patch set Utility (PSU).

• Installed and configured oracle grid control.

• Resolve problem tickets logged by the end users

• Conducting load test for new applications

• Performed Cold backup, hot backup using conventional backups and RMAN, recovered various and critical Production databases

• Prepared backup schedule which include offline, online and logical backups.

• Used Export/Import, Data Pump Utilities to move the data between different databases and for backups.

• Worked on transportation of Tablespaces, Data Archival, Re-organization of tables and restoration.

• Tuning of Shared Pool, Library Cache, and Data Dictionary Cache.

• Monitor CPU usage, I/O contention, memory paging on UNIX server. Identify resource and performance bottleneck. Provide technical direction to system administrators

• Rebuilding of Indexes for better performance, maintenance of Oracle Database.

• Generated performance reports and Daily health check up of the database using utilities like AWR, Statspack and ADDM to gather performance statistics.

• Identified and tuned poor SQL statements using EXPLAIN PLAN, SQL TRACE and TKPROF, Analyzed tables, indexes for improving the performance of the Query.

• Analyzed SQL statements, re-organized database objects and created indexes to improve the performance of the queries.

• Partition of tables to improve performance.

• Worked on ASM systems

• Troubleshooting various issues like database connectivity to users, privileges issue etc

• Created users and allocated appropriate table space quotas with necessary privileges and roles for all databases.

• Worked with Oracle Support for resolving the database related unresolved issues.

• Worked on SQL* Loader to load data from flat files, Checking for Row Migration and Chaining on Highly used transaction tables.

• Created new databases and configured TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.

• Created DB links across databases and Solved Database connectivity issues by continuously monitoring the status of the listeners and instances.

• Monitored overall system performance and Database growth.

• Provided 24X7 support for production environment.

• Worked in Onsite-offshore and Nearshore model.

• Checked alert logs and background trace files on daily basis and resolved problems.

• Carried out monitoring activities for space check for database growth, backups monitoring, materlized views refresh, DB uptime check

• Scheduled jobs in the database using CRON Jobs and DBMS_JOBS.

• Creating shell scripts for monitoring purposes.

Highlights:

• Automated Control File Binary Backup & Reporting for the Tests Conducted with the help of shell scripting

• Created a Maintenance portal in APEX for reporting

• Implemented flashback feature in production database for 9i and 10g.

• Automated the process of reporting block corruption in the database with the help of shell scripting.

• Upgrade and Migration of prod, test & QA databases to GIS severs.

CMS Institute, India June 2005 – Dec 2005

Technical Trainer

Responsibilities:

• Training students in Hardware courses including PC assembling, different parts of the computer

• Installation of Red Hat Linux and Windows operating system

• Network setup(LAN setup)

• Grooming students for CCNA certifications

• Preparing exam questions and conducting exams

• Resolving network issue

Highlights:

• Conducted a seminar on behalf of the CMS institute for over 200 audiences for basic computer hardware knowledge.

Key Achievements and Initiatives

• Received Frog award by GE CIO for quick response and solutions.

• Received customer appreciation for flashback implementation in production databases.

• Carried out six sigma green belt training for team members

• Conducted training sessions on APEX for team members

• Appreciation received by onsite counterpart for dedication in work.

• Awarded for Automation of control file backup of production databases residing on different servers.

Education:

Bachelor in Computer Science

Post Graduation Diploma in Business Administration - Information Technology (Ongoing)

Contact this candidate