SQL Data Base Development(English Only) (3785992)

Programming & Development

SQL Data Base Development(English Only)

$50/hr Starting at $100

10 years SQL experience. I can write stored procedures, functions, and optimize those you already have. I can troubleshoot performance issues and help you design new processes that are scalable, extensible, and most importantly, manageable. Extensive work with SSIS, integrating systems, and more. Designed integration solution for client data into business systems. Installed, configured, maintained SQL server 2017, 2019. Top to bottom SQL Server Maintenance and performance tuning. Performed ETL utilizing various techniques SSIS, BCP. In depth utilization of SSIS. Designed both normalized and de-normalized relational data models to support data warehousing and OLTP design patterns. Implemented email parsing for data warehouse integration Designed custom CLRs for making web requests from SQL server. Integrated external APIs with backend data structure. Designed integration solution for client data into business systems.

About

$50/hr Ongoing

Download Resume

10 years SQL experience. I can write stored procedures, functions, and optimize those you already have. I can troubleshoot performance issues and help you design new processes that are scalable, extensible, and most importantly, manageable. Extensive work with SSIS, integrating systems, and more. Designed integration solution for client data into business systems. Installed, configured, maintained SQL server 2017, 2019. Top to bottom SQL Server Maintenance and performance tuning. Performed ETL utilizing various techniques SSIS, BCP. In depth utilization of SSIS. Designed both normalized and de-normalized relational data models to support data warehousing and OLTP design patterns. Implemented email parsing for data warehouse integration Designed custom CLRs for making web requests from SQL server. Integrated external APIs with backend data structure. Designed integration solution for client data into business systems.

Skills & Expertise

API DevelopmentData ManagementData WarehousingDesignEmail ServicesEnglish LanguageModelingPattern DesignServer AdministrationSQLSsisStored ProceduresStructural Engineering

Related Work Collections

5 Reviews

mnrland says,

quick accurate work

for Create mailing list Real Estate on Apr 29, 2010
pivotalwriting says,

Roger provided a cost-effective solution in a very efficient manner. He converted contact information scattered across a large website into a single MS Excel spreadsheet. I would recommend Roger's services to anyone who needs similar services, and I plan on keeping him in mind for future work. Thanks for your help, Roger.

for Compile a spreadsheet with contact info. on Apr 08, 2010
Michelle_Murphy says,

Great job and completed it in record time. Thanks!

for Directory into Excel on Mar 31, 2010
Goeppert LLC says,

Excellent screenscrapper Guru. Fast and efficient. Very easy to work with.

for List management on Mar 02, 2010
Ken_Dixon says,

Roger quickly sorted 10k names and addresses and provided phone numbers from various web sources. Would definitely use him again.

for Find Phone #s from Name/Address list on Feb 25, 2010

Roger Leonard