SUMMARY

• A Microsoft Certified professional with around 10 years of experience in database programming, administration, data/dimensional modeling, database design, ETL development and testing of SQL server 2005/2008/2012 and implementation of data warehousing solutions.
• Proficient in writing complex ad - hoc SQL queries and expert at designing, tuning databases for very high performance OLTP/OLAP systems
• Expertise in complex Stored Procedure design, Index Design and Tuning, Triggers, User Defined Functions and Views.
• Documented and enforced organizational SQL coding standards and best practices
• Leading and facilitating design sessions and code walk-throughs.
• Planning and implementing the Disaster Recovery for Mission critical databases.
• Extensive experience in implementing Mirroring, Replication, Clustering and Log shipping for SQL Server High Availability.
• Expertise in Query Optimization and Performance Tuning, facilitated company wide user group meetings on writing efficient SQL code.
• Experience in extracting and transforming data using DTS Import/Export Data, Bulk Insert, BCP and DTS Packages.
• Experience in using Performance Monitor/Profiler to resolve System Hardware bottlenecks and Dead Locks/Long running queries.
• Responsible for scheduling complete, differential and transaction log Backups and Restore processes, Creating User Profiles and designing Metadata Data Dictionaries
• Scrubbing, simulation, distribution and maintenance of customer database environment.
• Data quality validation to check the Data Integrity, Data Governance and Data Profiling
• Perform OS and RDBMS service pack/patch maintenance.
• Hosting and Managing enterprise database systems each exceeding 1TB.
• Agile Development Practitioner.
• Exceptional ability to research, analyze and translate technical information to end-users at all levels.
• Security issues related to logins, database users, and application roles and Linked Servers.
• Ensured the security and stability of the database servers by implementing applicable patches and maintaining appropriate security measures.
• Extensive experience in design techniques, ETL processes like developing and monitoring DTS, SSIS Package for integrating data from heterogeneous sources.
• Experience in developing Reports using SQL Server Reporting Services (SSRS), Business Objects XI, Crystal Reports.
• Performed System testing, User acceptance testing, Unit testing for the entire database.
• Proven ability to work independently and with a project team.
• Volunteered for 24/7 On-call Support activities and showed willingness to work evenings and weekends, when necessary
• Ability to pursue a proactive approach to problem solving within a cohesive team environment
• Provided technical leadership to peers and junior personnel within Infrastructure Services
• Strong communication skills both written and verbal with the proven ability to communicate with external clients and internal team members.

TECHNICAL SKILLS

Languages: T-SQL, Dynamic SQL, PL/SQL, C, C++, Core Java, HTML, VB.Net

DBMS: MS SQL Server 2008, SQL Server 2005 and SQL Server 2000/7.0, Oracle 8i/9i/10g, MS Access

Web Application Frameworks: ASP.Net, IIS 4.0

Development Tools: VB 6.0, Dream Weaver, FrontPage, Photoshop, Crystal ver. 11

Data modeling tools: Erwin Version 4.1.4, R7.1

Data warehousing tools: Datastage 7.0

Enterprise Reporting: Business Objects XI, Crystal Reports

Operating System: Windows XP/98, Windows Server NT/2000, MS-DOS

Version control software: Rational Clear case Explorer 7.0.0.1, Subversion

Change Mgmt software: Clear Quest 7.0.0

Project Planning/Mgmt tool: VersionOne, Caliber

Others: Litespeed for SQL Server, Toad 4.0.0 for SQL Server, Citrix, SQL Examiner R2, DB Artisan 8.5, Microsoft Upgrade Advisor 2012.

PROFESSIONAL EXPERIENCE

Confidential, Malvern, PA

Sr. SQL Server Developer/DBA

Responsibilities:

• Performance Tuning, DB encryption, backup and recovery as a part of a daily job.
• Designed, developed and maintained several critical stored procedures using T-SQL for both reporting and application needs.
• Security / performance related T-SQL statements including DBCC statements
• Log-shipping, Replication, disaster recovery methodology.
• Worked on Continuous Replication using triggers for the purpose.
• Worked on reporting tools like SSRS, Business objects and crystal reports.
• Wrote Triggers, User Defined Functions, Views and Designed and Tuned Indexes
• Optimized the performance of queries with modifications in queries, normalizing and denormalizing tables wherever necessary, establishing joins and creating and tuning indexes when needed.
• Reverse engineered databases and worked on physical data models using Erwin.
• Coordinated the Change Control Board (CCB) meetings with the application teams to ensure data integrity.
• Analysis, design, coding and development of building a new schema (staging tables, views, SQL files).
• Agile Development Practitioner.
• Performance counters (both system and SQL Server related) and their implications
• Create / grant logins, Windows Active Directory (AD), LDAP, Kerberos, DNS, Network protocol configuration.
• Coordinated with sprint teams across various time zones around the globe (Kolkata, Sweden, Germany and Japan) for round the clock support activities.
• In-Depth knowledge of the business environment and tackling the minutest of every problem with sharp understanding and effective communication skills.
• Achieved database connectivity using Open Database Connectivity (ODBC) connections, used ODBC escape sequences to deal with DBMS specific queries.
• Root cause analysis of every LIVE customer issue with convincingly quick response
• Proven ability to research, analyze and translate technical information to end-users at all levels.
• Implemented standardization of systems implementation, support techniques, change control, best practices, and total quality practices in all DB related activities.
• Wrote JUnit Test cases extensively to test data and schema as a part of Test Driven Development (TDD)

