Robert Padilla Email & Phone Number

Beverly, Massachusetts, Us

Boston, Ma, Us

o Member of the Data Tech SQL Performance Team. Responsible for maintaining performance on several petabyte-sized servers.o Additional responsibilities include optimizing SQL queries, designing tables, monitoring servers for maximum efficiency, and reviewing code.o Projects include - Meta Data collection (collect data across all servers); Index Maintenance (uses a rules engine to determine if/when to run) and Server Reviews (uses metadata along with a collection of data from monitoring to find trends and allow us to find Servers to proactively review).o Used many tools and techniques to improve the performance of queries, including extended events, query plans, query rewrites, hints (when only option), and index changes.o I also worked with Google Cloud SQL (Postgres) and Google Big Query.o Mentor to co-workers and other engineers.

Washington, Dc, Us

o Subject matter expert for the department – “go-to” person to fix problems and review designs.o Performance tuning SQL code using many methods, some of which include altering indexes and rewriting code. Used tools such as extended events, profiler, query plans, and DMVs.o Transfer data between multiple systems using several methods, including multiple methods of replication, SQL Server Integration Services (SSIS), and BCP.o Mentor to co-workers.o Lead SQL Developer:o ATOS, a decision support system used by inspectors for oversight of flight safety.o SPAS, a data repository of multiple government agencies’ air carrier data. Used by inspectors, supervisors, and analysts to query and analyze air traffic data trends.o SRT, a master set of reference information used throughout the FAA.o MSAD, a risk-based decision-making tool used by FAA personnel to collect and analyze safety data.o Database Architect:o Designed databases to support FAA applications, to ensure system scalability, security, performance, and reliability.o Strategies included modeling, design, and implementation stages to address FAA requirements.

Hamilton Hm19, Bm

o Database Developer for claims, underwriting, security, and reporting applications.o Architected and coded Claim Logging system.o Responsible for overseeing the development of all in-house applications.o Created an automatic interface between claim/underwriting applications and a general ledger system.o Designed and implemented a data warehouse, which used multiple input sources.

Hartford, Ct, Us

o Created a phonetic search engine and linked multiple databases over a wide area network.o Automated feed from multiple databases to 3rd party vendor’s database.o Assisted with the design and implementation of the data warehouse.o Mentored several employees in SQL.o Programmed reinsurance ceding application that handles billions of dollars in transactions. o Modified booking application that moved data between relational tables, flat files, and the mainframe.

Boston, Ma, Us

Us

Cambridge, Ma, Us

Albuquerque, Nm, Us