PROFESSIONAL SUMMARY:

Over 8 years of experience in Oracle DBA/Architecture/Implementation/System Study/Support with emphasis on Evaluation of existing system and Data collection, System Design, Implementation specifications, Implementation schedules, Database design, Development, testing and Documentation of business applications using Oracle technologies 11g ASM,10g/9i/8i.

• Proficient in Oracle DBA activities including installation, migration, configuration, physical and logical database design, backup, recovery of oracle databases, PL/SQL, SQL scripts programming.
• Managed-Cold and HOT backup, RMAN with VERITAS Net backup, Export & Import, proficient in setting up the network connections (i.e. setting up Listener and TCP/IP Connections).
• Thorough knowledge in high availability RAC environment (2 node, 3 node and 4 node clusters) and upgradation of the standalone databases to 10g RAC environment.
• Experience in planning & implementation of used physical & logical backup using Shell Script, Rman, DataPump.
• Expertise in Oracle Enterprise Manager (OEM).
• Attended various workshop with Oracle – 10g Grid Control Workshop, 11g ASM Workshop.
• Monitor and maintain system security, including monitoring database alert logs manage file system disk space, resizing table space and de-fragmenting the database as needed, system shut down and restart, unlocking database table locks, as well as monitor and create additional table space and file space as needed.
• Co-ordinate with UNIX Administrators for space management on various servers.
• Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
• Experienced in Tuning SQL statements using Explain Plan, SQL Trace & TKPROF.
• Experience working with Oracle Streams, Oracle Data Guard & Data Guard Broker.
• Proficient in setting up Standby Database using Shell Script and Rman tool, Activating Standby Database & Re-building Standby.
• Availability to 24x7 on-call support on rotation basis for Production systems Support.
• Posse’s excellent analytical, problem-solving and learning skills as well as keen interest in the emerging technologies.

Operating Systems:

HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, 5.3
Red Hat Linux RHEL 4.x and Windows 95/98/ME/NT/2000/XP.

RDBMS:

Oracle8i, Oracle 9i,Oracle 10g, 11g ASM, Oracle 10g Real Application Cluster (RAC)

Languages:

SQL, PL/SQL, C, UNIX

Tools:

RMAN, OEM, Enterprise Manager Console, SQL*Loader, EXP, IMP, data pump (expdp, impdp), Sql Developer, TOAD, DBArtisan, Golden 32, ImpExp 32 , Grid Control , Putty

Tuning Tools:

TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR

Database Modeling:

Erwin 4.0

Storage:

EMC, NetApp, Veritas NetBackup, TSM, HP OmniBack

Web Tools:

HTML, XML

PROFESSIONAL EXPERIENCE:

Confidential,San Diego, CA Aug 08—Till Date
Role: Oracle Database Administrator
Sempra Energy, based in San Diego, Calif., is an energy services company with 2007 revenues of nearly $11.5 billion. With more than 13,500 employees worldwide, Sempra Energy companies develop energy infrastructure, operate utilities and provide related products and services to more than 29 million consumers around the world. Sempra Energy is currently ranked No. 232 on Fortune magazine\'s annual Fortune 500 ranking.
Responsibilities:

• Provided Primary architectural and administrative support for new projects.
• Performed day to day activities: Such as , daily error checks and database health, monitoring of physical resources (disk space, memory, CPU, etc.). Performance parameters adjusted as needed.
• Assisting Application Development Project Lifecycle through migration to Production, as well as SQL optimization and post-implementation storm support.
• Provided Production DBA support, as needed, on a 24/7 basis.
• Database Recoverability- Supported Operational , Reporting and Development backups and restorations.
• Proficient in Installation and Setting up of 10g RAC and 11g ASM on RAC databases and non RAC- databases.
• Extensive experience with database replication technologies (Data Guard/Standby, Advanced Replication, and Streams)
• Disaster Recovery Management; Defined and Implemented Production DR databases, administration for log-shipping/stand-by database systems.
• Participate in annual DR testing for mission critical systems.
• DBMS Software Updates - Installation of DBMS software per best practices. Patch and version upgrade evaluation, planning and installation.
• Experience in utilizing Oracle Enterprise Manager, DBArtisan, Golden 32 for monitoring and management of database environment.
• Experience in managing Multi-Terabyte databases
• Adherence to policies, procedures and controls especially in regard to outage and change management, licensing, and information protection.
• Support audit requests for information. Include adherence as well as testing of controls .
• DBMS configuration planning for systems physical environment, hardware capacity planning and licensing of enterprise environment.
• Performed various activities, such as database recovery, performance monitoring and tuning, structured query language, operating systems and relevant tools.
• Maintained a high level of user trust and confidence in IT’s knowledge of and concern for user’s business needs.
• Experienced in working on high-profile, externally facing, revenue generating, large scale projects.
• Presented and explain technical information of diverse type of audiences such as management, users, vendors and technical staff in a way that establishes rapport, persuades other and gains understanding.
• Worked on multiple projects simultaneously, met project deadlines and worked under pressure. Worked Independently with little or no supervision.
• Proficient in raising tar with Oracle Support and using Metalink to resolve the bottlenecks in the database environment.

