Open to opportunities

Sanchia Gonsalves

@sanchiagonsalves

Message

Accomplished database developer specializing in optimizing large-scale systems.

United States

Message

What I'm looking for

I seek a collaborative environment that values innovation and offers opportunities for professional growth.

I am an accomplished database developer with a proven history of optimizing large-scale systems, leading complex migrations, and automating critical processes. My expertise lies in translating business needs into scalable solutions that deliver measurable gains in performance, reliability, and data integrity. With over 8 years of experience in Oracle PL/SQL and 5 years in Postgres PGPLSQL, I have honed my skills in designing and implementing vector data architectures, particularly in Oracle AI Vector Search.

Throughout my career, I have successfully managed large-scale database projects, including migrations from Oracle to PostgreSQL, and have consistently improved performance metrics by optimizing queries and implementing real-time monitoring solutions. My role as a Senior Database Developer at Landis & Gyr involved leading data migrations and mentoring junior colleagues, fostering a culture of continuous improvement and knowledge sharing. I thrive in collaborative environments where I can leverage my technical expertise to drive innovation and efficiency.

Experience

Work history, roles, and key accomplishments

Current

Senior Database Developer

Current

Landis & Gyr

Jan 2023 - Present (2 years 6 months)

Optimized queries and stored procedures, significantly improving performance and scalability for datasets exceeding multiple terabytes. Led large-scale data migration and database object conversion from Oracle to PostgreSQL using the MTK (Migration Toolkit), leveraging pre- and post-migration scripts to ensure 100% schema compatibility and data integrity.

Query Optimization PostgreSQL Oracle Data Migration Bash Scripting Database Administration Performance Monitoring Data Warehousing Cloud Platforms

Database Developer

Agile Assets (Trimble)

Jan 2020 - Present (5 years 6 months)

Managed database conversion projects from Oracle to Postgres by translating business requirements into technical specifications and leading Scrum ceremonies. Optimized queries for large datasets, significantly improving dashboard load times by 40-70% for Infrastructure Management.

Oracle PostgreSQL Scrum Query Optimization Groovy JSON XML CI CD Jira Bitbucket Confluence

Database Team Lead

Kapsch

Jan 2015 - Present (10 years 6 months)

Designed and developed database objects to support new projects handling complex tolling transactions, enhancing system efficiency and scalability. Engineered data marts and implemented BI solutions for the Port Authority of NY, enabling roll-up/drill-down capabilities for traffic and revenue analysis.

Database Design Data Marts SQL Data Analysis Mentorship

Data Analyst

TXDOT

Jan 2013 - Present (12 years 6 months)

Generated detailed toll operations reports and performed data analysis to resolve tollway issues; conducted systems audits and reconciliations to ensure data integrity. Identified major tolling violators through in-depth analysis of revenue, reconciliation, and billing reports.

Data Analysis Reporting SQL Data Integrity Financial Analysis

PeopleSoft Developer

Accenture

Jan 2008 - Present (17 years 6 months)

Developed an Order Management System using PeopleSoft for AT&T, enhancing order processing efficiency. Designed and implemented application pages and business logic on the PeopleSoft Application Server.

Peoplesoft Order Management Oracle

Education

Degrees, certifications, and relevant coursework

Texas A&M University, Mays Business School

Master of Science, Management Information Systems

Grade: 3.8/4.0

Completed a Master of Science in Management Information Systems. Achieved a GPA of 3.8/4.0, demonstrating strong academic performance in the field.

BMS College of Engineering

Bachelor of Engineering, Medical Electronics (Biomedical Engineering)

Grade: 3.8/4.0

Obtained a Bachelor of Engineering in Medical Electronics (Biomedical Engineering). Maintained a GPA of 3.8/4.0, reflecting a solid understanding of engineering principles.