Teradata Database Administrator
Resume:
HASSAN AHMED HASSAN
Address: *** **** (E) South Academy, New Cairo, Cairo, Egypt
Contact: +20-111******* - +20-111*******
Email Id: ***.*****@*****.***
SENIOR TERADATA DATABASE ADMINISTRATOR – TECHNICAL EXPERT Domain Expertise: IT/ Telecommunications
C A R E E R S U MMARY
Certified Expert IT Professional with 10+ years of versatile experience across diverse organization domains.
Currently functioning as Technical Expert in Teradata Database Administration at Etisalat one of the world’s leading telecommunication groups involved in Etisalat Data-Warehouse Database Administration Activities of complex environment.
Excellent Attitude and Team work spirit.
Solid Experience in SDLC waterfall and agile methodologies.
Well versed in development of common business model.
Possess keen understanding of Project / Client Requirements coupled with hands-on exposure in handling all phases of Project / Program Life Cycle, implementation of robust technology solutions within time, budget and quality.
Adept at defining and driving project operations effectively, through the implementation of several management dynamics including Strategic Execution Plans, Performance Monitoring etc.
Mastering complete set of database technology activities (designing and implementing) through many platforms (UNIX, Linux, Windows) :
o High availability solutions.
o Backup policies, Replication solutions, data movement and database migration. o Performance and tuning.
o Space and Capacity planning.
WORK E X P E R I E N C E
Etisalat Group
Senior Teradata Database Administrator, May 2017 till date Responsibilities:
Acting as Expert Database Administrator for Etisalat Data-Warehouse across Teradata DB engines.
Involved in designing capacity plan, performance planning & space requirements.
Auditing of databases to ensure accurate and appropriate data usage.
Configure the New DSA Teradata Backup solution.
User Management – Creation and managing Users, Databases, Roles, Profiles and Accounts.
Define/modify workload management standards (workload groups, throttles, priorities etc.) based on the needs of the day in production and explain the changes effectively to the teams.
Analyze database operational data, identify potential issues and proactively initiate resolution strategies with other application and IT support team.
Data Archive, Restores and recovery – ARC Utility and permanent journals -Backup (Net backup).
Handling complex environment with multiple terabytes spread across multiple nodes.
Monitor/ Maintain System Health Check.
Evaluates and implements new initiatives on technology and process improvement.
Represents how data should be structured and related in the database.
Optimizes Teradata database resources for optimum configuration, database performance and cost.
Built a proactive monitoring system and scripts for all possible elements in Teradata database. Page 2 of 4
Automated space management strategy and all Teradata housekeeping, including space distribution planning, monitor space usage, regular compression, and DBQL with automatic maintenance scripts.
Restructured backup system, including backup policies, SLAs, archival, and restoration in order to ensure business continuity. Slashed costs while optimizing resources with major space savings.
Completed major upgrade and patching of Teradata system.
Exceeded goals, resulting in Expectation Award for pre-launch project of Etisalat IT development.
Completed physical H/W removal & relocation of Teradata Appliances securely and smoothly with Utilized proven methodology to limit downtime.
INTERNATIONAL TURNKEY SYSTEMS (ITS)
Senior Database Administrator, Jul 2012 -May 2017
Responsibilities:
Acting as Senior Database Administrator for banking application database across multiple DB engines
(Sybase, Oracle, and Microsoft SQL Server).
Involved in designing capacity plan, performance planning & space requirements.
Implementing high availability, cluster solution (Sybase, SQL Cluster) and disaster recovery plans to guarantee fault tolerance performance.
Support integration between ITS Applications & database.
Centralize administrative tasks while improving scalability and workloads using Virtualization Concept.
Focusing on technical architecture analysis, design, development and enhancement.
Updating on industry leading information management technologies.
Facilitate secure access to applications and content Using Citrix.
Administrate and manage more than 400 virtual servers.
Technical support for development team.
Create and maintain database structure for development purpose. Raya Cooperation
UNIX Administrator Nov 2011 – June 2012
Responsibilities:
As UNIX Administrator
Use components of the desktop system.
Manage files and directories.
Create and modify files.
Control the user’s work environment.
Archive files and perform remote operations.
Manage file systems.
Perform system boot procedures.
Manage network printers and system processes.
Perform system backups and restores.
Install software.
A C A D E M I C C R E D E N T I A L S
B Sc. OF ENGINERRING (MAJOR COMPUTER),2007-2011, GPA: Very Good (82.07%) Project Grade: Excellent
C E R T I F I C A T E S & T R A I N I N G S
Page 3 of 4
Training:
~ Golden Pyramids Plaza – City Stars Company Training
• Set up (Active Directory - DNS).
• Join client to the domain.
• Give users certain privilege.
• Control desktop by deploying the user group policy.
Linux LAN Application Deployment Lab Project
The project is designed on VMware to implement (LDAP and Samba, Squid, File & Print server). Achievements:
• Install LDAP on Linux environment (Suse11.2), creating organization units and users, Install multiple domains on different sites and allow replication between them.
• Sharing resources for Linux and Windows platforms (SMB).
• Windows Client Authenticate against a Linux LDAP Server.
• Internet user access control using Linux proxy (squid).
End user support include install client operating system software, join domain, Antivirus and application setup
P R O F E S S I O N A L DEVELOPMENT
Expert Teradata Database Administrator Etisalat Group Senior Database Administrator International Turnkey System Unix Administrator Raya Cooperation
IT F O R T E
Database: Teradata 14,15&16, Oracle 11g/10g/12c, Sybase 12/15,MS SQL (2005, 2008 & 2012) server.
Operating Systems: UNIX, Linux, Windows server platforms.
Oracle Web logic 10.3/12.1.2/12.1.3.
Networking: TCP/IP.
Virtualization.
Microsoft Azure Cloud Computing.
Windows infrastructure.
Others: S/W Engineering.
SQL tuning.
Shell Scripting.
• Microsoft infrastructure Lab Project
The project is designed on VMware to implement (Active Directory, Proxy & TMG). Achievements:
Certificates:
Teradata Vantage : Advanced SQL Engine Physical Database Tuning.
Microsoft Azure Cloud FundamMntals.
Microsoft SQL Server 2008, Implementation and Maintenance.
CCNA Exploration Network Fundamental.
Page 4 of 4
Date of Birth: 28 January 1989; Languages: English and Arabic; References: Available on Request
Contact this candidate