Syed Ali Raza Zaidi Email & Phone Number

Pakistan

 Managing team of 6 people Wring ETL scripts to migrate data between databases and from files to databases. Migrate data from PROSOURCE DB to CDS DB Using ADT (advance data transfer).  Write Pl/Sql scripts to migrate Audit data from Pro-source to CDS Scheduling backups and verifying backup procedures are implemented correctly. Tuning migration scripts and migrated data. Providing support to other teams in database administration and optimizing Sql,Plsql scripts.  Using Oracle trace to identify missing attributes from Petrel Studio Application. Writing ETL to migrate data from total Rods mssql db to EDM db Write optimized Sql, T-sql scripts to migrate data from TotalRod to EDM database and verify. Provide updated script to client to migrate data in production Migrate data from excel ,html ,xml to sql server database Perform database recovery after wrong data deletion by client. Using regular expression to handle complex data

Pakistan

 Working Experience of Configuration and Management of Oracle11gR2 RAC, ASM infrastructure. Good Experience in writing complex SQL, PLSQL, Dynamic SQL, Packages, Stored Procedures, Triggers, Functions, Views and Materialized Views. Configuration and Administration of Standby Database with Oracle Active Data Guard. Expertise in RMAN to create Incremental Backups, manage and configure backup policy and automate it to ensure that database backups are working according to backup and recovery policy. Database Upgrades, Migrations, Cloning, Patching, and troubleshooting various databases Expertise in managing Table spaces, Data files, Users and Privileges, Tables, Schema, Materialized Views, Indexes and other database objects. Implementing Virtual Private Database (VPD),Implementing Oracle Label Security (OLS) , Working knowledge of Transparent Data Encryption (TDE) and Basic knowledge of Oracle Data Redaction (ODR) Creating and managing MySQL on NDB cluster. Managing PostgreSQL database. Implementing PostgreSQL database replication, switchover and failover. Managing Sql Server 2014 database implementing backup and recovery for Sql server database, scheduling jobs, writing store procedures, functions. Migrating data to and from Sql server database. Managing team of 4 people.

Islamabad,Pakistan

 Upgrade database from Oracle 11g to 12C  Performing Backup, Restore and Tuning database Security implementation for different user profiles and applications  Database management using Oracle Enterprises Manager Grid Control  Modify and recompile objects.  Installation of Clients & server  Writing PL/SQL blocks to implement CDS business logic  Enhancements in Shell scripts which parse tab delimited text file and generate SQL statements in SQL scripts  Troubleshooting and debugging existing code to fix defects  Write SQL and PL/SQL scripts for data migration from CDS 5000.2.1 to CDS 5000.8.3 release  Provide support to every team member working on CDS.  Provide Database support to team Create ,upgrade and test OpenWorks Database and Openworks Pre-Oracle installer Preparing and administrating OpenWorks® and DSG servers on Windows and Linux for development team on virtual Box and physical machines. Managing team of 3 people

Lahore

 Administer production and development databases, ensuring maximum availability. Database Backup and restore using RMAN, Managing Database with Enterprise ManagerManaging team of 3 People Providing High Availability with RAC, Data Guard Ensure that storage, archiving, back-up and recovery procedures are functioning correctly Apply business Logic through Procedure, Functions and Packages triggers and writing complex queries. Work with customers in data migration projects to build migration scripts and integrate with customer’s existing databases and/or data feeds Review database design and code written by other database and software engineers. Writing ETL scripts and provide technical assistance to BI development, application Development and support team.

• Using SQL Server 2000, 2005, 2008 database administration and development.• Applying Backup and Recovery methods, backup tuning and troubleshooting• Involved in designing, developing and deploying application.• Apply business Logic through Procedure, Functions and Packages triggers and writing complex queries.• Providing Support to off sure clients.

• Working experience in Oracle forms ,Oracle reports ,Oracle graphic• Good Experience in writing complex SQL, PLSQL, Dynamic SQL, Packages, Stored Procedures, Triggers, Functions, Views and Materialized Views.• Write Ad hock queries to generate different reports and to extract data for analysis and decision making.• Managing database, creating Users and Privileges, Tables, Schema, Materialized Views, Adding tablespace, Data files.

• Working experience in Oracle Forms ,Oracle Reports ,Oracle graphic• Good Experience in writing complex SQL, PLSQL, Dynamic SQL, Packages, Stored Procedures, Triggers, Functions, Views and Materialized Views.• Write complex queries to generate different reports and to extract data for analysis and decision making.• Writing Ad hock queries to extract data for analysis purpose

Bs(Cs), Computer Software, A

Ocp, Database Administration

Activities and Societies: Oracle Database

Ocp, 11G Advance Pl/Sql Developer

Oca, Pl/Sql Developer

Dae, Computer Hardware, A