Oracle Database Management/Oracle DBA

Adebayo Gbadehan 732-***-****)

**** **** *****, ****** **. 75039

*********@*****.***

A Certified Oracle database administrator (OCP) and Certified Information System Auditor (CISA) with an overall knowledge-based of over 13 years multi-national experience working in various roles as a database administrations and RAT architect of databases.

Technical Skills

13 years’ experience in Oracle Database administration.

Capacity planning, Architectural Installation, configuration & upgrades of Oracle RDBMS on different environments and platforms.

Databases management system (RDBMS/DBMS): Oracle, Sybase, MS Access.

Database language & Scripting: SQL, ISQL, PL-SQL, SQL-Loader, TSQL etc

Services Controls & Scheduler: CRSCTL, SRVCTL, ASMCMD,EMCTL DBCONSOLE, OEM/GRID, Oracle Scheduler, CRON etc

Networks & Storage system: LAN/WAN, TCP/IP-Wireless protocol, FTP,DHCP, Active Directory Services, LDAP,SAN,NAS,UDP

Extensive experience of working on Oracle 9i, 10g, 11g & 12c on Sun Solaris, IBM AIX, HP-UX, Red Hat Linux, Ubuntu Linux, Oracle Virtual Box (VMware) and Windows.

Setup physical standby (snapshot/failover/switchover/Active database) for disaster recovery (DR) and Business Continuity.

RAC Clusterware installations & management both in 10g and GRID infrastructure in 11g on ASM Architecture using DNS/DHCP.

Configuration & Proficiency in using of Manager (OEM) and GRID control for managing and monitoring Oracle database

Used Oracle Enterprise Manager (OEM) for database performance monitoring, job scheduling, Setting Optimizer Statistic, etc.

Real database application Replay & testing (RAT + SPA) to capture production workload and replay it on different environment.

Upgrade database, Clusterware, RAC and ASM from oracle 10g to 11g and applied oracle patches for PST/CPU

Hands on experience with Installation and Configuration of Golden Gate software for Heterogeneous Data Replication for replicating data between oracle databases.

Database migration/upgrade from Oracle 9i to Oracle 10g and Oracle 10g to Oracle 11g.

Sound database tuning experience from (ASH), AWR, AWRSQRPT, ADDM etc for analysis, findings and recommendations.

Designed and implemented Database Backup and Recovery strategies using RMAN, OEM and Schedule Parallel backup for the same file using Oracle 11g RMAN feature.

Backup/Recovery using RMAN, Conventional export/import and Data Pump. Re-org using export and import

Database UPGRADE and GRID infrastructure upgrade

Performance tuning using various tools like Statspack, AWR, TKPROF, SQL Trace, Explain Plan, SQL Profile & advisory views.

Wrote Shell script for automated hot backup using RMAN.

Performance tuning of RAC at cluster level and OS level using HACMP by setting different clusters and Kernels parameters.

Use database tuning advisor and SQL Profiler for performance optimization.

UNIX shell script with SQL scripts for monitor database and automate backup and jobs running on CRON.

Monitor Database using hand written scripts, OEM, Spot light, Quest Foglight etc

Installed, configured, administrated and maintained SYBASE databases.

Administrated large Production database (100G to TB) and Large Data Warehousing and VLDB on an Oracle Exadata Platform.

Analytical Reporting tools such as Crystal Report, Advanced MS Excel etc.

Risk analysis and mitigation skills using Value@Risk, Stress testing, Scenario Analysis, Basel III with Regulatory bodies, ITIL, SOX

Excellent communication and interpersonal skills, good team player with analytical tools (BMC) and presentation acumen couple with strong attitude towards learning pros and cons of new technologies.

TECHNICAL SKILLS:

RDBMS

Oracle 8i, 9i, 10g R2, Oracle 11gR1/11gR2, Oracle12c,Sybase 11/12, Sql Server 2008,Oracle Exadata

OS

