SUMMARY:

Around 7 years of technical experience in Installation, Configuration, Maintenance and Administration of SQL Server 2008R2/2008/2005 in standalone and clustered environments

• Experience in Database Administration & Production Support, Business Intelligence including design, development and implementation of Microsoft SQL Server 2008 R2/2008/ 2005.
• Experience on SQL server new features like Microsoft SQL multi server administration, resource governor, performance data collector.
• Experience in Capacity planning, Performance Tuning, troubleshooting, backup and restore procedures.
• Experience in implementing efficient Disaster Recovery Strategies and High availability like Replication (Snapshot and Transactional with updatable subscriptions), Log shipping, Clustering (Active-Active) and Database Mirroring.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, SSRS and SSIS services.
• Excellent backend skills in creating SQL objects like tables, stored procedures, views, Indexes,triggers, rules, defaults, user defined data types and functions.
• Experience in Performance Tuning by Index Defragmentation, optimizing executionplans, proper usage of indexes, horizontal and vertical partitioning.
• Experience in creating Packages, Jobs, sending alerts using SQL Mail and custom extended procedures, Creation and maintenance of Databases, creating Roles and managing user permissions.
• Experience in data Import/Exportutilities tools like SSIS, SSRS, BCP, BULK INSERT.
• Experience usingDBCC commands, SQL Profiler, SQL Server Management Studio, Trace Analysis and Execution plans as part of trouble shootingand performance tuning.
• Experience in monitoring and tuning SQL Server database performance using SQL Profiler, DMV's, Index Tuning Wizard and Windows Performance Monitor.
• Experience in Database Designing/Modeling for new applications (OLAP & OLTP systems) and database changes to existing applications.
• Experience in T-SQL programming for writing DDL & DML queries, stored procedures, user-defined functions, Triggers, Cursors, Views setup.
• Capable to deal with the teammembers smoothly by positive attitude and strong communication skills.

TECHNICAL SKILLS

RDBMS: MSSQL 2008R2/2008/2005/2000,MySQL
Languages: T- SQL, HTML
Tools: MSSQL 2008R2, SSIS, SSRS, Idera Diagnostic Manager, Idera Safe Manager, Idera Defrag Manager, SQL Query Analyzer, Enterprise Manager, Lite Speed, Red Gate SQL Backup, Erwin, Visio, Point Designer, Spotlight, Dreamweaver, Microsoft Office.
Web Technologies: MS Office, XML, MS Visual Source
Operating Systems: Windows Server 2003/2008/2008R2, Windows 95/98/XP/Vista
Hardware: Dell Power Edge R900/R710

• Microsoft Certified Technology Specialist (MCTS)

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC Jan 12- Present
MS SQL DBA/ Developer

We provide investment planning for successful professionals, business owners and retirees.Our practice is designed to help navigate our clients through all phases of their financial life without them having to make unnecessary financial sacrifices or be overexposed to risk.Our commitment is to exceed our client's expectations and to build a lasting relationship based on trust, integrity, and superior client service.

Responsibilities:

• Installation, Configuration, Maintenance and Administration of MS SQL Server 2008 R2.
• Involved in setting up Transactional Replication and Snapshot replication.
• Involved in Setting up Log shipping.
• Involved in database mirroringandInvolved in Creating Back upStrategy.
• Involved in Designing (Logical and Physical) of Customer Database.
• Created & managed the Database Users, Login,Roles,Profiles and Security.
• Automated Backup/Restore Jobs as well as reduce the Backup/Restore time up to significant amount
• Created database objects like tables, views, indexes, stored-procedures, triggers, cursors using MS SQL.
• Creation of Jobs, Schedules, Alerts using MS SQL Server Agent and Notifications usingMSSQL Mail
• Created Packages and jobs to perform filtering operations and to import the data on daily basis from the Oracle DB to MS SQL server. Worked as MS SQL Server administrator.
• Worked on performance tuning of Database and Query tuning.
• Involved in resolving blocking and dead lock Issues by using MS SQL commands Using T-SQL.
• Monitoring Event viewer,MS SQL Error logs and Log File Viewer for Software and hardware related errors.
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SSIS, BCP utility. Extracting, Transformingand loading of data using SSIS.
• Deployed and scheduled SSIS Package.
• Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures, with a lot of interaction with the client.
• Performed analysis and design of the application.
• Experience in with tools like Microsoft Reporting Services (SSRS).
• Involved in creating traditional as well as Web-based interactive reports using SSRS.
• Created and deployed and scheduled report using SSRS.

Environment:MS SQL Server2008 R2, SSRS, Query Analyzer, Enterprise Manager, SSIS, SQL Server Management Studio, MS Excel, Windows XP, T-SQL, Windows Server 2008 R2.

Confidential, Burlington, MA Nov 10- Dec 11
MS SQL DBA/ Developer

Confidential, a division of Ascend Learning, is a world-leading provider of instructional, assessment and learning-performance management solutions for the secondary, post-secondary, and professional market. We endeavor to develop educational programs and service that improve learning outcome and enhance student achievement by uniquely combining authoritative content written by respected authors with innovative, proven and engaging technology applications that meet the diverse needs of today\'s instructors, students, and professionals.

