Sarah Tuttle
Cedar Park,TX
Summary
SQL Developer and Data Architect with over 20 years of progressive experience in Oracle and PostgreSQL, databases and application programming. Dedicated to building customized technical solutions in alignment with operational needs and objectives. Critical thinker, analyst and problem solver known for continuous delivery of quality products across diverse business environments.
Encouraging manager and analytical problem-solver with talents for team building, leading and motivating, as well as excellent customer relations aptitude and relationship-building skills. Proficient in using independent decision-making skills and sound judgment to positively impact company success. Dedicated to applying training, monitoring and morale-building abilities to enhance employee engagement and boost performance.
Overview
22
22
years of professional experience
Work History
Sr. SQL Developer & Data Architect
Tangoe
Austin, TX
04.2015 - Current
- Produced robust, accurate code that minimized production issues.
- Evaluated and improved development work of other developers on team, working to provide training, constructive criticism and knowledge transfer.
- Collaborated with other developers to identify and alleviate software errors and inefficiencies.
- Adjusted design parameters to boost performance and incorporate new features.
- Optimized performance through testing and tuning of applications.
- Worked with users to gather requirements and evaluate ease of use.
- Developed programs from ground up using measured, market-focused approach to eliminate waste and streamline implementation cycle.
- Designed robust future forward OLTP and OLAP designs
- Analyzed existing SQL queries to identify opportunities for improvements.
- Drove data analysis, resolving complex business issues and proposing long-term system solutions.
- Analyzed complex SQL installations to help plan data extraction and processing tasks, aiding in eventual deployments.
- Devised high-quality database solutions ranging in size and complexity, increasing productivity and improving data sharing.
- Produced high-standard database solutions to meet stability, reliability and performance metrics.
- Developed custom database objects, stored procedures and delivered application support.
- Drafted data mapping documentation for relational databases to establish standardized formats.
- Designed and developed customized extract, transform and load (ETL) applications per client specifications.
- Maintained data delivery pipelines to support consistent and reliable availability.
- Extracted and transformed multi-source data, incorporating assets into unified databases while monitoring integration and replication performance.
Sr. Lead Software Developer
Texas A&M University System
College Station, TX
09.2014 - 04.2015
- Maintain and support existing oracle data warehouse system and front-end reports
- Integrate and merge external data sources into data warehouse and transactional data structures
- Design and implement enhanced and extended data requirements into current system
- Design and migrate data architecture and ETL process to support data trust/integrity, scalability, simplified reporting, and advanced data analytics.
Technology Director / Sr. Software Engineer
Levelwing
Charleston, SC
01.2012 - 12.2013
- Leadership and mentoring of team members facilitating in team growth and career fulfillment
- Analyzing company processes and procedures in order to design and build automation and optimization frameworks in order to enhance overall team and department efficiencies
- Complete system architectural design, purchase, implementation, and administration of all hardware and software system components
- Design, develop, implement, and maintain from concept to production; all data ETL processes and database schemas for data warehouse and OLTP architectures
- Design, develop, implement, and maintain Oracle PL/SQL packages and web application interfaces using Oracle
- APEX, Perl scripting, PHP, and jQuery for end-user data interaction
- Manage and administer Oracle 11g databases and middle tiers running on a cluster of Linux servers.
Independent Consultant
- Design and develop web based package deployment system for windows based systems
- Worked with existing team to develop package-naming convention to provide logical versioning identification
- Designed and implemented MySQL database schema storing relational package and deployment information to be accessed and maintained through web based systems
- Designed and implemented web based system using perl, apache, and windows ps tools to provide one touch package deployment across multi server environments
- Designed and implemented web based deployment historical data interface providing access to deployment system logs, times, package versions, and personnel responsible for deployment activities
- Updated and enhanced home-grown ticketing system to provide greater reliability and new features including greater search criteria as well as tying the ticket system information to external data systems.
Sr. Software Engineer
Management Science Associates
Pittsburgh, PA
08.2007 - 12.2011
- Oracle application design, architecture, and performance tuning
- Develop new and support existing PL/SQL packages and procedures
- Analyze current product design and provide recommendations to address performance issues with a variety of schema updates, such as reorganizing or creating indexes, and data access methods, such as bulk and set processing
- Provide guidance and assistance to developers of multiple programming languages and expertise to address application design for high performance and scalable development
- Provide innovative, cost effective, and scalable solutions to meet the application requirements and allow for future design growth
- Work with multiple groups, bridging technical gaps to ensure understanding and progress in application support, quality assurance and design.
System Developer
Raeder Landree
Pittsburgh, PA
04.2007 - 06.2007
- Design and develop Oracle 10g PL/SQL system to collect and organize billing critical data from a legacy Sybase system and transport the data in a defined XML format to a remote system over http
- Developed a web-interface for testing and monitoring the new legacy xml consumption and transport system to simplify system problem identification and resolution by less technical business groups
- Developed a PL/SQL package to provide a simplified interface and framework for using Oracle 10g’s new XML functionality for future company use.
System Architect / System Developer / Integration Specialist
Boingo Wireless
Santa Monica, CA
08.2001 - 03.2006
- Troubleshot incidents reported by end-users to schedule system changes and identify permanent solutions.
- Analyzed existing systems and databases and recommended enhancements to solve business needs
- Collaborated closely with upper management to drive strategy through development and implementation of new processes.
- Communicated and explained business requirements to team members to understand and implement functional demands.
- Quickly learned new skills and applied them to daily tasks, improving efficiency and productivity.
- Used critical thinking to break down problems, evaluate solutions and make decisions.
- Performed internal system acceptance to deliver well-tested enhancements and meet business requirements.
System Administrator / Integration Systems Developer
Onemain/Earthlink, Inc
Reston, VA
01.2000 - 08.2001
- Developed dispersed authentication system for dial-up customer network access
- Responsible for seamlessly integrating entire user bases of acquired ISP’s into an LDAP database for RADIUS authentication
- Troubleshoot/Maintained daily operation of RADIUS authentication system
- Installed, maintained and upgraded all UNIX (Solaris) servers running LDAP directories and RADIUS servers
- Provided research and instruction to team members regarding NAS authentication configurations
- Developed, implemented, and maintained Perl and C programs for integration
- Load new configuration on to legacy servers
- Troubleshoot/Repair integration inconsistencies throughout entire process
- Resolved post integration problems
System Administrator
Penncom a Onemain Company
Warren, PA
01.1998 - 01.2000
- Responsible for the development of web-based applications for customer interfaces (Account administration / Email maintenance) utilizing C, Perl, CGI, Sockets (Internet and Unix Domain)
- Responsible for systems and network administration, and technical support supervision of 12 employees
- Perform regular monitoring of LDAP servers and backups
- Provide support in troubleshooting and resolving service issues including email, virtmail, WebPages, dial-up access, etc
- Designed, developed and implemented programs to improve daily processes and monitoring of LDAP servers/services
- Maintain and modify the Penncom LDAP schema as needed utilizing x.500 standard
- Provide on-call response to service issues and support to others regarding LDAP and DNS configuration and administration
- Manage complex technical service upgrades/changes such as installing network-wide backup-software, server monitoring software, etc
- Apache web server setup and maintenance for over 600 commercial websites
- Implement security policies for over 30 Unix servers / update OS and kernel patches
- Functioned as Portmaster for ComOS updates and modifications
- Responsible for monitoring network activity and bandwidth utilization, which also included backup and disaster recovery
- Maintain WAN topology diagrams and documentation
- Configure Cisco Catalyst switches
Education
High School Diploma -
Warren Area High School, Edinboro University
1993
Skills
- Extraction Transformation and Loading (ETL)
- Scrum Methodology
- Source and Version Control: Git, GitHub
- Databases: Oracle, PostgreSQL
- Bug Fixes
- Programming Languages: Python, Database Procedures & Functions, Bash
- Developing Databases, OLTP & OLAP Architecture Design
- Data Extracting
- Database Optimization
- AWS ( S3, RDS, Redshift, Lambda, Glue Spark )
- Team Mentoring and Support
Timeline
Sr. SQL Developer & Data Architect
Tangoe
04.2015 - Current
Sr. Lead Software Developer
Texas A&M University System
09.2014 - 04.2015
Technology Director / Sr. Software Engineer
Levelwing
01.2012 - 12.2013
Sr. Software Engineer
Management Science Associates
08.2007 - 12.2011
System Developer
Raeder Landree
04.2007 - 06.2007
System Architect / System Developer / Integration Specialist
Boingo Wireless
08.2001 - 03.2006
System Administrator / Integration Systems Developer
Onemain/Earthlink, Inc
01.2000 - 08.2001
System Administrator
Penncom a Onemain Company
01.1998 - 01.2000
Independent Consultant
High School Diploma -
Warren Area High School, Edinboro University
Similar Profiles
YASH SINGHYASH SINGH
Internal Auditor at TangoeInternal Auditor at Tangoe
Stephanie KoskiStephanie Koski
Procurement Specialist/Mobile Order Reconciliation at TangoeProcurement Specialist/Mobile Order Reconciliation at Tangoe
Abby WilmAbby Wilm
Service Delivery Analyst at TangoeService Delivery Analyst at Tangoe