Environment

Oracle 11gASM/10g(10g RAC)/9i/8i, AIX 5.2,5.3, DBArtisan, Golden 32, ImpExp 32, Grid Control (OEM), Enterprise Manager Console, SQL PLUS, SQL Developer, Putty.

Confidential,Tempe, Arizona Feb-08--June08

Role: Oracle Database Administrator

The Freescale Semiconductor
Freescale is creating a smarter, better connected world. Already, there are more than 17 billion Freescale semiconductors at work all over the planet. You’ll find them embedded all around you: in automobiles, computer networks, communications infrastructure, office buildings, factories, industrial equipment, tools, mobile phones, home appliances and consumer products that touch every aspect of your daily life.

Responsibilities

• Installation, configuration and maintenance of Oracle 10g RAC database.
• Created test, production and archive database and its application table spaces. Created admin users and granted the role to the users with high level security to protect the database from unauthorized access.
• Comprehensively involved in implementation and maintains of the database application design.
• Actively involved in application design and assisted the developer while designing the database application.
• Oracle RAC Database Administration including Installation, configuration, Analysis, Design, Backup and Recovery (RMAN).
• Involved in creating database objects.
• Monitoring the application related jobs and data replication activities.
• Performed application tuning and performance monitoring.
• Worked as part of a team and provided 24/7 support when required.
• Interface with Oracle Corporation for technical support.
• Actively involved in designing, developing and testing the application.
• Played an important role in migrating the database objects from Test database to Production database.

• Creating roles and users and Space management.
• Good knowledge in Real Application Cluster (RAC).
• Experience developing and refining data models and data processing environments.
• Optimize databases queries and recommend tuning enhancements.
• Performed troubleshooting of the database.
• On-going SQL tuning using Explain Plan and SQL Trace.
• Support Developers and QA testing.
• Involved in writing shell Scripts for Backup and recovery methods.
• Database maintaining including backups, restores, imports, exports.
• Management of Tablespaces such as dropping/creation and modification of storage parameters for disk optimization, coalescing tablespaces regularly in case of fragmentation and Analyze the statistics periodically and taking remedial action.

Environment:

Oracle 10g/9i/8i, AIX-HP, Redhat Linux, OEM, SQL, PL/SQL,SQL Plus, SQL DEVELOPER , TOAD.

Confidential,Basking Ridge NJ Oct 06 –Jan 08

Role: Database Administrator

B2C Provider Portal
A web application that provides a self-service view into the United Healthcare systems, allowing providers to access key information about their patients and practice

The UNITED Healthcare Online (B2C) Service uses the latest in Internet technology to significantly reduce the time your office spends checking patient eligibility and claim status, and submitting claims for reimbursement. Instead of making numerous phone calls to customer service, you can check and submit everything at once, right from your desktop computer. Responsibilities include installation, configuration and maintenance of the oracle RAC database. All administration procedures were automated using ‘Cron’ job scheduler. All alerts and errors were monitored and reported automatically during normal and batch runs and interfaced with pagers and email system.

Responsibilities:

• Extensively involved in analyzing the functional requirements for the Database Access Profiles.
• Provided high degree of coordination between user, technical and application to ensure effective database management.
• Implemented Index organized tables to improve the performance.
• Installation, configuration and maintenance of Oracle 10g RAC database.
• Tuning of INIT parameters to improve the performance during data loading.
• Performed Operational Data Store (ODS) using third party tool.
• Co-ordinate with UNIX Administrators for space management on various servers and help in Oracle installation, upgrading according to the standards & Quality assurance.
• Set up, configured and maintained oracle data guard(primary and standby databases) to ensure disaster recovery, high availability and data protection.
• Generating the Dataflow Diagrams and ER Diagrams by using Erwin.
• Synchronize Databases with production for data and testing purpose.
• Database system Architecture, Data Modeling, Logical/Physical database design (Data guard implementation for Disaster Recovery), creation, maintain, and documentation.
• Having Strong Oracle PL/SQL Programming Skills.
• Help Development team for technical issues related to database issues.
• Involved in running the Access Profile batch jobs.
• Creating the database schema, converting VIEWS specific to database.

