Database Administrator Sql Server

Edwar Bishara

Senior MSSQL Database Administrator

******@***.***

Bend, OR

626-***-****

Highlights

MSSQL Database Administrator proficient on all aspects of SQL server:

Managed and coordinated Migration Plan, for SQL Cluster Installation/upgrade.

SQL Performance Tuning and Optimization

Setup Replication (AlwaysOn) and Log Shipping, SSIS and SSRS

DB Maintenance Backup and Monitoring

SQL DB Design, TSQL, SQL Security

Azure Migration, ETL Data transfer using BCP and other methods.

Taught MSSQL courses for Microsoft as a consultant for MS Training centers.

Windows NT comprised of:

Installing Windows Server, Cluster, DHCP, IIS, Hyper-V, DNS, Active Directory, TCP\IP Settings, firewall setting, security and SQL on a Cluster server.

Executive Role:

Managed employees (DBAs) on all MSSQL Tasks.

Supervised and planed all SQL migrations, updates, and all other aspects of MSSQL.

Certifications:

MCSE Microsoft Certified System Engineer, MCT Microsoft Certified Trainer, MCP Microsoft Certified Specialist, MCDBA Microsoft Certified Database Administrator – expired 2021.

Experience

SQLCARE, INC 11/2002 – Current - Senior SQL Database Administrator

Designed a monitoring system via TSQL with email alerts and reporting:

oMonitor SQLServer, Performance CPU, IO, blocking, long running queries, job failure, jobs running over an hour, errors in the error logs, and other aspects of SQL monitoring.

oMonitoring system provided alerts and reports; such as daily job status report, blocking info, long running queries, etc.

Performed the following:

oManage and supervise Employees daily tasks.

oSetup Log Shipping and Replication (Always On, Transactional)

oSetup SQL on a Cluster server

oDatabase backup plan, maintenance plan (reindex, update statistics).

oMigrate MS Access to SQL, and SQL to Snowflakes.

oMigration project from Oracle, MySQL, Postgres and DB2 to/from SQL Server.

oAzure Migration and connection to MMS, Azure Data Studio, Azure migration application.

oUpgrade SQL server, migrate SQL databases, logins, DB mail profile, including SSRS, SSIS, SQL Jobs, Linked Servers.

oDatabase Recovery; transaction logs files and MDF files.

oETL using Linked server, access data from different sources that includes MSAccess and Oracle. And BCP to transfer data.

oVia SQL DMV tables, monitor and retrieve informational data about SQL server, for monitoring, reporting and performance. Identifying long running queries, and queries that are causing blocking.

oUsing Excel and Access for users to view data.

oPerformance and tunning, expanding Tempdb on multiple drives, index assessments, Triggers, TSQL queries, Stored Procedures.

oAudit: Security issues/report, user access, Orphaned users

oPowerShell to run script to update and configure multiple SQL servers.

Prior SQL Work and Training

Consulting and training on Microsoft SQLServer products. Provided Training on SQLServer courses which include; administration courses, implementation and the Tuning/Optimization MS courses.

Highlights of my experiences:

a.Trained internal Microsoft employees on MSSQL, internationally and domestically.

b.Taught MS courses at Microsoft Training Centers.

c.Assisted on SQL Server clustering documentation with Microsoft.

d.Setup SQL replication, replace Mirroring replication with Always-On.

e.Recovered Database crashes.

f.SQL Database upgrade.

Education

Graduated from Western Washington University with a BS in Computer Engineering Technology and a miner in accounting.

Contact this candidate