SUMMARY:

• 10 years of in - depth experience as SQL Server Developer/DBA in database technologies on SQL Server Version 2012, 2008 R2, 2008, 2005, 2000, 7.0 & 6.5. Handled various DBA activities on highly transactional production environment. Experience with SQL Server performance monitoring and fine tuning. Handled (ETL) Extract Transform and Load using Data Transform Services. Ability to diagnose and resolve performance bottlenecks. Ability to perform complex database architecture analysis.
• Development of business reports using SQL Server Reporting Services (SSRS) and Crystal Reports 10.0. Expertise to analyze the report requirement and understanding the business rules and logic requirement for reports. Expertise in building and fine tuning queries to reduce execution time.
• Microsoft SQL Server 200X administration including partitioning, replication, Microsoft SQL Server 200X development including stored procedures, functions, triggers, and views. Fluency in T-SQL, (DTS) Data Transformation Services, (ETL) Data Extract Transform and load, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services.
• Created and implemented advanced database objects using T-SQL for development of stored procedure, coding database triggers on table for insert, update and delete, developing functions, views & queries.
• Design & implemented database maintenance plan, object security management, distributed database management, replication, relational modeling clustering, capacity planning, database tuning and establishing database security.
• Design of backup/recovery solutions to ensure data integrity and Recovery Time Objectives. Provided full development lifecycle support to Development Team Members in the areas of database and software design, development and implementation.
• Generation of business reports using SQL Server Reporting Services and Crystal Reports 10.0. Set up and monitor database jobs, backups, and recoveries, automate common administrative tasks, conduct performance tuning and optimization, Created and revise schemas, jobs. Performance monitoring experience using Windows Performance Monitor and MS SQL Server Profiler.
• Experience in Migration/Upgrade SQL Server 7.0 to SQL Server 2000 and 2005. SQL Server Replication solutions in a multi-site, multi-location, distributed database environments using row-level merge and transactional replication and then synchronizing between databases to maintain consistency.
• Involved in Troubleshooting issues to include deadlocking, blocking, latency, memory bottlenecks, disk I/) bottlenecks, and CPU bottlenecks.
• Successfully Installed Microsoft Products like Microsoft SQL server, Windows Server 2000, Advance Server, Windows Server 2003 configuring active directory for users and computers, configuration of routing and remote access. Installation of windows95, Windows 2000 Professional, Windows XP based Client machines and configuration of other desktop products like Outlook express and Microsoft Outlook etc.
• Working on Full Life cycles of application system analysis, design and development, working with the systems analysts, technical managers, application developers, QA teams and support group.
• Worked with the business managers/analysts, application development teams, Hardware and software vendors for execution of various projects relating to hardware, software, databases and business decision issues. Finalizing the review of project plans and the application code and suggestions for overall improvements / enhancements for the performance tuning relating to software delivery exercises.

TECHNICAL SKILLS:

Languages: SQL, T-SQL, PL/SQL, C#, Visual Basic 6.0, Java 2.0, HTML, XML, Microsoft .Net development platform & visual studio, Oracle Developer Suite Tools Forms and Reports 6i/9i, MS-Access/MS-EXCEL-Visual Basic using ODBC with Oracle DB

Tools:: SQL plus, Export/Import, Microsoft Data Tools.

Database: Microsoft SQL Server 2012, 2008 R2, 2008, 2005, 2000, 7.0 & 6.5 Enterprise Edition (32-bit and 64-bit). Oracle RDBMS Release 8i

Operating System: Windows XP/2000/NT 4.x/98/95, HP-UX 10.20/11.00, Linux, TCP/IP, Apache Web Server 1.3Others: MDeamon, Microsoft Exchange Server 2003, VS Flex Views and VS Flex Report Viewer, Crystal Reports

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Lead Programmer Analyst

Responsibilities:

• Create and maintain complex stored procedure as part of daily maintenance jobs.
• Design and develop ETL packages (SSIS) importing and exporting data from multiple data source Flat file, Excel and SQL Server environment.
• Process involve Validating, Manipulating and data conversion of data from different file types.
• Design and develop Reports (SSRS) and Crystal report base.
• Creating database objects like tables, Stored Procedure, Views and functions. Modifications on Stored Procedure, SSIS Packages, SSRS Reports and Crystal Reports as per client enhanced requirement.
• Analyzing and Modify and fine tuning existing Stored Procedure and query to bring down execution time.
• Verifying data on production and test after release on test and production server.
• Responsibility to do code review, and suggest and support programmer to optimize performance of query and stored procedure.
• Actively involved in discussion for design document.

