SUMMARY

8 years of experience in areas of Oracle DBA, Oracle SQL/PLSQL Development, Unix/Linux shell programming. Extensively worked with analyzing, planning, implementing and managing large databases develop complex SQL/PLSQL code and shell scripts. I am result oriented with good communication skills and am an excellent team player.

TECHNICAL SKILLS

EXPERIENCE

CONFIDENTAIL

Role: Oracle DBA

• CONFIDENTAIL one of the largest jewelers in the world with workshops in CONFIDENTAIL is jewelry auctioning TV Channel and an online shop.
• Responsibilities as an oracle database administrator include configuration, installation and administration of
• the oracle database systems and tools. Develop, implement and maintain the methodology and procedure standards for effective access, backups and recoveries. Work closely with the business areas to understand the requirements.

Responsibilities:

• Monitoring and maintenance of around 8 database instances which include Development, Test and
• Production databases on Oracle.
• Configuring backups and recovery of databases which includes configuring EXP/IMP, Cold backups and Hot backups. Automated hot/cold and logical backups of databases using customized backup scripts on Linux environment. Scheduling backups using RMAN.
• Upgrade Oracle database from 9i to 10g.
• Monitor DB growth and provide DB capacity planning for apps expansion.
• Work with Oracle Support to resolve different database related issues.
• Create databases, listeners using tools such as DBCA/NetCA.
• Manage and maintain databases using SQL and PL/SQL scripts, shell scripts and tools such as
• ADDM, AWR, and AMM.
• Tune databases and custom code using Tuning wizards.
• Perform/automate backups, restore database, and manage TAR/SR with metalink.
• Work with management, project managers, developers, Linux engineers, storage engineers and other teams.
• Modify database initialization parameters: create additional listeners, create Oracle Net Service aliases, and configure connect-time failover. Control the Oracle Net Listener.
• Worked with Oracle Enterprise Manager.
• Responsible for Oracle 10g logical and physical database design, implementation, and maintenance on Red Hat Linux.
• Create new databases and users: set up backups, export and other monitoring scripts, installing and configured database software for Oracle Application development environment.
• Implement database refresh using full export for table level and full database defragmentation, resulting in improved performance and effective space management.
• Manage database security. Design, develop, and implement automated data backup and restoration procedures. Provide technical support for database maintenance and disaster recovery.
• Identify, recommend, and implement all new DB technologies and Oracle license management.
• Responsible for Oracle 9i logical and physical databases maintenance, and implementation
• Reorganize and size database objects to meet standards and improve performance 30
• Handle database server tuning, application tuning, maintaining documentation, capacity planning, and database security.
• Created Oracle 9i databases for 2 large departments, from planning and testing through production.
• Implement backup and recovery procedures of databases in Red Hat Linux environment.
• Implement backup and recovery procedures and IT department manual.
• Manage database remodeling and interface development during migration from MS Access to MS SQL server and from MS SQL to Oracle 9i.
• Enhance MS-Access databases by improving user interface, introducing multiple-user access, and increasing security and stability.
• Support Oracle developers by tuning databases, creating database reorganization procedures, scripted database alerts, and monitored scripts.

Environment:

Oracle 11g/10g/9i, SQL, SQL PLUS, SQL Loader, Linux, Windows XP, SQL SERVER, C , VB.Net

CONFIDENTAIL

Role: Oracle DBA

Setup Oracle 9i on Sun Solaris/HP-UX and Windows NT/Windows 2000 Operating Systems and databases on Windows 2000 Operating systems. Responsibilities include configuration and administration of the oracle database system. Provide help and support issues related to the queries and database systems. Perform the

duties as assigned.

Responsibilities:

