SUMMARY:

• 10+ Years as a Microsoft SQL Server Database Administrator with extensive professional experience in developing, managing and maintaining SQL Servers 2005/2008/2008 R 2/2012/2014/2016 versions with different editions.
• I have expertise in troubleshooting, designing databases, disaster recovery, HA solutions, developing reports and SSIS packages, migrate and upgrade databases, proactive monitoring, performance tuning, SQL/T - SQL queries and handling complex production issues.
• I am a self-motivated, team player with excellent verbal, written and communications skills.
• I have in depth understanding of the business analysis with proven ability to deliver high quality products and services on a scheduled and under budget.
• I am seeking for a challenging position with a prospective and growing company to utilize and expand my professional and technical knowledge, skills and experiences.

Database Administration and Management:

• Have broad knowledge on Advanced Installation and Configuration, Monitoring and Health Check, Reporting, and Maintenance with troubleshooting capabilities.
• Apply Hot Fixes, Service Packs (SP) in Prod, Dev and UAT, and good in Patch management
• Have well experience to set up Job, Database Mail Alert and Maintenance Plan
• Implemented Linked Servers within SQL Server environment
• Have work experience on Database Partition, Distributed Database Management System
• Set up Dev and UAT Environment and Implement Data Masking
• Perform Database / Technical Refresh and Cut Over for Prod Environment

Performance Tuning and Monitor Database Health:

• Have proven experience in the areas of Database Performance Tuning and Monitoring database health, disk space Utilization using native and 3rd party tools.
• Working Knowledge on DMVs and DMFs
• Have strong experience on Query Optimization, Query Execution Plan

Database Encryption and Security:

• Implement Transparent Data Encryption (TDE) on Databases
• Implement Column level Data Encryption and Data Decryption
• Implement and Manage Database Level Permission, Object Level Permission, Role Level Permission, and Schema Level Permission.
• Maintained individual and group service accounts for SQL Server security

High Availability and Disaster Recovery:

• Installed, Configured and Maintained Database Mirroring using automatic Fail-Over options in SQL Server
• Configured Log Shipping as Standby database from Production database for Reporting purposes
• Configured Clustering in VMware Environment
• Configure ‘Always On’ on SQL Server 2012
• Configure and Maintain Transactional, Peer to Peer and Merge Replication
• Experienced in SQL Server Backup and Disaster Recovery and Security Management Operations

Reporting:

• Installed, Configured, and administered SQL Server Reporting Services (SSRS)
• Developed and published Reports using SSRS

ETL Tools:

• Installed, Configured, and administered SQL Server Integration Services (SSIS)
• Skilled in ETL Operations, Batch Process, Export & Import data from Excel File, Flat file, CSV file to/from SQL Server Database using DTS,BIDS, SSDT
• Developed and Deployed SSIS Packages in Visual Studio.
• Developed Data Warehouse using SSAS, Created Cube using Fact and Dimension table

Database Migration:

• Migrate Database from SQL Server 2000/2005/2008 R2 to SQL Server 2008R 2/2012/2014/2016
• Migrate Database from MySQL 5.5.1 to SQL Server 2012
• Export & Import data from My-SQL and Access databases to SQL Server and Vice Versa

Operating Systems (OS):

• Knowledgeable on 64/32 bit SQL Servers and Windows Server Systems
• Good knowledge and working experience in Operating Systems (O/S) - Windows Server 2008 R2, Windows Server 2012 R2 including Active Directory Domain Services.
• Installed, Configured, and Managed VMware.

Database Design and Data Modelling:

• Have wide knowledge and experience in Database Design and Development, and Data Modeling using Normalization and UML Diagrams
• Have strong Knowledge on SSADM and OOAD Methodology
• Have practical experience in Conceptual, Logical, and Physical Data Model
• Knowledgeable in Data Warehousing Architecture, Schema, OLAP, ROLAP, MOLAP
• Have knowledge on Forward & Reverse Engineering with data modeling tools

Programming and Testing:

• Have strong knowledge and experience in SQL/T-SQL, Stored Procedure, Trigger, Views, Distributed Query
• Have Basic idea about PHP, HTML, CSS, JAVA SCRIPT, and AJAX.

Others:

• Proficient in other technologies including MySQL, ODBC, OLEDB, Toad Data Modeler, and IIS Web Server.
• Have Effective communication skills, multi-tasking and prioritizing skills, excellent interpersonal skills, strong customer focus view, quick learner, team player, reliable, dependable and ability to adapt to changing environments.

TECHNICAL SKILLS:

Database Management System: SQL Server 2016/2014/2012/2008 R2/2005, MySQL, MS, Access2007, 2003

Database Design & Data Modeling: Normalization, Unified Modeling Language (UML), Toad Data Modeler, SSDD (SQL Server Database Diagram)

