SUMMARY:

• 6+ years IT/ Oracle DBA experience
• Worked extensively on relational databases design, administration and development in Oracle 8i/9i/10g/11g/12c databases and developing applications in PL/SQL, SQL Loader, EXP, IMP, RMAN.
• Expertise in Oracle DBA activities, Oracle custom solutions and resolving customer issues.
• Experience in High Availability Database Solutions.
• Several production/test implementations of 8i/9i/10g/11g/12c databases.
• Tuned several production databases using explain plan, autotrace, tkprof and trace events.
• Performed fine tuning using statspack, dbms stats.
• DR planning, Data Guard and physical, logical standby databases.
• Complete Oracle lifecycle from concept to design, architecture, installation and patches, database creation, database performance monitoring, from production to test databases
• Devised & implemented back up strategies using Hot, Cold & export based on requirements
• Managing security of an oracle database using roles & profiles.
• Worked extensively with OEM and installation of Agents for monitoring purposes.
• Oracle backup using RMAN (Oracle Recovery Manager).
• Experience in SQL, Stored Procedures, Packages, Triggers, Joins and Performance Tuning in Oracle.
• Created and restored backups. Wrote SQL Plus queries to monitor the database.
• Expertise in full life cycle development of database.
• Worked with third party tools like Toad, Spotlight, ERWIN for quick diagnosis and end results.
• Good leadership qualities, excellent communication and interpersonal skills. Excellent analytical ability and presentation skills. Proactive.
• Efficient, resourceful and results - oriented team player with ability to grasp complex fundamentals quickly.

TECHNICAL SKILLS:

Operating Systems: DOS, Windows 95/98/NT/XP/2000/7/8, Red Hat Linux 7.x, UNIX, Solaris, HP-UX

Languages: C, SQL, PL/SQL, Java, C#

Databases: Oracle 8i/9i/10g/11g/12c, MySQL, MS Access, MS SQL Server 2000 Installation of Oracle 9i/10g, Database Creation Database Layout, Logical and Physical Database Design & Implementation Application Porting Oracle 9i/10g/11g/12c RAC PL/SQL, Stored Procedure & Trigger Implementing Disaster Recovery, Database Protection Solutions using Standby Database, UNIX file system management Implementation of Oracle 9i/10g/11g/12c RAC/Parallel Server Database Security Space Management Automatic job scheduling using cron jobs and maestro jobs Oracle Data Dictionary Export/Import, UNIX OS & FILE SYSTEM administration activities Capacity Planning (Plan growth and Changes). Performance Tuning Backup & Recovery Database Migration

Database Tools: RMAN, TOAD, Spotlight, ERWIN, Oracle Enterprise Manager(OEM)

Web Applications: HTML, MS FrontPage

Desktop Tools: Microsoft Office 2003 (Word, Excel, PowerPoint, MS Project)

Application Server/ Tools: MS Visio, UML, Oracle 10g Application Server, Apache Tomcat, Eclipse, TOYS, WINCMP3

QA Documentation: SRS, SDD, Use Cases, Test Cases, Test Plan Creation

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle DBA

Responsibilities:

• Database creation, managing log segments, disk initialization, disk mirroring, taking backups of databases and restoring in case of failure. Maintaining physical and logical devices.
• RMAN configuration and maintenance. Manage Database maintenance jobs (scheduled tasks) using Shell scripts
• Worked on various platforms such as Solaris, HP-UX, UNIX and Windows.
• Create and maintain database schema objects accessed by various stored procedures, functions and triggers.
• Code database stored procedures, functions and triggers in PL/SQL to provide core MMC Re-Insurance functionality.
• Perform database performance tuning by generating SQL plan, using hints, tuning SQL statements to enhance application processing time.
• Design and implement several standby database servers active/active, active/passive dataguard fail-over, switch over techniques on solaris platform providing extended data availability.
• Plan and implement database security and grant privileges and roles to set restrictions.
• Import data in the CSV format into database tables using SQL Loader.
• 40% of databases handled in sql server
• Execute autonomous transactions in PL/SQL to perform independent tasks.
• Design a very flexible hierarchical Oracle database to establish a parent and child relationship between table records that eliminates any need for structural changes.
• Manage test, development and production database systems.
• Perform logical and physical database backups using DataGuard and OEM Grid.
• Provide support for UAT and production database systems.
• Design the application and data schema in development, test and production database systems.

