Tech Specialist, Automation Solutions

n

Primary Skills

- Oracle DBA, Oracle PL/SQL, SQL DBA, MySQL

Job requirements

- 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 1. 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 1. 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 1. 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 1. Lead database upgrades.
- Develop upgrade plans.
- Develop rollback plans.
- Validate upgrade testing.
- Support modernization initiatives.

Migration

Activities 1. Conduct migration assessments.
- Build migration runbooks.
- Validate migration dependencies.
- Review migration readiness.
- Lead migration cutovers.
- Validate post-migration environments.

Security

Engineering 1. Design remediation plans.
- Review vulnerabilities.
- Conduct security assessments.
- Support audits.
- Review compliance findings. Automation 1. Develop automation scripts.
- Improve operational tooling.
- Automate health checks.

n

📌 Tech Specialist, Automation Solutions638 (Bengaluru)
🏢 Brillio
📍 Bengaluru