SQL Developer

Decskill; Lisboa; On-site; EUR 42,000 - 65,000; Full time

Job summary

Decskill in Lisbon is seeking an experienced SQL Developer to join our data engineering team. You will design and optimize database solutions across SQL Server and PostgreSQL, and partner with development teams to improve business processes.

The role emphasizes ETL development, query tuning, backup strategies, and monitoring using tools like Dynatrace, ELK, and Power BI. A strong foundation in data integrity and incident response is essential.

Qualifications

• Experience with ETL processes development and optimization.
• Strong root cause analysis and problem solving.
• Expertise in SQL performance tuning, partitioning and indexing.
• Experience with Master Data Services.
• Familiarity with ITIL concepts and DevOps practices.
• Experience with CI/CD pipelines.
• Monitoring and observability tools proficiency.

Responsibilities

• Design and implement database systems within information systems.
• Monitor and support critical business processes.
• Develop and optimize SQL queries, stored procedures, and triggers for reporting.
• Collaborate with development teams to improve business processes.
• Manage complex Microsoft SQL Server and PostgreSQL databases.
• Administer and maintain databases in production.
• Implement backup strategies to protect data integrity.
• Provide technical support and incident response for DB issues.
• Participate in post-mortems for major incidents.
• Use visualization tools to monitor performance and availability.
• Explore innovative solutions to automate costs.

Skills

ETL processes development

Root cause analysis

SQL performance tuning

Partitioning and indexing

DevOps CI/CD

Database administration

Incident management

Data quality

Tools

Dynatrace

ELK

Zabbix

Power BI

Master Data Services

Job description

Decskill was founded in 2014 as an IT Consulting Company and their main mission is to delivery value through the knowledge. We enable companies to meet the chalenges of digital world by providing our clients with business models that ensure technological capacity, flexibility and agility. We are more than 500 consultants with offices in Lisbon, Porto and Madrid.

DECSKILL operates in 3 main areas:

• DECSKILL TALENT, through which we provide our clients with an extension to their IT teams;
• DECSKILL BOOST, through which we provide our client with software development models to increase capacity and optimize Time-to-Market, where we create and manage teams that deliver according to their needs, at the desired speed;
• DECSKILL CONNECT through which we provide our client with consulting services, as well as the implementation and management of information technology infrastructures.

Our practice results in the creation of value for our customers, either by delivering qualified and value-added services, or through highly qualified and motivated professionals, as well as technology solutions that allow us to operate and transform the business of our customers.

We are looking for a SQL Developer:

RESPONSABILITIES:

• Designing an implementation of database systems in the Information Systems.
• Monitor and support critical business processes.
• Develop and optimize SQL queries, stores procedures, and database triggers for data manipulation and reporting.
• Working closely with Development teams to improve the value of business processes outcomes.
• Manage high complex Microsoft SQL Server, PostgreSQ.
• Administration and maintaining databases in operational conditions.
• Implementing backup systems to ensure the integrity of all database data.
• Ensuring that backups are made in accordance with strategy defined by each business line;"3- EXPERT
• Provide technical support.
• Provide support to developers and APS teams.
• Intervene in the event of incidents which limit the performance of databases or access to information.
• Active participation in post-mortems for major and/or recurring database incidents.
• Ensure technological monitoring to maintain the required performance and availability through visualization tools (e.g Dynatrace, Power BI);3- EXPERT
• Assess and deploy innovative solutions aiming to simply, automate and optimize database costs.

REQUIREMENTS:

• Solid experience with ETL processes Development, optimization and monitoring (SQL Procedures, Functions,..).
• Root cause analysis skills.
• Experience with SQL performance tunning, partitioning and indexing.
• Experience with Master Data Services.
• ITIL 1 - Notions
• DevOps (CI/CD)
• Monitoring tools (e.g. Dynatrace, ELK, Zabbix)

IDIOMAS:

Decskill is committed to equality and non-discrimination with all our talents. We recruit and promote talent, based on diversity and inclusion, regardless of age, gender, ethnicity, race, nationality or any other form of discrimination incompatible with the dignity of the human being