MOHAMMED ALDOORI

*** *** ****** **** ******: 615-***-****

La Vergne, TN 37086 add5ni@r.postjobfree.com

Senior SQL DBA Professional

Hands on experienced in MS SQL Server Installations, Performance Tuning, Backup and Recovery, Query Optimization, SQL Clustering and Replications and Security of database Servers. Worked independently as well as in team-oriented environments. Establishing guidelines for a defined database architecture and database builds. Experience in supporting huge SQL Server databases troubleshooting problems

Areas of Expertise

Network Infrastructure

T-SQL Coding

Mobil Banking (IVR)

VB.net

DB Microsoft Azure

Window Server 2014 -2016

Active Directory

Inventory Management (IMS)

Oracle-SQL

PC and Software Builds

Powershell scripting

Problem Resolution

Systems Administration

RMAN Backup/Recovery

Kapwere Configuration.

SQL DBA

Professional Experience

INSEQUNCE-Smyrna, TN

IT-DBA- Field Service. 4/2018 - Present

Installed and configured a SQL server (2008 R2, 2012, 2014, 2016).

Configured and supported replication and log shipping.

Maintained, migrated and troubleshooting of database mirroring.

Upgrade and migrating Database to newer SQL version.

Installed and configured SSRS (SQL Server Reporting Services).

Performed day to day DBA activities such as monitoring SQL Server health, job status, addressing user requirements.

Troubleshooting critical performance, space, availability and various issues using TSQL/Powershell.

Developed Disaster Recovery plans using Log Shipping, Database Mirroring, Restored backups regularly for verification

Experience with handling Active Directory data using SQL Server.

Security Administration (adding logins, users, granting permissions thru roles, managing schemas) on the SQL Server

HP, La Vergne, TN 11/2013 – 4/2018

SQL DBA on HP Contract

Responsibilities Performed server installation and configurations for SQL Server 2008 and

SQL Server 2012.

Performed installations of SQL Server Service Packs.

Upgraded databases from SQL Server 2008 to SQL Server 2012.

involved in capacity planning, sizing and database growth projections.

Scheduled Full and Transactional log backups for the user created and system databases

in the production environment using the Database Maintenance Plan Wizard.

Setup backup and restoration jobs for Production, Development and QA environments

Created transactional replication for the reporting applications.

Implemented disaster recovery solution at the remote site for the production databases using Log Shipping.

Provide expert technical assistance for a high transaction PC, software, printer receiving, test, build, QA, and shipping operation for HP.

Ensure that the assembly line process is working smoothly by resolving a broad range of technical issues that would otherwise impact the shipping schedule of integrated HP hardware and software systems.

Design labels for each new product family that includes assigning a ZPL code, creating a new storage procedure, deploying the unit in a test environment and installing it in a live environment.

Capitalize on root cause analysis skills to promptly identify and remediate technical issues.

Create and run database queries during the production process to avoid any error before shipping the unit.

IDB BANK, Baghdad Iraq 6/2011 -8/2013

IT Team Leader

Successfully manage and implement the HR Personnel and Payroll System for multiple branches and used certification gained in the application to extend the services provided to include secure import of sensitive financial information, deduction, tax, and overtime features.

Led the installation of the IVR Project for Mobil Banking by building the applications for voice messages, menu options, and seamless integration with the database within required budget and timeline.

Oversaw the installation of RAC Servers and Oracle databases in the Data Center to provide secure user access and privileges for each branch.

Provide for improved backup and data recovery by configuring the ARMAN schedules.

Install HP server Win server 2008

Technical Skills

Database: T-SQL, SQL-DBA, Oracle-SQL,

Networking: CISCO Networking,

Server: Windows Server 2014, 2016,

HP Server: PRISM Technical for commercial testing server

Project Management: Visio, MS Project

Education and Certification

B.S. in Computer Science

Contact this candidate