SUMMARY

• Senior Database administrator with extensive hands on experience in planning and execution of major database environment implementations and managing technical teams. Innovative in providing effective technical reviews, Installation of new data structure backbone, planning and streamlining, technical support, process automation and process enhancement, performance tuning and project outsourcing to operational teams for long term support.
• Experienced in leading database teams in charge of mission critical projects, project and staff supervision, project and resourcing estimation, performance assessment for small and large teams in multi Terabytes database environments
• Experienced in planning and implementation of technical solutions in large IT warehouse environments, and administration of mission critical projects, project delivery for large scale production deployments and phasing major rollouts
• Extensive hands on experience in Oracle PL/SQL coding, database ETL and data warehousing
• Strong technical background in databases: Oracle (12cR1,11gR2, 11gR1, 10G, 9i, 8i), Microsoft SQL server (2008), DB2, MySQL, Cassandra, systems architecture and UNIX, Oracle Golden Gate
• Extensive hands on knowledge and skills for provisioning high availability and disaster recovery solutions, automation tools
• Proficient hands on skills with UNIX scripting (Korn and Shell)
• Proficient with Hadoop ecosystem, Hive, Pig, Hadoop installation and administration
• Skilled with R programming and Python
• Innovative in providing and implementing solutions for process enhancement, quality and performance assurance
• Excellent coordination skills and team management skills for planning and execution of parallel projects and optimizing team s effort and resourcing. Experienced in providing tangible reports on project status, forecasts milestones and managing stakeholders expectations
• Proficient with project management tools, PMI member, PMP certified, Certified Scrum Master
• Excellent communication skills in both English and French

PROFESSIONAL EXPERIENCE

DBA team lead

Confidential, San Francisco

Responsibilities:

• Managed and executed installation and configuration of Oracle 12.1.0.2 software and database for all database platforms. Provided requirements and installation documentation and trained client DBAs in installation of new databases.
• Upgraded Oracle 11.1.0.7 and 11.2.0.4 to 12.1.0.2. Used Datapump, RMAN convert, manual upgrade using upgrade scripts. Managed upgrade phases. Upgrade was from Windows 32 bits to Oracle Linux 6, from HP and Solaris to Oracle Linux 6. Trouble shooted many errors on the source environments.
• Installed Oracle Enterprise Manager 12C for monitoring databases
• Configured standby database for Oracle 12C, set up of data guard and test of disaster recovery by performing switchover and fail over activities.
• Provided run book for performing disaster recovery for 12c Oracle databases.
• As lead Oracle DBA was accountable for successful implementation of database rollouts and Go Live support for MBNA credit card project.
• The project consisted of building mission critical database environments (mostly Oracle 11gR2) and disaster recovery solutions, extensive DDL implementation on lower database environments, performance enhancement of batch jobs on production environments, set up of security solutions and backups,
• Assessing operational risk and providing risk mitigation solution for major application deployments, capacity planning and assessing required space/memory to ensure stability of the database environments, setting up process and communication plan for applying quarterly security patches, defining the implementation plan for fall back/fall forward testing (using either database import/export or rolling back to a restore point),
• Streamlining and providing the build book for database back up implementation using RMAN (backup to tape via media server), reporting on project build status and pursuing the database changes (to cover gaps from design requirements) until database handover to the business and remote supporting team.
• Upgraded Oracle 10g and 11gR2 to 12c and provided the roadmap and the run book for team’s usage
• Designed and provided implementation guidance on ETL operations. Provided technical support during application testing phases.
• Created and managed database wallets and TDE (Transparent Database Encryption) requirements
• Extensive hands on engagement with the application team in application deployment phases and performance monitoring and batch job performance tuning phases ( 17 hour batch job was cut to 5 hours and 20 minutes)
• Provided Application Portfolio Documentation, the run book and post hand over support documentation for all batch interfaces, and several major applications within the bank.
• Data gathering and follow - ups on production of these documents required both in-depth technical knowledge about the applications, the hardware and database components involved as well as being able to connect with the business and gather all business related workflow information, including contact information, escalation procedure, disaster recovery plans and high level incident management workflow.

Senior lead DBA

Confidential

Responsibilities:

• Senior lead DBA in charge of outsourcing project for level 1 support of bank database environments, trained local and off shore staff in their roles, hosted knowledge transfer sessions and supervised team members’ work as part of transition, to ensure their capability for continuation of support. Validated and maintained documentation for major processes and ensured team’s compliance with best practices including database performance, security and schema management
• Identified opportunities for reducing operational errors as well as operational cost through usage of automated solutions and process improvement
• Advising the senior leadership of the status of the department initiatives on a routine basis to promote transparency & collaboration and recommending the optimum mix for future resourcing
• Provided architectural level advice and all the automation code (SQL plus and korn shell scripts) to the “ZERO IMPACT BACKUP” project. The goal was to use the image copy of production server LUNs to perform the backup of production on a staging server rather than the production server itself. The automated solution for ZIB backup for Oracle 11gR2 database led to significant cost reduction, more reliable recovery solution, as well as increased backup performance and elevated the load on the production server.
• Coordinated different phases for testing of the automated backup solution. Gathered lessons learnt and meeting minutes.

