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