Environment: SQL Server 2008/2005(SQL Server management Studio(SSMS), SQL Server Reporting Services(SSRS)), SQL Server 2000 (Query Analyzer, Enterprise Manager, DTS Designer, SQL Profiler, Replication Wizard, Database Maintenance Plan, Index Tuning Wizard), Windows Server 2003, ODBC, MS Access, MS Excel, VersionOne, Agile Development Tools, TextPad text editor, Visual Studio, VBScript, MS Visio, SQL Packager, SQL Examiner, Litespeed, Erwin7, Subversion

Confidential, Malvern, PA

Sr. SQL Server Admin/Dev

Responsibilities:

• Involved in different phases of project (project initiation, project requirement and specification gathering, designing system, coding, testing, and debugging new and existing client-server based applications.
• Gathered requirements from business users and created logical and physical database design, data structures, and implemented large databases using Erwin.
• Developed functional requirement documents based on user requirement specification.
• Applied knowledge of T-SQL (DDL and DML) to perform batch processing and implement business logics into backend.
• Prepared schedule and template report for Database Health-check activities.
• Reduced application downtime helping implement 2-node active/passive Cluster design (Clustering) for servers with mission critical applications.
• Developed, modified, and optimized complex stored procedures, triggers and DTS packages to handle complex business rules, history data and audit analysis.
• Developed stores procedures to transform the data from enterprise data warehouse to build dimensions and load data to fact tables.
• Performed intensive Data Quality Testing on various Data Migration processes and written various post scripts to perform data correction.
• Supported the front-end application developers for queries for development hierarchies, file upload and validations using ASP.Net.
• Proven expertise in performance issues and fine-tuned queries and stored procedures.
• Query monitoring for the queries that were parsed through Cognos.
• Backups and Restoration of data/database using a Third Party Tool (SQL Litespeed)
• Expertise in sizing, capacity planning, backup and recovery planning.
• Coordinate database design with IT development staff to ensure optimum performance, conformance to standards and naming conventions; generate database definitions.
• Performed intensive white box testing of all stored procedures and function for accuracy and documented all processes for later easy .

Environment: SQL Server 2000, MSCS, MS Access, DTS, Erwin, ASP .Net, SQL Query Analyzer, DTS, Toad for SQL Server, DB Artisan, SQL Litespeed, Erwin, SQL Examiner, Clear case, Clear Quest

Confidential, Ann Arbor, MI

Sr. SQL Server Developer/Admin

Responsibilities:

• Developed, deployed and monitored DTS Packages.
• Performed daily tasks including backup and restore by using SQL Server 2000 tools like SQL Server Enterprise Manager, SQL Server Profiler and SQL Server Agent.
• Responsibilities include assisting development teams in data modeling and logical database design
• Operational support, capacity planning, performance monitoring, job scheduling, system integration, performance tuning, and participating in managing all DB related projects
• Developed and optimized database structures, stored procedures, views, triggers and user-defined functions.
• Troubleshooting system performance issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Performed Replication of Data using Transactional method.
• Designed and implemented user log in and security.
• Created stored procedures for Automatic Scripting to backup transaction logs, flush/grow/shrink log files, maintain archive of objects.
• Actively documented all the developed processes and applied Reverse Engineering to document already developed application.
• Wrote scripts for generating Daily Backup Report, verifying completion of all routine backups, Log Space utilization monitoring etc.
• Design and Implemented monitoring tool for capturing Log Events for Production Servers performance monitoring and alert messages for blockings.
• Involved in Design and Development of Disaster Recovery Plan.
• Database health checks, assessments, database migrations and troubleshooting.
• Assisted in designing and creating User Interface for Data Entry Person to enter Customer Information, Underwriter to evaluate information, and Administrator to manage the system, using Microsoft Visual Basic.
• Responsible for creating crystal reports and hosting it on the web for the users.
• Generated the weekly, monthly, and quarterly report by using Crystal Reports.

Environment: MS SQL Server 2000, MS SQL Server 7.0, Toad for SQL Server, Win NT/2000, Win 2003, Crystal Report 8.5, Citrix, SQL Examiner, Clear Case, Clear Quest

Confidential, Minneapolis, Minnesota

Data Analyst/MS SQL Server Developer

Responsibilities:

• Actively involved in gathering User Requirement and Online System Specification.
• Modified current database by adding tables and relationships to support online system.
• Created views as required by front end developer for easier implementation on web pages, and triggers on those views to provide efficient data manipulation.
• Created complex stored procedures and functions to support efficient data storage and manipulation.
• Optimized the performance of queries with modification in index system for online system.
• Monitored the growth of the database objects for capacity planning.
• Written stored procedures for Automatic Scripting to backup transaction logs, flush/grow/shrink log files, and maintain archive of objects.
• Successfully applied schema change scripts to existing objects to synchronize with changing business rules.
• Maintain database user logins, passwords and privileges.
• Maintain database integrity and security.
• Monitor database system resources and performance.
• Coordinate database system upgrades with IT staff, end users and vendors.
• Assisted in designing and creating website for the system using ASP, DHTML, CSS.
• Scheduled jobs for backup, and created alerts for error reporting.
• Participated in different testing and debugging of the system.

Environment: SQL Server 2000 Enterprise Edition, Toad, ASP.Net, VB.Net, ODBC, VBScript, Jscript, CSS, DHTML, Adobe Photoshop, Macromedia Dreamweaver, Macromedia Flash, Windows 2000, IIS 4.0.