|
|
12345678910111213141516
Resume 6
RONALD L. SWANSON
358 Evergreen Road
Alston, CO 80439
OBJECTIVE:
Database Administrator and Architect, with in-depth technical knowledge combined with strong management/supervisory skills. Hands on professional able to produce positive results in an efficient, quick and cost effective manner. Able to gather client requirements, design and implement work process solutions and database design, along with marketing data analysis, meeting extremely tight time and quality objectives. Skill set includes defining, developing, and modifying database systems, building the logical design model of a database, administering databases, meeting schedules and budgets, working with developers in performance tuning design and functioning as a change agent.
EMPLOYMENT HISTORY:
Various 2001 to Present
Senior Oracle DBA
- Contract positions as required by various companies.
- Built up a data warehouse along with an intermediate log processing database.
- Got into production the replication system for processing web server logs and aggregating the data into a warehouse.
- Set-up a complete backup and recovery system
- Skills used- Oracle administration and installation, performance tuning, Backup and recovery, SQL, PL/SQL, Oracle Designer, Technical documentation
SmartLogic, Westford, CO 2000 to 2001
Senior Database Architect
- Member of the MatchLogic DBA team, involved with the requirements analysis, design and implementation of several re-engineered systems. Successfully developed and implemented several new database systems as well as the supporting processes.
- Worked on the design team that re-engineered the complete data transformation process for incoming client data streams to be loaded to a profile repository data warehouse . This included reverse engineering undocumented existing systems, finding and eliminating bottlenecks and streamlining the entire process.
- Developed the concepts for the metadata portion of the data transformation processes including a database driven job control section.
- Designed and implemented a statistical gathering, reporting and data aging system for profile repositories.
- Designed and implemented an ad server configuration system. This involved moving an existing perl based batch process to a real-time database system.
ExciteSystems, Westford, CO 2000
Database Architect
- Using UML analysis and design, laid the foundation and did proof of concept for an image management system as well as several multi-media presentation systems to increase site traffic and registrations.
- Designed an image metadata database using object-relational technology. The system was implemented to a testing stage and allowed not only standard metadata to be tracked and applied, but contractual information as well. This prevented images from being used in areas outside of contracts.
- Built a system to rapidly deploy multi-media web sites. The sites were developed such that all parameters were stored in a database allowing high efficiency of the time of creative type people. Also, statistics were gathered as to traffic and traffic patterns to fine tune the web site performance.
PrintsNow.com, Boderville, CO 1999 - 2000
Database Manager
- Brought on to develop and build up a database management team that would take the work back from outside contractors that had been used for fast site start-up. This included documenting the existing system, planning the future expansion and developing the required expertise.
- Completely responsible for a 7 x 24 Oracle database operation involving both e-commerce, market data collection, ad serving and e-mail pushes.
- Setup and tested a 7 x 24 database fail over system and data recovery.
- Liaison with marketing department to improve targeting accuracy and increase speed and detail of consumer online registrations with new reporting and analysis tools.
- Outlined and instituted the process of building a database management team for a 7 by 24 e-commerce web site.
ProductFast.com, Alden, CO 1999
Senior Oracle DBA
- Contract position to get a small internet start-up moved to the next growth stage in a production environment.
- Moved in-production websites to a new ISP while upgrading software versions with minimal downtime.
- Did a complete analysis and major performance tuning on the production system.
Florence Daniel, Alden, CO 1995 - 1999
Project Information Manager, Computer Integrated Engineering Manager and Oracle DBA
- Worked as a project information manager on a 1.2 billion dollar project and as the Computer Integrated Engineering department manager. Took the office from minimal CAD experience to utilizing intelligent 3D design systems which involved a tremendous change in work attitudes across several cultures.
- Directed the integration of information flow using new automation tools that resulted in less costs and error free design execution.
- Managed the cradle to grave integration of information and data flows between different groups.
- Guided the building of a uniform set of work procedures on inter-office work sharing of data and information at a scale not been done before.
- Worked with clients, after project award, to establish technical requirements and goals. Translated these into technical specs and procedures for implementation.
- Consistent work processes were established between 3 offices, enabling work load balancing, eliminating personnel transfers and crossing cultural and technical boundaries.
Raylon Engineers, Steelwood, CO 1985 - 1995
Computer Aided Engineering Support and Oracle DBA
- Sole Oracle DBA responsible for several databases on different engineering projects. Not only supported and tuned the databases, but worked with the end users to develop new applications and reporting systems.
- Supported and developed Oracle RDBMS and systems for the Design Teams. Wrote procedures and automated work processes.
- Defined goals and objectives, managed major projects, developed and managed budgets, and dealt effectively with management responsibilities.
TECHNICAL SKILLS
Databases: Oracle, Informix, Access
Operating Systems: Windows NT and UNIX Solaris & LINUX
Software: Oracle RDBMS, SQL*Plus, Oracle Designer, Microsoft Office, Lotus Notes, Various CAD software, Microsoft Project, Power Designer
Languages: SQL, Perl, PL/SQL, Java minimal , C, HTML beginner
Other: Oracle Database Administration, Database Design, Apache web server, database performance tuning, database backup and recovery, data cleansing, data bulk loading, specification writing, customer interface, UML Analysis and design
EDUCATION
MS, Computer Science, University of Denver
MBA, University of Houston
BSEE, Iowa State University
Registered professional Engineer
Colorado, Missouri, Idaho, and Texas
Oracle University- Oracle Fundamentals and Advanced Query Techniques, Oracle Database Administration and Oracle Application Performance Tuning, Develop Web Based Applications in JAVA and PL/SQL, plus Oracle Application Server Administration, Database Design Analysis using UML
Continuing Training- Supporting NT Servers and Workstations, Novell system administration
Management and Supervision- Developing Positive Assertiveness, Effective Speaking, Managing Human Performance, Written Presentation of Ideas, Supervisory Management
12345678910111213141516
|
|