Experienced Database Administrator
-- Acting as Database Administrator for Etisalat Data-Warehouse across Teradata DB engines.
-- Involved in designing capacity plan, performance planning & space requirements.
-- Provide data quality control & auditing of databases to ensure accurate and appropriate data usage.
-- User Management – Creation and managing Users, Databases, Roles, Profiles and Accounts.
-- Access of Database Objects – Granting and Revoking Access Rights on different database objects.
-- Define/modify workload management standards (workload groups, throttles, priorities etc.) based on the needs of the day in production and explains 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 and recovery - Netbackup
-- Handling complex environment with multiple terabytes spread across multiple nodes, datacenters.
-- Monitor/ Maintain System Health Check (Viewpoint)
-- Evaluates and implements new initiatives on technology and process improvement.
-- Optimizes Teradata database resources for optimum configuration, database performance and cost
Achievements
-- Visit Main tables to optimize storage by using Compression Techniques.
-- Apply Physical database design techniques on some table for better performance.
-- Change data types to be well defined with the actual data stored in.
The above achievements lead to enhancement:
• CPU Utilization : 8 %
• I/O Count : 6%
• Execution Time : 58 %
• Storage : Saved 3.7 TB of data
-- Automate Archiving Process.
ACADEMIC CREDENTIALS
=========================
? B Sc. OF ENGINERRING (MAJOR COMPUTER) , 2007-2011 , GPA: Very Good (82.07%) , Project Grade: Excellent
Work Terms
less than 30 hour per week , communication by (Voice - Chat )