Syed A

About Syed A

Over 12 years of designing, development, maintenance, implementation, database administration experience in Oracle based ERP and multi terabytes data warehouse systemsInstallation, configuration, upgrade of Oracle Grid Control server and Agento Upgrading 10g databases into 11g release 2 (11.2) o RAC One node cluster (11g) o Install, Manage cluster file system, RAC databaseso The SQL Performance Analyzer o Database replayo SQL Repair Advisor o Automatic Diagnostic Repositoryo SQL Test Case Buildero Real Application testing (RAT) MYSQL Databases Administrationo Installation, configuration and upgrading of MYSQL databases Extensively worked in Oracle Application Database performance tuning in multi terabytes with users. Implementation and maintenance of Oracle real application cluster (RAC). Experience in implementation of grid computing environment of Oracle 10g Databases with Oracle E-Business suits 11i. Design logical and physical database for best optimization, fulfill backup requirements and minimize downtime. Understanding of data guard and stand by database architecture. Extensive knowledge of Windows, Solaris, UNIX and Shell scripting. Logical and physical database design for Data warehousing and used ETL tools Gathering and analysis business requirement and perform capacity planning and trend analysis. Extensive experience in the database design, grid computing (10g), capacity planning, administration of Oracle Database, Backup and Recovery, SQL Tuning, Disaster Recovery, Installation of Oracle Software, Oracle 9iAS portal v1.0.2.2, RMAN, Netbackup Well versed with Standby database, Global database standards, SQL, Export/Import, SQL*Loader, PL/Sql Development, Shell Scripts, and User management Project co-ordination & resource management. Automated the day-to-day database administration, backup and helped developers to use efficient logic on coding, SQL tuning, customizations of Oracle ApplicationsSpecialties- Oracle Certified Professional - 12+ years of proven experience only in multi national companies- Expert in converting business model into database model- Performance tuning expert in VLDBs (2+ Terabytes) environment with users- Extensive knowledge in Installation, patching, Upgrade and cloning.

Experience

1. AVP, Database Administration

   LPL Financial

   Sep 2014 — Present · Charlotte, NC, US

Education

• Petroman Training Institute

  Diploma, Computer Science

  1994 — 1995

• University of Sindh

  Bachelor, Computer Science

  1996 — 1999

• Oracle University

  Certification, Oracle DBA 7.3 / 9i / 10g

Skills

• Oracle
• Database Administration
• Clustering
• Pl/Sql
• Data Warehousing
• Disaster Recovery
• Performance Tuning
• Databases
• Rman
• Database Design
• Sql
• Oracle Sql
• Sql Tuning
• Cluster
• Oracle Enterprise Manager
• Solaris
• Shell Scripting
• Unix
• Data Modeling
• Oracle Applications
• Oracle E-Business Suite
• Microsoft Sql Server
• Oracle Rac
• Itil