MS SQL Database Administrator(PaaS)

Conteúdo do emprego

Overview

Systems Planning and Analysis, Inc. (SPA) delivers high-impact, technical solutions to complex national security issues. As we enter our 50 th year in business, we are known for continuous innovation for government customers, both long-established and newly acquired, as our capabilities expand around the globe. Our work is state-of-the-art and made possible only through the best personnel, tools, and jobs in the national security business. We are highly collaborative in spirit and practice, and we freely share expertise across SPA in our quest for enduring solutions to critical concerns. Come work with the best!

SPA has an immediate need for a MS SQL Database Administrator(PaaS) to provide contracting services to NATO.

Responsibilities

• 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
  

Qualifications

Required Qualifications:

• 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-premise 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.
• National of one of the 30 NATO countries
• In possession of an active National and/or NATO Secret security clearance
  

Desired Qualifications

• 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