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

Confidential,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.

Confidential,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.

Confidential,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