Resume

Sign in

Database Administrator Technical Support

Location:
El Kelaa des Sraghna, Marrakesh-Safi, Morocco
Posted:
January 23, 2023

Contact this candidate

Resume:

Hikmat Attari

Churchill Meadows, Mississauga, ON L5M 7A7, Canada

e-mail:aduvgs@r.postjobfree.com Phone: 647-***-****

OBJECTIVE:

Seeking Oracle Database Architect/ DBA or Cloud Virtualization position (IaaS, DBaaS, PaaS) in Oracle Production environment implementing Oracle 9i/10g/11g/12c, RMAN, RAC, ASM, Active Data-Guard, OEM Grid-Control,OEM Cloud control 12c & 13c, Performance Monitoring and Tuning

SUMMARY:

Over Eighteen years of experience with Database and systems design, architecture, development, implementation and maintenance with multi-terabyte data warehouses and high availability transaction processing systems.

Extensive experience in implementing Oracle and Teradata physical data structures in Data-Warehouse for maximum database performance and implementing physical database models with Oracle (7, 8i, 9i, 10g, 11g, 12C, 18c and 19c)

Extensive Experience in Oracle Cloud and Virtualization support and Infrastructure design.

Extensive experience in Databases & Applications administration, installations, migration and upgrades including Oracle Financials 10.7 and 11i, IMS, SQL server and TERADATA Databases. This has involved database architecture/administration and management experience in RAC, Extended (Stretched) RAC, ASM and Data Guard environment. Additional extensive expertise in physical/logical modeling, data warehousing, project management, performance tuning, application integration/migration, data replication and transformation, application and Systems Support, data transformation and Networking. I am able to grasp and assimilate new technologies very quickly with virtually little or no external training or support. My experience cut across different organizations, which includes financial Banking, government, healthcare, retail & wholesale, telecommunications and business systems.

CERTFICATES:

Bachelor’s degree in Computer Science, University of Jordan

Oracle Certified Professional OCP - Database Administrator 8i, 9i, 10g, 11G and 12C cloud.

Oracle Enterprise Manager 12c Certified Implementation Specialist.

Project Management, Toronto, Canada

TRAINING:

Oracle Database 12c Installation and upgrade – Oracle University, Canada, Jan 2015

Oracle7/8/8i/9i/10g/11g/12c/18c/19c Database Administration and Data Modeling

Oracle Applications 10.7 (Financials) – Milwaukee, WI, USA, 1999

Oracle and Applications programming, administration and support (Designer/2000 and Developer/2000) - University of BirZeit 1995

TERADATA Training: Database Applications utilities and Administration - Toronto, Canada, 2006

Project Management Training: Project Management (12 Weeks) and Ms-Project 98 - LEF, Toronto, Canada, Oct 2004

UNIX Training: Shell programming and Administration SUN Microsystems Solaris 8, Solaris 9 and Solaris 10.

RDBMS Training : IMS Database, MPE-HP3000 Image and Query - Hewlett Packard.

Computer Networks and Routers Training - University of BirZeit, 1995

TECHNICAL SKILLS:

Databases: Oracle 7/8i/9i/10g/11g/12c/18c/19c, TERADATA, SQL-server 2000/2005 and IMS

DBA skills include: Oracle RAC & ASM Administration/Installation, Performance Tuning & Capacity monitoring, Data Security, Database Partitioning RMAN Backup & Recovery, Failover and Load balancing, Data-Guard DR Standby and Veritas.

Cloud and Virtualization, Oracle Virtual Manager (OVM), Oracle virtual server OVS and Oracle Virtual Machine (VM) virtual box.

Oracle cloud OVM, OVS, Xen and VM Agent, Red-hat Linux

High Availability: Sun Cluster, Red Hat Linux Clustering and IBM Aix HA cluster.

Expert level in OEM 12c, OEM13c Cloud Control implementation.

