Mr. Darius Doddridge

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

Drive

Ottawa, ON K2C 2G8

613-***-****

acc2i7@r.postjobfree.com

IT Related Experience 14 years

Security Clearance Secret

Profile

Mr. Doddridge is an Oracle Database Administrator with over 14 years

experience in IT.

Mr. Doddridge has extensive experience in Oracle version 11g, 10g, 9i, 8

and Oracle Real Application Clusters database related utilities and tools

and has data warehouse experience in Oracle 9i and 10g. He has the ability

to perform both database and operating system performance tuning and

monitoring and has knowledge of all backup and recovery techniques

Mr. Doddridge is excellent with communicating with management, development

teams, vendors and System Administrators to facilitate their needs,

provides a strategic database direction for the organization and is

proficient at handling multiple projects and deadlines.

Mr. Doddridge also has excellent knowledge of database security management

and data integrity and with the installation, configuration and upgrading

database software. He is able to quickly evaluate database features and

related products and establish and maintain sound backup and recovery

policies and procedures.

Mr. Doddridge possesses a security clearance at the Secret level.

PROFESSIONAL EXPERIENCE

Bank of Canada

1.

Oracle Database Administrator

May 2012 - Present

Project Description:

Canada's central bank is the nation's pre-eminent macroeconomic policy

institution.

Focusing on overall administration of physical database environments and

DBMS software infrastructure to support live production applications.

Ensuring a smooth transition from development to production of all related

on-going operational requirements.

Working closely with application developers, other DBAs and mid-tier

specialists. Primary responsibility is to ensure that the Oracle databases

are well maintained and compliant with evolving Oracle technology.

Participating in the delivery of the changes required to implement new

components and ensure their successful integration with the applications

and infrastructure.

Tasks Performed:

( Deliver assigned work on schedule, unless otherwise negotiated with

the Team Leader

( Support changes effectively and efficiently to ensure production

timelines are met

( Provide regular status reports to the Team Lead

( Give DBA support for Oracle databases versions 10g and 11g including

patchsets 10.1.0.5 to 10.2.0.5 and 11.1.0.6 to 11.2.0.4

( Define, document, and develop the test cases needed to address the

evolving technology

. Perform database tuning using Diagnostic and Tuning packs and Stats Pack

for production, development and testing environments

( Participate in the delivery of enhancements for the application

components being upgraded

( Supporting 11.2 databases setup in a Data Guard environment in

production and testing environments

( Provide ongoing support for the application databases

( Support and management of system landscape (dev/qa/production/bcp)

including

configuration / vendor patches

( Security and Authorization administration

( Provide support of databases in Solaris / Unix environments and

configure servers with the Server group

( Setting up OEM Cloud Control 12c for development, testing, stage and

production databases

( Monitoring and providing backup of databases using OEM 12c

( Backing up and Restoring databases using RMAN (including point in time

restores, full backups and restores and incremental backups

and restores)

( Migrating databases to other servers and refreshing databases from

production

( Installing new database software versions on new servers and

supporting new application upgrades and releases

( Communicate on a regular basis with clients, management and team leads

to complete projects, provide support and hold meetings

( Document DBA support of environment and provide training

( Client administration

( Supporting Middleware environments using SOA

( Administration of development keys

( Part of a database team supporting SQL Server 2012

. Performing backup and recovery of Oracle databases using RMAN

. Managing Oracle Grid Control

. Performing backup and recovery of Oracle databases using Datapump

Transport Canada

Project # 2

Oracle Database Administrator

November 2010 - March 2012 (1 year, 5 months)

Project Description:

The Database Management group (DM) supports and maintains the database

infrastructure for Transport Canada. Oracle is the departmental database

management standard with SQL-Server as a limited alternative. These

databases operate on clustered/shared UNIX, Linux and Windows servers. The

department has approximately 200 corporate databases in production, plus

numerous acceptance, development and training instances. DM works in

conjunction with application DBAs to develop and maintain the application

databases.

Tasks Performed:

. Provide production DBA services such as database analysis, database

management including but not limited to monitoring, performance tuning

and problem troubleshooting

. Participate in the delivery of technical support and expert advisory

services

. The delivery of database support for all application databases and DBMS

software tools

. Give DBA support for Oracle databases versions 10g and 11g including

patchsets 10.1.0.5 to 10.2.0.5 and 11.1.0.6 to 11.2.0.4

. Working with a DBA team supporting SQL Server 2008R2

. Involved in the delivery of access control of databases

. Perform database tuning using Diagnostic and Tuning packs and Stats Pack

for production, development and testing environments

. Analyze current situation and propose options for moving forward taking

into account Oracle Server future directions.

. Supporting 11.2 databases setup in a Data Guard environment in production

environments

. Develop database scripts or automation tools to assist database analysts

. Test, coordinate, and assist with the transition to new database

procedures

( Backing up and Restoring databases using RMAN (including point in time

restores, full backups and restores and incremental backups and

restores)

( Migrating databases to other servers and refreshing databases from

production

( Installing new database software versions on new servers and

supporting new application upgrades and releases

( Communicate on a regular basis with clients, management and team leads

to complete projects, provide support and hold meetings

( Document DBA support of environment and provide training

. Provide guidance to database analysts in relation to new database

procedures or tools

. Identify requirements for improvements to existing database systems and

procedures

. Supporting Middleware environments using SOA

. Provide support of databases in Solaris / Unix environments and configure

servers with the Server group

. Assist with disaster recovery solutions

. Give recommendations on access control for databases

. Using Oracle Advanced Security

. Providing general DBA services, database analysis, and database

management using Oracle 9i, 10g and 11g.

. Writing architecture and support documentation

. IT project management

. Analyzing and developing improvements to DBA Services, Processes and

Practices

. Managing Oracle Grid Control

. Using Oracle Diagnostic and Tuning tools for monitoring, troubleshooting

and optimizing Oracle databases

. Performing backup and recovery of Oracle databases using RMAN

Project # 3

Foreign Affairs and International Trade Canada

Passport Canada

Oracle Database Administrator

July 2009 - November 2010 (1 year, 5 months)

Project Description:

Passport Canada is responsible for issuing, refusing to issue, revoking,

withholding, recovering, and providing instructions on the use of Canadian

passports. It provides guidance to missions issuing passports abroad and

supervises all matters relating to Canadian travel documents.

Passport Canada has four regional operations: Western, Ontario, Central and

Eastern. There are 34 passport issuing offices across the country from St.

John's, Newfoundland and Labrador, to Victoria, British Columbia.

Tasks Performed:

* Uses Oracle Advanced Security to protect and encrypt data

* Monitors systems and runs diagnostics using Oracle Diagnostic and Tuning

Packs

* Installs Oracle Automatic Storage Management (ASM), Cluster and Real

Application Clusters (RAC), and performs raw device setup for ASM storage

and Cluster

. Installs and maintains Oracle Grid setup across multiple servers for

Production, Dev, Test, Training and Sanity test databases used for

Passports Facial Recognition environment

. Organized data into related structures/record types based on business

requirements

. Generates/creates new database, creates tables and fields

. Defined specifications so that the data could be displayed, or used in a

different format from the source data

* Creates User profiles and permissions and audits users, logins and

actions using Oracle Advanced Security

* Imports of data

* Performs database performance tuning and troubleshooting issues

* Monitors database performance (including consistency, response time, and

memory requirements) for production systems through OEM and scripting

Backing up and Restoring databases using RMAN (including point in time

restores, full backups and restores and incremental backups

and restores)

Migrating databases to other servers and refreshing databases from

production

Installing new database software versions on new servers and supporting new

application upgrades and releases

Communicate on a regular basis with clients, management and team leads to

complete projects, provide support and hold meetings

Document DBA support of environment and provide training

Provide support of databases in Solaris / Unix environments and configure

servers with the Server group

* Resolves performance issues through database and OS tuning

* Performs Production, Test and Development refreshes

* Provides RMAN database restores, including point in time restores (back-

up and recovery) and sets up and maintains full and incremental RMAN

backups

* Performs troubleshooting and administering for RAC production, Test,

Development and Sanity Test databases

* Assists with the design and model of the database environment,

performance tuning and troubleshooting issues

* Provides training and writes procedure and support documentation,

advising programmers, analysts, and users about the efficient use of data

* Sets up and maintains nightly backup of all production and test/dev

databases (roughly 120 databases in total) using RMAN

* Provides point in time recovery using RMAN

* Refreshes dev, test and staging environments from production using RMAN

. Assists with the design and model of the database environment for

Passports Facial Recognition System for dev, test, sanity test and

training environments, scheduling environment usage and ensuring projects

are delivered on time

. Maintains the data dictionary for the database updating lists of records

. Communicates effectively (in English) with team members, management,

developers and testers

. Resolves user conflicts by optimally organizing data to ensure efficient

access

. Organizes and leads meetings and projects, scheduling project milestones

and resources

. Develops disaster recovery and virus protection procedures

Project # 4

IBM (formerly Cognos Inc)

Oracle 8, 9i, 10g

Oracle Database Administration

March 2001 - June 2009 (8 years, 4 months)

Project Description:

IBM helped pioneer information technology over the years and it stands

today at the forefront of a worldwide industry that is revolutionizing the

way in which enterprises, organizations and people operate and thrive.

IBM's Cognos software provides business intelligence and financial

performance management to help clients make the decisions that drive better

performance.

The Cognos 8 platform underpins a broad range of performance management

capabilities such as reporting, analysis, scorecarding, dashboarding and

planning to provide complete, timely information to your diverse user

communities and ensure cost-effective scale as these communities grow.

Tasks Performed:

* Supporting hundreds of production, development, testing and staging

databases across a variety of operating systems

* Used Oracle Advanced Security to protect and encrypt data stored in the

database, the disk-based backups, and the network

* Monitored systems and ran diagnostics using Oracle Diagnostic and Tuning

Packs

* Implemented and maintained database security (create and maintain users

and roles, assign privileges) using Oracle Grid Control in an Oracle Grid

environment

* Performed database tuning and performance monitoring using/implementing

Oracle Grid Control in an Oracle Grid environment

* Gave 24-7 rotational pager duty support of all production environments

globally using Oracle Grid Control in an Oracle Grid environment

* Performed SQL and PL/SQL scripting

* Supporting SQL Server databases using SQL Server Management Studio for

multiple databases in production, development and testing environments

and in on-call rotation.

* Replication administration and setup using Oracle Streams between various

production environments

* Provided refreshes of production to development and test environments

using RMAN

* Set-up and maintained standards, writing documentation for procedures,

support and administration

* Planned growth and changes (capacity planning) based on forecast user

needs and system requirements

Communicate on a regular basis with clients, management and team leads to

complete projects, provide support and hold meetings

Document DBA support of environment and provide training

* Performed general technical troubleshooting and give consultation to

development teams

* Interfaced with Oracle Corporation

Backing up and Restoring databases using RMAN (including point in time

restores, full backups and restores and incremental backups

and restores)

Migrating databases to other servers and refreshing databases from

production

Installing new database software versions on new servers and supporting new

application upgrades and releases

* Performed code migration, database change management and data management

and data management through the various stages of the development life-

cycle

* Designed database and implemented an environment for Customer Support and

development in many different OS's for the development and support of

software for various database versions

* Performed 11i basic administration and production control

Provide support of databases in Solaris / Unix environments and configure

servers with the Server group

* Performed PeopleSoft administration and production control

* Performed database patching and upgrades

* Provided database services and support to R&D, Customer Services and

other organizations

* Provided technical knowledge support to all IS development teams advising

programmers, analysts, and users about the efficient use of data

* Provided Change Management support for IS applications environment,

improved database environment for developers. Creating common test

environment for Customer Support and Development and maintaining patches

and updates as needed.

* Projected needs of server and databases for various teams, planning

upgrades and scheduling system required system downtime

* Provided full coverage of application and database outages

(hardware/software upgrade, power and network)

* Installed, implemented, provided consultation on Oracle databases, and

installed many Oracle environments in UNIX operating systems

* Supported Oracle production databases in UNIX environments for Solaris,

HPUX, AIX and Linux

* Maintained development databases on common test environments and labs

* Provided RDBMS support (24/7 for Hotsite priority 1) for Oracle

* Performed technical troubleshooting, analysing the database and provided

consultation to development teams

* Administered and troubleshot RAC environment. Which included production

cluster, dev, test, staging and training environments.

* Performed database patching and upgrades

* Performed disk management and account creation

* Unix shell scripting

* Performed script monitoring through crontab

* Oracle command line administration

* Troubleshooting of connection and performance issues

* Performed CPU and Oracle upgrades

* Organizes and leads meetings and projects, scheduling milestones and

ensuring timely delivery

* Setup and maintained nightly backup of all production and test/dev

databases (roughly 120 databases in total) using RMAN and provided

point in time recovery using RMAN

* Monitored database performance for production systems through OEM

Resolved server performance issues through analysis of the database and OS

tuning and provided 24/7 pager duty monitoring, response and

troubleshooting

. Organized data into related structures/record types based on business

requirements

. Defined conversion specifications to ensure that converted data was

changed to the required format

. Finalized the strategy for converting the data including; finalizing the

upload procedures, timings and dependencies

. Generated new database, created tables and fields

. Maintained the data dictionary for the database, updating lists of

records

. Maintained configuration control and maintained the consistency of

system's performance with its requirements, design, and operational

information

Project # 5

Retter /Associated Software Concepts/Nortel

Database Administrator

September 1998 - March 2001

Tasks Performed:

* Tested corporate conversions of data

* Managed databases in a UNIX environment

* Performed troubleshooting, code migration and data management

* Performed database design and implementation

. Completed an analysis of the existing system to determine which data

needed to be converted and to determine the target specifications

. Defined conversion specifications that listed the required changes

. Performed capacity planning by forecasting users needs and system

performance requirements

. Maintained the data dictionary for the database, updating lists of

records

. Developed processes to be followed should data be found inaccurate, or

incomplete

. Performed database tuning and ensured functions performed on the data

would leave the data consistent, complete and accurate by implementing

standards and procedures for users to follow

. Resolved user conflicts by optimally organizing data to ensure efficient

access

. Implemented specific controls and security procedures for various

database platforms

EDUCATION

Software Development Graduate (1999)

Retter Business College. Ottawa, ON

PROFESSIONAL DEVELOPMENT

March 2006 - Oracle Backup and Recovery course at Oracle University.

Ottawa, ON

October 2005 - SQL Administrator course at Cognos Ottawa

October 2003 - IBM Informix Administrator course at IBM San Francisco

October 2002 - IBM DB2 Administrator course at IBM Ottawa.

May 2001 - Oracle Database Administrator course at Oracle University.

Ottawa, ON

Contact this candidate