Lee Teague's Resume

Lee Teague 2257 Stuttgart Drive Frisco, Texas 75034 469-348-5581 lteague@lteague.com	Skills
	Designing and developing data-centric technology systems Business Intelligence and Data Warehousing Configuring, tuning and maintaining databases, specifically Oracle, SQL Server, and open source databases UNIX and Linux configuration, maintenance, administration, support, and security Team management Languages and Other Software: SQL, PL/SQL, T-SQL, Java, C#, PHP, C/C++, XML, SOAP, CVS, Subversion, Bash/Korn Shell Scripting, Tcl, Perl, Python, Ruby, Apache, lighttpd, FastCGI, IIS/ASP.NET, AOLserver, HTML/Javascript/CSS Databases: Oracle 8i/9i/10g/Express, Oracle Recovery Manager (RMAN), Oracle Data Guard, Oracle Real Application Clusters (RAC), Oracle Business Intelligence (Siebel Analytics), Microsoft SQL Server 2000/2005/Express, Microsoft Data Transformation Services (DTS), Microsoft SQL Server Integration Services (SSIS), MySQL 3/4/5, PostgreSQL 6/7/8, SQLite Operating Systems: GNU/Linux, including Debian, Red Hat, SuSE, Slackware, Mandrake, Ubuntu, and Gentoo, Sun Solaris, Microsoft Windows 2000/XP/2003
	Work Experience
	Application Developer 2/2007 - Present Verizon Wireless, Southlake, Texas Utilized data warehousing techniques including star and snowflake schemas to design a data model for reporting outages Designed and developed reports using Oracle BI (Siebel Analytics) Responsible for installation and configuration of Oracle BI Supported other team members in the usage of advanced Oracle SQL and query optimization Developed and maintained Java, perl, and PL/SQL code responsible for large data warehouse ETL processes
	Systems Engineer/DBA 4/2005 - 2/2007 IRM Corporation, Dallas, TX Designed data model and data access layer for complete rewrite of IRM's flagship BI product, Sales Discovery System (SDS). The existing application uses a proprietary data store which is reaching its limits in terms of the amount of data it can process, so the database was replaced by SQL Server Express on the desktop with a SQL Server 2005 server component. Developed the flat file loader component of the new version of SDS. This tool imports flat files from the network into a local database, validates and transforms the data into the optimized format required for the SDS viewer, then copies the data to a central database server. Designed job dispatch system to manage SDS loader executions. This system provides a central front end for several loader processes distributed over multiple machines simultaneously, tracks statistics on job execution, and handles notification when a job succeeds or fails. Designed import/export system for our web-based products. The new data model as well as the legacy data model are both very complex, and it was necessary to develop a flexible system for exporting/importing to/from customers' databases. Managed heterogeneous database server environment . Oracle 8.1.7, 9.0.1, 9.2.0, and 10.1.0 on Solaris, Windows, and Linux Utilized Oracle 10g Enterprise Manager to allow management and other team members to monitor database availability and performance Managed several SQL Server 2000 and 2005 database servers Optimized database performance of ASP.NET web project Implemented build process for ASP.NET web project using NAnt; compiled and deployed development, staging, and production websites as well as database scripts Migrated existing Visual Source Safe repository to Subversion; trained team in its usage
	Software Engineer/Systems Engineer/DBA 10/2000 - 2/2005 Placemark Investments, Dallas, TX Designed several key components of Placemark's investment platform Received promotion from Software Engineer to Systems Engineer/DBA Managed several production servers, including Oracle 9i database servers (Primary and standby for production, staging/testing, and development), web servers, mail servers and application servers Implemented Oracle Real Application Clusters (RAC) Developed a full database replication system using RMAN and Standby databases. This system allowed the development and operations staff to access one day old production data, which enabled them to run reports and diagnose data issues without affecting the production environment. Configured and managed heterogeneous database server environment . Oracle 8i and 9i on Solaris and Linux Primarily responsible for database configuration, maintenance, patches, tuning, and security Provided support and training for development staff Developed backup strategy using RMAN and exports Migrated Oracle Databases from Sun Solaris/SPARC to Linux/x86 Created extensive documentation for database processes Developed application server for client data with security as the first priority Created a framework for developing web applications in Tcl/AOLserver Developed data loaders and migration utilities in Perl Created four-stage release process and coordinated releases from development to production Developed a paperwork generation (PDF) wizard to speed through client account creation Developed a secure transparent login system and integrated it with multiple clients' existing systems
	Programmer/Systems and Database Administrator 3/2000 - 10/2000 Fountainhead Entertainment, Dallas, TX Developed a custom content management system to manage our corporate and product websites Administered the company web, email, and database servers including OS and software installation, software upgrades, and security patches Assessed server and application requirements and made hardware recommendations Provided database support and optimizations for developers building internal and external web applications
	Network/System Administrator 5/1998 - 2/2000 TradeLink, Incorporated, Roanoke, TX Primarily responsible for maintaining employees' desktop computers, network, and employee technical support Administered corporate web, email, and database servers Configured and managed backups of critical data