Management Development
Resume:
Resume
Yinka KEHINDE
* **** *****, ******** ** *8619
email: *****@*********.***
mob : 732-***-****
POSITION SEEKING: Database Administrator
SUMMARY: As a Sybase and Oracle DBA on Solaris Unix, I have been working for
about 8 years, completed a Data Archive project with a leading investment bank as a
contractor, and with highlight being as a permanent staff in the IT Group Dept of an
energy utility company in Melbourne with team responsibility for Gas Market System,
Supervisory Control And Data Acquisition (SCADA) System, Metering & Settlements
System, and Gas Full Retail Contestability (FRC) Systems, having 45 Sybase ASE,
Replication servers running on various 30 Unix Systems (Sun Solaris and Digital Unix
Servers) and 12 Windows Systems (XP, 2000 and NT servers) in a mixture of
development, testing and production environments using technical products like Veritas
Netbackup, BackupExec, Active Directory, RAID 5, Solstice DiskSuite and Big
Brother, MDA Tables, Foglight, Control-M, ERwin Data Modeler, DBArtisan, etc.
Job Position: Sybase Database Administrator
Company: CXC / AOPC
Period: March 2009 – todate
Technical Skills: Sybase ASE 12.5, 15, Repserver 12.5 and 12.6 DBArtisan, T
-SQL, Solaris 8.0 and 9.0,
Sun E450, E3500, Unix, Shell Scripting, SAN, SQL Server 7.0,
2000, Erwin Data Modeler, Windows XP, 2000, and NT servers.
Activities / Capabilities:
- Sybase ASE 12.5.x server installation, configuration and
Administration on development, UAT and production
Environment
- Design, Analysis and Development of Database Systems from
business / users requests leading to logical data models (ERDs)
and Physical Database Design ensuring integrity and removing
redundancy.
- Liaise with developers and renders user support on
PA Courts Management Systems (PACMS), and Common Plea
Courts Management Systems (CPP), HR and Finance applications.
- Data Replication services between CPP and HUB servers
- support on application and Unix/network related issues
- Deployment of releases of application software
- SQL and Database tuning
- On call and after hours support
Yinka Kehinde Page 1 of 6 DBA’s curriculum vitae
PROFESSIONAL EXPERIENCE:
Job Position: Sybase DBA
Company: Catalyst Systems Inc / JP Morgan Asset Management, NJ (USA)
Period: Sept 2007 – March 2009.
Technical Skills: Sybase ASE 15.x, 12.5.x, Sybase RepServer 12.6, Control M, ERwin,
Oracle 9i, Solaris 8.0, and 9.0, Veritas Cluster Server (VCS) and Sun
F16K and F25K, Unix Scripting, MDA Tables, Windows XP, 2000, etc.
Activities / Capabilities:
A member of the Database Services team with sole responsibility for the support of Equity,
Trading, and Asset Management applications that run on Solaris Unix platform using Sybase
ASE 15.0, 12.5.4 and RepServer 12.6, in Production, test, training, UAT and development
environments. Built a formidable Data Archive for reporting to ease off resource contention from
OLTP server using Sybase Replication server 12.6 (MSA).
• Currently building series of 15 QA environment servers on Sybase ASE 12.5.4 in a team
project.
• Production Support of Equity, Trading and Asset Management Services applications
(follow the sun support with offshore teams)
• New projects and BAUs
• Server monitoring and diagnostics using MDA tables
• Design, Analysis and Development of Database Systems from business / users requests
leading to logical data models (ERDs) and Physical Database Design ensuring integrity
and removing redundancy.
• Performance and Tuning
• Architected and implemented backup/recovery strategies for various databases.
• Assisted and worked closely with developers and business analysts in tuning and
implementing database objects such as T-SQL queries, scripts, stored procedures and
SQL Agent jobs.
• Implemented daily and weekly performance tuning schedules.
• Researched and corrected errors and data inconsistencies to ensure information
accuracy and reliability to ensure that issues are resolved quickly.
• Sybase ASE Databases Administration and Archiving by Replication
• UAT setup and support
• Database dump and load from production to test environment
• develope perl code for ad-hoc database queries
• Provide database expertise in the form of helping write batched inserts and deletes to
other non database developers. Advocate and evangelize database best practices and
coding guidelines for the developer community
• Give guidelines and formulate strategies for creating partitioned indices/clustering on
large production database
• Produce documentation in terms of work-flow, system and data-flow diagrams for existing
fund derivative system
• Responsible for maintaining and updating communication subscription modules for
various data feed monitoring processes.
• Enforced system security and auditing.
• Advanced skills in writing stored procedures/scripts and optimizing SQL.
• Responsible for the administration of databases to ensure availability of systems for
corporate users.
• Responsible for maintenance and support of more than 50 development and QA
environments.
• Investigated methods to implement standby strategies for adaptive servers using
backups/restore and replication.
• Created, analyzed and executed project plans for database activities with a clear
understanding of business activities, processes and the data.
Yinka Kehinde Page 2 of 6 DBA’s curriculum vitae
• General users support
• Systems and Technical Documentation
Job Position: Sybase DBA / Unix Systems Administrator (Contractor)
Company: ANZ Bank, Melbourne, Australia
Period: August 2006 - August 2007.
Technical Skills: Sybase ASE 12.5.x, Sybase RepServer 12.6, Oracle 9i, Solaris
8.0, and 9.0, Sun Fire V880 and, F16K and F25K, Unix Scripting,
Windows XP, 2000, and NT servers, MDA Tables, etc
Activities / Capabilities:
- Production Support of Custodian Services application (follow the
sun support with India and New Zealand)
- New projects and BAUs
- Performance and Tuning
- Database Monitoring, Troubleshooting and Diagnostics by
querying MDA tables
- Sybase ASE Databases Administration and Archiving by
Replication
- UAT setup and support
- Logical Data Modeling and Physical Database Design systems.
- General users support
- Systems Backup
- Systems and Technical Documentation
Job Position: Unix Systems Administrator / DBA (Oracle & Sybase)
Company: Commonwealth Department of Industry (DITR), Canberra
Period: August 2005 - August 2006
Technical Skills: Sybase ASE 12.5, DBArtisan, T-SQL, Oracle 9i, PL/SQL, TOAD,
Solaris 8.0 and 9.0, Fire V210, 280R and V440, V880, E450,
E3500, Unix, Shell Scripting, SAN, SQL Server 7.0, 2000,
Erwin Data Modeler, Windows XP, 2000, and NT servers.
Activities / Capabilities:
- Solaris Unix server installation, configuration and tuning
- Sybase ASE 12.5 server installation, configuration and
Administration on development, UAT and production
environment
- Creation, management and administration of Oracle
Databases on 9i instances (production, UAT, Test, Training and
Development)
- Design, Analysis and Development of Database Systems from
business / users requests leading to logical data models (ERDs)
and Physical Database Design ensuring integrity and removing
redundancy.
- Database Capacity Planning by monitoring tablespaces growth,
alert logs, etc
- Liaise with developers and renders user support on
application (HR and Finances) and database related issues
Yinka Kehinde Page 3 of 6 DBA’s curriculum vitae
- Deploy EXP (export) and IMP (import) to move tables and
users (schemas) across databases on different hosts
- Deploy RMAN to handle backup, restore and recovery, and to
recreate database on another hosts
- Established database links, granting select privilege to a user on
development database to access a set of tables belonging to a
schema on production database.
- Handle LOBs movement across tablespaces
- Handle user permissions and password administration
- Wrote a lot of PL/SQL scripts and unix scripts to automate tasks
- Solaris Unix Systems Administration and Shell / awk scripting
- support on application and Unix/network related issues
- Preparation of database scripts for deployment of builds and
releases to central and state offices
- Deployment of releases of application software
- SQL and Database tuning
- On call and after hours support
- support on MS SQL Servers
Job Position: Business Support Officer
Company: London Borough of Camden (Street Environment Services), UK
Period: June 2004 - August 2005
Technical Skills: Crystal Reports version 8.5, Sybase ASE, IQ, SQL 2000,
Contender StreetScene, Unix, Shell Scripting, Windows XP,
2000, and NT servers.
Activities / Capabilities:
- Design and Generation of reports from Contender Database
tables using Crystal Reports version 8.5
- Sybase ASE, IQ and MS SQL Databases Administration
- Datawarehouse maintenance loading data from ASE using CIS,
Spreadsheet and Flat files.
- Contender Business Application Support
- General users support
- Systems Backup
- Systems Documentation
Job Position: Sybase DBA / Unix Systems Administrator
Company: Victorian Energy Network Corporation, Melbourne, Australia
Period: Nov 2000 – March 2004
Technical Skills: Sun Solaris Unix Servers ver 2.6, 7.0, 8.0, Unix Bourne/Korn Shell
scripting, SSH, FTP, Perl, Sybperl, T-SQL, Test Director, Unix
awk programming; Sybase ASE 11.9, 12.0, 12.5; Replication
Server, DBArtisan, Open Client and Windows XP, 2000, and NT
servers.
Activities / Capabilities:
- Installation of 3 ASE 12.5 servers on a test (Solaris Unix) box
- Wrote a Unix script to create all DBAs as logins, granting them
‘sa’ and ‘sso’ roles on each Sybase server for all production,
test and development boxes
Yinka Kehinde Page 4 of 6 DBA’s curriculum vitae
Wrote T-SQL queries, stored procedures, triggers while
-
maintaining user tables for Metering and Settlements dept.
Installation and Implementation of Unix Backup Script on
-
a Unix test server
Creation of Sybase devices and relocation of TEMPDB
-
database onto a new device for all Sybase servers on a test box
Increase of maximum memory on a production Sybase ASE
-
12.5 server.
Set-up of External logins and Remote table mappings between
-
2 Sybase ASE 11.9.2 development servers, both on a Sun
Solaris Unix server
Recovery of MASTER and SYBSYSTEMPROC databases
-
through Buildmaster utility and Installmaster script on ASE
11.9.2 Sybase server (a DR) on a Unix box.
Relocation of TEMPDB database on 2 ASE 12.5 Sybase
-
servers on a Unix box of testing environment.
Wrote T-SQL stored procedures as a team member in a joint
-
project with Application Development dept for FRC scheme.
Installation and Configuration of 2 DR Sybase 12.5 servers on
-
a Unix System
Dropping of a Sybase ASE 11.9.2 test server and integration of
-
its databases into a Sybase ASE 12.5 of a test environment
User Management on 2 DR Sybase ASE 12.5 servers
-
Development and Coding of a Unix script to handle relocation
-
of TEMPDB databases to its own device on any Sybase server
Resolution of dbcc hard faults on a Sybase ASE 12.5 server
-
Recovery / Rebuild of Master database on a Sybase ASE 11.9.2
-
DR server
Wrote a Korn Shell script to obtain growth status of
-
/export/home on a production Unix server, for developers
Wrote a Korn Shell script to dump transaction logs for each
-
database of Sybase servers on a production Unix box.
Adapting the above script to work on 3 test Sybase ASE 12.5
-
servers
Database synchronization for Replication Server on a Sybase
-
ASE 12.5 DR server
Cleaning out dbcc operation results (from DBCCDB database)
-
from the 2 productions and 2 DR Sybase ASE 12.5 servers
Expanding MASTER database size on master device for a
-
Sybase ASE 12.5 server on a production Unix system
Led a team of 3 to handle cut-over and cut-back exercise on the
-
Sybase Replication Server to ascertain the company readiness
at the DR site
Resolving Backup Script execution problem on a DR Unix
-
Server
Wrote server documentation for a test Unix server
-
Yinka Kehinde Page 5 of 6 DBA’s curriculum vitae
RECENT COURSES:
Oracle 9i Database Fundamentals 1 – Sept 2005
Windows 2003 Server Active Directory – Feb 2005
Crystal Reports Version 8.5 – Nov 2004
Introduction to SQL: Sybase Adaptive Server Enterprises 12.0 – Dec 2000
Fast Track to Sybase Adaptive Server Enterprise (VOL I & II) 12.0 – Dec 2000
System and Database Administration (VOL I & II): Sybase ASE 12.5 – Feb 2001
Performance and Tuning: Configuring Sybase ASE – March 2003
Fundamentals of Solaris 8 Operating Environment for Systems Administrators – July
2001
Solaris 8 Operating Environment System Administration I – Jan 2002
Shell Programming for System Administrators (VOL I & II) – April 2002
Solaris 8 Operating Environment System Administration II – May 2002
Microsoft Visual Basic 6.0 – Nov 1999
MS SQL Server 7.0 – Dec 1999
Negotiating Skills – May 2002
Communication and Values – May 2002
Clear and Assertive Communication – Sept 2002
PRINCE2 Project Management (United Kingdom) – August 2004
EDUCATION:
MSc. Computer Science University of Lagos, Yaba, Lagos, Nigeria
BSc. Computer Science University of Ibadan, Ibadan, Nigeria
WORKING VALUES:
Diligence, Timeliness, Organized, Honesty, Meticulous, Efficiency, Team Work,
Communication, Leadership and Analytical Skills.
PROFESSIONAL MEMBERSHIP:
Member, Australian Computer Society (MACS)
Member, Computer Professionals of Nigeria (MCPN)
REFEREES: Available on request
Yinka Kehinde Page 6 of 6 DBA’s curriculum vitae
Contact this candidate