Syed Ashar Abbas

SYED ASHAR ABBAS Data Base Chief Architect Profile Master’s in computer sciences having more than 17 years of Data Base Administration, Management and Development experience. Highly motivated, goal-oriented, and team-focused with a passion for scaling up and predictably controlling of huge data loads on multi-tenant databases in AWS Clouds. Solid mindset for DevOps and well versed in Performance Tuning of all major databases like ORACLE, SQL SERVER, DB2, MYSQL, PostgreSQL, Informix and SYBASE. Ability to handle heavy workloads with thousands of databases with Terabytes of data by designing architectures, scaling and capacity planning using proactive and reactive controls. Excellent communication, time-management skills with strong leadership qualities. EXPERIENCES 11. Salsa Labs Environment: Data Base Chief Architect since July 2017 Oracle 12c, SQL Server 2016, PostgreSQL 9.5, MySQL 5.5, Linux, AWS, Azure, Python, Perl, Hadoop, Redshift, MongoDB, Big Query Responsibilities • Managing deployments and Own 100% uptime with performance of multitenant Database on AWS Based infrastructure. • Responding to alerts or escalation calls on 24x7 for mission-critical database environments to keep smooth Database Operation. • Implementing AWS based disaster recovery, scaling and capacity planning for multitenant database architecture. • Proactively monitor the database systems to ensure secure services and smooth performance with no downtime. • Responsible for High availability, Load Balancing, Replications, Installation, Configuration, Upgradation and patching Database Servers on AWS Cloud. • Measure performance of databases using different monitors like Grafana, DPA, Nagios, APM to avoid resource starvation and slowness. • Improved Performance by tuning SQL Queries, DB configurations, OS File system and recommending best for database design. • Removed vulnerabilities and Implement high-level Security authentications and audit policies. • Designed reactive Auto Heal solutions to handle high loads and resolve performance bottlenecks in automatic way. Achievements Implemented Auto Heal system for automating response against database performance issue. Developed central database inventory system to manage more than 10 thousands system efficiently. Consolidated more than 5 thousand databases in multi-tenant environment for cost efficiency over compute price ratio. -----------------------------------------------------------------------------------------------------10. NetSol Technologies Data Base Optimization Lead February 2016 – August 2017 Environment: Oracle 11g, 12c, SQL Server 2014/2016, PostgreSQL 9.5, MySQL 5.5, Windows 2012, Linux, AIX Responsibilities • Playing Lead role for Root Cause analysis of Performance issues at client production Databases. • Performing the Proof of Concept (POCs) of database solutions need to be pitch to the client. • Auditing SQL Code according to optimization best practices and Providing Scalability option in terms of storage and capacity planning. • Load test to Extract and Analyzing the Blocking, Deadlock, and finding their Solution using AWR/ADDM and ASH Reports analysis. • Evaluating Database initialization parameters (SGA & PGA) and resources (Processor, Memory, Disks, Network) for best performance. • Provided Technical Upgrade, Load balancing and High Availability solutions to clients according to their business needs. • Performed regular Database Health Check as a preemptive approach to figure out the area that should be strengthened proactively. Achievements Introduced Parallelism for Performance in Oracle 11g. Implemented Parallelism in SQL Server 2014. Designed Automatic Data Archiving system for high volume database to reduce space and best performance ------------------------------------------------------------------------------------------------9. Agha Khan University Lead Data Base Administrator September 2013 – January 2016 Environment: Oracle 10g, SQL Server 2008, PeopleSoft 8.51, MySQL, Windows 2008, Linux, Weblogic Responsibilities ● Leading and managing database performance, monitoring, trouble shooting, Backup and recovery and security policies. ● Developing adequate understanding of data modeling and analysis techniques to ensure compliance across board. ● Participate as lead in upgrade / patch management, configuration, capacity planning and regular database maintenance activities. ● Auditing SQL Code and database design to gain performance of the whole application / DB design. ● Maintain and manage database documentation and participate in preventive maintenance activity. ● Interact with departmental users as supervisory level and resolve day-to-day issue. ● Make sure Availability of Databases at 24X7 and Works as lead for end-to-end problem resolution. ● Represent department in management meetings, committees and forums pertaining to technical aspect. Achievements Implementation of DR solution on SAN based for Hospital Management system. Upgrade PeopleSoft ERP to 8.53. Implemented high availability solution for all database solutions to avoid downtime during maintenance window. 8. Folio 3 (Pvt.) Ltd Environment: Lead Data Base Administrator/BI Developer November 2010- October 2013 Oracle 11g, Jdeveloper 11g, SQL Server 2008, Oracle EBS R12, Cognos 8, PostgreSQL 8.2, UNIX Responsibilities ● SQL Queries Optimization and Handling load management for Performance Tuning and avoiding bottlenecks. ● Suggesting improvements in Database design and modeling ERD. ● Implementing Data Warehousing by PostgreSQL and SQL Server 2008 and Developed ETL by using SSIS and SQL scripts. ● ● ● ● Working on Business Intelligence and Reporting by using SQL Server 2008 Analysis and Reporting Service. Developing Data migration and uploading Scripts. Plan and maintain Security Policies to avoid potential security threats. Administering, Configuring, Customization and security implementation Oracle E-Business suite R12. Achievements Implemented SQL Server 2008 FailOver Clustering at Getz Pharma. Integration of Oracle E-Business suite R12 with Bitzer mobile application. Build a data warehouse by using PostgreSQL. Owner of Business Intelligence special interest group in Folio3. ------------------------------------------------------------------------------------------------7. Master Key System Data Base/Developer/Administrator Environment: SQL Server /2005/2008(SRS, SAS, SSIS), Windows 2003 November 2009- December 2010 Responsibilities ● Identifying and Analyze bad SQL queries and database levels performance bottlenecks to keep smooth database operation. ● Managing backup, recovery, High availability, Patching, configuration and deployment activities. ● Make sure availability of Database at 24X7. ● Developing Data migration and uploading Scripts. ● Write Complex stored procedures, Functions and triggers related to business requirements. ● Plan and maintain Security Policies to avoid potential security threats. ● Write database documentation, including data standards, procedures and definitions for the data dictionary. Achievements Automation of Data Migration from old MK4 system to New MK5. Optimize and Tune whole database scripts for Fast response at user end. Implement a Point of failure Backup and Recovery Policies to avoid any data loss. Deployed a strong Security policy. ---------------------------------------------------------------------------------------------------6. Royal Cyber Inc. Environment Data Base/Developer/Administrator January 2008-November 2009 SQL Server 2005/2008(SRS, SAS, SSIS), Cognos 8, DB2 9.2, Windows Responsibilities ● Designing Logical Data Models and Writing complex SQL queries with development team. ● Developing Data migration and uploading utilities using different Databases utilities. ● Developed ETL by using SSIS and SQL scripts. ● Working on Business Intelligence and Reporting Tools of various Databases. ● Implementing Replication, Failover Clustering, Backups/Restores, Performance and tuning scenarios. ● Write Complex stored procedures, Functions and triggers related to business requirements. Achievements Star of Month on Implementation of HADR and Performance tuning of Database in DB2 for Dawn News Group. DTS package for online survey of General Electric. SSIS package for Rogers Mobile for online survey. Performance and Tuning of Resturant.com Data Base Stored Procedure. ------------------------------------------------------------------------------------------------5. Primatics Financial LLC Data Base/Developer/Administrator May 2007-December 2007 Environment: Oracle 10g, SQL Server 2005 (SRS, SAS, SSIS), MySQL, UNIX, Windows. Responsibilities ● Working with the design team to define the database schemas. ● Tuning SQL queries and optimize database design and stay on top of the latest information in that space. ● Designing Data migration and merging scripts. ● Implementing Data ware house and OLAP techniques using SQL Server Analysis Services 2005. ● Writing Complex stored procedures, Functions and triggers related to business requirements. Achievements Data Base Designing and Tuning of Loan Amortization System. Developed OLAP system for Loan Amortization System. Developed Reporting system by using SQL Server Reporting Services. ------------------------------------------------------------------------------------------------4. BMA Capital Management Data Base Administrator Environment: Oracle 9i, TOAD, PLSQL Developer, Windows 2003 November 2006-April 2007 Responsibilities ● Installation, configuration and upgrading of Oracle server and related products. ● Establishing and maintain sound backup and recovery policies by using Data Guard in Oracle. ● Take care of the Database design and implementation. ● Implementing and maintain database security (create and maintain users and roles, assign privileges). ● Perform database tuning and performance monitoring. ● Preparation of MIS Reports for Management. Achievements Implemented Data Guard in Oracle 10g for high availability. Developed MIS reporting system. Performance and tuning of Oracle using ADDM. Implemented Strong backup policies using RMAN. ------------------------------------------------------------------------------------------------- 3. PHILIPS Electrical Industries Oracle Programmer June 2005-October 2006 Environment: Oracle 9i, Oracle Forms 9i, TOAD, PLSQL Developer, Windows 2003 Responsibilities ● Designs and develops integrated business systems to support the achievement of the business goals. ● Leads others in the project scope, plans and deliverables including cost projections and proposed implementation. ● Integrate Data Transformation and Processing between JD Edward and Oracle. ● Establish and maintain sound backup and recovery policies and procedures. ● Perform database Tuning and performance monitoring. Achievements Integration between JD Edward and Oracle. Graphical Drill Down Reports for Human Resource Management, Supply Chain Management, Bank Reconciliation, Billing & Invoicing, Store management with enhanced reporting and charts in oracle. ------------------------------------------------------------------------------------------------2. Al-Hamd International Container Terminal Analyst Programmer September 2003-May 2005 Environment: Oracle 9i, Oracle Form 6i, TOAD, PLSQL Developer, Windows 2000 Responsibilities ● Undertakes hands-on application design and development, as well as the support of internally developed systems. ● Works closely with senior management to implement consistent application across the enterprise. ● Complete documentation and procedures for deployment and maintenance, and transfer knowledge to users. ● Design, develop, test, deploy and support various applications, including web-based and standalone desktop. Achievements Billing & Invoicing, Container terminal System, Pay Roll, HR management system. ------------------------------------------------------------------------------------------------1. Mahmood Brothers (Exporter ISO 9002) Computer Programmer July 2001-August 2003 Environment: Oracle 8i, Oracle Form 6i, Windows 2000 Responsibilities ● Responsible for developing, coding, installing, debugging and optimizing different projects, as part of the team, system enhancements relating to databases structure and user interface. ● Assist in the preparation of routine block diagram and machine logic flow charts. ● Manages the distribution and retention of data on various storage devices develop activities, as well as the support of internally developed systems. Achievements Financial and GL Management system, Pay Roll, Store management. Budgeting & Forecasting, Sale management. EDUCATIONS & TRAININGS Year Grade M.Sc (Computer Sciences) Standards 1999 B Islamia University Bahawalpur Institution Post Graduate Certificate ORACLE 9i 2003 A NED University Karachi Oracle 11g Performance tuning Workshop 2014 Oracle Pakistan SQL Server 2012 Performance Tuning 2013 Jordan, Microsoft Pakistan SQL Server 2016 Advance features and Power BI 2016 Lahore, Microsoft Pakistan http://www.mycertprofile.com/Profile/- C-23, Abbas Town, Gulshan-Iqbal, 4-A, Abul Hassan Isphani Road, Karachi, Pakistan--