Oracle Sql Server
Resume:
Blaise G. BASSE
DBA,OCP.
***-** **** ****** *******, New York 11432
Green Card holder
Telephone number
Mobile
Work
Citizenship
: Ivorian
email :
*******@*****.***
*******@*******.***
PRIORITY
Consulting or
Permanent jobs inquiries
WORK EXPERIENCE AND ACHIEVEMENT SYNOPSIS
Experience with Oracle, Microsoft SQL Server and MySQL RDBMS and its
associated tools for over 14 years.
Working knowledge of UNIX, linux and good bash shell scripting experience.
Experience in Database Backup and Recovery, SQL Tuning, Storage Management,
User maintenance, Data Guard deployment and Administration, Critical Patch
Update and Security Alerts, Performance Tuning.
Ability to function as a team player and alternatively work independently
to achieve the objectives
Attending day-to-day problems occurring with the production databases and
taking suitable action
Experience in rapidly learning and analyzing new subject matter, Strong
analytical and problem solving skills
Oracle Real Application Clusters Administration and Deployment
Securing and Auditing Oracle and SQL Server databases
Migrating existing databases and applications to VMware vSphere 5
environment without support (Physical to Virtual (P to V))
Upgrading E-Business Suite/Oracle Applications 11.5.8 to 12.1.3
Resolving database performance issues, replication, data integration with
GoldenGate and other distributed data issues and Disaster recovery
TECHNICAL SKILLS EXPERTISE AND ACHIEVEMENTS
Oracle 8.0.4 - 12c / E-Business Suite DBA
High Availability - Real Application Clusters (RAC 11gR2), Installation,
Administration and Deployment
Disaster Recovery - Implementing DATAGUARD Concepts and Administration
Using RMAN for Backup and Recovery
Using RMAN for Cloning or Creating and Updating duplicate databases
Implementing Data Models and database designs, Installation, Upgrade,
Migration
Security - Auditing, Implementing strong authentification and Auditing
database Users, Privileges and Objects
Applying Transparent Data Encryption
Auditing DML statement
Performance Tuning (ADDM, StatsPack)
Automatic Storage Management (ASM)
Grid Infrastructure, Grid Control
Setting up access to non-oracle system with heterogeneous services
Using ETL for data Replication (Talend Open source)
Data integration with GoldenGate
Upgrading large databases from 8i to 10gR2 and from 9i to 11gR2
Oracle database 8i, 9i, 10g, 11g and 12c Installation and Administration
Oracle Applications 11.5.8 /11.5.10.2
Upgrading E-Business Suite
Microsoft SQL Server 2000 - 2012
Installing, Configuring, Patching and Upgrading SQL Server Software
Modeling Data and Designing Database
Capacity Planning
Backup and Recovery
Maintaining Documentation
Performance Tuning
Scripting and Replicating Data
MySQL 4.0 - 5.6
Administering Users and Granting Privileges
Managing Space
Monitoring Health
Preventing a Disaster and Ensuring Recoverability
Optimizing Performance
Other Database Platforms
Sybase (Sybase SQL Server - Sybase Adaptive Server Enterprise (ASE))
Zope Object Database (ZODB)
Operating Systems knowledge
Windows NT, Windows server 2000, windows server 2003, windows server 2008
and windows server 2012
Linux (Suse 7.0-12, RedHat As 3-6, Mandrake, Debian
Unix (Sco, Digital, Solaris Mac OS X Server version 10.4-10.8
PROFESSIONAL CERTIFICATIONS
Oracle Database 10g Certified Professional (OCP)
Foundation Certificate in IT Service Management (ITIL)
EMPLOYMENT HISTORY
Senior DBA & Team Manager - West African Central Bank headquarters (BCEAO)
- Paris (FRANCE)
(May 2004 to October 2013)
Responsibilities and Achievements
Production support.
Experience in a corporate environment with hands-on systems experience
working on project-oriented business processes in large-scale and complex
global ERP and banking applications environments.
Performing all Oracle Database (8i to 11gR2) Administration related
activities for major Institution projects independently with minimal
supervision.
Strong capability and ability to resolve highly technical and complex
database and infrastructure related issues on their own before they impact
production and the business.
Performing database migrations, upgrades and structure migrations.
Migrating existing databases and applications to VMware vSphere 5
environment without support.
Auditing database users, privileges and objects.
Auditing DML statements.
Implementing Fine-Grained Auditing (FGA).
Applying Transparent Data Encryption
Ability to influence development team to comply with databases systems best
practices and company databases systems standards and practices.
Coordinating and/or participating in system information stress tests,
analyzing results, and making recommendations for design or coding changes
based upon those results.
Enforcing the Bank's Security Policy.
Ensuring the Bank's information system security and data Integrity by
protecting databases against improper access, sql injection and suspicious
activities.
Oracle 11gR2 RAC deployment and configuration.
Converting database 10g files from file system to ASM.
Providing technical assistance to vendors in development and implementation
of applications.
Setting up and configuring Oracle 9i/10g/11gR2 Physical Standby database
(Data Guard) and performing Switchover using DGMGRL.
Writing bash shell scripts for databases backup (hot and cold) without
RMAN.
Modeling with Oracle Designer 10gR2 and old versions.
Managing users with Quota Maintenance and security by creating roles and
profiles.
Involved in database capacity planning related to database growth and
predicting future
database resource requirements
Writing bash shell scripts to compute oracle databases statistics and
rebuild indexes.
Adding and deletion of Node in RAC.
Backing up of OCR and Voting Disk.
Data Integration with Oracle Golden Gate
Using AWR for snapshots and Baselines.
Troubleshooting, backup and recovery, proactive database and system
maintenance, proactive monitoring, security, all levels of performance
tuning, architecture and design.
Skilled in SQL statement tuning with detailed understating of AWR and
StatsPack reports, database performance tuning and PL/SQL programming.
Performing Advanced Configuration with Oracle database 10gR2 (Advanced
queuing and External procedures ) for Bank built applications.
Cloning, refreshing and adding a new node to an existing system.
Hands on Experience of implementing Oracle 9i, 10gR2 and 11gR2 database on
Windows 2003 and 2008, UNIX(Sun SPARC) and Linux.
Proficient at time and priority management.
Oracle DBA Consultant - National Investment Bank (BNI-C te d'Ivoire)
(June 2003 to April 2004)
Responsibilities and Achievements
Performing Oracle DBA consulting services for the Bank. Duties included
Oracle configuration,Oracle database administration, Oracle Databases
monitoring and upgrading. Duties also included Oracle performance tuning,
Oracle troubleshooting, and Oracle support for the Oracle development team.
Setting up and Configured Oracle DATAGUARD using RMAN backup for physical
standby databases.
Working closely with other team leads and their technical teams to ensure
delivery of database services within the performance targets set.
Schema Refresh using Export & Import.
Providing assistance to Development staff for issues relating to
performance tuning and SQL tuning.
Written bash shell script to perform Databases Backups (Hot and Cold)
without RMAN.
Ability to write professional level technical documentations and to ensure
presentations.
Oracle DBA/System Administrator - Soci t Nationale de d veloppement
Informatique (SNDI-C te d'Ivoire)
(August 2000 to May 2003)
Responsibilities and Achievements
Performing Oracle DBA activities including Oracle performance Tuning,
Oracle administration, assisting clients in a Windows/UNIX migration.
Member of a team of database administrators responsible for application
support, maintenance, upgrades, monitoring and tuning of over 100 databases
spread throughout the region. Utilizing advanced available techniques such
as StatsPack, Standby Databases/Data Guard and Real Application Clusters.
Other duties like installing databases and client software including
patches, writing shell scripts to perform certain tasks and assisting
developers with problems and SQL optimization.
Deploying applications on sybase database.
Basic understanding of Connection pooling and middleware software like
JBoss, JRun, Tomcat, IBM Web sphere.
ADDITIONAL INFORMATION / TOP 10 PROFESSIONAL TRAININGS
Performance Tuning - Oracle database 10gR2 - Colombes/Paris/FRANCE
(Jun 23 - Jun 26 2008)
RAC for Administrators - Oracle database 10gR2 and 11gR1 -
Colombes/Paris/FRANCE
(Jun 07 - Jun 11 2010)
Linux: Advanced system Administration and Security - Paris/FRANCE
(Oct 11 - Oct 20 2011)
VMware vSphere - Install, Configure and Manage - EMC Global Education
Paris/FRANCE
(Mar 19 - Mar 23 2012)
Data Domain - System Administration - EMC Global Education - Paris/FRANCE
(Jun 25 - Jun 27 2012)
VNX Unifified Storage - Deployment and Management -EMC Global Education -
Paris/FRANCE
(Jul 02 - Jul 06 2012)
Recoverpoint - Operations and Management - EMC Global Education -
Paris/FRANCE
(Aug 27 - Aug 29 2012)
Networker - Installation, Configuration and Administration - EMC Global
Education Paris/FRANCE
(Sep 03 - Sep 07 2012)
SQL Server 2008 - Installation, Configuration and Administration - SOLID -
Dakar/senegal
(Sep 17 - Sep 21 2012)
Oracle Database 11g: Security - Colombes/Paris/FRANCE - (Feb 04 - Feb 08
2013)
EDUCATION
Engineer Degree in Computer Science - July 2000, Polytechnic Institute FHB
of Yamoussoukro (INP-HB, C te d'Ivoire)
Engineer degree Course in computer science - Polytechnic Institute FHB of
Yamoussoukro (INP-HB, C te d'Ivoire) - (Oct 1997 - Jul 2000)
Scientific preparatory classes - ENSTP of yamoussoukro (INP-HB, C te
d'Ivoire) - (Oct 1995 - Jun 1997)
Scientific school-leaving Certificate leading to university entrance
qualification - Jun 1995, baccalaur at s rie C, Modern secondary school of
Daoukro (C te d'Ivoire )
LANGUAGE SKILLS
French (mother tongue)
English (fluent)
Spanish (fair)
MISCELLANEOUS
Driving license
Sport - Soccer
Contact this candidate