Resume

Sign in

Sql Server Oracle

Location:
Brampton, Ontario, Canada
Posted:
October 05, 2016

Contact this candidate

Oracle Certified Professional DBA

mongodb certified dba

**** ************ ***

Mississauga ON,

Canada L5V 2R6

Phone: 416-***-****

Email acwxez@r.postjobfree.com

Senior Infrastructure /Database Machine DBA

Sam Rahim

Summary Of

Qualifications

Over 17 years of Oracle Database experience in 24x7 production mission critical multi-terabytes database’s and RAC & Dataguard Standby Database’s on Windows/Linux/Unix platform.

Proficient in an array of continuous improvement tools centered on lean manufacturing and six sigma methodologies including standard work, standard operating procedures, statistical process control, visual management systems, 4S,8PS, continuous flow, and Kanban systems

Expert level in Performance Tuning of Oracle database server 7.x/8i/9i/10g/11g/12c using OWI, ADDM, AWR, OEM, RDA and Statspack.

Installed Oracle databases on HP-UX, Sun Solaris Sparc & x86 processor, Linux and on Windows servers.

Good skills in database Installation, performance tuning, optimization, backup and recovery,Database Mirroring, data integration and synchronization in SQL Server 2005/2008

Customized System startup & shutdown procedures.

Installed High Availability Oracle solutions using Oracle RAC, ASM, Flashback, Dataguard, Goldengate, Replications(Streams)

Good knowledge of Hyperion EPM.

Strong database migration and upgrade experience across versions and platforms. Database upgraded and migrated using Export/Import, Transportable Tablespaces.

Clone databases using RMAN, export/import, datapump and physical online/offline backup for development, testing, education and production purpose.

Experienced in 24X7 production databases support as well as development databases to ensure maximum availability of database for various applications.

Excellent skills in writing SQL and Functions, Procedures, and Packages of PL/SQL.

Excellent skills with SQL*PLUS, OEM, RMAN, SQL Loader, and third party tools like Quest Live Reorg and Toad.

Strong in performance tuning using Explain Plan, STATSPACK, SQL_TRACE, TKPROF, TRCSESS.

Automation of daily routine tasks like including user management, daily hot backup & weekly cold backup (using CRON & AT), storage management, develop data feed and standby database management, and administration by writing UNIX shell scripts.

Involved in application development teams for app. development, testing, system acceptance, implementation and migration to production.

Good Skills in SQL Server 2005/2008 BI Suite (SSIS, SSRS)

Experienced Logical and Physical database design using Oracle Designer, Erwin.

Customized the database for data movement and expertise in data migration. Designed the structure of the database to reduce the contention and fragmentation. Ensure the safety of the database by creating multiplexed redo log files and control files.

Expertise in Troubleshooting the Problems regarding database, application and development tools.

Extensive experience in Extraction, Transformation and Loading of data using Informatica from heterogeneous sources.

Configured Oracle Audit & Security (Encryption, Redaction). Developed and implemented the strategy for managing security roles and privileges. Created profiles to control and optimize the system resources such as connect time, idle time, CPU time etc.

Experienced in database Analysis, design, creation, maintenance and upgrading.

Designed backup strategy in view of business requirement, activity level on the database. Complemented physical backup procedures with logical backup schedules. Restored the database after database crash, corruption and system crash on client site.

Involved in Configuration and Maintained Storage devices like NAS, SAN, Exadata, replication and physically removable devices.

Experienced in Solaris system performance tools.

Experience using source management and change management tools (CVS,Oracle Designer SCM)

Strong Project Management skills and worked with other domains/group on various projects.

Follow ITIL Best Practice guidelines for Incident Management, Change Management, Problem Management & Release Management

Certification

Oracle Certified Professional – Database Administrator

Lean Six Sigma Black belt in Process

Technical Skills And Qualifications

Jan 2016

University of Toronto, Mississauga,ON

