SUMMARY

• Double Masters in Computer Science with over 20 years of Experience.
• Database Specialist with a proven record.
• An Oracle Pl/Sql Expert with extensive experience working in technologies including Oracle, Netezza, Linux, Unix, TWS, Autosys.

TECHNICAL SKILLS

OS: Linux, Unix, Ultrix, VMS, Windows, OS/2, MS - DOS

Languages: PL/SQL, Shell Scripting - Korn/Bourne/C shells, sed, awk, C, Visual Basic

DBMS: Oracle, Netezza, Microsoft SQL Server, Sybase, Microsoft Access, Paradox

Internet: Oracle iAS, OAS, Apache, HTML, Java, XML, JavaScript

Tools: SQL*Loader, nzsql, nzload, Export/Import, Explain Plan, DBArtisan, Winsql, Toad, TFS

Others: TWS, Autosys, Control-M, Oracle AQ, Crystal Reports, Performance Tuning

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Responsibilities:

• Extensively worked on Oracle 11.2 / Netezza 7.2.0.
• Designed/Developed a generic process to refresh data from Oracle to Netezza. A time-critical, robust process saving time and effort providing alerts to the support team in case of issues.
• Responsible for developing multiple processes using Shell Scripting, SQL*Loader, Pl/Sql, Netezza.
• Troubleshoot the slow running processes and Performance Tuning of SQL scripts - Indexes (Bitmap, Function-based), Optimizer Hints, Partitioning was used.
• Key player for the Team in the Infrastructure Refresh from one Data Center to another. Performed the Migration of the Development infrastructure, setup of user environments etc.
• Planned and executed to perfection. Unix utilities like rsync, ssh, sftp, sed, df/du, gpg, wget, curl was used.
• Setting up of pgp/gpg keys using public key cryptography.
• Role of TWS Admin for the DB Team performing dataexport/dataimport of TWS objects, Creation of Schedule/Jobs, Load Balancing and Maintenance. Performed TWS Upgrade from 8.6 to 9.2.
• Responsible for setting up of multiple Alerts for the Team’s infrastructure.
• Primary member of the Code Review Board.
• TFS Admin for the Team and involved in the migration to another data center.
• Technical Lead for the Team for troubleshooting/fixing any issues related to Oracle, Netezza, Shell Scripting, TWS, TFS.

Confidential, Boston, MA

Responsibilities:

• Developed, supported and maintained Fidelity Message eXpress, Message Center Application, Investor Preferences Center, Email Review & Management System.
• Participated in the design discussions of the Application development. Involved in the write up of the technical documentation of Systems Design Specs and Technical Specs.
• Development in Pl/Sql and configuring the application java middle tier with XML over HTTP between the applications.
• Worked as a Release coordinator of all the application deployment scripts and maintained the database objects in sync with all the environments.
• Worked in the committee in establishing the coding standards, version control system and application support.

Confidential, Boston, MA

Responsibilities:

• Responsible for providing technical and organizational leadership for the agency’s database environment including strategic planning for all database activities and overseeing the development, use and organization of the databases.
• Responsible for supervising the data team and managing and setting priorities for all projects.
• Planned and oversaw maintenance, security, design, and use of the databases.
• Acted as liaison between various stakeholders of the databases including staff and external partners to define and prioritize reporting needs for all programs.
• Developed and maintained documentation related to the design, use and security of databases.
• Managed a team of 4 including application developer, reporting specialist, data collection coordinator and data entry manager.
• Facilitated meetings of PIC workgroups relating to use of the databases.
• Assisted in the back up, recovery and performance tuning of the agency’s databases.
• Performed the performance appraisals of the Data Team members.

Confidential, Boston, MA

Responsibilities:

• Responsible for the development and support of Right Time Marketing, Customer Service Database application systems in Oracle.
• Extensive Pl/Sql scripting involved in the backend application code. Dynamic Sql was used for the late binding processes. Responsible for creating lot of adhoc reports.
• Oracle AQ used to queue up the messages to other applications.
• Fine-tuned SQL queries in the existing applications that were causing performance bottle-necks for optimum performance using tuning tools like EXPLAIN PLAN and also made use of Oracle function-based indexes.
• Analyze tables and indexes, identify and build missing indexes and rebuild indexes when needed and monitored and tuned the database.
• SQL*Loader, Data Pump, Flashback, PL/SQL file manipulation utilities like UTL FILE and UNIX utilities such as sed/nawk were extensively used.
• Performed the DBA role in maintaining the application development environments.
• Performed logical backups using Export/Import utility, setting up schemas, creating indexes.
• Carried out the production refresh of data into the development environments. Responsible for syncing up the data across different environments.
• Worked on the Java servlets for the application systems in Visual Café.
• Performed the product evaluation of Oracle IAS and IBM Websphere. Configured, Installed and Maintained Oracle IAS.