DB Utilities: Oracle Enterprise Manager grid (OEM), OEM cloud control 12c & 13c,Server manager, Import/Export Utility, SQL Net configuration, SQL*Loader,Table and Index partitioning TOAD, RMAN, Teradata Tools, TKPROF, Exceed, Erwin, SmartDB, Quest, Commvault, Power point, CIDM, Outlook, MS Project, SharePoint and excel.

Operating Systems: Windows 2000/2003/2008, NT, DOS, UNIX (Solaris, HP, AIX) and Redhat Linux.

Applications: Oracle Financials 10.7, 11i and many 3rd party and customized applications.

PeopleSoft application and Tools.

Enterprise Automation job scheduler tools: IBM Tivoli, SharePoint, Remedy BMC, Tivoli, HP-service Now and Crontab.

Teradata Utilities and Tools: Teradata SQL Assistant, Teradata Administrator, Performance Monitor, Dynamic Workload Manager, FastEXport, BTEQ, MLOAD, TPUMP and FastLoad, BI query, Crystal Reports

Languages: SQL, PL/SQL, COBOL, PASCAL, FORTRAN, BASIC, Assembly, C and C++.

Professional Experience:

Project#25: Sr. Oracle DBA

Nov 2021 - Current

Payments Canada

Responsibilities:

Accounts and users’ IDs management in DB vault environment that includes Oracle 12c and 19c Multitenant container environment.

Database and users access security that includes users, profiles, passwords, roles, permissions and login.

Oracle database 19c container Installation and PDBs creation on Exadata appliances for OEM repository.

Applying PSU security patches as required.

Supporting and troubleshooting Golden Gate Basics and Microservices.

Implemented Golden Gate plugin in OEM 13c for monitoring.

Upgraded oracle Enterprise Manager (OEM) from 12c to 13C.

RMAN for Backup and recovery and database refresh.

Data refresh among various environment using Data pump Expdp & Impdp.

Performance tuning for fast response.

OEM setup for monitoring Targets in Production, Staging and Development environments.

Created Service requests with Oracle support for resolving issues and fixes.

Project 24:

SR. Oracle Database Administrator

Aug 2020 – Nov 2021

IBM / Payments Canada: NS Halifax.

Responsibilities:

Managing users and database security in oracle 12c environment.

Upgraded Oracle Database from 12.2 to 18C and 19C.

Applied required patches on Oracle database 18c and 19C.

Implemented Security Hardening on 19C database.

Provided technical support to all ITIL process owners and performed audits on process.

Coordinated with customers to develop ITIL process strategies for design.

Integrated Active Directory with Oracle 19C for CMU Centrally Managed Users.

Troubleshooting and tuning 19C database for better performance.

Configured Data Guard for High Availability in 19C.

Validating Site Switchover for 19C database.

Standby database creation and monitoring to make sure it is in Synch with Primary.

Physical RMAN Database backup and recovery and database refresh.

Monitoring storage, archiving, back-up and recovery procedures are functioning correctly.

Oracle Database Performance and Tuning, incidents and alerts coming through OEM including ADDM and AWR reports.

Project 23:

SR. Oracle Database Administrator

Nov 2019 – Jul 2020

Hpe/DXC/CIBC Bank

Responsibilities:

Supporting Database instances and Cognos software in DEV and PROD environments in Redhat Linux.

Monitoring performance and configured oracle parameters for better performance and fast query response.

Monitored storage, archiving, back-up and recovery procedures are functioning correctly

Managing users and database security in 12c environment.

Provided technical support to all ITIL process owners and performed audits on process.

Coordinated with customers to develop ITIL process strategies for design.

Integrated Active Directory with Oracle 19C for CMU Centrally Managed Users.

Troubleshooting and tuning 19C database for better performance.

Configured Data Guard for High Availability in 19C.

Validating Site Switchover for 19C database.

Standby database creation and monitoring to make sure it is in Synch with Primary.

Physical RMAN Database backup and recovery and database refresh.

Monitoring storage, archiving, back-up and recovery procedures are functioning correctly.

