OVERVIEW
Over 7+ years of experience in Database Administration,System design, development, implementation and testing of SQL Server in development,testing,staging and production enviroments.
Extensive knowledge of Internet Technology, ColdFusion 8.0/7.0/6.0/5.0/4.5, Flex 2.0.2, Java 1.6, ActionScript 3.0, JavaScript, JSP, Perl 5.8, ASP.NET, Crystal Reports 8.5, Power Builder 6.5/7/8, Visual Basic 6.0 HTML, DHTML, IIS 4.0/5.0 and database technologies Oracle 9i/10g.
Experience in various capacities such as developer, team lead, DBA and application designer on various multi-tire applications.
Expertise in SQL server 2005 and 2008 installation,configuration,SSIS, and Administration.
Extensive experience with data modeling, Logical and Physical database designing.
Experienced in Administering, maintaining, developing, and implementing policies and procedures for ensuring the security and integrity of the database environment.
Hands on experience in high availability SQL Server solutions, including log shipping, replication and SQL Server clustering.
Extensive hands-on experience with triggers,user functions,views,indexes, and stored procedures.
Proficient with RDBMS database design,development and administration.
Working knowledge in the environments of Linux, Solaris and Windows 2000/XP.
Experience with data import/export, database migration and performance tuning using database tools and operating system tools.
Experience with SQL Server security – authentication, server roles, database roles and permissions.
Experienced in Database design using ERWIN, Microsoft Visio for Enterprise Architects.
Authoritative in developing documentation and programming standards for a given project environment.
Comprehensive knowledge of Insurance, Manufacturing and Marketing Domains.
Experience in both independent and team oriented environment with strong trouble-shooting, analytical, interpersonal, documentation, and communication and presentation skills.

EDUCATION
Bachelors in Computer Science

SKILL SETS
DATABASES: Microsoft SQL Server 7.0, 2000/2005/2008, Oracle 9i/10g , MySQL.
OPERATING SYSTEMS: Linux, Sun Solaris, Windows 2000/XP.
TOOLS: MS Office Suite (Project 2000, FrontPage 2000), Developer/2000, ColdFusion 6.0/5.0/4.5, JDBC, Networking, Adobe PhotoShop, Flash MX, Dreamweaver 8, Flex Builder 2.0, CFEclipse, Crystal Reports 8.5, Windows NT Event Viewer, WinRunner 7.0.
LANG/ TECH: C, C++, C#, Java 1.6, JSP, XML, XSL, ASP.NET, PHP 3, HTML, CSS, DHTML, JavaScript, VBScript, PowerBuilder 7/ 8, Visual Basic 6, Java Bean.
SERVERS: IIS 5, Java Web Server 2, I Planet 4.0, Netscape LDAP Server, WebLogic 5.1, WebSphere 4.0 ,Apache HTTP Server.
VERSION CONTROL TOOLS: CVS, SVN,PVCS and Rational Clear Case.

EXPERIENCE

Confidential,DC
Confidential,
Nov 2009 – Present
Functioning as a Senior SQL Server DBA.
FEP Administrative Application Services is an IT department which provides services on the Information Systems for the various coldfusion applications like PIITS,PPE,ACM and BMS with backend as SQL Server database.
Plan Information and Issues Tracking System (PIITS) is an Intranet application which provides accurate and timely data on identified BCBS Plan issues and current business practices by providing a centralized repository.
Performed database administration tasks on production server like backup and recovery, creating and maintaining transaction logs, data file space and table partitions, setting up users and permissions.
Deployed the system to various clients to client specific staging areas and to production environments and resolved the on call tickets.
Responsible to review the application development code which is written in stored procedures and DB Triggers.
Setup the SQL server profiler to trace various DB activities, resource usage and query optimization paths.
Installed and configured integration, reporting and analytical services.
Historical data migrated from DTS packages to SSIS services and scheduled the jobs for automation.
Created SSIS packages to extract and transform data, develop business intelligence and scheduled daily and weekly using jobs.
Created SSIS packages to Export and Import Data from various systems to SQL Server.
Used most of the Tools in SSIS packages like Looping, Error Handling, E-mail notification etc.
Reconfigure improvements for SQL Server environments, architecture and processes. Experience in performing large scale SQL Server version upgrades.
Troubleshooting performance issues and fine-tuning queries and stored procedures.
Extensively written and used database stored procedures, functions and queries that enforce encryption of sensitive data across database to application transports.
Migrated database environments from SQL 2000 and SQL 2005 to SQL 2008.