June 1998

Bachelor of Computer Science, Applied Science University, Amman- Jordan

Hardware (Platforms)

Sun Server X3,X4 Intel Xeon E5-2697, HP-UX 9000 /HP RX6600/ IBM p Series 610 / SAN Storage Arrays /IBM PCs (and compatibles)

Operating Systems

Exadata X3-2,X4-8,Oracle Database Appliances X3-2,X4-2,Linux 6.x/5.xHP-UX Itanium/ PA-RISC/Unix,AIX/Red Hat Enterprise Linux / Windows 2012 Servers

Software

Databases

Oracle 12c/11g/10g RAC, Oracle Enterprise,Spatial (12c/11g/10g/9i/8i/8),SQL Server 2005/2008,2012,MongoDB 3.2, MySql 5.x

Middleware / Application Servers

Goldengate10g/11g,Weblogic Server 11g/12c,OIM/OAM,Oracle10g Application Server

Application / UML Modeling

Erwin,Designer 10g/6i 2000 Case Tools, Magic Draw, MS Visio

Development Tools / Environments

Hyperion Essbase,Planning

Oracle Developer Suite (10g, 9i, 6i, 2.1)

Oracle PL / SQL

Oracle 10g AS Portals

Oracle Business Intelligence(Discoverer)10g, 9i,Oracle Data Integrator

IBM Cognos

GeoMedia tools

Version Control Systems

Oracle SCM,CVS

Programming languages

Pl/SQL,Shell Scripting,J2EE (Servlet,JSP), Cold Fusion, FrontPage, HTML

Other Tools/ETL Tools

ODI 11g,Hyperion Essbase,TOAD,HP-OpenView

Virtualization /Emulation

vSphere, ESX Server, ESXi Server, Workstation, Fusion,Virtual Box

Training Courses

Oracle Exdata 11g Eseesntials

Eclipsys Solutions

Hyperion 11g Essbase

Eclipsys Solutions

Hypperion 11g Planning

Eclipsys Solutions

Oracle GoldenGate 10g Fundamentals

Riyad Bank

Workshop PLUS - SQL Server 2005 for Administrators

Microsoft Corporation

Java Programming

Oracle EMEA Cairo-Egypt

Build J2EE Applications

Emakacademy Cairo-Egypt

Oracle Designer 2000

NATCOM (National Computer System Company)

Introduction to Unix &TCP/IP

Shaheer Net Riyadh –K.S.A

Oracle DBA

ITCC (International Training& Consultancy Center)

Oracle Forms4.5,Report4.5,PL/SQL

ITCC Amman Jordan

Blogs and Publications

http://wiki.oracle.com/page/Oracle+RAC11g+R2+SINGLE+CLIENT+ACCESS+NAME-+SCAN

http://wiki.oracle.com/page/Extraction+and+Transformation+and+Loading+-ETL

Professional Experience

Feb 2014 - Present

Senior Infrastructure /Database Machine DBA

Regional Municipality of Peel

Brampton, Ontario Canada

Environment: Exadata X3-2, Oracle Database Appliance X4-2, Oracle 9i,10g,11g,12c,Oracle Linux6.x, Oracle Enterprise Manager 12c Cloud control, WebLogic Server 11g,12c, Oracle 12C RAC, ASM, WebLogic 12c,Oracle Data Integrator 11g,Oracle Hyperion 11.2.1.3,Oracle PeopleSoft 8.53, Oracle Utilities CC&B, Oracle Spatial,GeoMedia,windows 2008R2,2012,SQL Server 2005/2008/2012,EMC Data Domain Boost Backup.

Key Responsibilities:

Brought Lean and Six Sigma methodologies to the company to Standardize operations and improve equipment reliability which resulted in 57.7% decrease in rework steps

Supporting, managing over 90 Production instances.

