Omer Abd elazeem Osman

Sr. SQL DBA Data Engineer

About me

Nationality: Sudanese

Birth Date: 09-03-1979

Marital Status: Married

Professional Experience

Address

Taif Saudi Arabia

009***********

adxnwr@r.postjobfree.com

Skills and Knowledge

Sr. Data Engineer at Taif University

Jan 2018 – Present (5 Years and 5 Month)

Key Responsibilities:

• Configure and maintain database servers and processes Monitor system's health and performance Creating,

• maintaining database objects like Indexes, Functions, views, Triggers, constraints.

• Performance tuning and query optimization including updating statistics, rebuilding and re-organizing

indexes. Create and manage multiple databases and

assist in capacity planning.

• Maintain data integrity and security (manage roles and permissions of database users). Use tools like SQL Profiler for database tuning. Generate traces, execution plans, identify performance issues,

• deadlocks/contention and resolve them. Develop

strategies and implement solutions for managing back- ups, restoration Experience in SQL Server Clustering and HA technologies including Always On availability groups mirroring, log shipping, failover cluster.

• Configure the ETL packages, Cubes in Jobs and

Scheduling the Jobs Using SQL Server .

Debugging and troubleshooting the packages.

• Implemented incremental Load for many SSIS packages. Experienced in Error handling, Debugging, error logging for production support in SSIS.

• Experienced in Extracting, Transforming and Loading ETL data from Excel, Flat file, Oracle to MS SQL

• Strong experience in building intuitive visualizations using Qlik Sense and PowerBI on top of

structured/unstructured data

• Manage BI Access & Distribution (Workspaces, Apps)

Strong knowledge of PL/T-SQL.

MS SQL Server

Created complex stored

Procedures, Triggers, and other

SQL Joins and Statements for

Applications by using T-SQL

Have exposure of BI tools like

Qlik Sense and Microsoft Power

BI ...

Architect Data warehouses and

Developing Integration packages

for ETL operations using SSIS.

Created complex stored

Procedures, Triggers, and other

SQL Joins and Statements for

Applications by using Sql and

T-SQL

Should have good business

communication

Good experience in data

modeling and metadata services.

Should have good business

communication

SUMMARY

Over 16 Years of IT experience working, SQL Server DBA, System Performance Monitoring and Tuning, SQL Server Clustering and HA technologies, Architect Data warehouses and Developing Integration packages for ETL operations using SSIS. Creating Dashboards using (Qlik sense & power BI) Education and Certificates

Master's degree in Computer Information Systems

(Neelain University - Sudan December - 2012).

Bachelor of Computer Science (Honor- Degree) Faculty of Computer Science and information Technology graduate

(Sudan University of Science and Technology 2006) . Senior Sql Database Administrator &SQL Developer at Glory System Co. (Ras Tanura - Saudi Arabia)

March 2013 – 2018 (4 Years and 10 Month)

Glory Systems is one of the leading global providers of complete IT and business solutions and Consultation and implementation for Total (Data Warehouse Management, Human Resource and Payroll System, and Computer’s Hardware.).

Key Responsibilities:

Perform day-to-day operations for all SQL Server databases, including monitoring and maintenance, problem investigation and resolution, backup creation and maintenance, database optimization and

Develop and review complex SQL, T-SQL scripts, stored procedures for various reporting and data development projects

Assist with sourcing and implementing a Master Data Management system

Assist developers with complex query tuning and schema refinement. Center of Computer and Information Technology (University of Holy Quran -Sudan) April 2008

Key Responsibilities:

Programming with VB & C# .net

System administrator

Develop Backup & Restore scripts for SQL Server as needed

Responsible for General Database Administration and Performance.

Trouble shooting Problems by using SQL server profiler.

Updating with latest service packs and security patches.

Computer Maintenance (Software & Hard ware)

Contact this candidate