Job Location: Belfast (Hybrid, 3 days from office)
We're Synechron, a global consultancy Laser-focused on accelerating digital initiatives in financial services. With over 14,500 members of staff across 19 countries and a unique mix of end-to-end digital, business and technology services, we help clients solve complex challenges with modern and innovative solutions.
We are in search of Mid-Level SQL Developers to join our growing team in Belfast. You will be part of a global dynamic team building in-house systems that are critical to the business. Solving problems to meet the ever-changing regulatory environment.
The role will include, but not limited to the following:
- Write native SQL stored procedures, user defined functions and triggers.
- Design, document, create and maintain data structures for complex business data - tablespace, tables, indexes, views, partitioning etc.
- Able to provide environmental support - escalating issues when necessary to other DBA groups.
- Perform database tuning and performance analysis using standard tools.
- Support development and QA teams through their development life cycles.
- Help resolve/escalate issues as needed to successfully deliver projects on time, on budget and with quality.
- Adhere to industry standards for best practices.
Knowledge/Experience:
- Min 6+ years' experience using SQL in application development and database administration.
- Expert in SQL - complex multi-table joins, nesting, correlation etc.
- Able to design, document, create and maintain data structures for complex business data - tablespace, tables, indexes, views, partitioning etc.
- Able to provide environmental support - escalating issues when necessary to other DBA groups.
- Able to grasp and understand business context and become expert in the underlying business data.
- Confident in dealing with administration of development environments, and in working with other DBAs for higher environments.
- Team player - able to work with developers in multiple technologies (Java, Ab Initio) to assist in impact analysis, design, and implementation of SQL queries/performance etc.
- Experienced working with QA teams.
Required Skills:
- Experienced at writing native SQL stored procedures, user defined functions and triggers.
- Expert in database tuning and performance analysis using standard tools.
Below are nice to have's from Mainframe perspective:
- Write and analyze Cobol programs and have knowledge on VSAM/GDG file system setup.
- Analyzing Cobol Stored Procedures.
- Setup and modify JCL's, PROC's and control cards.
- OPC JOB scheduling and handle one time job runs.
Preferred to have:
- Experience on IBM DB2 to Oracles/Oraas migration
Remote Working/Office Presence:
This hire would need to be in the office when required, this will be at River House, near the City center. The hire will need to be prepared at stages to come into the office 3 days per week requested by the client.
Benefits Include (not limited to):
Competitive compensation/Hybrid working/Immediate start available
Diversity Statement
Synechron are proud to be an equal opportunity employer. Our Diversity, Equity, and Inclusion (DEI) initiative Same Difference' is committed to fostering an inclusive culture - promoting equality, diversity and an environment that is respectful to all. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We offer flexible workplace arrangements, mentoring, internal mobility, learning and development programmes to support our global workforce. Empowerment and collaboration are at the core of how we operate.
All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant's gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.