SUMMARY

• Oracle Certified Database Administrator(OCA 11g) with 9 Years of experience on various Linux, UNIX and Windows platforms with Oracle databases (9i,10g, 11g), having hands on experience in database administration, production, Test & development support, installation, configuration, upgrades, performance tuning, backup and recovery, cloning and capacity planning.
• Experience in all stages of system development life cycle, including requirement gathering, analysis, design, development, and maintenance of the system.
• Experience in Installation, configuration and maintenance of Oracle 10g, 11g databases on UNIX, AIX & Windows Servers.
• Excellent skills in creating database objects like Tables, Procedures, Views, Materialized views, Indexes, Triggers, Cursors, Packages, Records, Sequences, Synonyms, functions, etc. using SQL & PL/SQL.
• Experience creating databases using scripts & DBCA utility.
• Experience in SQL query optimization and performance tuning.
• Good experience working in RMAN, RAC, and Data Guard environments.
• Experience using data pump utilities, SQL Loader, External tables, etc.
• Database performance monitoring & tuning experience using SQL Developer, Oracle Grid Control, AWR report, TOAD.
• Excellent experience in backup, restore and recovery procedures.
• Complete ETL cycle experience including data analysis, database design, data mapping and conversion and data load using SQL Loader.
• Experience working in both OLTP and OLAP environments.
• Administration experience of various database environments consisting of over 30 databases.
• Experience using SharePoint and MS Dynamics CRM for documentation management, information sharing, etc.
• Strong experience managing database Users, related to database security/permissions.
• Experience in creating and using database links & network link in multiple database environments.
• Supporting the day to day development activities by working with the application development team on database issues.
• Good experience in Database Performance Tuning using Explain plan, SQL Trace, Stats pack, TKPROF, AWR, ADDM and ASH.
• Have ability to perform root cause analysis, Performance monitoring and application related issues.
• Worked in production Support as a Level2 Database developer on Key Financial and multi - Terabyte Databases.
• Provided On-Call support.

TECHNICAL SKILLS

Operating System: RHEL, Confidential -AIX, Windows, Sun Solaris

Programming Language: SQL, PL/SQL, Shell script, XML, HTML

Databases: Oracle 9i/ 10g/ 11g, MS-Access, ODBC

Other tools: SQL*Plus, Oracle Enterprise Manager (OEM), RMAN, SQL*Loader, TOAD, EXP, IMP, data pump, Data Guard, Putty, winSCP, FTP, SFTP, SCP, TELNET

PROFESSIONAL EXPERIENCE

Confidential, New York

Database Administrator

Responsibilities:

• Migrated and upgraded databases from version 8i to 9i and 9i to 10g.
• Designed and implemented effective solution for enterprise backup and recovery strategies for databases using RMAN.
• Responsible for handling case management with Oracle technical support
• Good in troubleshooting the problems finding root causes and work with other teams for corrective actions.
• Installed and configured Oracle server and clients.
• Perform User Management, Space management for production, development as well as test database environments.
• Cleanup activities at database as well as operating system level.
• Used Oracle SQL Developer, Grid Control (Enterprise Manager), SQL Plus and TOAD to monitor & administer the environment.
• Altered and developed new functions and procedures, and packages using PL/SQL to implement business rules.
• Implemented proper database security for users assigning appropriate roles to the users.
• Developed and tested backup shell scripts, plan schedules for Oracle databases.
• Involved in shell script development for automating & scheduling database maintenance jobs (stats collection, alert log reset, etc.) and database monitoring.
• Involved in monitoring & administering Oracle databases in Production, development & test environments using Oracle Enterprise Manager (OEM).
• Developed stored procedure, triggers and packages for batch process and online process.
• Used data pump utility for import and export of data.
• Worked in partnership with Business Analysts during initial project meetings to gather data and analyze requirements and data model design.
• Performed application tuning using Oracle Trace and analyzing the execution plans, tuned the queries by creating proper indexes and modifying the PL/SQL procedures.
• Generate automated and load processes, batch job administration, optimize database performance and SQL queries.
• Experience in using packages like DBMS JOBS to schedule tasks Involved in developing UNIX shell scripts to automate and scheduled the database jobs.
• Created/Alter Partitioned tables for large customer related data.
• Used DBMS STATS to gather the statistics along with analyze command
• Responsible for purging and archiving the production databases.
• Experience in Extracting, Transforming and Loading data from various Flat Files using SQL loader utility.
• Monitored the CPU utilization and performance using UNIX utilities.
• Managed projects by developing implementation plansand timelines, providing weekly status reports, preparing technical documentation pertaining to various projects.
• Documented, maintained and provided installation & procedural manuals for support staff.
• Involved in all the phases of SDLC.
• Provided 24/7 production database support.

