Brillio

Technology consulting for AI-driven digital transformation

Tech Specialist - Automation Solutions

Database AdministrationPosted on Nov 10

Full-timeBengaluru, Karnataka, IndiaNo salary listedHybrid

About the Job

Requirements

Seven to nine years of database subject-matter-expert or Tech Specialist experience.
Expertise in Oracle Database Administration, Oracle PL/SQL, SQL Database Administration, and MySQL.

Responsibilities

Own technical engineering, architecture reviews, migrations, high availability and disaster recovery design, advanced troubleshooting, and performance optimization.
Review enterprise database performance, analyze query execution plans, design indexing strategies, implement performance-tuning recommendations, conduct performance baselining, analyze deadlocks and blocking chains, optimize workload distribution, perform capacity assessments, and establish performance standards.
Lead P1 and P2 incident resolution, perform root cause analysis, investigate database corruption issues, resolve replication, cluster, and failover failures, and analyze recurring incidents.
Design high availability and disaster recovery solutions, review recovery time objective and recovery point objective compliance, conduct disaster recovery readiness assessments, lead disaster recovery testing, and validate failover and failback designs.
Lead database upgrades, develop upgrade and rollback plans, validate upgrade testing, and support modernization initiatives.
Conduct migration assessments, build migration runbooks, validate migration dependencies, review migration readiness, lead migration cutovers, and validate post-migration environments.
Design remediation plans, review vulnerabilities, conduct security assessments, support audits, and review compliance findings.
Develop automation scripts, improve operational tooling, and automate health checks.

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.

About the Company

Brillio

Technology consulting for AI-driven digital transformation

Brillio helps organizations move their systems and processes into the digital world by providing technology consulting and customized AI and cloud-based solutions. The company works with large clients, including many Fortune 500 firms, and has a strong emphasis on the healthcare sector. Its offerings include designing and building tailored software and workflows that improve efficiency, security, and scalability, and enabling real-time, AI-powered interactions through generative AI tools. Customers typically engage Brillio through long-term support contracts or project-based work, paying for both advisory services and the implementation of technology solutions. Brillio’s goal is to help clients become ‘generative enterprises’—organizations that leverage AI and cloud technologies to continuously transform operations and user experiences, stay competitive, and drive measurable business outcomes.

Company size: 5,001-10,000
Company stage: Late Stage VC
Total funding: Not listed
Headquarters: Dallas, TX
Founded: 2014

Recently Posted Jobs

Explore more opportunities at Brillio

See more jobs