Database Administrator Sql Server

Edwar Bishara

Senior MSSQL Database Administrator

******@***.*** -- Bend, Oregon -- 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 installation on a Cluster server.

Employment

Company: SQLCARE, INC

Position: Senior SQL Database Administrator From: 11/2002 To: Current

Designed a monitoring software via TSQL to monitor clients SQL Server’s activity, the application includes email alerts and reports:

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 application provided alerts and reports; such as daily job status report, blocking info, long running queries, etc.

oSQL Server version proficiency: SQL 2000, 2005, 2008, 2012, 2014, 2016, 2017, 2019, 2022.

oWorked with Auth0, ticket manager, and other software the client has.

Performed the following:

oSetup Log Shipping and Replication (Always On, Transactional)

oSetup SQL on a Cluster server, SSIS, SSRS

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

oMigrate MS Access to SQL, and SQL to Snowflakes.

oMigration project Oracle, MySQL, Postgres and DB2, Azure

oAzure Migration app and connection to MMS, Azure Data Studio.

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. Identifying long running queries, and blocking.

oUsing Excel and Access for users to view data.

oPerformance and tunning, Tempdb enhancements, 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.

Company: Independent Contractor – Certified Microsoft SQL Trainer

Position: Taught MSSQL as a contractor

From: 11/1986 To: 2002

Taught MSSQL courses which included; 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 Providers.

c.Assisted on SQL Server clustering documentation with Microsoft.

d.Required 100% travelling to different Microsoft Training Centers Providers.

Certifications:

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

Education

Bachelor Degree of Science from Western Washington University (WWU) Bellingham, WA.

Graduated with a Bachelor of Science Degree in Engineering Technology. 2 years at ISU Pocatello Idaho. And Graduated High School from Poky High Pocatello Idaho.

Contact this candidate