Assist developers with implementation of best practices regarding data definition, data quality, data security, and data integration.
Worked with the testing team on requirement analysis and creating the test plan, test strategy.
Environment: MS SQL Server 2000/2005 and 2008, DTS, SSIS, SSRS, SSAS, ColdFusion MX 7.0/8.0, Sharepoint, SSL, CSS, IIS 5.0, Rational ClearCase, Microsoft Visio, Windows 2000.

Confidential,April 2008 – Oct 2009
Functioned as a Senior Software Consultant.
California Department of Developmental Services (DDS) is the agency through which the State of California provides services and supports to children and adults with developmental disabilities.
Conducted System Analysis, Design, Development and Implementation of various Applications and the subsequent transition to ERP and Web Enabled Application.
Installed, configured and managed SQL Server Instances under cluster environment.
Developed & maintained scripts, utility jobs or implement needed software for database maintenance.
Converted DTS packages into SSIS and scheduled the Job Maintenance Window for execution process.
Performed all the Database related activities such as Database Backup, Restore Operations, Troubleshooting Issues as and when occurs, Performance Tuning, monitoring error logs, jobs etc.
Rewrote and tuned long running SQL queries to cut execution time, ease database load and improve scalability.
Developed SQL stored procedures for the Invoices Posting, Payment Posting and Checks Generation.
Upgrade the MS SQL Server 2000 to 2005.
Involved in Analysis and Design Documentation, User requirements and maintained good documentation.
Performance tuned the queries for Service Verification module.
Environment: MS SQL Server 2000/2005, DTS, SSIS, SSRS, Share Point, Microsoft Office 2007, Visio, Windows 2000

Confidential,November 2006 - March 2008
Functioned as a Senior Software Consultant
NCSBN conducts online courses for the registered students
Students enroll for the course by paying through credit card or Etoken (i.e. gift card). NCSBN also provide facility for bulk user/ course registration
Involved in Design, Analysis, SOW for NCSBN Project.
Interaction with the client in requirement gathering.
Managed Microsoft SQL Server 2000 databases in production and non-production environments including development, testing, staging, configuration, and production areas.

Developed SQL processes for data loading, migration, application interfaces, and data generation for load testing activities.
Developed ColdFusion templates for Single User Etoken module and to integrate with Nexus Web service.
Writing stored procedure and migration scripts in SQL Server 2000 for Multi-user module.
Configured and administered access permissions and privileges for databases and reporting needs.
Resolved database performance and throughput issues.
Responsible for version controlling using Microsoft Version Manager.
Environment: MS SQL Server 2000, ColdFusion MX 6.1, Dreamweaver, SSL, JavaScript, IIS 5.0, ERWIN 4.0, Windows 2000

Confidential,VA
Confidential,July 2005 - October 2006
Functioned as a Software Consultant
AMIS maintains information about AAAE members, organization, meetings and advertisements for the various airports in US
AAAE coordinates between airports to organize trainings, meetings for all the 240 airports
Design and development of Advertisement, Miscellaneous Billing, Subscriptions Module
Query in Query were developed for Page Caching quick process
Writing stored procedure and Triggers in SQL Server 2000 for Advertisement module.
Written Wrapper stored procedure, Cursors for finical transactions in Billing Module.
Written Wrapper Stored procedure and template for bulk renewal of subscriptions in the subscription module.
Responsible for version controlling using Microsoft Version Manager
Involved in Development of Crystal Reports for Advertisement Module
Environment: MS SQL Server 2000, SSL, JavaScript, IIS 5.0, VB,ERwin 4.0, Windows 2000 Server, PVCS 6.7

Confidential,India
Confidential,July 2004 - June 2005
Functioned as a Programmer
This system is used marinating students enrolled for the Courses, different examination details and there centers
Developed ColdFusion for courses, student information.
Developed search facility for the courses, nearest centers.
Troubleshoot databases and customer application issues.
Set up standard on SQL server and database security.
Developed Reports to maintain account for number of people registered for the course
Interacted with users for collecting the information.
Performed Unit testing for the modules
Environment: MS SQL Server 7.0, ColdFusion Studio 4.5/5.0, JavaScript, IIS4.0