Working closely with the Infrastructure teams (storage, network, Linux, backup) to develop a support model for Oracle Engineered systems (EXADATAX3-2, ODA X4-2).

Working closely with the Regional Service Delivery operation teams to perform training (KT Sessions with L2 and L3), support and optimize Oracle 12c infrastructure.

Participate in the design, build and deployment of a new Oracle 12c database service in order to cover all projects with a common service request, monitoring definition, backup and recovery strategy, and security, auditing in compliance with SOX/PCI policies.

Installing, Configuring, Administrating Oracle Utilities CC&B on Linux/Windows Platforms.

Upgraded Hyperion EPM 11.1.1.3.1 to EPM 11.1.2.2

Installed EPM 11.1.2.2 suite and configured HSS, Essbase, Planning, HFM, FDM, EPMA, FR, ODI

11g and Web Logic 11g on high availability servers

Migrated and took backups of different Hyperion applications across Development, Test and Production environments

Provided all the required Hyperion Administration and DBA support of all Hyperion components of the Essbase, Planning and Reporting systems - database servers, application servers, batch job servers, and file servers for the development, test and production environments.

Worked with GIS Developers closely and other clients to implement GIS web-based application utilizing Oracle Spatial GeoMedia tool.

Administration and maintenance, Troubleshooting and Performance tuning of 100+ SQL Server 2005/2008/2012 databases into multiple environments, and providing production support for 24X7 high availability environments.

Troubleshooting and supporting kofax Databases on SQL Server 2008/2012.

Configure Oracle Advanced Security on 12c databases to implement Transparent Data Encryption at tablespace, table and column levels. Also configured Redaction using OEM's Policy expression builder.

Engagement in Designing high level ETL architecture for overall data transfer from the OLTP to OLAP using SSIS for Peel Region Garbage Collection, and Salesforce clouding Applications

Configured Database mirroring and log shipping in the SQL Server instances as High Availability

Involved in building, moving, marinating SSIS packages between various environments.

Key Achievements

Key member of Engineered Systems (Database Appliances X4-2, ExadataX3-2) implementation team that conducted the initial proof-of-concept exercise and then implemented one of the first true Production implementations of three half-racks supporting.

Lead DBA role in 9i,10g,11g2 to 12c database upgrades on multiple database simultaneously

Aug 2013 – Feb 2014

Senior Database Specialist /Systems Consultant

Eclipsys Solutions ( George Brown College Project)

Toronto,Ontario Canada

Environment: Oracle Database Appliance X3-2,Oracle Linux5.x, Oracle Enterprise Manager 12c Cloud control, WebLogic Server 11g, Oracle 11g RAC, ASM, Oracle Database Appliance.

Key Responsibilities:

Installation and configuration Grid Infrastructure for Cluster database on four nodes on two Sites.

Racking Oracle Database Appliance on two Sites.

Configuring, deploying ODA Virtual platform.

Configuring, deploying Oracle RAC 11.2.0.4.

Configuring Virtual Machines on Virtual platform.

Key Achievements

Successfully Migrated Production Databases with Zero Downtime.

Jan 2012- Aug 2013

Senior Oracle DBA

Brainhunter Inc. (Zylog Systems Canada LTD)

Toronto,Ontario Canada

Environment: Linux RHEL,6.4, Centos 6.2,SAN Storage, AVAYA IVR Oracle Enterprise Manager 11g,Oracle11gR2 RAC, ASM, Oracle Secure Backup, Goldengate,PL/SQL, CVS,Toad, WebLogic 10g Application Server, MySQL 5.5,SQL Server 2008

Key Responsibilities:

Performed architecture and configuration analyses of DEV, QA, UAT,and PROD environments including: disk configurations and RAID levels to support OLTP and Data Warehouse applications, database initialization parameters and conformance to OFA guidelines

Installation and configuration Grid Infrastructure for Cluster database on six nodes.

Installation and Deploying Oracle GoldenGate 10g/11g in unidirectional and bi-directional modes.