Environment: Oracle 9i/10g/11g, PL/SQL, RedHat Enterprise Linux, Java Struts, JSP, J2EE, BEA Weblogic, Tomcat, SQL Loader, IMP, EXP, SQL Navigator

Confidential

Senior Oracle DBA

Responsibilities:

• Provided maintenance of around 1800 number of Oracle 8i, 9i and 10g databases.
• Provided 24/7 support for production, QA and development databases.
• Incident management, worked on helpdesk tickets, RFC submission for root cause analysis and problem management.
• Creation of databases manually and using DBCA.
• Managed and maintain 3 node Oracle RAC with VERITAS cluster in both test and production environment.
• Maintained hot backup scripts in maestro and cron jobs, implemented using RMAN.
• UNIX file system management.
• Datafiles and tablespace management.
• User security and account management.
• Performance tuning.
• Perform troubleshooting to find out cause for application failures, cluster and database issues.
• Configure, install and upgrade Oracle various versions, applying Oracle and CPU patches on UNIX and Solaris machines.
• Storage management of datafiles, control files, redo logs.
• Data copy from one database to other using various utilities i.e. export/import, data pump.
• Manage multiple Oracle databases and instances on the servers in the production environment.
• Tune SQL statements using explain plan, hints, query rewrite hints, index hints and using cost-based optimizer.
• Monitor database activities using Oracle Enterprise Manager (OEM), Quest Spotlight and Toad.
• Work as a team with a group of SAN engineers and HP-UX system administrators to allocate database storage space.

Environment: Oracle 10g/ 9i/ 8i, RAC, Data Guard, BMC software, Remedy tool, HP-UX 11.0, Solaris 10, Windows NT 2000 server.

Confidential

Oracle DBA

Responsibilities:

• Designed architecture of database in Oracle 10g for application.
• Gathered requirements for Legal, Vigilance and Planning modules.
• Migration of SQL Server 2000 data to oracle 9i database.
• Involved in full life cycle database development.
• Consult with other departments including account management, finance and other areas to understand and gather requirements.
• Perform work related to importing and exporting data using IMP and EXP tools in Oracle 9i, file structures.
• Performed data transfer using Export/Import using command line as well as in interactive mode and through Data pump.
• Designed and modeled database using ERWIN.

Environment: Oracle 10g/9i, SQL Server 2000, Oracle Migration Workbench, .Net framework.

Confidential

Responsibilities:

• Handled Oracle 9i database and daily database troubleshooting tasks. Migrated data from Oracle 9i to MySql and consolidated all schemas into a single schema.
• Migration of Oracle9i to Oracle10g database by exporting and importing database structures and data.
• Restore database using IMP from an exported database dump file using EXP to move the entire database schema(s) from the source database into the target database.

Environment: Oracle 10g/9i, Oracle Migration Workbench, My SQL 5.0, Linux SUSE 9, IE 5.0 & Firefox 2.0, Liferay 4.0.1, JBoss 4.0.2.

Confidential

Responsibilities:

• Handled Oracle 9i database, implemented Oracle 10g database, Oracle 10g Application server with OC4J Container.
• Worked on Virtual Private database, Data Guard Recovery Server, SQL Tuning and Optimization and reports creation.
• Handled database troubleshooting and maintenance tasks also.
• Create and maintain database schema objects accessed by various stored procedures, functions and triggers.
• Perform database performance tuning by generating SQL plan, using hints, tuning SQL statements to enhance application processing time.
• Perform user-managed backup and recovery using SQL scripts and shell scripts and using RMAN.
• Design and implement standby database server on Linux platform providing extended data availability.
• Plan and implement database security and grant privileges and roles to set restrictions.
• Manage test, development and production database systems.
• Perform logical and physical database backups using EXP utility and user managed backups.
• Design the application and data schema in development, test and production database systems manually and using database modeling tool called ERWIN.
• Perform Oracle10g database tuning by referring to statspack reports, using data dictionary dynamic performance views, tkprof, explain plan.
• Manage multiple Oracle databases and instances on the servers in the production environment.
• Tune SQL statements using explain plan, hints, query rewrite hints, index hints and using cost-based optimizer.

Environment: Oracle 9i/10g, DBUA, Enterprise Manager, Toad, Windows 2000, Eclipse (IDE), JSP, Servlets, Struts.

Confidential

Responsibilities:

• Design and development of Web Site for USA based client. The web site can be seen at Confidential.