Database Administrator Server

Nasir Gul Nasir

Rockville, MD 202-***-**** ***********@*****.***,Skype: nasirjan52

Summary

* **** ***** ****** ********** working with databases, preferably Microsoft SQL Server Databases 2008 / 2012 /2014/ 2017/2019, specially data migration from SQL Server 2012 to SQL Server 2017 and SQL Server 2019, performance tuning and database security . Effectively identify, manage and mitigate risks within the scope of assigned job responsibilities

Skills Summary

●SQL server Installation, upgrading, migration, Apply patch.

●SQL server Security,SQL server Backup & Restore

●SQL server Performance tuning,SQL server troubleshooting

●Monitoring

●Data migration from 2012 to 2017/2019

●Data analyzing

●TSQL

●Agile Methodology

●Standalone Database High availability (Log shipping, Mirroring)

●Object level High availability (Transaction Replication)

●Group of Database High availability ( Always On Availability Groups)

●

Education

Bachelor of Science, Kabul University, Afghanistan, 2003-2007

Certification & Training

● Microsoft Database Administration (MCSA)

● Training on Database Performance tuning

● Training on Database High availability and SSIS

● Training Certificate in Information Systems

Professional Experience

nfosys LTD June 2022-Present

Technology Lead (Database Administrator)

●Managing team of 8 SQL Server DBAs

●Monitoring the databases and optimizing database performance and use of resources.

●Maintain database dictionaries and support tools

●Develop and maintain accurate system documentation.

●Develop processes for optimizing database security.

●Perform disaster recovery, performance analysis and tuning, index maintenance, and monitoring of data.

●Diagnose and troubleshoot database errors.

●Maintaining availability and integrity of databases.

●Monitoring and managing database backups and, restorations, big loads to databasesConfigure and maintain database servers and processes

●Data migration from SQL server 2012 to SQL server 2017 and SQL server 2019

●Monitor system's health and performance

●Ensure high levels of performance, availability, sustainability and security

●Analyze, solve, and correct issues in real time

●Provide 24x7 support for critical production systems

●Perform scheduled maintenance and support release deployment activities after hours

●Installation, Configuration, Administration, Upgrade SQL Server in different versions.

●Strong knowledge of and experience with index, and statistic, and execution plan management

●Queue management to ensure

●Appling SQL server security patch

Infosys LTD Sep 2019- Jun 2022

Technology Analyst (Database Administrator)

●Manage SQL Server databases on-prim and azure SQL servers

●Configure and maintain database servers and processes

●Data migration from SQL server 2012 to SQL server 2017 and SQL server 2019

●Monitor system's health and performance

●Ensure high levels of performance, availability, sustainability and security

●Analyze, solve, and correct issues in real time

●Provide suggestions for solutions

●Assist developers with query tuning and schema refinement

●Provide 24x7 support for critical production systems

●Perform scheduled maintenance and support release deployment activities after hours

●Installation, Configuration, Administration, Upgrade SQL Server in different versions.

●Strong knowledge of and experience with index, and statistic, and execution plan management

●Queue management to ensure

RLS Rules of law and stabilization Feb 2015- Sep-2019

Database Administrator

●Installation, Configuration, Administration, Upgrade SQL Server in different versions.

●Strong knowledge of and experience with index, and statistic, and execution plan management

●Experience in troubleshooting and resolving all types of database issues (experience troubleshooting replication, log shipping issues, Always on issues)

●Follow Microsoft best practices for configuring and operating SQL Server

●Properly maintain Backup and Recovery methods

●Support SQL Database Operational of Developers and Business users

●Configured and maintain High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server.

●Implementing automation of reoccurring DBA tasks.

●Good communication and documentation skills for processes and procedures

●Failover Clustering and SQL Server AlwaysOn configuration and support

●Knowledgeable of Performance tuning at the server and SQL Server database and Query level

●Working with Idera SQL Diagnostic monitor tool

●Provide database production support of critical systems including backup and recovery, database object creation and administration, performance tuning of queries and data structures.

Main Street Technologies March 2014- Jan 2015

SQL DBA

●Work experience and strong knowledge in disaster recovery

●Rebuild Servers (Restore & Recovered from tape/CD backup) from backup

Configured Log Shipping from Production to Standby Server (Running as Reporting Server)

●Created Backup strategy for production and development environment.

●Developed Database Maintenance Plan for rebuild and reorganized indexes.

●Monitor and troubleshooting connectivity issues Permissions, etc. with custom applications and SQL Server Error Log, space usage.

●Run DBCC statements to check physical and logical consistency of the database.

●Export & Import data from Oracle, MySQL, and Access Database including flat files like text, excel, and CSV files into SQL Server databases

●Respond to service ticket requests and troubleshoot issues as needed

●Perform routine monitoring, administration and maintenance of the MS SQL Server databases within the hosted environments

●Provide after-hours support as needed

●Experience with data analysis, design, and development and with the deployment of database objects

●Find Query problem by reading and acting on SQL Server execution plans

●Supporting a mission-critical database environment on a 24x7 basis

Contact this candidate