Oracle Sql
Resume:
TARAKA VADDADI
Email: *******@*******.*** STATUS: US Citizen
PROFILE in BRIEF:
Oracle certified professional Over 17 years of experience in information
technology. Over Ten years of experience as Oracle Database Administrator
(DBA) for OLTP and Data Warehouse systems. Experienced with full life
cycle of Systems Analysis, Planning, Design, Implementation, Performance
Tuning, Backup and Recovery, Implementing Standby Databases, Golden Gate,
RAC ( Real Application Clusters), GRID, OEM and effective in core DBA
activities.
. Excellent working experience with FANNIE MAE, NADA, NEXTEL, MBNA BANK,
AT & T and MCI Word Com.
. Expertise in Installation, configuration and upgrades of Oracle 11g,
10g, 9i, 8i and 7x on UNIX and Windows platforms.
. Configuration, load balancing, backup and recovery, sizing and space
management, PL/SQL tuning, diagnostics and proficient with OEM tools.
. Expertise in RAC 11g installation, administration, production support,
configuration, upgrades, patches, space management, database security,
performance tuning, troubleshooting, Database Design and ASM on UNIX
and Windows.
. Extensive knowledge of Oracle Architecture, Data modeling,
Logical and Physical databases design using Erwin/Visio.
. Expertise including Backup and Recovery using RMAN and Scripts,
Performance Tuning, Migrating Oracle Databases to lower environments
and Maintenance. (24/7) Production on-call Support
. Implemented GoldenGate for replication solutions.
. Responsible for scheduling the batch jobs and monitoring the
jobs using OEM and cron.
. Experience in using OEM, TOAD, SQL Developer and performing data
migrations using Export/Import utility.
. Implemented automated backup strategy using the UNIX shell
script CRON UTILITY and RMAN
. Expert in SQL* Loader, export/import and data pump operations.
. Expertise in performance-tuning, SQL tuning services with EXPLAINS
PLAN, TKPROF, STATSPACK, SQL TRACE, AWR to collect and maintain
performance statistics and improve the database performance.
. Excellent knowledge in SQL, PL/SQL, Partitioning, Data modeling
with utilities like ER/Studio, OLAP, Logical and Physical Database
Design, Procedures, Functions, Packages, Database Triggers.
. Experience as On-Call 24x7 production DBA and
application/development DBA and Oracle Support processes for technical
requests through Meta link and other Support Procedures
. Experience in Java and automating routine tasks using HTML,
UNIX, Shell Scripting, Java Scripting.
. Excellent knowledge in C/C++, Pro*C, JAVA ( Servlets, JSP, JDBC
), java script, XML and HTML.
. Migrating Oracle Database to SQL Server DB and used SSIS for
ETL's.
Technical skills:
Database ORACLE 11g/10g/9i/8i and 7.x and SQL Server 2012
AS Architecture design, implementation and integrations.
11g R2 RAC: Deployment: Designed Multi Node 11g R2 RAC
system
Languages C/C++, Pro*C, SQL, TSQL, PL/SQL (Stored Packages &
Procedure, Functions, Database Triggers), JAVA (
servlets, JSP, JDBC ), UNIX Shell Scripts, AWK, Java
Script, XML and HTML
TOOLS Oracle11g/10g Oracle Data pump, SQL*Loader, RMAN,
GoldenGate, ASM, OEM, ERWIN, AWR,Oracle SQL Developer,
Oracle Data modeler, PL/SQL Developer, Informatica,
Oracle Warehouse Builder ( OWB), SQL Navigator, TOAD,
Visual Caf , Rational ClearCase ClearQuest, PVCS,
Sablime,CVS, Autosys and jobcontrol
Reporting Tools Oracle Discover and Business Objects
Hardware HP-9000, Sun Fire 6800/480, Sun Fire V490, Sun E6900,
IBM Power VM servers, EMC storage devices, Sun Store
Edge devices, Sun Cluster 2.2.
CERTIFICATIONS: Oracle Certification Professional (OCP) from Oracle Corp
& TRAININGS
Oracle10g PL/SQL programming.
Oracle 11g New Features
Oracle RAC 11g Deployment
GoldenGage
EDUCATION: Master's Degree, Computer Applications.
IMMIGRATION STATUS: US Citizen
Professional Experience:
NADA (National AutoMobile Dealers Association)
McLean, VA.
Oracle Database Administrator (DBA)
From Oct 2008 to Present
Environment: Oracle 11g/10g, SQL Server 2012, UNIX and Windows
As a DBA in NADA, I'm responsible for multiple applications and Oracle
database instances, the mix of 10g and 11g. Responsibilities includes
analyze, design, implement and maintain cost effective enterprise database
solutions to meet established hosted system architecture requirements for
availability, manageability, recoverability, monitoring, scalability,
security and reliability. Perform database administration on all database
systems. Optimize programming code for maintenance jobs and application
reporting tools. Develop and maintain database administration policies and
procedures. Prepare and perform database capacity studies and planning for
management review and approval.
Responsibilities:
. Lead task with projects capacity planning, database server design,
storage architecture, physical database design, backups & recovery
procedures, security schemes and Oracle upgrades.
. Involved in Application Performance tuning, Database Tuning, database
monitoring activities
. Designed, developed and implemented Multi node 11g RAC
architecture in data warehouse environment.
. Conducted code reviews and successfully implemented the development
standards that helped to improve the significant performance of NADA
applications.
. Implemented GoldenGate for replication solutions.
. Improved the application performance by optimizing SQL statements.
. Scheduling the ETL batch jobs using Cron and OEM.
. Implemented SQL Server 2012 and Migrated Oracle Database to SQL Server
Database.
. Developed SQL Server SSIS solutions to ETL processes.
. Managing the Users access.
. Creating procedures for database backups using Data Pump, Oracle RMAN and
Shell Scripts.
. Implemented Partitioning on large Data Warehouse tables for performance
and manageability.
. Excellent communication and interaction with business partners, vendors
and upper management.
. 24X7 on-call support to production systems. Involves trouble management,
crash recovery, hardware maintenance, space issues, patch fixes, HA
functionality verification, fix broken jobs etc.
FANNIE MAE, HERNDON, VA
Oracle Database Administrator (DBA)
Aug 2007 to 08/10/2008
Environment: Oracle 11g/10g, ERWIN, UNIX and Windows, Rational ClearCase
and ClearQuest.
Working as a DBA team member in HAMP DBA Support team of Fannie Mae.
Responsibilities:
. Creation and maintenance of production, development, system test and
integrated test environments.
. Refreshing the above databases from the backup of production
database.
. Implementing the backup and recovery for production database,
enhancements in the backup and recovery design, Design the backup and
recovery for implementation of application releases in Production etc.
. Monitoring the production system for performance, sga tuning, sql
tuning etc
. Co-ordination with the production dba to migrate the system into the
production, preparation of migration scripts, documents etc.
. Production support in terms of performance of the system,
troubleshooting the pl/sql code for optimization of the process
. Co-ordination with the team members to solve the production issues,
analyzing the existing process, revisiting the requirements with the
user/analyst group and re-tune the process
. Development of shell scripts, scheduling the jobs using Autosys and
jils
. Involved in Application Performance tuning, Database Tuning, database
monitoring activities, DB Capacity Planning, SQL Tuning, creating
roles, profiles, privileges and assigning roles to users.
. Improving the performance of the database by optimizing SQL
statements.
. Creating procedures for database backups and refreshing using EXPDP/IMPDP, Oracle RMAN and Shell Scripts.
. Implemented Partitioning on large tables for performance and
manageability.
. Excellent communication and interaction with business partners, vendors
and upper management.
. 24X7 on-call support to production systems.
. Developed the processes for data extraction, modifications and loading
using the UNIX Shell Scripts, SQL and PL/SQL to handle load process
requirements.
. Tuning the existing and new processes to minimize the process time.
. Fixing the data issues for UAT teams as per their requirements.
SPRINT NEXTEL, HERNDON, VA
Oracle DBA
From Nov '02 to July 2007
Environment: Oracle 10g/9i, UNIX Shell Scripting, SQL PL/SQL, Business
Objects, Sun Solaris and HP UNIX
Nextel has 46 terabytes of Data Warehouse with multiple data marts. The
main sources of this warehouse, are ENSEMBLE database (which is the third
party "AMDOCS" billing system), BCGI (Boston Communication Group Inc ) and
the internal systems.
As a Oracle DBA at Nextel Communications, VA. I am responsible for
Applications like Nextel Revenue Applications, Boost Mobile Revenue
Applications and other applications like Nextel Unbilled Revenue
Applications, GL Revenue Reporting, Sales Inventory, Auto Reporting, GL
Accrual Deferral, Reconcile, IMSI PTN sync up process, Altline and head
hock queries and 14 Oracle database instances.
Responsibilities:
. Creating the development and test environments using Oracle 9i/10g.
. Co-ordination with the production DBA team of EDS ( Third-party Prod
env maintenance team ) to migrate the system into the production and
preparation of migration scripts
. Involved in Application Performance tuning, Database Tuning, database
monitoring activities, DB Capacity Planning, SQL Tuning, creating
roles, profiles, privileges and assigning roles to users.
. Extensively used UNIX Shell programming for automating different
activities like planning of backup and maintaining archived data.
. Conducted code reviews with development teams and successfully
implemented the development standards that helped to improve the
significant performance of NDW applications.
. Interacted with senior management to help define the scope of the
project, and met with users to define the system requirements.
. Used oracle basic utilities like OEM for performance monitoring, and
TKPROF/EVENT Tracing for Tuning.
. As a production DBA involved in Oracle Server Administration, Advanced
Replication Server, Parallel Server, Multidimensional database,
Distributed Database system study, analysis, design, development,
testing and implementation with expertise in online transaction
processing and multi-user systems involving large and distributed
databases (DSS).
. Performed regular production database backup and recovery using RMAN
and EXP/IMP.
. Maintaining the deferent versions of the code in CVS and PVCS.
MBNA AMERICA, Wilmington, DE
Marketing Database DBA / Database Developer
From July '02 to Nov '02
Environment: Oracle 8I, UNIX Korn Shell Scripting, SAS, SQL PL/SQL and
SUN Solaris.
MBNA's Database Marketing is in the process of creating the next
generation database by utilizing the relational database oracle engine.
This database ( 3.6 terabytes ) is extensively used by the business
analysts, telemarketing, direct mail systems and business modelers (
groups ). The data is refreshed by different process like by daily, weekly
and monthly basis.
Responsibilities:
. Creating the development and test environments using Oracle 8i.
. Developed batch job script using UNIX Shell Scripts and SQL to handle
load processing requirements.
. Interacted with users for reporting requirements
. Supporting Production systems.
. Involved in Documentation of processes
. Involved in coding, PL/SQL, UNIX Shell Scripting
. Loading data from external files into database using SQL LOADER (
parallel loads and direct loads )
. Performance Tuning of SQL statements using SQL *Trace and Explain Plan
MCI World com, Chantilly, VA, USA.
NRM / NPAS Database Developer /DBA
From Nov '99 to Jun '02
Environment: Oracle 8i/7.3, HP Unix, Pro*C, PL/SQL, C++, Java.
1. Creation and maintenance of development, system test and integrated test
environments, refreshment of the above databases from the backup of
production database.
2. Implementing the backup and recovery for production database,
enhancements in the backup and recovery design, Design the backup and
recovery for implementation of application releases in Production etc.
3. Monitoring the production system for performance, SGA tuning, SQL tuning
etc
4. Co-ordination with the production dba to migrate the system into the
production, preparation of migration scripts, documents.
5. Production support in terms of performance of the system,
troubleshooting the pl/sql code for optimization of the process
6. Co-ordination with the team members to solve the production issues,
analyzing the existing process, revisiting the requirements with the
user/analyst group and re-tune the process
7. Designing the migration strategy from oracle 7.3 to oracle 8I,
introducing the new features of oracle8I like partitioning the database
objects, object oriented database design, parallelizing the queries etc.
8. Development of shell scripts, scheduling the jobs using cronjobs.
9. Assist to team members regarding all facets related to the database
systems.
10. Development of UNIX shell scripts to set up the batch jobs using cron
jobs.
11. Development of the process to monitor the application volume (using the
triggers) and generating the session reports, timings for each session,
application package being called etc.
AT&T - HERNDON, VA, USA.
ONS-OON, Sr. Database Developer
From Mar '98 to Oct '99
Environment: Oracle7.3, Pro*C, PL/SQL( Packages, Database Triggers
Functions/Procedures ), C, C++, UNIX shell scripts, Tuxedo, Sablime (
source code management system )
Responsibilities included:
. Collecting the user requirements and converting them into technical
specs.
. Requirement Study and Documentation of Data flow diagrams
. ER diagram preparation.
. Involved in coding, PL/SQL packages, functions, Database Triggers,
stored procedures,
. C/C++ and Pro *C to support enhancement of existing applications.
. 24*7 Production support of existing batch jobs
. Loading data from external files into database using SQL LOADER
. Performance Optimization using Explain Plan, SQL Trace, Optimizer Hint
etc.
. Extensively used crontab to automate tasks like removing temp files
. Involved in coding shell scripts using Korn Shell for executing and
running housekeeping jobs
Perot Systems, Reston, VA, USA.
National Car Rental, Senior Programmer
From Aug '97 to Feb '98
Environment: Oracle 7.1, Pro *C, C, PL/SQL, Oracle Forms4.5, Reports2.5,
Designer 2000, Unix shell scripts on Unix.
As a programmer I involved in developing a comprehensive OLTP application
for National Car Rental Company incorporating all the features of existing
enterprise applications. with an estimated 3300 end-user workstations.
Responsibilities included:
. Collecting business requirements from the users
. Design a module
. Preparing the Design documents
Involved in coding, PL/SQL packages, functions, Database Triggers,
stored procedures, C/C++ and Pro *C to support enhancement of existing
applications.
. Testing with Interfaces
. Coding and unit testing the modules
HCL Perot Systems, New Delhi, India.
Migration Methodology, Senior Programmer
from May '94 to July '97
Responsibilities included:
. Walk through the requirements
. Design the Generic Forms
. Coding the module using Oracle Forms4.5, Reports2.5, Designer 2000, Unix
shell scripts on Unix.
. Walk through the control flow of the forms
. Unit Testing
Contact this candidate