Summary

• Has over 10 years of IT experience, Over 8 year's experience in Oracle 8i/9i/10g/11g & 10g RAC, Data Guard Database Technologies as Production/Development Oracle DBA/Database Consultant.
• 2+ Yearsof SQLServer2000/2005 administration.
• Proven experience in analysis, design, development, maintenance, production support and database administration of mission critical systems based on Client/Server, Intranet and Internet Technologies.
• Interaction with Customers to get the service level needs and getting signoff on SLAs.
• Excellent Customer Interaction and Interpersonal skill.
• Excellent hands on designing the backup and recovery strategy for the production databases.
• Involved in Capacity Planning and License agreement of various databases.
• Oracle Installation, up gradation, migration on different platforms.
• Participate in the recruitment activities, find out the job requirement and interview the candidate from technical and Process perspective.
• Change Management (CR) /trouble ticket management(CASE )
• Implement the best practices for providing the 24*7 database support
• Discussion with the client and find out the expectation from project perspective.
• Good Initiatives, leadership and team conflict resolution.
• Creation and maintenance of the database objects such as Tables, Indexes, Materialized View etc. at all customer sites.
• Query, PL/SQL and Database Performance Tuning using EXPLAIN PLAN, TKPROF and UTLBSTAT, UTLESTAT, STASTPACK.

CERTIFICATIONS
Oracle 8, 8i, 9i, 10g and RAC Database Administrator Certified Professional (OCP)

Computer Hardware and Software:
Hardware: E450, Sun Ultra Sparc, RM600, Intel x86
Operating System: HP-UX 10.x/11.x, Sun Solaris 7/8,AIX, Windows NT 4.0, Windows 95/98/2000,
Windows XP Professionals, Linux,
Databases: Oracle 10g/9i/8i/8/
Package/Other Software: Oracle Enterprise Manager,TOAD
Tools/Utilities: RMAN, TOAD,MS Office, top, sar Statspack, PLAN, TKPROF & UTLBSTAT,
UTLESTAT, STASTPACK.
Web Technologies: HTML, CGI Perl, CGI Using C++
Languages: Programming through C, OOPS with C++, IDE VisualAgefor Java, Software
Engineering, Networkingessentials, Computer architecture and Operatingsystem
concepts.
Packages: MS OFFICE, VERITAS-Volume Manager VxFS & RAID Veritas NetBackup

Trainings

• Oracle 10g RAC , Oracle Hyderabad, India
• Unix Shell scripting Wilshire Technologies, India.
• Solaris 8/9 Administration, Wilshire Technologies, Hyderabad, India.

Client: Confidential, Texas December 2008 to till date
Sr. Database Administrator

• Environment: Oracle 9i /10g/11g, SQL server 2005, Windows, Linux and Solaris
• Change Management (CR) /trouble ticket management(CASE )
• Administering various Oracle and SQL Server databases
• Managing the Oracle databases in Financial ,HR Peoplesoft systems env
• Handling day-to-day production support
• Creating and maintaining tablespaces
• Estimating and properly sizing data, index and rollback segments.
• Creating users, Roles, Profiles
• Migrated databases from 8i,9i to 10g
• Managing Standby databases by using DATAGAURD utility
• Setup and configure Log shipping on production databases.
• Creating Snapshots and views
• Auditing User Activities
• Control user access to resources and information
• Creating and managing data files
• Backup & recovery strategies with and without RMAN
• Validating Database Backups
• Identify and resolve ORA errors and database application issues
• Importing and exporting (datapump) data between databases and tablespaces
• Worked on scripts for loading data using SQL*Loader
• Creating Unix/win job schedules
• Design Databases using normalization rules
• Tuning the database by using STATSPACK, UTLESTAT UTLBSTAT, TKPROF and other Utilities
• Fine-Grained Auditing for Real-World Problems
• RAC, ASM,OCFS
• Creating ,Refreshing Materialized Views
• Expert level skills in TSQL, Stored Procedures, and Triggers
• applying patches ,cloning database
• Database refreshes
• Raising TAR / SR and contacting Oracle/Microsoft for SEV 1 issues. Discuss the resolution impact

Environment: Windows XP Professionals, Oracle 8.1.7/9i, Toad, MS OFFICE, Citric, Solaris, PL/SQL Developer, Netcool, SIEBEL, Peoplesoft HR, Peoplesoft FIN, Oracle 10g,Oracle RAC,Oracle Data Guard, Sqlserver 2000/2005

Client: Confidential, November 2005 to October 2008
Sr Database Administrator
Environment: Oracle 9i /10g, SQL server 2005, Windows, Linux and Solaris

