Oracle Sql
Resume:
SHAIK
******@************.***
SHAIK
Professional Summary:
Over 7 years of experience as an Oracle DBA in very large Production, Test,
Design and Development environments in diversified domains.
. Experience in Database Design, Database creation, Oracle Server
Installations/Upgrades/Patches, Capacity Planning, Backup &
Recovery, Disaster Recovery, Performance Tuning.
. Experience in configuration, implementation of Oracle 10g RAC/11g
RAC.
. Experience in Multi Node RAC cluster design, administration and
support.
. Experience in installing, configuring Oracle Fail safe.
. Experience in Oracle 9i, Oracle 10g, Oracle 11g software
installation and configuration and cloned Oracle Databases for
development and testing.
. Experience in design and implementation of Backup & Recovery
procedures and used new features/technologies to optimize system
maintenance and extensive knowledge on Partitions and Oracle
Streams.
. Proficient in implementation, maintenance of Database Security
(Users, Roles, Privileges), space management of logical structures
(i.e. table spaces, rollback segments) and responsible for setting
and managing user accounts, granting required privileges to users.
. Proficient in using Oracle utilities like export/import Data Pump,
Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM.
. Experience in optimization and tuning SQL queries using SQL_TRACE,
TKPROF, EXPLAIN PLAN, STATS_PACK, and AWR. Customization and
development of Korn shell scripts.
. Experience in the management of schemas, de-fragmentation and
partitioning the tables & indexes to improve the performance.
. Experience in managing Very Large OLTP and Data warehouse databases
of size multiple TB
. Experience in Oracle Admin Server and in upgrading databases to
Oracle 10g, Oracle 11g.
. Proficient in SQL, PL/SQL programming and performing SQL tuning and
assist developers with coding PL/SQL.
. Experience in using RMAN for Backup and Recovery. Experience in
designing and implementing Hot, Cold and Logical backup plans.
. Knowledge on Oracle Support processes for technical requests with
Metalink.
. Result oriented, self-motivated, Team player, ability to work
independently.
. Excellent analytical and problem-solving skills and excellent
written and verbal communication skills
Technical Skills:
Databases : Oracle 11g R2 RAC, 10gR2RAC, 9i, 8i, 8.0
Operating Systems : HP-UX, Sun Solaris, AIX, Linux and Windows.
Languages : SQL, PL/SQL, Java, C, UNIX Shell Scripting.
Tools : RMAN, OEM, SQL*Loader, Data Pump, TOAD, GoldenGate,
Share Plex, Tuning Tools
: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, OEM Grid Control
Data Modeling : Erwin, DB Artisan, Rational Rose, Informatica
Other : EMC, Net App, VERITAS
Education: Bachelor of Engineering Osmania University.
Professional Experience:
DST Systems Inc, Kansas city, MO
Aug 2010 - till date
Sr. Oracle DBA
Responsibilities:
. 24x7 Production database administration support.
. Installation and Configuration of Oracle 10g/11g Database on AIX,
Sun Solaris and Linux based systems.
. Installed, configured and administered Oracle 10g RAC/Oracle 11g
RAC
. Installed, configured and administered Automatic Storage Management
(ASM)
. Administered and managed Production, Test, and Stage and
Development databases involving various types of applications.
. Administered Data Warehousing environments and OLTP applications.
. Highly involved in performance tuning based on type of applications
(data warehousing and OLTP).
. Monitored and maintained databases with sizes ranging from few
hundreds of GB to TB's .
. Installed and configured Data Guard using physical and logical
standby for high availability and reporting purpose.
. Worked on shell scripts to monitor statistics, backups, and DB
checks.
. Implemented Oracle Streams 10g to capture, propagate, and apply the
transfer of data, transactions, and events within managed
databases. Replicated in OLTP as well as data warehouse
environments.
. Review database environments, such as database settings, monitoring
oracle user processes.
. Working knowledge in Oracle Grid control. Maintaining the grid
control alerts, configuring the rules, notifications, setting up
metric settings, blackouts, advisors (Segment Advisor, SQL Tuning
Advisor, Memory Advisor, SQL Access Advisor), and administration
and performance tuning of databases and servers.
. Upgradation of databases from 9i to 10g, 10g to 11g and 9i to 11g.
. Partitioned large tables to get the better performance and
manageability.
. Working Knowledge on AWR, ADDM, EXPLAINPLAN, TKPROF, STATSPACK.
. Configured and Monitoring GoldenGate for Replication of data from
source to destination.
. Involved in Capacity Planning for databases based on the future
business growth requirements.
. Involved in data architecting in the initial stages of Oracle
Application.
Environment: Oracle 11g RAC/ 10g RAC, Oracle 9i, Grid Control, TOAD, RMAN,
RedHat Linux, Sun Solaris 10, AIX 5.3
PNC Bank, Pittsburgh, PA
Jan 2009 - Jul 2010
Oracle DBA
Responsibilities:
. 24 X 7 Production database administration, support and monitoring
to ensure a proactive problem recognition and resolution of
database issues.
. Installation, Configuration and Administration of Oracle 10g
RAC/Oracle 11g RAC.
. Migration of oracle databases from windows to Linux and applying
patches for Databases
. Involved in developer Environment Setup, Support, Cloning and
Refreshes. Performed database cloning to setup Test and Development
database.
. Implemented and performed Hot, Cold and Logical backup plans.
. Involved in Installation, Configuration and Maintenance of Oracle
9i, 10g, 11g.
. Proactive data base monitoring and performance tuning using Stats
pack, Explain plan, AWR, ADDM.
. Upgrading databases to Oracle 10g.Involved in applying patches to
Oracle Databases and Applications.
. Cloned Oracle Databases for development and testing.
. Responsible for optimizing the queries and application tuning.
. Conducting sizing & capacity planning for Oracle databases and
management of schemas, objects partitioning the tables & indexes
. Perform SQL tuning and assist developers with coding.
. Provided support to Application Database Administrators in
designing the database.
. Installed and Implemented Backup & Recovery procedures.
. Used RMAN for backup and recovery and in performed backup
validations.
. Applied High priority, security patches downloaded from Metalink.
. Conducted multiple "dry runs" (test runs) to gather timings for
production upgrades.
. Monitored regularly whether primary and standby databases are in
sync and clearing the backed up archive log files after confirming
that they are applied on the standby database.
. Monitored the database objects growth, managing the extents growth
and de-fragmenting the objects, which are running out of maximum
extents. Monitoring the excessive fragmentation of table spaces and
taking remedial steps.
Environment: Oracle 10g RAC, Oracle 11g, OEM, Oracle Data guard, Oracle
Universal Installer, Oracle configuration Assistant, PL/SQL, Unix Shell
scripting, RMAN, HP-UX 11 and Red Hat-5
Oracle Corporation, San Francisco, CA
Jan 2008- Dec 2008
Oracle DBA
Responsibilities:
. 24 X 7 Production database administration, support, monitoring,
proactive problem recognition and resolution of database issues.
. Involved in process improvement, Oracle Server
Installations/Upgrades/Patches, Space Management, Capacity
Planning, Backup & Recovery, Disaster Recovery, Database
Performance Tuning, Memory Tuning, Application Tuning, Security
Administration, Data Warehousing, Data Guard, Oracle Advanced
Replication, Real Application Clusters, and Oracle Standby.
. Performed database cloning to setup Test and Development database.
. Installation and Maintenance of Standby database.
. Experience in Disaster Recovery Drills, documented database and
application validation steps.
. Conducting sizing & capacity planning for Oracle databases.
. Upgrading Production and Development databases to Oracle 10g.
. Installation, Configuration and Administration of Oracle 10g RAC.
. Applied RDBMS patches, security patches, proactive monitoring of
databases and applications.
. Perform SQL tuning and assist developers with coding PL/SQL.
. Responsible for optimizing the queries and application tuning.
. Provided support to Application Database Administrators in
designing the database.
. Installed and Implemented Backup & Recovery procedures.
. Used RMAN for backup and recovery and performed backup validations.
. Implemented Hot, Cold and Logical backup plans.
. Customization and development of Unix shell scripts.
. Management of schemas, objects partitioning the tables & indexes.
. Automation of data load using Korn shell scripting and SQL*Loader.
. Responsible for setting and managing user accounts, granting
required privileges to users.
. Defining and Implementation of Backup and Recovery strategies
. Perform other regular DBA activities including space management and
performance monitoring.
. Effective troubleshooting of Performance tuning problems in Oracle
database.
. Optimization and tuning SQL queries using TRACE FILE, TKPROF,
EXPLAIN PLAN.
. Continuous monitoring of database performance during peak and non-
peak loads using STATSPACK, AWR report.
Environment: Oracle Database 10g RAC, Oracle 11g, HP-UX, Linux, Oracle GRID
Control, SQL Navigator, TOAD, RMAN
MetroPCS, Dallas, TX
Jul 2006- Dec 2007
Oracle DBA
Responsibilities:
. Installed, Configured and Administered Oracle 8i/9i/10g databases
. Responsible for optimizing the queries and application tuning. Perform
SQL tuning and assist developers with coding PL/SQL
. Writing Oracle scripts for the SQL and PL/SQL requirements for various
applications.
. Optimization of the SQL queries to meet the performance requirements.
. Worked with database export & import scripts to backup database
structures and automation procedures.
. Monitored for unusual conditions in database against contention, load
throughput and cache utilization.
. Performed Monthly Cold Backup, Daily Hot Backup. Incremental backups
using RMAN.
. Testing of Backup's and Documenting backup strategies. Created scripts
for automating online daily backup
. Developed Database Triggers and Stored Procedures for populating and
updating data into different tables on ORACLE 8i Database Management
Systems. Developed scripts for exporting and importing database.
. Dataloads using SQL*Loader
. Other activities like applying RDBMS patches, security patches,
proactive monitoring of databases.
Environment: Oracle 10g/9i/8i/7.3, SQL, PL/SQL, SQL*Loader, ASM, DataPump,
Sun Solaris, HP-UX RedHat Linux.
Krisfo InfoTech Solutions Pvt Ltd, Bangalore, India
Sep 2005 - Jun 2006
Oracle DBA
Responsibilities:
. Administered and managed Production and Development databases.
. Configured and administered ASM on RAC based instances.
. Review database environments, such as database settings, monitoring
oracle user processes.
. Involvement in migrating and upgrading Oracle 9i databases to 10g.
. Working knowledge in OEM Grid Control (Segment Advisor, SQL Tuning
Advisor, Memory Advisor, SQL Access Advisor, AWR, ADDM, and Metrics).
. Administrated Automatic Storage Management (ASM) on a Single Instance.
. High expertise in working with Interval Views.
. Monitored disk space utilizations and sizing.
. Configured and Administered Oracle Streams 10g for replication of data
among databases.
. Implemented Fine-Grained-Access Control and Auditing standards on very
vital oracle objects.
. Involved in Capacity Planning for databases based on the future growth
requirements.
. Actively involved in deploying the changes occurred in the databases
in all three database. Coordinated with the Production database team.
. Involved in a 24/7 production support.
. Data Architecting- Design and entity relation.
. Implemented Normalization techniques during design stages.
Environment: Oracle 9i OEM, Oracle Data guard, Oracle Universal Installer,
Oracle Configuration Assistant, PL/SQL, Unix Shell scripting, RMAN,
SQL*Plus, SQL*Loader, Sun Solaris 9, HP-UX 11.11
AirTel, Hyderabad, India
Jun 2004 - Aug 2005
Oracle DBA/Developer
Responsibilities:
. Created and maintained user accounts, roles, system & user level
database objects.
. Migrating from lower versions of oracle to upper versions.
. Applied patches
. Developed various PL/SQL Packages and SQL scripts to generate reports
for users.
. Worked closely with programmers to ensure proper implementation of
program and system specifications.
. Communicated with management and other branch offices regarding
technical issues.
. Communicated with users to determine specifications for tool
development, maintenance, modification, and troubleshooting.
. Modified data access by creating event-related triggers.
. Designed, developed and maintained Company database.
. Managed tablespaces such as creation, reorganization and modification
of storage parameters for optimization of disk space and
defragmentation.
. Creating the Database, Tablespaces, Redolog files, Database triggers
and indexes.
. Performed database backups on disks and tapes.
. Recovery of database when needed.
. Tuning SQL queries for optimal performance and tuning memory
structures.
. Managing the on-line Redolog files and creation of Redolog members and
groups.
. Copying schemas from one database to another through Transportable
Tablespaces.
. Performance tuning of the database.
. Resolution of day-to-day related issues, Documentation of Oracle DBA
routine tasks.
. Automatic startup and shutdown of the database during the boot or
shutdown of the Server.
Environment: Oracle 8i Database, SQL & PL/SQL, Windows NT, UNIX (using VI
editor), Import/Export, Developer 2000.
Contact this candidate