• Data migration, loading with SQL Loader.
• Installation, configuration and monitoring of servers, databases by Oracle Enterprise Manager (OEM) 10g Grid Control.
• SQL*loader and data pump import to load data into tables.
• Developed stored procedures using PL/SQL. Used Hints, Indexes, Explain Plan, Sql Trace and TKProf for effective retrieval and processing of queries used for retrieving current details and also history of changes made for a version.

Environment:

Oracle 10g/9i, Sun Solaris 9, AIX, Redhat Linux, OEM, SQL, PL/SQL,SQL Plus, Unix, Erwin Data Modeler.

Confidential,NJ Oct 05 – Sep 06

Role: Oracle DBA

Customer Proprietary Network Information (CPNI) is information relating to a customer\'s telecommunications or voice service that only the customer or the customer\'s telecommunications carrier would possess. CPNI includes information typically available from details on a customer\'s monthly telephone bill, including: the type of line, technical characteristics ,class of service, current telephone charges, long distance and local service billing records, directory assistance charges, usage data and calling patterns.
Responsibilities:

• Installation and Configurations of Oracle 10g and 9i on Linux Red Hat.
• Responsible for administration and supporting Oracle 9i and 10g databases.
• Upgradation and migration from Oracle 9.2.0.8 databases to Oracle10.2.0.3.
• Experience in OSA (Oracle Sales Analyzer) and OFA (Oracle Financial Analyzer).
• Designed and implemented database schema (logical and physical data models).
• Write scripts for Oracle Database security, creation of users, creation and assignment of roles, analyze space requirements and maintain tablespaces, creation and maintenance of tables and indexes.
• Experience in working Data Guard execution.
• Creating primary database objects (tables, views, indexes) once application developers have designed an application.
• Configuring ODBC, to enabling networking between the Database Server and Clients
• Handling large database environments Dataware Housing, Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and keep running.
• Responsible for online and offline backups and recoveries of the oracle database.
• Creating and rebuilding indexes and optimizing the code to improve the performance after analyzing the trace files.
• SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, Statspack, Explain Plans and monitor the database performance on daily basis. Having stored outlines before and after Database tuning to stabilize and optimize the database by changing the parameters.
• Troubleshooting errors that occurs one daily basis and resolving problems quickly and efficiently and giving suggestions to developers when they are required for tuning the code to maximize performance of the database.

Environment: AIX, HP -UX, Windows NT/2000, Oracle 10g/9i, SQL plus, OEM, TOAD, Red Hat Linux, Sun Solaris.

Confidential,Secunderabad Feb 01 – Aug 05

Role: Oracle DBA
CFST (Citizen Friendly Ship services of Transport Dept)
FAST Application (Fully Automated Services of Transport Department)
This system (FAST) completely automates APTD activities, which includes Wireless information using GSM Technology (Ex: remote system), Issuing Fresh/Duplicate/Renewal Driving License, Registration of Vehicles, Registration Operations, MIS Reports. It also involves in issuing Road Permits.
The main aim of the project is automation of APTD activities, fast issuing of License (Within 8 Minutes), and Centralizing complete state data in one central Database. The advanced DBA concepts are used to establish the connection between the Central Server at Hyderabad and the remaining centers which are located at remote places. This project is also planned to establish online information security at check posts, so that the taxes or punishments to the vehicle owners can be levied on the spot.

Responsibilities:

• Database design development, Testing & implementation.
• Database performance/Statement tuning, Table sizing, and administration.
• Development of database procedures and packages.
• Backup & crash/disaster Recovery Locally & Remote.
• Partitioned large tables to increase the performance. Responsible for optimizing the queries and application tuning. Database Links for data porting, and business logic changes/database merging.
• Implement Hot, Cold and Logical backup plans. Created scripts for speedy troubleshooting of database problems. Use TOAD tool to access the database
• Investigate new tools in database field and give recommendations to the management.
• Extensively involved in maintaining & updating the database.
• Maintaining the database availability and security.

Environment: Oracle 8i, SQL, PL/SQL, SQL plus, TOAD, Oracle Enterprise Manager.