Hassan E'sa

• Participate in Architecture /Database Design Meetings – Business Requirement gathering/Designing. • Handling multiple NPT projects SQL 2008 to SQL 2014/2016. • Participate in discussion with Business team in getting the requirements. • Migrate/Upgrade SQL Server infrastructure to SQL 2016, planning, design, testing, deployment. • Responsible for fine-tuning & fast performance of those servers, fine tuning stored Procedures & Queries. • Manage and support team members for requests with Integration Services (SSIS) or Reporting Services (SSRS) and other data ETL tools. • Deploy Lower lane changes and on Production using change requests. • Apply Hot Fixes, Patches, Cumulative Updates, Service Pack, Service Pack), Upgrades • Proactively and reactively resolve database performance and capacity issues, including managing indexes, SQL trace data, audits, and alerting • Automate routine tasks, alert responses using PowerShell, SQL, .NET, or other tools • Analyze query execution plans and advise developers on best practices for database code. • Manage and support team members for requests with Integration Services (SSIS) or Reporting Services (SSRS) and other data ETL tools • Building the Servers from Scratch using Standard Best practices. • Responsible for deployment of SQL Server High Availability - using database Mirroring / Replication, Always ON based on the Tier level of the application and requirements. • Responsible for monitoring the Servers, Database Backups, Capacity Planning. • Remediated ESM security violations. • Involved in patching activities. • As part of the projects worked with Network, storage and Application teams and provided best design inputs for SQL server. • Worked on Annual Disaster Recover Test for multiple applications based on the data center. • Worked on complicated DMZ projects with multiple upstream \ Downstream Applications which Involves configuring IPsec rules and E’connects requests. • Part of On-Call rotation.

• Participate in Architecture /Database Design Meetings – Business Requirement gathering/Designing. • Managed SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems • Ensuring system availability, data integrity; monitor/troubleshoot backup and recoveries, performance, disk space, and network connectivity. • Responsible for fine-tuning & fast performance of those servers, fine tuning stored Procedures & Queries. • Responsible for day to day database administration and maintenance activities, including performance tuning, backup and recovery, writing maintenance plans, creating SQL jobs and writing and running ad-hoc queries. • Created database capacity planning, Maintenance planning, SQL Agent Jobs scheduling and troubleshooting. • Implemented, maintained database security, SQL Mail Manage small, medium and large SQL Server projects. • Written SQL queries, Triggers, Functions, creating Tables, Views and Indexes. • Audited and generated monthly management reports using third party tool. • Created the database, tables, table spaces, data objects, setting privileges, indexes, user logins, and passwords (security). • Implemented security, generated and reviewed report periodically, enforced security mechanism. • Providing Recommendations / implementations for good performance of Servers and Databases. • Created Customized maintenance plans (Re-Index, Update Stats) based on the application needs. • Used Powershell to automate DB refresh to lower lanes. • Created logins, proxies, customized security roles based on the standards.

• Responsible for monitoring the Servers, Database Backups, Capacity Management & trending. • SQL administration: installation, configuration, security, backup design, maintenance jobs and systems performance tuning, and operational Support Providing Recommendations / implementations for good performance of Servers and Databases. • Experience installing, configuring and administering new SQL Server databases and Failover Clusters. • Responsible for fine-tuning & fast performance of those servers, fine tuning stored Procedures & Queries. • Responsible for Maintenance of Servers – Patching the Server with Security Patches, Exclusion of .mdf and .ldf files from Security Scans, Disk Defragmentation using maintenance window. • Responsible for building SQL Server High Availability Solutions in Synchronous Automatic Fail Over and Asynchronous Mode. • Attendance daily stand up team meeting (Both DBA and Application team) to discuss the DBA activities/issues with the help of KanBan Board. • Attendance in Quarterly Offsite Meeting to discuss the projections and the forecast of each quarter of the DBA Team. • setup reports to email the daily failed Jobs, daily Backups failed, low disk space alerts – Kind of Daily Vitals of all Production Servers. • Responsible for Managing Production Database Servers during storage Migration (Off Peak Hours). • Responsible for on call DBA Support in a rotation basis as Operations team calls the on-call DBA to manage the crisis. Company provide Hotspot to the DBAs and the call forwarded to the on-call DBA Portable phone on a rotational basis. • Providing Recommendation / Building the Servers from Scratch using Standard Best practices. • Responsible for keeping pertinent /authentication information in Password Vault. • Responsible for database maintenances – Reindexing, CheckDB, updating the statistics. Skills: SQL Server 2008 R2\2012\2016 64 bit, Idera Diagnostic Manager Monitoring Tool, SQL Safe, Skynet

• Planned, tested, and upgraded SQL Server 2008, 2012 to SQL 2014. • Create documentation and best practices for access and controls, benchmarking, policy management, backups and recovery, performance, reliability, usability and support. • Created and developed SSIS packages for data mining and loads of data repositories. • Daily management, health and maintenance checks • Develops strategies for data acquisitions, archive recovery and implementation of a database. • Implemented performance monitoring, SQL alerts & maintenance jobs for all US and International sites • Assisting developers and stored Procedures & Queries.