Managed the setup and configuration of GoldenGate Director and Veridata.

Troubleshooting GoldenGate and fixing all business relations issues for unique/foreign key constraints and other conflicts for Data extraction / replication process.

Managed the migration from Oracle 10.2.0.4 to 11.2.3 for Development,QA,UAT,Production, Disaster Recovery Databases

Managing Very Large Database +1.5 TB.

Working closely with business and call center teams to analyze IVR functional requirements and gather change requests, convert into technical document and implement those based on schedule

Monitoring and maintaining the routine business cronjobs setup on the DB instances of various types.

Routinely refreshing non-production DB instances with Production DB data.

Integrating with external customers through SFTP/SSH file transfer to process batch job posting and other business processes using DB cronjobs calling stored procedures.

Implementing Informatica ETL data analysis /reports according to business/customer requests.

Provided Production Support in solving bugs reported about DB operations

Used CVS for change management and version control for rolling forward patches.

Developed a backup plan, including backup type, schedules, locations and capacity planning

Monitoring and optimizing database performance

Monitoring SQL server 2008 performance using profiler to find performance and deadlocks.

Analyzed SQL server 2008 long running slow queries and tune the same to optimize application and system performance.

Implemented Oracle TDE to satisfy PCI requirements for credit card data encryption.

Managing SQL2008 server disk space, memory and connections.

Maximum performance and uptime in production environment.

Installing and supporting IMAP/POP/SMTP email.

Setting up RAC disaster recovery and High Availability Architecture using Data Guard.

Implementing High Availability scenario for synchronizing Production databases data during the migration process with no data loses or services interruption using Goldengate 10g/11g

Optimizing Linux system operations and resource utilization, and performs system capacity analysis and planning.

Ensure that system hardware and software conform to organization standards and policies.

Key Achievements

Successfully Migration critical Production Database with Zero Downtime.

Primary DBA on day-to-day Oracle, SQL Server database administration efforts.

Provided support for all customers running Talentflow system, through their VPN connection

Mar 2011 – Jul 2011

Database Consultant

Talk2One

St. Catharine’s, Ontario Canada

Environments: Linux Centos, Oracle 11g,SQL Server 2008,CA ARCserve Backup, Erwin,CVS PL/SQL

Key Responsibilities:

Gather business and IT requirements for database development project.

Worked on research and analysis (including reverse engineering) for business development.

Installing and maintaining operational environment of Oracle, SQL databases.

Involved in writing PL/SQL, T-SQL codes for implement Stored Procedures and Functions for different tasks.

Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).

Created new database objects using T-SQL in Development and Production environment for SQL Server 2008

Developed a backup plan, including backup type, schedules, locations and capacity planning.

Key Achievements

Successfully automated a daily operations reports for champions

Mar 2007 –Feb 2011

Database Architect

Riyad Bank

Environment: HP-UX RX6600 Itanium,HP-UX.B.11,AIX, Linux Red Hat 5.1,SAN Storage, Oracle Enterprise Manager /Grid Control 11g, Oracle RAC11gr2/10gr2, ASM,Goldengate10g, Streams, Weblogic Server 10, PL/SQL, Toad, VERITAS, Tivoli Backup

Key Responsibilities::-

Engagement in business Infrastructure design and architecture with Oracle and suppliers.

Performed architecture and configuration analyses of DEV, QA, environments including: disk configurations and RAID levels to support OLTP and Data Warehouse applications, database initialization parameters and conformance to OFA guidelines

Engagement in upgrade and migration planning for more than 52 Oracle 8, 9i, 10g legacy databases to Oracle 11gR2 RAC 16 node environment, migration planning to ASM and RAC environments.

Implementing database vault and Encryption with Oracle TDE for client’s data redaction.

Worked on database performance tuning, data backup, recovery, architecture, security processes / procedures and Database auditing.

