SUMMARY:

• Extensive experience with SQL Server 2005/2008, installation, configuration, performancetuning, backup/recovery and working knowledge of MS Windows 2008 O.S
• Solid understanding of execution plans and how to use them to optimize/improve query costs
• Database consistency check using DBCC, alerts and event configuration
• Possess experience in high availability features - cluster, replication and SQL Server2008 SSIS & posses knowledge in database mirroring & log shipping
• Strong background in SQL (stored procedures, T-SQL, functions & triggers)
• Broad knowledge of related infrastructure, tools and services in support of SQL Server databases such as SANs, Active Directory, backup technologies, application integration, and business continuity.
• Strong communication skills, technical writing and documentation

TECHNICAL SKILLS:

Databases: SQL Server 2005/2008, Oracle 9i, Sybase 11, Access, SQL Anywhere, DB2

Software/GUI: Power Builder, Visual Basic, Java Script, COBOL, HTML, SQL, PERL, DB Artisan

Application & Tools: S-Designer, PVCS, Visio, Voice Prompt Manager & MS-Office

OS: Window 98/2000/2003 , UNIX (Sun Solaris), Apache Server, AS/400

PROFESSIONAL EXPERIENCE:

Confidential, Westchester, IL

SQL Server, DBA

Environment: SQL Server 2008, MS-Office, Star designer, Share Point, Window 2003 Server

Responsibilities:

• Installed SQL Server and service packs registered SQL Server instances and configuration
• Maintained eight SQL Servers including backups, restoration, troubleshooting and performance monitoring
• Configured backup plan, integration check and other cleanup scheduled jobs
• Perform security services adding, deleting user logins, role assignment and modification
• Involved in migration conversion of MS Access database applications to SQL server 2008
• Provide server and Windows level trouble shooting, performance tuning on users applications using event viewer and performance monitor
• Created database and performed data modeling for web and HR applications
• Generate Ad-Hoc reports using T-SQL, Access database and Excel worksheet using export/ import utility
• Design stored procedures, triggers, created tables, views, and functions for production application
• Configured replication servers, database mirroring, log shipping and clusters

Confidential, PRINCETON, NJ

SQL Server, DBA/Developer

Environment: SQL Server 2005, Sybase(ASE)11, Power Builder 6.5, Erwin, Sun Solaris, Unix, PVCS

Responsibilities:

• Developed stored procedures, triggers for the IVR application using T-SQL
• Worked with developers to tune the SQL queries using SQL profiler
• Involved in migration from Sybase 11 to SQL Server 2005 with SSMA and manual conversion.
• Reinstallation of SQL server, data modeling, stored procedures and other object upload using PVCS, version control application
• Provided setup and configuration for framework model as well and customized clinical trial application, IVRS/IWRS. Providing complete SDLC support including migration from development to production servers.
• Performed DBA duties database backups and restores minimum downtime data transformation
• Database maintenance plans, jobs creation, testing database log space monitoring and maintenance
• Handling defragmentation / Statistics / re-indexing and other related slow performance issues
• Ensuring all changes are first tested on acceptance test servers and then applied on production Servers. Keeping the production and acceptance environments synchronized. Ensuring that all databases are secured with well defined permissions and roles
• Provide integrity check, optimizations, and transaction log backup jobs
• Setup SQL Mail and SQL Agent Mail and replication server, subscribing document to client database
• Troubleshooting of systems related problems and maintain availability, performance, integrity and security of systems
• Ensuring sizing & tuning that the proper hardware resources are acquired before database implementation of any system and continue to be used appropriately during an applications life cycle and assisting the resolution of escalated incidents and participates in problem management activities

Confidential, North Plainfield, NJ

Programmer Analyst

Environment: Power Builder, Sybase 11, Oracle 9.1, MS Excel, Erwin, Window 2000, Sun Solaris, Unix

Responsibilities:

• Supported client oriented sales support and marketing tool application, CRM 24x7. Maintained PL/SQL stored procedures and wrote SQL queries for Datawindow, PowerBuilder application. Provided adhoc reports on SQL Plus
• Invoice generation, billing reconciliation application using Sybase 11, Access database and MS Excel.
• Created SQL Queries to retrieve historical data to be used for financial reports on access, manipulate data on excel for billing reconciliation and auditing
• Created scripts on Unix for maintenance of Sybase stored procedures
• Developed Sybase stored procedures and triggers
• Developed Excel spread sheet from vendor’s reports, created functions on excel to link access database in order to reconcile invoices, generate credit reports for customers
• Maintained Sybase application. Wrote MQ Series message calls on Sybase stored procedures

Confidential, NEW YORK, NY

Programmer

Environment: Power Builder 7.0, PFC, Oracle 9, Window 98

Responsibilities:

• Developed and modified application on Power Builder and Sybase stored procedure support
• Used data Windows Services of PFC for enhancement of survey processing module
• Provided Data Modeling for Sybase database using Erwin tool
• Documented and provided to the users and programmers on extension module of Integris System
• Integris is a survey processing system built on PFC and CS (Corner stone libraries). This system generates ad-hoc reports with Power Builder on client side integrated with Sybase stored procedures
• Trouble shooting and responding to client call on day to day basis

Confidential, PRINCETON, NJ

Programmer Analyst

Environment: Power Builder 6.5, Sybase 10, Visual Basic 6.0, Star Designer, PVCS, Sun Solaris, Unix

Responsibilities:

• Deployed help-desk and administrative support application on Power Builder
• Participated as a lead programmer in deployment of project specific application in Visual Basic
• Developed interface to Confidential t’s clinical trial records, Drug management of Site Inventory and Ware House Inventory system
• The IVRS system was based on Sybase 11.0. Interface connected through heavy usage of stored procedure and triggers
• Involved as major team member in building Interactive voice response (IVRS) application on Visual Basic using Visual Voice Prompt Manager and ODBC connectivity for 4 different Sybase databases
• Developed Demand Projected Module (DPM), background processes that produces forecasting reports and mail them to recipients in the PDF format
• Performed data modeling for Sybase using ERWin and Start Designer tools
• Used PVCS for managing version control of stored procedures, Power Builder libraries, Visual Basic files, VOX files and documentation