Senior Database Administrator DALIL INFORMATION TECHNOLOGY

1. Key Responsibilities

2.1 Database Administration

• Install, configure, patch, upgrade, and administer Oracle (including Multitenant, RAC, Data Guard, ASM), MS SQL (Always-on), MongoDB, PostgreSQL and MySQL (InnoDB Cluster & ClusterSet) database environments in production, staging, and development.

• Design and implement high-availability (HA) and disaster recovery (DR) architectures including Oracle RAC, Oracle Data Guard, GoldenGate replication, MS SQL (Always-on) , PostgreSQL replication, MongoDB replica sets / sharded clusters and MySQL InnoDB Cluster.

• Perform logical and physical backup and recovery operations using RMAN, Data Pump, mongodump/mongorestore, mysqldump, and pg_dump, and validate recovery procedures on a regular schedule.

• Conduct performance tuning and troubleshooting at all levels including SQL/query optimization, indexing strategies, storage I/O, memory, network, and OS-level diagnostics.

• Plan and execute large-scale database upgrades, migrations, and cross-platform conversions with minimal downtime.

• Implement and enforce database security: user management, role-based access control, auditing, TDE encryption, data masking, and compliance with organizational and regulatory standards.

• Develop and maintain automation scripts (Shell, Python, PL/SQL) for routine database operations, monitoring, and housekeeping tasks.

2.2 Middleware Administration

• Install, configure, and administer Oracle WebLogic Server including domain creation, managed servers, clustering, load balancing, and JVM tuning.

• Administer Oracle SOA Suite and Oracle Service Bus (OSB) including composite deployment, troubleshooting, dehydration store management, and integration support.

• Manage Oracle Business Intelligence Enterprise Edition (OBIEE) 12c and Oracle Analytics Server (OAS): installation, configuration, RPD deployment, security, and performance optimization.

• Install, configure, and support Oracle Data Integrator (ODI) for ETL workloads, including agent management, repository administration, and scenario execution.

• Deploy and manage Oracle Forms & Reports and other Java-based applications on WebLogic.

• Apply patches, security updates, and CPU/PSU bundles to all middleware components in line with vendor recommendations and change-management processes.

• Install, configure, and administer Apache products (Kafka, Spark, Tomcat) including clustering, load balancing, and JVM tuning.

2.3 Operating System & Infrastructure

• Strong working knowledge of Linux/Unix (Oracle Linux, RHEL, CentOS) and Windows Server environments hosting database and middleware workloads.

• Proficiency in bash and PowerShell scripting for automation, monitoring, log analysis, and routine maintenance.

• Solid understanding of storage (NFS, ASM, SAN), networking, kernel parameters, file systems, and OS-level security hardening concepts.

• Familiarity with capacity planning, server provisioning, and OS-level upgrades, with the ability to coordinate effectively with infrastructure and virtualization teams.

• Hands-on experience working with containerized environments, including Docker (and exposure to Kubernetes / OpenShift is a plus) for deploying, running, and managing database and middleware workloads.

2.4 Monitoring, Operations & Support

• Implement and maintain proactive monitoring frameworks using Oracle Enterprise Manager (OEM Cloud Control), Grafana, Prometheus, or equivalent tools.

• Respond to production incidents, perform root-cause analysis (RCA), and deliver post-incident reports with corrective and preventive actions.

• Serve as the primary technical contact for database and middleware vendors, coordinating SLAs, escalations, support tickets, and product renewals.

• Maintain detailed technical documentation, runbooks, architecture diagrams, and standard operating procedures (SOPs).

• Provide 24/7 on-call support on a rotational basis for critical production systems.

• Collaborate with application, security, DevOps, and infrastructure teams to align database and middleware operations with organizational standards and regulatory requirements.