- MS SQL server /MySQL/PHP/HTML/CSS/WordPress/SCCM
Hi, I am Kareem from Egypt,
An experienced IT professional with database administration skills Oracle, MS SQL, MYSQL, and PostgreSQL.
15+ years of expertise in Database Development and Administration, Database management,
Relational Database, and Database Programming (Functions, Views, Stored procedures), T-SQL, SSRS,
SSIS, user-defined constraints, replication, setup, and maintenance.
I worked with SQL Server, MySQL, PostgreSQL, PHP, HTML, CSS, WordPress, and SCCM.
Experience in OLTP and OLAP environments, Experience installing MS SQL SERVER with hotfix and
service packs, Strong understanding of RDBMS concepts as well as Data Modeling Concepts
- Five years as a Senior SQL Developer.
- 10+ years as a Senior SQL DBA.
- Expertise in Implementation, Administration, Database Design, Development, Performance Analysis,
Tuning, and Production Support for Large (VLDB) and Complex Databases.
- Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS Packages.
- Scripting (T-SQL).
- Performance optimization:
o Server performance optimization (settings\configurations\indexes)
o Code performance optimization (procedures\views\functions)
- Monitoring, Troubleshooting and recovering
- Planning and implementation High Availability solutions (Log Shipping, Mirroring, AlwaysON AG,
Clustering)
- Experience in Replication – Snapshot and Transactional and extensive knowledge in Merge
Replication and upgrading.
- SSRS (optimization reports, writing reports)
- SSIS (writing packages, troubleshooting)
- Managed 100 instances, had to deal with VLDBs (100GB).
2- Microsoft system center
• SCCM (Administrator/Implementation/Patch Managiement/Application deployment…etc.)
• implementing Service manager
• SCSM custom reports creation
• SCCM Asset Management
• Script Creation.
• OS Image Creation / Task Sequence Creation
• User Profile Migration (USMT)
• Deployments and Automated Deployment