SUMMARY

• An experienced Certified Microsoft SQL Server Database Administrator with SQL/TSQL skills having more than 7 years, who is dedicated to keep up - to-date industry knowledge looking for SQL Server Database Administrator/DBA job.
• Dedicated and Responsive professional has experience in Database Design, administration, ETL Processing, Report Development, Data Modeling, SQL/TSQL Scripting, Gathering and analyzing business requirement and Administering Windows Server Operating Systems.
• Solid working experience in managing and troubleshooting large databases, backup/recovery, developing and managing reports using SQL Reporting Services (SSRS), Monitoring, Performance Tuning, stored procedures, triggers, functions, constraints and views etc.
• Professional experience entails configuring and managing Databases and Database Servers using SQL Server 2016/2014/2012/2008 R2/2005 and Strong business and technical vision with effective people skills, ability to manage multiple complex projects, innovative and creative problem solver, results oriented, and has an aptitude for learning and can maximize resources while possessing a sense of urgency.
• Extensive experience in SQL Server Database Management System in the areas of Database Administration, Reporting, Data Modeling, Database Design and Development, Advanced Installation, Configuration, Backup and Recovery, Upgrade, Service Pack (SP), SQL/T-SQL, Stored Procedure, Trigger, DMV, DBCC, Clustering, Always On, Mirroring and Replication.
• Proven experience in Database Performance Tuning using SQL Server Profiler, Extended event, Database Engine Tuning Advisor, Execution plan, Performance Monitor and other third-party tools like Idera, RedGate and SolarWinds.
• Configured and managed High Availability and Disaster Recovery solutions like Log shipping, Mirroring, Replication, SQL Server clustering and AlwaysOn.
• Experienced with SQL/T-SQL scripts including scripts/SQL/TSQL for managing Database and database objects.
• ETL: SSIS & DTS Packages: Created, configured, deployed, and managed including Migrate and Upgrade. Working experience in Data Movement, data dumping using different tools like Export & Import utility, Data Tools, BIDS, SSIS
• Upgrade and migrate: Upgraded and migrated from SQL Server databases and instances from older version to newer version like SQL 2005 to SQL Server 2008 R2/2012 in different environments. Migrated data from Oracle to Sql and Sql to Oracle.
• Manage Security Management: Securing SQL Servers and Databases, manage users, Data encryption, granting/ revoking access.
• Cloud/Azure experience entails Azure Services, Migrated on premises databases and Legacy databases to Azure, deployed products on Azure, and setup development and test environment on Azure.

TECHNICAL SKILLS

Operating Systems: Windows Server 2016,2012R2, 2008 R2

Databases: MS SQL Server 2016,2014, 2012, 2008 R2, MS Access

Database Migration: Migrated Oracle, MySQL, and MS Access Databases to SQL Server Upgrade SQL 2008R2,2012 to 2014, 2016

Database Tools: SSMS (SQL Server Management Studio), SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, SQL Agents, SQL Alerts, SQL Jobs, SQL Mail, SQL Client Configuration utility, Backup and Restore, mirroring, Replication, Log Shipping

Third Party Tools: SolarWinds, ERWin, Idera, RedGet, DDBoost

ETL Tools: DTS (Data transformation services), SSIS (SQL Server Integration Services)

Development skills: SQL, Transact SQL (T-SQL): Writing Query and Scripts

Reporting Tools: SSRS (SQL Server Reporting Services)

DR (Disaster Recovery) and HA (High Availability) Solutions: Backup & Recovery, Log Shipping, Mirroring, AlwaysOn, Replication and Clustering

Data Security: TDE (Transparent Data Encryption), IPSec, SSL, Data Masking, Column level security

Hardware/Storage: SAN, RAID

VMware: Installing, configuring, and administering

Cloud: Migrated and Managed Databases in Azure Database & Azure VM from on Premises databases systems. Migrated and Managed Databases in Azure VM, AWS.

Professional Work Experiences

Confidential

SQL Server Database Administrator

Responsibilities:

• Managed Database Servers in Development, Test, Production environment.
• Installed, Configured, and Managed SQL Server 2008 R2, 2012, 2014,2016 in Development, Test, and Production environment.
• Installed, Configure and Maintained HA/DR Solutions using Clustering, AlwaysOn, Mirroring, Replication, and Log Shipping.
• Installed, Configured, monitored and troubleshoots Log Shipping as Standby database from Production database for Reporting purposes.
• Strong knowledge and working experience in Database Backup and Disaster Recovery.
• Experienced with Point-in-Time Recovery.
• Restored Database from backups.
• Upgraded/Migrated SQL Server 2005 to SQL Server 2012/2008 R2.
• Migrated MS Access Database 2000, 2003 into SQL Server 2008r2, 2012.
• Good understanding on data modeling projects and generated E-R Diagram.
• Data Modeling tools used: Toad Data Modeler, SQL Server Data Diagram.
• Backward & Forward Engineering with data modeling tools mentioned above.
• Applied SP/ HOT Fixes (Service Pack) on SQL Server.
• Applied SP/Hot Fixes on SQL server Instances to address Security and upgraded related issues.
• Strong on database Monitoring and Performance tuning.
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification.
• Monitor SQL Server Error Log, Space usage.
• Strong on SQL Server Profiler, Extended Events, Database Engine Tuning Advisor, Performance Monitor, Activity Monitor, Execution plan.
• Besides Native tool, used OpNet as a Third Party Tool for monitoring and Performance Tuning.
• Writing T-SQL, Functions, Trigger, Partition, View, and Stored-Procedures, joins, union and writing scripts for job set-up.
• Assisted Database Developers to optimize SQL queries and Stored Procedures.
• Export & Import data from Excel File, Flat file, CSV file to/from SQL Server Database using BIDS, SSDT.
• Export & Import data from/to databases as My-SQL, and Access to/from SQL Server.
• Creating SSIS Packages and deployed from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports OLEDBData sources.
• Setup jobs from SSIS Packages.
• Installed, Configured, and administered SQL Server Reporting Services (SSRS).
• Developed and deployed different type of repot using different data source like SQL Server, Oracle, CSV, Excel .
• Delivered reports to users in variety of format like Report Server (Web Based), Excel, CSV, PDF formats.

Cloud/Azure: Migrated on premises databases and Legacy databases to Azure, and setup production, development and test environment on Azure .

Environment: SQL Server 2008R2,2012,2014, IIS 7.5, 8.5, Windows Server2008R2, 2012, ASP, ASP.net, ETL and AD (Active Directory)

Confidential

SQL DBA/Database Administrator

Responsibilities:

• Installed, Configured, and Managed SQL Server 2005, 2008, 2008R2 in development, test, and production environment.
• Installed, configured database associated tools and performance monitoring Software.
• Setup, Configured, monitors and Maintained Database Replications.
• Installed, configured, maintain and monitored troubleshoots SQL Server Database Mirroring.
• Securing SQL Servers and Databases, Manage users, Data encryption, granting/ revoking access.
• Data Encryption and Data Decryption for data security in Database & Column level.
• Managed Backup/Restore, Point-in-Time Recovery including backup verification, security by native tools and RedGate tools.
• Applied SP (Service Pack) on SQL Server 2005, and 2008, 2008R2.
• Expertise in database Performance tuning SQL profiler, Execution Plan, Database tuning Advisor, Activity Monitor, Performance Monitor.
• Monitored data activities such as logs, space utilization, locks, long transaction.
• T-SQL, Stored-Procedures, Triggers, Function, Views, Indexes.
• Developed and maintained scripts, utility jobs or implement-needed software for database maintained.
• Created and managed Indexes, Constraints, and Keys (Primary Key, Foreign Key).
• Worked on different Data Modeling projects including creating scripts, E-R Diagram, backward/forward engineering.
• Worked multiple Data Modeling projects for different applications.
• Processed data dump and Exported & Imported data from Flat file, CSV file, Oracle, My-SQL, and Access to/from SQL Server Database using DTS, SSIS, and EXP/IMP tool.
• Export & Import data from Flat file (CSV, Excel) to SQL Server Database using EXP/Imp and DTS tool.
• Setup automated jobs for different purposes including backup, monitoring database health, disk space, backup verification, and moving databases from environment to environment including creating test environment.
• Developed Different Maintenance Plans such as backups, index management, fragmentation management, cleaning history, deleting old files.
• Monitored Server Activity, Error Log, space usage, and solving problem as needed.
• Executed change management scripts on weekly basis.

Environment: SQL Server 2005, 2008, 2008R2, IIS Server 6.5, 7.5, Windows Server 2003R2, 2008R2, ASP.net, Java, ETL and AD (Active Directory)