Synopsis

• Highly motivated Database Administrator with over 15+ years experience in Information Technology.
• Knowledge in all aspects of Oracle Database Administration, Architecture and PL/SQL Coding. Proven ability in tuning and optimizing applications/databases.
• Four plus years of experience in managing projects and teams. Proven project and people leadership skills, can effectively manage and mentor database and application developers through the entire software development cycle. Have successfully managed projects through planning, executing, controlling, closing and transitioning to support phases by detailed task assignments, estimates, resource planning, meticulous tracking and thorough up-to-date documentation
• Strong analytical and problem solving skills with ability to communicate effectively among peers and team members.
• Highly organized and excellent team player with the ability to manage multiple projects and meet critical deadlines.
• Thorough comprehension of software development life cycle with full ownership and accountability for critical modules. Ability to work closely with cross-functional teams in very fast paced and dynamic work environments
• Domain expertise in various business sectors including Engineering, Retirement (401k) Plans, Insurance, Banking, Stock Exchange, Car Auctions, Stock Broking sectors, Federal Government Grants/Reporting.

Education

• Bachelor’s in Electronics & Power Engineering
• Oracle Database Administration Workshop

Technical Skill set
Databases : Oracle 7.x/8i/9i/10g/11g, SQL Server 6.5/2000/2005, MS Access
GUI Tools : Oracle Forms 3.x/4.x/6i/9i/10g, Reports 2.x/4.x/6i/9i/10g,
Oracle ADDM, APEX, Oracle Enterprise Manager,
Oracle AQ, Toad, SQL Developer, PowerBuilder, Crystal Reports
Web Technologies : ColdFusion, PureEdge XFDL, XML/XSD, Oracle PL/SQL Web toolkit
Database Reporting Tools : Discoverer, SQL Server Reporting Services, SQR
Database Modeling Tools : ERWin, Designer
Languages : SQL, PL/SQL, T-SQL, Pro*C, HTML, DHTML, PHP, JavaScript
JDBC programming, CFML, Basic Java programming,
Basic Shell Programming
Utilities : SQL Server Gateway, Unix Reflections, MS Visio, PVCS, RPM, Rational Clear Case, Clear Quest, Lotus Notes, MS Office
Database Administration : Oracle, SQL Server
System Administration : ColdFusion Server, Oracle iAS Server, Redwood Server
Operating Systems : Sun Solaris, HP-UX, AIX, Windows

Professional Experience

Confidential,Bethesda, MD Feb\'10-Current
Sr. Oracle DBA/Developer
· Lead and mentor a team of 6 application developers and a junior DBA.
· Support daily operations of the production/Dev/QA environments by proactively managing the performance, integrity, and security of business applications\' databases and database servers.
· Monitor database space usage proactively and perform capacity planning analysis.
· Responsible for synchronizing and migrating data and database objects between development, QA, and production environments; perform periodic database refreshes.
· Migrated 6 databases from 10g R2 to 11g R2.
· Created a new RAC test instance and worked with the development team to identify issues and enhancements needed for running their applications on RAC databases.
· Wrote RMAN scripts for performing nightly as well as monthly backup’s.
· Worked with the Business Objects team to define, identify and create objects as well as a new database for BI reporting for Dev/QA/Prod environments.
· Created new back-end PL/SQL processes for grants processing under American Reinvestment and Recovery Act (ARRA).
· Developed PL/SQL coding standards.
· Modified, enhanced, and tuned various existing PL/SQL modules.
· Wrote PL/SQL back-end code for generating reports for ARRA as well as perform data call requests from time to time.
· Wrote technical and user documentation of nightly batch jobs comprising over 1m lines of code.
· Participated and contributed towards CMMI Level 2 and Level 3 certifications as lead DBA.

Confidential,Houston, Texas Jan\'09-Jan’10
DBA Consultant
· Create new instances with seed data for new projects; included them in daily and weekly backup’s.
· Perform on-demand database refreshes; quarterly patching; resolve application performance issues.
· Worked with the BI team to identify data needed to be passed on to BI warehouse and wrote and scheduled PL/SQL scripts to do the same nightly.
· Performed maintenance work and enhancements on existing PL/SQL back-end modules.
· System administration of Oracle iAS and Redwood Servers.