Oracle Database Performance and Tuning, incidents and alerts coming through OEM including ADDM and AWR reports.

Change requests implementations in PROD, resolving Incidents and users requests.

Creating and maintaining database security including users, roles, permissions, profiles, passwords and schema accounts.

Analyzed and recommended improvements to all new systems and ITIL processes.

Developed and documented various ITIL standards.

Troubleshooting and fixing users and applications connectivity issues.

Project 22:

SR. Oracle Database Administrator

Sep 2019 – Nov 2019

Societe General Bank

Montreal, QC

Responsibilities:

Upgraded Oracle Database from Oracle 11.3.4 to Oracle 12.2 multitenant container database in Oracle Real Application Cluster (RAC) configuration.

Verified Oracle OEM 12c & 13c cloud control for monitoring and email notifications

Documented the database upgrade steps from 11.3.4 to 12.2 implementation plan.

Migrated database to Oracle cloud.

Reviewed and documented hardware requirements associated with the database upgrade.

Physical RMAN Database backup and recovery and schema export import.

Project 21:

SR. Oracle Database Administrator

May 2019 – Sep 2019

Seneca College

Supported Database instances and PeopleSoft software R9.0 environments (DEV, QA, PPRD) .

Tuned PeopleSoft application and database for better performance of OLTP and batch jobs.

Configured Replication and Data Guard for high availability and performance.

Database and schema refresh that includes PeopleSoft application refresh.

Standby database monitoring to make sure it is in Synch with Primary.

Physical RMAN Database backup and recovery.

Upgraded database 12c to 18c, 19c and applied required patches.

Manage database 11g and 12c instances including Space management, performance optimization, creation of service requests SR with Oracle Support.

Provided technical support to all ITIL process owners and performed audits on process.

Coordinated with customers to develop ITIL process strategies for design.

Manage database instances including Space management, performance optimization, creation of service requests with the vendors (Oracle, PeopleSoft), resolved any infrastructure or network issues related to the database, ensured proper backups and recovery and resolving any trouble tickets associated with the pre- or post-upgrade database environments.

Installed, supported, maintained and patched PeopleSoft and Web-logic middle-tier environment.

Supported end users and monitoring user access and security using OEM.

Monitored performance and configured oracle parameters for better performance and fast query responses to users

Monitored storage, archiving, back-up and recovery procedures are functioning correctly.

Oracle Database Performance and Tuning, incidents and alerts coming through OEM including ADDM and AWR reports.

Project 20:

SR. Oracle Database Consultant

Mar 2018 – May 2019

Humber College

Supported Database instances and software environments (Oracle Homes) in all of the environments (DEV, QA, PPRD, PROD) .

Upgraded Oracle Database from 10g, Oracle 11.3.4 to Oracle 12.2 and 19c multitenant container database for Banner application in Oracle Real Application Cluster (RAC) configuration.

Upgraded OEM 12 to OEM13 cloud control and configured alert, notification and integrated with BMC Remedy.

Configured Replication and Data Guard for high availability and performance.

Implemented Oracle OEM 12c & 13c cloud control for monitoring and email notifications

Documented the database upgrade steps from 11.3.4 to 12.2 in implementation plan before the upgrade.

· Manage database instances including Space management, performance optimization, creation of service requests with the vendors (Oracle, Elucian Banner), resolved any infrastructure or network issues related to the database, ensured proper backups and recovery and resolving any trouble tickets associated with the pre- or post-upgrade database environments.

· Developed and executed test plans to verify database upgrades completed successfully and that existing applications continue to function normally.

· Reviewed and altered hardware requirements associated with the database upgrade.

Supported end users and monitoring user access and security

Monitored performance and configured oracle parameters for better performance and fast query responses to users

Analyzed and recommended improvements to all new systems and ITIL processes.

Developed and documented various ITIL standards.

Monitored storage, archiving, back-up and recovery procedures are functioning correctly

Project 19:

SR. Oracle Database Consultant

The Government of Canada Public Services of Canada PSC -Ottawa

Jun 2017– Mar 2018.

Installed, configured and tested Oracle Enterprise Manager cloud control 13c

Installed OS Linux RHL Enterprise R7

Installed Oracle 12.2.0.2 on Linux RHL R7 environment.

Migrated / upgraded databases from Oracle 11g on HP-Unix to Linux R7 and Oracle 12c using Export /Import method

Migrated databases from Oracle 11g on HP-Unix to Linux R7 and Oracle 12.2.0.2 using Transportable Tablespace method

Troubleshooting and fixing OEM 11g issues.

Reviewed and updated Data Centre Services Reference Architecture Document (RAD)

ASM Storage SAN Disk Move for Data Centre Relocation project

Installed OEM 12c and upgraded to 13c.

Installed OEM cloud control and oracle VM Manager Management and Life cycle Packs.

Created many reports using BI publisher and created custom BI and EM reports.

Installed and supported Microsoft SQL 2008-2016.

Analyzed and recommended improvements to all new systems and ITIL processes.

Developed and documented various ITIL standards.

Main tasks is monitoring, validating and tuning database performance, to meet SLA performance SLA objectives.

Data Centre Relocation tasks.

Created multiple VMs, VLANS and virtual storage in Vmware virtual environment..

Project 18:

Oracle SR. DBA consultant

CIBC Bank /HPE Project

Jun 2016- Jun 2017 (12 months).

Lead and provided subject matter expertise in production and non-production databases for data development, maintenance ensuring consistency & integration with existing database infrastructure.

Manage database distribution, configuration, security, and access requirements using OEM 12c and command line interface.

Installed OEM 12c and upgraded to 13c.

Installed OEM cloud control and oracle VM Manager Management and Life cycle Packs.

Created many reports using BI publisher and created custom BI and EM reports.

Installed and supported Microsoft SQL 2008-2016.

Main tasks is monitoring, validating and tuning database performance, to meet SLA performance SLA objectives.

Lead reporting, performance/capacity planning, performance tuning, backup and restore

I used Job scheduler tool Cisco Tidal to schedule unattended backup and batch jobs among distribute environment and controlled them from Cisco Tidal centralized master server.

Provided leadership & technical expertise to ongoing problem identification/resolution & root cause analysis process form database environments.

Logged and documented production incidents; identify recurring problems and recommend preventative measures.

Analyzed and recommended improvements to all new systems and ITIL processes.

Developed and documented various ITIL standards.

Oracle Database Performance and Tuning, incidents and alerts coming through OEM including ADDM and AWR reports.

Oracle RAC, Data-Guard implementation and administration

Provided production database administration of Oracle 10g/11g/12c/Exadata databases.

Oracle database 12c and OEM setup, implementations, configurations, patching and upgrade.

Used OEM 12c for System monitoring and technical support of technical infrastructure as well as working with multiple technical support teams.

Previous experience and working knowledge of systems management disciplines and operations tools (automation, scheduling, monitoring, problem, change, configuration management etc.)

Information Technology infrastructure performance analysis skills

Service Center, HP OpenView, and OEM 12c cloud control.

Analyzing and investigating potential problems as described on incident management tickets to determine root cause, take the necessary action or escalate when necessary.

Analyzing and ensuring information on request for change tickets are clear prior to execution, closing the ticket with details of actions upon completion.

Tracking & understanding all production & testing environments for their clients data structure, volumes, disk allocation & performance.

Receiving critical alerts, which could be generic and caused by several factors; this requires in-depth analysis to determine the root cause in order to resolve the problems.

Assessing the impact of errors/problems based on timing and situation to determine the most appropriate decision and course of action.

Creating and maintaining database security including users, profiles, passwords and schema accounts

Logical database and schema export /import

Physical RMAN Database backup and recovery

Performance tuning troubleshooting

RAC troubleshooting and support.

Data guard maintenance and support

