Senior SQL Database Administrator - Remote

Dimension Data Solutions Limited (Kenya); United States; Remote; USD 110,000 - 165,000; Full time

Job summary

NTT DATA is seeking a Senior Database Administrator to ensure availability and performance of complex data assets. You will work with cross-functional teams to support data-driven applications, troubleshoot issues, and implement robust backup and recovery strategies.

You will monitor security, manage access, plan upgrades, and optimize DBMS such as SQL Server, Oracle and MySQL to meet business needs.

Qualifications

• Advanced SQL knowledge and experience writing complex queries, stored procedures, and functions.
• Proficient in configuring and tuning DBMS for high availability and performance.
• Strong understanding of database security, access controls, and encryption.
• Experience with backup and disaster recovery planning and execution.

Responsibilities

• Install, configure, and maintain complex DBMS (SQL Server, Oracle, MySQL, etc.).
• Collaborate with developers to design and optimize database schemas and data models.
• Document data standards, data flows, and metadata definitions.
• Monitor performance, identify bottlenecks, and optimize queries and indexing.
• Design and implement robust backup and disaster recovery strategies.

Skills

Advanced SQL

DBMS tuning

Data security

Backup & recovery

Cross-functional collaboration

Performance monitoring

Education

Bachelor’s degree in computer science/engineering/IT

Tools

SQL Server

Oracle

MySQL

Job description

Make an impact with NTT DATA

Join a company that is pushing the boundaries of what is possible. We are renowned for our technical excellence and leading innovations, and for making a difference to our clients and society. Our workplace embraces diversity and inclusion - it's a place where you can grow, belong and thrive.

Your day at NTT DATA

The Senior Database Administrator is an advanced subject matter expert, responsible for ensuring the availability, integrity and performance of complex and critical data assets and works closely with cross functional teams to support data-driven applications, troubleshoot issues, and implement robust backup and recovery strategies.

The Senior Database Administrator works closely with Change Control, Release Management, Asset and Configuration Management and Capacity and Availability Management to establish the needs of users, monitoring user access and security.

This role assists in controlling access to databases environments through permissions and privileges.

Key responsibilities:

• Performs the installation, configuration, and maintenance of complex database management systems (DBMS), including SQL Server, Oracle, MySQL, or others, as required.
• Collaborates with software developers/architects to design and optimize database schemas, data models, and database-related applications.
• Participates in the writing of database documentation, including data standards, data flow diagrams, standard operating procedures and definitions for the data dictionary (metadata).
• Monitors database performance, identifies performance bottlenecks, and optimizes queries and indexing for optimal database performance.
• Designs and implements robust backup and disaster recovery strategies to ensure data availability and business continuity.
• Monitors production databases regularly or respond to any database issues by bringing down the database or taking the database offline.
• Proactively supports the development of database utilities and automated reporting.
• Works closely with the Change Control and Release Management functions to commission and install new applications and customizing existing applications in order to make them fit for purpose.
• Plans and executes database software upgrades and applies patches to keep systems up-to-date and secure.
• Communicates regularly with technical, applications and operational employees to ensure database integrity and security.
• Implements and manages security measures to safeguard databases from unauthorized access, data breaches, and data loss.
• Conducts regular security audits and vulnerability assessments to maintain compliance with data protection standards and regulations.
• Works collaboratively with cross-functional teams, including developers, system administrators, network engineers, and business stakeholders, to support database-related initiatives.
• Provides technical support to end-users, assists with database-related enquiries, and conducts training sessions as needed.
• Performs any other related task as required.

Knowledge, Skills and Attributes:

• Advanced proficiency in database administration tasks, including database installation, configuration, maintenance, and performance tuning.
• Advanced knowledge of SQL (Structured Query Language) to write complex queries, stored procedures, and functions.
• Advanced understanding of database security principles, access controls, and data encryption methods.
• Advanced working knowledge in database backup and recovery strategies to ensure data availability and business continuity.
• Ability to monitor database performance, identify and resolve issues, and optimize database operations.
• Ability to manage multiple projects concurrently while maintaining a high level of attention to detail on each project.
• Ability to learn new technologies as needed to provide the best solutions to all stakeholders.
• Ability to communicate complex IT information in simplified form depending on the target audience.
• Effective communication and collaboration skills to work with cross-functional teams and stakeholders.
• Advanced proficiency understanding of the principles of data architecture and data services.
• Advanced knowledge of application development lifecycle and data access layers.
• Excellent problem-solving skills to troubleshoot database-related issues and implement effective solutions.
• Excellent analytical skills related to working with unstructured datasets
• Ability to manipulate, process and extract value from large, disconnected datasets.

Academic qualifications and certifications:

• Bachelor's degree or equivalent in computer science, engineering, information technology or related field.
• Relevant certification, such as MCSE DBA, oracles associate or equivalent preferred.
• Relevant certifications such as Microsoft Certified; Azure Database Administrator Associate; Oracle Certified Professional (OCP) - Database Administrator; MySQL Database Administrator; PostgreSQL Certified Professional preferred.
• Completion of database manage