SUMMARY:

• Certified SQL Server Database Admin/DBA having about six (6) years of hands - on experience as MS SQL Server Database Administrator (DBA) working on SQL Server Database Administration, Database Design/Modelling, Report Development (SSRS), Report Deployment, Report Distribution, DTS, Data Migration Using SSMA from Oracle, MySQL, MS Access Database, ETL, Integration Services (SSIS) Packaging, managing Very Large Databases (VLDB), Backup/Recovery, Monitoring, Troubleshooting, Performance Tuning, Replications, AlwaysOn, Mirroring, Clustering, AlwaysOn and writing SQL/TSQL scripts - Stored Procedures, Functions, Triggers, Constraints and Views. In depth knowledge and experience with Database Security, Encryption, TDE (Transparent Data Encryption), third party tools like RedGate, Idera, Solar winds, OpNet, SpotLite, ERWin, Toad Data Modeller and Toad for SQL Server Admin.
• Besides that I hold excellent hands on experience on Operating Systems (Windows 2012R2, 2008 R2, and 2003 R2).
• Have an excellent understanding of business and technical vision. Have effective people skills and ability to manage multiple complex projects having innovative and creative problem solver, results oriented, aptitude for learning and can maximize resources while possessing a sense of urgency. Good experience with the phases of Software Development Life Cycle SDLC, SELC, STLC & AGILE such as requirement gathering & analysis, design, development, testing, implementation & maintenance.
• Self-motivated, team player with excellent verbal, written and communication skills with business analysis and technical knowledge

TECHNICAL SKILLS:

Databases:: SQL Server 2016, 2014, 2012, 2008R2, 2005, 2000.

SQL Server Tools:: SQL Server Management Studio (SSMS), Enterprise Manager, Business Intelligence Development Studio (BIDS), Query Analyzer, SQL Profiler, Database Tuning Advisor, Index Tuning Wizard, BCP, SQLCMD, Upgrade Advisor, SQL Configuration Manager, Client and Server Network Utilities, Surface Area Configuration

Database Tools: Profiler, DTS, Management Studio/Enterprise Manager, Query Analyzer, SSIS, SSRS

Reports Development/Management:: Report Development, deploy, manage, migrate, and upgrade reports and Report Server. Strong expertise on configuring and managing Report Server such as SQL Server Reporting Service (SSRS), developing report using BIDS (Business Intelligence Development Studio), SSDT (SQL Server Data Tools), and Report Builder, using Microsoft Access and Microsoft Excel to map with SQL Server for data manipulation and Data Analysis

Data Modelling:: ERWin, SSDD (SQL Server Database Diagram.)

Programming:: SQL, T-SQL, Scripting, debugging, improved performance stored procedures, Functions, Triggers

SSIS/DTS:: DTS, SSIS Package create, manage, deploy, upgrade and migrate packagesData Migration:: using SSMA for DB2, SSMA for Oracle, SSMA for MySQL and SSMS Export/Import Wizard, DMA tool

Performance Tuning: Server Optimization and Performance Tuning, Query Optimization, Experience in resolving Dead Locks or long running queries. Experienced in using different Tools - Profiler, Execution Plan, PerfMon, Extended event, Database Tuning Advisor, DMV, Windows Performance Monitor, Idera SQL Diagnostic

Database High Availability:: Strong knowledge and experience in configuring and administering High Availability Database Solutions like Database Mirroring, AlwaysOn, Replication, Log shipping, Cluster Database

Windows Server and Active Directory:: Experience in administering Windows Server 2012R2,2012, 2008 R2, 2003 R2, AD (Active Directory), Domain, DNS server, DHCP server configuration, Mail server, monitoring user activities, VMware.

Security: Experience with Security and Audit Management like Security, Encryption, TDE (Transparent Data Encryption), Change Data Capture

Upgrade/Migrate: Migrated Oracle, MySQL, Sybase to SQL Server and Upgraded databases from MS SQL Server 2005, 2008 R2 to higher version.

Application Server: Administered IIS application server, deployed applications

Service Pack: Applied Service Pack (SP) and Hot Fixes for Databases and Operating Systems

Documentation: HTML, DOC, DOCX and PDF format

Third Party Tools: Idera, Erwin, and Toad for SQL Server Admin

Web Technologies: SQL, T-SQL, HTML, VBScript, ASP, .Net Technologies: VB. NET, ASP.NET

Dot Net Technologies:: VB. NET, ASP.NET

Development Tools: Visual Studio (VB), Visual Studio2010/2012,2015, BIDS, SSDT

Networking:: Active Directory, TCP/IP, Network Switches, Network Hubs, Network Printer.

