Senior Technical Specialist

Job Description Database SME OSSDB No

SQL

Role Overview

The Database SME OSSDB No

SQL is responsible for providing deep technical expertise across opensource and No

SQL database platforms throughout the migration lifecycle The role focuses on assessments readiness activities execution support validation troubleshooting and ensuring successful transition of database workloads The SME collaborates closely with architects engineers and customer teams to drive smooth migration delivery and maintain high quality and reliability

Key Responsibilities

Assessment Readiness Activities

Perform detailed analysis of existing OSSDBNo

SQL environments including configurations extensions schemas data sizes and workload characteristics

Identify compatibility considerations sequencing requirements data dependencies and application integrations

Provide input for migration planning timelines and preparation activities

Execution Support Cutover Coordination

Support engineers during data movement cycles ongoing sync methods cutover activities and validation checks

Troubleshoot database issues related to performance connectivity replication access or configuration

Assist with dry runs data integrity checks and postmigration validation

Performance Operational Optimization

Conduct performance diagnostics across queries indexes cache settings and database parameters

Recommend optimizations to ensure stable operations and efficient performance postmigration

Automation Tooling Enablement

Contribute to reusable scripts templates and validation steps that streamline database operations

Work with Dev Ops teams to support automation workflows involving Terraform ARMBicep Git Hub or ADO

Collaboration Technical Guidance

Work closely with Database Architects Squad Leads Application SMEs and Data teams throughout the migration

Provide technical inputs and clarify databasespecific requirements constraints and best practices

Mentor engineers on OSSDBNo

SQL operational nuances and troubleshooting techniques

Security Reliability Governance

Ensure recommended configurations follow standards for access control encryption monitoring and resilience

Support teams in validating compliance related checks and operational readiness

Required Skills Experience

Minimum 812 years of experience working with opensource and No

SQL databases

Strong expertise in at least three of the following platforms

oPostgre

SQL MySQL or MariaDB

oCosmos DB Mongo

DB Cassandra

oRedis Couchbase

oElasticsearch or similar No

SQL engines

Handson experience with

oDatabase Server Installation Provisioningsetup Configuration

oDatabase Administration Backup Recovery Migration

oReplication HADR setups clustering or sharding

oQuery tuning schema optimization indexing and diagnostics

oData validation and troubleshooting

Familiarity with automation and Dev Ops workflows Terraform Bicep

ARM Git ADO Git Hub

Understanding of database security models RBAC backups and monitoring approaches

Strong analytical communication and crossteam collaboration skills

Certifications Preferred

Postgre

SQL MySQL Mongo

DB or Cassandra professional certifications

Microsoft Azure database related certifications good to have

Linux or Kubernetes certifications beneficial for containerized workloads

Preferred Qualifications

Exposure to cloud managed database services and distributed data platforms

Ability to create reusable checklists validation steps and documentation for execution teams

Skills

Mandatory Skills :
Postgre

SQL