Database Administrator for Frontex Projects

If the washing machine program is the only one you can’t figure out.... Your place is with us!

We are expanding our teams in the defence sector to take on Frontex projects.

We´ll get to the point; we'll tell you what's not on the web. If you want to know more about us go to GMV website

WHAT CHALLENGE WILL YOU BE TAKING ON?

In our team you will provide support to several projects for a European institution, concerning security and border control activities (Frontex). The project where the DBA is required deals with assessing the security in the border controls (vulnerability assessment).

Your tasks:

• Task 1: Data processing
  
  

Support data collection of structured and unstructured data from European Union Member States. Upon reception of the data, evaluate and handle them in line with the security operating procedures, review against the acceptance criteria, and provide feedback to the submission party prepared. The administrator shall clean and transform the data package using the provided set of criteria and dictionaries and import the cleaned data package into the system database (currently using the DB stored procedures, SSIS and MS SQL Server as destination). Additionally, he/she shall analyse the imported data along with the existing data sets in the database to produce BI products.

• Task 2: Database and data analysis systems administration
  
  

Administer the system DB (MS SQL Server 2016), excluding the database engine and accounts. This covers daily monitoring, control of the database parameters, ensuring appropriate data quality, security, availability, capacity, continuity and documentation.

• Task 3: Support to systems design
  
  

The data stored in this system evolve with Frontex needs. The data base administrator shall facilitate this evolution advising systems designers on the as-is and to-be, planning for the transition. Additionally, he/she shall implement the required changes from one solution to another without loss of data or changes to data quality or availability to the authorised users and document implemented changes.

• Task 4: Knowledge transfer and consultancy
  
  

Looking to advance your IT & Network Engineering career with relocation support? Explore IT & Network Engineering Jobs with Relocation Packages that include comprehensive packages to help you move and settle in your new role.

Maintain up-to-date operational (how to perform operational duties) and technical documentation (how systems logic and data are organised). Once per year, the data base administrator shall deliver a knowledge transfer workshop of at least 4 hours, making sure that the attendees are able to take over the data base administrator duties.

• Task 5: Timely response to ad-hoc queries and Production of ad-hoc reports and dashboards
  
  

Respond to ad-hoc queries from Frontex members to access the system data in support of their daily duties, using the data processing tools available.

• Task 6: Integration
  
  

Plan, manage and maintain the database and data processing tools configuration. Configure additional data sources and data transformations as needed. Generate XML files on-demand to facilitate file-based integration.

WHAT DO WE NEED IN OUR TEAM?

We are looking for We are looking for an experienced MS data base administrator with:

• BSc degree in Computer Science or related field
• MCSA in SQL Server 2016 Administration Certification or equivalent
• 4 years hands-on experience in the administration of complex MS SQL based systems, preferably deployed in distributed environments
• Knowledge of authentication and authorisation mechanisms, preferably in distributed enterprise level systems
  
  

We will also value:

• MSc degree in Computer Science or related field
• Experience in monitoring of complex IT systems using tools such as SCOM
• Hands-on experience on Microsoft BI system administration tools to monitor, manage, and configure system components (e.g. Microsoft SharePoint SSAS, SSRS, SSIS and PowerBI)
• Hands-on experience in administration of complex IT systems deployed in distributed environments
• Expertise in tasks related to administration, management, monitoring, and backup of large, preferably multi-site MS SQL-based databases
• Proficient in scripting MS SQL data bases, data transformation and ETL tools
• Expert in optimizing, tuning and planning capacity of databases
• Hands-on Experience in management of Opens Source databases and data manipulation tools including PostgreSQL and its extensions
  
  

WHAT DO WE OFFER?

🕑 Hybrid working model and 8 weeks per year of teleworking outside your usual geographical area.

💻 Flexible start and finish times.

🚀 Personalized career plan development, training and language learning support.

🌍 National and international mobility. Do you come from another country? We can offer you a relocation package.

💪Wellbeing program: Health, dental and accident insurance; free fruit and coffee, physical, mental and financialhealth training, and much more!

⚠️ In our recruitment processes you will always have telephone and personal contact, face-to-face or online, with our talent acquisition team. In addition, bank transfers and bank cards will never be requested. If you are contacted through any other process, please write to our team at privacy@gmv.com

❤️We promote equal opportunities in recruitment, and we are committed to inclusion and diversity.

WHAT ARE YOU WAITING FOR? JOIN US

If you have any questions please do not hesitate to contact Magdalena Kalinowska, in charge of this vacancy.

Magdalena Kalinowska