Operating System & VMware: Windows Server 2012 R2/2008 R2/2003 R2/2000, Windows XP/7/8,

Languages: SQL, T-SQL, HTML, Ajax, JavaScript, PHP

ETL Tools: SSIS, DTS, Visual Studio, SSDT and BIDS

Reporting: SSRS (SQL Server Reporting Services)

Third-Party Tools: Idera, Red Gate, Toad Data Modeler, Service Now, Jira

Version Control: Team Foundation Server (TFS)

Native Tools: SQL Server Profiler, Extended Events, Database Engine Tuning Advisor, Performance Monitor, Resource Monitor, Activity Monitor, Query Execution Plan, SSMA, DMA

Networking: Active Directory, TCP/IP, LAN/HTTP/ HTTPS

PROFESSIONAL EXPERIENCE:

Confidential, Weehawken, NJ

Database Admin Consultant

• Installed and configure SQL Server 2012/2014
• Set up Jobs and Maintenance plan.
• Configure Linked Server
• Implement Data Masking for Dev Environment
• Implement Transparent Data Encryption(TDE) on Production Server
• Perform Database/Technical Refresh
• Apply Service Pack on Prduction databses
• Migrated 32 Database Servers/Instances from SQL Server 2000/2005/2008 R2 to SQL Server 2008R2/2012/2014
• Trouble Shoot performance issues related to query optimization, tempdb, and log file growing fast, identify and release Lock, block and deadlock.
• Used DMVs and DMFs to Diagnose Server Health and Improve Performance
• Developed Stored Procedure, Trigger, Views using SQL and T-SQL.
• Managed Backup and restore process.
• Configured and Maintained Database Mirroring using Automatic Fail-Over options in SQL Server 2012 / 2008 R2
• Configured Log Shipping as Standby database from Production database for Reporting purposes
• Configured and Implemented Transactional Replication
• Created SQL Server migration analysis report that will publish the cost and time requirements for Migration using SSIS and SSRS
• Developed Data Warehouse using SSAS, Created Cube using Fact and Dimension table.
• Developed and published Reports using SSRS that include Drill-Down Report, Graph, and Chart etc.
• Send Report through Email in MHTML and Attachment using Data Driven Subscription
• Developed and Deployed SSIS Packages.
• Migrated SSIS Packages from SQL Server 2005 to SQL Server 2012
• Created SQL Server Analysis tools to estimate time and cost for the migration requirements using SSIS.
• Skilled in ETL Operations, Batch Process, Export & Import data from Excel File, Flat file, CSV file to/from SQL Server Database using DTS,BIDS, SSDT
• Export & Import data from Excel File, Flat file, CSV file to/from SQL Server Database using DTS,BIDS, SSIS
• Developed Cube in SSAS for Dimensional Reports.
• Designed and Developed Database for SQL Server Analysis Tools

Confidential, Alexandria, VA

SQL Database and Reporting Service Administrator

• Installed, Configured, and Managed SQL Server 2008 R2, 2012 in development, test, and production environment
• Installed and Configured SQL Server 2014 for testing different features and stability
• Migrated Database from SQL Server 2005/2008R2 to SQL Server 2012/2014
• Implemented Data Masking for Dev and UAT environment
• Implemented Transparent Data Encryption(TDE), and Column level Data Encryption and Decryption
• Skilled in ETL Operations, Batch Process, Export & Import data from Excel File, Flat file, CSV file to/from SQL Server Database using DTS,BIDS, SSDT
• Installed, Configured and Maintained Database Mirroring in SQL Server 2012/2008 R2
• Configured Log Shipping as Standby database from Production database for Reporting purposes
• Configured and Maintained Replications (Transactional)
• Configured Clustering in VMware Environment
• Managed backup and disaster recovery strategy using automated jobs
• Took Point-in-Time Recovery of databases.
• Developed Dynamic Script to Restore Database from backups
• Export & Import data from/to My-SQL, and Access databases to/from SQL Server
• Designed Database, Model Data and Developed E-R Diagram
• Used different Data Modeling tools e.g. Toad Data Modeler, SQL Server Data Diagram
• Performed Forward & Reverse Engineering
• Applied SP/ HOT Fixes (Service Pack) on SQL Server
• Monitored Performance tuning issue and trouble shoot errors.
• Implemented scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification, Database Mail Alert
• Followed up SQL Server Error Log, Space usage
• Used SQL Server Profiler, Extended Event, Database Engine Tuning Advisor, Performance Monitor, and Activity Monitor to analyze and monitor performance of the system.
• Used Idera SQL Diagnostic Manager to monitor SQL Server status as a Third Party Tools.
• Wrote Functions, Trigger, View, and Stored-Procedures using T-SQL to manage and administer database.
• Developed Data Warehouse using SSAS, Created Cube using Fact and Dimension table
• Assisted Database Developers to optimize SQL queries and Stored Procedures
• Installed, Configured, and administered SQL Server Integration Services (SSIS)
• Export & Import data from Excel File, Flat file, CSV file to/from SQL Server Database using DTS,BIDS, SSDT
• Developed and Deployed SSIS Packages
• Installed, Configured, and administered SQL Server Reporting Services (SSRS)
• Developed and Deployed Reports using SSRS

