Oracle Database
Resume:
Channab Astagi
TECHNICAL SUMMARY
. 15 years technical experience of which almost 10 years as database
administrator/architect.
. Experience as Lead Oracle DBA on various Oracle versions (7, 6i, 9i,
10g, 11g) on Unix (Sun Solaris, AIX) and Linux platforms.
. Experience in the US includes DBA responsibilities for AT&T, Sprint,
Bellsouth and Nextel.
. Extensive experience in PL/SQL coding and debugging
. Experience in implementing advanced Oracle database Features -
Partitioning, Materialized views, RMAN etc.
. Experience in Implementing and maintaining Data Guard, Streams and RAC
for designing and implementing High Availability (HA) and Disaster
Recovery solutions
. Administering 24/7 production databases, hot backups and recovery
situations.
. Managed a team of 15 DBAs for Design, Development and Production
support
. Administering and implementing Data warehousing databases.
. Monitoring and tuning of Oracle Databases.
. Designing and implementing application security, database security.
. Logical and physical modeling with Erwin, Toad
. SQL, PLSQL, UNIX Shell Scripting and Oracle utilities exp/imp, Sql
loader
. Backup and recovery using SQLBackTrack tool
. Planning and Implementing Data Base Re-org
. Implementation experience on Golden Gate solution for AT&T
. Assisting team member in resolving technical Issues
. PMP Certified and experienced in Project Management
EDUCATION
Bachelors in Electronics and Communication Engineering
College of Engineering, Gulbarga, India, 1992
Certifications
. Oracle Certified Professional DBA
. PMP Certified
. ITIL and ITSR Certified
Environment
SUN Solaris 2.6/2.7, HP-UX 10.20,HP-UX 11.0, AIX3.2 and 4.2, Windows
-NT/2000, LINUX 6.2,Windows NT, Weblogic
LANGUAGES
SQL/PLUS, PL/SQL, Unix shell script, Fortran, C, C++, Assembly Language,
Java, JDK 1.2
PROFESSIONAL EXPERIENCE:
Accenture Feb 2006 - June 2010
Client: AT&T, Atlanta, GA
Senior Data Base Administrator May 2009 -
June 2010
Handled 4-node RAC Siebel Production database, which is used for telecom
ordering system for Telstra involving 3 terabyte of database on an EMC disk
array. Post implementation support and planning of enhancements for major
and minor application releases. Apart from this, I had additional
responsibilities to support Kenan billing (22 databases), a 3-Node RAC for
Online Billing (OLB) and Tibco Integration database.
Responsibilities:
. Maintain and support 4 critical application databases starting from dev,
test and prod
. Handled High Availability application database and met most of customer
SLA with respect to database availability
. Handled 24*7 production database
. Planned and implemented re-org on various databases
. Used ERWIN for Logical and Physical database Modeling, and UML
methodology and Use Case design approach using Rational Rose Unified
Process.
. Physical Database capacity planning and data-files mapping. Database
schemas creation based on the logical models.
. Disk space management & monitoring of top process, memory utilization
system load. User creation, & permission granting.
. Oracle Server software installation and configuration. Implementation of
Oracle Advanced replication environment and mechanism. Multiple Database
environments over multiple platforms.
. Design and implementation of backup and recovery strategy using tools,
such as Veritas Netbackup and RMAN.
. Identified problem queries and created stored outlines where ever
feasible
. Assisted Data Warehousing team to design ETL (Datastage) from Oracle
databases supported by my team
Senior Data Base Administrator Feb 2006 -
April 2009
Handled very critical 3 plus TB 24*7 production database support, and
played major role in data migration project form Oracle 8i to 10g.
Responsible for meeting customer SLA with respect to database availability.
Automation of database monitoring scripts, planning and implementing
regular re-org activities interacting with customer to discuss on ongoing
issues and agree upon time-based action plan. Apart from this, I had
additional responsibilities to support AT&T's EDW (Enterprise Data
Warehousing) and ODS (Oracle 11g), which comprised of five large databases.
Handled independently 50 plus databases starting development, testing, pre-
prod, performance and production
In addition, I was responsible for the design and implementation of
Database for AT&T wireless e-commerce site (http://www.bellsouth.com/) and
post-implementation support and planning of enhancements for this ECommerce
application.
Responsibilities:
. Install OS, Web Servers, Software and Patches on Sun Servers.
. Design and capacity planning of migrating project from 8i to 10g along
with associated application interfaces.
. Used ERWIN for Logical and Physical database Modeling, and UML
methodology and Use Case design approach using Rational Rose Unified
Process.
. Physical Database capacity planning and data-files mapping. Database
schemas creation based on the logical models.
. Implemented Golden Gate
. Disk space management & monitoring of top process, memory utilization
system load. User creation, & permission granting.
. Oracle Server software installation and configuration. Implementation of
Oracle Advanced replication environment and mechanism. Multiple Database
environments over multiple platforms.
. Design and implementation of backup and recovery strategy using tools,
such as Veritas Netbackup and RMAN.
. Support and manage database activity during the development cycle.
. Support Oracle CRM product (ver 11.5.4); this application handles around
25,000 orders per day for a ATT project.
. Performance testing and tuning, capacity planning, and database
monitoring.
. Develop PL/SQL code; Ensure PL/SQL performance tuning and code
optimization.
. Debug and deploy Java application on development and testing environment
. Create and maintain the Data Model and physical integrity of the
databases.
. Technical assistance and guidance to the development group.
. Help development team in migrating Oracle Application ordering workflow
to sterling DOM workflow with respect to database.
Technologies: Oracle 11g/10g/9i/8.1.7, Sun Solaris, ERWIN, Veritas, RMAN,
PL/SQL, Oracle CRM, PL/SQL, Java, Weblogic
IBM Global Services Dec 2004 -
Jan 2006
Client: Sprint, Dallas, TX
Senior Database Administrator
Lead DBA for Sprint Telecommunications.
Responsibilities for providing maintenance and support of over 150 Oracle
databases for Production, Operations Support, Development, Test and
Training. The team comprised of 5 members who were responsible for
maintaining all these different environments and coordinating with the
Application Support group for various new releases planned from the Oracle
database up-gradation, OS migrations or Application releases. The Team also
provided 24X7 support by being On-Call to support all Production
environments.
Responsibilities:
. Extensive knowledge on Cloning/refresh
. Writing Shell scripts to pro-actively monitor the database for space,
Table space Fragmentation, data files status and mount points space
checking.
. Backup and restoration planning
. Performance Monitoring and Tuning the databases based on the inputs
from the application team.
. Monitoring Backups logs daily.
. Refreshing schemas in development and Testing environment from
Production before any new Release.
. Participating in Migration activities from DBA aspects.
. Typical DBA activities including extending the database storage
capacity by creating new table space, adding data files to table
space; creating users and roles for privilege management; managing the
table space to reduce I/O contention & table space fragmentation;
creating database triggers and procedures, etc.
. Design and implementation of new databases
Initial build, script development and maintenance
Creation and maintenance of test schema
Development and Test database refresh from production
Implementation of code changes
. Database migration Oracle 8i to 9i.
Reverse engineering of all database objects.
Schema comparisons via TOAD.
Optimization of long-running processes by parallel processing.
. Support
Troubleshooting and 2nd-level support for OS and database application
issues.
Provided 24*7 support to 7 application databases
Backup and recovery via RMAN scripts and troubleshooting.
Monitoring of Oracle database; automated error notification.
Managing backup through Sql Back Track Tool.
SQL statement analysis and tuning
Technologies: Oracle database 8i/9i, Sun Solaris, HP-
UX, Linux
Associated Cement Companies Ltd. (ACC) Oct
2000 - Nov 2004
Systems and Database Administrator
Responsibilities:
. Responsible for designing, configuring, and maintaining several
company-critical systems and databases including Solaris 7/8/9
servers and Oracle 8i/9i databases.
. Production, development, test and pre-production environments.
. Setup, configuration, upgrades and maintenance of Oracle databases
while maintaining a 99.9% uptime guaranty.
. Maintained, configured and supported customized application databases
running on Oracle back end with forms 6i as front end.
. Planned, setup and maintained an Oracle Database for Integrated Material
Management, Cement dispatch section and Payroll system.
. Designed and Implemented Oracle 8i database for Raw Material System for
cement manufacturing company, actively involved in resolving performance
issues along with development team.
. Independently setup Oracle Databases, planned and Implemented daily
backup,
.
Technologies: Solaris 7/8/9 servers, Oracle 8i/9i databases
Father Angels Technical Institute, Mumbai, Sep
1997 - Oct 2000
System Analyst
. Designed, developed Oracle based Examination result processing System.
The system had 750 tables and 1950 stored procedures, among
others.(Oracle 7.3 and D2K)
. Researched and led the team on migration of data from old Foxpro data to
Oracle database.
. Developed Payroll processing system, which takes care around 500
Employees monthly payroll.
. Used to conduct classes to Advanced Diploma in Computer system software
administration and Application (ADCSSA&A) students on RDBMS and Oracle
Database
. Designed and developed Agnel ITI students merit selection system.
Technologies: Oracle 7.3, Fox Pro, Power Builder
VIKRAM ISPAT Oct 1995 - Sept
1997
Programmer
Integrated Material Management System using FoxPro (Duration: 15 months,
Team size: 3).
Payroll System using FoxPro (Duration: 9 months, Team size: 2)
Development of Modules in the areas of Modvat Item Inventory, Invoicing,
Maintaining Contractor (Labor & Piece Rate) Data, and HRD Training Module.
Delivered computer training to different department staffs.
Technologies: Fox Pro, Oracle 7, SCO Unix
AMEX Computer and Services Pvt. Ltd. Oct 1993 -
Sept 1995
Programmer
Material Management System for Metacaps Engineering Pvt. Ltd., Mumbai City
using IBM Compatible PCs and FoxPro 2.5 (Duration: 11 months, Team size:
2).
Inventory System for Lloyds Steel Industries Ltd., Mumbai City using IBM
Compatible PCs and FoxPro 2.5 (Duration: 11 months, Team size: 2).
Oracle Project at Syspro Software Services Ltd: Spares Analysis using IBM
Compatible PCs and
Technologies: Fox Pro, Oracle 7, Unix, Windows
Contact this candidate