[pic] [pic]

Benedict Asare

***-**** ******** ****, ******, Ont. K2G 5Y7

E-mail: acdzit@r.postjobfree.com Cell: (613) 266 - 0923

Objective: Seeking a position as an Oracle DBA or SQL Server DBA in a

challenging environment that makes use of my

expertise in database consulting. 18 years of experience

in Information Technology, 16 years as an Oracle

DBA, 10 years as SQL Server DBA and technical and

functional implementation of Oracle Applications and

database Consulting.

Profile:

. Secret Security Cleared

. Advanced knowledge of Oracle 8i, 9i, 10g & 11g database

administration and management

. Advanced knowledge of SQL Server 2000, 2005 & 2008

. Extensive SAP Basis administration experience

. Advanced knowledge Objectstar database architecture experience

. Great experience in working in a multi-disciplinary environment

. Experience in Oracle and SQL Server database administration,

development, performance tuning, reports

. Extensive knowledge in ATIPFlow/ATIPImage application on oracle

database on a unix platform

. Solid systems administration and project management skills

. Solid experience with Oracle RAC, Data Guard and Oracle GRID

implementation

. Advanced knowledge of Object Oriented programming languages

. Extensive experience in providing first level operational support

for a Relational Database Management Systems such as Oracle,

ObjectStar, Sybase, DB2 and MS SQL Server

Technical Skills

Operating Systems:

MS-DOS, SCO/UNIX, SUN/SOLARIS, WINDOWS, WINDOWS

95/98/XP, WINDOWS NT,LINUX 4.0

NETWARE 3.X/4.X, WINDOWS 2000 & 2003, UNIX (HP & TRU64)

Software:

JAVA, CGI, ORACLE DBA V10G, ORACLE DBA V9, ORACLE DBA V8,

DESIGNER/2000, REPORTS

ORACLE FORMS, SQL*LOADER, ERWIN 3.5, SQL*NET, PL/SQL, ORACLE CASE,

ORACLE DATA WAREHOUSE BUILDER, ORACLE DESIGNER 6i, OAS 10g, PL/SQL

PROGRAMMING, CRYSTAL REPORTS, WEBSERVER, VISUAL BASIC, C++, FORTRAN,

SAP, HTML, SQL SERVER 2000, MS ACCESS, SYBASE, RDIMS, ORACLE OLAP,

JDEVELOPER, TIVOLI, EXCEED, OBJECTSTAR

SMART DBA, ORACLE STREAMS, EM GRID CONTROL, SQL SERVER 2000 & 2005

Networking:

PEER-TO-PEER, CLIENT-SERVER, LAN, MAN, WAN, INTERNET

TECHNOLOGIES, TCP/IP

ENTERPRISE SYSTEMS INTEGRATION

Work Experience

Aboriginal Affairs and Northern Development Canada

September 2012 - Present

Position: Senior Oracle DBA

. Managed application support, maintenance, created logical and physical

data layout, table re-organization, installing patches, upgrades,

monitoring and tuning of over 70 databases

. Implemented database standards and naming convention for the database

objects

. Applied patches and service packs to keep the database at current

patch level

. Implemented SQL standards in writing Stored procedures, Triggers,

Views, Sql functions and locking issues

. Designed and implement database logical and physical Schemas using

Erwin 3.5.2./4.0

. Responsible for configuration of Microsoft Server/Client Products and

implementation

. Setup and Created RMAN (recovery manager) for backup and restore

activities

. Responsible for installation of Oracle database creation and building

and scheduling jobs for maintenance

. Performed database re-organization as required for performance

optimization

. Supported development effort by providing SQL statement tuning and

optimum data loading

. Setup Oracle 11g GRID from scratch for monitoring of Dev and

production instances

Public Works and Government Services Canada

November 2011 - July 2012

Position: Senior SQL Server DBA

. Upgrading and upsizing databases from earlier versions to the latest

versions

. Writing code and creating jobs to automate repetitive tasks

. Implementing and administering database replication between SQL Server

databases

. Troubleshooting performance issues and fine-tuning queries and stored

procedures

. Installing, configuring, administering and securing our clients'

production servers

. Going through the clients' requirements and coming up with database

design

. Providing advice and guidance to peers on database features

. Developed Windows scripts to manage and automate Microsoft SQLServer

database functions such as backups

. Installing and configuring Microsoft SQLServer 2000, 2005 or 2008

. Successfully resolving SQL Server problems in conformance with SLAs

Citizenship and Immigration Canada

November 2007 - September 2011

Position: Senior Oracle DBA & SQL SERVER DBA

. Provide database administration on Oracle production, testing and

development database servers

. Estimate Storage requirement, Creation of Tables and users for Sybase

