Site Reliability Engineer - Database

Key Responsibilities 1. Database Administration & Optimization (Primary Focus) Database Operations Administer and maintain ESB-related databases (DB2, Oracle, SQL Server, PostgreSQL, MySQL, or equivalent).Perform database installation, configuration, upgrades, patching, and lifecycle management.Manage database schemas, tablespaces, indexes, stored procedures, and jobs supporting the integration platform.Ensure database high availability and disaster recovery readiness.Performance Tuning Monitor database performance and proactively identify bottlenecks.Analyze slow-running queries and optimize execution plans.Implement indexing strategies and database optimization techniques.Perform capacity planning based on transaction growth and integration workloads.Backup & Recovery Design and execute backup, restoration, and recovery procedures.Validate backup integrity through regular recovery testing.Establish and maintain RPO/RTO requirements for critical integration databases.Database Security Manage database access control and privileged accounts.Ensure encryption, audit logging, and compliance requirements are implemented.Collaborate with security teams to remediate vulnerabilities and perform security hardening. 2. ESB Platform Reliability Engineering Platform Availability Ensure ESB services meet defined SLA, SLO, and availability targets.Maintain platform resilience through proactive monitoring and preventive maintenance.Support middleware platforms such as:IBM Integration Bus (ESB Suite)WebMethodsApache KafkaRed HatMFTAzure Integration ServicesHybrid Integration PlatformsReliability Management Implement reliability engineering practices and operational standards.Conduct root cause analysis (RCA) and problem management activities.Eliminate recurring incidents through automation and service improvements. 3. Monitoring & Observability Implement monitoring and alerting for databases, ESB runtimes, API gateways, and messaging services.Create operational dashboards and health reports.Monitor:Database performanceQueue depthIntegration transaction volumeService latencyError ratesInfrastructure utilizationPreferred Tools ElasticSplunkOpenSearch 4. Incident & Problem Management Act as escalation point for critical production incidents.Lead incident response activities for integration and database-related outages.Perform post-incident reviews and corrective action tracking.Participate in 24x7 on-call support rotation when required.Key Activities Incident triageService restorationRoot cause analysisPreventive action implementationKnowledge base maintenance 5. Automation & DevOps Develop automation scripts to reduce operational overhead.Automate:Database maintenance activitiesBackup validationHealth checksMonitoring configurationsDeployment verificationCommon Technologies PythonShell ScriptingPowerShellTerraformJenkinsGitHub Actions 6. Capacity & Performance Management Monitor platform utilization and growth trends.Conduct performance benchmarking and stress testing.Forecast infrastructure and database resource requirements.Recommend scaling strategies for integration workloads. 7. Disaster Recovery & Business Continuity Design and maintain DR procedures for ESB platforms and databases.Participate in periodic DR drills.Ensure service recovery objectives meet business requirements. 8. Governance & Compliance Ensure compliance with enterprise security and operational standards.Maintain operational documentation, runbooks, and architecture diagrams.Support audit and regulatory requirements. Required Qualifications Education Bachelor's Degree in Computer Science, Information Systems, Engineering, or related discipline.Experience 3+ years of experience in SRE, Middleware Operations, Database Administration, or Platform Engineering.3+ years managing enterprise integration platforms.Proven experience supporting mission-critical production environments. Technical Skills Database (Mandatory) DBADatabase Performance TuningBackup & RecoveryReplication & High AvailabilityQuery OptimizationData Security & AuditingIntegration Technologies Enterprise Service Bus (ESB)API ManagementKafkaMQ SeriesActiveMQRDQMREST/SOAP ServicesInfrastructure Linux AdministrationWindows ServerKubernetesDockerPublic Cloud Platforms (Azure preferred)Monitoring & Observability ElasticSplunkOpenSearch Soft Skills Strong analytical and troubleshooting capabilities.Ability to work under pressure during production incidents.Stakeholder communication and coordination skills.Continuous improvement mindset.Strong documentation and knowledge-sharing practices.