• Monitoring and maintenance of around 6 database instances which include Development, Test and
• Production databases on Oracle.
• Configuring backups and recovery of databases which includes configuring EXP/IMP, Cold backups and Hot backups. Automated hot/cold and logical backups of databases using customized backup scripts on Windows environment. Scheduling backups using RMAN.
• Refreshing test and development environments Oracle from production databases as and when required.
• Tuning of databases which includes Server side tuning and application tuning.
• Capacity planning of the databases/applications.
• Migrate DB between software versions, platforms, DB products
• Upgrade Oracle database from 7.x to 8i/9i.
• Design and implement DB security, user management
• Support developers in tuning DB and apps for optimal performance
• Install, configure, upgrade software: server, tools, applications
• Design and implement backup methods and disaster recovery strategies
• SQL and PL/SQL: scripts, triggers, procedures, packages.
• Monitor DB growth and provide DB capacity planning for apps expansion
• Work with Oracle Support to resolve different database related issues.
• Perform on call duties whenever required and support the databases 24/7.

Environment:

Oracle 9i, SQL, SQL PLUS, SQL Loader, Windows XP

CONFIDENTAIL

Role: DBA/Developer Consultant

• Primary responsibilities are Database Administration for development and test environments.
• Other responsibilities include performing database upgrades, data loading using SQL Loader, creation of database objects, writing Procedures, Triggers and SQL Queries for certain applications. Conversion of mainframe database into Oracle database, tested on different Oracle database before convert into production database. Some examples of recent work are as follows:

Responsibilities:

• Installation and configuration of Oracle 9i Database Server on HP-7x.
• Migrated the IBM Mainframe Database to Oracle using SQL Loader, Export/Import, and SQL Merge.
• 24x7 on call support of Databases on HP 7x with Omni backup and Quick I/O for Raw Devices.
• Involved in various stages of the Oracle Database Administration Life cycles Installation, Database builds/instance creation using Quest Software, Migration and Upgrade, Applying Patches,
• Configuring SQL Net Connectivity .
• Involved in Design and successful implementation of various automated DISASTER RICOVERY
• mechanisms for Mission critical production databases.
• Performance tuning involving, SQL Query, SGA - Memory, Disk I/O tuning.
• Wrote stored procedures, packages, triggers and functions using PL/SQL.
• Involved in Replication Designing and Implementation of UTS Database.
• Oracle Database Refresh/Cloning performed from Production to Test, Parallel, Training and
• Development databases.
• Backup and recovery procedures using RMAN.
• Worked on Conversion Re-engineering project from Mainframe VSAM to Oracle 9i Database, right from analysis to Design and Implement database.
• Developed huge number of objects and procedures for business system by writing stored procedures, functions and triggers using PL/SQL and SQL.
• Designed and developed various Reports and complex forms.
• Created Visual tools for defect prevention and database concurrency during conversion from old to the proposed system.
• Involved in Migration and conversion with large data from multiple systems.
• Extensively used SQL Loader, PL/SQL and shell scripts to migrate the data.

Environment:

Oracle 8i/9i, PL/SQL, SQL, SQL PLUS, SQL Loader, Forms 6i, Reports 6i, C , TOAD 7.6, Designer 6i, Java, HP-UX 7.x, Windows NT

CONFIDENTAIL

Role: Jr.DBA/Developer

The scope of the project is to offer test and development support to the client system. The support includes the general maintenance as per requirements of the client and to solve the problems encountered by the client while using the system.

Responsibilities:

• Responsible for creation of object libraries, form and report templates to implement standards.
• Responsible for creating PL/SQL libraries to handle security of the application, Error handling, general validation, screen activations etc.
• Used SQL Loader to upload the data. This is a scheduled process, which looks for incoming data files and then uploads them to database.
• Created users, granted privileges and public synonyms/db links/snapshots
• Developed backup and recovery procedures for database information
• Designed and developed PL/SQL scripts and stored procedures and functions.
• Developed complex Reports.
• Establishing and Implementing Backup strategy, also automating the process of backup, providing guidelines to Operation Department, backup operators involved in backup process.
• Tested different recovery scenarios in the databases. Database recovery using archived logs backup, time based recovery .
• Creation and maintenance of different database entities included managing table spaces, managing data files, redo log files, rollback segments and renaming/relocating of data files on servers.
• Maintaining system security and user access.

Environment:

Windows Server 2008, UNIX, Oracle 8 SQL, PL/SQL , SQL Loader, Shell Scripts, Windows NT

CONFIDENTAIL