Hardware/Storage: SAN, RAID

Operating System:: Excellent Knowledge in Windows Server 2012 and 2012R2, add Role and Features, Creating Domain Controller, Creating Cluster, User, Group and Grant Permission and maintain security through Windows level.

VMWare/Virtual Box:: Knowledge and experience of Installing, working on VMWare/ Virtual box

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, Florida

MS SQL Database Administrator/SQL DBA

Responsibilities:

• Have hands on experience on Development, Test and Production environments.
• Installed, Configured, and Administered SQL Server as standalone, side-by-side, Replication, in-place
• Administration includes SQL Server 2008, 2008 R2, 2012, 2014, 2016
• Installed, Configured and Managed Database AlwaysOn, Mirroring, Replication and Log Shipping.
• Installed, Configured and Maintained Fail-Over Cluster Servers in SQL Server 2005, 2008, 2008 R2 & 2012.
• Upgraded SQL Server 2005, 2008 and 2008 R2 Database into SQL Server 2012, 2014, and 2016.
• Applied Service Pack (SP) and Hot Fixes
• Migrated DB2, MySQL and Oracle Databases into SQL Server.
• Wrote SQL, T-SQL, Stored-Procedures and Triggers.
• Optimized SQL queries, Stored Procedures and Functions
• Monitor Server Activity and solving problem as needed.
• Performed database monitoring, performance tuning, index and statistics management.
• Monitor Servers activity and worked with clients to solve different problems.
• Managed SQL Server Error Logs, space usage and growth pattern.
• Managed DEADLOCK, BLOCK and LOCK.
• Created Backup jobs for different types of backup like FULL, Differential and Transaction Log.
• Created Jobs for database maintenance Index fragmentation, rebuild and database statistics.
• Worked on different Data Modelling projects including ERWin Modeller on designing Logical & Physical Database.
• Created and managed Index (Cluster/Non-Cluster), Constraints.
• Created and Managed users, roles, security at object level, data encryption.
• Work experience and strong knowledge in disaster recovery.
• Restore and Recover databases using backups.
• SSIS/DTS:
• Created, managed, deployed, upgraded and migrated DTS/SSIS Packages
• Reports:
• Installed, Configured, and administered SQL Server Reporting Services (SSRS.)
• Developed Ad-hoc Reports using Report Builder.
• Deployed Reports and managed security for reports.

Work Environment: Windows Server 2012R2, 20112, 2008 R2, SQL Server 2016, 2014, 2012, 2008 R2, 2008, AD (Active Directory), SSIS, Reporting/SSRS, IIS, Dot Net, and J2EE Apps.

Confidential, New York

MS SQL Database Administrator/SQL DBA

Responsibilities:

• Database Programming: Wrote T-SQL, Trigger, and Stored-Procedures. Assisted Database Developers to optimize SQL queries and Stored Procedures.
• ETL Tools: Used ETL tools like DTS, SSIS, Import/Export, BCP (Bulk Copy), to import & export data from flat files, and excel to MS SQL Server databases.
• Export & Import: Data from/to Oracle, MySQL, and Access Database including flat files like text, Excel, and CSV files to SQL Server 2005/2008.
• Report Development: Installed, Configured, and administered SQL Server Reporting Services. Developed Reports using SSRS. Deployed Reports. Developed Ad-hoc Reports using Report Builder 3.0, 2.0.
• Used DBCC to check database conditions, Rebuilding indexes and other database Maintenance purposes as well.
• Database High Availability: Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2008/2005. Installed, Configured and Maintained Database Mirroring using automatic fail-over option in SQL Server 2008. Configured Log Shipping as Standby database from Production database for Reporting purposes. Configured and Maintained Replications.
• Database Upgraded: SQL Server 2005 to SQL Server 2008. SQL Server 2008,and 2008R2 to 2012
• Database Migration: Migrated MS Access 2003/2000/97 databases into MS SQL Server. Migrated Oracle 10g, MySQL into MS SQL Server 2008R2.
• Data Modelling: Worked on more than 10 data modelling projects and generated E-R Diagram. Data modelling tools used using SQL Server Data Diagram.
• Database Monitoring/Performance Tuning: Strong on database Monitoring and Performance tuning. Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification. Monitor SQL Server Error Log, space usage.
• Backup/Recovery: Strong knowledge and working experience in Database Backup and Disaster Recovery. Experienced with Point-in-Time Recovery. Restored Database from backup.

Work Environment: Windows Server 2012R2, 2014, 2008 R2, 2003 R2, SQL Server 2008R2, 2005, AD (Active Directory), applications - Registration System, Reporting System, Booking System, TimeSheet, and Payroll & HR