Sql Server Data

Dixita

C: 832-***-**** ******.******@*****.***

•6+ years of experience in Microsoft SQL including 2014/2012/2008/2008 R2, SSIS, SSAS, and SSRS enterprise editions and exposure to 2016.

•Experience in planning, installing, configuring, and managing of SQL 2014/2012, 2008 R2 and 2016 server.

•Good experience working with system and user-defined databases, database files, and file groups.

•Having expert skill in designing, creating, configuring, monitoring, upgrading, and supporting databases.

•Good knowledge planning, Implementing, and administering HA/DR solutions like log shipping, Mirroring, Replication, Clustering, and Always on the Availability group.

•Proficiency on performance monitoring using SQL server profiler, performance monitor, activity monitor, extended events, Database engine tuning advisor (DTA), and Server-side traces.

•Very good knowledge in fine tuning long running T- SQL scripts by breaking down complex scripts to simple once, creating Indexes, updating statistics and so on.

•Hands-on experience in Database Administration Operations like Backup, Recovery, Installing, Configuring, Managing, monitoring and using SQL Profiler.

•Designed and developed ETL-SSIS packages with various transformations, stored procedures, configuration files and tables.

•Expert in Extracting and transforming data (ETL) from various heterogeneous sources and loading them into various heterogeneous sources.

•Successfully Implemented Event Handlers and Error Handling in SSIS packages.

•Knowledge of capacity planning and storage management, expanding, and shrinking databases.

•Hands on skill on creating database objects like views, indexes, stored procedures, functions, and triggers.

•Extensive experience creating user and groups' logins, granting necessary permissions, and monitor activities enforcing the security policy.

•Creating and configuring and managing partially contained databases, and database Snapshots.

•Highly capable in Monitoring, Rebuilding and reorganizing indexes at regular intervals for better performance with strong understanding in performance tuning, query optimization, and resolving database performance issues including blocking, deadlocking, and index fragmentation.

•Skilled in database encryption and column level encryption.

•Implementing, managing and troubleshooting SQL server security, and audit.

•Good at Troubleshooting SQL server by Reading and analyzing event viewer and SQL server error logs.

•Experienced in writing complex T- SQL scripts to support Ad-hoc needs.

•Experience in creating various complex reports in SSRS (tabular, drill down, drill through, matrix, chart, and parameterized) per requirements.

•Experience in Service Management (which includes Incident, Change and Problem) and well versed in handling issues in Production.

Technical Skills:

Databases

MS SQL Server 2000/2005/2008/2012/2014/2016,2017, Oracle 9i/10/11g, Postgresql, MongoGB.

Languages

SQL, T-SQL, PL/SQL, PowerShell.

ETL Tools

SQL Server Integration Services (SSIS) Oracle Data Integrator (ODI), Cognos data Manager.

SQL Server Tools

SQL Server Management Studio, SQL Profiler, Export & Import (DTS), Idera SQL DM, Idera SQL Doctor, Litespeed, Visual Studio 2008/2012, Redgate SQL Monitor, SQL Compare.

Business Intelligence Tools

Business Intelligence Development Studio (BIDS), SSRS, SSIS, SSAS, Essbase, Microsoft Dynamics AX, Power BI.

Client: TrialSpark, NYC

Role: SQL Server DBA Nov 2018 -Till date

Responsibilities:

•Analyzed data requirements and created physical data flow using tools such as Visio.

•Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies

•Configure, optimize, and maintain SQL Server instances in development and production environments, which include Azure VMs and Azure PaaS instances, to improve performance, availability, and security

•Analyzed massive and highly complex datasets, performing ad-hoc analysis and data manipulation using T- SQL.

•Designed and developed SSIS Packages to import and export data from MS Excel, Salesforce, SQL Server 2016/2012 and Flat files.

•Administered and Managed SQL Server 2016//2014/2012/2008R2 on Test, Development and Production Servers.

