SUMMARY:

• 7 years of experience as SQL Server Database Administrator and Developer. Experience in working with SQL Server versions 2000/ 2005/2008/2008 R 2/2012/2014/2016 .
• Experience in transforming complex business logic into Database design and maintaining it by using SQL tools like Stored Procedures, User Defined Functions, Triggers, Views, TSQL Scripting.
• Experience in migrating data from various sources such as Excel, Oracle, MS Access, OLE DB, and flat files to different destinations using SSIS.
• Experience in applying latest Service Packs, Patches and Hot fixes for SQL Server.
• Experience in MS - SQL server Installation, Configuration, Performance Tuning, Query Optimization, Backup & Recovery and Running DBCC Commands.
• Experience in Migration/Up-gradation of logins, users, roles, permissions, Jobs, replication objects and stored procedures from SQL Servers R on Development, Testing and Production Environments.
• Experience in performing regular database backups (Full/Differential/Transaction Log) using native tools and restoring the backups on requirement.
• Design and develop creative BI components for the delivery of scorecards, delivered reports, ad hoc queries, extracts and analytics.
• Created the database objects including tables, views, indexes, stored procedures using T-SQL.
• Experience in implementing High Availability and Disaster recovery features like Clustering, Replication, Log Shipping and Database Mirroring.
• Experience on working with Always-On High availability feature.
• Experience in implementing concepts like Data partitioning, Isolation levels.
• Experience in working with Perfmon Counters, SQL Profiler and Extended events.
• Experience in analyzing execution plan and Index management for better Query Optimization.
• Well-versed in usage of SSIS Control Flow items (For Loop, Execute SQL task, Script Task, Send Mail Task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Experience in developing multidimensional databases using SSAS. Experience in OLAP cubes using SSAS for data mining.
• Experience working on SSIS, Creating SSRS reports using the Business Intelligence Tools and SSAS on OLAP environment.
• Responsible for SSIS package deployment and execution and SSRS reports publishing, report generation and availability.
• Extensive experience in Data warehousing like identifying the Facts and Dimensions, creating Star and Snowflake schemas.
• Provided Technical/ Production Support and on-going maintenance for Crystal Reports.

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2000/ 2005/2008/2008 R2/2012/2014, MS Office Access 2000/2003

MSBI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services(SSAS) 2005/2008/2008 R2/2012/2014

Programming Languages: T-SQL, SQL, C, C++, C#, XML, HTML, CSS, .Net, PHP

Operating Systems: Windows 2000/2003/2008/2012 Server

SQL Server Tools: SQL Server Management Studio(SSMS), SQL Server Business Intelligence Studio(BIDS), Query Analyzer, Performance Tools, SQL Server Management Utility & SQL Profiler

Other Tools: Light Speed, Red gate, Spotlight, Fog light, TFS

PROFESSIONAL EXPERIENCE:

Confidential,Basking Ridge, NJ

SQL server DBA

Responsibilities:

• Installed SQL Server 2008R2, 2012, 2014 and 2016 in stand-alone and clustered environments.
• Migrated SQL Server 2008R2 databases to SQL Server 2012, 2014 and 2016 databases.
• Managed and administrated SQL Server 2012, 2014 and 2016 on production and non-production servers.
• Installed the latest service packs, patches and hot fixes.
• Performed full, differential and log backups and worked on point in time recovery.
• Restored backups (full, differential and log) as per requirements.
• Developed maintenance jobs for scheduled backup operations.
• Hands-on experience in working with HADR techniques like Clustering, Mirroring, Log shipping and Replication.
• Worked in setting up replication technique in setting up single publisher to multiple subscribers and multiple publishers to single subscriber.
• Implemented and maintained Log Shipping as Disaster Recovery solution.
• Involved in implementation of Always-On Availability Group as a High Availability solution on SQL Server 2016, 2014, 2012.
• Implemented Partitioning on large tables to improve the performance.
• Developed and maintained the database objects including tables, views, indexes, stored procedures using T-SQL.
• Created Logins, Users with appropriate permissions and performed security management.
• Resolved issues like Locks & Deadlocks using DMVs, table hints and Activity Monitor to improve the performance.
• Experience on dealing with blocking issues.
• Experience in working with and resolving issues related to space issues (Log full, Disk Full).
• Monitored index fragmentation and performed index rebuild or re-org at regular intervals depending on the fragmentation levels.
• Developed maintenance jobs for updating statistics, database integrity checks and Index defragmentation.
• Developed alerts, notifications and emails for system errors, insufficient resources, fatal database errors and hardware errors.
• Modified stored procedures and complex T-SQL queries to improve query execution.
• Participated in Optimizing, Tuning and identifying long running queries using DMVs, Extended events and alert notifications.
• Worked on different third party tools like Spotlight and Red gate.
• Experience on configuring and working MS SQL Server 2008 and MS SQL Server 2005 on VMware Environment.

Environment: SQL Server 2008/2008R 2/2012/2014/2016, TSQL, and SQL Job Manager.

Confidential,Plano, TX

SQL server DBA/Developer

• Worked extensively on installation and configuration of MS SQL Server 2005/2008/2008 R2/2012.
• Involved in migration of MS SQL Server 2005/2008 to MS SQL Server 2008R2 to 2012.
• Handled clustering between two production servers and performed daily backups and developed recovery procedures.
• Assisted in deploying 2 NODE failover clustering.
• Implemented Always-On Availability Group as a High Availability solution on 2012 SQL servers.
• Experience in setting up Always on High Availability on SQL Server 2012 and maintained critical database in the availability groups in sync mode with the secondary replicas.
• Good experience working with Replication, Mirroring and Log Shipping techniques.
• Worked on ETL process using SSIS package.
• Implemented Transactional Replication between primary and secondary Servers.
• Performance metrics reports daily, weekly and monthly.
• Experience in using Perfmon counters in finding issues related to memory, disk, I/O and network by using the various counters and relate them with the thresh hold values.
• Created auditing procedure related data using DDL/DML Triggers to keep track all the changes to database and data in tables
• Troubleshooting blocking issues, deadlocks using trace flags and activity monitor.
• Experience in working with lock issues and different isolation levels.
• Resolved Log file full, Low disk space and query performance issues.
• Configured DB mail for sending automatic mails to respective people and alerts for critical issues.
• Administered the MS SQL Server by creating User Logins with appropriate Roles, dropping and locking the logins, monitoring the User Accounts, granting and privileges to users.
• Scheduled the Backups for databases and performed Restoration operations upon requirement.
• Worked on point in time recovery for minimal data loss issues.
• Rebuilding the indexes at regular intervals for better performance based on level of fragmentation.
• Performed index re-build and re-organization on high transactional databases based upon fragmentation levels.
• Experience in Power Shell scripts and Power shell activity directory with SQL server power shell extensions.
• Experience in usage of SSIS Control Flow items ( For Loop, for each loop, execute package/SQL tasks, Script task, and send mail task ) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot ).
• Worked with Transparent data encryption technique.
• Created ad-hoc reports to users in Tableau by connecting various data sources.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Worked on SSIS features like Event Handling, Precedence Constraints, Break Points, Check Points, Transaction, and package configurations and Logging for Complex SSIS Packages.
• Worked closely with Application Developers in optimizing the query performance, tuning stored procedures taking long time in production environment and performance monitoring using SQL Profiler

