SUMMARY:

• An experienced Certified Microsoft SQL Server Database Administrator wif SQL/TSQL skills having about 6 years, who is dedicated to keep up - to-date industry noledge looking for SQL Server Database Administrator/DBA job.
• Dedicated and Responsive professional has experience in managing production, test/UAT, development environment, requiring minimum or no supervision and be productive from teh first day of teh job.
• Professional experience entails configuring and managing Databases and Database Servers using SQL Server 2016, 2014, 2016, 2012, and 2008 R2 and Operating System Windows Server 2012, and 2008 R2 in physical, VM and cloud Environment.

TECHNICAL SKILLS:

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.

Database Management:

• Strong noledge and working experiences as Database Administrator of MS SQL Server (SQL Server 2016, 2014, 2016, 2012, and 2008 R2)
• Working Experience in managing databases/instances in Dev, Test and production Environment
• Strong work experience wif HA (High Availability) Solutions: AlwaysOn, SQL Server Replication, Log shipping, Mirroring, and Clustering
• Performance tuning, Backup/recovery, Query Optimization, Database and Column Level Encryption, and Security Management.
• Maintain Management Plan, Job Set up and monitor job activities.

Programming and Testing:

• SQL, T-SQL, Functions, Store Procedures, Trigger

Reporting Service:

• SQL Server Reporting Services (SSRS), visual Studio - Installation, Configuration, and Management
• Developed, Deployed, and Managed Reports

Integration Service:

• SQL Server Integration Services (SSIS),DTS, BCP - Installation, Configuration, and Manage.

Operating Systems:

• Worked on Operating Systems like Windows Server 2003R2,2008 R2 and Windows Server 2012 including installation, and configurations

PROFESSIONAL EXPERIENCE:

Confidential, Suitland, MD

SQL Server Database Administrator

Responsibilities:

• Cloud/Azure: Migrated on premises databases and Legacy databases to Azure, and setup production, development and test environment on Azure
• Managed Database Servers in Development, Test, Production environment
• Installed, Configured, and Managed SQL Server 2008 R2, 2012, 2014 in Development, Test, and Production environment

Database High Availability:

• 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

Report Development:

• Installed, Configured, and administered SQL Server Reporting Services (SSRS)

Database Upgraded and Migrate (development, testing and production environment):

• Upgraded/Migrated SQL Server SQL Server 2012/2008 R2 and 2014 and 2016
• Migrated MS Access Database 2000, 2003 into SQL Server 2012

Database Monitoring/Performance Tuning/Troubleshooting:

• 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

Database Programming:

• 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 Procedure
• Export & Import data from/to databases as My-SQL, and Access to/from SQL Server
• Setup jobs from SSIS Packages

Backup/Recovery:

• Strong noledge and working experience in Database Backup and Disaster Recovery
• Experienced wif Point-in-Time Recovery
• Restored Database from backups

Environment: SQL Server 2012, 2014, 2016, IIS 7.5, 8.5, Windows Server 2008 R2, 2012, ASP, ASP.net, Java, ETL

Confidential, Woodbridge, VA

SQL DBA/Database Administrator

Responsibilities:

• Installed, Configured, and Managed SQL Server 2012, and 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
• Configured and Maintained Log Shipping as Standby database for Reporting Purposes
• 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 instances
• 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 multiple Data Modeling projects for different applications
• Developed and Managed Report in SSRS (SQL Server Reporting Services) including managing securities
• Setup automated jobs for different purposes including backup, monitoring database health, disk space, backup verification, 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 2012, 2008R2, IIS Server 6.5, 7.5, Windows Server 2003R2, 2008R2, ASP.net, ETL