Profiles from Search

Profile photo

Omar Abdallah

3rdPremium Subscriber

Previous positions

  • Associate Database Administrator at We Energies
  • SAP Business Analytics IT-Intern at We-Energies

Education

University of Wisconsin-Milwaukee, Bachelor of Business Administration – BBA, Management Information Systems

273

Background

Summary

Experienced Database Administrator with a demonstrated history of working in the utilities industry. Skilled in SQL Server and Oracle.Strong information technology professional graduated from UW-Milwaukee.

Experience

  • Database Administrator

    WEC Energy Group

    May 2015 – Present(4 years 5 months)Pewaukee, Wisconsin

    -Installed and configured SQL Server 2005-SQL Server 2016 with backup jobs, database mail and configuration options. -Upgraded SQL Server with latest services packs -Migrated SQL Server databases from 2008 & R2 to SQL Server 2016 -Created, administered & maintained SQL Server Databases on Production, Test and Stage for various groups and ensured the availability of the database servers on a 24/7 on-call rotation. -Installed and configured SQL Server 2012-2016 Clusters -Installed and configured SQL Server HADR solutions. -Supported Customer Service databases that were bigger then 2TB. -Installed and configured Oracle 12c -Leading technical projects from start to finish while working within organizational change management and project management guidelines -Work with and educate our dev team to make good schema design choices and write efficient queries

  • Associate Database Administrator

    We Energies

    December 2013 – June 2015(1 year 6 months)

    -Achieved 99.9% uptime on all SQL Servers & Oracle databases -Recommend and implement database security policies that are consistent with security guidelines and best practices. -Provide DBA support and technical expertise for multiple applications in development, test, QA and production – SQL Server 2005-2016 & Oracle 9i, 10g, 11g and 12c environments. -Develop strategies in migration SQL 2005 servers to 2008 SQL Servers. -Provide 24/7 support as sole SQL Server DBA -Managed SQL Server -based Applications -Experienced in using SQL Server Profiler and SQL Server Agent. -Experienced in using Oracle Enterprise Manager 11g and 12c.

  • SAP Business Analytics IT-Intern

    We-Energies

    June 2012 – January 2014(1 year 7 months)greater milwaukee area

    Develop web content for We-Energies intranet using HTML, Java and SAP tools. Develop Web Intelegance Reports using SAP BI Platform. Develop Dashboards Using SAP Business Objects tools. Develop and Design queries for different business requirements using BEx Query Designer. Develop excellent communication and interpersonal skills in the corporate environment.

Education

Languages

  • Punjabi

  • English

Skills & Expertise

  • Query Optimization
  • Oracle Enterprise Manager
  • Business Analysis
  • Visual Basic
  • SQL Server Integration Services (SSIS)
  • Business Requirements
  • Business Administration
  • Data Analysis
  • Project Management
  • Change Management
  • C#
  • Business Analytics
  • Databases
  • Sybase
  • Web Analytics
  • English
  • Web Development
  • Data Security
  • Data Mining
  • Visio
  • HADR
  • SQL Server Reporting Services (SSRS)
  • Query Designer
  • Data Integrity
  • Database Security
  • Customer Service
  • Database Servers
  • Query Writing
  • Skilled Multi-tasker
  • Troubleshooting
  • Written Communication
  • Problem Solving
  • Database Administration
  • Information Technology
  • HTML
  • Microsoft SQL Server
  • Web Design
  • Oracle
  • SQL
  • Business Objects