CORE COMPETENCIES STRENGTHS

• Over 7 years of Oracle database experience in ORACLE 11g/10g/9i Database Administration in Production/Development environments, which includes Database creation, upgrades, tuning, maintenance, backups and recovery in both Unix Sun Solaris, IBM AIX, HP-UX Red Hat Linux and Windows Environments.
• Experience working in different areas like E-commerce, Financial, Manufacturing to deliver new products, upgrades. Resolve application problems to maintain high level of customer satisfaction.
• Excellent experience in installation, upgrade and configuration of Oracle Database.
• Very proficient in installing and Implementing physical Data Guard.
• Experience in Installing and Configuring Automatic storage management ASM Instance
• Good experience in Installation and configuration of RAC Real Application Cluster on different nodes.
• Familiar with Oracle backup utility RMAN to implement Oracle backup.
• Immense experience in taking Hot Backup and Cold Backup.
• Good hands on Crontab including: Backups, exports and imports, archiving old records and verification of such processes.
• Perform backup and restoration using RMAN and pointing time recovery using DB Flashback.
• Expertise in Database and schema creation, creating roles, profiles, privileges and assigning roles to users.
• Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager, ADDM, TOAD, monitor users, table spaces, memory structures, rollback segments, logs, and alerts.
• Applying Patches, Upgrades, Troubleshooting database issues, critical security updates and User Issues using Meta link.
• Extensively worked in developing SQL and PL/SQL codes through various procedures, functions, and packages to implement the business logics of database in Oracle.
• Widely used SQL Loader to load files into database and Written shell scripts to automate loading file into database.
• Experience working with Business Intelligence Tools and Reporting tools like Business Objects XI XI 3.x and Crystal Reports.
• Demonstrated ability to work both in independent and team-oriented environments with well-developed organizational skills and excellent interpersonal and communication skills, self-starter and a quick learner.

Technical Summary:

Professional Experience

Confidential

Oracle Database Administrator

Responsibilities:

• Configured Data Guard using physical Standby database.
• Upgraded the database from Oracle 10g to 11g on Linux platform.
• Exposed to Real Application Clusters RAC on Oracle 10g using Automatic Storage Management ASM .
• Created and managed users, roles and profiles, audited and monitored databases and user access
• Created database objects, managed partitioned tables, managed table spaces.
• Used Recovery Manager RMAN and Enterprise Manager for various maintenance tasks like backing up of database, restoration and recovery of database.
• Developed UNIX shell scripts for automating many tasks.
• Extensive user of crontab in Unix environment for scheduling routine tasks
• Configured OEM and Performed database monitoring using OEM.
• Password security management at database level as well as operating system level.
• Loading flat file data into tables using SQL loader
• Extensively used exp, imp and data pump utilities to build changes.
• Responsible for all production patching, maintenance and support activity
• Responsible for Partitions on tables and Indexes for managing large tables.
• Wrote shell scripts for monitoring the database.
• Maintain 24 hours uptime for the database while carrying out the activities.
• Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora
• Worked with Development team to fulfill the requirements of applications with Database design
• Database performance tuning using v tables, STATSPACK, TKPROF, OEM .
• Maintaining data integrity and tune database for optimum performance and availability.

Environment: Oracle 10g/ 11g, Red hat Linux 5.0, SQL Plus, OEM, Confio Ignite, Putty, Toad, SmartFTP, SQL server 2005, Business Objects XI 3.x , Crystal Reports XI.

Confidential

Oracle Database Administrator

Responsibilities:

• Exposure to Real Application Cluster RAC environment with Auto Storage Management ASM on Oracle 10g.
• Created and configured Data Guard using physical Standby database on a fresh server starting from Oracle Installation
• Performed regular Backups and Recovery as per Organization Strategy to support the database and also
• Worked in backup team and was responsible for configuration and implementation of backup strategies using RMAN.
• Performed Partial, Complete and Metadata Exports Imports.
• Involved in upgrading application database from Oracle10g to Oracle 10g.
• Capacity Planning, Storage Allocation and Space Monitoring Management.
• Created Tables with appropriate Tablespace and Index.
• Created Users, Roles and Schemas with suitable Permissions.
• Maintained Logs/Backups using Imp/Exp Utilities.
• Automated many common tasks using crontab including: Backups, exports and imports, archiving old Records and verification of such processes.
• Automating processes, Scheduling Jobs per user requirements using DBMS JOB.
• Performed SQL tuning by using Explain Plan and TKPROF and Oracle Enterprise Manager.
• Responsible for Data Integrity and Concurrent Data, Locks, Latches and Deadlocks.
• Designed logical and physical Data Models using ERWIN.

Environment: Oracle 11g/10g, Linux 3.0, RAC, ASM, TOAD, OLTP, Putty, Mobaxterm, SQL Plus, SQL Loader FileZilla, Crystal Reports.

Confidential

Oracle Database Administrator

Responsibilities:

• Installation, Configuration and deployment of Oracle 10g database and Real Application Clusters RAC on different nodes on Solaris with ASM.
• Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using SQL, PL/SQL and UNIX shell Scripting.
• Implemented database refresh with the hot backup using DUPLICATE or full export.
• Used RMAN for Backup Recovery.
• Performance Tuning of application be identifying the SQL, which are not written well, providing
• inputs to the application programmer, correcting and implementing the right components
• Reviewing performance stats and recommended changes for tuning database, server, and storage configurations, as well as application SQL
• Participating in periodic backup audits, including test restores ensuring all databases and associated

Environment: Oracle 10g/11g, Quest Toad Ver8.5, SQL Loader, Windows, Sun Solaris 5.8, Erwin4.0, Data Guard, OEM, RMAN, Exp/Imp, SmartFTP, Putty, SQL Trace, People Soft

Confidential

Oracle Database Administrator

Responsibilities:

• Structured and maintained database. Monitored database space usage and system sizing.
• Analyzed oracle database performance.
• Troubleshoot and supported data system.
• Implemented multi-join queries to generate reports from database per request
• Exported and imported database for development and QA. Uploaded database per request
• Used to do HOT backup every day and COLD backup once in two weeks on the application
• database techniques using RMAN and conducted disaster recovery drills
• Designed database, Managed database space usage, Created database users and managed database
• Security to ensure for the continued accuracy, reliability and integrity of the data systems.
• Experience in Backup Recovery and explaining SQL: optimized SQL statement by using hint to change the access path and join order tuned table access, optimized full table scans and index lookups.

Environment: Oracle 9i/ 10g, Red hat Linux 4, Windows 2000/NT, SQL Plus, SQL Developer, TOAD 8.5

Confidential

Oracle analyst DBA

Responsibilities:

• Created data model, logical design, and physical design of the database.
• Involved in various stages like development, system Analysis, and design for new application.
• Developed stored procedures, functions, views and triggers.
• Actively participated in gathering of User Requirement and System Specification.
• Created new database logical and physical design to fit new business requirements
• Identified, tested, and resolved database performance issues monitoring and tuning to ensured database optimization by using Index Tuning Wizard, SQL Profiler and Query Analyzer execution Plan .
• Backing up entire user's database and scheduling backup process.
• Used DDL and DML to writing triggers, stored procedure to check the data entry and payment verification.

Environment: Oracle 9i, Quest Toad Ver8.5, SQL Loader, Windows server 2003/2000