development databases

. Daily support of ATIPFlow/ATIPimage on Oracle database backend

. SAP Unicode upgrade on an HP-UX box with an oracle database back-end

. Supported Sybase Development databases and wrote stored procedures for

Sybase Apps.

. Migrated SAP/Oracle data from an HP-UX server to an HP-Itanium server

. Upgraded ATIPFlow backend Oracle database from 9.2.0.7 to 10.2.0.4

. Upgraded all the SAP/Oracle databases from 10.2.0.5.0 to 11.2.0.2

successfully

. Clone/Refresh of Oracle Production databases to Testing and training

environments

. Developed/customize UNIX shell scripts to automate routine Oracle DBA

tasks of taking backups, exports and monitoring space

. Creation of Oracle databases objects like tables, indexes, stored

procedures, snapshots and views

. Monitor and Tuning of Oracle and SAP Database Performance by using

various optimization techniques

. Performed day-to-day DBA jobs for managing Oracle and ObjectStar

databases

. Setup and Created RMAN (recovery manager) for backup and restore

activities for Oracle development and testing databases which is in

the process of being rolled out to Oracle production databases.

. Created a self-tuning procedure for adjusting SGA memory components

based on application processing needs

. Tuned database parameters for a large monthly Oracle / SAP refresh

jobs for good performance

. Troubleshooting ATIP Flow problems and optimizing database

performance.

. Provide On-Call support for ATIP Flow, SAP ERP 6.0 production

Databases on rotation basis

. Responsible for supporting Oracle databases including troubleshooting

issues and resolving issues

. Responsible for installation of SQL Server, database creation and

building and scheduling jobs for maintenance of all databases

. Upgraded and created unix scripts to monitor Objectstar databases

. Monitored Oracle and ObjectStar databases for errors and space issues

Nova Networks, Ottawa, Ontario

August 2007 - November 2007

Position: Senior Oracle DBA & MS SQL Server DBA(consultant)

. Implemented Oracle 10g Enterprise Manager to monitor and tune Oracle

Instances

. Developed backup procedures, which include Hot and Cold backup

. Trained client MIS staff on basic database administration procedures

. Deployed an Oracle 9i oracle fail safe solution on a windows 2000

server for prototype purposes

. Created and documented the definition, design and implementation of

Oracle 10g database management procedures

. Migrated a couple of Oracle 10g databases to MySQL database

. Applied oracle patches and upgraded third party softwares for client

user enhancements

. Responsible for installation of SQL Server, database creation and

building and scheduling jobs for maintenance

. Documented DB processes and procedures using ERD's and manuals

. Supported application developers by providing expertise on tuning and

performance of their SQL queries

. Defined and scheduled several DTS packages to move data between

servers and set up nightly jobs

. Established general guidelines for coding Transact-SQL and Stored

procedures

. Resolved technical issues and researched best practices for the

monitoring support, maintenance, and implementation of applications

Transport Canada, Ottawa, Ontario

February 2006 - June 2007

Position: Senior Oracle DBA(consultant)

. Developed backup strategy and validation - includes document backup

processes, testing backup processes and validating successful recovery

from backup.

. Participated in design discussions to support project and baseline

work.

. Performed regular schedule maintenance processes

. Worked with application development staff to develop database

architectures

. Planned and performed the migration of all Oracle version 9.2.0.7 to

version 10.1.0

. Administered Oracle 8i, 9i and 10g databases on various unix platforms

(HP, SOLARIS, AIX)

. Designed and implemented a failover solution based on an Oracle

9.2.0.7 standby database and developed scripts to monitor the transfer

of archived redo logs and resolve gap sequence due to network

problems.

. Installed various Oracle packages of the Collaboration suite

. Installed and configured Oracle 10g grid on Linux and windows servers

. Installed 10g agents on all servers and configured the servers for all

the database processes to be monitored on the 10g grid OEM

. Installation, configuration and performance tuning of large Oracle

databases in a UNIX/NT environment

. Managing partitioned tables

. Oracle installation and migration to new releases (8i, 9i & 10g)

. Installing and setting up management server and enterprise manager

. Data loading using SQL Loader

CGI (Secure Channel), Ottawa, Ontario

April 2005 - January 2006

Position: Senior Oracle DBA(consultant)

. Supporting Sun and HP Servers running different applications in 24X7

environment

. Oracle installation and setup on Solaris and AIX servers

. Design, develop and maintain database integrity including

dictionaries, monitoring standards, access /security, performance and

server functionality

. Installed and supported OAS, web cache and oracle HTTP server

administration pages

. Manage turnover of programs, data, and simple schema changes into test

and production databases.

. Monitor database performance, backups, alerts and logs.