Environment: SQL Server 2000/2005/2008 Enterprise, Windows Enterprise Server 2003, T-SQL, SQL Server Reporting Services and SQL Server Integration Services.

Confidential

SQL Server DBA

• Scheduled maintenance plans for backup jobs (full, differential and log backups).
• Restored backups upon requirement and worked on point in time recovery.
• Maintaining databases and schemas, adding users, roles and groups and implementing database security per project requirements.
• Installed and administered clustered and stand-alone SQL servers 2012,2008 & 2008R2.
• Refreshed (backup and restore) non-prod environments with production data on regular basis
• Involved in writing and debugging T-SQL, stored procedures, Views and User Defined Functions .
• Managed Security using SQL Logins, Roles and Security Modes for various users and handled orphan users while moving databases.
• Experience in implementing High Availability and Disaster recovery features like Clustering, Replication, Log shipping and Database Mirroring
• Setup, monitor, and resolved database mirroring issues.
• Worked on index fragmentation issues and experience in defragmentation.
• Created DDL triggers for auditing any DDL change in SQL 2005/2008R2/2012
• Data migration (transformations) from DB2 & Oracle to SQL Server 2012/2008 using SSIS, BCP and Import/export tools.
• Worked with stored procedures and complex T-SQL queries to improve query execution.
• Perform database tuning including monitoring, troubleshooting and optimizing performance of the databases.
• Implemented Data Cleaning, Incremental Data Loading, Event Handling and Error Handling.
• Experience in working with Deadlocks using DMVs and table hints.
• Involved in resolving locking and blocking issues.
• Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions.
• Using third party tools such as Lite Speed, Fog light Performance Analysis and Spotlight for backups and monitoring.