• Change Management (CR) /trouble ticket management(CASE )
• Administering various Oracle and SQL Server databases
• Managing the Oracle databases in Financial ,HR Peoplesoft systems env
• Handling day-to-day production support
• Creating and maintaining tablespaces
• Estimating and properly sizing data, index and rollback segments.
• Creating users, Roles, Profiles
• Migrated databases from 8i,9i to 10g
• Managing Standby databases by using DATAGAURD utility
• Setup and configure Log shipping on production databases.
• Creating Snapshots and views
• Auditing User Activities
• Control user access to resources and information
• Creating and managing data files
• Backup & recovery strategies with and without RMAN
• Validating Database Backups
• Identify and resolve ORA errors and database application issues
• Importing and exporting (datapump) data between databases and tablespaces
• Worked on scripts for loading data using SQL*Loader
• Creating Unix/win job schedules
• Design Databases using normalization rules
• Tuning the database by using STATSPACK, UTLESTAT UTLBSTAT, TKPROF and other Utilities
• Fine-Grained Auditing for Real-World Problems
• RAC, ASM,OCFS
• Creating ,Refreshing Materialized Views
• Expert level skills in TSQL, Stored Procedures, and Triggers
• applying patches ,cloning database
• Database refreshes
• Raising TAR / SR and contacting Oracle/Microsoft for SEV 1 issues. Discuss the resolution impact

Environment: Windows XP Professional
Oracle 8.1.7/9i, Toad, MS OFFICE, Citrix, Solaris, PL/SQL Developer, Netcool, SIEBEL, Peoplesoft HR, Peoplesoft FIN, Oracle 10g,Oracle RAC,Oracle Data Guard, Sqlserver 2000/2005

Sr Database Administrator March 2004 to October 2005

Clients: Confidential

Environment: Oracle 9i /10g, SQL server 2005, Windows, Linux and Solaris

• Change Management (CR) /trouble ticket management(CASE )
• Shareplex administration
• Administering various Oracle and SQL Server databases
• Managing the Oracle databases in Fin/HRl Peoplesoft systems env
• Handling day-to-day production support
• Creating and maintaining tablespaces
• Estimating and properly sizing data, index and rollback segments.
• Accelerated the I/O performance by distributing Data files and Redo Log files.
• Creating users, Roles, Profiles
• Creating and managing Standby databases by using DATAGAURD utility
• Setup and configure Log shipping on production databases.
• Auditing User Activities
• Control user access to resources and information
• Creating and managing data files
• Backup & recovery strategies with and without RMAN
• Validating Database Backups
• Deleting expired Backups using scripts and monitoring
• Monitoring alert log/system log through NetCool tool.
• Implement and maintain database security (create and maintain users and roles, assign privileges)
• Implement and maintain Row Level Security using Virtual Private Database
• Creating database objects like tables, procedures, functions, triggers etc
• Performance tuning using Oracle diagnostics and monitoring tools
• Identify and resolve ORA errors and database application issues
• Importing and exporting data between databases and tablespaces
• Worked on scripts for loading data using SQL*Loader
• Creating job schedules
• Tuning the database by using STATSPACK, ESTAT BSTAT, TKPROF and other Utilities
• Fine-Grained Auditing for Real-World Problems
• RAC, ASM
• Creating ,Refreshing Materialized Views
• Expert level skills in TSQL, Stored Procedures, and Triggers
• applying patches ,cloning database, refreshing Databases

Environment: Windows XP Professionals, Oracle 8.1.7/9i, Toad, MS OFFICE, Citric, Solaris, PL/SQL Developer, Netcool, SIEBEL, Peoplesoft HR, Peoplesoft FIN,MS Office, Oracle 10g,Oracle RAC, Oracle Dataguard, Sqlserver 2000/2005

Database Administrator

Environment: Oracle 8i /9i, Windows, Linux

• Administering various Oracle databases
• Managing the Oracle databases for Oracle forms in Development env and Production
• Handling day-to-day production support
• Creating and maintaining tablespaces
• Estimating and properly sizing data, index and rollback segments.
• Accelerated the I/O performance by distributing Data files and Redo Log files.
• Creating users, Roles, Profiles
• Creating and managing Standby databases by using DATAGAURD utility
• Setup and configure Log shipping on production databases.
• Control user access to resources and information
• Creating and managing data files
• Backup & recovery strategies with and without RMAN
• Validating Database Backups
• Deleting expired Backups using scripts and monitoring
• Monitoring alert log/system log manually
• Implement and maintain database security (create and maintain users and roles, assign privileges)
• Creating database objects like tables, procedures, functions, triggers etc
• Performance tuning using Oracle diagnostics and monitoring tools
• Identify and resolve ORA errors and database application issues
• Importing and exporting data between databases and tablespaces
• Worked on scripts for loading data using SQL*Loader
• Creating job schedules
• Tuning the database by using STATSPACK, ESTAT BSTAT, TKPROF and other Utilities
• Expert level Stored Procedures, and Triggers
• applying patches ,cloning database, refreshing Databases

Environment: Windows XP Professionals, Oracle 8/8i/9i, Toad, MS OFFICE, Oracle Forms & reports, VB,C++.