Expert Details
Database Architecture, Application Architecture, Oracle, SQL Server, .NET
ID: 723392
Georgia, USA
As a database production support specialist and Senior Database Administrator, Expert has been able to ensure his clients the best available uptime by not only properly managing and monitoring the database systems, but also in designing effective disaster recovery plans for the database servers under his care. He worked as a Database Administrator for nearly a decade before graduating to database and application architecture. He brings to the table a level of experience that not many database administrators have, which is very available environments and also multi terabyte database systems. He has managed systems that required cross continent disaster recovery sites and multiple levels of failure for the database, including Replication, Failover Clustering, Database Mirroring and hardware SAN solutions for database backup and recovery.
As a database architect, Expert has developed multi-terabyte database solutions that enable rapid DML operations as well as sub-second response time with very complex query plans. He has the ability to think outside of the conventional box and not only look at traditional methods for database design, but look at a business and how the respective data lives. Sometimes this requires a combination of both OLTP and OLAP design features, which Expert has extensive experience in combining.
Expert has been writing in the C# programming language for over 10 years. He has written many applications for both WinForms and WebForms. He has been able to leverage this language to write logistics planning and capacity applications, Ajax Mashups, countless Web Services, and many other applications for many different industries.
In addition to his years of experience writing distributed and n-tiered applications, Expert has also written many Client/Server applications, utilizing many different backend databases and front end development languages. He has extensive experience writing applications in C#, VB, VB.NET, Delphi, C++, and Java. While Client/Server technology might be growing obsolete, Expert has the experience to look at any existing legacy system and leverage anything already in production to save on valuable development time for new products or projects.
Expert has over 15 years of software and database writing experience. He has developed computer software for many large firms and countless smaller ones. He is proficient in various operating systems including: Solaris, RedHat, HP/UX, AIX, and Windows. He is even more proficient in many programming languages including: Delphi, ASP.NET, C#.NET, VB.NET, J#.NET, C++, Java, JavaScript, VBScript, HTML, and ASP. In addition to his vast programming knowledge he is also proficient in SQL Server, Oracle, and has experience writing applications utilizing MySQL, DB2, FoxPro, Interbase and Microsoft Access.
Given the distributed nature of the Internet and business today, Expert has been involved in many projects that share data between applications and business units. Utilizing many different methodologies, including database links, linked database servers, Web Services, BizTalk as well as other technologies, he has been able to see many applications integrate flawlessly to improve business continuity and provide rapid access to data across many divisions of a company or business unit.
As an application architect, Expert has designed and developed solutions to support hundreds of thousands of concurrent users. He has experience working with web enabled applications utilizing ASP.NET, C# and VB.NET, and he also has extensive experience writing WinForms applications in both C# and VB.NET. He is well versed on the latest .NET technologies and integration to existing systems.
Work History
| Years | Employer | Title | Department |
|---|---|---|---|
| Years: 1994 to Present | Employer: Undisclosed | Title: Senior Internet Architect - Consultant | Department: Architecture - Business Development |
Responsibilities:Expert has worked for this client for over a decade. He has been involved in to many projects to list. The most notable technologies and milestones are listed below.This expert developed over nine custom in-house tools utilizing technologies from Oracle to SQL Server, Delphi to C++ and C#, traditional HTML to ASP.NET 2.0. This client is a service provider for the largest telecommunications companies in the world, including Korean Mobile Telecom, AT&T, BellSouth, Cingular, Intercel, Powertel, T-Mobile, Verizon, Cox Communications, and many others. This client was involved in direct consultations with the US government on the rebuilding of the Iraqi wireless communications network after the initial war with the United States. Tools that this expert built were consulted and used in outlining timelines and deliverables to meet a very aggressive schedule. This expert developed complete solutions for the management of this client, and provided direct interfaces into the accounting and senior management departments. Complete integration with accounting department reduced human error, and need for multiple accountants to be employed with the company. The solutions that this expert built were all internet capable that supported numerous remote offices spread all over the United States, and allowed for Central management of these offices from the main campus in Atlanta, Georgia. |
|||
| Years | Employer | Title | Department |
| Years: 2006 to 2008 | Employer: Cox Communications | Title: Senior Database Architect - Consultant | Department: Architecture |
Responsibilities:He is currently involved in enhancing and maintaining a multi terabyte database environment with complex transformation requirements.He modified and maintained over 800 DTS packages. He maintained over 4000 T-SQL code Objects, and modified then where necessary. He is directly responsible for analyzing all T-SQL objects, the overall server architecture, all database structures and cluster performance for the entire database enterprise related to SQL Server. Within 3 weeks he had fully documented the entire system consisting of over 14 database servers, 100 databases, 800 DTS packages, 10,000(+/-) objects, and four clusters in a mixed environment consisting of Windows 2000, Windows 2003 32 and 64 bit, and SQL Server 2000/2005. He performed a production rollout to all servers to upgrade them all to the latest service pack levels. He moved select databases to the SAN environment to increase database performance, while limiting physical changes to underlying database entities. He installed and upgraded select databases to SQL Server 2005 64 bit to test migration of production systems to new platform for SQL Server. He ran full analysis on DTS package upgrade to SQL Server Integration Services. |
|||
| Years | Employer | Title | Department |
| Years: 2005 to 2006 | Employer: Witness Systems, Inc. | Title: Senior Database Architect - Consultant | Department: Engineering |
Responsibilities:He designed and created a multi terabyte database on SQL Server 2005 and concurrently on Oracle 10g.Database was designed as a hybrid OLTP/OLAP database that provided rapid insertion (12000 transactions per second) while being able to search the multi-terabyte database with sub-second response time with a hardware TCO under $20,000.00 (US). He built this specific database to support thousands of concurrent users of the system. He maintained and wrote all ERWin models and documentation including database design documentation, detailed enterprise database testing plans, recovery and failover documentation, and database dictionaries. He explored and utilized numerous enterprise features on Oracle 10g and SQL Server 2005, including replication, log shipping, database mirroring, partitioning, and indexed views for customer databases that would exceed 1 TB in size. He developed maintenance plans and procedures for customer sites to increase reliability and availability. He developed the database so that it could support a federated database design for SQL Server 2005 using a centralized model, linked servers and unionized views. He built a custom multi-threaded database simulation and loading tool to test and scale the database solution, using C# and the .NET framework 2.0. He designed, documented and tested numerous recovery and failover plans to maximize customer availability. This expert worked directly with numerous clients, some of Witness’s largest, as a DBA consultant. |
|||
| Years | Employer | Title | Department |
| Years: 2005 to 2006 | Employer: industrydiscovery.com | Title: Senior Application and Database Architect - Consultant | Department: Engineering |
Responsibilities:He is the architect of the industrydiscovery.com portal.He wrote a fully Ajax (leveraging some Atlas technology) enabled mash-up that communicates via web services written in C# on the .NET 2.0 platform. He designed and developed OLTP database that stores user information and all available articles for RSS publication. He built and maintains a custom web crawler and searching algorithm to locate relevant data on the web, specifically tailored for industrydiscovery.com (Further developments can be discussed in person, as the project is very confidential) |
|||
| Years | Employer | Title | Department |
| Years: 2005 to 2005 | Employer: Obvient Strategies, Inc. | Title: Senior Database Architect for SQL Server and Oracle | Department: Architecture |
Responsibilities:He managed, administered, tuned and enhanced 24/7 data warehouse environments for various clients.He designed complex ETL procedures and processes to load data into various warehouse structures. He designed and constructed complex margin analysis structures, along with numerous packages, stored procedures and functions, for various complex key performance indicators (KPI). He designed and created calculations engine for rolling up accounting data in hierarchical format within specific dimensions and facts. He provided direct support to both the end user community as well as the development community. He provided direct support on performance issues to isolate and fix performance bottle necks within our system as well as our clients. He was the lead architect in designing our warehouse meta layer. He was the lead architect in the effort to redesign multiple database star structures. He was responsible or all database standards documentation, and provide input on all future design features of the existing data warehouse. He was responsible for maintaining concurrent data warehouse models in both SQL Server and Oracle. He was the technical database lead for the entire company on database related issues for both SQL Server and Oracle. He developed custom performance tracking tools for SQL Server along with interfaces to view the data using Visual C# on the .NET 1.1 framework. He developed custom tool using Visual C# for .NET 1.1 to display all STATSPACK information in a user friendly manner. He was able to manage multiple clients, and multi-task between all clients efficiently while under pressure. He was directly responsible for all in-house DBA responsibilities, including all DR design and implementation. |
|||
| Years | Employer | Title | Department |
| Years: 2004 to 2005 | Employer: Southern Company, Inc. | Title: Database Administrator for Oracle and SQL Server - Consultant | Department: Applications Database Administration |
Responsibilities:He managed, administered and enhanced multi-tier 24/7 environment incorporating approximately 83 SQL Servers (versions 7.0 and 2000), and 437 Oracle instances (versions 7.3 – 9.2).He designed and implemented complex migration and auditing procedures for current SQL Server environments to create standards within the SQL Server environment. He worked on many systems that required compliance with Sarbanes Oxley Constraints. He built tools to audit and alter all 437 Oracle instances at once to install and create auditing objects and Toad objects. He provided direct support to both the end user community as well as the development community, writing complex stored procedures, functions for both SQL Server and Oracle. |
|||
| Years | Employer | Title | Department |
| Years: 2004 to 2004 | Employer: ADP, Inc. | Title: Senior Database Administrator for Oracle and InterBase | Department: Benefit Services |
Responsibilities:Expert managed, administered and enhanced a multi-tier 24/7 environment incorporating Oracle 9i and Interbase 7.1 database platforms servicing 400,000 external participants though web and an IVR connectivity. He performed capacity analysis based on business forecasts, measurement of volume and throughput and present multiple scenarios to senior management future planningHe Collaborated with internal user community for ongoing isolation of persistent application and database issues that require manual workarounds and capture the business needs and management buy in required for resolution. He built a custom tool in Delphi 7 to extract meta data from existing Interbase database for migration to Oracle 9i environment. He built a custom monitoring tool for InterBase in Delphi 8 for .NET for the monitoring and custom job management for the entire FSA system. |
|||
| Years | Employer | Title | Department |
| Years: 2001 to 2004 | Employer: Xelion Technology Services, Inc. | Title: Senior Application and Database Engineer | Department: Engineering |
Responsibilities:He worked for some of our most notable clients, including Ernst & Young, UPS, ChoicePoint and the VanLake Consulting Group (VCG).He built and managed databases to scale and perform in upwards of 150 – 200 gigabytes. He built tools using many technologies for each of our clients, from utilizing DTS in SQL Server to Visual C++ to C on Solaris 8. He deployed and trained clients on Oracle and SQL Server, and also taught Unix/Linux to the clients in how it directly relates to Oracle. This expert was able to provide remote database administration services to multiple clients at the same time operating from our central location in Atlanta, Georgia. |
|||
International Experience
| Years | Country / Region | Summary |
|---|---|---|
| Years: 1996 to 1997 | Country / Region: Brazil, Sao Paulo | Summary: He was a programming and database consultant for BellSouth International based in Sao Paulo Brazil. He worked primarily in Oracle, however did offer programming services in Delphi using Midas as the application server. |
Fields of Expertise
database, Oracle, SQL database, Structured Query Language, Oracle application architecture, database management, database management system, database server, database technology, multidimensional database, object-oriented database, object-oriented database management system, database design, client/server architecture, client/server computing, computer software, .Net, Microsoft Windows programming, active server pages, computer system integration, software engineering, World Wide Web application, World Wide Web programming, JavaScript, data warehouse, Sarbanes-Oxley, legacy, SQL server, information architecture, database recovery, backend technology, software regression testing, Pascal programming language