Project coordinator

Confidential, Toronto

Responsibilities:

• Facilitated testing project definition and scope, Chaired meetings to sign off on clear project objectives and milestones and communication plan, planned testing strategy and steps for build ORT (Operation readiness test) QA testing and Cloud implementation project. The latter of which was the first IBM business initiative for implementation of Cloud technology in a large scale environment. Testing included gathering requirements, creation of testing strategy, detailed engineering of an optimal resourcing and scheduling strategy, creation of templates, hosting meetings with full participation of all parties, gaining clients approval for the plan, supervising actual testing sessions, gathering the artifacts, gaining client s sign off and agreements on all testing strategy plans and projects post - delivery maintenance documents and run books.
• Created and enhanced reporting templates in support of Project Delivery and Operational processes
• Provided and reported on detailed daily plan for conveying the QA tests (Operations Readiness tests).
• Monitored the flow of testing, maintained project plan and artifacts, arranged meetings and gathered lessons learnt for QA testing
• Defined the strategy for grouping and test plan for Cloud project for User Acceptance Test (UAT)
• Provided and implemented backup/restore scripts and implemented DB2 database backup solution
• Supported and trouble shooted database errors for Oracle and DB2 databases used in Cloud

Database lead / manager

Confidential, Toronto

Responsibilities:

• As senior database manager for a group of 15 local and 13 off shore DBAs led support strategy and guidelines for major infrastructure build, QA testing of the production builds, resource assignments, identification of requirements and risks, risk mitigation plan, coordinating meetings, liaising between the DBA team, the client and senior executives, reporting on multiple streams projects, logging signoffs and lessons learnt, defining new standards and ensuring team s awareness of the project governance, supervision of team s compliance with enterprise delivery framework, tracking changes and corporate standards, identification of continuous improvement opportunities.
• Acted as project escalation point for Go Live phase of major production environments. Used subject matter expert to evaluate risks and provide contingency plan for major production builds and changes. Planning and execution involved organizing team meetings and gathering inputs from several teams and continuously updating and re - evaluation of requirements to ensure compliance with project governance.
• Ensured consistency of database builds over more than 100 new data warehouse builds. Supervised the process of QA and later automated the health check process.
• Provided reports on project advancements to the higher managers and ensured timely delivery of project deliverables for large scale retail warehouse environment.
• Estimated resourcing requirements and maintained resource plan. Provided detailed requirements and timelines and the contingency plan for major production environment changes, including overnight implementations including multiple resources.
• Identified opportunities for project cost and error reduction and provided automated solutions to improve processes through standardization and automation of project delivery operational processes. Conceptualized, initiated and implemented automation of database build audit project which cut the 8 hours duration to 30 minutes and drastically changed reliability of build audits. Classified departmental activities and signed off on agreed SLA s, created scripts for delegation of portion of database activities to support center members as part of conceptualization of a structure of first call resolution. Provided training for support center members in the role for database first call resolution activities.
• Documented testing phases and lessons learnt and trained resources in the process of production QA testing. This process was to simulate loss of primary business database site and proving reliability of disaster recovery solution built by the database team. Winner of Above and Beyond award for commitment to business excellence.
• Incorporated standards for major production rollouts and changes, environmental upgrades, maintained standard operation documentation, monitored the compliance of team s builds with the standards and procedures.
• As a key member of process enhancement group, revised major project phases such as build and audits and provided process enhancement advise.
• Maintained resource calendar and scheduling for the team of local and off shore resources
• Supervised performance of DBA team, participated in conflict management, report performance on the teams efficiency to higher managers and acted as a liaison between technical team, higher management and clients to explain the new processes to be used by the team in order to ensure client s requirements are met
• Suggested new technical solutions for RMAN backup and restore to the client s team and coordinated QA tests to ensure reliability of high availability solutions
• Provided details database steps for production environment changes involving several technical units. Coordinated change execution.
• Acted as a single point of escalation for resolution of database technical challenges
• Provided detailed run book and timelines for database upgrades. This procedure was used as a standard enterprise document for all database upgrades.
• Interviewed resources, provide performance reviews and coaching and advised on strategies for increasing team s performance.

Senior lead Oracle DBA

Capgemini - loblaw account

Toronto

Responsibilities:

• Installed standby database and configured data guard in 10g environment
• Implemented automated solution for database backup procedure
• Installed and configured Oracle software, database and ASM and configured schemas
• Performed standby switchover and fail over tests to ensure maximum business continuity
• Provided installation documentation and build books conform with specifications
• Developed backup and restore schedule and scripts for Oracle and SQL and DB2 databases.
• Provided Shell scripts and SQL code to automate database installation and configuration audit
• Supported Oracle 10g and 11g on AIX 5.3 environment
• Installed RAC on Oracle 10g and 11g environments
• Configured database environments for Maximum Availability Architecture and disaster recovery site to provide for robust and reliable business backbone, used Oracle high availability features, RAC and Dataguard configuration and provided procedure for simulation of recovery from loss of production site.
• Provided installation documentation and build books conforming with client specifications and requirements for Oracle 10g, 11gR1, 11gR2 and RAC and data guard

Oracle DBA

Confidential, Toronto

Responsibilities:

• Prepared documentation and detailed DBA steps for installation of database, and build books conform with specifications
• Provided reports and work estimates and resourcing requirements estimates
• Reviewed and updated configuration items on Oracle software, database and ASM and schemas
• Performed standby switchover and fail over proof of concept to ensure maximum business continuity
• Wrote PL/SQL code and Unix Shell scripts to automate regular tasks to help minimize human error during run time

Oracle DBA

Confidential

Responsibilities:

• Recommended indexes and primary key and foreign key constraints and data model .Tuned SQL queries and indexing strategies.
• Upgraded Oracle database 9i to 11g and provided TDD (Technical Design Document) and installation build book, revised database security features, installed database vault, TDE (Transparent Data Encryption), PCI compliance, created Wallet and VPD (Virtual private database) configured realms for VPD
• Configured, installed and administered RAC on Oracle 10g environment
• Performed database restores and recoveries; provided and tested Disaster Recovery plan for production database
• Performed extensive ETL operations. Used sqlloader and PL/SQL coding
• Provided SQL tuning recommendations to development team
• Built scripts to automate and manage frequently requested activities such as refresh procedure which decreased refresh procedure duration from 2 hours to 10 minutes
• Implemented RMAN backup and recovery procedures to enable efficient cold and hot database backup with minimal human error and database downtime
• Installed Oracle 9i, 10g and 11g software and patches, provided trouble shooting during installation activities
• Configured Oracle Resource manager to ensure OLTP users get minimum required CPU resources
• Mapped old database model into new model and wrote SQL code to reflect the changes, provided documentation and planning for data load, data cleansing and data maintenance of old archived data

Oracle DBA

Accenture

Responsibilities:

• Refreshed/re - created database environments and performed promotion to production environment
• Created and configured standby databases, setup data guard as part of DR (Disaster Recovery) solution
• Installed Oracle database high availability feature of Fail Safe 3.3.4 on Oracle 9i environment
• Installed Oracle Database 9i on AIX and provided testing environments
• Installed Oracle 10g Redhad Linux and provided database monitoring scripts
• Built scripts and managed scheduled automated tasks for daily exports, backups and database maintenance tasks
• Managed password policies and audit reports compliant to SOX policies
• Ported unix shell commands to Windows to support and monitor database on NT environment
• Documented client's database s environments, database refresh procedures
• Created and successfully tested database backup and restored procedures, provided documentation
• Developed PL/SQL stored procedures based on client's needs

Oracle DBA

Confidential

Responsibilities:

• Installed and post configured Oracle Applications 11i server by means of Rapid Install
• Performed trouble shooting and Uploaded budget data to production Oracle Financials database using Oracle s General Ledger Open Interfaces, and automated this process with interactive UNIX shell and SQL*PLUS scripts.
• cloned E - business suite environment to provide testing and standby environment. Pre and post configured software requirements
• applied patches, created database users, used autoconfig, addadmin, adpatch and rapid clone
• Developed and enhanced administrative UNIX shell and Oracle scripts for proactive Database monitoring, maintenance and database backup
• Trouble shooted Quest STAT to integrate a global grid used by developers and project managers
• Installed Oracle, People soft tools 8.18, 8.45, Quest STAT for developers and assisted with their database connection, installed and administered Mircosoft SQL server 2005
• Performed Oracle applications 11i basic administration tasks
• Refreshed different environments / schemas using Oracle Import/Export tools
• Enhanced existing automating scripts
• Created /cloned new databases environments
• Followed up on customer tickets to meet SLA and minimize customers escalating
• Ran customer defined quarries against different databases
• Used Remedy ticketing system compliant with CHORUS standards
• Installed DST (Daylight saving time) proofing patches installations, provided documentation and step by step guides
• Assisted with tuning PL/SQL code, revised indexing strategy