Database Administrator Manager
INMOBILES
Total years of experience :13 years, 9 Months
• Directed the Database team, and administered all 50 production servers running MS SQL.
• Implemented Database mirroring (Log Shipping), Replication for High Availability (Peer to peer), Merge Replication, and Transactional Replication.
• Built the Database mirroring in High Performance and High Availability mode and tracked issues with witness servers. (Created the Failover Cluster and Always ON Availability Groups with Witnesses, on SQL Servers joined to the same domain controller and to different domain controllers “Cross Domain” using MS SQL 2016 and MS SQL 2017).
• Improved Performance of the High Availability Group in different subnet by implementing the Distributed Availability Groups.
• Added appropriate DNSs, domain users in Active Directory, quorums and grant them appropriate permission for the failover Cluster.
• Coordinated with the IT Manager in ordering the NAS or SAN storage, disks, RAID choices, and planned the location of data, index, and Transaction log files on the disks.
• Enhanced the quality and speed of the services by tuning, and optimizing of Stored Procedures to meet the best execution plan. Boosted the databases response time by adding appropriate indexes.
• Created Database Maintenance Plans which covers Database Integrity Checks, Updating Database Statistics Rebuilding indexes, jobs execution, Backups and Cleanups.
• Managed schema objects such as tables, views, indexes, procedures, triggers and maintained Referential Integrity depending on user requirements and converted them into technical specifications.
• Redesigned the old Application’s Databases to meet the new requirements, the best performance and fastest response time of the application using the minimum resources.
• Developed reports to track the evolution of the products with SQL reporting services.
• Succeeded in building databases architectures than handles 8000 TPS on a single server. Maximized the throughput of the old servers by updating the databases Structure.
• Designed the Database structure based on the story board of the new applications. Analyzed the user behavior to expand the services features. Built the data Flow for every new application or redesigned application.
• Programed a customized Alarm System on MS SQL to track the Database system, catch every suspicious query and sends emails to the Database Department Team.
• Engineered a system that blocks any unappropriated attend of penetrating the live platform. Secured the SQL Server Environment with Microsoft best practices.
• Trained the developers for the best SQL server usage and formalized the way of writing the stored Procedures. (Naming convention, stored procedures best Practices). And supervised the Backend Team while writing the Stored Procedures for their APIs.
• Built a data warehouse and implemented the ETL jobs using MS SQL Analysis Services.
• Developed the data Encryption/Decryption by creating Master Keys, Certificates and Symmetric Keys to Encrypt backups, and columns with important or critical data.
• Upgraded the Production database Servers to MS SQL 2016.
• Configured MySQL enterprise on redhead servers. Migrated Databases from MS SQL server to MySQL and designed the clustering between several MySQL databases and routers for a high availability environment.
• Redesigned the new Numberbook Social databases structure (mobile application for numbers search) and migrated billions of data records from the old to the new one. Tested the Result Quality meeting the targeted response time.
• Performed the Database administration for the SQL Server database environments.
• Upgraded the Production Database Servers from SQL Server 2000 or 2008 R2 to SQL Server 2012.
• Reduced CPU usage and I/Ops on the live servers by tuning the live queries.
• Created the backup and restore strategy and their scheduling for production and development environment. Implemented a job to backup all SQL authentication users with their hashed passwords.
• Organized the user logins with appropriate roles, enabled and disabled the logins, monitored the user accounts, created of groups, granted the privileges to users and groups. Maintained all databases permission and security.
• Audited specific actions on specific databases using MS SQL Audit Logs.
• Introduced the linked Server for easy communication between several MS SQL Servers.
• Prevented dead locks by updating the scheduler or the execution order of some SQL jobs. Monitored the Performance of different production servers.
• Diagnosed and troubleshoot the errors that every developer faced while working on the live or test environment of MS SQL Servers. Updated Stored Procedures to meet the best execution plan and created the best indexes.
• Detected slow queries using SQL Profiler caused by missing indexes or miss use of the built in functions, triggers, cursors, joins… and updated them to reach best response time.
Environment: Microsoft SQL Server 2017/2016/2014/2012/2008R2/2005/2000,
Windows 2016/2012/2008R2/2003 enterprise server, SQL Profiler, Performance Monitor
Founded applications for Microsoft Lync Server 2012, using Lync SDK and Lync UCMA, Lync UCWA, Windows PowerShell and Lync Web service using visual studio 2010/2012.
Implemented Web services and Workflows for Microsoft Forefront Identity Manager based on visual studio 2010/2012, built its data warehouse using System Center Service Manager 2010 (SCSM) / XML Files, created the store procedures, functions and reports using SQL reporting services.
Launched Silverlight applications, web services, windows applications in C# and VB.net using visual studio 2012, MS SQL 2012, Orchestrator 2012 and Windows PowerShell.
Customized Microsoft SharePoint 2012 farms, sites, sub-sites, document management libraries, profile synchronization, web parts, and master pages.
Integrated custom workflows using SharePoint Designer 2012 and active directory groups.
Developing Add-Ins for Microsoft Outlook 2010/2012 using visual studio 2012.
Forged a document library based on Microsoft SharePoint 2010 to organize the researches and their documents, having a unique permission for each group of person. Confirmation and notification workflows were written using SharePoint Designer 2010.
PRO-DELTA, USA from May 2011 - June 2011
Developed a windows application in VB.net and Microsoft Access, for a company that buys and sells used cars, the program gets all the information and fees details, calculates the benefit and prints deferent reports for available cars, sold cars, banking account operations, daily log, etc…
CARGOMASTER LINE, SARL from February 2011 - March 2011
Developed a windows application in VB.net and SQL server 2008 that collects all information about a shipment from different tables, and converts some to codes then saves all data in a database and an XML file in the format specified by the government.
(Supervisor Mr. Jacques Abouzeid Tel: +961-3-444688)
PROCOMIX, SARL from July 2009 - December 2009
Developed a SharePoint 2007 Web Part on Windows Server, which creates a User in Active
Directory and a Mailbox on a certain Domain.
(Supervisor Mr. Michel Kattouah Tel: +961-3-235203)
Masters of Science in Computer Science, Database Systems Graduated University, UNIVERSITÉ SAINT-ESPRIT KASLIK in 2012-2013 Studies focused on databases, data warehousing and data mining.
Bachelor in Computer Science Graduated University, UNIVERSITÉ SAINT-ESPRIT KASLIK in 2009-2010 Studies focused on languages theories, software development and project management.
Graduated School, COLLЀGE DES FRЀRES MONT LA SALLE AIN-SAADÉ in 2004-2005.