SQL Developer

SQL, T-SQL, AZURE, ETL, SSIS, Data Factory
Contract Corp-To-Corp, Contract Independent, Contract W2, 12 Months
Depends on Experience
Work from home not available Travel not required

Job Description






SQL Developer ***Local candidates preferred; client requires face to face technical interview***



Essential Duties and Responsibilities:




    • Assist in maintaining and managing all versions of data models for production, testing and developing databases.

    • Analyze access patterns and propose the best combination of indexes, constraints, foreign keys, and queries.

    • Create and/or enhance existing stored procedures, views, functions and SSIS 2012 and above







    • Create processes to ensure clean data






  • Create processes that synchronize, check and balance for on premise data to and from azure cloud/third parties vendors.

  • Prepare data for job runs, support existing jobs. Troubleshoot, analyze and repair production issues.

  • Assists in day to day operations to support centralized data processes.

  • Write ad-hoc and complex SQL queries to support data analysis.



Requirements




    • At least 7 years of experience as a SQL database developer







    • Minimum of 5 years recent hands-on writing complex T-SQL queries. eg. High-performance, T-SQL windows functions, merge, derived tables and sub-queries.

    • Minimum of 5 years recent hands-on coding with SQL server and ETL (SSIS).

    • Minimum of 2 years in PowerShell scripting on windows and azure.

    • Minimum of 2 years working with Azure SQL server.

    • Experience using SQL server replication and its architecture to synchronize large datasets, monitoring and troubleshooting.






  • Experience integrate large and complex datasets data to and from Azure SQL and on-premise SQL server using Azure data factory and SSIS.

  • Experience in creating, updating, optimizing and tuning T-SQL on high transaction Microsoft SQL server.

  • Good troubleshooting and support skills.

  • Advanced data analysis, validation, and processing skills.

  • Strong communication and organizational skills.

  • Experience working with Infor Lawson preferred.

  • Experience working with JAMS scheduler preferred.



Dice Id : 10120339
Position Id : 6043753
Originally Posted : 4 months ago
Have a Job? Post it

Similar Positions

SSIS Developer
  • Mindtree Limited
  • Pasadena, California
SQL Server Developer
  • Sharp Decisions
  • Long Beach, CA
SQL Developer
  • Robert Half Technology
  • Burbank, CA
Developer - .NET, SSRS, Expression, KPI, SQL, Relational Databases
  • Software Management Consultants, Inc.
  • Santa Ana, CA
BI/ETL Developer
  • Ledgent
  • Anaheim, CA
Database Developer
  • Everest Technologies
  • Burbank, CA
Business Intelligence Developer
  • Oxford Global Resources
  • Beverly Hills, CA
MSBI Develop
  • Brillio, LLC
  • Los Angeles, CA