Sr Developer & Analyst

MANZOOR BABAR

*** ******** ***** ** ******* AB, T1Y 5G9

Home: 403-***-****; Cell: 403-***-****

**********@*****.***

OBJECTIVE

Oracle Database Administrator

SUMMARY

● Highly motivated database professional with over fifteen years of experience in 24/7 high availability environment

● Installed oracle DBMS software, upgraded and applied patches to Oracle enterprise servers

● Worked in Sun Solaris, SCO Unix, Linux, SCO open server and Microsoft environment

● Shell scripting to automate the database scheduled tasks

● Proactively monitor the databases to ensure secure services with minimum downtime.

● Production roll-out of database changes from development and testing environment

● Expertise in SQL/PLSQL, packages, procedures, functions, troubleshooting and data migrations

● Analyze, map, and migrate data to different data models from different data sources

● Implemented Data Guard, RMAN and OEM

● Understand clients need and resolve the issues. Client support through Remedy, Magic, Service now and RT3 ticketing system

● Implement database changes, and establish related standards and documentation

● Good communication and presentation skills

TECHNICAL SKILLS

Databases: RMAN, Row level Security, Datapump, install / upgrade Oracle software, shell scripting, multi-master replication, data models (physical & logical), Views, Triggers, Oracle streams, Data guard, Microsoft SQL Server, Oracle 9iAS, 10gAS, Data guard, Oracle Enterprise Manager.

Programming: SQL/PLSQL, UNIX shell scripting

Systems: Sun Solaris5.8 / 5.10, SCO UNIX Open Server 5.7, SCO UNIX System V version 3.2, Windows, Linux

PROFESSIONAL EXPERIENCE

Database Administrator / Analyst 2011- present

Groundswell Group Calgary Alberta www.groundswellgroup.ca

(Oracle 10g / 11g Sun Solaris 5.8/ 5.10, Linux, MsSQL2008, Informatica8.6.1)

● Monitor database alert log files, data block corruption, segment fragmentation, performance issues, security threats, contention issues (deadlocks, I/O, memory, CPU, etc.). Manage and maintain high volume transactional tables and indexes, database reorganization

● Create tablespaces, tables, and users for custom applications and maintained security.

● Supporting day to day user related issues, troubleshooting and resolve.

● Monitor the database space, performance

● PLSQL codes to create views, triggers, database packages, procedures, functions and tables.

● Oracle application DBA support, applying patches, mini-packs, family-packs and maintenance packs, upgrades, automatic routines DBA task, periodic refreshes ,oracle support dealing with functional , developers and end users.

● Provided Oracle and UNIX expertise in application development, troubleshooting, performance tuning, and database architecture to include configuration, installation, migration, and upgrades.

● Create mapping docs to migrate the data from JDE, well data oather transactional datbases to data warehousing database.

Database Administrator 2006-2011

Kelman Technologies Inc. Calgary Alberta www.kelman.com

(Oracle 9i/10gR2, 9iAS, 10gAS, Sun Solaris 5.8/ 5.10, Linux)

● Check database alerts/logs, everyday backups for errors and resolve promptly, discuss issues with DBAs, developers, testers and address unanimously. Results in smooth running of database servers.

● Installed Oracle 10.2.0.1 database software, applied patches. Upgraded database from 10.2.0.1 to 10.2.0.3. Results in smooth up gradation with better performance.

● To create a controlled “delete procedure” for SEISMIC lines and inventory, to be run by data managers; designed the work-flow using Visio, developed the procedure, tested and rolled out to production. Resulted in no intervention by DBAs in deletion of data.

● Migrated users data from separate schema's into one. Resulted in simplified management of databases, less efforts in implementing the database changes.

● Analyze source data, create mapping doc, discuss the mapping doc with end users and modify if required, write scripts to extract data from source, transform accordingly and load into PPDM38/PDM32. Results in data loaded into client’s database as required.

● Make database changes in development/testing environment and then smooth roll out to production; work closely with developers, QA team and DBA team.

● Document all the activities; preserve different versions of scripts for database projects.

● To provide data pump export frequently to clients; created shell scripts, parameter file and scheduled a cronjob to automate the task. Resulted in data pump export reaching clients ftp site every month without any manual intervention.

● Configured physical standby database using 10g Data Guard

● Assist developers in troubleshooting application problems related to database, and to ensure performance and productivity levels are maintained

● Consult Oracle, create SR (service request), and resolve database related issues promptly.

● Refresh testing, development and stage databases for developers and tester.

● Respond to requests made through Remedy for day to day operations support; custom insert, update/delete, and generate custom reports.

● Installed OEM grid control and agents on database servers.

Quality Assurance Team Member 2006-2006

Kelman Technologies Inc. Calgary Alberta www.kelman.com

(Oracle 9i / 10g, Sun Solaris 3.8, Red Hat Linux 4)

● Test changes and update made to the records in database using Toad, SQL/PLSQL.

● Document the work in accordance to QA documentation standards using Word, Excel

● Performed functionality, regression and performance tests on applications and database in testing environment.

● Prepared detailed procedural flow charts of various applications using Visio

System Analyst 2001-2005

Board of Intermediate Education Karachi, (www.biek.edu.com)

Oracle7.0/7.3; Microsoft SQL 2000, SCO UNIX Open Server 5.7, Linux, Oracle Developer

● To computerize the examination system. Analyzed by interviewing examination supervisors/related staff, went through related docs. Designed the examination system procedures. Developed applications and databases according to the design. Did alpha testing, let the examination staff test the system. Deployed the examination system into production, monitored and supported. Results in fewer work forces, less time to process the examination, and increased accuracy.

● Analyzed and designed the pay roll system. Developed and implemented computerized payroll system, resulted in less work force, accurate and faster processing.

● Designed, developed and implemented the decoding process of encrypted students roll numbers. Resulted in accurate and faster decoding

● Enforced policies and procedures, created database roles, auditing of critical tables, and user profiles.

● Developed Data Tracking System to document changes and corrections done to the students’ data.

● Extracted data from current and historical examination database, developed students Tabulation Register, which saved around $500/register/year.

● Enforced policies and procedures, created database roles, password checking procedure, auditing of critical tables, user profile.

● Migrated data from Oracle 7.0 to Oracle 7.3

● Administered and performed tuning of databases and SQLs.

Programmer 1994-2001

SEMIS (Sindh Education MIS) Karachi http://www.sindhedu.gov.pk

● Analyzed developed and implemented Educational MIS databases and applications using FoxPro, resulting in accurate provincial educational statistics for better decision making and budgeting

● Transferred data from Foxpro to MSAccess database

● Developed and implemented ‘Seniority System’ to monitor staff performance

● Conducted seminars and workshops every year, explained the census questionnaires.

● Conducted staff trainings, on the use MS Office, email software, applications and MIS system

EDUCATION & TRAININGS

● Bachelors of Computer Systems Engineering 1993

Mehran University of Engineering & Technology

● Oracle Developer Professional’s Preparatory Courses 1999

Institute of Cost & Management Accounts of Pakistan (ICMAP)

● Oracle 9i Postgraduate Certificate 2003

CCEE NED University of Engineering and Technology

● OCA Oracle 9i Oracle Certified Associate 2005

● Work Experience for Immigrants Program (WEIP) 2006

Centre for Career Advancement

Bow Valley College 332 – 6th Ave SE Calgary, AB

● Success in Workplace 2009

Bow Valley College 332 – 6th Ave SE Calgary, AB

Contact this candidate