Oracle Manager
Resume:
Sarala Reddy
************@*****.***
Summary
* Professional, Technical and Enthusiastic person with 15 years of
experience as DBA Manager, Tech lead and Sr. database Administrator.
* Strong interpersonal communication, negotiation and leadership skills.
* Managed DBA team consists of both on-shore and off-shore members with
multiple platforms.
* Part of Management team who decides the technology direction at the
corporate level.
* Installed and configured RAC databases with Oracle 11g, 10g R2 with
ASM on IBM AIX and SUN and Linux nodes.
* Implemented and supported Peoplesoft Financial applications during
initial installation and also upgrading to higher versions.
* Led the DBA team in Disaster Recovery practices evaluation,
implementation and documentation.
* Supported mission critical applications in complex environments with
high quality deliverables.
* Hands on experience with Oracle Standby databases, Data Guard and
replication methods.
* Hands on experience with Oracle Spatial, Oracle Distributed and RAC
systems.
* Implemented and supported Oracle spatial and ESRI SDE spatial
applications.
* Supported Data Mart applications with Star Schema.
* Supported Business Intelligence project which used Informatica as ETL
tool and Cognos as reporting tool.
* Good knowledge on BMC Patrol DB Change Manager, Patrol Oracle KM,
AUTOSYS scheduler and Precise, TOAD tools.
* Participated in SOX related auditing and created procedures to make
sure that applications follow SOX rules.
* Tuned complicated data mart applications running on Oracle 9i taking
advantage of Oracle new features.
* Worked with cross functional teams in designing, implementing and
supporting complex applications in a wide variety of industries. As
part of understanding application, involved in database design at many
critical situations.
* Helped developers tuning sql and pl/sql procedures by suggesting
appropriate indexes and monitored applications using Confio, OEM and
associated tools.
Experience
DBA Lead (Jan 09-present), Tata Communications Ltd, NJ.
. Mentored junior DBA's at all levels of database architecture, tuning,
backup, recovery and automation technologies.
. Worked as a liaison between application teams and business leads and
translated the requirements to the technical team..
. Involved in Enterprise system architecture and deployments decisions
. Supported mission critical, highly visible RAC databases of 20TB with
high quality SLAs.
. Installed, Configured and Maintained Oracle 11g and 10g RAC databases
for mission critical applications on Linux and SUN and AIX nodes.
. Maintained Oracle E-business databases with AR, AP, GL modules
. Configured Oracle Grid Control to monitor mission critical databases.
. Created, Configured and Maintained 10g Standby databases using Data
Guard
. Led the DBA team in converting non RAC, non ASM database running on
SUN to Linux, RAC with ASM using Oracle cluster.
. Configured Oracle 10g R2 databases on Sun LDOM
. Configured Oracle 10g R2 database on AIX LPARs.
. Supported high transactional system on Sun cluster.
. Responsible for RMAN backup/recovery using Netbackup.
. Scheduled jobs through Appworx.
. Supported migration of Oracle database to Postgres Eneterprise DB . By
doing this I was able to bring down the IT overall cost significantly.
. Supported conversion of DB2 data warehouse database to Netezza.
Oracle Technical DBA Manager (Oct 05-Dec 08), Motorola, NJ.
* Managed a team of Oracle and DB2 DBAs.
* Installed and configured 11g and 10g R2 RAC databases for mission
critical telecom applications on AIX, SUN and Linux nodes.
* Configured RAC databases to use ASM as a storage management system
* Configured RAC databases to use Oracle Load Balancing techniques for
better scalability.
* Created Logical and Physical Standby databases to support DR and
uninterrupted application upgrades using Oracle Data Guard..
* Helped customers setup RMAN backups successfully on both RAC and non-
RAC databases.
* Implemented row level security to secure sensitive data.
* Converted non-partitioned tables to partitioned ones by using Oracle
online reorg tools to support 24/7 systems
* As part of DBA responsibilities, supported developers and helped them
in tuning the application code.
* Helped developers in identifying problems with sql, plsql code during
unit test, integration test and stress test cycles.
* Helped developers and testers in loading application data and
monitored application for problems, so it won't be a bottleneck when
it goes to production.
* Involved in Logical and physical design of the database.
* As part of the management team, involved in application Architectural
decisions to support 15 tera bytes of database.
* Created database standards and procedures document to support multiple
applications.
Lead Database Administrator (Nov 98 - Oct 2005), Chubb & Sons, NJ.
* Mentored junior DBA's at all levels of database architecture, tuning,
backup and automation technologies.
* Configured, upgraded and maintained Oracle 8i, 9i databases under Unix
platform taking advantage of Oracle new features. Converted all
dictionary managed table spaces to Locally Managed Table spaces.
* Created, Configured and maintained Standby database to support
replication between datamart and ETL databases using native Oracle
tools and Data Guard.
* Supported ODS and Datamart databases using Oracle 9i. Created and
maintained Materialized views and snapshot refreshes.
* Installed and applied Oracle CSS( Character Set Scanner for NLS
conversions) on databases and converted database character set
accordingly to support European Characters under Unicode architecture.
* Configured, implemented and evaluated Oracle Log Miner, Flashback
Query on Oracle 9i databases.
* Automated data transfer from one peoplesoft database to the other by
using Oracle Transportable table spaces, which reduced the copy time
tremendously.
* Configured, implemented and supported Peoplesoft 7.3 AP, AR
applications on Unix platform with Oracle Partitioning option.
Involved in problem resolutions through out the life cycle of the
project.
* Successfully implemented, automated and documented Oracle RMAN backups
using TSM Oracle TDP, with high quality recoverability. Successfully
implemented Standby database as a fail safe catalog database. Mentored
DBA team in understanding the details of the backup and recovery
process with and without catalog databases. Also helped them in
understanding overall architecture of TSM storage system including
configuration parameter files.
* Led the DBA team in Re-architecture of TSM. Participated in technical
discussions with CNT consulting group and TSM group at Chubb, impact
analysis on database backup/recovery system, impact on Chubb's overall
DR practices.
* Implemented and documented procedures for backing up UDB and Informix
databases directly to TSM and recovering to different node. Researched
extensively on TSM and UDB configurations to make this process
reliable and dependable.
* Supported Upgrade of Peoplesoft from 7.3 to 8.4. Involved in
evaluating upgrade process, SQR tuning, application performance
issues.
* Led the DBA team in evaluating and implementing HDS True Copy and
Shadow image systems for Enhanced Disaster Recovery. Participated in
technical discussions and implementation of HDS True Copy and Shadow
image systems. Created data integrity testing strategy for Oracle and
UDB databases, documented and coordinated testing with Unix and HDS
teams. Also worked with Unix team in implementing HACMP as a fail
over method for high availability.
* Implemented and configured Oracle native spatial database.
Participated in problem resolution with Oracle consultants and
application team at all levels. Also supported ESRI's spatial
application using SDEMON. Automated the startup of the deamon, as part
of the Operating system startup program.
* Evaluated Tivoli TEC and TBSM products for both Oracle and UDB
database monitoring. Also participated in evaluating REVIVIO product
as a DR/Problem Determination tool.
* Supported ODS and Datamart databases running on UDB v7 and v8. Helped
Cognos team in performance tuning evaluations and creating high
quality cubes.
Sr.Database Administrator (Feb 97 . Nov 98) Citibank, NJ.
* Installed and maintained Oracle 7.3 RDBMS, related support programs
and utilities in DEC alpha environment
* Installed and Configured Oracle Parallel database on 4 node SP2 AIX
4.1 MPP system to support the mortgage system.
* Created HSD's and VSD's on SP2
* Maintained SYBASE on SP2 AIX 3.2.
* Responsible for all database operations on Oracle OL TP an Oracle DSS
systems.
* Installed BMC Patrol and monitored databases(Sybase and oracle) and
operating systems(SP2 and DEC alpha}.
* Responsible for DR practices and backup/recovery of mission critical
applications.
Sr.Database Administrator (Aug 95 . Jan 97) J&J PRI, NJ. & NYNEX, NY
(Consultant)
* Installed and Maintained HP Chem and Chemstudy Software's.
* Participated in logical and physical design of the database for two
projects and supported programmers.
Database Administrator (Sept 94 - Aug 95), Neuman Distributors,Inc. NJ.
* Created and Maintained Multi division Distribured database with 3
nodes and 7 domains on RS 6000 running AIX
* Automated Data replication methods across network to allow location
transparency using Oracle snapshot utilities.
Engineer (Oct 87 - Aug 92), B.E.L, Bangalore, India.
* Worked on various projects and automation processes.
Education
M.S Computer Science (Spring'94), Monmouth College, New Jersey.
B. E Electronics & Communications (1987), U.V.C.E. Bangalore University,
India.
Contact this candidate