Participation for Setting up the disaster recovery and High Availability Architecture for DR Site using Data Guard, Goldengate10g.

Managed the setup and configuration, installation and deploying Oracle GoldenGate 10g in unidirectional mode.

Key Achievements

Primary DBA for the implementation of Oracle Data guard for a critical financial database onto DR Site, configured, deployed, tested and documented the Data guard setup and successfully conducted the switchover to the new live system. This work was done to a very tight deadline and schedule, without compromising the other project work

I was heavily involved in performance tuning at both the application and database,managing Service Delivery in accordance with SLA’s & OLA’s

Oct 2005-Jan2007

Senior Database Administrator

Agricultural Bank

Environment: HP-UX.B.11,AIX 5.L,Linux Red Hat3.8,SAN Storage, Oracle Enterprise Manager /Grid Control 10g, Oracle10gRAC, ASM, Replication(Streams), Designer 10g SCM,AS 10g,Oracle Secure Backup, PL/SQL, Microsoft SQL Server 2005,BizTalk,SCOM,HP-penView

Engineering, implemented, documented business Infrastructure design and architecture with HP architects

Provide 3rd level support for SQL Server 2005,Oracle RAC 10g Installation, patching, performance tuning, backup and recovery issues with RMAN/ Data Protector, trace analysis, manage 750Gb+ OLTP Database for Online Payment Transactions for a hundreds of concurrent users and Batch jobs in a 7x24 environment.

Implementing data redaction, and encryption, auditing.

Synchronized databases replication SQL Server and Oracle for Loans and Online Payment systems.

Key Achievements

After the loss of a schema in the largest financial database, I assisted in restoring their Primary database, worked closely with the other DBA’s and Sys Admin’s assigned to the task, working through the night and successfully bringing the database with 4 hours downtime .

Managing Service Delivery in accordance with SLA’s & OLA’s

Oct 2003 –OCT 2005

Database Administrator

Ministry Of Justice

Ministry Of Health

EBTTIKAR Technology LTD

Environment: AIX 5.L, Linux Red Hat,SAN Storage, Oracle Enterprise manager,Oracle10g RAC,RMAN, Designer 10g,PL/SQL,Erwin,Application Server 10g, IBM Cognos,BrightStor ARCserve Backup

Responsibilities:

Engineering, implemented, documented and support builds of multiple cluster nodes to use Oracle 10g RAC on IBM AIX Servers, Oracle Application Servers 10g on Linux.

Installation, upgrades, migrations, performance tuning, backup and recovery plan, SQL tuning, RAC HA disaster recovery strategy, proactive monitoring and troubleshooting, managing 200 Gb+ Oracle database in a 7x24 environment.

Worked in AES encryption in oracle 10g by using DBMS_Crypto package

Primary DBA for all Production, Development and Staging instances.

Participation in creating PL/SQL Packages, Triggers.

Key Achievements

Successfully migrated multiple schemas from versions 8 to 10g RAC and applications from two tier Architect to Multitier Tier Architect to make the enterprise applications more scalable and reliable.

Jul 1998 – Oct 2003

Database Administrator /System Analyst

Ministry Of Health - Organ Transplantation Center

National Computer Systems Co. (NATCOM)

Environment: Unix True64,AIX 5L,Oracle8x,Oracle Advanced Replications, PL/SQL, Designer 2000,Shell Scripting

Key Responsibilities::-

My responsibilities:

Installation and configuration Designer Repository, Implemented database Security

Implemented Database replication,disaster recovery strategy using custom written shell scripts

Duties Involved as: Senior Application Developer

Participation in the Design, development, deployment, testing and quality assurance of a various applications in the Ministry of Health for the Project of Organs Transplantation Center

Tools: Oracle 8.0.5 RDBMS Enterprise Edition and ORACLE Designer2000, Developer tools (Oracle Developer Suite 6i,10g,Toad)



Contact this candidate