Oracle Management
Resume:
Phaniraj
[pic]
E-mail:*******.***@*****.***
PROFESSIONAL SUMMARY
o Oracle certified Professional with Over 7 Years of Oracle DBA experience
in Database administration, Installation, Database design, Backup and
Recovery, Performance Tuning, Database upgrade & Migration, Space
Management, Database Security, Replication, Oracle Partitioning,
Troubleshooting, Development and Production support in Oracle 9i/10g/11g
in local and remote environments for diverse client industries.
o Vast Experience with RMAN to implement Backup/Recovery strategies and
clear understanding of the data structures and architecture provided by
ORACLE for Recovery in all kinds of Disaster situations..
o Experienced in maintaining Oracle Data Guard Administration and
management of Data Guard environment using Data Guard Broker. Implemented
Data Guard for replication and fail-over of databases and implemented
Oracle RAC on 2 node and 3 node clusters.
o Configured and resolved the issues with Oracle Streams in production
development and test instances.
o Applied several patches such as CPU/PSU patches, one-off patches and
Interim patches as per Oracle recommendations.
o Experienced in creating materialized views, partitioning and Query
optimization in Data ware house environment.
o Fine tune Transaction intensive servers i.e. OLTP situations (I/O
bottlenecks, SGA, Pinning objects, Sort space, Redo logs).
o Implemented Explain plan, TKprof, Autotrace and identifying the Execution
plan and tune queries, using Indexes, hints etc. Also used Data
Dictionary views, ESTAT/BSTAT and STATSPACK for performance monitoring.
o Extensively used Oracle utilities like Export / Import and SQL *LOADER
and oracle tool OEM and SQL developer.
o Experienced with key Oracle technologies on Oracle 10g/11g RAC databases
in production environments.
o Suggesting different backup methods, automation of backup procedures in
relation with nature of the application.
o Implemented nightly corn jobs to maintain the backup and for other
administrative works.
o Tuning memory, which involves sizing of buffer caches, shared pool,
Database buffer caches in order to reduce parsing and disk accessing.
o Creation of users with passwords and assigning them table spaces like
user data and temporary, granting privileges (system and object) through
roles and profiles.
o Worked on different technological Platforms, RAC. configured Data
Guard for Standby Database, GRID Control.
o Strong Knowledge of Oracle database security, Oracle label Security
(OLS), Virtual Private database (VPD), Oracle Advanced Security Option
(ASO) Oracle database Vault and Oracle Data Masking Pack.
o Data maintenance and migration within Oracle Databases and SQL server.
o Experienced in different flavors of UNIX/LINUX operating system, Shell
scripting and job scheduling using crontab.
o Involved in installation of supportive software applications,
operating systems, systems configurations, performance tuning,
migrating existing applications, and capacity planning and database
integrity.
o Proficient in writing SQL, PL/SQL stored procedures, packages and
triggers.
o Expert in Cloning, manual creation of Oracle Databases.
o Capable of working in a Team/independently with ability to lead a DBA
team with project management, technical, business, presentation,
communication and time management skills.
Supported 24/7 Production databases and responsible for round-the-clock
database operations.
o Excellent troubleshooting, analytical skills, problem resolution and
organizational skills.
EDUCATION & CERTIFICATION
> Pursued my Bachelors in Electronic and Telecommunications Engineering
from Kakatiya University, INDIA.
> Oracle Certified Professional.
TECHNICAL SKILLS
Oracle RDBMS: Oracle 8i, Oracle 9i, Oracle 10g
Administrative Tools: RMAN, Data Guard, Stats pack, Tkprof, Oracle
Enterprise Manager 9.2, RAC
Operating System Windows 2003/2008 server, Sun Solaris 2.7/2.8/5.9, Linux,
HP, AIX, UNIX, Open VMS Win 2000/NT/XP/98/95 / Vista
/ 7.0
Development Tools: MS Office, PL/SQL, TOAD 8.6.1, Pl/SQL,
Developer 2K, Visual Basic,
SQL*plus, Oracle Forms and Reports, Crystal Reports,
Streams
Programming Languages: C, UNIX, PL/SQL, SHELL SCRIPTING
Operating Systems: UNIX flavours like Sun Solaris, Linux, Windows
98, 2000, XP
Professional Experience
InComm Inc, Atlanta, GA
Apr 09 - Till Date
Role: Sr. Oracle DBA
Responsibilities:
> Designed, created, configured and Administered Databases (Production,
Testing) to optimum performance.
> Installed Oracle Software as per the Oracle Optimal Flexible
Architectural standards.
> Upgraded/ Migrated several databases from Oracle 9i/10g to 11g.
> Monitored database performance and tuned database management system to
ensure maximum performance.
> Reported database capacity plans to manager, and expanded the databases
in time schedule.
> Monitored all the running databases, and printed out performance
reports (Statspack, ADDM) when necessary and tuned some configuration
parameters to improve the databases performance.
> Performing regular Backups and Recovery using RMAN as per Organization
Strategy to support the database and also maintain 24 hours uptime for
the database while carrying out the activities.
> Implementation of Dynamic SGA sizing, managing tablespaces, segments,
extents, indexes and performing management of AWR, ADDM feature.
> Created Physical and Logical Standby databases using Oracle 10g Data
Guard.
> Worked in RAC environment. Configured the RAC database servers to fail
over for higher availability.
> Experience building new Oracle 11g production RAC databases migrating
existing production Oracle RAC 10gR2 databases to Oracle 11g RAC
databases and patching Oracle production RAC databases.
> Created rules and scripts data replications for Oracle Streams
> Involved in User Management, creation, monitoring and management of
database users, altering passwords of users and granting and revoking
system/object privileges & roles. Resource Management using Profile and
Resource manager.
> Managing SQL, PL-SQL Coding and tuning queries using Explain Plan,
Autotrace, SQL Trace, TKPROF tools. Extensively used TOAD for various
Database Activities.
> Managing Oracle Net configuration, configuration of Listeners and
Dispatchers monitoring Alert Log files, Listener Log, Redo Log status,
rollback segments and trace files for the database.
> Implemented Replication using Materialized views and Replication
Manager.
> Auditing at Database level as well as Audit programs in PL/SQL for Data
Consistency check and validation.
> Carrying out export and import operations on Oracle Database, loading
the data using SQL * Loader.
> Created Various Shell Scripts for automated backups.
> Provided on-call production database support.
Environment: Oracle 9i/10g/11g RAC, Grid, OEM, ASM, Streams, SQL*Plus,
OLTP, OLAP, Grid Control, Data Guard, RMAN, Oracle TOAD 9.4, Database
Cloning, SDP, PIM, CRM, Red Hat Enterprise Linux 4.0, Windows 2003, Sun
Solaris, AIX
Seagate, Oklahoma city
Sep 07 - Mar 09
Role: Oracle Database Administrator
Responsibilities
> Handling several production databases ranging from 100GB till 2TB
supporting various environments like production, quality testing and
development
> Implemented High availability, creating physical Standby database with
maximum performance. Configured Data Guard using OEM for easy Data Guard
management.
> Upgraded database from 9i to 10g.
> Installed, configured multiple RAC 10gR2 environments with Oracle cluster
ware on 2 node clusters.
> Applied critical patch updates every quarter.
> User Management ( Create user, Drop user, Reset password, Disable
password/accounts, Profile management, Grant/Revoke privileges, Create
Synonyms
> Role Management ( Create/Drop role, Grant/Revoke privileges,
Grant/Revoke Roles
> Tablespace Management ( Create/Alter/Drop Tablespaces, Sizing
Tablespaces, Tablespace reorganization
> Object Management ( Create/Drop/Alter Objects, Object reorganization
> User requests ( Production rollouts, script executions, ORA- error
investigation, connective issues, stat pack reports generation,
management reports, kill handing process, invalid object compilation
> Handling database/query performance issues, long running queries issues
> Monitoring ( Deadlock monitoring, ORA-01555 snapshot error monitoring,
Undo/Temp full monitoring, ORA-600 monitoring, invalid object monitoring,resource busy issues, Archive log full issues, File system ( mount
points) monitoring, Alertlog monitoring
> Morning support for all databases ( User management, Tablespace
management, Data refreshes, hotline coverage, Investigate/FIX the prod
job failures for all databases, server performance issues like swap
space, cpu utilization, average load, i/o bottleneck support.
> Implemented exp-imp for 9i/10g database excluding big tables.
> Implemented AUTOEXTEND OFF on all production databases to have control
over space management and stop growing the single files more than 10GB
and stop mount points getting full.
> Implemented mechanism for different backup and recovery strategies for
the organization.
Environment: Sun Solaris UNIX operating system, IBM AIX 5.3, Linux, Oracle
10g, RAC, SQL server 2005, Toad.
Pragma Systems, Austine, TX
Sep 06 - Aug 07 Role: Oracle Database Administrator
Responsibilities:
> Cloning of database for development team and Project Team.
> Provide Oracle DBA support for multiple large databases in production,
development and test environments.
> Regular Database backup activity and patching activity during regular
maintenance.
> Setting up physical and logical standby database / data guard at DR site
for operational recovery.
> Remedy Ticket solution for oracle application and oracle user.
> Troubleshooting, tuning, backup and recovery and upgrading of Oracle
databases. Experience designing and implementing Oracle Data Warehouse
technology.
> Developed functions, procedures and packages using PL/SQL.
> Handled DBA activities like user creation, backup, partition, Tablespace
etc.
> Involved in PL/SQL Debugging and support.
> Used Oracle Forms 9i was used to design and develop the interface for the
system.
> Used Import Export tools to create dump files for exporting and importing
data to the database
> Extensively worked with table partitioning and Tablespace creation etc.
> Created Object Groups to create to screen templates with Forms 9i
> Used SQL *Loader to load data from CSV file to database.
> Created front-end procedures and functions with Forms 9i
> Set up, configured and maintained oracle Data Guard (primary and
standby databases) to ensure disaster recovery, high availability and
data protection.
> Worked on Automatic Storage Management (ASM) for managing data in SAN.
> Installation of Grid Control Server and Management Server.
> As part of a core development team, cleaned up existing code, fixed
problems and achieved in making the system production ready in remarkably
short time.
Environment: Sun Solaris UNIX operating system, Oracle 9i, PL/SQL (Stored
Procedures, Packages, Triggers), Forms & Reports 9i,Informatica, SQL server
2005, SQL*Plus, Toad., SQL * LOADER
Keane Technologies, Hyderabad, India
Mar 04 - July 06
Role: Oracle Developer
Responsibilities:
> Worked on developing database objects like Tables, Views, Indexes etc.
> Responsible MIS Reports Module
> Coding and tuning Stored Procedures, Triggers & Functions using SQL,
PL/SQL language.
> Written Packages, triggers, functions for the following modules like
products, catalogue, billinh, shipping, rejected material, purchase
orders and material receipts.
> Wrote database triggers and control files to port data from Ingress
database to Oracle database.
> The operational responsibilities include: Scheduling Modules, testing and
debugging, providing user training, integrating screens to a module
through security administration module and porting data from ingress
database to oracle database.
> Developed UNIX shell scripts and PLSQL procedures to extrat and load data
for month end batch processing.
> Designed and developed User Interfaces using forms, reports and coding
modules in PLSQL
> Worked with business users to define and analyze problems, create logical
data model, implement physical data model, and considers the implications
of business solutions to the current and future environment.
> Involved in testing and code logic correction.
Environment: Sun Solaris 2.8, Windows NT, Oracle 8i (8.1.7, 8.1.6), Ingress
Database, Forms 5, Reports 3 SQL & PL/SQL
Contact this candidate