General Description:
The purpose of this job is to focus on the integration of various platforms, both internally and externally developed, into an efficient omnichannel platform.
Minimum Work Experience
Bachelor of Science Degree with 4 years of programming experience or equivalent.
Minimum 2 years of experience developing applications in MS SQL and ETL processes. Knowledge of Salesforce (Optional)different ETL techniques a plus.
Required Technical Skills
- Required Languages: TSQL, JSON, XML.
- Technologies: MS SQL Server 2016; Azure Postgre SQL
- Strong SQL experience with managing SQL server 2016
- Some experience in Azure environment + Azure DevOps exposure will be helpful
Additional Technical Skills
- Required Languages: TSQL, Knowledge of Triggers, Stored Procedures & Functions are more important.
- Technologies: SQL Server 2016, Always On Availability Groups, GIT, Azure Dev Ops, and other continuous development tools, Microsoft Office, and others as needed.
Primary Responsibilities:
The activities which the person will be directly held accountable for are broken into the following main areas and include:
- Meet the client’s standards for application and database development.
- Work in various team workflows including Agile and Waterfall. Work with functional groups and project management to ensure that the plan reflects the milestones and timing of the projects.
- Document technical designs using Erwin diagrams, flowcharts, data flow diagrams, descriptive software component documentation, etc. as required.
- Design, review, analyze, and provide feedback on data models, ETL and application processes designed to meet the business use cases and workflows.
- Develop database objects, including tables, views, functions, and stored procedures to support business processes.
- Maintain data management compliance and best practices.
- Evaluation of data sets to determine keys and other relationships within the dataset and recommend structures and processes based on the data and business needs.
- Ability to identify, analyze, and resolve database and application performance issues.
- Manage and monitor database backups.
- Manage SQL servers, monitor usage and make and execute efficiency changes.
- Deploy changes to production databases.
- Troubleshooting issues with automated processes and execute changes as needed.
- Performs code review sessions with other developers and suggests improvements or alternative strategies when appropriate.
- Work with internal teams to perform maintenance and upgrades to SQL Servers.
- Creation and maintenance of testing of ETL and data processing processes.
- Review business requirements and suggest solutions based on industry and best practices.
- Learn and implement new software and hardware tools as appropriate.
- Support of internal hardware and software applications through problem-solving/recommendations.