123

MS SQL Database Administrator (PaaS) (NATO-NCIA)

New

Mons, Belgium, Belgium, Sapienza Consulting [C002393]

Field(s) of expertise
Information Technology Software Engineering
Job type
Contract
Education
BachelorDiploma
Deadline
29/09/2022

About this job

Sapienza Consulting, a Serco company, is recruiting MS SQL Database Administrator (PaaS), to work on the AAS Project at NATO-NCIA, with work location in Mons, Belgium.

Responsibilities

Duties & Role:

  • Installing and upgrading the database server and application tool
  • Allocating system storage and planning storage requirements for the database system
  • Modifying the database structure, as necessary, from information given by application developers
  • Enrolling users and maintaining system security
  • Ensuring compliance with database vendor license agreement
  • Controlling and monitoring user access to the database
  • Monitoring and optimizing the performance of the database
  • Planning for backup and recovery of database information
  • Maintaining archived data
  • Backing up and restoring databases
  • Contacting database vendor for technical support
  • Generating various reports by querying from database as per need
  • Managing and monitoring data replication

Profile

Skills, Knowledge & Experience:

  • The candidate must have a currently active NATO SECRET security clearance
  • At least 5 years of recent relevant years’ experience
  • Systems requirement analysis for database design and complete installation according to high-performance data throughput systems
  • Administering, maintaining and securing the database servers and provide Level 2/3 support according to SLA KPI metrics
  • Upgrade from earlier Microsoft SQL Database versions-based running on on-premises and/or cloud
  • Re-platforming Microsoft SQL Database servers, which the lift and shift process whereby servers are simply carried over from the current Data Centre to the new environment.
  • High Availability implementation of Microsoft SQL Databases, troubleshooting replication problems and identify appropriate replication strategy
  • Disaster Recovery Solutions use RDBMS HA (Clustering and Always on Availability Groups) and participating in Disaster Recovery Planning analysis and tests
  • Provision and maintenance of database support documentation in line with Quality Standards, knowledge base documentation
  • Configuration/monitoring of Microsoft SQL Database backups and restore databases
  • Perform routine database maintenance activities and able to check daily routine tasks on MSSQL Systems including reorganization of databases to maintain performance levels
  • Resolution of Database performance issues, writing, debugging and optimizing complex queries and provide troubleshooting support
  • Performing simple tasks on Windows and Linux Operating Systems as a Database Administrator
  • Knowledge of Virtualization and Platform services

 

Experience Desired:

  • Experience in provisioning of Platform as a Service
  • Knowledge of SharePoint platform
  • Experience in the provisioning of application maintenance and support services. Investigates and resolves application and system support problems and provides information about the systems, utilizing management tools
  • Knowledge of working within an ITSM framework (ITIL etc.) and perform Service Operation activities in ITIL Service Lifecycle
  • Prior experience of working in an international environment comprising both military and civilian elements

Candidates must be eligible to work at NATO-NCIA.

For information on how the personal data in your application is processed, please see the Sapienza Consulting Privacy Policy.