Database SME / Tech Specialist Experience 7 - 9 Years Role Purpose Own technical engineering, architecture reviews, migrations, HA/DR design, advanced troubleshooting, and performance optimization. Detailed Activities Advanced Performance Engineering
Review enterprise database performance.
Analyze query execution plans.
Design indexing strategies.
Implement performance tuning recommendations.
Conduct performance baselining.
Analyze deadlocks.
Analyze blocking chains.
Optimize workload distribution.
Perform capacity assessments.
Establish performance standards.
Advanced Troubleshooting
Lead P1 incident resolution.
Lead P2 incident resolution.
Perform root cause analysis.
Investigate database corruption issues.
Resolve replication failures.
Resolve cluster failures.
Resolve failover issues.
Analyze recurring incidents.
HA/DR Architecture
Design HA solutions.
Design DR solutions.
Review RTO compliance.
Review RPO compliance.
Conduct DR readiness assessments.
Lead DR testing.
Validate failover design.
Validate failback design.
Upgrade & Modernization
Lead database upgrades.
Develop upgrade plans.
Develop rollback plans.
Validate upgrade testing.
Support modernization initiatives.
Migration Activities
Conduct migration assessments.
Build migration runbooks.
Validate migration dependencies.
Review migration readiness.
Lead migration cutovers.
Validate post-migration environments.
Security Engineering
Design remediation plans.
Review vulnerabilities.
Conduct security assessments.
Support audits.
Review compliance findings.
Automation
Develop automation scripts.
Improve operational tooling.
Automate health checks.
SQL Server / Azure SQL SME Experience 7–9 Years Role Purpose Provide advanced operational support, technical leadership, incident management, migration support, performance analysis, and platform governance for SQL Server, Azure SQL Database, Azure SQL Managed Instance, and Hyperscale environments. Mandatory Skills
SQL Server Administration
Azure SQL Database
Azure SQL Managed Instance
Hyperscale
Always On Availability Groups
Replication
Backup and Recovery
Performance Troubleshooting
HA/DR Operations
Key Responsibilities Advanced Support
Lead resolution of critical incidents.
Perform advanced troubleshooting.
Support major incident bridges.
Conduct root cause analysis.
Performance & Health Analysis
Analyze query performance issues.
Identify performance bottlenecks.
Review blocking and deadlock situations.
Recommend improvements for Engineering approval.
Operational Governance
Review database patching activities.
Review upgrade readiness.
Support migration assessments.
Validate deployment readiness.
Knowledge & Continuous Improvement
Mentor L1 and L2 engineers.
Reduce dependency escalations.
Improve operational runbooks.
Maintain known error database.
________________________________________ PostgreSQL SME Experience 7–9 Years Role Purpose Provide advanced PostgreSQL operational support across Azure PostgreSQL, GCP PostgreSQL, and Enterprise PostgreSQL platforms. Mandatory Skills
PostgreSQL Administration
Azure PostgreSQL
GCP PostgreSQL
Replication
WAL Management
Backup & Recovery
Performance Troubleshooting
High Availability
Key Responsibilities
Lead P1/P2 Postgres incidents.
Analyze replication failures.
Support failover validation activities.
Review PostgreSQL performance trends.
Support database migration activities.
Conduct RCA for recurring issues.
Review monitoring and alert effectiveness.
Mentor support engineers.
Improve operational SOPs.
________________________________________ Oracle SME Experience 7–9 Years Role Purpose Provide advanced Oracle database operational support and governance across Oracle Enterprise, RAC, Data Guard, and RMAN environments. Mandatory Skills
Oracle DBA
RAC
Data Gua
