SUMMARY

• Oracle Certified Database Administrator(OCA 11g) with 7 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 and development support, installation, configuration, upgrades, patching, 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.
• Experience working in both OLTP and OLAP environments.
• Administration experience of various database environments consisting of over 40 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.
• Have ability to perform root cause analysis, Performance monitoring and application related issues.
• Worked in production Support on Key Financial and multi - Terabyte Databases.
• Provided On-Call support.

TECHNICAL SKILLS

Operating System: RHEL, IBM-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:

• Perform User Management, Space management for production, development as well as test database environments.
• Provide support for application development teams by creating and managing various database objects like Users, Tables, Views, Synonyms, Database Links, etc.
• Involved in backup, restore & recovery strategies using RMAN& user managed techniques.
• Used Oracle SQL Developer, Grid Control (Enterprise Manager), SQL Plus and TOAD to monitor & administer the environment.
• Export import of data between servers using data pump utilities (expdp/impdp) and FTP, SCP, etc.
• Configured Data Guard for development environments for application testing, using Enterprise Manager Grid Control.
• Installation, Configuration and Maintenance of Oracle 11g two node RAC.
• Cleanup activities at database as well as operating system level.
• Clone the production database and deploy on test/development servers for test/development purposes.
• Involved in Analysis, planning, design and development of the database Instances on dev and test environments.
• Created, modified & deployed listener files using Net Configuration Assistant (netca) GUI and command line as well, on various clients & servers.
• Take part in all the daily DBA activities.
• Loading, importing, exporting bulk data & database objects using SQL Loader and data pump utilities.
• Document and update daily changes related to the user requests.
• 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.
• Altered and developed functions and procedures, and packages using PL/SQL to implement business rules.
• Involved in shell script development for automating & scheduling database maintenance jobs (stats collection, alert log reset, etc.) and database monitoring.
• Developed stored procedure, triggers and packages for batch process and online process.
• 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.
• 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.
• Monitored the CPU utilization and performance using UNIX utilities.
• Managed projects by developing implementation plans and 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, RAC,TOAD, SQL Developer, Grid control 11g, Data guard, Putty, SharePoint, SQL Loader, data pump utilities, Control-M,PL/SQL,ASM, RMAN

Confidential, New York

Database Administrator

Responsibilities:

• 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).
• Automated the hot, cold, RMAN backups and Stats pack using script and scheduled in control-M.
• Maintained documents of Oracle database operations. Prepared documentation of database backup and recovery standards.
• 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 OracleDatabaseSoftware11g.
• 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 11g RAC.
• Successfully provided 24/7support for production, development, and test database.
• 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.
• 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.
• Backup and Recovery using RMAN, Hot Backup and Cold Backup.
• Maintained documents of Oracle database operations. Prepared documentation of database backup and recovery standards.

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

Confidential

PL/SQL Developer

Responsibilities:

• Designed the Functional Requirements and Mapping Technical Specifications on the basis of Functional Requirements.
• Created Index, Views, Stored Procedures, Triggers, Cursors and appropriate User defined functions to implement the business logic.
• Participated in different meetings, walkthroughs with developers and business analysts to review Business, Functional and System Requirement documents
• Requirements gathering, Analysis and Design of all the client requirements.
• Created indexes for the faster retrieval of data from the database.
• Prepared technical documentation for business reviews for management
• Handling of problem tickets.
• Involved in Monthly Release and Change Activities of code deployment
• Involved in performing Health Checks.
• Involved in Support Activities of Database.

Environment: Oracle 9i, PL/SQL, Java, TOAD, SQL Developer

PL/SQL Developer

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