Job description
- proficient in writing, reading, and updating Stored Procedures
- proficient with standard SQL functions (DATEDIFF, CAST, MIN/MAX, ISNULL, COLLATE, CONCAT, SUBSTRING, COUNT, ROW_NUMBER, ETC)
- experience using IF, CASE, and WHILE statements
- experience creating and using #temp tables
- experience with complex JOIN/LEFT JOIN/APPLY from multiple DW tables and lookup tables
- experience writing complex SELECT statements, INSERT and UPDATE statements
- experience using TRY/CATCH and TRANSACTION statements
- experience using multiple database servers and multiple production and test environment
Required Skills : 3-5 years SQL Development Experience
Strong verbal and written communication skils proficient in writing, reading, and updating Stored Procedures proficient with standard SQL functions (DATEDIFF, CAST, MIN/MAX, ISNULL, COLLATE, CONCAT, SUBSTRING, COUNT, ROW_NUMBER, ETC)
experience using IF, CASE, and WHILE statements experience creating and using #temp tables experience with complex JOIN/LEFT JOIN/APPLY from multiple DW tables and lookup tables experience writing complex SELECT statements, INSERT and UPDATE statements experience using TRY/CATCH and TRANSACTION statements experience using multiple database servers and multiple production and test environment
?
Basic Qualification :
Additional Skills :
Background Check :Yes
Drug Screen :Yes
Notes :Remote, supporting CST time zone hours
Selling points for candidate :
Project Verification Info
Exclusive to Apex :No
Face to face interview required :No
Candidate must be local :No
Candidate must be authorized to work without sponsorship ::No
Interview times set : :No
Type of project :Development/Engineering
Master Job Title :Dev: SQL Server Database
Branch Code :Orange County
Interested in this role?
