What are the responsibilities and job description for the Need SQL Server Developer(Not Data Engineer) - Local to Alpharetta position at My3Tech?
SQL Server Developer
We have max rate of $55/hr on W2 Al
Location: Local to Alpharetta – Must be able to work onsite 2 days a week
No H1s, Candidates Must be able to work on Client W2 without any current or future sponsorship
MUST HAVE SKILLS :
- SQL Server development in 2012
- 2019 CTEs
- Stored procedures
- UDF
- Database development SSIS package development
- DB job debugging ETL
DESIRED SKILLS: Google Cloud Platform (GCP) C# Scripting
SQL/ETL Developer - To support Employee Engagement Platforms
JOB DUTIES:
- Translate user business requirements into program specifications.
- Create database objects Tables, Views, User defined functions, Store procedures, Joins, Dynamic SQL, Indexed Views, Daily Jobs and Workflow objects.
- Developed business logic workflows in SQL Server using stored procedures, UDFs, views, temp tables, table variables, For loops, CTEs.
- Performance tuning on database Objects to achieve optimal data retrieval/updates using SQLProfiler, Execution plan.
- Execute SQL Task and Data Flow Tasks were used extensively as part of ETL packages.
- Monitoring daily database jobs, data loads and proactive resolution of issues to ensure maximum uptime/availability of database for reporting.
- Prepare Unit, Integration and System test plans and execute and log results.
- Analyze and fix bugs in the existing system.
- Create documentations and follow standards and methodology as defined by the project manager.
Salary : $55