As T-SQL Developer with Perl , you will collaborate with stakeholders across the business to work on complex technical requirements. You will be responsible for managing multiple engagements, prioritize and resolve complex problems and escalate as necessary, in a fast paced environment.
Responsibilities:
Develop and optimize T-SQL stored procedures, functions, and triggers for high transaction environments.
Design and implement database schema, tables, and relationships to ensure data integrity and performance.
Utilize Perl scripts for data extraction, transformation, and loading (ETL) processes.
Automate routine database maintenance tasks and system operations using Perl.
Collaborate with the development team to integrate database operations with existing Perl applications.
Conduct performance tuning of T-SQL queries and indexes to improve database efficiency.
Manage database backups, restores, and updates while ensuring data security and compliance with industry standards.
Provide support for database-related issues; troubleshoot and resolve problems in a timely manner.
Create and maintain detailed documentation for database schemes and Perl scripts.
Keep abreast of the latest technologies and best practices in database development and scripting languages.
Required Skills:
BS in computer science or engineering degree or a related field or equivalent work experience required.
Experience in Requirement Analysis, Strategic Analysis, Software Development Fundamentals, Design, Development, Maintenance, Testing and Implementation of efficient data flow and batch processes in applications.
Experience in TSQL programming, Perl and Shell scripting.
Excellent understanding of relation transactional databases like Sybase and MSSQL.
Strong knowledge of Extraction Transformation and Loading (ETL) processes using TSQL and Perl/Shell scripting.
Experience in TSQL (MSSQL/SYBASE must have ) code development, performance tuning, query optimization and batch or ETL creation experience.
Desired Skills:
Experience with other database technologies like MySQL, PostgreSQL, or Oracle.
Familiarity with other scripting languages such as Python or PowerShell.
Knowledge of version control systems, preferably Git.
Certifications in Microsoft SQL Server and/or Perl programming are a plus.
We can offer you:
A highly competitive compensation and benefits package
A multinational organization with 51 offices in 20 countries and the possibility to work abroad
Laptop and a mobile phone
10 days of paid annual leave (plus sick leave and national holidays)
Maternity & Paternity leave plans
A comprehensive insurance plan including: medical, dental, vision, life insurance, and long-/short-term disability (plans vary by region)
Retirement savings plans
A higher education certification policy
Commuter benefits (varies by region)
Extensive training opportunities, focused on skills, substantive knowledge, and personal development
On-demand Udemy for Business for all Synechron employees with free access to more than 5000 curated courses
Coaching opportunities with experienced colleagues from our Financial Innovation Labs (FinLabs) and Center of Excellences (CoE) groups
Cutting edge projects at the world's leading tier-one banks, financial institutions and insurance firms
A flat and approachable organization
A truly diverse, fun-loving and global work culture
SYNECHRON'S DIVERSITY & INCLUSION STATEMENT
Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action 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 strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.
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