SUMMARY:

• 8 years of IT experience in Database Design, Data Modeling, Data and Database Security, Requirements Analysis, Application Development, Testing, Implementation and Deployments using SQL Server 2012/2008/2005.
• Experience with Multi- Servers and Multi-Terabyte Databases design for Very Large Databases
• Strong experience in Business Intelligence BI using Visual Studio 2008/2005.
• Hands on experience and outstanding knowledge of high availability SQL Server solutions, including replication and SQL Server clustering, log shipping and Mirroring.
• Created, Built and deployed successfully dynamic SSIS packages into SQL Server 2008/2005 databases and scheduled them according to requirements.
• Extracted, Transformed and Loaded data in Data warehousing using SSIS packages.
• Involved in migrating DTS packages from SQL Server 2000 to SSIS packages in SQL Server 2008/2005 database.
• Experience in Migration of Data from Excel, Flat file using DTS, SSIS and other ETL Tools.
• Experience in working with Reporting tools like MS SQL Server Reporting service SSRS .
• Rendered reports in CSV, PDF, XML and Delivered reports by file share and E-mail according to schedule.
• Created, designed and deployed Tabular, Matrix, Chart, Drill-down and Ad-Hoc reports on report server.
• Experience in Database Design activities including Data Files and File group organization, Capacity Planning, Data Partitioning and Data Normalization.
• Resolved issues with Indexes, Blocking and locking issues to remove the performance bottlenecks.
• Proficiency and Expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Rebuild online index and worked with Dynamic Management Views DMV for improving query performance.
• Created recursive queries using Common Table Expression CTE .
• Performed database consistency checks at regular intervals.
• Experience in Change Data Capture CDC , Change Tracking CT in SQL server 2008.
• Experience in Creating complex Views, Stores Procedures, DDL/DML Triggers and User-Defined Functions to implement Business Logic and Data Protection.
• Good hands-on with creating Partitioned Tables and Partitioned Views.
• Creating and managing schema objects such as Tables, Views, Indexes, Stored Procedures and User-Defined Functions depending on the Technical Requirements.
• Experience in migration of data using BCP Utility, Bulk Insert command, SSIS and DTS Packages, Import/Export Wizard and Copy Database Wizard.
• Knowledge in SSAS in generating cubes.
• Expert in Query Tuning and activities including Updating Statistics, Re-building and Re-organizing Indexes.
• Monitoring and optimizing the performance of the Queries and Indexes using SQL Server Profiler, Database Engine Tuning Advisor, Performance Monitor, DBCC commands and Dynamic Management Views.
• Worked in both Production and Development environment.
• Expert in creating and maintaining Documents for future needs.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server DBA

Responsibilities:

• Production supporting DBA activities in huge environments.
• Designing SSIS packages those involved in different tasks like ETL, maintenance plans, monitoring etc.
• Analyzing and designing and implementing different types of Replication Models.
• Supporting Huge Databases, Troubleshooting the problems.
• Spreading huge tables to different file groups to achieve maximum performance.
• Writing TSQL code and complex stored procedures for different tasks. Tuning the code written by team members to achieve optimum performance.
• Setting up DR solutions using Log shipping, Mirroring, Always On 2012 in windows clustering environments for High Availability.
• Setting up monitoring alerts and dashboards in addition using of SQL built-in dashboards.
• Discussion with peers about performance issues, SQL Internals about log shipping, DB mirroring, replication etc.,
• MS SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
• Database creation, restoration, recovery, User/Schema Creation and maintenance Space Management.
• Monitoring Memory Usage, Monitoring batch jobs, Running trace and create standard reports on query performance
• Monitoring and Troubleshooting SQLServer using Windows System Monitor, creating an Alert in Windows System Monitor, creating a SQL server Performance Alerts.
• Maintaining and Automating SQLServer like, Configuring Database Mail, creating an Operators, Creating Jobs, Alerts, Database Maintenance plans.
• Data migration import export BCP from Text to SQL server.
• Designed SQL SSIS Packages in Business Intelligence Development
• Good understanding and experience in SQL Server 2008 features like Change Data Capture CDC , Transparent Data Encryption TDE and Policy based Management.
• Studio BIDS , to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2008, 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks in Visual Studio 2008.
• Prepared and documented Backup Restore Plans.
• Created clustered and non-clustered indexes to improve the performance of queries with by understanding the Actual execution plan. Eliminated key-lookups, table scan and converted index scan to index seek
• Backing up master system databases and restoring them when necessary and automated backup processes using SQL Server jobs.
• Supported Application Development team with any database issues, updates or new releases. Support included deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio BIDS .

