SUMMARY:

• 7+ years of IT experience with SQL Server database Administration and Development experience.
• Worked extensively on MS SQL Server 2000, 2005, 2008, 2008R2 and 2012
• Experience in installation, configuration of SSIS and SSRS packages in 2005 and 2008.
• Exposure to SSIS Architecture and designing end to end DTS & ETL process.
• Involved in building Star schema and Snow Flake schema depending on business requirements.
• Defined Relationships between Dimensions and Measure Groups like Fact Relationship, Many - to-Many Relationship, and Defined Dimension Granularity within a Measure Group
• Hands on Experience in Developing, Deploying and Processing SSAS Cubes and writing MDX queries.
• Defined relationship between attributes in SSAS Cubes and worked in handling Partitioned cubes in SSAS.
• Good skills in client server architecture, design, system requirement study, and project management.
• Worked extensively on Merge Replication - configuration and trouble shooting
• Extensive knowledge as SQL Server Developer and DBA experience in writing Stored Procedures, Triggers, Views, Indexes, Functions using T-SQL with Query Analyzer tool and ability to use SQL Profiler & Index Tuning Wizard for Performance Tuning and used DTS, BCP for import & Export the data.
• Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, SQL Profiler, restoring database using full, differential, and log backups.
• Designing and Deployment of Reports for the End-User requests using Web Interface & SSRS.
• Extensive experience in controlling the User Privileges, Monitoring the Security and Audit issues as per Standards.
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and Spotlight.
• Experience in solving Real Time issues with Index fragmentation, DBCC checks, Query Tuning, Error and Event Handling.
• Experienced in programming Tasks-Stored Procedures, Triggers, Cursors using SQL Server 2012/2014 with T-SQL.
• Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models, E-R Diagrams.
• Extensive experience in Deploying and Consolidating Multiple Instances over Clustering Environment and Remote Installations.
• Extensive experience in Installation, Configuration and Deployment of SSRS using Scale-Out, Scale-Up and Local topologies.
• Involved in migration of SSIS Packages 2012 SP1 CU5 and troubleshoot migration issues.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports.
• Expertise in What-If Analysis using Excel, Power Pivot Reports and Drill Through Dashboards using Warehouses and OLTP Connections
• Expertise in Proactive Caching, Degenerated Dimensions and Tabular Data Modelling for Moderate to Large Data Systems.
• Excellent T-SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers, and Distributed Transactions.
• Hands on experience in Troubleshooting database issues.
• Implementation experience of Microsoft Clustering Services for High Availability of Servers.
• Experience in writing and debugging stored procedures and triggers
• High level of exposure to SQL performance tuning query optimization using Database Engine Tuning Advisor (DTA) and SQL Server Profiler
• Merge replication configuration for SQL Server 2005 CE subscribers
• DB maintenance, creation of users, configuring permissions and assigning roles to users.
• Strong MYSQL Skills and Good knowledge and experience working on Apache Server and IIS
• Strong analytical and conceptual skills, rapid grasper of new technologies and business terminology.

TECHNICAL SKILLS:

Databases & Services: SQL Server 2000/2005/2008/2008 R2/2012, ORACLE, MYSQL, MS-ACCESS, SSIS, Reporting Services, Business Intelligence, Database Tuning Advisor, SQL Server 2000/7.0, T-SQL, MSDE, OLAP, SQL Plus 8.0, PL/SQL 8.0, Query Analyzer, SQL Profiler, Performance Monitor, Index Tuning, Replication, DTS, BCP, Agent, Jobs, MYSQL, ODBC, JDBC

Disaster Recover Tools: Log Shipping, and MSCS Fail over Clustering Services

Programming/Scripting: Script, XML, HTML, DHTML, T: SQL Programming, VB 6, C++, JAVA, .Net, C#, ASP.NET, Perl, Ruby, Crystal Reports, Business Objects

Operating Systems: Windows XP/NT/2000/98, Visa, UNIX

Microsoft Office suite: Word, Excel, Power Point, Outlook, Access, Visio, MS-Project

