Job Description

Job Summary

JD for MS SQL DBA: High level JD: • Design and develop optimal solutions to migrate or upgrade existing databases to new platform or DBMS versions • Build and leverage automation and DB DevSecOps pipelines to provision, upgrade, patch and maintain DB systems • Support DB change request and problem investigation and resolution of both production and non-production environments. • Monitor capacity, high-availability and performance for non-production and production databases to ensure they are highly reliable, efficient, cost effective, and provide the required functionality. • Seeks opportunities to improve database performance by identifying tuning measures and implementing them when appropriate. • Develops and maintains database backup and recovery strategy and procedures. Ensures that databases are properly backed up and recovered when necessary • Ensures databases are properly maintained, meeting security, audit and compliance requirements. Databases are reorganized/groomed when necessary and other DBA utilities run when appropriate. • Managing SQL Server databases. • Configuring and maintaining database servers and processes • Monitoring system's health and performance • Analysing solving and correcting issues in real-time • Refining and automating regular processes, tracking issues, and documenting changes • Performing scheduled maintenance and supporting release deployment activities after hours Primary Skill: MS SQL Secondary Skill: DB2 LUW or Oracle or AWS RDS or Redshift

Key Responsibilities

JD for MS SQL DBA: High level JD: • Design and develop optimal solutions to migrate or upgrade existing databases to new platform or DBMS versions • Build and leverage automation and DB DevSecOps pipelines to provision, upgrade, patch and maintain DB systems • Support DB change request and problem investigation and resolution of both production and non-production environments. • Monitor capacity, high-availability and performance for non-production and production databases to ensure they are highly reliable, efficient, cost effective, and provide the required functionality. • Seeks opportunities to improve database performance by identifying tuning measures and implementing them when appropriate. • Develops and maintains database backup and recovery strategy and procedures. Ensures that databases are properly backed up and recovered when necessary • Ensures databases are properly maintained, meeting security, audit and compliance requirements. Databases are reorganized/groomed when necessary and other DBA utilities run when appropriate. • Managing SQL Server databases. • Configuring and maintaining database servers and processes • Monitoring system's health and performance • Analysing solving and correcting issues in real-time • Refining and automating regular processes, tracking issues, and documenting changes • Performing scheduled maintenance and supporting release deployment activities after hours Primary Skill: MS SQL Secondary Skill: DB2 LUW or Oracle or AWS RDS or Redshift

Skill Requirements

JD for MS SQL DBA: High level JD: • Design and develop optimal solutions to migrate or upgrade existing databases to new platform or DBMS versions • Build and leverage automation and DB DevSecOps pipelines to provision, upgrade, patch and maintain DB systems • Support DB change request and problem investigation and resolution of both production and non-production environments. • Monitor capacity, high-availability and performance for non-production and production databases to ensure they are highly reliable, efficient, cost effective, and provide the required functionality. • Seeks opportunities to improve database performance by identifying tuning measures and implementing them when appropriate. • Develops and maintains database backup and recovery strategy and procedures. Ensures that databases are properly backed up and recovered when necessary • Ensures databases are properly maintained, meeting security, audit and compliance requirements. Databases are reorganized/groomed when necessary and other DBA utilities run when appropriate. • Managing SQL Server databases. • Configuring and maintaining database servers and processes • Monitoring system's health and performance • Analysing solving and correcting issues in real-time • Refining and automating regular processes, tracking issues, and documenting changes • Performing scheduled maintenance and supporting release deployment activities after hours Primary Skill: MS SQL Secondary Skill: DB2 LUW or Oracle or AWS RDS or Redshift

Other Requirements

JD for MS SQL DBA: High level JD: • Design and develop optimal solutions to migrate or upgrade existing databases to new platform or DBMS versions • Build and leverage automation and DB DevSecOps pipelines to provision, upgrade, patch and maintain DB systems • Support DB change request and problem investigation and resolution of both production and non-production environments. • Monitor capacity, high-availability and performance for non-production and production databases to ensure they are highly reliable, efficient, cost effective, and provide the required functionality. • Seeks opportunities to improve database performance by identifying tuning measures and implementing them when appropriate. • Develops and maintains database backup and recovery strategy and procedures. Ensures that databases are properly backed up and recovered when necessary • Ensures databases are properly maintained, meeting security, audit and compliance requirements. Databases are reorganized/groomed when necessary and other DBA utilities run when appropriate. • Managing SQL Server databases. • Configuring and maintaining database servers and processes • Monitoring system's health and performance • Analysing solving and correcting issues in real-time • Refining and automating regular processes, tracking issues, and documenting changes • Performing scheduled maintenance and supporting release deployment activities after hours Primary Skill: MS SQL Secondary Skill: DB2 LUW or Oracle or AWS RDS or Redshift