Environment: SQL Server 2008/2005, SSIS, SSRS, Visual studio 2008, MS Visio 2007, XML, VB.Net.

Confidential

SQL Server DBA

Responsibilities:

• Actively participated in interaction with users, team lead, DBA's and technical manager to fully understand the requirements of the system.
• Performed data migration from SQL Server 2005 to SQL Server 2008.
• Implemented Functions, views, triggers and stored procedures and enforced business rules via checks and constraints.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Created SQL scripts for tuning and scheduling.
• Performed data conversion from flat file into a normalized database structure.
• Created Triggers to enforce data and referential integrity.
• Create new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio BIDS and Visual studio 2008.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Generated reports using SSRS, Excel Pivot that could be used to send information to diverse group of users, clients, and managers.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Responsible for creating the reports basing on the requirements using SSRS 2008.
• Data migration import export BCP from Text to SQL server.
• Designed SQL SSIS Packages in Business Intelligence Development
• Good understanding and experience in SQL Server 2008 features like Change Data Capture CDC , Transparent Data Encryption TDE and Policy based Management.
• Studio BIDS , to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2008, 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks in Visual Studio 2008.
• Prepared and documented Backup Restore Plans.
• Created clustered and non-clustered indexes to improve the performance of queries with by understanding the Actual execution plan. Eliminated key-lookups, table scan and converted index scan to index seek
• Backing up master system databases and restoring them when necessary and automated backup processes using SQL Server jobs.
• Supported Application Development team with any database issues, updates or new releases. Support included deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio BIDS .
• Involved in Deployment and Administration on SSIS packages with Business Intelligence development studio.
• Developed, monitored and deployed SSIS packages.
• Involved in System Study analysis for logical/physical data model there by defining strategy for implementing Star Schema with Fact and Dimension tables.

Environment: SQL Server 2008/2005, SSIS, SSRS, Visual studio 2008, MS Visio 2007, XML, VB.Net.

Confidential

MS SQL DBA

Responsibilities

• Designed and applied schema change scripts to existing objects to synchronize with changing business rules.
• Performed data migration from SQL Server 2005 to SQL Server 2008.
• Took part in data normalization process with senior database analyst.
• Created stored procedures, triggers, views, added/modified tables for data load transformation extraction and manipulation.
• Created clustered and non-clustered indexes to improve the performance of database and tables.
• Filtered bad data using complex T-SQL statements, Cursors and UDFs and implemented various constraint and triggers for data consistency.
• Designed and applied schema change scripts to existing objects to synchronize with changing business rules.
• Build table relationships and wrote stored procedure to clean the existing data.
• Coordinated with front end developer to put in the business rules. Wrote stored procedure to check some of the rules at the backend at the time of entering data.
• Developed SQL Scripts to Insert/Update and Delete data in MS SQL database tables.
• Developed the project using iterative approach.
• Managed database changes based on feedback.
• Migrating DTS package from SQL Server 2005 to SSIS in SQL Server 2008.
• Created new SSIS packages according the business rules.
• Participated in creating reports using SSRS.
• Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Configured SQL mail agent for sending automatic e-mails to employees for Invoice using SSIS packages.

Environment: SQL Server 2008/2005, SQL Server 2008 Integration Services SSIS , SQL Server 2008

Reporting Services SSRS ,SQL Server 2005 DTS, MS Access 2003, MS Excel 2003, VB.Net, OLEDB, Visio 2003, Microsoft Outlook 2003 ,Windows 2003 Server/XP.

Confidential

MS SQL DBA

Responsibilities:

