Key Facts

Remote From:

Africa

Full time

Expert & Leadership (>10 years)

English

Hard Skills

Other Skills

•
Communication
•
Teamwork
•
Troubleshooting (Problem Solving)
•
Mentorship
•
Problem Solving

Roles & Responsibilities

Bachelor's degree in Computer Science or 10+ years IT experience
Advanced T-SQL and PowerShell scripting skills
Advanced knowledge of Microsoft SQL Server query optimization and index management
Advanced knowledge of Microsoft SQL Server Reporting Services and Integration Services Packages

Requirements:

Configure and maintain database servers and processes, including monitoring system health and performance to ensure high levels of performance, availability and security
Create and maintain documentation, procedures and best practices for database deployment and maintenance
Respond to user-reported errors in a timely manner
Assist developers with complex query tuning and schema refinement

Global Village Worker

Human Resources, Staffing & Recruiting

About Global Village Worker

"Man is changing and those that are wise will embrace and ride the wave. The rest will stand on the beach and envy and criticise those riding the wave." quote by Chris Kriel.With the ever-increasing internet resource and our electronic connectivity exploding into our private lives we are faced with many new horizons and opportunities. Let alone the dangers to our private lives.Today you can work in any country in the world from the comfort of your home. Live in Beijing and work in New York.Being the most effective and efficient worker you possibly can be. Working with greater freedom and determining your own work environment enables you to be better at what you do and being more effective with the time you allocate to your working life. This is a way to decrease the time you have to give to working (+travelling) and having oodles more time for doing things you want to do. Control your work environment and equip yourself better to be able to fill your role in the organisation that employs you.Define GVW (Global Village Worker/s): workers that work remotely from home (or any other place) using the internet.The phrase Global Village was first coined by Marshall McLuhan in 1970: https://globalvillageworker.com/global-village/

Company type: Startup

Industry: Human Resources, Staffing & Recruiting

Founded: 2018

Company size: 11 - 50

Website LinkedIn See all jobs →

Job description

Position Advertised: Database administrator

Job specification:

Your responsibility as a database administrator (DBA) will be the performance, integrity and security of a database. You'll be involved in the planning and development of the database, as well as in troubleshooting any issues on behalf of the users. You'll ensure that: data remains consistent across the database.

Duties and responsibilities

Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high-levels of performance, availability, and security
Manage, create and Maintain SQL Reporting Service Reports and ad-hoc reports as requested by the business
Create and maintain documentation, procedures and best practices for database deployment and maintenance
Create stored procedures for application programming interfaces (APIs)
Respond to user reported errors in a timely manner
Assist developers with complex query tuning and schema refinement
Monitor systems performance and identifying problems that may arise
Perform scheduled maintenance and support release deployment activities after hours
Protect the database from threats and unauthorized access
Provide technical mentorship and cross-training to other peers and team members

Qualifications and skills required:

Bachelor’s degree in Computer Science or other relevant discipline or 10 Years IT experience
Advanced T-SQL and Power Shell Scripting skills
Advanced in Microsoft SQL query optimization and index management
Advanced knowledge of Microsoft SQL Reporting Server Reports and Integration Service Packages
Advanced hands expertise with replication, log shipping, High Availability and Backup/Recovery
Advanced SQL Server maintenance/patching mechanics

Advanced understanding of back end, server, and API development, including application and database/data development and architectures
Expert in performance tuning and DB optimization using native monitoring and troubleshooting tools

Experience with the following (one or all) NOSQL databases - Elastic, MongoDB, Neo4j
Understanding and experience of Microsoft Azure and related SQL services including Azure SQL Managed Instances & Azure SQL Database
Knowledge with Microsoft Power BI is desirable
Understanding of Scrum/Agile methodologies is preferred
Knowledge of ViewPoint Software for Business is desirable

Experience needed:

Advanced T-SQL and Power Shell Scripting skills
Advanced in Microsoft SQL query optimization and index management
Advanced knowledge of Microsoft SQL Reporting Server Reports and Integration Service Packages
Advanced hands expertise with replication, log shipping, High Availability and Backup/Recovery
Advanced SQL Server maintenance/patching mechanics

Advanced understanding of back end, server, and API development, including application and database/data development and architectures
Expert in performance tuning and DB optimization using native monitoring and troubleshooting tools

Experience with the following (one or all) NOSQL databases - Elastic, MongoDB, Neo4j
Understanding and experience of Microsoft Azure and related SQL services including Azure SQL Managed Instances & Azure SQL Database
Knowledge with Microsoft Power BI is desirable

Minimum requirements

10 Years IT experience
. Experience with the following (one or all) NOSQL databases - Elastic, MongoDB, Neo4j
Understanding and experience of Microsoft Azure and related SQL services including Azure SQL Managed Instances & Azure SQL Database
Knowledge with Microsoft Power BI is desirable