Allen Feitl

Full-stack Engineer • Customer Success Manager • East Windsor, NJ, US

Database Design

Database Queries

Data Migration

Databases

Data Cleansing

Available for hire fromNegotiable

Contracts

Streamline Your Data with Professional Relational Database Design and Development Services

I have worked with Relational Databases for over 20 years as a database designer/architect, developer, DBA and performance and tuning analyst. I have extensive experience with MS SQL Server, Oracle, PostgreSQL, Access and MySQL. I have built many queries that produce KPI or other critical business information in a format that users can understand and use. I have designed and built many databases, the largest being for a telecom application with over 700 tables, several of which have many millions of rows. Performance and tuning has always been a key part of my work. I have also had several projects where I was responsible to provide a process to “clean” the database of potential problems caused by missing or incorrect data.

Projects

Design and Development of the Data Tier of a major Telecom Project

The application designs and builds telecom services automatically. Messages are received from a front end system that provide information about the service needed such as the end points (your house), the type of service (residential, business, data, video, etc) and the speeds required. The system figures out the best use of the available equipment and cables and creates a design, It then contacts the telecom equipment in the field and instructs it to create the correct service. The database was a combination of an inventory (of equipment, cables, spare and in-use ports and cable pairs, and existing services and what inventory items they are using and a set of specifications for available services that the Telecom company wished to sell. The database contained over 700 tables.. It included stored procedures and stored packages, triggers, and a java API for the business tier developers to access the database. This is a high performance, high volume application. 98% of orders for new or changed services flow through this application without human intervention. Many of the tables exceeded 1 million rows in production and several exceeded 10 million rows. The queries contained many complex joins and a lot of work went into performance and tuning the database and the queries. I was the database designer and lead developer for the data tier. The data tier included a java API for the business tier to receive the data they needed with understanding the underlying data structures.See More

Microsoft SQL Server DB Architect and SQL Developer

The project was to automate an insurance company's processes, from the initial application for insurance to the issue of a policy. I was the Lead Database Developer on the project. The database had over 200 tables and over 2000 stored procedures. The project took almost 2 years and was implemented on time and within budget. We went live in November, 2022 with no major issues. Client Feedback: "Allen was key part of a project for our largest client. He dealt with a very complex environment and many technical challenges. He was integral to the success of the overall project." See More

Porting SQL Server DDL to Oracle

This project included converting a medium sized database and stored procedures from MS SQL Server ro Oracle and loading data into the database. Client Feedback: "Al is a database expert and helped tremendously with this project."See More

Migrate Database

Migrating an existing database from an MS SQL server to MySQL. Client's feedback: 5 StarsSee More

Need DBA to do Database Tuning

Test and monitor performance of SQL queries and improve performance Client Feedback 5 StarsSee More

Work History

Freelancer

Allen FeitlFreelance Database Consultant

Senior Consultant - Database

Advanced Technology GroupJul 2016 - Dec 2017 • 1 yr 6 mosProvided production support for several 3rd party applications running Oracle Databases. This included typical application upgrade support, trouble shooting, and SQL or PL/SQL query development. I also developed a webpage of various audit type reports that could be run periodically by the end users to identify database inconsistencies or missing data that could cause problems in later processing. These applications provided over 98% flow-through without human intervention, so correcting these errors before they caused problems was critical.

Senior Software Engineer

Ericsson, Telcordia Technologies, Bell Communications Research (Bellcore)May 1984 - Mar 2016 • 31 yrs 11 mosThe company name changed 3 times while I worked there. I worked 7 years as a consultant and 25 years as an employee. Responsibilities included A major Telecommunications application: Data Tier design and development (Oracle), Business Tier development, Automated Interface development, DBA (Oracle), performance, and customer support. Multiple other telecommunications applications: Performance and Tuning Analyst responsible for performance tuning of production environments at customer sites and measuring release over release performance differences in house.

Education

Stevens Institute of Technology

Masters Degree, Computer ScienceSep 1995 - May 1998

New Jersey Institute of Technology - Newark College of Engineering

Bachelors Degree, Electrical EngineeringSep 1966 - Oct 1970

How Pangea Works

Effortlessly discover top talent

We’ve distilled the candidate search from endless hours down to just a few minutes. Using Pangea’s AI-powered search tools, you can find top fractional talent able to take on your next project. Our system looks at your company’s niche and your needs to find the perfect match faster than any traditional hiring platform.

Start working with talent today

The top talent on Pangea is ready to get started with you right now. You can message or hire a candidate right from their profile page and start assigning work as soon as they respond. And the best part? Pangea’s fractional contract structure lets you start small and ramp up as your needs change, keeping your costs manageable and your team’s capabliities flexible.

Track work and invoices in one place

Assign tasks, track progress, and complete invoices all on Pangea. We’ve combined every part of the hiring process into one platform to eliminate the miscommunication that’s unavoidable on other freelance platforms. We even send out 1099s to your contractors at the end of the year!

Talk with a Talent Expert

Members of our team are available to help you speed through the hiring process.

Available Now

Book a Call