Operations Engineer

Project Role : Operations Engineer

Project Role Description : Support the operations and/or manage delivery for production systems and services based on operational requirements and service agreement.

Must have skills : Oracle Database Administration (DBA)

Good to have skills : NA
Minimum 5 year(s) of experience is required

Educational Qualification : 15 years full time education

Summary:
A Database Middleware Service Engineer is responsible for the day-to-day operation, monitoring, support, and maintenance of enterprise database and integration platforms. The role ensures the availability, performance, and integrity of relational databases (Oracle, SQL Server, PostgreSQL), NoSQL stores (MongoDB), cloud-native database services (AWS RDS/Aurora, GCP Cloud SQL), and the full middleware stack - IBM MQ, Kafka, API Gateway, Tibco, and MuleSoft - across a regulated financial services environment.
This individual forms the primary operational execution layer within the data and integration platform tower - a proficient hands-on engineer with strong platform knowledge across both database and middleware disciplines, disciplined incident and change management practices, and the ability to collaborate effectively across application, cloud, security, and network teams.

Roles Responsibilities:
Database Operations Platform Health
- Monitor and maintain enterprise relational database platforms - Oracle, SQL Server, and PostgreSQL - ensuring continuous availability, performance, and replication health across on-premises and cloud environments
- Manage day-to-day database operations - instance health monitoring, tablespace and storage management, alert log review, backup job verification, and scheduled maintenance tasks
- Provide L2/L3 support for database incidents - performing structured troubleshooting, diagnosing performance issues, resolving connectivity and locking problems, and restoring service within defined SLA commitments
- Monitor and operate cloud-native database services - AWS RDS/Aurora and GCP Cloud SQL - including replica lag monitoring, automated backup verification, parameter group management, and failover validation
- Execute database configuration changes, patching, and version upgrades - following approved change management procedures with pre-change validation and post-change verification
- Perform database performance monitoring and tuning support - identifying slow queries, reviewing execution plans, analyzing wait events, and escalating to Principal Engineers for complex optimization work
- Manage MongoDB replica set and Atlas cluster operations - monitoring replication status, managing index builds, and supporting operational queries
- Maintain CMDB accuracy for database assets - instance inventory, connection strings, schema ownership, and lifecycle records - to audit-ready standards
Middleware Integration Platform Operations
- Monitor and maintain IBM MQ and RabbitMQ messaging infrastructure - queue depth monitoring, dead-letter queue management, channel status, and HA cluster health across all environments
- Operate Apache Kafka clusters - broker health monitoring, consumer group lag tracking, topic management, and Kafka Connect connector operations and failure resolution
- Support MuleSoft Anypoint Platform operations - Mule runtime monitoring, application deployment support, alert triage, and API health monitoring across CloudHub and on-premises runtimes
- Monitor and support Tibco BusinessWorks and EMS platforms - process health monitoring, adapter status, queue management, and escalation of persistent failures to Principal Engineers
- Manage API Gateway operations - Kong or AWS API Gateway - monitoring endpoint health, responding to rate-limit and authentication alerts, and supporting configuration change execution
- Perform structured incident management for middleware events - message delivery failures, integration flow errors, connectivity outages - with accurate RCA documentation and preventive action tracking
- Execute middleware configuration changes, patch cycles, and version updates - following approved change procedures with pre- and post-change validation
- Maintain operational runbooks, SOPs, and platform documentation for all database and middleware platforms - keeping procedures current, accurate, and audit-ready
Security, Compliance Continuous Improvement
- Manage database user access requests, role assignments, and access reviews - enforcing least-privilege principles and ensuring compliance with PCI DSS and SOX access controls
- Monitor and respond to database and middleware security alerts - unauthorised access attempts, privilege escalation events, and compliance policy violations
- Support audit and regulatory activities - producing database access logs, configuration exports, backup evidence, and MiFID II call recording compliance documentation as required
- Execute vulnerability remediation and security patching across database and middleware platforms - tracking CVEs, prioritising remediation, and evidencing closure within SLA
- Participate in on-call and escalation support rotas for Tier 1 database and middleware services
- Contribute to continuous improvement - identifying recurring failure patterns, toil reduction opportunities, and automation candidates within the data and integration operations function

Professional Technical Skills:
Must-Have Technical Skills
Oracle Operations: Instance monitoring, alert log analysis, tablespace management, RMAN backup verification, AWR/ASH report reading, and L2 incident support
SQL Server Operations: AlwaysOn AG health monitoring, SQL Agent job management, index maintenance, blocking/deadlock analysis, and backup/restore operations
PostgreSQL Operations: Streaming replication monitoring, VACUUM management, pg stat analysis, connection pooling (PgBouncer), and backup/restore procedures
MongoDB Operations: Replica set monitoring, Atlas cluster management, slow query log analysis, index build support, and backup verification
Cloud DB Services: AWS RDS/Aurora and GCP Cloud SQL - instance monitoring, replica lag, parameter management, automated backup verification, and failover testing
IBM MQ / Kafka: Queue depth monitoring, dead-letter queue management, Kafka consumer lag tracking, topic operations, and Kafka Connect connector health
MuleSoft Operations: Anypoint runtime monitoring, application deployment, alert triage, API health checks, and CloudHub / on-prem runtime support
Tibco Operations: BusinessWorks process health, EMS queue management, adapter status monitoring, and escalation-ready fault diagnosis
API Gateway: Kong or AWS API Gateway - endpoint health monitoring, rate-limit alert response, certificate management, and configuration change execution
Incident Change Management: Structured P1-P3 incident handling, ITIL-aligned change execution, post-change verification, and RCA documentation in FSI environments
Database Security: User access management, least-privilege enforcement, TDE and encryption verification, access log review, and audit evidence production
FSI Compliance: PCI DSS, SOX, MiFID II - database audit logging, data residency awareness, access certification, and regulatory evidence production
Preferred / Advantageous
- Experience with database performance tooling - Oracle Enterprise Manager, SQL Server Management Studio, pgAdmin, or equivalent monitoring platforms
- Familiarity with Kafka Schema Registry, Kafka Connect, and message serialisation formats (Avro, JSON Schema) for integration operations
- Exposure to IaC tooling (Terraform or Ansible) for database and middleware provisioning and configuration management
- ITIL Foundation or equivalent service management framework certification

Additional Information:
- Changes across database and middleware platforms are executed cleanly - validated, implemented without unplanned impact, and verified post-completion with documented evidence
- Application, cloud, security, and network teams regard the Database Middleware Service Engineer as a reliable, technically credible operational partner who resolves platform issues efficiently and proactively

Mandatory Certifications
Oracle DB Associate (OCA) or Equivalent
MuleSoft Certified Developer (Level 1)
AWS Database Specialty or GCP Associate Cloud Engineer

Qualification 15 years full time education