SUMMARY:

• Motivated and ambitious Database Administrator with 9 years of experience in MS SQL Server 2016/2014/2012 R2/2012, SQL server 2008R2/2008, SQL server 2005 with advanced experience using SQL Server management Studio and Visual Studio combined with good team work abilities. Installed and configured SQL Server on both physical hardware and virtual machines in clustered and standalone systems. I can accomplish tasks with under minimal supervision and direction. Hard worker with a desire to use updated MS SQL Server skills in the field to assist with achieving goals and objectives.
• Expertise in Microsoft SQL Server 2016/2014/2012, 2008R2/2008 and 2005 Database Administration in Production, Development and QA environments with server installation, configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Experienced with High Availability and Disaster Recovery Technologies (SQLALWAYSON AG, Clustering, Mirroring and Log Shipping and various model of replication Technologies).
• Strong relational database concepts. Strong experience in the management and administration of SQL SERVER Instances and databases in Microsoft Azure.

COMPETENCIES

• Performing Capacity Planning
• Installing, Configuring & Upgrading Database Server
• Managing Data Integrity
• Managing Security
• Implementing & Managing Database High Availability
• Implementing Effective Backup Strategies for Disaster Recovery
• Database Performance Tuning & Query Optimization
• Team Building
• Project Coordination
• End User Training
• Process Improvements
• Communication
• Systems Analysis
• Troubleshooting & Problem Solving
• Documentation

TECHNICAL SKILLS:

RDBMS: MS - SQL Server 2016/2014/2012 /2008R2/2008/2005, MySQL, PostgreSQL.

Widows Server Operating System: Windows sever 2016, 2012, 2008R2, 2008 and 2003, Windows NT, Windows 9x and Linux.

Scripting Language: DOS & T-SQL.

ETL Tool: SSIS, SSRS, SSAS, Erwin.

Management Tools: SQL Server Configuration Manager, SQL Server Management Studio (SSMS).

SQL Server Technologies & Tools: Enterprise Manager, Management Studio, Visual Studio, SQL Server Profiler, Extended Events, DTS (ETL), Database Engine Tuning Advisor (DTA), SQL Server Activity monitor, Idera, Spotlight, Red Gate, SQL LiteSpeed, EPIINFO, ENA-SMART, SPSS, SharePoint.

Case Tools: MS Access, MS Excel, MS Outlook, MS Visio, MS Project.

Network Topologies: TCP/IP, DNS, IIS, WINS, DHCP, FTP, SNMP, SMTP. VMware, Oracle VM VirtualBox.

Excellent interpersonal, analytical and Written communication skills.

PROFESSIONAL EXPERIENCE:

Confidential, Arlington, VA

Database Administrator

Responsibilities:

• Installed, configured, upgraded and managed MSSQL server 2016, MSSQL server 2012R2/2012, MSSQL server 2008R2/2008.
• Applied Service Packs, patches, hot fixes and cumulative updates.
• Changed Management for patches and upgrades.
• Managed numerous databases in 24/7 environment on standalone and cluster servers.
• Provided support for Active Directory, assigned roles and permissions.
• Coordinated and collaborated with team members to ensure smooth connection to the databases.
• Performed database Backup and Recovery, restore operations, Error log monitoring and troubleshooting when required.
• Involved in Identification of SQL server poor performances using MS performance monitor, activity monitor, Extended Events and MS SQL trace tools.
• Performed Performance tuning in MSSQL server 2016, MSSQL 20012, MSSQL 2008R2/2008.
• Created and maintained exhaustive documentations on server and database configurations, maintenance plans, security policies.
• Administered SQL Server Security by Creating User Logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Handled SQL server Job creation/Automation of DBA tasks using SQL server agent.
• Created SQL server alerts to notify potential failures and implemented actions accordingly.
• Recommended changes for queries which may affect the optimum databases performances.
• Implemented database failover techniques such as Mirroring, Log shipping and Replication.
• Developed and implemented backup strategies and DR plans for large operational databases which ensured better performance and HA.
• Configured and assured the smooth operation of HA options like: Log shipping, database mirroring and AAG.
• Involved in set up of Clustering and server consolidation.
• Configured SQL server agent jobs for daily maintenance tasks like: backups and restores, shrink database, update statistics, rebuild and reorganize indexes, maintenance cleanup, etc.
• Devised superior performance tuning plans by proactively ensuring bottlenecks are identified and eliminated.
• Rebuild, reorganize Index and update statistics at regular intervals for superior performance.
• Scheduled jobs to automate different tasks such as monitoring database health, disk space, job alerts, index monitoring, stats monitoring.
• Configured and implemented database mail.
• Handled data migration from various sources.
• Handled multiple SQL Instances on cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Performed installation of SQL Server enterprise 2012 SP1 CU 5 64bit version on Windows 2012 SP1 Clusters (HP Servers in Enterprise Data Centers).
• Created and configured SQL Server Platform as a Service instance(s) in Microsoft Azure.
• Created and configured SQL Infrastructure as a Service VM in Microsoft Azure.
• Configured a Hybrid High Availability solution to Azure from our on-premise environment to replace an existing on-premise Disaster Recovery solution.
• Identified SQL databases that could be migrated to Azure and work with necessary parties to migrate and test.

Environment:

• Database: MS SQL server 2016, MS SQL server 2012R2/2012, MS SQL 2008R2/MS SQL 2008 Enterprise, MS SQL 2005, Access, Excel, Basic knowledge on MYSQL, MS SharePoint.
• Operating System: Windows Enterprise Server 2016, Windows Server 2012R2/2012, Windows Server 2008R2, Windows Server 2008.
• Software: ER data modeling.
• Performance tools: MS SQL profiler, database engine tuning advisor and Activity Monitor.
• Application tools: .NET, Microsoft Visio, Idera, Spotlight, IIS, SFTP.
• Virtual machine: VMWare server virtualization.

Confidential

Database administrator

Responsibilities:

• Configured performance tuning and optimization in SQL server 2008R2, SQL server 2008, MSSQL server 2005.
• Performed all aspects of data administration including backup, replication and recovery.
• Designed and implemented disaster recovery options (Mirroring, Log shipping, Replication, Backup and Restore).
• Created new database users, controlled and monitored user access privileges to the database maintaining system security.
• Created alerts and notification for system errors or success.
• Imported and exported data to and from the SQL server databases.
• Upgraded multiple databases required for different environments.
• Handled Transactional Replication from Central Server to Reporting Server Database.
• Configured SQL server Reporting service (SSRS), developing Reports using SSRS.
• Handled Data Extraction/Transformation using SQL Server Integration Services (SSIS) package.
• Involved in set up of Clustering.

Environment:

• Database: MS SQL 2008R2, MS SQL 2008, MS SQL server 2005, Access.
• Operating System: Windows 2003, Windows 2008, Window 7, Windows XP.
• Other Soft Wares: EPIINFO, ENA-SMART, SPSS.
• Performance Tools: MS SQL profiler, database engine tuning advisor.