Tech Specialist, Cloud Engineering - R01570425

Brillio 2
Bangalore +1 more
Hybrid

Who this role is best for

Best suited to experienced database engineers with expertise in SQL Server, PostgreSQL, and Oracle platforms working in cloud engineering environments.

Best fit for

  • Experienced database engineers with 7–9 years of SQL Server, PostgreSQL, or Oracle expertise
    — “SQL Server / Azure SQL SME Experience 7–9 Years”
  • Candidates adept in HA/DR architecture and incident resolution for enterprise systems
    — “Lead P1 incident resolution. Lead P2 incident resolution.”
  • Individuals with strong skills in performance tuning and workload optimization
    — “Implement performance tuning recommendations. Optimize workload distribution.”

Things to consider

  • The role demands high availability and disaster recovery expertise across multiple platforms
    — “Design HA solutions. Design DR solutions.”
  • Candidates should be prepared for advanced incident management and root cause analysis
    — “Perform root cause analysis. Analyze recurring incidents.”

How to stand out

  • Highlight experience with SQL Server, Azure SQL, and PostgreSQL in your resume and interview responses
    — “Provide advanced operational support across Azure PostgreSQL, GCP PostgreSQL, and Enterprise PostgreSQL platforms.”
  • Demonstrate a track record of performance optimization and indexing strategy design
    — “Design indexing strategies. Implement performance tuning recommendations.”
  • Showcase experience with migration planning and validation of post-migration environments
    — “Validate post-migration environments. Build migration runbooks.”
  • Demonstrate ability to mentor junior engineers and improve operational SOPs
    — “Mentor L1 and L2 engineers. Improve operational runbooks.”
Pace · Fast PacedCollaboration · MediumAutonomy · MediumDecision Impact · Team

Derived from job-description analysis by Serendipath's career intelligence engine.

What success looks like

  • led resolution of critical incidents
  • conducted root cause analysis
  • validated upgrade testing
Typical background
7-9 years of experience in database administrationexpertise in SQL Server, Azure SQL, PostgreSQL

Skills & requirements

Required

Database AdministrationPerformance TuningTroubleshootingHigh AvailabilityDisaster RecoveryAutomationSql ServerAzure SqlPostgreSQL

Preferred

Cloud EngineeringScripting

Stack & domain

Database SMETech SpecialistSQL Server AdministrationAzure SQL DatabaseAzure SQL Managed InstanceHyperscaleAlways On Availability GroupsReplicationBackup And RecoveryPerformance TroubleshootingHa/dr OperationsPostgresql AdministrationAzure PostgresqlGCP PostgresqlEnterprise PostgresqlOracle DBACloud Engineering

About the role

Original posting from Brillio 2 via Lever

Tech Specialist, Cloud Engineering

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

  • 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

Source: Brillio 2 careers (Lever)

Similar roles