Abdul Wahab
Angestellt, Database Administrator., W. L. Gore & Associates
Ottobrunn, Deutschland
Über mich
Having worked in the business for more than ten years as Database Administrator, I have a proven track record of creating, setting up, and managing corporate databases for MS SQL Server both on-premises and in the cloud. My expertise lies on maximizing database efficiency while maintaining data integrity by actively utilizing SQL, PL/SQL, and T-SQL. PowerShell scripting. Best practices for physical and logical architecture, implementation of the backend ecosystem, configuration, and integrations with other services and applications, Infrastructure capacity planning and suggestions and best practice implementation, data purification, data presentation and problem solutions, cost optimization and compliance with licensing, Azure managed instances, and AWS RDS & EC2. I'm skilled in PostgreSQL, Oracle administration, and My-SQL development. I am proficient in Linux scripts, No-SQL, Linux OS, SOP writing, Python, Azure Data Factory, Azure Data bricks, Azure Analysis Services, Spark SQL.
Werdegang
Berufserfahrung von Abdul Wahab
• Administrating and coordinating MS SQL & Oracle database instances globally, both on-premises and in the cloud (AWS, Azure). Managing full SDLC process for servers. • Configuration of health checks for performance monitoring, creation of automated scripts (T-SQL , PL/SQL) and notifications, scheduled critical operations for production instances. Capacity planning and business continuity, Index rebuilding, User access control. Backups and recovery policies Database migrations.
4 Jahre und 9 Monate, Nov. 2012 - Juli 2017
Sr. DWH/Business Intelligence Expert.
Systems Limited
• Working on database systems with Terabytes of Data in the Data Warehouse (SSAS), Reporting and analysis based on many fact and dimension tables. • Observing and analyzing various performance metrics like throughput, latency, concurrency, and resource utilization, Query Performance, Database Health, Session and Connection Monitoring, Cache and Buffer Monitoring, Index and Table Statistics. • Performing ETL to consolidate, clean, and structure data from various sources for analysis and reporting.
1 Jahr und 2 Monate, Okt. 2011 - Nov. 2012
Computer Programmer and Analyst
Beaconhouse School System
• Design, prepare functional specification and application development (PHP, EXTJS), database development ( PL/SQL), Reports Generation, Dashboards. • Reviewing the Database ERD diagrams, proposing data model designs & Data Analysis • Supported the different UI with backend logic, wrote SQL code to summarize the data. • Worked on support tickets, maintenance tasks and project coordination. • Created and provided workshops to end users, created user-friendly training materials & documentation (SOP).
2 Jahre und 8 Monate, März 2009 - Okt. 2011
Reporting Analyst
Mobilink GSM
• Creating and maintaining, Integration stream data from different diverse sources and load into data DWH. • Visualization of data including Reports, Dashboards. • Data cleansing, ER modeling, developing process for DWH & documentation. • Implemented complex business requirements in backend, using efficient stored procedures and flexible functions, as well as the application front end • Creating GUI for web forms (HTML, CSS, JavaScript, ASP.NET C#, PHP),query writing .
1 Jahr, Apr. 2008 - März 2009
SE, Technical Support Executive
Ovex Technology
• Writing assigned application code (HTML, CSS, JavaScript, ASP.NET C# ). • Conducted data import and export operations using the DTS wizard. • Troubleshooting, performance issues & error handling in Stored procedure & Views. • Coordinated with the Front-End Developers in detecting the bugs and solving the same.
Ausbildung von Abdul Wahab
4 Jahre, Apr. 2004 - März 2008
Information technology
Punjab University, Lahore
Information technology, Databases, Software developement
Sprachen
Englisch
Fließend
Deutsch
Gut