What are the responsibilities and job description for the SQL Middleware Developer position at Synerfac Technical Staffing?
Job Responsibilities :
- Design, develop, and maintain SQL databases and applications.
- Create and optimize complex SQL queries, stored procedures, functions, views, and triggers to support data integration and reporting needs.
- Develop, test, and maintain ETL workflows from / to multiple sources and target systems, ensuring data quality and consistency.
- Work with middleware technologies to facilitate data exchange and automation between different systems and applications to increase efficiency and reduce manual intervention.
- Work closely with data analysts, developers, business intelligence teams, and other stakeholders to understand data requirements and deliver effective solutions.
- Provide troubleshooting and support to Identify and resolve data-related issues, optimize performance, ensure data integrity, and provide ongoing support for data integration processes.
- Develop and maintain documentation for database processes and procedures.Education / Experience :
- Bachelor"s degree in Computer Science, Information Technology, or a related field.Other Required Skills :
- Strong proficiency in SQL programing skills with the ability to write complex queries, stored procedures, views, and triggers.
- Experience with database optimization and performance in different database systems both on-site and cloud based. (, SQL Server, Azure SQL, Informix, Postgres, and Oracle).
- Knowledge of Middleware platforms, ETL tools, scripting languages, and integration techniques and processes (, 4GL, Python, Bash)
- Experience with data modeling, database design, data warehousing, and normalization.
- Experience with version control systems ().
- Competency using Project Management software and Microsoft applications including Word, Excel, PowerPoint, Teams, and Outlook.
- Excellent problem-solving and analytical skills.
- Strong communication and teamwork abilities.Preferred Skills :
- Proven experience as a SQL Developer or similar role.
- Knowledge of other programming languages a plus (, Java. .NET).
- Experience with business intelligence tools (, Power BI, Tableau)
