28 Jul
SQL Developer
Vacancy expired!
- Design, implement, and manage database systems, and ensure their availability, stability, reliability, and performance.
- Support Power Bi developers with data requests.
- Design and develop integrations using SSIS packages, PowerShell, T-SQL, PL/SQL, or other appropriate technologies.
- Participate in requirements sessions with the stakeholders and convert functional requirements into technical solutions, along with supporting materials such as use cases, designs, flowcharts, models, specifications, and reports.
- Ensure the data quality and integrity in databases, as well as compliance of standards and conventions in developing programs.
- Troubleshoot and resolve complex issues, including root cause analysis along with recommending and implementing preventive techniques.
- Manage interfaces and automated jobs to ensure efficiency and lead effort to migrate interfaces to current technologies.
- Design, develop, and implement comprehensive test and evaluation plans to ensure integrations perform efficiently and meet full requirements.
- Provide and maintain technical documentation for new system processes or enhancements.
- Partner with business users to provide guidance and support as necessary to help drive best practices to meet their integration needs.
- Confidently present possible solutions to audiences of various sizes and technical knowledge levels weighing pros and cons.
- Ensure security standards are included, applied and maintained across all product sets within the domain.
- Be part of an on-call rotation to support mission-critical production database systems.
- B.S. in information technology/computer science.
- 5+ years of experience with SQL Server administration and support.
- 5+ years hands-on experience developing and implementing integration solutions.
- Extensive experience working with SQL, Stored Procedures, data extraction, data transformation, and data loading.
- Good experience with PowerShell and SSIS packages.
- Experience in SQL Server database development and troubleshooting, including typical database installation and configuration, as well as implementing database security controls to properly manage access to the data.
- Experience in Agile environment - Must be able to learn and apply new technologies quickly and work within a dynamic work environment.
- Data integration experience with business systems such as Kronos, Dynamics GP and other 3rd party applications.
- Experience with Azure DevOps and Visual Studio.
- Working knowledge of other related database technologies such as: Oracle, Azure SQL, Big Data, Azure Data Factory, Azure Synapse, and with other programming languages like Python and/or C#.
- Excellent written and verbal communication skills.
- Work well independently as well as part of a team.
- Strong analytical and problem-solving skills.
- Self-starter with ability to work efficiently with minimal direction or guidance.
- Manipulate Data with SQL, and with other programming languages like Python and/or C#.
Vacancy expired!