Summary:

• Over 4+ years of experience in full application life cycle development, testing and production in Information Technology - Software Industry
• Over 3+ years of experience in creating and modifying the PL/SQL procedures, functions according to the business requirement.
• 9 months of experience as a DotNet and PHP developer/programmer.
• Hands-on experience with design and development of SQL and PL/SQL packages
• Sound knowledge of Oracle 11g, 10g environment and Oracle relational database.
• Profound knowledge of using Visual Basic, .Net platform, VB.Net, ASP.Net and C.
• Huge knowledge of Unix Shell Scripting and Unix commands
• Expert in advanced PL/SQL techniques in a 11g and 10g environment
• Used SQL LOADER to upload the information into the database tables.
• Created database objects like stored procedures, function, packages, Cursor, Ref Cursor and Triggers.
• Wrote and modified Oracle PL and SQL, Sql statements procedures and functions that are called in the Java Scripts, Jsp and EJBs.
• Involved in developing Oracle Reports which are further added to Web pages.
• Created and used XML for data management and transmission.
• Worked on OLTP for optimization and to facilitate the processing of large numbers of concurrent updates to an database.
• Worked extensively on Java and Dotnet for low level programming and C for embedded work.
• Involved in analysis, design, coding and Testing.
• Involved in creating Database Design (Physical and logical) as per the requirement given by business.
• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database.
• UNIX Shell Scripting to automate procedure execution from UNIX box.
• Involved in Performance Tuning using ADDM (Automatic DB Diagnostic Monitor) which makes thediagnostic data readily available.
• Rewrote, debugged and deployed enterprise applications using C#, VB.NET, ASP.NET.
• Wrote PL SQL statements, stored procedures and functions, following best practices regarding QA and implementation standards.
• Experience with designing and generating database objects and Oracle Forms, Reports using Oracle Designer
• Provided support on a rotational basis for a number of intranet applications. Trouble shooting issues. Developed and maintained DTS packages.
• Worked on performance issues and bugs within packages, forms, and reports using dbms_output, Forms debugger, explain plan and TKPROF
• Created documentation. Gathered requirements, wrote technical specifications, workflow diagrams.
• Testing: Created and executed test cases. Ensured bugs are logged and tracked through closure.
• Maintained and revised functional, technical, and screen design documentation.
• Maintained and updated database design schema.
• Created stored procedures using PL/SQL Developer.
• Created test scripts for application modules.
• Develop many custom software solutions to meet various specific business needs.
• Cultivate inter-departmental relationships as a “service department” for the company.
• Outstanding ability to apply Object-Oriented analysis and design
• Excellent written and oral communication skills

Technical Skills:

Languages C, VB.Net, ASP.Net, PHP, SQL, PL/SQL, Shell Scripting, PERL Scripting
RDBMS Oracle 9i/10g/11g, SQL Server 2000/2005/2008
Operating Systems Sun Solaris, Red Hat Linux, HP-UX, AIX, Windows NT/2000/2008
Tools Export/import, Data pump Exp/DPI, RMAN, SQL*Loader, OEM GC, LogMiner, Oracle streams, AWR, ADDM, STATSPACK, TKPROF, EXPLAIN PLAN (10046), Oracle SQL Developer, SFTP
Other Tools AUTOSYS, VNB, TOAD, VVM, BMC Patrol, Erwin, TSM, Legato Net Worker, WinSCP

Role: PL/SQL Developer
Responsibilities:

• Worked as a PL/SQL developer to support business applications using Oracle SQL and PL /SQL developer.
• Designed and created database tables, views, packages and stored procedures.
• Experience on working in a production database directly.
• Built and maintained SQL scripts, indexes, reports and queries for data analysis and extraction.
• Developed new processes to facilitate import and normalization.
• Worked with business users and application developers to identify business needs and provide solutions.
• Analyses and discuss the business requirements with the clients.
• Responsible for the development, implementation and support of the database of the server.
• Optimized and modified the triggers, complex store functions, procedures, user base data type etc.
• Worked on Oracle Forms based on stored procedures
• Worked with a team of 9 personnel for the development of the database, procedures, functions, etc.
• Responsible for the dealing with the problems, bug fixing and troubleshooting

Environment:For Oracle 11g and 10g Server as Back-end:

• Very high level of PL/SQL programming
• Database Triggers
• Stored Package & Procedure
• Views, Sequences etc.
• Oracle Forms

Role: PL/SQL Developer and Jr.Oracle DBA
Responsibilities:

• Worked as a PL SQL developer and handling all the duties and work assigned to this position efficiently:
• Mainly responsible for communicating with clients and understanding their business requirements to develop applications
• Handling other duties like designing, developing, updating, writing specifications and codes for applications
• Responsible for database administration and management by using knowledge of PL SQL programming
• Developing procedures using PL/SQL Developer and loading data using SQL*Loader
• Involved in creation of database objects like stored procedures, function, packages, Cursor, Ref Cursor and Triggers.
• Installation and maintenance of Oracle 11g/10g Data Guard 24*7 Production Environments.
• Shell Scripting, bash scripting and PL/SQL Programming to resolve business problems of various natures.
• Worked on the upgrade process of Oracle Forms and Reports 6i to 10g
• Extensively worked on imp/exp, impdp/expdp and SQL * Loader to load and unload data.
• Monitoring Cold, Hot and RMAN backup scripts of the databases supporting different applications.
• Used and maintained bitmap indexes, materialized views, DB links
• Experience in partitioning and sub-partitioning (Range, Hash, List, Composite) of tables in OLTP environment.
• Upgrading development and production databases to Oracle 11g and applied patches to Oracle Databases.
• Cloned/Refreshed Oracle Databases and Oracle applications for development and testing.
• Utilized Oracle Enterprise Manager (OEM), Grid control to manage users, privileges, profiles, and schemas. Installation, configuration and maintenance of Oracle 11g Real Application Clusters(RAC).
• Implemented Oracle Streams for the replication of data in Development to Production.
• Running Cron job to do scheduled task of database like backup with help of RMAN scripts.
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
• Oracle support and Meta Link are utilized to troubleshoot the problems and issues.
• On-call support regarding production - related database problems is performed.
• Provided 24X7 database administration support for production and development databases for customer clients.

Environment: Oracle 10g/11g, Oracle Forms, Oracle Reports, Windows NT, RAC, OEM, Grid Control, RMAN, DBCA, Data Guard, Putty, TOAD, SQL * Loader.

PL/SQL, DotNet, PHP Developer
Responsibilities:

• Project Name: Community Board project

Worked on community board project for Gannon staff to find the regular events organized by Gannon by using PHP as front end and MY SQL server as backend. Developed queries and incorporated with PHP to get and submit data.

• Wrote SQL queries for DML and DDL activities.
• Wrote Stored Procedures and created tables, packages and functions.

Software: PHP, MY SQL server 2000 as backend on windows platform

• Project Name : Patient Billing System for Hospitals

This project is aimed at developing a patient billing software system that is of importance to a hospital. The PBS is a local software system. This system can be used to maintain the location (bed no.) of each patient either in the ward or the ICU. Information about the patient and the charges to be paid is also stored.

Software: ASP.Net using ADO.net as front end, Oracle9i as backend on windows platform.

• Worked on stored procedures and made enhancements where required.
• Created tables and views with oracle as a database.
• Project Name: Cafe Project:

Worked on a faculty schedule report by using crystal report writer equipped with Microsoft visual studio 2008. Created SQL queries and sub queries to get needed data from SQL database for report.

Software: Microsoft visual studio 2008, MS SQL server 2000 as backend on windows Platform

Confidential,India May 08 Aug 09
Role: Jr.Oracle DBA and Database Developer

Responsibilities:

• Managed large tables using index and table partitions
• Created and monitored physical standby database (data guard)
• Maintained and managed daily operation of development, production, and test Oracle 11g and 10g databases
• Modified and defined database objects as per requirements.
• Wrote procedures, packages, functions and shell scripts.
• Used Cursors and ref cursors in the packages for referencing.
• Used Triggers for scheduled job activities like birthday reminders etc.
• Set up Cron jobs to monitor file systems usage, archive logs, backup logs and cleaning up of these file systems periodically, and also RMAN Hot Backup Scripts.
• Maintained regular free space checking and daily alert log checking by using UNIX cron jobs.
• Reorganized data files, identified and eliminated contention factors like I/O, buffers and locks
• Tuned Oracle Initialization Parameters.
• Applied latest patches as per requirement.
• Performance tuning and trouble shooting
• Performed crontab to send alerts by e-mail to DBA team, for any ORA errors in Alert Log files, file system utilization, table space and DB Objects monitoring.
• Configured TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Performs Oracle database administration tasks, including user administration, schema creation and maintenance, data validation
• Monitored the production databases for performance and tuned the databases where necessary to provide optimal response times
• Provided 24X7 support beyond regular hours.

Environment:Windows 2003, HP-UX, AIX, Putty, DATA GUARD, impdp/expdp, Oracle 11g/10g, TOAD, Oracle Partitioning, PL/SQL, Shell Scripts, Oracle Enterprise Manager

Role: Oracle Database Administrator
Responsibilities:

• Involved in production support activities 24/7 during on call and resolved database issues.
• Backup Script creation and Standardization. Performed Database Installation and up gradation.
• Created materialized views, table partition for Tuned databases.
• Created indexes, rebuild indexes and maintained indexes.
• Audited database for statements, privileges, and schema objects.
• Performed daily hot backup, weekly cold backup and full export/import
• Involved in user creation and user access control. Involved in Schema creation and management.
• Implemented Oracle security features and audit mechanisms for Fine grained access control.
• Maintained the RMAN repository and customized recovery catalog.
• Customized Data Guard as a tool for Disaster Planning and implementation.
• Created Logical and Physical standby Databases to ascertain high availability of database during system crashes.
• Taking care of Rollback/Undo segment Issues
• Performed database tuning for daily loads and slow response issues.
• Used Triggers for database activities, like delete, update triggers.
• Involved in session management and monitored the critical wait events in the database.
• Involved In query optimization and using rule based optimizers and cost based optimizers.
• Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas.
• Used SQL* Loader for data import from remote databases
• Written the control files in SQL*Loader to load the files in database tables.

Environment: ORACLE 9i, SQL, PL/SQL, Toad, Erwin, Import/Export, RH Linux, Windows NT.

EDUCATION:

• Master of Science Computer and Information Science
• Bachelor of Technology