. Install and configure database server, upgrade, and patch-sets.

. Manage movement of complex schema changes into test and production

databases.

. Manage database storage (tablespaces, datafiles, extents) and I/O

distribution.

. Installed and configured Oracle Application Servers (OAS) for Testing

environment

. Setup and manage physical database data structures, tables, indexes,

clusters, and partitions.

. Setup and manage backup, recovery, and fault-tolerance of Oracle and

SQL databases including DTS and PL/SQL packages in the database.

. Setup and manage network interfaces between databases, clients and

other products.

. Setup and manage role-based security, database replication and

distributed database environment.

. Tune database instances and applications and provide database

expertise to development staff.

. Perform other basic database administration tasks.

. Be on-call to respond to critical system issues.

. Administered, created, maintained and monitored clients and database

access.

. Established backup and recovery procedures

. Created a quick user interface application with Oracle forms to access

oracle development databases

. Provided 24x7 software and hardware support and logged in resolved

support calls

. Performance monitoring and tuning

. Installation of DB2 data warehouse and configuration

. Connecting Oracle Portals to DB2 databases on AIX servers and

generating PDF files on application servers

. Table creation and setup to work with a lot applications like SPSS,

COLDFUSION and other in-house applications

Telus Inc, Edmonton, Alberta

September 2004 - March 2005

Position: Senior Oracle Database Administrator(consultant)

Duties:

. Maintained Oracle/SQL Server and related software by applying patches

. Implemented database related bugs fixes communicated by the

application team

. Interface with database vendor for technical support

. Maintained and updated database setup documentation

. Worked with testing team to monitor database performance and assisted

developers in removing performance bottlenecks

. Performed database re-organization as required for performance

optimization

. Updated and fixed stored procedures using PL/SQL

. Ensured the completion of all daily backups, archives and exports

. Assess database capacity by monitoring online storage, growth and file

system space

Canadian Institutes of Health Research, Ottawa, Ontario

May 2004 - August 2004

Position: Senior Oracle Database Administrator(consultant)

Duties:

. Installed Oracle software and created new databases on windows 2000

servers

. Installed and configured Oracle customer data hubs

. Imported database objects into new Oracle 9i databases

. Upgraded Oracle 8i databases to Oracle 9i

. Setting up and reviewing technical environments before instalation

. Validated the compilation of all objects in the new Oracle 9i

databases

. Modified backup scripts for new databases

. Maintained and coordinated data models, dictionaries and other

database documentation

. Trained junior personnel in the administration and management of

Oracle

Hydro Ottawa Inc, Ottawa, Ontario

January 2004 - April 2004

Position: Senior Oracle Database Administrator(consultant)

Duties:

. Developed IT policies and standards relating to database issues

. Support, administer and maintain the oracle environments primarily

running on windows platform

. Maintained defined operating procedures for day to day operations

including various database backups

. Created and maintained several Oracle standby databases

. Provided some instance level performance monitoring and tuning

. Provided and implemented optimum physical database design

. Created and executed triggers and stored procedures with PL\SQL

. Supported a project group with different disciplines and different IT

backgrounds

. Supported development effort by providing SQL statement tuning and

optimum data loading techniques

. Trouble-shot database problems as required

. Provided 1st, 2nd and 3rd level support

. Planned and rehearsed database recovery plans

Canadian Standards Association, Etobicoke, Ontario

November 2001 - September 2003

Position: Oracle DBA / SAP Basis Admin

Duties:

. Migrating Application and data from SQL Server database to Oracle

database

. Support of Oracle tools (Developer, Designer, DBA Studio, OEM) in

Windows environment

. Oracle installation and migration to new releases (7.3, 8 & 9i)

. Estimating the database growth and request additional diskspace

proactively

. Research into SAP notes and SAP documents on the OS version

. Daily system checks and troubleshoot any errors

. Defining Business Systems & assigning Transport Targets

. Life cycle maintenance by updating kernel, support packs and

installations

. Applying sapnotes if there is any urgency and sps cannot be

implemented soon

. Installing and setting up management server and enterprise manager

. Data loading using SQL Loader

. Preparing the Plan for implementing support pack stack in Production,

Dev & QAS

. Installation, configuration and performance tuning of large Oracle

databases in a UNIX/NT environment

. Managing partitioned tables

. Logical backups and hot (online) backups using shell scripts and

incremental backups using recovery manager

. Customizing APIs, forms, applying patches and managing database

security

. Wrote triggers to carry out advanced validation

. Installed and configured Oracle customer data hub

. Designed and created relational databases with Oracle

. Wrote stored procedures and triggers for DB2 databases

Washington Mutual bank, Atlanta, Georgia

May 2000 - September 2001