Generating AWR and ADDM reports.

Monitoring and fixing scheduler database jobs

Executing reports and queries as requested by developers and business teams.

Database, Listeners and connections availability.

Space management on ASM, File systems and Database levels.

Fixing AutoSys scheduled jobs failures

Troubleshooting database performance, health check, locks, blocking and hung sessions.

Checking and maintaining database and archive log space

Project 17:

Oracle Database Consultant

HCL, Rogers Telecommunications: Datacenter migration (4500 servers)

Feb 2016-Jun 2016

Analyzing, evaluating, planning, estimating and communicating software upgrade installation and impact as well as completing database migration and upgrades.

Oracle Enterprise Manager (OEM 12c) cloud control Installation,Upgrade, architecture and redesign to support over 100,000 targets.

Installed OEM 12c and upgraded to 13c.

Installed OEM cloud control and oracle VM Manager Management and Life cycle Packs.

Created many reports using BI publisher and created custom BI and EM reports.

Installed and supported Microsoft SQL 2008-2016.

Main tasks is monitoring, validating and tuning database performance, to meet SLA performance SLA objectives.

I used Job scheduler tool Cisco Tidal to schedule unattended backup and batch jobs among distribute environment and controlled them from Cisco Tidal centralized master server.

Database migrations between different version, releases, platform and instances.

Using enterprise incident and solution management tools to manage and track resolutions such as OEM, HP-Site-View, MAXIMO and ITSM.

Analyzed and recommended improvements to all new systems and ITIL processes.

Developed and documented various ITIL standards.

Advanced experience with Oracle Enterprise Manager to manage databases and all infrastructure environments. MASS agent deployment for monitoring hundreds of thousands of targets including applications, databases and middle tier web-logic and web-sphere.

Troubleshooting and supporting Oracle 8i, 9i, 10g, 11g and 12c database RAC and Data-Guard software, application tuning and resolving performance issues.

Administering, Troubleshooting and Supporting Oracle on Exadata box.

Project 16:

Oracle Database Consultant

The Government of Canada Ontario Public services (OPS) IT cyber security

Aug 2015 – Jan 2016

The main responsibilities are:

Oracle 12C Installation, Upgrades and batch jobs performance tuning

Data base backup and recovery using RMAN.

Creating virtual machines for Oracle 12c RAC installations.

Installed and implemented OEM 12c and upgraded to 13c.

Installed OEM cloud control and oracle VM Manager Management and Life cycle Packs.

Created many reports using BI publisher and created custom BI and EM reports.

Installed and supported Microsoft SQL 2008-2016.

Main tasks is monitoring, validating and tuning database performance, to meet SLA performance SLA objectives.

MYSQL cluster installation and EnTrust application setup to use MYSQL database.

Data conversion and Migration from Oracle to MYSQL database.

Troubleshooting and resolving performance issues.

Project 15:

Sr. DBA consultant/Team Lead

PARSONS Canada, DELCAN USA

Jul 2014 – May 2015

Main Responsibilities:

Database migrations between different versions/releases 10g,11g, 12c and instances development, UAT, QAT and Production.

used advanced database tools such as replication,ASM, RAC, Active Data Guard

Managing more than 100 users, Proxy user, roles, privileges, accounts and connectivity methods in redhat and sun solaris 8, solaris 9 and solaris 10.

Managing RMAN database backup and recovery policy, jobs and scripts.

Monitoring and auditing database usage and access using SQL scripts.

Database backup and recovery and standby synchronization.

Performing the Daily tasks for supporting, maintaining the applications and database according to business needs.

Installed, supported and implemented OEM 12c.

Installed OEM cloud control and oracle VM Manager Management and Life cycle Packs.

Created many reports using BI publisher and created custom BI and EM reports.

Installed and supported Microsoft SQL 2008-2016.

Analyzed and recommended improvements to all new systems and ITIL processes.

Developed and documented various ITIL standards.