Protocols: TCP/IP, HTTP, FTP, SSH, TELNET

PROFESSIONAL EXPERIENCE:

Confidential, Newark, DE

SQL Server DBA/Developer

Responsibilities:

• Managed and administered SQL Server 2012 in development, test, and production environment.
• Installed and configured SQL Server and the service packs based on the errors and flaws that are found in the application.
• Administered the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Worked on Backup, Recovery and Reorganizations of databases using utilities.
• Generated Log shipping for transferring the database in different server.
• Responsible for fine tuning of the database, troubleshooting, user administration, memory management. Create new databases and reports Modify and enhance existing databases.
• Day- to - Day Monitoring of the event logs and server logs for troubleshooting.
• Created SQL Server Integration Services (SSIS) Packages for transferring data from Oracle to MS-SQL Server.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.

Environment: SQL SERVER 2012, SSIS, SSRS, SSAS, MDX, XQuery, Windows 7, Visual Studio 2010.

Confidential, Boston, MA

SQL Server DBA/Developer

Responsibilities:

• Involved in entire product life cycle development from the requirement gathering through implementing in production.
• Extensively worked on extraction of data from file systems, ODBC to SQL Server 2008 R2/ 2012.
• Developed T - SQL scripts for Execute SQL task, Execute Package tasks and appropriate transformations using SSIS for the sake of automation of end-to-end ETL process and inputs to downstream systems.
• Generating various types of daily, weekly, bi-weekly, monthly, ad-hoc, standard, dynamic reports in customer level, manger level, vendor level using Microsoft and SAP technologies.
• Wrote Web Focus dashboard programs for health care reporting for internal and external applications.
• Worked with Office SharePoint Server 2007 Excel Services to enable the interaction of the end users with spreadsheets through a web browser.
• Integrated Reports Developed in SSRS to the SharePoint report viewer web part(Reports Center)
• Developed complex report using Report Studio and created logical and physical design using best practices in Frame work Manager.
• Scheduled Reports through Schedule Management in Cognos Connection.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Involved in planning, defining and designing star/snowflake using ERwin on business requirement and provided documentation.
• Wrote documentation describing end to end business flow, data flow among different applications, program modification and automation processes for maintenance and to support business users.
• Worked on SSIS Package names in a folder to admin tables using Bulk load processing, T-SQL Scripting, query optimization, indexing using SQL server 2008 R2.
• Assistance to database developers and web programmers in query writing, query optimization, Performance Tuning on very large volume of databases in terabytes.

Environment: Microsoft SQL Server 2012/2008 R2,,Visual Studio 2010/2008, Microsoft Data tools, Business Intelligence Development Studio (BIDS), Remedy, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS),SQL Server Analysis Services (SSAS).

Confidential, Poughkeepsie, NY

SQL Server Developer/ DBA

Responsibilities:

• Developed SSIS packages and used Aggregate, Conditional split, Multicast, Derived column, Lookup and Fuzzy Lookup transformations.
• Migrated data from different sources like Text files, Excel spreadsheets to SQL Server databases using SSIS.
• Involved in planning, defining and designing data and provided documentations.
• Created SSIS Packages for Data Migration and Transformation.
• Configured and deployed SSIS packages.
• Worked on various database maintenance tasks in SSIS.
• Used ETL to implement slowly changing Dimension to maintain historical data in Data Warehouse.
• Developed reports using complex queries and filters as per client requirements.
• Created various database objects such as Stored Procedures, Functions, Triggers, Tables, and Views using T - SQL queries to retrieve data from various tables.
• Wrote from simple to complex T-SQL queries in SQL Server Management Studio, for extraction of data from staging environment based on the requirement and pushed the required data to UAT environment.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server 2008.
• Worked on Business Data Catalog to integrate business data from back-end server applications to Office Share Point Server 2007 using XML connectors.
• Improved Performance of the queries by creating Clustered and Non Clustered Indexes and by optimizing the T-SQL statements using MS SQL profiler, Job Activity Monitor and Performance monitor.
• Involved in improving database performance using SQL Profiler, Trace Flags, Execution plan and Index Tuning Wizards.
• Created cubes and dimensions and measures and calculated measures according to the business requirements.
• Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS).
• Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server 2008 Analysis Services (SSAS).
• Worked on creating hierarchies for dimensional tables like date dimensions and region dimension tables.
• Browsing the cube for analysis and validation of the data.

