Sql Server Oracle
Resume:
Miss. Poonam Rane
Email id: *******@*****.***
Phone: 006*-****-****
Summary
. Having 4.7 years of overall experience and 3.5 years of relevant
experience as Production Support DBA supporting Oracle, SQL, DB2 and
Sybase Technologies over UNIX and Windows Platform in Production,
Test, Development Environment.
. Currently working as Database Analyst for Production support
supporting oracle, SQL DB2 and Sybase Technology over 24*7 support
with Barclays Capital.
. Inclination towards holding more responsibilities
Objective
To work in a demanding and responsible position applying my Knowledge and
skills as a DBA and skillfully accomplish projects involving Database
management with an extensive use of Oracle technology.
Strengths
I have been an avid reader and learner of the people, process and the
technology. In addition, my commitment to job and Problem solving skills is
an asset. These qualities augment my abilities to perform well at work. I
have been very flexible, quick in learning new skills, Self-motivated, Good
Team Motivator, Excellent written and verbal communication skills and
strong team player.
Achievements
. Successfully migrated the World Bank Project on database front from US
to India within 3 months time frame and stabilized the project while
setting up offshore support in India (Pune and Chennai) to gain client
confidence and good reputation for the company. Have received many
client appreciations for exceeding expectations and overall
management.
. Successfully coordinated and achieved milestone as set by client in
various events.
. Production Database Recovered in World Bank reducing downtime for LSR
Application
. Database Migration Done from Oracle 9i to Oracle 10g
. Oracle OEM installed in Production to monitor database
. Implemented various automation script to improve the environment
. Standby Database Created for all critical Production Databases.
. Proposed various solutioning including RAC, Database segregation, DR
Setup to improve the production environment
. Cross trained team mates and trainees on SQL, Sybase in addition to
Oracle
Technical Skills
Operating Systems AIX - 5.3, Red hat Linux - AS2.0,
Solaris,Hp-Unix, Windows NT / 2000/2003,
Win2k Server and Win2k3 AD
Protocols TCP/IP, SNMP, SSH, FTP and Telnet
Databases Primary Domain: Oracle (version Oracle
8i,9i,10g)
Secondary Domain: SQL Server (2000 and 2005)
Tertiary Domain: Sybase (v 12.5), DB2
Oracle Database Utilities DBCA, Oracle Net Manager, OEM, EXPDP/IMPDP,
RMAN, Exp/imp, Tkprof, Lsnrctl, SQL*Plus,
TOAD, DB Artisian, Opatch, ASM, SQLLoader,
Statspack, AWR
Backup Technology Galaxy, TSM
Programming Shell, HTML
Remote Administration Terminal Service, SSH & Telnet
Tools
Hardware and Networking CCNA, A+, N+
Education Details
Bachelors of Engineering (Electronics and Telecommunication), University of
Pune, 2005 (Full-Time) ~ First Class
Masters of Business Administration (Information Technology), ICFAI
(Distance Learning) ~ Pursuing
Certification
. HP-Unix CSA Certified ( 11v)
Professional Experience
Duration Organization Location Designation Technology/Skills
March 2010 - Till Barclays Capital Singapore Database Analyst Oracle,SQL,Sybase,DB2 on Unix & NT
Date
July 2007 - March Mphasis an HP India, US Associate Oracle, SQL, Sybase on Unix & NT
2010 Company Infrastructure
Engineer
Dec 2006 - July Saraswat Infotech India Trainee Oracle, HP-Unix
2007 Infrastructure
Engineer
Sep 2006 - Dec Jetking India Technical Electronics, Hardware, Networking
2006 Technologies Instructor
Sep 2005 - Sep Rane Investment India Trainee Sales Marketing
2006 Firm Executive
Project Profile
1.Barclays Capital (Singapore)
March 2010 - Present
Database Administrator (Analyst) ~ Oracle, SQL, Sybase, DB2
Client Barclays Capital (Singapore)
Domain Banking
Role Database Administrator (Analyst)
Team Size 17
Employer Barclays Capital (Singapore)
Period March -2010 - Till Date
Database SQL Server 2000,2005,2008, Oracle 9i,10g,11i, Sybase,
DB2
Environment Operating System - Solaris, Red Hat, Windows
RDBMS - Oracle 8i,9i,10g,SQL Server 2000, 2005,
2008,Sybase 12.5v, DB2
Tools : DBCA, Opatch, EXPDP/IMPDP, OEM, RMAN, ASM, Db
artesian, Toad, Galaxy, Sybase Central, SQL Server
client, TSM, Autosys, WebTop
High Availability: Data Guard, Oracle Flashback
Activities:
. Supporting all critical production database instances globally for
Oracle, SQL, DB2 and Sybase to ensure good health and smooth functioning
while meeting the stringent SLA requirements.
. Following the incident and change management process.
. Monitoring and maintaining all backup jobs including RMAN, native, TSM
jobs
. Monitoring and maintaining replication and DR site for oracle, SQL and
Sybase
. Taking care of change requests and incidents.
. Proactively monitoring the database's health and taking preventive or
corrective action as required.
. Monitoring the scheduled jobs like (Backup, Statistics building) and
troubleshooting
. Proactively monitoring the database's health and taking preventive or
corrective action as required.
. Monitoring and tuning the performance of the database for all 3 RDBMS
. Managing the incident using the trouble ticket system and updating the
knowledgebase for resolving known errors.
. Taking care of weekly maintenance jobs
. Using TSM for backup purpose
. Documentation
2.International Finance Corporation( World Bank Group) ~ US, India
March 2008-March 2010
Team Lead for DBA ~ Oracle, SQL, Sybase
Client International Finance Corporation( World Bank Group)
Domain Banking
Role Team Lead for DBA
Team Size 7
Employer Mphasis an HP Company
Period March-2008 - March 2010
Database SQL Server 2000,2005, Oracle 9i,10g,11i, Sybase
Environment Operating System - AIX 5.3,Red Hat, Windows
RDBMS - Oracle 8i,9i,10g, SQL Server 2000, 2005,
Sybase 12.5v
Tools : DBCA, Opatch, EXPDP/IMPDP, OEM, RMAN, ASM, Db
artisian, Toad, Galaxy, Sybase Central, SQL Server
client
High Availability: Data Guard, Oracle Flashback
Activities:
. Managing offshore team and having client interaction
. Installing Oracle client/server, Grid, SQL Server 2000, 2005 software
and applying Patch
. Making database backups (Logical and Physical) and performing restoration
and recovery
. Data Refresh from Production to lower environment in Oracle, SQL and
Sybase.
. Performing upgrades of the database and software to new release levels.
. Monitoring and tuning the performance of the database.
. Managing users and security by creating roles and profiles.
. Managing schema objects, such as tables, indexes, and views
. Automating jobs via scripts
. Database auditing
. Data Load in Production
. Materialized view refresh
. Executing requests from developer
. Creating standby database and having periodical switchover activity
. Monitoring the alert logs for any errors and warnings and provided
corrective action if required.
. Monitoring the scheduled jobs like (Backup, Statistics building) and re-
running incase of failure.
. Proactively monitoring the database's health and taking preventive or
corrective action as required.
. Monitoring and tuning the performance of the database.
. Managing the incident using the trouble ticket system and updating the
knowledgebase for resolving known errors.
. Documentation of the Implementation
3.Embarq ~ India
July 2007 - March-2008
Database Administrator ~ Oracle, SQL
Client Embarq
Domain Telecommunication
Role Database Administrator
Team Size 7
Employer Mphasis an HP Company
Period July 2007 - March-2008
Database SQL Server 2000,2005, Oracle 9i,10g
Environment Operating System - Sun Solaris 5.9,Red Hat, Windows
RDBMS - Oracle 10g RAC, SQL Server 2000
Tools : DBCA, Opatch, EXPDP/IMPDP, OEM, RMAN, ASM
High Availability: RAC, Data Guard, Oracle Flashback
Activities:
. Setting up RAC environment
. Installing Oracle and SQL software
. Making database backups (Logical and Physical) and performing restoration
and recovery when necessary
. Performing upgrades of the database and software to new release levels.
. Monitoring and tuning the performance of the database.
. Managing users and security by creating roles and profiles.
. Installing Patches
. Installing and setting up Grid
. Documenting the process
. Monitoring the alert logs for any errors and warnings and provided
corrective action if required.
. Monitoring the scheduled jobs like (Backup, Statistics building) and re-
running in case of failure.
. Proactively monitoring the database's health and taking preventive or
corrective action as required.
Contact this candidate