Windows XP, 2000, SUN SOLARIS 9/10/11, HP-UX Itanium 11.31, Red Hat Linux 4/5, AIX 7.1, VMware

Tools/Technology

OEM, TOAD, SQL Developer, PSFTP, FTP, Putty, MOBAXTERM, Spot Light, fog light, DBArtisan, Crystal reports, UDP, NAS,SAN,DGMGRL

DB Utilities

SQL * Loader, Exp/Imp, Data Pump Utilities, RMAN, OLTP/OLAP

Language

SQL, PL/SQL for Oracle, Shell programming

Scripting language

HTML, XML, Korn Shell

Shell script

Unix Shell Script

EDUCATION &CERTIFICATIONS:

University of Connecticut, Business School, Stamford, U.S. (MSc, Financial Risk Management GPA: 3.92)

Obafemi Awolowo University, Osun, Nigeria (MBA, Business Admin.)

University of Ibadan, Oyo, Nigeria (BSc, Computer science.)

Oracle 9i DBA training (Oracle university Certified OCP Program)

Oracle 10g Database Administration 1 & 11 (OCA & OCP Certifications

Certified Information System Auditor (CISA)

PROFESSIONAL SUMMARY: Vice President CITI Bank

CITI, IRVING TX Oct. 2014 – till date

Role: SR. Oracle Database Administrator (Team-Lead- L3 Support)

Description: CITI is a Global Financial institution connecting millions of people across hundreds of countries and cities. It serves approximately 1 Billion customers with 200 years of experience in helping clients meet their toughest challenges while embracing its greatest opportunities. I am currently working as a Senior Oracle DBA on Level 3 support, specifically on the Credit and Loans Processing, Retail Banking Business and Card Businesses for the Banamex/Mexico arm of CITI. With a Varying databases of over 400 running mostly on Oracle 11g/10g on Red-Hat Linux/AIX Unix and some on HP-Unix and IBM-AIX Unix in both Stand-Alone and RAC architectures supported by a Maximum Performance Physical DATAGUARD for High Availability/Disaster Recovery (DRP/COB).

Senior Oracle DBA providing L3 support and capacity planning and improvement by taking escalations from L1/L2 team.

High Level Performance analysis and interpretation as well as recommendation to implementation of AWR/ASH Report.

Ensure the optimum performance of the Database by ensuring that Patches are apply and fixing of bugs through SR.

perform Upgrade and RAC upgrade from 11gR1 to 11gR2 and apply EOV patches using Opatch apply in ORAAS Environment.

Put into optimum use, the Physical Standby environment for testing in the advent of major release or Change to reduce overhead on Prod as well as for active dataguard.

Installation, configuration and database upgrade management of Oracle 12c Release 1 on Linux platform with OEM.

Utilized the OEM 12c performance page enhancement features including ASH analytics and Historical events for troubleshooting.

Credit Initiation (CI) capacity planning and Mexico database deep diving and stabilization Team player.

Stabilization of the conventional 2 RAC Node Clusters in most of the ECS estate by creating and modifying services.

Configuring and management of the GRID infrastructure and management of the utility services ASMCMD, ./CRSCTL, SRVCTL

Database performance enhancement by justifying creations of partitions and rebuilding index around frequently access tables.

Lead Database team in Disaster recovery plan/business continuity test on quarterly basis.

Primary DBA to databases in a RAC architecture with conventional physical standby on DG Broker (DGMGRL)

Creating and redefining existing crontab to automate some BAU (business as Usual) tasks.

Cut off backup/recovery time by 95% by optimizing the usage of flashback technology using Guarantee Restore points for major testing or deployment.

Out of place, GRID and Database upgrade from 11.2.0.3 to 11.2.0.4 on AIX Unix and reconfiguring/modification of SRVCTL.

Work with application team to tune some of their SQL/PLSQL queries especially those with Literals with same matching signatures.

Use of the SQL profiles/baselines when execution Plan flips are spotted.

Golden gate replication to establish high Availability across homogenous platform.

Present powerpoint knowledge sharing session to bridge gap between the L3/L4 technical support.

Barclays Plano/McKinney, TX Dec. 2013 – Oct. 2014

Role: Oracle Database Administrator Designation: ASST. VP

Description: Barclays is a renowned Financial Service Provider. It serves approximately 400 million customers. I worked as a PDBA, specifically on the Investment Banking, Retail Banking Business, Wealth Management and Card Businesses all over the continents including America, Asia, Europe and Africa. Varying databases of over 3000 running mostly on Oracle 11g/12c on Red-Hat Linux and some on Sun Solaris, HP-Unix and IBM-AIX Unix on RAC architecture supported by a Maximum Performance DATAGUARD for Disaster Recovery.

Act in a capacity of A Stack DBA on a L3 capacity by taking escalations from L1/l2 incident Management team.

Refresh database schemas from the production to UAT and Development environment running Oracle Exadata

Ensure the optimum performance and success of jobs schedule on Autosys.

Installation, configuration and database upgrade management of Oracle 12c Release 1 on Linux platform.

Setup physical standby (snapshot/failover/switchover/Active database) for disaster recovery (DR) and disaster recover

Real life Quarterly PAT (Production Active Test) failover to Physical standby by all stakeholders in conjunction with policy.

Implement and maintain physical snapshot standby Dataguard and guarantee restore point using flashback architecture

Perform incremental and full database backup as well as schema/tables/objects dumps for partial refresh.

Used of DG Views like v$managed_standby, v$archived_gap, v$log_history, v$restore_point,v$archived_log,V$logfile etc.

Use SQL Profiler to ensure that SQL query plan flips and stale hints statistic are enforced.

Experience on handling production oracle databases in Linux, windows and UNIX in 24 X 7 environments.

Core skills on 11g database creations and software binaries installations in Windows/Unix using 10g and 11g advance features.

Practical experience in monitoring and tuning a database to provide a high availability service.

Core experience on Oracle high availability setup likes cluster, RAC, Data guard (Active DG, Failover including DGMGRL) & ASM

Practical experience in database backup & recovery using RMAN and Knowledge on Exports, Imports, Data pump, SQL-Loader.

In cases of some High level issues/problems, open a case with Oracle and do coordination with principle till closure of SR.

Responsible for ensuring availability and performance of the databases that support the system.

Experience in analysis of data tablespace, TEMP, UNDO tablespace growth.

Knowledge on performance tuning of database through the holistic approach i.e. Memory, CPU, I/O Stats etc.

Hands on experience on cloning of databases with databases restorations and recoveries.

Hands on experience on CPU patching and upgrades.

Jobs automation via shell scripting using Autosys/Crontab schedulers.

Hands on experience on Stats pack, AWR report analysis with SPA enhance for SQL tuning sets.

Knowledge in writing shell scripts needed for automated jobs like Autosys and Cronjobs.

Automated alert monitoring using Nimbus and Lab128 tools.

Essential Non-Technical Qualities Include:

Good Communication and Problem solving Skills

Good Team Player with capability of leading the shift.

Exposure to awareness of ITIL/CISA

Sound Knowledge on process defining and sharing.

Good in Technical delivery and interpersonal communication with various business groups

Oracle Consultant (Oracle Corporation - CVS Project) Aug. 2013 – Nov. 2013

Role: Oracle Database Administrator (RAT & SPA)

Description: CVS is the leading America’s Pharmaceutical provider. It serves approximately over 100 Million customers. I worked as an oracle DBA Performance analyzer and Tuner, specifically on the RAT (Real Application Testing), OEM, Upgrade and Golden Gate on an AIX OS with a growing Production database of over 10 Terabytes, on 5 RAC nodes architecture.

Analyzing performance test results generated by Oracle Real Application Testing for structured query language (“SQL”) for the targeted migrations for both the OLTP and batch transactions.

Monitor the applications running on the CVS architecture OEM and resolving locking conflicts using SQL, PL-SQL optimizer scripts.

Analyzing report generated from the SQL performance Analyzer (SPA) during the high peaks for the OLTP transactions on QA.

Data security and objects backup/recovery using RMAN, TSPITR, Data Pump, Flashback data from Archive destination/DPDUMP.

Managing the Servers running on AIX 7.1 Unix for Upgrades and Patches on EMC storage area in a 5 RAC nodes Clusterware.

Database performance analysis and tuning assistance for the migrated database using any of the following tools, as determined appropriate by Oracle: Oracle Enterprise Manager (“OEM”) diagnostics and tuning packs, Oracle Automated Workload Reports (“AWR”).

Capture, Process, Replay, Analyze and Report all findings discovered in the database workload Replay by executing DBMS workloads and wrc.

Management of VLDB on an Exadata Platform for easier queries performance using a smart flash cache technology

Management of the 5 nodes RAC architecture databases, Clusterware home and Automatic storage management ASM

Performing and comparing execution plans between top running SQLs including Procedures with binds variable in Oracle 10g and 11g and restructuring or tuning as may be required.

Writing and debugging complex PL-SQL statements using CURSOR etc.

Using SQL Auto-trace and Explain Plan to tune and improve the performance of the Top-bad SQL from the AWR/ASH/AWRSQL Report and ADDM recommendations and findings.

Use oracle SQL Developer tool for the management of queries in a more user friendly environment including 3rd Party Databases.

Verizon Wireless Warren/Basking Ridge, NJ Feb. 2013 – July 2013

Role: Oracle Database Administrator

Description: VZW is the leading America’s wireless provider and mobile operator. It serves approximately 19 million customers. I worked as a DBA, specifically on the MCS (Media Content Solutions) with an SLA of 10 Milliseconds of data Response over a growing database of a Terabytes on RAC architecture supported by a Maximum Protection DATAGUARD in case of eventuality/switchover.

Oracle general purpose configuration and management on the MCS, Vision System, SCM and CMP for data processing control.

Monitor the applications running on the MCS architecture via GRID/OEM and resolving locking conflicts using SQL, PL-SQL optimizer scripts.

Support as PRODUCTION/QA DBA to over 20 databases running concurrently on 10 different servers running to Terabytes.

Data security and objects backup/recovery using RMAN, TSPITR, Data Pump, Flashback data from Archive destination/DPDUMP.

Linux/Solaris installations & administrations of upgrades, Patches etc on SAN/NAS Servers or VMware prior Oracle installations.

Experience in code management, database change and management through the stages in System development life cycle (SDLC).

Configuring, implementing and managing of the various services on the 4 RAC Nodes on GRID home using the SRVCTL and the CRSCTL utilities dedicated for the Information system.

Real database application Replay & testing (RAT) for upgrade and capacity planning using SQL performance analyzer & Replay.

Configuring and management of the GRID infrastructure and management of the utility services ASMCMD, ./CRSCTL, SRVCTL

Implementation and management of Oracle Golden Gate on a unidirectional (Active-Active instant failover) for replication of data, transaction within and outside the database as well as management of Oracle SharePlex replication Technology.

Utilizing Dataguard snapshot to clone test & development servers as well as maintaining Maximum High Availability in failovers and switchover.

Configuring ASM High Redundancy for best protection during data & storage failure and maintaining availability in disks failures.

Using Flashback technology to recover tables, transaction & events from Undo, while database is recovered from Flashback area.

Maintaining and analyzing database performance using the SQL tuning advisor, Explain Plan, TkProf, SQL Trace, Analyze, etc.

Maximizing Partitioning on the oracle and OS level to ensure multiplexing of core Critical objects/disks in a more flexible pattern to avoid disaster and minimize (MTBF).

Using UNIX shell scripts and oracle scheduler to schedule jobs and for system tablespace auto Extent management.

Environment: Oracle 11g, Red-Hat Linux 5.x, Sun Solaris, RAC, Toad 9.5, PL/SQL, SQL*LOADER, SQL PLUS, UNIX shell scripts.

FAMILY OPTIONS Inc. Watertown, CT (HealthCare Industry) Jun. 2010 – Jan. 2013

Oracle DBA.

Medicare Management Information Systems (MMIS) to Provide 24 X 7 Oracle database on-call support services.

Manage the oracle production database instances and ensure performance monitoring of the database using SQL tuning set.

Participate in the Planning, Analysis, implementation and Maintenance of production database resources running on UNIX.

Creating and maintaining database objects for complex business rules. Disabling constraints for bulk DMLs upload

Install various components of oracle E-Business Suite applications and configuration to support the Aix-Unix environment.

Provide input on design decisions in the integration of databases using SQL-Loader or SQL Server Interface service (SSIS).

Monitor database growth trends and develop capacity planning and data archival strategies using the optimizer statistics tools.

Oracle security based audits & disaster recovery plan using Data Replications infrastructure & scalable Dataguard flexibility.

Implemented and managed Oracle Golden Gate technology on unidirectional basis (Reporting database) with one of our partner health provider using the golden gate command interface ggsci

Performed upgrades from Oracle 10.2.0.3 to 11.1.0.1 and Monitor Oracle 11i Application instances.

Configured, administered and monitored a Streams environment using tools like OEM console and apply changes on database

Set up, configured and maintained oracle data guard (primary and standby databases) to ensure faster disaster recovery, high availability and data protection

Used shell scripting for automation of job Scripts, for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes

Installation and maintenance of 2 nodes RAC including the Clusterware + ASM (G.I) and configuring the services with SRVCTL.

Worked on import/export, export data pump/import data pump and SQL- loader.

Installed and Implemented Backup & Recovery procedures, Implemented Hot, Cold, Logical backup plans.

Installing and configuring RMAN and Flash Recovery. Cloning databases using RMAN as well as scripts

Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 11g.

Based on the thresholds configured, notifications and alarms are generated; actions are executed while gathering performance data for planning, analysis, and reporting.

Monitored log apply rates, capturing diagnostic information, and detecting problems quickly with centralized monitoring, testing, and performance tools in physical/logical databases

Installed Oracle 11g Enterprise Manager (OEM) (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on databases

Designing the security and database access strategies using tools like ESM and writing a SQL Scripts for bulk authorized users.

Indexed at the database level and used pre-tuned queries at the application level to tune OLTP.

24x7 production support for several mission critical systems which utilize multiple databases.

Environment: Oracle Server 11g/10g, SQL, PL/SQL, UNIX, RedHat Linux 5.x

Wachovia (Well Fargo) Jersey city, NJ (Wipro Consultant) Jun. 2008 – Apr. 2010

Oracle-Database Administrator (FLEXCUBE CORE BANKING APPLICATION)

Description: Well Fargo is among the too big to fail banks in the United States with subsidiaries all over the world. I acted as a DBA apps supporting the Enterprise Core Banking Applications (FLEXCUBE) running on UNIX OS. I managed Up-time and High availability of the Oracle FLEXCUBE. Managed the databases applications of over 300 gigabytes size performing all databases related activity to ensure high availability.

Integration and Interoperability of other Business applications (KASTLE and 3rd parties applications) with FLEXCUBE CBA

Co-ordination, review, testing and deployment of patches and fixes bug in the FLEXCUBE modules and E-Business suites apps.

Design and Co-ordination of FLEXCUBE Center of Excellence – 24/7 online Database support for Flex-branch & FLEXCUBE.

Handle problems relating to Oracle FLEXCUBE Helpdesk management and resolving Oracle applications bugs for VLDB

Tuning of instances and database using optimizer statistics from AWR & ADDM by setting the baseline, metrics, threshold etc.

Query optimization using SQL advisor, bind variable, and explain plan, trace, views, indexing and various types of joins. Analyzing CBO and instance parameter for best result of query by monitoring performance at session, query and system level. To find problematic SQL from History tables.

Rewriting of SQL queries for different types of joins. Define outlines and profile for SQL for stereotype queries. Writing PL/SQL block for bulk DML tasks.

Monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs using CRON, creation of users, schemas, tablespace and other database objects. (crontab –e, crontab –l, crontab –r)

Writing SQL and SHELL scripts for monitoring database. Automation of database maintenance using OEM, SHELL scripts. Configure alert, thresholds and email in OEM.

Creating scripts automate backup of database by RMAN, Import/Export of data file and user schema. Recovery of full database by applying archive and redo logs (Alter database open resetlogs).

I was involved in writing queries involving multiple-joins to generate applications reports using Business report or OBIEE Tools on Toad, Quest tools etc.

Planned the index rebuilding, index analysis and table analysis on periodical basis.

Scheduled & coordinated database maintenance activities including such items as database reorganizations, restructures, migrations, tuning, SOX (Sarbanes-Oxley Act) sensitive views, materialized views & staged data refresh.

Capturing the database statistics and metrics for proactive database management

Cloning of production database to the test environment using Recovery Manager (RMAN).

Monitored the growth of the database objects for capacity planning and analysis.

Loading data from flat files into Oracle Database using SQL*Loader and automated the process using UNIX Shell scripting.

Migrated databases from windows SQL Server to HP-UNIX servers using Data Warehousing (ETL).

Database Administration and Planning including logical design, physical design, backup & recovery.

Developed, implemented and tested a backup and recovery strategies.

Environment: Oracle 10gRAC, 9i, RedHat Linux, HP-UX, IBM Aix, OEM, RMAN, SQL*Loader,

SKYEBANK PLC, Lagos, Nigeria Jun. 2004 – May 2008

Oracle DBA/Technical lead:

Description: Skyebank is among the biggest banks in the coast of West Africa with a customer base of over 100 Millions in about 6 Africa countries, Head office on the western coast of Nigeria. It was a product of 5 merging banks. I managed the database which is on a 2 RAC nodes Grid Infrastructure with a database size running to Terabytes on an Enterprise HP-Ux Platform.

Management of data architecture & risk assessment processes from an in-depth understanding of risk & security measures.

Implemented and managed Dataguard on Primary Core Database against the standby database to manage databases failovers.

Management of Virtual data and automate backup using Data Pump and RMAN embedded script on oracle scheduler.

Administration & Migration of data running on Sybase and SQL-Server to Oracle Aix-UNIX Platform using SQL-Loader, a metadata management of Non-Oracle database system.

Scheduling routine CRON jobs on AIX Unix production Servers on a 2 nodes grid infrastructure to allow for maximum performance.

Optimizing database performance by analyzing database objects, generating statistics, creating indexes & materialized views.

Taking snapshots into the Automatic Workload Repository (AWR) to proactively maintain the database using Statistic optimizer and minimize reactive resolution of the Automatic Database Diagnostic Management (ADDM) over a threshold frequency.

Obtaining efficiency with Recovery Manager (RMAN) in backup, restoring and recovery of p-files, control files and datafiles.

In Merger/Acquisition Project, I was involved in the data migration of a legacy banks’ data in Financle/Equinox banking application running on Sybase to FLEXCUBE banking application running on Oracle in an Aix UNIX Server OS platform.

Configuration of Oracle Instance with SGA, PGA and Background Processes.

Managing Logical objects like Tablespaces, segments, and extents in estimating table sizes, table spaces.

Maintaining indexes and performance management of Undo Data.

Create Users and Roles with appropriate privileges, roles. Thus create user profiles and assign to appropriate user.

Also define Database level authentication and OS level authentication using password file.

Performing regular Backups and Recovery as per Organization Strategy to support the database and Troubleshooting with restoring and recovery (Instance, media).

Performing hot/cold backup. Setting up of RMAN on the database to perform necessary back-up.

Integrated the Backup Status Reporting for all the databases using shell script.

Extensive use of Export and Import for full database backup, schema level backup, Table level backup and metadata.

SQL query optimizing using CBO (cost base optimizer), bind variable, Explain Plan,Stats pack and instance as per company’s requirement for high tuning.

Performance tuning for Oracle Day-to-day maintenance and management of the several different databases in development, test, and production environments.

Written extensively UNIX Shell Scripts, PL/SQL, Stored Procedures, Functions and Triggers.

Create table, view, and materialize view, private and public synonyms.

Create user define packages and use pre-define packages. Different kind of Exception handling.

Responsible for integrity and concurrency of data, locks and latches.

Working with management system like DBMS and RDBMS with specific functions, database tools and utilities. Managed and resolved design issues during development.

Roles as a technical lead,

Work with lines of business to create functional process & data flow charts for customer and technical review on modeling.

As a technical lead, Producing detailed Data Architecture framework within which Entity Relationship Diagram & Data Model Designs (conceptual, logical, and physical) will be developed.

Implementing a disaster recovery plan (DRP) or business continuity plan (BCP) for the Universal lending systems.

Ensuring bugs are fixed & thoroughly tested on the development and test environment before applying patches to production Server in line with operating manuals.

Develop MIS & other Credit reports of all credit facilities by categories (Overdraft, Personal Loan, Credit Card, Mortgage loan, Auto loan and other credit facilities) to Credit Bureau using Crystal report tools, Oracle report and Business objects.

Analyze internal and external data for portfolio segmentation and validation with thorough execution of credit loan from origination to disbursement via the various stages of underwriters and Counterparty rating in the ERP of Oracle EBS suite.

Proficiency in using IBM Websphere & MQ Websphere for the implementation of KASTLE Universal Lending System (ULS).

Strong knowledge of Application development life cycle (SDLC), including functional testing (QA) and requirements gathering.

Environment: UNIX, Oracle 8i, 9i, 10g RMAN, SQL Server 2005, 2008 Crystal Reports 5.0, SQL * Loader, Toad.

WEMA BANK (NATIONAL BANK), Lagos, Nigeria Oct. 2003 – Jun. 2004

Sybase DBA/Application analyst

Tera-data Management of database running on UNIX OS; Database architecture/administration with emphasis on data integrity, quality & security while maintaining access & control of users, assigning privileges and roles.

Taking database Dumps and Upload from the ISQL command prompts for database backup and recovery

Integration and Interoperability using SQL Server Integration Services (SSIS) with Extract, Transform & Load (ETL) capabilities.

Writing DML and DDL queries using SQL/PL-SQL to manage data, table and transactions maintenance on the Toad/DB-Artisan.

Coordinate and manage service level agreement with consultants and user across the network to maximize up-time.

System Administration on file Servers (Equinox/Phoenix Banking Application) running on SQL Server RDBMS.

Reviewing, Fixing and debugging queries coming for change management and recompiling invalids objects.

Extensive performance/tuning of ANSI SQL, PL/SQL using various methods i.e. tuning of memory parameters, hinting queries.

Fixing the joins with proper columns and indexes. Writing PL-SQL for business logic including triggers, procedures.

Writing SHELL scripts which set profile of any instance with single commands. Debugging PERL and SHELL scripts.

Efficient in managing database server from command-line and using SQL developer tools and Toad.

Supported as DEVELOPMENT/PRODUCTION DBA to 40+ databases on 6 different servers with over a Terabyte in size.

Hand over the QUERY PERFORMANCE result to off-shore developers for better design of DB and automatically taking reports

Of SQL queries that run beyond a threshold frequency in a session and fixing it with proper

Contact this candidate