The Senior SQL Developer will be playing key role in the Engineering team that delivers next generation products within Perigord s product offerings. The suitable candidate will work in product(s) development which may include writing and managing all the database objects, working in Projects team on the ETL/Data migration and Reporting projects, and help with resolving any performance issues on Production environments.
Your Responsibilities:
Design, develop and implement of high-quality database objects and routines on SQL Server as part of the SDLC.
Manage the SQL Projects/DacPac of the product(s).
Manage the sanity and performance of different objects introduced per version.
Manage the SQL documentation per version.
Collaborate with Head of Engineering and Tech leads.
Produce and manage both out of the box reports and custom reports based on client-specific requirements.
Data migrations involving feed from excel or external DWH.
Data feed to external systems via SFTP or direct integrations.
Work closely with DBA and investigate performance issues in Production systems as needed.
Maintain comprehensive technical documentation including design documents, architecture diagrams, and deployment guides.
Identify opportunities for process improvements and automation to streamline development workflows and increase team productivity.
Preferred Qualifications, Training and Experience:
Bachelor s or master s degree in computer science.
Minimum of 8 year s experience in Database development including managing all the database objects.
3-4 years experience in SSIS or an ETL process with various data sources.
3-4 years experience on reporting using SSRS or any reporting tool.
Approx 1-2 years on resolving Production issues.
Experience working in an Agile set-up especially Scrum.