Environment: MS SQL Server 2012, 2008 R2, 2008, SQL, T-SQL, PL/SQL, SSRS and Crystal Report, VSS, 2000/XP OS.

Confidential, Chantilly, VA

Senior Programmer Analyst

Responsibilities:

• Main role in creating database objects like tables, Stored Procedure, Views and triggers. Modifications on Stored Procedure, SSIS Packages and Crystal Reports as per client enhanced requirement.
• Verifying data on production and test after release on test and production server.
• Responsibility to do code review, and suggest and support programmer to optimize performance of query and stored procedure.
• Scheduling jobs to set an automatic process. Supporting DBA in daily activities.
• Testing Stored Procedure created by programmer in compare with defined business rules.
• Development and maintaining application in C#.
• Actively involved in discussion for design document.
• Monitoring Schedule jobs and determine in case of failure.

Environment: MS SQL Server 2008 R2, 2008, 2005, SQL, T-SQL, PL/SQL, DTS, SSIS, Crystal Report, MKS, VSS, 2000/XP OS.

Confidential, Vienna, Virginia

Programmer Analyst

Responsibilities:

• Major role in Modifications as per client requirement on Database Objects, SQL Server Report (SSRS) and SQL Server Integration Services (SSIS) deployed on production.
• Modification of existing reports and SSIS packages with changes in business rules.
• Responsibility to Testing, Bug Fixing, Data Analyzing and Deploying SSIS packages and SSRS Reports.
• Creating databases, stored procedures, views and creating & scheduling jobs to set an automatic process for daily collection of data and flat files.
• Fine tuning Stored Procedure used for .Net application for quick execution of Dash Boards from 10 minute to under 10 second eliminating use of cursor, functions many conditions in existing stored proc.
• Monitoring performance of SSIS package using windows performance monitor for CPU usages.
• Analysis and confirming fact stat & fact data.

Environment: MS SQL Server 2005, SQL, T-SQL, PL/SQL, SSIS, and SSRS, VSS, 2000/XP OS.

Confidential, Herndon, VA

Programmer Analyst

Responsibilities:

• Working on SQL Server Integration Services for building high performance data integration solutions, including ETL packages that provide extract, transform, and load processing for data warehousing and cube.
• Responsibility to Testing, Bug Fixing and Deploying SSIS packages developed by offshore team.
• Creating databases, stored procedures, views and creating & scheduling jobs to set an automatic process for daily collection of data and flat files.
• Communicating and providing support to offshore team for development.
• Closely monitoring performance of SSIS package using windows performance monitor for CPU usages.
• Testing and debugging SSIS package before deploying onto live environment.
• Creating left and right partition function and scheme and scheduling jobs to run automated partition creation on daily basis.
• Providing 24/7 supports on production server to monitor on going automated data loading process.
• Analysis and confirming fact stat & fact data and rolling it up for Daily, Monthly for cube.

Environment: MS SQL Server 2005, SQL, T-SQL, PL/SQL, SSIS, and SSRS, VSS, 2000/XP OS.

Confidential, Jacksonville, FL

Programmer Analyst

Responsibilities:

• Development of data modification scripts, stored procedures, functions, and data transformation scripts to support a series of production and development databases for a federal asset management system on a Microsoft SQL Server 2005 platform.
• Developed complex stored procedures to create various reports.
• Schedule jobs & developed script to import data from text file, created script to check fail over cluster and fire an email and page to DBA team for failure of main server.
• Trouble shooting script and other issue for packages deployed on QC.
• Creating database objects creation like tables, indexes and constraints.
• Data migration from SQL Server 2000 to SQL Server 2005 using speed lite backup and restore data across different server.
• Monitoring, optimizing and tuning the performance of SQL Server in slow running application by analyzing and evaluating of queries and databases.
• Scheduled maintenance on databases and capacity planning to increase performance and productivity.
• Perform Database Capacity planning calculations as per Maintenance Plan, and documents, Performance tuning of database, application response and queries.
• Creating DTS packages and SSIS packages.
• Designing Recovery Strategies and Test Plans for Database.
• The DBA team supports production servers and development servers.

Environment: MS SQL Server 2005, SQL, T-SQL, PL/SQL, SSIS, SSRS and Crystal Reports, Windows NT 4.x/2000/XP OS, Raid10 Mirroring technique.