Tech Specialist Automation Solutions

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. 2. Analyze query execution plans. 3. Design indexing strategies. 4. Implement performance tuning recommendations. 5. Conduct performance baselining. 6. Analyze deadlocks. 7. Analyze blocking chains. 8. Optimize workload distribution. 9. Perform capacity assessments. 10. Establish performance standards. Advanced Troubleshooting 1. Lead P1 incident resolution. 2. Lead P2 incident resolution. 3. Perform root cause analysis. 4. Investigate database corruption issues. 5. Resolve replication failures. 6. Resolve cluster failures. 7. Resolve failover issues. 8. Analyze recurring incidents. HA/DR Architecture 1. Design HA solutions. 2. Design DR solutions. 3. Review RTO compliance. 4. Review RPO compliance. 5. Conduct DR readiness assessments. 6. Lead DR testing. 7. Validate failover design. 8. Validate failback design. Upgrade & Modernization 1. Lead database upgrades. 2.



Develop upgrade plans. 3. Develop rollback plans. 4. Validate upgrade testing. 5. Support modernization initiatives. Migration Activities 1. Conduct migration assessments. 2. Build migration runbooks. 3. Validate migration dependencies. 4. Review migration readiness. 5. Lead migration cutovers. 6. Validate post-migration environments. Security Engineering 1. Design remediation plans. 2. Review vulnerabilities. 3. Conduct security assessments. 4. Support audits. 5. Review compliance findings. Automation 1. Develop automation scripts. 2. Improve operational tooling. 3. Automate health checks.

We may use artificial intelligence (AI) tools to support parts of the hiring process such as reviewing applications analyzing resumes or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed please contact us.

Required Experience:

IC

📌 Tech Specialist, Automation Solutions R (Bengaluru)
🏢 Brillio
📍 Bengaluru