Senior SQL & Cloud DBA

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

Benefits offered by this job

Health insurance

26 days vacation

Training

Job summary

FOX IT, a Portuguese consulting company, seeks a Senior SQL & Cloud DBA to administer SQL Server and PostgreSQL DBMS, model data, and optimize performance. You will manage backups, high availability, ETL, and real-time ingestion with Azure Event Hubs and Google Pub/Sub.

The role involves data governance, security, and collaboration with development teams. Required are a degree in Computer Engineering, IS, or Data Science or 6+ years in DB management, plus experience with data migration or IoT

Qualifications

• Bachelor's degree in Computer Engineering, Information Systems or Data Science or a minimum of 6 years of experience in Database Management.
• Experience in data migration or modernization projects.
• Experience with IoT data streams or integration with external systems.

Responsibilities

• Administrate DBMS: SQL Server and PostgreSQL.
• Model relational and NoSQL data.
• Optimize queries and performance.
• Perform backup, recovery and high availability (clustering, replication).
• Handle ETL, data integration and real-time ingestion (Azure Event Hubs, Pub/Sub GCP).
• Open Data Management and open data stewardship.
• Monitor performance and availability.
• Support migration and modernization projects.
• Develop technical documentation and reports.

Skills

Data modeling

Query optimization

Monitoring

Education

Bachelor's degree in Computer Engineering, Information Systems or Data Science

Tools

SQL Server

PostgreSQL

Azure Event Hubs

Google Pub/Sub

Job description

Fox IT is a Portuguese consulting company that has been in the top 5% of SMEs in Portugal for the 5th consecutive year. Our mission is to bring a new approach to the IT market, promoting a fairer exchange between us, our consultants, and our clients. More recently, we received the Happy at Work certification, recognizing that we value our people.

The services to be provided for the Senior SQL & Cloud DBA Profile aim to ensure the administration, operation, monitoring, and optimization of the client's database platforms, guaranteeing their availability, performance, security, and integrity, in accordance with previously established rules.

Responsibilities

• Database Management System (DBMS) Administration: SQL Server and PostgreSQL;
• Relational and NoSQL data modeling;
• Query optimization and performance tuning;
• Execution of backup, recovery and high availability (clustering, replication);
• ETL, data integration and real-time ingestion (e.g., Azure Event Hubs, Pub/Sub GCP);
• Open Data Management and open data;
• Monitor performance and availability;
• Supporting migration and technological modernization projects;
• Optimize queries and data models;
• Ensuring security (encryption, access control and GDPR compliance) and
• Support development and integration teams;
• To develop technical documentation for existing technological platforms;
• To prepare technical reports on technological advancements.

Mandatory requirements

• Bachelor's degree in Computer Engineering, Information Systems or Data Science or a minimum of 6 (six) years of professional experience in Database Management.
• Participation in data migration or modernization projects;
• Experience with IoT data streams or integration with external systems.

What we offer:

• Participation in projects with significant social impact.
• A solid technical environment, focused on quality and best practices.
• Opportunity for growth and exposure to modern technologies.
• Integration into a multidisciplinary and collaborative team
• 26 days of vacation;
• Health insurance;
• Training;