Main tasks is monitoring, validating and tuning database performance, to meet SLA performance SLA objectives.

I used Job scheduler tool Cisco Tidal to schedule unattended backup and batch jobs among distribute environment and controlled them from Cisco Tidal centralized master server.

Delcan, Caltrans and VDOT projects: Data archiving and Migration.

Reclaim unused space from OS, Tablespace and Data files levels and created SQL scripts to automate the process.

Supporting, maintaining and repairing databases on HD-Mobile units and Cognos.

Disaster Recovery planning and testing.

Creating and scheduling database and applications activity jobs.

Database and schema refreshes from PROD to QAT, UAT, DEV and Test environments according the needs.

Remotely supporting Parsons and DELCAN projects, data migrations and capacity planning in PA, HI, NJ and CA.

Supporting the development team in creating database objects, running script, creating accounts, roles, privileges and resolving performance issues.

Supporting applications new releases promotions and deployments and verifying the Rollback PL/SQL scripts are functioning correctly before the deployments.

Making sure that we are meeting SLA with our clients.

Working with the middleware (WebLogic, WebSphere, and Portal) administrators to resolve configuration, performance hanging and interface issues.

Working closely with the infrastructure teams and heling with network, storage and hosts setup.

Implemented SECURE_LISTENER registration for security purpose.

Planning, Design, documenting and Upgrade of Oracle RAC database, ASM and RAC from 11gR2 to 12c with minimal downtime using Transient Standby database method.

Performing Oracle Software RDBMS, GRID and cluster installations, patching and upgrades.

Creating and scheduling SQL and shell scripts for collecting Database, ASM and Cluster information for auditing, Monitoring and resolving performance issues.

Project 14:

Oracle Database and Cloud Virtualization Consultant:

Government of Canada –Saskatchewan

Jan 2014- June 2014

Installed, configured and upgrade Oracle OVS, OVM and OEM12c for cloud and Virtual environment.

virtualization using Hyper-V and Oracle cloud (IaaS, DaaS, PaaS)

Assembly and template VM management.

Implement new features and bugfix in Oracle VM dom0 Linux kernel.

Oracle VM is a high performance server virtualization software. The hypervisor is built on Xen and it leverages Linux as the control domain.

Working on debuggers to help debugging Linux X86 guest on Xen.

Working on Transcendent memory project which can optimize memory usage and improve performance for Linux running on Xen.

Installed OEM 12c and upgraded to 13c.

Installed OEM cloud control and oracle VM Manager Management and Life cycle Packs.

Created many reports using BI publisher and created custom BI and EM reports.

Installed and supported Microsoft SQL 2008-2016.

Main tasks is monitoring, validating and tuning database performance, to meet SLA performance SLA objectives.

Red-Hat Linux X86 kernel patching/customizing/compiling.

Red-Hat Linux operating system installation internals.

Oracle database migrations between different versions/releases 10g,11g, 12c and instances Development, UAT, QAT and Production.

Helped with SAN administration

Provided Infrastructure design and architect documentations for Disaster Recovery and High Availability in cloud Virtual environment.

Patching Enterprise Manager, Plug-in, OVM, Linux x86 (YUM) and OV Servers.

OMS, WebLogic and middleware installation and upgrade.

Cisco Networks, VLANS and EMC storage setup and configurations. I used Job scheduler tool Cisco Tidal to schedule unattended backup and batch jobs among distribute environment and controlled them from Cisco Tidal centralized master server.

Integrating OEM with OVM Plug-in and Appliances.

Administered and supported Oracle Cloud and Virtualization’s Full Stack Storage, Network, OS, Database, Virtual Servers, Virtual Machines, Guest and API.

Architect high-performance systems for optimal database and systems usage and SQL performance tuning and resolving slowness issues.

Host replication and synchronization, Automatic and manual fail-over strategies

Cloud, self-service, auto-provisioning, life-cycle management

Consolidation (servers, storage, networking) Imaging for faster turn-around of new systems

Optimal resource management, no wasted idle resources

