Tech Specialist, Database & Middleware – R01571246

Brillio; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Brillio is seeking a Tech Specialist, Database & Middleware to manage operational database support across SQL Server, Azure SQL, PostgreSQL, and Oracle. You will monitor availability, manage user accounts, and coordinate with L2 teams for rapid incident resolution.

The role involves executing health checks, backups validation, and contributing to migration/deployment activities while maintaining audit logs and documentation for compliance.

Qualifications

• 2–4 years of experience in operational database support across SQL Server, Azure SQL, PostgreSQL, and Oracle platforms.
• Experience with administration of multiple database platforms and security policies.

Responsibilities

• Monitor and manage database availability, CPU, memory, and disk utilization alerts to ensure performance and uptime.
• Administer user accounts across multiple database platforms per security policies.
• Log, categorize, and escalate incident tickets with L2 teams for timely resolution.
• Execute approved scripts, run health checks, restart services, and generate reports.
• Verify backups, validate backup logs, and address failures to maintain data integrity.
• Review database logs and assist with migration and deployment activities to minimize downtime.
• Monitor growth trends, replication health, and maintenance jobs to optimize resources.
• Update technical knowledge articles and documentation for knowledge sharing.

Skills

SQL Server

Azure SQL

PostgreSQL

Oracle DBA

Backup/Restore

Health checks

Incident management

User administration

Monitoring

Audit logs

WebLogic

WebSphere

MongoDB

MySQL

Informix

Tomcat

NGINX

PL/SQL

Python

BizTalk

CFI/MFT

Education

Bachelor’s degree in CS/IT

PostgreSQL/SQL Server admin cert

Job description

Tech Specialist, Database & Middleware - R01571246

Job requirements

Experience Range:

• 2 – 4 years of experience, including at least 2-3 years in operational database support across SQL Server, Azure SQL, PostgreSQL, and Oracle platforms

Key Responsibilities:

• Monitor and manage database availability, CPU, memory, and disk utilization alerts to ensure optimal performance and uptime, documenting resolution actions and system status
• Administer user accounts by creating, modifying, disabling inactive accounts, resetting passwords, and managing permissions across multiple database platforms, ensuring compliance with security policies
• Log, categorize, and prioritize incident tickets, escalating unresolved issues and maintaining accurate worklogs while coordinating with L2 teams for timely resolution
• Execute approved scripts, run health checks, restart database services, and generate comprehensive support and audit reports to meet operational and regulatory requirements
• Verify backup completion, validate backup job logs, and elevate failed backups to maintain data integrity and business continuity, tracking backup success rates
• Review database logs, support failover notifications, and assist with migration and deployment activities to minimize downtime and ensure seamless transitions
• Monitor and analyze database growth trends, replication health, and failed maintenance jobs to proactively address system risks and optimize resource utilization
• Update and maintain technical knowledge articles and documentation to support operational excellence and facilitate knowledge sharing across the team

Required Skills:

• SQL Server administration and troubleshooting
• Azure SQL database management and monitoring
• PostgreSQL administration and performance tuning
• Oracle DBA tasks including user management and backup operations
• Database backup and restore processes across multiple platforms
• Execution and validation of health check and maintenance scripts
• Incident and alert management in enterprise database environments
• Database user administration and security best practices
• Monitoring tools for CPU, memory, and disk utilization
• Generating and interpreting database reports and audit logs

Preferred Skills:

• Weblogic or WebSphere administration in enterprise environments
• MongoDB, MySQL, or Informix DBA experience
• Middleware technologies such as Apache Tomcat and NGINX
• Advanced scripting for automation using Oracle PL/SQL or Python
• Experience with enterprise integration platforms such as BIZTALK or CFI/MFT

Desired Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, or a closely related discipline
• PostgreSQL or SQL Server administration certification