Senior Technical Specialist

Job Description Database SME OSSDB NoSQL

Role Overview

The Database SME OSSDB NoSQL is responsible for providing deep technical expertise across opensource and NoSQL 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 OSSDBNoSQL 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 DevOps teams to support automation workflows involving Terraform ARMBicep GitHub 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 OSSDBNoSQL operational nuances and troubleshooting techniques

Security Reliability Governance

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

Support teams in validating compliancerelated checks and operational readiness

Required Skills Experience

Minimum 812 years of experience working with opensource and NoSQL databases

Strong expertise in at least three of the following platforms

oPostgreSQL MySQL or MariaDB

oCosmos DB MongoDB Cassandra

oRedis Couchbase

oElasticsearch or similar NoSQL engines

Handson experience with

oDatabase Server InstallationProvisioningsetup 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 DevOps workflows Terraform BicepARM Git ADO GitHub

Understanding of database security models RBAC backups and monitoring approaches

Strong analytical communication and crossteam collaboration skills

Certifications Preferred

PostgreSQL MySQL MongoDB or Cassandra professional certifications

Microsoft Azure databaserelated certifications good to have

Linux or Kubernetes certifications beneficial for containerized workloads

Preferred Qualifications

Exposure to cloudmanaged database services and distributed data platforms

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

Skills

Mandatory Skills : PostgreSQL