SME - Oracle Administration,PostgreSQL,MYSQL, MS SQL

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 Dev Sec Ops 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 Dev Sec Ops 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 Dev Sec Ops 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 Dev Sec Ops 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