SUMMARY

• Database Admin with 7 years of comprehensive experience in management, migration, upgrade, production and design with MS SQL Server 2008/2012/2012 r2/2014/2016 in different industries such as financial, retail, Consulting, healthcare.
• Experience in Data Migration by using side - by-side upgrade process Management
• Responsible for creating and managing database objects like tables, Indexes, views, stored procedures triggers etc.
• Expertise in implementing and maintaining efficient disaster recovery strategies and high availability like Replication, Log shipping, Clustering (active-active and active-passive)
• Have done extensive amount of job that required for me to implement SQL server security.
• Skilled with Database consistency checks using DBCC & Dynamic Management Views using DMV’s.
• Vast use of tools/processes that were in use daily are below
• Strong background in planning and applying different types of replication methods like Snapshot, Transactional and Merge Replication
• Experienced in mobilizing tasks such as planning, scheduling jobs, Backup and recovery strategies, index tuning and performance tuning and archiving data.
• In-Depth knowledge about query optimization, complex Scripts, Batches, Stored Procedures, Cursor, Triggers, Tables, Views, User Defined Functions, Data Integrity, and SQL joins.
• Familiarity in Identifying the Bottlenecks caused by complex queries using Activity Monitor/SQL Profiler.
• Monitored SQL server to captures performance problem and improve performance by tuning Databases.
• Experience in creating and maintaining Backup and Restore, Mirroring and Log-Shipping strategy as a part of Disaster recovery.
• Well versed in Capacity Planning and storage management.
• Superior analytical and communication skills with 24/7 rotated support experience.
• Considerable knowledge in using of SSMS, SSIS, SSAS, SSRS in day to day activity.
• Experienced in mentoring, coaching and writing documentation

TECHNICAL SKILLS

• TSQL
• SQL profiler and SQL Query Analyzer
• Crystal reports
• BID
• SQL server report builder
• Visual Studio.
• MSDTS
• SSIS
• ETL
• BCP
• Data Migration
• Import/Export Wizard
• SSMA

PROFESSIONAL EXPERIENCE

Confidential, NY

SQL database administrator

Responsibilities:

• Responsible for high availability SQL server solutions with SQL server failover clustering, database snapshot, log shipping and database mirroring using SQL server 2014/2016.
• Oversighted performance monitoring with activity monitor, SQL profiler, Performance monitor, Database Tuning advisor, DMVs and DMFs, SQL diagnostic manager.
• Performed side by side migration and new machine installation.
• Experienced in implementing different type of replication models, capacity planning, performance tuning, disaster recovery, troubleshooting backup and restore procedures.
• Responsible for security administration work i.e creating users and assigning them roles and privileges.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases and process SSAS cubes.
• Tasks such as table/index partitioning, full text search and tuning the production server to inhance the performance was some of the day to day work to name a few.
• Conducted root cause analysis of application availability and narrow down the issues related to coding practices, Database Bottlenecks, or Network Latency.
• Performance tuning of Queries and Stored Procedures using graphical execution plan, Query analyzer, monitor performance using SQL Server Profiler and Database Engine Tuning Advisor.
• Monitoring and checking alert logs and user dump files for correcting errors and tuning.
• Helped migrate data using export and import between tables
• Creating Backup strategies and scheduling using third party tool like Lite Speed, as a part of database maintenance plans.
• Created the MS SSIS packages for executing the required tasks. Created the Jobs and scheduled for daily running.
• Highly skilled with point in time backup and restoring strategies, Troubleshooting databases for both performance and maintenance errors.
• Monitoring SQL servers for performance ad-hoc and pro-actively
• Providing 24/7 supports to SQL application developers in implementing the applications on production server.

Confidential, MI

SQL Server DBA

Responsibilities:

• Migrated different databases to it’s next gen using in place upgrade process with the help of advisor tool. I.E 2012 SQL server to 2014 and server.
• Manage SQL Server security by granting appropriate server and databases roles/permissions and by having frequent security checks for inappropriate access
• Manage disk space on SQL servers by shrinking data and log files. Determine and forecast the growth of the databases and increase disk space as required
• Check alerts from SQL log and work with server team to fix any I/O or operating system issues. Help troubleshoot error and perform root cause analysis
• Work towards achieving 100% results with service level agreements by handling requests as per severity and getting back to the users well before SLA with resolution.
• Ensure daily and weekly database maintenance jobs succeed. Also take care of other application related jobs that are critical for the application.
• Used DTS packages to move logins and jobs from one server to another server.
• Knowledgeable about log shipping for synchronization of database.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Procedures such as creating stored procedures, triggers, views, functions and updating indexes were few of my day to day tasks.
• Monitored the server performance using profiler, perfmon to locate deadlocks, slow performance causes.
• Handled up to 2 TB Size databases with clustered and stand-alone environment.
• Revoked public access to DB objects from all production servers to ensure security.
• Support disaster recovery project planning, testing and implementation.
• Coordinate with external vendors and make changes to improve performance of the application. Implement Microsoft's recommendations to improve server performance.
• Participate in weekly Change Board meetings and explain the DB changes proposed.

Confidential, Cockeysville, MD

Database Admin SQL server

Responsibilities:

• Involved in redesigning and redefining data warehouse and provided necessary documentation.
• Use SSIS packages to extract data from old Data Warehouse and push into new Data Warehouse.
• Transformed complex business logic into Database design and maintaining it by usingSQLobjects like Stored Procedures, tables, Views, Functions.
• Used DDL, DML, and TCL to write query, recursive CTE, Join and views.
• Successfully implemented indexes on tables for optimum performance.
• Created SSIS 2012/2014 Packages to integrate data coming from Text files and Excel files.
• Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS 2012/2014
• Configured and Deployed SSIS Packages.
• Used SQL Agent to setup schedule for SSIS Packages.
• Responsible for implementation of data viewers, SSIS 2012/2014 Logging, error configurations for error handling the packages.
• Created several drill down and drill through reports usingSSRS
• Developed dashboard reports using reporting Services, report Model and reporting usingReport Builder.
• Experienced in creating linked reports and parameterized reports withknowledge of report serving architecture. (Table, chart and matrix report)
• Use various SSIS transformations such as Conditional Split, Lookup etc which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Created ETL packages with different data sources (SQLServer, Flat files, Excel source files, Fixed File) and loaded the data into target tables by performing different kinds of transformations using SSIS 2012.
• Updated and made necessary changes to existing Tubule, matrix and parameterize SSRS reports.

Confidential, MA

SQL server DBA

Responsibilities:

• User creation and ACL Management
• Installation in new machine, side by side installation and upgrade
• Create, deploy, configure and monitor complex ETL/SSIS packages Created maintenance plan fordatabaseconsistency and optimization
• Document server anddatabasepolicies and procedures.
• Involved in performance tuning using Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards.
• Analyze existing indexes for missing or unused/overlapping indexes.
• Solid hands on performance monitoring with Activity monitor, SQL Profiler, Performance monitor, Database Create and maintain various databases for Production, Development and Testing Servers using Tuning Advisor, DMVs and DMFs, SQL Diagnostic Manager.
• Responsible for different replication models and implementing DBCC utilities to maintain the consistency and integrity of each database in the production server.
• Conducted root cause analysis of application availability and narrow down the issues related to coding practices, Database Bottlenecks, or network latency.
• Experience with Database consistency checks using DBCC & Dynamic Management Views using DMV’s.
• Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
• Provide local and remote help desk support to all staff members, resolving various technical issues.
• Create and manage Server 2008 security, such as monitoring system performance, Event Viewer log, Firewall, Virus protection, Windows update, Spyware Protection.
• Monitor and provide 24 X 7 critical production support