Daniel Adeniji
[Send email using form at bottom]
Home Phone # [Send email to request phone number] 96.8121
Summary
Interested in a position where my many talents and experiences can be harvested
towards the fulfillment of strategic and operational business goals and
practices.
RECENT EXPERIENCE
PG & E (Sept 2006 - Present)
Roles: Database Architect, Operations DBA, and Software Developer (.NET, SQL,
Java) - MS SQL Server [version 7, 2000, 2005, 2008], Oracle [version 11G, 10 G,
9i, 8i, 7.3]
Highlights & Tools
· Participated in identifying and processing Hardware & Software directions and
standards
· Performed historical and on-going analysis of system utilization and
identified proper Application paring to better distribute system overall cost and
utilization
· Successfully uptake of Multi-Instance, Virtualization, and shared storage
deployments
· Paid close attention to system’s Life cycles, usage of monitoring tools, and
open communication with business stake-holders, Business Analysts, other system
engineers to project and plan for utilization increase, data footprint upswing,
and other factors
· Usage of newer database backup technologies such as LAN-free, compressed, and
“segmented” backups
· Distributed database design and implementation (partitioning, file groups)
· Reviewed System's data requirements and identified performance, redundancy &
availability, storage, security, and auditing needs
· Worked with all involved to document SLA and OLA requirements
· 24 * 7 Support of Client's database systems
· Set up & maintained Database Clustering systems
· Configured Database Mirroring / Log Shipping / Replication
· Developed Microsoft Integration Services (SSIS) & DTS packages
· Developed Reports using SQL Server Reporting Services
· Installed new systems, upgraded & patched existing systems
· Performance Tuning
· Monitoring
· Multi-Instance systems setup & monitoring
· Data Exchange between MS SQL Server Systems and Heterogeneous data sources
(Oracle, Sybase, MYSQL, MS Excel)
· Very Heavy usage of MS SQL Transact SQL (T-SQL)
· Very adept at understanding data flow requirements and developing Extract
Transform Load (ETL) modules in SSIS/DTS/Transact SQL
· MS .NET Development work using C# and VB.Net (Also MS SQL Server CLR
Development work)
· SOX Compliance – Data access & usage auditing
· System Hardening & Data security
· Networking (Firewall)
· Storage (SAN) - Connectivity, allocation & tuning
· Backup & Restore (Traditional database backup & restoration and 3rd Party –
IBM Tivoli [TDP], Symantec [Backup Exec])
· Virtualization experience (VMWare, Microsoft Virtual Server – Hyper-V)
· Monitoring Tools (Microsoft MOM & Microsoft System Center)
· Setup database repository for numerous 3rd party products (Microsoft
[SharePoint, MOM, SMS], Remedy, Research In Motion – RIM – BlackBerry, Citrix,
Risk Master [Legal Software])
· Conversant with Microsoft front Office Technologies – MS Office (Word, Excel,
Outlook). Very comfortable using them as an end-user and also programmatically
(VBA, OLE Interop, 3rd party tools [Aspose])
· Very comfortable with MS Windows OS (Microsoft NT, 2000, 2003)
· Installation & Operation of MS Exchange (SMTP, MAPI, Anti-spamming
configuration)
· Apache web server
· Oracle (some DBA & PL/SQL work, and also Transparent Gateway Configuration)
· Java\JDBC\Bea Web Logic development & database connectivity\configuration
work
· Some Linux
· Some MYSQL DBA work
· Some GIS Work
PeopleSoft/Oracle Corporation (Dec. 2000 - Sept. 2006)
Roles: Database Architect, DBA, Data Modeler, Web Developer, Lead SQL Server
DBA, Lead Developer
Work on all three major databases (Microsoft SQL Server, Oracle, and IBM UDB).
Provide 24 by 7 coverage. Work on all application deployment tiers - Database
Servers, App Servers [Bea Tuxedo], and Web Servers [Microsoft IIS, Apache].
Highlights & Tools
· Participated in discussions with clients and identified database needs &
requirements
· Aligned delivery of those requirements with the various departments,
individual contributors, engineering infrastructure & systems
Designed, configured, and maintained SQL Server Cluster
· Configured interoperability between MS SQL Server and Oracle & IBM DB/2 & UDB
Servers
· Responsible for database daily maintenance, performance tuning, script coding,
database backup & recovery, system connectivity, and security
· Participated in inter-department discussions and decisions on choice of
hardware, storage, and network
· Databases located across the globe (Asia Pacific - Australia, Europe, Canada,
and US)
· Work with management and end users to design new Applications - Study the
business model and practices, designed application, ensure & build the
infrastructure, deploy and manage
· Data modeling functions - Designed logical & physical data models for LOT and
Decision support systems
· Very proficient with database modeling tools (Erwin, Embarcadero ER/Studio)
· In designing logical model, able to identify entities, determine relationship
between entities, and define data integrity constraints
· In designing physical model, able to map logical model into a physical model
that is suitable to the underlying characteristic of the database platform
(whether MS SQL Server, Oracle, or IBM DB/2). Ensure that indexes, views, stored
procedures, triggers, and constraints are used effectively
· Reversed Engineered existing databases into logical model - In doing so able
to educate and share existing data repository with others and prepare system for
maintenance, upgrade, or retirement
· Able to predict and determine data hotspots and spread data entities (actual
data, log, and indexes) across unique physical drives
· Proficient at optimizing database queries (using re-written queries, indexes,
partitions, archiving, and materialized views)
· Well verse experience with MS SQL Transact SQL (T-SQL)
· Rich set of expertise in understanding data flow requirements and developing
Extract Transform Load (ETL) modules in SSIS/DTS/Transact SQL
· Proficient with XML, XSLT
· Comfortable with Web Services and Soap
· Adept at using reporting tools (Crystal Reports, CONGAS, MS Reporting Services
[SSRS])
· Used Microsoft SQL Server DTS packages extensively
· Configured Replication between MS SQL Server Instances
· Web Development work - Microsoft - ASP.NET, C#, VB.NET
· Web Development work - Java - JSP, Servlet
· Very comfortable with MS Windows OS (Microsoft NT, 2000, 2003)
· IBM Notes (Programming)
· Apache web server
· Oracle (some DBA & PL/SQL development work)
Healtheon/WebMD, Inc (May. 1999 - Dec. 2000)
Roles: Database Architect, DBA, Data Modeler, Web Developer, Lead Developer,
Systems Engineer
Managed multiple Microsoft SQL Server databases. Supported Web Community
system. End users were allowed to register, subscribe to newsletters, and
participate in virtual communities.
Co-designed & developed Java based Email Newsletter distribution system.
Highlights & Tools
· Installed and configured LDAP Directories (MS Active Directory & MS Site
Server)
· Wrote applications using Microsoft ASP, ADSI (Active Directory Service
Interface), VBScript, Jscript, and Visual Basic
· Microsoft IIS
· Borland's Delphi
· Microsoft's SQL Server
· Microsoft's Transact SQL
· Microsoft Visual C++
· Erwin
· Embarcadero ER/Studio
· Designed logical & physical data models - Able to study business, design,
socialize, & tune data models
Franklin Templeton (April 1997 - May 1999)
Roles: DBA, Data Architect, Data Modeler, Web Developer, Lead Developer, Systems
Engineer
Developed and maintained numerous systems that helped customer service track
customers investments.
Highlights & Tools
· Microsoft Visual Basic
· Microsoft IIS
· Microsoft's SQL Server
· Microsoft's Transact SQL
· Visual Cafe Java
· Microsoft MTS (Messaging)
· Database modeling tools (Erwin)
Exodus (Dec. 1997 - May 1999)
Roles: DBA, Data Architect, Data Modeler, Web Developer, Lead Developer, Systems
Engineer, Sustaining Engineer
Responsible for streamlining distributed architecture for a system that supports
global web hosting infrastructure. Completely rewrote sales, customer support,
and Inventory management system.
Highlights & Tools
· Microsoft SQL Server
· Borland Delphi
· Microsoft IIS
· Crystal Reports
EBSCODOC (May 1997 - Dec 1997)
Roles: Web Developer, DBA
Responsible for designing and implementing Internet Commerce Site.
Highlights & Tools
· Microsoft Internet Information Server (IIS)
· Microsoft Active Server Pages (ASP)
· Microsoft Transact SQL
· HTML & JavaScript
Siemens Communication (Dec. 1996 - May 1997)
Roles: DBA, Developer
Managed SQL Server databases. Responsible for converting legacy applications to
Java. Developed a gateway application written in Java. The application receives
requests from the PC and services those requests on a DB/2 database system
residing on MVS. The communication module consists of JDBC, JDBC-ODBC bridge,
ODBC, and SNA.
Highlights & Tools
· Microsoft SQL Server
· Microsoft Internet Information Server (IIS)
· Microsoft Active Server Pages (ASP)
· Microsoft Transact SQL
· Java & JDBC
· HTML & JavaScript
The Money Store (May 1996 - Dec 1996)
Roles: Architect, Lead Technical Developer
Lead programmer on a project that tracks home mortgages. The GUI was written in
Delphi; and the backend was an Informix database.
Utilized object oriented techniques to build components. Tuned database to
optimize performance.
Highlights & Tools
· Borland Delphi
· Informix Database
· Microsoft Visual Basic
· SQL
MCI Telecommunications Corp. (August 1993 - May 1996)
Roles: Architect, Project Lead, Lead Technical Developer
Developed Human Resources application. Application allowed company to track
employee's information. Information tracked included organization's flow-chart,
security and access data, and employee's personal data.
Gained tremendous hands on experience managing Microsoft SQL Server databases.
Databases were installed and utilized nation wide. Responsible for all remote SQL
Servers. Provided database training to programmers and end-users. Offered
solutions to end-user questions regarding database maintenance, optimization,
networking, and programming.
· Microsoft Visual Basic
· Microsoft SQL Server
· Microsoft C++ (Foundation Classes)
· Borland Delphi
· Informix Database
· Microsoft Visual Basic
· Power Builder
· SQL (Sybase, SQL Server, DB/2)
In the past worked for the following companies:
1. Broadway & Seymour, Columbia, SC. August 1992 - August 1993. Software
Developer. Developed applications using C, C++, Presentation Manager (PM), SQL,
and IBM DB/2 and IBM Communication Manager.
2. American Express Health Systems Group, Charlotte, NC. Sept. 1990 - August
1992. Network Specialist. Assisted in managing a Novell Network with thousands
of hosts. Hosts included PCs, Mackintosh, IBM and DEC terminals. Configured
file servers, gateways, bridges, hubs, and modems.
3. Sunbelt Computer Systems, Charlotte, NC. May 1990 - Dec. 1990. Designed
financial database applications for sale to credit unions. Programmed in Visual
Basic.
4. Project Ready, Charlotte, NC. August 1988 - September 1999. Designed
touch-screen based tutorial applications. Tutorials were for students in state
funded post-secondary institutions and adult education.
5. IBM, Charlotte, NC. Jan. 1988 - Aug. 1988. Assembler. Assembled copiers and
printers.
6. Carolina Medical Center, Charlotte, NC. Jan. 1986 - Mar. 1987. Designed
Analysis applications that helps track participants health habits. Applications
were written in Basic, Pascal, and SPSS.
Education
Bachelor of Science. Electrical Engineering Technology, UNCC, Charlotte, NC.
May 1988.
Associate Degree. Computer Engineering Technology, CPCC, Charlotte, NC. May
1985.
Skill Sets
Skill Sets Years
DBASE/Paradox/Clipper 6 years
Delphi 6 years |