Responsibilities:

• Installed and configured SQL Server 2008 along with Integration Services (SSIS), Analysis services (SSAS), and Reporting services (SSRS).
• Responsible for migration of packages from SQL Server 2005 to SQL Server 2008 using SSIS.
• Participated with business analysts in order together requirements for design and implementation of database.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Designed Handshaking architecture for overall data transfer from the OLTP to Staging area and finally into OLAP with SSIS and T-SQL stored procedures.
• Worked on existing OLTP system(s) and created facts, dimensions, data models, star schema representation of the OLAP databases.
• Developed, deployed and monitored SSIS Packages including upgrading SSIS using upgrade advisor.
• Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Created parameterized reports and matrix reports using Report builder for the roles of the customers.
• Responsible for designing, creating and deploying the reports into the production server.
• Created complex store procedure to copy Database Objects from remote server to local machine and vice versa.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Generated Daily, Weekly, Monthly, Subscriptions for the analysis of managers and end users by using SSRS.
• Handled 24/7 Production Issues.
• Designed index and optimized queries by using execution plan for performance tuning of the database.

Environment:MS SQL Server 2005/2008, MS SQL Server Reporting Services , MS SQL Server Integration Services, SQL Profiler, T-SQL, Windows Server 2005/2008.

Confidential, Minneapolis, MN Jan 10 - Oct 10
MS SQL DBA/ Developer

Confidential, the leading global financial services company has approximately 200 million customer accounts and doesbusiness in more than 160 countries and jurisdictions. Citi provides consumers, corporations, governments andinstitutions with a broad range of financial products and services, including consumer banking and credit, corporateand investment banking, securities brokerage, transaction services, and wealth management.

Responsibilities:

• Gathered requirements from the business users, created technical specification documents
• Responsible for writing scripts in T-SQL to create stored procedures, views, triggers.
• Designed the Data warehouse data models using Erwin.
• Implemented Star Schema for OLAP cubes using SSAS.
• Created SSIS packages from scratch to move data from flat file, Excel and OLE DB sources.
• Used the concepts of Lookup, Derived Column, auditing, priority constraints, conditional split to validate data for SSIS packages.
• Scheduled SSIS jobs using SQL Server Agent
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
• Created SQL server configurations for SSIS packages.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Responsible for creating T SQL scripts to create report models.
• MS SQL performance tuning.
• Trouble shooting problems by using SQL server profiler.
• Developed and document disaster recovery plan.
• Created different type of reports including Cross-tab, Conditional, Drill-down, Sub reports also parameterized reports.

Environment:MS SQL Server 2005/2008, SSIS, SSAS, SSRS, T-SQL, Windows server 2003/2005/2008,Erwin.

Confidential, San Antonio TX Mar 08 - Dec 09
MS SQL DBA/ Developer

Confidential, is a Fortune 500 company based in San Antonio, and through its subsidiaries is the world's largest independent petroleum refiner and marketer. Well-positioned pipelines and terminals allow Valero to deliver premium-quality clean fuels quickly, responsibly and efficiently. Our diversified product slate supports dozens of industries, from health care and plastics to transportation, beauty products and manufacturing.

Responsibilities:

• Involve in Database Design activities including Data Files and File group organization, Capacity Planning, Data Partitioning and Data Normalization.
• Created dimension and measures according to business requirements
• Sorted attributes members based on a secondary attribute.
• Automated Backup/Restore Jobs as well as reduce the Backup/Restore time up to significant amount
• Migration of data across different databases and different server.
• Analyzed and designed software and database solutions.
• Updated functional specifications and technical design documents
• Responsible for identifying and defining the Key Performance Indicators.
• Designed Security Model by creating Users, Schemas, Roles and Permissions for SQL Server
• Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Testing of application for performance, data integrity and validation issues.

Environment:MS SQL Server 2005, SSIS, SSRS ASP, XML, Windows Server 2003/2005.

Confidential, June05 - Jan 08
MS SQL DBA/ Developer

Confidential, is a leading integrated telecommunications company with operations in 20 countries across Asia and Africa. Headquartered in New Delhi, India, the company ranks amongst the top 5 mobile service providers globally in terms of subscribers

Responsibilities:

• Developed physical data models and created DDL scripts to create database schema and database objects
• Wrote user requirement documents based on functional specification.
• Developed source to target specifications for Data Transformation Services.
• Developed functions, views and triggers for automation
• Created SSIS package to schedule the jobs for batch processing.
• Performance tuning to optimize SQL queries using query analyzer.
• Created indexes, Constraints and rules on database objects for optimization.
• Database Backup Procedures, Restoration Procedures, Disaster Recovery Procedures and Contingency plans. Testing and Implementing these procedures.
• Created & managed the Database Users, Login,Roles,Profiles and Security.
• Involved in Setting up Log shipping.
• Updating with latest service packs and security patches.
• Data Migration from legacy to master tables using SSIS- import and Export wizard.

Environment:MS SQL Server 2003, MS Access, SQL Query Analyzer, SQL Developer,SSIS, Windows Server 2003