- Location
- Porto, Portugal
- Type
- Full-time
- Department
- IT
- Seniority
- Senior
- Source
- Workday
Description
SQL Database Developer: The primary purposes of this role include data migration, application development and assisting other developers in database development. In the role you will develop new code, models, structures and processes to support our current and new products. You may also assist in the administration of the databases. The role is to help ensure performance, capacity, functionality, tuning, deployment and that best practices are followed at all times.
The current databases are MS SQL Server. You will work with a small but skilled team in a highly complex international solution environment and collaborate with developers and product management to understand our domain and deliver out products, with security at the heart of everything we do.
Key activities
•
Write and support SQL queries and stored procedures in a SaaS based environment
•
Assist and provide leadership in migrating data between different generations of applications
•
Assist in data acquisition for an online product
•
Assist developers with complex query tuning and schema refinement
•
Work with the application development team to implement new data products
Title
SQL Database Developer
Recommend solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications.
•
Communicate regularly with other technical, applications and operational staff to ensure database integrity and security
•
Manage the disaster recovery aspects of a database
•
Research and implement new related database technologies as necessary
•
Maintains quality service by establishing and enforcing best practices
•
Implement and maintain automated database maintenance plans and backs up routines using standard methodologies
•
Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of-the-art practices; participating in professional societies.
•
Maintain professional competence by complying at all times with the training and competence procedures of the company
•
To undertake any other reasonable duties as deemed appropriate by management, commensurate with the level of the post so as to ensure the smooth running of Acupay
Required skills and experience
•
5+ years of database development with significant MS SQL Server Experience
•
Ability to write and troubleshoot SQL code, design stored procedures, create functions, tables, views, triggers, and indexes
•
Experience with ETL processing and ETL tools like SSIS
•
Any experience in data migration between different generations of an online product
•
Strong knowledge of MS SQL Server 2016 or later
•
Thorough understanding of database structures, theories, principles, & best practices
•
Technical knowledge of MS SQL Server internals with emphasis on query performance.
•
Degree in Computer Science, Engineering or a related subject preferred, or the equivalent work experience
•
Excellent written and verbal communication skills
•
Enthusiastic, self-driven, willing to go the extra mile and work at own initiative
•
Ability to work under pressure, to work independently as well as to be a team player, particularly across different sites and time zones
DESIRABLE
•
Any experience with a scripting language such a Python
•
Experience in a cloud-environments with an emphasis on AWS
•
Data modelling experience
•
DBA experience with any relational databases technologies
3
Deliverables
• High-quality database source code, in compliance with Acupay's coding standards for readability, maintainability, and efficiency.
• Database availability, performant, and resilient
• Clear and comprehensive technical documentation.
Euronext Values
Unity
• We respect and value the people we work with
• We are unified through a common purpose
• We embrace diversity and strive for inclusion
Integrity
• We value transparency, communicate honestly and share information openly
• We act with integrity in everything we do
• We don’t hide our mistakes, and we learn from them
Agility
• We act with a sense of urgency and decisiveness
• We are adaptable, responsive and embrace change
• We take smart risks
Energy
• We are positively driven to make a difference and challenge the status quo
• We focus on and encourage personal leadership
• We motivate each other with our ambition
Accountability
• We deliver maximum value to our customers and stakeholders
• We take ownership and are accountable for the outcome
• We reward and celebrate performance
We are proud to be an equal opportunity employer. We do not discriminate against individuals on the basis of race, gender, age, citizenship, religion, sexual orientation, gender identity or expression, disability, or any other legally protected factor. We value the unique talents of all our people, who come from diverse backgrounds with different personal experiences and points of view and we are committed to providing an environment of mutual respect.
Additional Information
This job description is only describing the main activities within a certain role and is not exhaustive. It does not prevent to add more tasks, projects.