Sql Server Oracle
Resume:
POKKULA HARIRAM Oracle
Database Administrator
Email:
*******@*****.***
Phone:
RELEVANT SUMMARY:
* *** ** ********* ********** in Oracle database administration including installation,
backup / recovery, performance tuning & high availability.
Over 1year of experience in SQL Server administration.
Responsible for Administration of Oracle Databases in UNIX, LINUX & Windows
environments.
Worked on implementing and testing disaster recovery system, using RMAN/DataGuard
(physical/logical standby).
Extensively worked on Failover / Switchover as part of regular DR exercise.
Provided support in the installation of 2-Node RAC using OCR and ocfs2 file system.
Through knowledge in high availability RAC (multiple nodes) environment and up
gradation of the standalone databases to 10g RAC environment
Testing all types of backup and recovery strategies in simulated conditions before actually
implementing the backup and recovery strategies and crisis resolution plans.
Extensive experience in Upgrades and applying One-off/CPU Patches.
Extensively worked on Migration, SQL Tuning & Memory Tuning.
Good experience on writing Shell scripts for managing the user's roles and privileges, disk
space management, cold backup and hot backup.
Good knowledge in SDLC, database design and database system infrastructure
development.
Evaluated Oracle 10g new features for the implementation (OEM grid, ASM, VLDB, AWR,
ADDM and Datapump – Impdp/Expdp).
Wrote Oracle stored procedures and PL/SQL programs.
Experience in administering large databases ranging from 50 GB to 5 TB of data on UNIX
Platforms.
Responsible for administration of SQL Server databases including backup / recovery, user
management and disk space management.
Proactively administered, monitored and tuned the databases by providing 24x7 On-Call
Technical Support to Mission Critical, Business Critical and Normal Databases.
Ability to work independently and effectively adapt to rapidly changing technology and
apply it to business needs.
Exceptional problem solving and sound decision making capabilities.
EDUCATION & CERTIFICATIONS:
Bachelors of Engineering, India
Oracle10G Certified (OCP).
TECHNICAL SKILLS:
Database : Oracle 8i, 9i, 10g, 10g RAC, SQL SERVER 2000/2005.
Operating Systems : Sun Solaris 5.9/5.10, Tru64 UNIX, HP-UX, IBM AIX, CentOS 4,
Windows NT.
Database Tools : OEM, RMAN, AWR, ADDM, TOAD, DB Artisan, IMP, EXPDP, IMPDP,
Toad, BCV, ERWIN, GRID CONTROL.
Technologies : RAC (Real Application Cluster), DataGuard
Utility Tools : Putty, Hummingbird Connectivity.
Languages : Oracle PL/SQL, Conversant with C, C++, Mat lab.
Change Management : ClearCase, ClearQuest, Remedy.
Scheduling Tools : Autosys, Crontab.
PROFESSIONAL EXPERIENCE:
Freddie Mac, VA Jan’08 – Till Date
ORACLE / SQL Server DBA
Responsible for administration and supporting Oracle 9i, 10g and 11g databases.
Responsible for monitoring of 200 Oracle db’s ranging between 500GB to 2TB in size and
70 SQL Server db’s ranging between 40GB to 200GB in size.
Responsible for Installation, Upgradation of Oracle 9i/10g databases.
Implemented Backup and Recovery strategy through RMAN/SQL Backtrack with TSM as
media manager layer and used Autosys as the scheduler.
Performed both Hot / Cold backups and coordinated with TSM team to solve any backup
issues.
Performed cloning of databases using RMAN/SQL Backtrack for lower environment
purposes.
Implemented disaster recovery solution using DataGuard.
Provided support in the installation and configuration of 2-Node RAC using OCR and
ocfs2 file system.
Upgraded standalone databases to 10g RAC environment.
Expertise in using OEM and its components.
Performed Failover / Switchover as part of DR exercise.
Apply regular CPU patches.
Monitored databases using OEM Grid Control.
Respond to database fatal alerts in Quest Foglight.
Involved in refreshing lower environment schemas with production data periodically
using EXP/IMP and Datapump.
Wrote/modified various shell and SQL scripts.
Created/Modified/Dropped users as and when required.
Enabled password management for all the users using profiles and administered
privileges via roles.
Assisted users in improving the database and SQL performance. Fine tune Oracle
parameters for better performance.
Installed Oracle database gateway for Sybase.
Configured Oracle clients using configuration files – tnsnames.ora / sqlnet.ora.
Assisted users in resolving Oracle client related issues.
Responsible for administration of SQL Server databases including backup / recovery, user
management and disk space management.
Created databases and users using SQL Server Enterprise Manager.
Refresh SQL Server databases with production data.
Served as primary point of contact for all database related issues during the shift.
Change management using ClearCase/Remedy.
Documented standard procedures and policies.
Environment: Oracle 9i/10g/11g, 10g RAC, Sun Solaris, Tru64 UNIX, Hummingbird Connectivity
4.2, Quest Foglight/Spotlight, DB Artisan 8.1.1, Rational ClearCase/ClearQuest, Autosys, BMC
Remedy, RMAN, SQL Backtrack 6.1.0, TSM Media Management.
City of Charlotte, NC May’07 – Dec’07
Sr. ORACLE DBA
Implemented disaster recovery solution using DataGuard for production and non-
production databases.
Created both physical and logical standby databases.
Performed switchover and failover using OEM Grid and DataGuard Broker as part of
disaster recovery exercise.
Installed and configured 10g RAC on Linux and sun Solaris including creation of database
using ASM, upgrading 10.2.0.2 to 10.2.0.4 by manual method and Implementation of
RMAN.
Trouble shooting of RAC Database
Monitored database activity, Standby databases health and backups using OEM Grid
Control.
Performed both Hot / Cold backups using RMAN.
Involved in restore and recovery of databases.
Refresh lower environments with Production backups using RMAN.
Refreshing Schemas using EXP/IMP utilities.
Served as primary point of contact for any DataGuard related issues.
Assisted users in resolving Oracle client related issues.
Monitor databases/servers using Quest Sportlight.
Created/Modified/Dropped users as and when required.
Provided 24x7 on call support.
Environment: Oracle 9i/10g, 10g RAC, Sun Solaris, HP-UNIX, Putty, OEM Grid Control, TOAD,
RMAN, DataGuard, and Quest Spotlight.
Bear Stearns, NY Aug’05 – Apr’07
ORACLE DBA
Responsible for Upgrade and Maintenance of Oracle 9i/10g Databases.
Evaluated Oracle 10g new features for the implementation.
Supported users in upgrading applications from 9i to 10g in helping them to tune SQL
and database performance.
Created and maintained DataGuard. Wrote new shell scripts for the maintenance.
Worked on capacity planning and scheduled required jobs to setup alerts using CRON.
Perform daily maintenance tasks on oracle databases such as creating or adding space to
Tablespaces, users, roles, privileges, synonyms, archivelog destination monitoring,
upgrades/patching, database connectivity issues etc.
Performance Tuning at SQL and database level.
Backup and Recovery using RMAN.
Cloning a database using RMAN, Refreshing of database using exp/imp and also
transportable Tablespaces.
Resolved any issues and ensured scheduled backups are completed successfully.
Created triggers and stored procedures in PL/SQL.
Maintained various shell and SQL scripts and also wrote new scripts.
Monitoring database health by scheduling shell scripts through cron jobs.
Wrote technical documentation and standard procedures.
Environment: Oracle 9i/10g, PL/SQL, Shell Scripts, RMAN, DataGuard, CRON, OEM, TOAD, Sun
Solaris, Linux SUSE and Windows.
Lord Abbett, NJ Apr’04 – Jul’05
ORACLE DBA
Installation & Maintenance of Oracle 9i and creating database for all environments.
Refreshing the test database with production data periodically using exp/imp.
Involved in restore/recovery of the databases.
Configured Recovery Manager (RMAN) to implement backup methodology.
Developed the backup scripts for backing up the databases using RMAN.
Used STATSPACK for tuning the database performance and configured the initialization
parameters.
Worked on Object (Index, Table and Cluster) creation for different applications.
Used OEM for maintaining database users and administered their privileges using roles.
Wrote/Modified PL/SQL Procedures, Triggers and Packages.
Writing shell scripts to automate day-to-day database administration activities like
Monitoring the disk space, alert logs, and archive logs.
Assisted users with daily Oracle client related issues.
Provided 24x7 production/customer supports for database issues.
Oracle primary (carried pager) duty biweekly.
Wrote technical documentation and standard procedures.
Environment: Oracle 9i, PL/SQL, Shell Scripting, CRON, RMAN, OEM, TOAD, Sun Solaris and
Windows.
Bombay Stock Exchange, India Apr’03 – Mar’04
ORACLE DBA
Administered Oracle databases on both Windows and Sun Solaris servers.
Creating users, setting up profiles and administering their privileges.
Developed scripts and implemented physical (HOT and COLD) backups for the
databases.
Refreshed training databases at the beginning of each training batch.
Set up auditing and developed procedures to log statements issued by a specific user.
Validated production backups and cloned them into development environment.
Routine database Administration tasks including tablespace creation, creating roles,
granting privileges, auditing, upgrades etc.
Interacting with development teams on DBA related activities such as query optimization
and export/import.
Resolved performance issues with database and applications.
Environment: Oracle 9i/8i, PL/SQL, Exp/Imp, Shell Scripting, Sun Solaris and Windows.
Contact this candidate