Environment: Microsoft SQL Server 2008, Windows 2003, T-SQL, PL/SQL, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS), WebFOCUS, RESTful, SVN, C#, .NET, SSMS

Confidential, Irvine, CA

SQL Server Developer/DBA

Responsibilities:

• Installed and maintained MS SQL Server 2005 on Windows 2003 Server Worked on SQL Server 2005 failover clustering which is built on top of a Windows 2003 server cluster.
• Involved in replication setup, configuration and maintenance in Transactional Replication.
• Created the Production database backup and restore strategy and implemented the Database recovery procedures.
• Involved in tuning the database and server performance.
• Upgraded experience from SQL Installed and Configured SQL 2005 & 2008
• Configured and maintain Log shipping,
• Creating and managing Partitioning and File Groups.
• Creating Logins, Users and Roles in context of SQL Server security.
• Involved in end to end Database and ETL Architecture.
• Migrated DTS to SSIS packages using the migration tool and re-writing the new package.
• Performed Extensive Research on SSIS, needed for pre-processing and parsing a fixed with file according to pre-defined specification and extraction of data from different FTP source systems.
• Worked intensively on UNIX utilities in windows to convert fixed width file into delimited file for bulk insert operations.
• Transferred data (ETL) to Data ware house Environment using SSIS.
• Dropped and recreated the indexes on tables for performance improvements. Used Index tuning wizard for Tuning of indexes.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested Backup strategies.
• Developed stored procedures using T-SQL and optimized queries for report generation and data modifications activities.
• Extensively worked on Pivot and UnPivot operations in SQL Server 2005
• Monitor SQL Server performance via SQL Profiler and the Windows System Monitor tool.
• Automation of DB activities
• Developed automated backup and DBCC scripts for databases and transaction logs, which can be scheduled using NT scheduler. These scripts produce log of the activities, which can then be reviewed for errors and fixed using various DBCC options.
• Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate Data from various data sources, created packages for different data loading operations for application.
• Maintained the database consistency with DBCC at regular intervals

Environment: MS SQL Server 2005 & 2008, SSIS, SSRS, T-SQL, IIS, Windows server 2003, HTML, MS-Excel, Unix Utilities, Windows NT, Toad 8.0. ASP.Net, VB.Net, ADO.Net, COM, XML

Confidential

SQL Server Developer/SQL Server DBA

Responsibilities:

• Managed high-availability SQL Server environment supporting financial, business intelligence and CRM systems with load-balancing across multiple data centers.
• Managed for business continuity and disaster preparedness in all database systems in multiple sites for storm coverage.
• Implemented transactional replication to enhance the failover capabilities increased over all database manageability and improved performance.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification, indexing and statistics updates.
• Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Actively designed the database to fasten certain daily jobs, stored procedures.
• Optimize query performance by creating indexes.
• Wrote T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL Queries, Stored Procedures.
• Involved in merging existing databases and designed new data models to meet the requirements.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications
• Created complex stored procedures and functions to support efficient data storage, Archiving, Purging and manipulation.
• Conducting root cause analysis of application availability and narrow down to issues related to coding practices, database bottlenecks, hardware bottlenecks or network latency.
• Created Analytical reports by PROCLARITY tool.
• Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system.
• Performance tuning and optimization of procedures and queries. documentation including everything from environment configuration information through standards, policies and procedures.
• Responsible for change control management documentation.
• Interacted with higher management for reporting root cause analysis and suggested best practices to reduce the down time.
• 24x7 Production support.

Environment: MS SQL Server 7.0/2000/2005 , Windows 2000 Advanced Server, Windows 2000 Datacenter, T-SQL, SQL Server Integration Services (SSIS), HP Proliant Servers DL Series, HP Storage WorksMSA20.