Confidential,Austin, Texas May\'08-Dec’08
Sr. Developer Consultant
· Created websites in ColdFusion for various corporate clients of The 401 Company that served as the 401k record keeping and trading platform so that their employees could enroll and set up their 401k accounts.
· Performed maintenance work and enhancements on high-traffic 401k sites.
· Gathered business requirements from the new 401k clients to migrate their data to the 401k Company database. Wrote Oracle stored procedures for migration of data.
· Modified and tuned existing Oracle queries to improve their performance.
· Upgraded ColdFusion 5 pages to ColdFusion MX.

Confidential,Carmel, Indiana Oct\'07-Apr’08
Sr. Oracle Developer Consultant
· Lead a team of 2 developers and 2 analysts/testers to create a new application in Oracle Forms and
PL/SQL packages for financing salvage car dealers. Worked with business analysts and senior management
to gather requirements and design the system.
· Tuned around 20 Oracle Packages to improve performance of the car dealer loan application system.
· Wrote and modified Oracle Apps alerts.

Confidential,Houston, Texas May’01-Sep’07
Sr. Software Engineer/DBA
· DBA for 3 Oracle databases; backup DBA for SQL Server database.
· Implementation and Administration of Oracle 9iAS server.
· Created over 20 Oracle Reports for Claims application.
· Wrote/Modified scripts to generate nightly business reports from Oracle and SQL Server databases using
PL/SQL, T-SQL.
· Created PL/SQL procedures and functions for generating financial transactions reports and displaying
them on the web using PL/SQL Server pages.
· Designed and developed 13 stored procedures in SQL Server database. Added functionality to the stored
procedures to develop HTML pages using SQL Server Reporting Services.
· Wrote around 45 PL/SQL packages, stored procedures, functions and triggers along with SQL Loader
scripts to migrate over 20 Gigs of mainframe data into Oracle Claims database.
· Upgraded v6 forms to 9i web-enabled forms.
· Led an offshore team of 3 developers to upgrade around 120 Oracle Forms and 10 Oracle Reports
from v4.5 16-bit to v6 32-bit client server. Worked with the QA team for performing comprehensive testing.
· Upgraded the v6 Oracle Forms and Oracle Reports to web-enabled 9iAS.
· Led a team of 2 developers for the Analysis, Migration, upgrade of Reinsurance PowerBuilder software
application to ColdFusion.
· System Administration of ColdFusion server.

Confidential,Houston, Texas Nov’98-Apr’01
Sr. Software Consultant

· Designed prototype for automation of new business payroll accounts globally. Designed and created the
entire Oracle database.
· Developed an application for validation of new business payroll accounts using Pure Edge XFDL, Java,
ColdFusion, XML, and Oracle PL/SQL stored procedures. The programs extracted data in XML form from
PureEdge forms using XFDL, Java, XML, ColdFusion, Oracle. The XML data was then sent to mainframe
servers for validation through CORBA objects. An XML response file was then sent back by the server and
depending upon the response the users were notified of acceptance or changes/documents needed.
· Scheduled the programs to run every 3 mins. on week days and wait an hour incase the mainframe
servers were down. Emails were generated to notify administrators in case the servers are down.

· Developed 8 web screens using ColdFusion, Java and JavaScript. Screens are used to register new users,
login, perform encryption/decryption of credit card data. Wrote 26 stored procedures/functions in Oracle.
· System Administration of ColdFusion server.

· Developed 6 web screens for this online travel services company in ColdFusion, ASP, JavaScript, and
Macromedia Fireworks/Dreamweaver. Screens were used to login, register new users and make online
reservations. Stored procedures were written in SQL Server.
· System Administration of ColdFusion server.

· Analysis, customization, implementation of the entire Claims system brought from PriceWaterhouse
Coopers (PwC) in Oracle Forms, Oracle Reports and Pro*C.
· Modified and enhanced 32 Oracle Forms and 4 Oracle Reports.
· Developed 3 new Oracle Forms for Workers Comp and SROI/FROI business lines.

Confidential,Bombay, India Aug‘95-Oct’98

· Responsible for maintenance and enhancement of around 25 Oracle Forms, 20 Oracle Reports and 15
PowerBuilder screens.
· Created 11 Pro*C programs for uploading/downloading data to/from flat files.

· Wrote approach, analysis and design paper.
· Designed 7 PowerBuilder screens and 4 Crystal Reports. Back-end packages were written in Oracle.

· Responsible for maintenance, enhancements and development of 16 Oracle Forms 3.0, 12 Oracle
Reports 1.1, 6 Proc*C programs. Oracle 7.1 database and Sun Solaris operating system.