Position: Intermediate Oracle DBA & Programmer

Duties:

. Optimized Oracle instance and I/O using reports from statspack utility

. Migrated Oracle databases onto HP and AIX platforms

. Responsible for maintenance of client scheduling database (SQL Server)

. Performed recovery from missing or corrupted data files, redo log

group, control files and recovery from block corruption (dbverify)

. Converted data functions from HP3000 Image database to HP9000 Oracle

database on UNIX platform

. Provide in-house training for staff on new programs and applications

. Discharged installation, upgrade, and migration of Oracle databases

(Oracle 9/9i) duties.

. Migrated data from MS SQL Server database to Oracle database

. Implemented automatic documentation for Oracle databases and UNIX

systems

. Developed database application for SQL Server 7 and 2000 with transact

SQL

. Created stored procedures with PL\SQL

. Managed concurrency using transactions and locking options

Applied Systems Inc, Mississauga, Ontario

August 1999-March 2000

Position: Jnr Oracle DBA / Software Developer

Duties:

1. Wrote and executed PL/SQL code such as procedures, functions and

packages

2. Created Oracle forms and reports

3. Migrated and converted clients data to corporate system, to ensure

homogenous application and data platform for project design (MS

ACCESS and VISUAL BASIC)

4. Administered Oracle 8i networking such as listener.ora and

tnsnames.ora

5. Administered Oracle Databases on WIN 2000 and UNIX platforms

6. Wrote and executed SQL statement against Oracle databases and its

objects

7. Successfully managed stakeholder expectations and translated client

requirement into phased implementation program

8. Prepared project report which included design concepts, plans,

sections, elevations and computer generated 3-d models and animation

9. Performed configuration of custom database layout structure such as

relocating the user

10. Regularly scheduling maintenance exercises and custom report

generation to extend life of the system

11. Performed required analysis to indicate modules of various

applications

12. Documented all requirements for the design, coding and testing of

applications

13. Contributed positively to the team development environment

Canada Imperial Bank of Commerce

January 1999 - July 1999

Position: Sales and Service Specialist

Duties:

14. Provided banking services to clients over the phone

15. Maintained clients' accounts

16. Sold products and services to clients

Royal bank Financial Group, Toronto, Ontario

January 1998 - December 1998

Position: Jnr Oracle DBA / SQL Server DBA

Duties:

. Supported latest XML technologies

. Created Oracle Instance/Database using customized scripts,

conforming to Oracle's Optimal Flexible Architecture (OFA)

. Managed the Oracle Instances using custom scripts and 8i Oracle

Enterprise Manager (OEM)

17. Assisted in migrating legacy applications and data to current

corporate platform

18. Created tables and views and supported developers

19. Maintained data integrity also managed profiles, resources and

password security

. Provided system support for Win95/98, 2000, NT Workstations and

server installations

. Designed requirement documents and modelled data for project

managers

. Granted roles and privileges to different users as per the

requirement

20. Wrote, coded and supported stored procedures on Microsoft SQL

servers

21. Integrated applications by designing, coding, testing and

maintenance

Celestica Inc, Toronto, Ontario

January 1997 - December 1997

Position: Help desk Specialist / Jnr Oracle DBA

. Managed Users, Privileges and Roles

. Setup and configured Netscape, Internet Explorer, Lotus Notes and MS

office products

. Provided ongoing technical support for systems and applications

software

. Installed and configured Oracle 7.3 databases

. Have good experience in taking logical and physical backups

. Created and maintained Oracle database users with different levels

of responsibilities

. Created indexes as and when required

. Performed pre-migration analysis needed to successfully port

customer's binary dump file

. Provided support for Novel/Netware 4.11 and Novel ZENWorks

applications

Skills Acquired: Critical thinking, comprehensive grasp of business

processes of several industries, Project Management, Communication skills

and presentation. Working long hours under tight schedules and meeting

deadlines.

Education

BSc. (Statistics & Mathematics) - University of Ghana, Accra - Ghana

BA. ( Economics) - York University, Toronto - Ontario

Computer Science Diploma - Ontario Institute of Information and

Technology, Toronto - Ontario

Oracle Certified Professional (Oracle DBA 9i, 10g & 1g) - Oracle University

(Humber College)

Other Professional Courses

Client/Server Information Systems - A Business Oriented Approach

A Guide to Oracle 8 Development

Oracle 7.3, 8i, 9i,10g & 11g DBA

MS SQL Server DBA 2000, 2005 & 2008

IBM DB2 UDB DBA

Sybase DB Development

Advanced Visual Basic 6.0

Mastering Java

Advanced Systems Design and Analysis

Advanced Unix Administration

References available upon request

Contact this candidate