SUMMARY:

• SQL server DBA with 8+ years of experienced of IT with administration, design, development, and implementation experienced using SQL Servers 2016, 2014, 2012, 2008.
• Experienced in SQL server 2016, 2014, 2012, 2008 on Windows 2012 r2, 2008 both in standalone as well as in Cluster.
• Experienced in always on availability groups setup.
• Strong experienced in installing / upgrading / patching, memory configuration and security management.
• Experience in SQL clustering on different version of windows Servers.
• Experienced in monitoring SQL server, capturing performance problem and improve performance by tuning databases.
• Proactively used tuning advisory, query optimization plan and query execution plan in order to address database locking, deadlocking and blocking issues.
• Experienced in replication and log - shipping strategy a part of disaster recovery.
• Experienced in security technical implementation guide (STIG) is a cybersecurity methodology for standardizing security protocols within servers.
• Experienced in supporting and troubleshooting huge DBs performance as well as security problem.
• Maintained SSRS/ SSIS report wizard.
• Expert in installing different software both in cluster and non-clustered environment.
• Experienced in security auditing and managing performance monitoring tools.
• Worked as an independently as well as in team-oriented environments.
• Excellent analytical and communication skills with 24/7 rotated support experience.

PROFESSIONAL EXPERIENCE:

Confidential, Alexandria, VA

SQL server administrator

Responsibility:

• Installed, configured and upgraded SQL Server 2016, 2014, 2012, 2008 in development, test and production environments.
• Used basic sharepoint site owner skills creating page adding custom lists, columns, calculated columns, lookup columns, calendars, announcements, permissions.
• Developed and maintained database backup and restore strategy.
• Experienced in disaster recovery through backup/restoration and point-in-time recovery options.
• Managed and maintained database security import DISA STIG files.
• Experienced in creating and maintaining high availability solutions including database mirroring, log shipping, replication, always on, and clustering.
• Generated Reports using SSRS (sql server reporting services) and deployment managed reports and managed reports security.
• Identified and addressed database performance issues and capacity planning issues.
• Experienced in security technical implementation guide (STIG) is a cybersecurity methodology for standardizing security protocols within servers.
• Managed logins and user security policy.
• Wrote stored procedure to audit SQL servers, establish and enforce security auditing mechanism, performance tuning and optimization.
• Experience in automation jobs for different database related activities including backup, monitoring database health, disk space and backup verification.
• Experienced in database capacity planning, maintenance planning, and SQL agent Jobs scheduling and troubleshooting.
• Assisted SQL developers to optimize SQL queries and stored procedures.
• Monitored databases for optimal performance through SQL profiler wait stats, DMV, DMF, activity monitor, extended events, error log, windows performance monitor.
• Data compression and shrink database as necessary to improve the performance.
• Used DBCC to checked physical and logical consistency of databases.

Confidential, MD

SQL Server Administrator

Responsibility:

• Involved in upgrading from SQL server 2008 to SQL server 2012 always on cluster.
• Worked on database user administration and granted required privileges to users.
• Tuned stored procedures and sql queries.
• Performed performance analysis using CPU, I/O and memory counters using performance monitors.
• Scheduled database maintenance tasks to improve the database performance.
• Involved in maintaining database with maximum database availability, resolve any database issues.
• Worked with tuning and configuration of production and development database servers.
• Created the stored procedures, views and scripts for application development.
• Experienced in DBCC commands to check physical & logical consistency of the databases.
• Experienced in using performance monitor/profiler to resolve deadlocks & long/slow running queries.
• Managed for securing sql server, user management, assigning permissions & roles.
• Hands on experienced of Microsoft share point 2007 and Microsoft sharepoint 2013.
• Used basic share point site owner skills creating pages adding custom lists, columns, calculated columns, lookup columns, calendars, announcements, permissions.
• Managed and maintained database security import DISA STIG files.
• Excellent experienced in operated independently as well as in team-oriented environments.

Confidential, Arlington, VA

SQL Server Database Administrator

Responsibility:

• Upgraded, installed and support SQL servers including production, test and developed servers.
• Installed and configured SQL server 2012, 2008, and 2005 on standalone machine as well as on cluster environment.
• Installed and reviewed SQL server patches as well as service packs.
• Designed and configured database, tables, indexes, store procedures, functions and triggers.
• Experienced in always on availability groups concepts.
• Troubleshot database status, performance, replication, log-shipping as well as various errors on production, development and UAT servers.
• Maintained SSRS/ SSIS report wizard.
• Maintained plan for backup and restore, performance tune up.
• Experienced in point-in-time restoring databases in production and development servers.
• Monitored SQL servers for performance ad-hoc and pro-actively.
• Designed and implemented T-SQL scripts and stored procedures and tune up them.
• Managed and maintained database security import DISA STIG files.
• Created documents for deployment and troubleshot issues for references.

Confidential, D.C.

SQL Server Database Administrator

Responsibility:

• Participated in upgrading/Patching SQL Server 2005 to SQL Server 2008 server.
• Maintained SSRS/ SSIS report wizard.
• Installed and configured the mssql fail over clustering for production servers.
• Experienced with SQL disaster recovery processes and documented the processes.
• Created the maintenance plan for database optimization and integrity checks.
• Experienced in monitoring\capturing sql server performance issue by using windows performance monitor\task manager \sql native monitor \sql profiler.
• Experienced with improving databases performance using execution plan, index tuning wizards and SQL profilers.
• Analyzed SQL server deadlocking, locking/blocking & troubleshoot the root of those issues.
• Experienced in securing the SQL servers assign the permissions to SQL server users.