• Designed and created use case, class and sequence diagrams using UML.
• Expertise in all the installation and configuration issues of Microsoft SQL Server and Integrating Services and Reporting Services.
• Expertise in Server Management issues like administration, Backup/Restore, Space Management auto growth/shrink, file groups , Attach/Detach.
• Worked on performance issues like server wide performance issue, database wide performance and stored procedure tuning issue.
• Worked on replication configurations and troubleshooting replication like replication agent's failure, and performance issue.
• Troubleshoot data corruption issue Server down situation understand the DBCC checkDB output, planning of disaster recovery.
• Troubleshooting all type of memory related issues like: out of memory error and issues related to basic connectivity and full text search.
• Troubleshooting of upgrades issues like SQL Server 2005 to SQL Server 2008, Edition upgrades and hot fix upgrades.
• Worked on advisory cases like providing knowledge to customers who are not sophisticated on installations and configuration setups of database services and reporting services and also helped customers in setting up upgraded services packs and hot fixes.
• Created Complex SSIS Packages ETL Applications, using BIDS and troubleshoot couple of Execution and development issues.
• Created Complex SSRS Reports using the Business intelligence development tools and troubleshoot the performance and subscription issues in it.
• Troubleshooting issues with the reporting services website on different ports.
• Trouble shooting IIS and reporting services errors like HTTP:401 etc .

Environment: Windows Server 2000, SQL Server 2008, UML, SSIS, SSRS.

Confidential

MS SQL DBA

Responsibilities:

• Participated in joint application development session JAD to gather information about clients need and to get familiar with vendors product.
• Wrote T-SQL statements to ensure data consistency by filtering corrupt data and implemented various constrains and triggers to preserve data integrity.
• Developed effective stored procedures, functions to implement business logic.
• Used BCP to move in or out data from different sources.
• Used Bulk Insert to copy large amount of data into database.
• Designing, testing and managing disk tape Backups and Recovery strategies.
• Backing up master system databases and restoring.
• Design and automation of disaster recovery procedures.
• Developed Merchandise Business Analysis report for Top management and Category Buyers using reporting services SSRS and deployed to report server.
• Migrated data from text files and Excel spreadsheets to SQL Server databases using Integration Services SSIS .
• Maintained and created Replication: Merge, Transaction and Snapshot and also implemented data transformation to the published articles
• Increased query performance, necessary for statistical reporting after monitoring, tuning, and optimizing indexes by using Performance Monitor, Profiler, and Index tuning wizard.
• Participated in testing and debugging to validate data after the export/import/delete.

Environment: SQL Server 2005, VB 6.0, XML, VB.Net, SSRS, SSIS

Confidential

MS SQL Server DBA

Responsibilities:

• Installed and maintained MS SQL Server 2005.
• Designed and applied schema change scripts to existing objects to synchronize with changing business rules.
• Designed, developed, and tested stored procedures, views and complex queries for Reports distribution.
• Managed all indexing, debugging, optimization and performance tuning using SQL Profiler and SQL Server Agent.
• Created stored procedures for the business logic using T-SQL and also performed coding of several database triggers and stored procedures and maintained integrity constraints.
• Designed and developed Data Transformation Process.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface with the database and other applications in the most efficient manner.
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, fund Reports, Portfolio Report, sub-reports, charts, parameterized reports, conditional and dynamic reports.
• Provided effective work independently from specifications and with a diverse group of developers and end users to analyze business needs and translated that need into deliverables.
• Built and performed user acceptance testing on new and modified reports.

Environment: MS SQL Server 2005, T-SQL, Windows 2003, Access2000

Confidential

MS SQL Server DBA

• This application will helps client in developing websites and managing information about users who are using this site by different browsers, different areas, different port addresses etc.
• Provided Security, consistency, efficiency, track state etc.
• Involved in analysis, design, coding, unit testing, integration testing, system testing.
• Developed and modified PL/SQL packages, procedures, functions, triggers, reports as per customer requirement to make new enhancements or resolve problems.
• Involved in analysis, database designing, coding and testing.
• Optimized the performance of Queries and Store Procedures with modification in T-SQL statements, by removing unnecessary columns, by eliminating redundant and inconsistent data, by renormalizing tables, and created indexes wherever necessary.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Planned the Complete Backing up of Database and Restored the Database from Disaster Recovery.

Environment: SQL Server 2008/2005, Windows 2003 Server, T-SQL