Ms Access/ SQL server full stack expert

Apply Now

Company: Centraprise

Location: Seattle, WA 98115

Description:

This is Jami from CentraPrise. We have urgent position of Ms Access/ SQL server full stack expert locationin Seattle, WA. If you are interested please share your updated resume with contact details.

Position: Ms Access/ SQL server full stack expert

Location: Seattle, WA

Duration: Fulltime/Permanent Position

Candidate must be open to relocate after Covid lockdown

Over 5 years of IT experience in the Analysis, Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite Development, UAT and Production Environment.

Experience in Design and Development of Database and Business Intelligence with SQL Server 2008R2.

Strong technical knowledge in MS Access/MS SQL Server development including DTS, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.

Extensive experience with different phases of project life cycle Analysis, Design, Implementation, Testing, and debugging new and existing client-server based applications .

Experience in writing the TSQL Statements, stored procedures, functions using SQL Server.

Experience in creating the packages or batch jobs for loading the data from one server to other using SSIS.

Experience in creating the reports for proving the monthly and quarterly reports to the clients.

Worked with QA team for fixing the bugs in the code and used Jiira and Spira Test tool for updating the defect status.

Experience in using TFS 2012/2008 for maintaining the source code like check-in, check-out, merging and branching the source code.

In-depth knowledge of T-SQL, SSRS, SSIS, Reporting and Analytics.

Experience in SQL Server DTS and SSIS Integration Service package design, constructing, and deployment. Transformed data from one server to other servers using tools like Data Transformation Services DTS and SQL Server Integration Services SSIS 2005/2008/2013 .

SQL Server 2005/2008 RDBMS database development including T-SQL programming.

ETL implementation using SQL Server Integration Services SSIS .

Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSIS projects.

Knowledge on integration of BI suite of products with Microsoft Office range of products like Business Scorecard Manager, Dashboards, Performance Point Server.

Worked in Data modeling, creating star and snowflake schemas in SSIS. Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.

Thanks & Regards

Jami |Sr. Technical Recruiter

Centraprise Global





www.centraprise.com

Similar Jobs