Confidential

Database Consultant

• Installed, Configured, and Managed SQL Server 2008 R2, 2012 in development, test, and production environment
• Set up Jobs and Maintenance Plan
• Developed database using SQL Server and MS Access
• Improved performance tuning for several clients using query optimization, optimize isolation level, reducing Lock, block and deadlock etc.
• Worked with DMVs and DMFs
• Worked with SQL/T-SQL, Stored Procedure, Trigger, Views etc.
• Set up jobs to automate backup and restore process.
• Configured and Maintained Database Mirroring using automatic Fail-Over options in SQL Server 2008 R2.
• Developed Data Warehouse using SSAS, Created Cube using Fact and Dimension table.
• Skilled in ETL Operations, Batch Process, Export & Import data from Excel File, Flat file, CSV file to/from SQL Server Database using DTS,BIDS, SSDT
• Configured Log Shipping as Standby database from Production database for Reporting purposes
• Configured and Implemented transactional Replication
• Installed , Configure and administered SQL Server Reporting Services (SSRS)
• Created different types of report e.g. Time based Sales Report, Geo location based sales report etc. and publish report on the Web.
• Installed Configure SQL Server Integration Services (SSIS)
• Developed and Deployed SSIS Packages in Visual Studio.
• Move data from Excel File, Flat file, CSV file to SQL Server Database using BIDS, SSDT
• Migrated Database from SQL Server 2005/2008R2 to SQL Server 2008R2/2012
• Design, Build Logical and Physical Data Models.
• Create Entity Relationship Diagram (ERD)
• Model Database Using Third Party Tools, Toad Data Modeler
• Conduct System Analysis and Design using UML and SSADM
• Produce Software Requirements Specifications (SRS)

Confidential

Project Supervisor, Database Administrator

• Installed and Configure SQL Server 2000, 2005 & 2008 in development, test, and production environment
• Reinstate the Development Environment from the Current Production Environment
• Deploy Script from Development Environments to Production
• Designed and implemented monitoring tool for capturing Log Events for Production Server performance monitoring and alert messages for blockings
• Developed Database Maintenance Plan
• Was Responsible To Monitor Servers activity, Solving problem
• Prepared and implemented documentation for new server configuration and software installation
• Set up or scheduling jobs in different locations and servers for back ups
• Performed Database health checks, tuning, performance for databases and systems
• Setting up and maintaining security at the database as well as server level
• Was responsible to create and administer user accounts
• Implemented and Managed Database Level Permission, Database Object Level Permission, Database Role Permission, Schema Level Permission.
• Implemented Transparent Data Encryption and Data Decryption, and Column level Encryption
• Rebuild Servers (Restore & Recovered from tape/ CD backup) from backup
• Configured Log Shipping from Production to Standby Server (Running as Reporting Server)
• Configured and Maintained Database Mirroring, using automatic Fail-Over options in SQL Server 2012/2008 R2
• Managed backup and disaster recovery strategy using automated jobs
• Took Point-in-Time Recovery of databases.
• Created automated script to Restore Database from backups
• Migrated SQL Server 2005 to SQL Server 2012/2008 R2
• Export & Import data from/to databases like My-SQL, and Access to/from SQL Server
• Designed database and model data and generated E-R Diagram
• Used Data Modeling tools e.g. Toad Data Modeler, SQL Server Data Diagram
• Performed Backward & Forward Engineering
• Applied SP/ HOT Fixes (Service Pack) on SQL Server
• Performance tuning and monitoring using SQL Server Profiler, Database Engine Tune Advisor, Performance Monitor
• Index tuning; worked on rebuild indexes, reorganized index based on fragmentation level,
• Used SQL Server Profiler, Extended Event, Database Engine Tuning Advisor, Performance Monitor, and Activity Monitor to analyze and monitor performance of the system.
• Written T-SQL, Design and Create Databases, Tables, Views, Functions, Stored Procedures and Triggers
• Written T-SQL, Functions, Trigger, View, and Stored-Procedures to manage and administer database.
• Worked with Database and Application Developers to optimize SQL queries and Stored Procedures
• Created and Deployed SSIS packages using BIDS, set up SQL Agent jobs, loading data from different databases to SQL Server database
• Export & Import data from other data sources like flat files using the Import / Export through DTS and SSIS
• Provide Training on Database Design and Development, Web development.