Oracle Management
Resume:
Mr. Darius Doddridge
Drive
Ottawa, ON K2C 2G8
*******@*****.***
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