•Perform SQL Server Service pack and Windows Service pack Upgrade.

•Implementation of SQL login, Roles and Authentication mode as a part of Security Policies as a part of various categories of Users.

•Worked in Active /Active and Active /Passive Clustered Environment.

•Monitored and Troubleshoot Servers performance and activities using SQL Profiler, Performance Monitor, Extended Event, Trace flags, Activity Monitors and Store Procedures.

•Auditing stored procedures for Optimization and improving Performance.

•Implementation of Trigger to maintain Data Integrity.

•Reorganize/Rebuild the Indexes at regular intervals for Better Performance.

•Auditing Stored Procedures for optimization and improving Performance.

•Involved in Index Analysis and Performance Tuning.

•Analyze long running slow queries and tune the same to optimize application and system performance.

•Performed various physical and logical consistency checks on databases using various DBCC commands.

•Creating maintenance plan in a daily and weekly bases.

•Implemented SQL server high availability tools like Log shipping, Replication, Mirroring and Failover Clustering to minimize downtime.

•Created Schedule and Monitored SQL Server Jobs and making sure Jobs running successfully every night.

•Analyze Execution plan, and tuned queries and databases for better optimal performance.

•Created an Alert to using Severity level.

•WMI script to change all SQL server startup account/ Password on the network.

•Support development, test, and production SQL server instances.

•Configure Temp DB on files and file group and capacity planning of databases.

•Configured and Deployed SSIS Packages from Test to Production Environments.

•Responsible for the timely and accurate completion of other tasks as defined by management.

Environment: SQL Server 2016/2014/2012/2008R2, Business Intelligence Development Studio (BIDS), SQL Profiler, Query Analyzer, SSRS, SSIS, SSAS, VISIO

Client: PNC Bank, Pittsburgh, PA

Role: SQL DBA June 2017 – Nov 2018

Responsibilities:

•Designed, developed the customer comparison reports in MS SQL Server environment using SSRS 2012.

•Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.

•Extracted data from various sources like SQL Server 2008/2012, Oracle, .CSV, Excel and Text file from Client servers and through FTP.

•Extensively used Grid View and Details View and Form View to display data in a customized format in the ASP.NET web pages.

•Implemented and supported different High Availability & Disaster Recovery scenarios like Always-On Availability Groups (AAG), Clustering (Active/Passive), Replication models (Transactional, Snapshot), Log Shipping (Native and Custom) and Data Base Mirroring.

•Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.

•Good Experience in database design, data modeling, development, implementation, ETL and reporting in SQL Server 2016/2014/2008 R2.

•Reporting Services (SSRS), Analysis Services (SSAS) & Power BI (Power View, Power Pivot).

•Experience monitoring MS SQL Server databases and performance tuning using Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal performance.

•Expertise configuring and creating SSIS solutions for ETL and business intelligence process for data integration and migration services.

•Skilled in merging data from various heterogeneous data sources, populating dimension and fact tables in data warehouses and data marts, cleaning and standardizing data loaded into OLTP and OLAP databases using SSIS.

•Extensive experience creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server.

•Created Dynamic time-based calculations like MTD, QTD, YTD, Prior, %YoY etc.

•Expertise creating various parameterized, cascaded, linked, drill-through and drill-down reports.

•Expertise configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies with SSAS.

•Created SQL server jobs on SQL Server Integration Services (SSIS) packages to automate the execution of the packages at a particular time depending on requirements.

•Expertise configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies with SSAS.

•Great Expertise in event handlers, Package Configurations, Logging, and Check points, Package Securities and User Defined Variables for SSIS Packages.

Environment: MS SQL Server 2014/2012/2008, Windows Server 2008R2/2012 T- SQL, MS Access, MS Business Intelligence Development Studio 2008.

Client: CIGNA - Bloomfield, CT

Role: Database Administrator (SQL DBA) Jan 2016 – May 2017