Automated failover of downed systems using SQL and Shell scripts.

Deliver technical documents including technical case studies, best practices guides, and solution reference architecture to drive adoption of SaaS for the business divisions of customers.

Provide solution system designs, redesigns for platform, performance and integration of new technical features and capabilities, etc.

implementation of an IT Disaster Recovery, Server and Virtual machines Live migrations of hundreds of servers in high-availability and fault-tolerance Virtual Infrastructure.

Configured and supported IaaS, PaaS, DBaaS, SaaS, and all other cloud services in Public, Private and Hybrid cloud.

Project 13:

Sr. Oracle Database Architect:

Government of Canada (AANDC), Ottawa

Jun 2013 – Dec 2013.

The main project is Database Character set migration/Conversion from Single-Byte WE8DEC to Multi-Byte AL32UTF8.

This includes:

Database objects, data dictionary objects and data analysis by writing SQL and PL/SQL procedures.

Supporting Databases for PeopleSoft and e-business R11i environment.

I work closely with the Applications developers since the character set migration of a database, especially from a single-byte to a multi -byte character set may have a significant impact on applications using this database.

Day-to-day DBA tasks and activities in Windows, Linux and UNIX environments that include:

Database creation and Cloning using RMAN, Data Pump and Export/Import methods.

PeopleSoft, SAP and e-business schema refreshes from PROD.

Installed OEM 12c and upgraded to 13c.

Installed OEM cloud control and oracle VM Manager Management and Life cycle Packs.

Created many reports using BI publisher and created custom BI and EM reports.

Installed and supported Microsoft SQL 2008-2016.

Main tasks is monitoring, validating and tuning database performance, to meet SLA performance SLA objectives.

Database, servers and storage sizing and capacity planning.

Managing security, DB-Links, Jobs, Materialized views and users accounts.

In depth using Remedy BMC, Test Track, CIDM, OEM, TOAD and SQL/PLSQL developer utilities and Tools.

Applications data refreshes from Production to Dev, Test, UAT, Production Support and QUAT environments.

Troubleshooting and resolving Performance and timeout issues by creating Materialized views, SQL tuning and DB-links.

Creating and scheduling Jobs using scripts and OEM Grid Control to automate many DBA tasks and MVIEWS Refresh.

SQL and PLSQL performance tuning and troubleshooting.

Creating and analysing AWR, ADDM, Explain Plan, Tracing and Active session History reports for tuning and Capacity planning.

Project 12

Sr. Oracle Database Administrator

PARSONS Canada ltd. Emission & Safety Projects

Aug 2012 – May 2013 (9 months)

Installing CRS and building new 11g Oracle databases using ASM and applying CPU and Bundle Patches.

Created and implemented Health-check Perl/ Shell scripts.

Databases and Application Upgrade.

High Availability, Business continuity, scalability, clustering GRID & load balancing

Hot Cloning or Online Cloning for Databases and Application with RMAN and Snapshots.

Disaster Recovery Design and Implementation in RAC, HA, ASM, Redhat Linux Clustering and Data-Guard environment.

Debugging, troubleshooting and performance tuning for Oracle PL/SQL scripts and stored procedures.

Installed and implemented RDBMS in Sun Solaris 8,Solaris9 and Solaris 10.

Installed OEM cloud control and oracle VM Manager Management and Life cycle Packs.

Created many reports using BI publisher and created custom BI and EM reports.

Installed and supported Microsoft SQL 2008-2016.

Main tasks is monitoring, validating and tuning database performance, to meet SLA performance SLA objectives.

Designed, developed and maintained data extraction and transformation processes and ensured that data is properly loaded and extracted in and out of our systems using Oracle PL/SQL scripts,ETL and ODS (Operational Data Store).

Evaluate, design, writing technical specification and shell scripts in Solaris 8, Solaris 9 and Solaris 10.

Oracle PL/SQL coding, tuning, and testing.

Performance review and



Contact this candidate