Environment: Oracle 10g & 11g, AIX, TOAD, SQL Developer, Grid control 11g, Data guard, Putty, SharePoint, SQL Loader, data pump utilities, Crontab, Data Warehouse, RMAN, Oracle BI Admin, Discoverer plus & desktop

Confidential

Senior Software Engineer

Responsibilities:

• Day to Day General Administration Table space Management, Undo Management, Managing Users, Resources, Managing User Privileges and Roles.
• Performed Database Refreshes and Database Copies for Development, Test and Production databases.
• Implemented basic replication through Materialized Views.
• Created and maintain users, roles and privileges.
• Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans.
• Performed SQL tuning and assist developers with coding PL/SQL.
• Developed Shell scripts to automate database operation and database monitoring.
• Done modifications to the already existing logical/physical design models and reflect the same in Dev. Databases, based on the enhancements in the application.
• Troubleshoot and determine solutions for problems found in Application and database.
• Administering through Oracle Management Server (OEM).
• Backup and Recovery using RMAN, Hot Backup and Cold Backup.
• Automated the hot, cold, RMAN backups and Stats pack using script and scheduled in crontab.
• Maintained documents of Oracle database operations. Prepared documentation of database backup and recovery standards.
• Performing all daily maintenance tasks. Interacting with Oracle Customer service as and when required.
• Created Configured and Setup RMAN Catalog databases and registered target databases with the Catalog.
• Perform daily incremental backup and full weekly backup using Oracle backup utility RMAN.
• Creation and maintenance of standby databases
• Managing Rollback Segments, Redo logs, Control files, and Table spaces.
• Installation and configuration of Oracle Database Software 10g.
• Developed PL/SQL Code for migration of packages and procedures
• Extensively involved in Weekly Maintenance, Re-Organization and Health Check of Databases.
• Managed batch jobs using Control-M for various operations.
• Monitor SGA, Memory Segments, DB and Log Buffers, Disk storage growth, Network status
• Worked as an Oracle DBA for various versions from Oracle 8.x, 9.x, 10.x and also Oracle 9i RAC and 10g RAC.
• Experience with testing and pre-production of Oracle 10g with ASM.
• Successfully provided 24/7 support for production, development, and test database.

Environment: Oracle 9i &10g, TOAD, SQL Developer, Java, HTML/Java Script, PL/SQL, Control M(scheduling), putty, Unix scripts, AIX, FTP, Database connections, MQ, DBus

Confidential

Software Associate

Responsibilities:

• Developed proper process for database schema changes and code migration from development to QA and QA to Production environments.
• Developed PL/SQL Stored procedures, packages and triggers.
• Involved in Design, development and testing phases.
• Tested programs and screens.
• Involved in debugging and supporting to fix problems at development and production stages.
• Worked with QA testers on developing test scripts
• Interact with client to study and analyze requirements specifications for the system
• Involved in writing different Technical documents at each phase of the project.
• Created, altered and managed users, roles, groups, Profiles, etc. to enhance database security.
• Administered and maintained Oracle databases.

Environment: Oracle 9i, PL/SQL, Java