Ahmed Hesham

• Managed and optimized Teradata environments, including multi-system, and MAPS architecture, ensuring optimal AMP distribution and performance. • Planned and executed database migrations and data synchronization using TPT and Data Mover, minimizing downtime and ensuring data consistency. • Conducted daily health checks and proactive monitoring of Teradata systems (CPU, Disk, Spool, Skew) using Viewpoint, PDCR, and custom alerts. • Implemented and fine-tuned performance strategies, including statistics, indexing (PI/PPI), partitioning, and query optimization via Explain Plans and DBQL. • Diagnosed and resolved critical database issues such as blocked sessions, skewed queries, space shortages, and database corruption. • Designed and managed robust backup and recovery strategies (BAR, ARCMAIN), automating schedules with BTEQ scripts and cron. • Administered database security, including user/role management, privilege grants, password policies, and applying patches/upgrades. • Developed and maintained stored procedures, macros, and scripts for operational automation and efficiency.

• Design, configure, and deploy SQL Server databases, including standalone and high availability (HA) cluster environments. • Set up and maintain SQL Server Always On Availability Groups, clustering, and other HA features. • Plan and execute migrations of databases between SQL Server environments or to newer versions, ensuring minimal downtime and data integrity. • Perform daily health checks on production DB servers, monitoring for any critical issues and escalating when necessary. • Monitor and analyze database performance using SQL Profiler, Dynamic Management Views (DMVs), and other tools. • Implement indexing, query optimization, and other strategies to improve performance, proactively identifying and resolving bottlenecks. • Diagnose and resolve database issues, including connectivity, performance, and configuration problems. • Implement and manage backup/recovery strategies, ensuring data integrity and availability. • Apply patches, perform upgrades, and maintain security standards for databases. • Develop stored procedures and views for reporting purposes. • Automate data transfer tasks between servers for specific customer requirements. • Install SQL Server following best practices. • Review ad-hoc SQL queries and database changes from an operational perspective. • Monitor for and resolve database corruption and critical SQL error log entries. • Detect problematic queries and collaborate with the development team for optimizations. • Oversee DB backup operations and sync data to development environments as needed.

• Design, configure, and deploy SQL Server databases, including standalone and high availability (HA) cluster environments. • Set up and maintain SQL Server Always On Availability Groups, clustering, and other HA features. • Plan and execute migrations of databases between SQL Server environments or to newer versions, ensuring minimal downtime and data integrity. • Perform daily health checks on production DB servers, monitoring for any critical issues and escalating when necessary. • Monitor and analyze database performance using SQL Profiler, Dynamic Management Views (DMVs), and other tools. • Implement indexing, query optimization, and other strategies to improve performance, proactively identifying and resolving bottlenecks. • Diagnose and resolve database issues, including connectivity, performance, and configuration problems. • Implement and manage backup/recovery strategies, ensuring data integrity and availability. • Apply patches, perform upgrades, and maintain security standards for databases. • Develop stored procedures and views for reporting purposes. • Automate data transfer tasks between servers for specific customer requirements. • Install SQL Server following best practices. • Review ad-hoc SQL queries and database changes from an operational perspective. • Monitor for and resolve database corruption and critical SQL error log entries. • Detect problematic queries and collaborate with the development team for optimizations. • Oversee DB backup operations and sync data to development environments as needed.

• Make daily health checks on the production DB server. • Responsible for SQL server daily operations and maintenance. • Monitor Production database servers and escalate issues to higher level administrators. • Developed multiple stored procs and views for reporting purposes. • I’ve developed automated data transfer task from server to server for a customer. • Install SQL server as per the best practice. • Review ad-Hoc SQL queries from operational perspective. • Monitor any database corruption and fix it. • Monitor SQL error log for any critical errors. • Detect bad queries and send them to development team.

• Handle all customer level one support. • Work on bank Misr banking system. • Treat with all account types and handle all customer financial transactions.