Environment: MS SQL Server 2005/2008/2008 R2/2012 Enterprise, Windows server 2003/2008.

Confidential

SQL server DBA/Developer

• Extensively involved in creating database objects such as tables, views, stored procedures, indexes etc.
• Involved in resolving locking and blocking issues.
• Installation, configuration and maintenance of MS SQL Server 2005/2008.
• Monitoring disk space utilization, CPU performance, I/O activities and automation of maintenance jobs using database mail notification solutions.
• Setting up processes for regular backups and restore methods
• Performed database Backups and Recovery, as needed.
• High emphasis on database security, permissions, user management.
• Used database consistency checks using DBCC utilities.
• Installing, upgrading and applying the latest service packs/hot fixes.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Involved in setting up clustering as a high availability technique.
• Implemented log-shipping as disaster technique.
• Good understanding about other High availability and disaster recovery techniques like Replication and Mirroring.
• Implementation of SQL Logins, Roles and authentication modes as a part of security policies for various categories of users.
• Loading data from different source systems like Sybase, SAP to SQL Systems SSIS also by using SQL 2012 new deployment mechanism and deployed packages into SSIS Catalog.
• Experience in SSIS script tasks, look up transformations and Data flow tasks using T- SQL.
• Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Index, Views, User Functions, SQL joins, Relational Database Systems following Data Integrity and normalization.
• Configured security at Active Directory and SQL Server by mapping users to roles. (Securable and Permissions).
• Experienced on creating SSAS tabular model, calculated measures and data security for report data.
• Created Database Maintenance Plans for the performance of SQL Server which covers database integrity checks, update database statistics and re-indexing.
• Experience in providing Logging, Error handling using Event Handlers, Pre, and post for SSIS Packages, check points (package restart ability features), break points.

Environment: SQL Server 2005/2008, Microsoft Windows 2008 Server, SQL Server Management Studio, T-SQL, SSIS, SSRS, SSAS.

Confidential

SQL Developer/DBA

• Gathered requirements from business users.
• Applied Normalization rules in designing the database.
• Wrote user requirement documents based on functional specification
• Involved in the Migration of Databases from SQL Server 2000 to SQL Server 2005.
• Involved in setting up data mirroring as high availability and log shipping as disaster recovery technique.
• Worked with Business Users and gathering the requirements.
• Design and developed the data model, SSIS Packages, Tabular Model and Power View reports.
• Developed SQL Server Integration Services (SSIS) packages to automate the nightly extract transform and load jobs.
• Experienced in using SQL 2012 new mechanism of deploy the SSIS packages in SSIS Catalog. Schedule the SSIS jobs by using SSIS Catalog.
• Prepared the PowerShell scripts to deploy BI (DB, SSIS, Model and Job Configuration) Components.
• Created the Unit Test Projects to deliver bug free solutions.
• Created the jobs for package automation using SQL Server Agent.
• Generate the Power View reports by using SSAS Tabular model.
• Provided data security in Power View reports by using DAX queries
• Implemented the Delta Pull for reducing the daily job time and maintain historical data.
• Automated and enhanced daily administrative tasks, including space management, backup & recovery and performance monitoring.
• Worked on index defragmentation based on the fragmentation levels.
• Involved in migrating DTS packages from SQL Server 2000 to SSIS packages in SQL Server 2005 database.
• Created and optimized SSIS packages for data flow between SQL Servers.
• Extensively used SSIS and DTS packages for data archiving.
• Extensively worked on Extracting, Transforming and Loading (ETL) of Data from Excel, Flat file to MS SQL Server using DTS Import/Export utility, BCP, DTS and SSIS Packages.

Environment: SQL Server 2005/2008, Microsoft Windows 2008 Server, SQL Server Management Studio, T-SQL, SSIS, SSRS, SSAS.