Responsibilities:

•Installation, administration, and configuration of SQL Server 2016.

•Maintenance and applying services pack and hot fix of 2005/2012/2016 in Production and development.

•Administration and troubleshooting of active/active SQL 2 node cluster

•Installation, configuration, and administration of Team Foundation Server (TFS)

•Upgrade 0f database from version SQL 2005 to SQL 2012 & 2016.

•Setup server level audits on SQL server instance.

•Setup, Managing and troubleshoot mirroring and log shipping

•Setup, Managing and troubleshooting data Replication using Transaction replication.

•Design, develop and deploy SSIS packages in ETL environment for file transfer and data loads, provide by external agency.

•Support and Troubleshoot existing SSIS package failures and performance tuning.

•Developing data source, testing and deploying reports in SSRS environment.

•Developing SQL adhoc-query, stored procedures, views, triggers, functions managing indexes.

•Performance optimization of slow running query in OLTP and SSRS environment.

•Data migrations across the environments, Dev, QA, STAGE and Production.

•Provide oversight and tactical support for processing of datasets in all environments

•Provide SLAs for incident response and system availability.

•Coordinate with other State of Connecticut resource for issues resolutions, including other database administrators (DBA), system and network engineers, and application hosting group.

•Develop, design and maintain all project diagrams, data dictionary & documentation.

Environment: MS SQL Server 2005/2008/2008R2/2012/2016, TSQL, SSIS, SSRS SQL Profiler, Microsoft Outlook, Visual studio 2010 Visual studio 2012, Team Foundation Server, Windows Enterprise Server 2003/2008/2012

Client: Navaera software services private limited, India

Role: SQL Server Developer/DBA May 2013 - July 2015

Responsibilities:

Providing 24/7 support for over 250+ Production, and pre-production instances SQL Server 2005, 2008,

•2008R2 and 2012, 2014 as standalone\Clustered environment.

Experience in Installation, Configuration in different versions of SQL Server 2005, 2008, 2008R2 and 2012.

•Applying Service Packs, Cumulative Packs, related Hot-Fixes and Troubleshooting.

Expertise in Installation, Configuration of SQL Server 2008 R2, 2012, 2014.

Experience in Reviewing and Enforcing SQL Server Security by Managing User Privileges and Efficient

•Resource Management by Reconfiguring Profiles and Assigning Roles to Users.

Monitoring SQL Server Performance using SQL Profiler, Optimizing the Queries using Tuning Advisor and

•Tracing Long Running Queries.

Verifying and Resolving the SQL Server Blocking and Dead Lock Issues.

Experience in troubleshooting SQL issues by using SQL Tools, Execution Plans, Trace, Statistics, and Index

•Tuning Wizard.

Creating and Administering the SQL Server Databases, Managing other Growth Parameters.

Hands on experience in creating Database Objects including Tables, Indexes, Views and Stored Procedures.

Suggested and Implemented Backup and Restoration Strategy required for Client environment.

Hands-on Experience in maintaining Database Backups, Recovery Models and Recovery Techniques

•appropriate for various Recovery Scenarios.

Proficient in Implementing and Handling SQL Server Disaster Recovery activities of Databases using Database

•Mirroring, Replication, Log Shipping combination of HA-DR.

Knowledge in Cluster Installation with Active\Active and Active\Passive. Adding the Nodes in respective

•servers & Performing Failover, Failback operations in Cluster Environment for adding the New Disks and troubleshooting.

Configuring weekly Maintenance Plans such as Integrity Check, Rebuilding Indexes, Update statistics and monthly plans such as clean up history etc. to run the databases efficiently.

Worked on Data Migration and Integrated Data through creating SSIS packages.

Involved in High Availability Planning of Clustering and Always-On Features.

Proficient in Upgrading and Migrating Servers from 2005\2008 to 2008 R2 and 2012.

Contact this candidate