Oracle Sql
Resume:
Prashanth Paladi
abhc72@r.postjobfree.com
Oracle DBA
Summary
. Oracle Database Administrator with 7+ years of experience in
Installation, configuration, upgrade/migration, Administration, Backup
and Recovery, Maintaining and Tuning of Oracle RDBMS.
. Experience in supporting Oracle Databases 8i/9i/10g RAC/11g RAC in
variety of different environments including Unix, Sun Solaris, IBM-
AIX, HP-UX, RedHat Linux, Microsoft Windows 2000/NT Servers including
Disaster Recovery, High Availability Solutions (RAC & Data Guard) and
Backup & Recovery.
. Extensive expertise in Oracle Architecture, I/O tuning, Capacity
planning, space management, Memory Tuning, Performance Tuning,
Backups, Recoveries, RMAN backups, Oracle streams, Optimization,
Networking, Troubleshooting.
. Experience in Oracle Enterprise Manager (OEM) Grid Control, Oracle
Goldengate, TOAD, RMAN.
. Experience in installing Oracle patches, Migration of database across
different platforms and Cloning/Data Refresh from production
environment to setup test and development environments.
. Proven ability of providing production support for 24X7.
. Proficient in all DBA responsibilities such as Instance tuning, user
management, space management, monitoring.
. Migrated single instance databases to multimode 10g RAC, 11g RAC
environment for High Availability and Load Balancing.
. Experience in capacity planning and benchmarking.
. Installed, configured and maintained ASM enabled RAC and single
instance databases.
. Experienced in Monitoring/Analyzing performance periodically and to
tune, debug and optimize the databases, applications, SQL, and PL/SQL
code from time to time.
. Excellent working knowledge in logical backups, Hot/Cold Backup, RMAN
incremental backups, and Recovery .
. Cloning of databases using Recovery Manager and manual method.
. Excellent experience in performing Point-In-Time Recovery.
. Delivering SQL and Database performance tuning services via V$/GV$
views, Explain Plan, TKPROF, AWR (Statspack) reports, ADDM, SQL Tuning
Advisor, SQL Access, Oracle Enterprise Manager (OEM), Grid Control.
. Experience with SQL, PL/SQL coding, stored procedures, triggers,
functions, packages, UNIX Shell Scripting, Partitioning, Indexes,
ERWIN Data modeling, Logical and Physical database design.
. Experience with Flash-Back Recovery, Datapump, ASM, ASH, AWR, ADDM,
ASSM, ASMM, Automatic Undo management, Grid Monitoring and Recycle
Bin.
. Experience in range, hash, list, interval, system partitioning and
BITMAP, B-Tree Indexes, Composite indexes.
. Ability to work on own initiative and as a part of team. Excellent
verbal and written communication skills. Willingness to learn new
technologies, openness to new ideas and ability to learn very quickly.
Education
. Bachelor of Technology from JNTU, INDIA
Technical Skills
Operating System : RedHat Linux 4.x, 5.x, AIX 5.1, 5.2, 5.3,6.1, Sun
Solaris 8,9,10, HP-UX
10x,11.x, Windows NT/2000/XP/Vista.
Databases : Oracle 11g RAC, Oracle 10g RAC, Oracle 9i,
Oracle 8i, Oracle 7.3
DBA tools : SQL Navigator, SQL*Loader, SQL *Plus, OEM, Grid
Control, RMAN,
Golden Gate, DBCA, DBUA, Data Pump,
Oracle Streams, Toad, Data
Guard, Export / Import, TKPROF,
STATSPACK, EXPLAIN PLAN, AWR,
ADDM, ASH.
Languages : SQL, PL/SQL, C, C++, UNIX Shell Scripting, Core
java.
Web : ASP.NET, HTML, XML, Dreamweaver.
Work experience
Verizon Wireless, Irving, TX
Dec 09-Present
Sr.Oracle DBA
Responsibilities:
. Responsible for 24 X 7 Production database administration, support and
monitoring.
. Installation, configuration and administration of Oracle 10g RAC, 11g
RAC databases for High Availability and Standby Databases (Data Guard)
for Disaster Recovery and reporting purpose.
. Monitoring the Database performance, scheduling backups, disaster
recovery and managing user/ application team requests.
. Applying the database patches, upgrading to higher database versions,
installing the client and other database software.
. Provided On Call support for all the application databases to resolve
any Tablespace, database performance, locks, file system issues and
etc.
. Used Data pump for exporting/ importing the data, metadata and
complete database.
. Worked on migration of a single instance database to the RAC
environment
. Database performance monitoring and tuning using STATPACK, TKPROF, SQL
Trace, Explain Plan, AWR.
. Constantly monitoring the database using Grid Control, SGA parameters,
alert logs, trace files to identify any potential problems and resolve
them before they cause any serious or fatal issues on the database.
. Created disaster recovery procedures and performed Backup/recovery.
. Installed and configured GoldenGate
. Monitoring the Oracle Instances, Users, Tables, Tablespaces, Memory
structures, and Rollback segments, Redologs, Archived Redologs and
Alerts.
. Responsible for capacity planning, database security, recovery
planning and installing patches
. Responsible for implementing backup procedures using RMAN. Responsible
for creating RMAN catalog Database and Registering the Databases in
Catalog Database. Implemented strong backup and recovery strategies
and monitored backups.
Environment: Oracle 10g RAC/11g RAC/9i, HP-UX, Sun Solaris, IBM AIX, RedHat
Linux, Oracle Enterprise Linux, RMAN, ASM, AWR, ADDM, PL/SQL, SQL*Loader,
TOAD, Data Pump, OEM GRID Control, GoldenGate.
EDD, Sacramento, CA
Aug 08-Dec 09
Sr.Oracle DBA
Responsibilities:
. Responsible for 24 X 7 Production database administration, support and
monitoring.
. Installed, configured Oracle Real Application Clusters (10g RAC/11g
RAC) and Standby Databases (Data Guard)
. Developed RMAN scripts for backup and recovery of databases.
. Database Design, Schema Design, Performance Monitoring, Tuning.
. Backup/Recovery Setup (Daily, Weekly, Monthly)
. Support of production Database Problems 24X7
. Write monitoring/health check scripts to alert team of database
uptime/downtime status, sizing issues, which ensured availability
99.98% of the time.
. PL/SQL Programming in developing automatic partition management.
. Frontline customer support.
. Perform capacity planning and space management.
. Created disaster recovery procedures and performed Backup/recovery.
. Installed, migrated, supported Customer Databases onsite and remotely.
. Managing Replication with Oracle Golden Gate.
. Monitoring of Listener and TNS names.ora files and storage space for
better performance.
. Worked on import/export, export datapump/import datapump and SQL-
loader.
. Database design Data modeling, Schema design using ERWIN, Schema
design and scripting, dynamic schema generation.
. Performance planning and solution implementation to handle high-speed
and high volume data.
. Migration of data from SQL Server 2005.
. Worked on performance tuning of SQL and Procedures and packages.
. Created Cron jobs in production to automate repetitive tasks
. Administer, maintain, develop and implement policies and procedures
for Managing DB Security and Auditing.
. Resolve database performance issues, database issues
Environment: Oracle 10g RAC/11g RAC/9i, HP-UX, Sun Solaris, RedHat Linux,
Oracle Enterprise Linux, Windows, SQL Server, RMAN, ASM, AWR, ADDM, PL/SQL,
SQL*Loader, TOAD, Data Pump, OEM GRID Control, GoldenGate.
Countrywide Home Loans, Dallas, TX
Feb 07 - Aug 08
Sr.Oracle DBA
Responsibilities:
. Provided support for both the Production and Development databases on
24*7 basis with on-call pager.
. Involved in support for Multi Node RAC database.
. Installation of 10g RAC databases.
. Daily Health check of database using STATSPACK, AWR, ADDM.
. Cloning of Oracle Databases from Production to Development and Test
environments.
. Upgrading of Oracle Database from 9i to 10g and applying patches when
required.
. Resolving Performance issues.
. Setup periodic backups of the Database.
. Refreshing of database from Production to Test and Development
environment.
. Setup stand by database (Data guard) for high availability/disaster
recovery purpose.
. Loading data from flat files using external tables and SQL Loader.
. Developing Disaster Recovery plan.
. Developed Scripts for backups, cloning, Startup and Shutdown of
databases, Analyzing Tables and Rebuilding of Indexes for better
performance,.
. Monitoring and Troubleshooting issues.
. Recovery of database from Media failure and Block corruption.
. Management of schemas, objects partitioning the tables & indexes.
. Scheduling of jobs.
. Responsible for optimizing the queries and application tuning.
. Monitoring and tuning system resources related to database performance
issues
. Setup Automatic Storage Management.
. SQL scripts to monitor tablespaces and extent growth.
. Creating and maintaining Big file Table Spaces.
. Experience in maintaining database security using security compliance
auditing.
. Setting up and Managing Flash Recovery Area.
Environment: Oracle 10g RAC, 9i,8i, Sun Solaris, IBM AIX, RedHat Linux,
Windows, RMAN, ASM, AWR, ADDM, PL/SQL, SQL*Loader, TOAD, Data Pump, OEM
GRID Control.
Standard Chartered Bank, Hyderabad, India
May 05 - Jan 07
Oracle DBA
Responsibilities:
. Part of 4 member DBA team for 24x7 supports of 9i production,
development databases.
. Installing Oracle 9i, 10g RAC.
. Performed backup and recovery using RMAN.
. Monitoring performance and tuning the database.
. Maintaining database security by creating roles, privileges, quotas
and passwords.
. Creation of database objects.
. Involved in Database Capacity Planning and Security Management.
. Documenting all Oracle database operations and training of backup
personnel.
. Transfer of data from one database to another using export/import
(exp/imp).
. Monitoring the performance of database and viewing alert log.
. Creating hot and cold backup scripts to automate backup procedures.
. Providing support to end users and developers.
Environment: Oracle 10g RAC, 9i,8i, Sun Solaris, RedHat Linux, Windows,
RMAN, ASM, AWR, ADDM, PL/SQL, SQL*Loader, TOAD, Data Pump, OEM GRID Control
Bajaj Allianz Life Insurance, Hyderabad, India
Jan 04 - May 05
Junior Oracle Developer/DBA
Responsibilities:
. Maintaining Oracle databases
. Provided 24x7 supports when required.
. Involved in the installation of Oracle 8i,9i,10g
. Monitoring the growth of the database.
. Involved in creating the backup and recovery procedures.
. Diagnose and Troubleshoot Database Problems and failures.
. Involved in tuning the database to increase the response times.
. Created materialized views, Database links, tables, synonyms, for
replication.
. Created database objects, imported database objects which have been
either truncated or dropped by accident.
. Management of table space growth, monitoring data file additions.
. SQL, PL/SQL Programming. Written PL/SQL functions, procedures,
packages and triggers.
Environment: Oracle 10g, 9i, 8i, 7.3 Sun Solaris, RedHat Linux, Windows,
RMAN, PL/SQL, SQL*Loader, TOAD, Data Pump
Contact this candidate