Assistant General Manager - Infra and IT - SCO

DP World; Mumbai; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

DP World in Mumbai is seeking an experienced Linux and database administrator to manage RHEL/Oracle Linux servers and multiple database platforms.

You will install, patch, harden and monitor Linux systems across physical, VMware, and cloud environments; administer Oracle, PostgreSQL and SQL Server databases; implement backups, DR plans and performance tuning.

Qualifications

• Install, configure, administer, patch, upgrade and troubleshoot RHEL/Oracle Linux servers.
• Manage Linux systems across physical, VMware and cloud environments, including users/groups, sudo, SSH, systemd, cron, DNS, NTP and network configuration.
• Administer file systems, LVM, NFS, SAN/NAS connectivity and multipathing; troubleshoot CPU, memory, disk I/O, kernel and network issues.
• Perform OS hardening, vulnerability remediation, package/repository management using YUM/DNF and capacity planning.
• Develop Bash/Shell automation for health checks, operational tasks and reporting.

Responsibilities

• Install, configure, administer, patch, upgrade and troubleshoot Oracle databases including 12c/19c and later.
• Manage Oracle instances, schemas, users, roles, privileges, tablespaces and listeners.
• Monitor and tune SQL performance using AWR, ASH, ADDM and Explain Plan; manage RMAN backups, restore and recovery.
• Configure Data Guard, replication, DR architectures; plan Release Updates and patching; troubleshoot archive logs and recovery issues.
• Install, configure, administer PostgreSQL databases and clusters; manage roles, privileges and configurations.
• Install, configure, administer Microsoft SQL Server databases; manage backups, log shipping, Always On and maintenance.
• Define and maintain backup standards, restore procedures and DR drills; validate recovery capability.
• Proactively monitor Linux and database performance; perform capacity forecasting and optimization with application teams.
• Implement Linux/database hardening and vulnerability remediation; track end-of-support versions and upgrade plans.
• Configure proactive monitoring and alerts for availability and resource utilization across systems and databases.

Skills

Linux Administration

Oracle Database

PostgreSQL

MS SQL Server

VMware

Scripting Bash

Backup & DR

Monitoring & Troubleshooting

Security Hardening

Tools

VMware

NFS

SAN/NAS

Job description

• Install, configure, administer, patch, upgrade and troubleshoot RHEL and Oracle Linux servers.
• Manage Linux systems across physical, VMware and cloud environments, including users/groups, sudo, SSH, systemd, cron, DNS, NTP and network configuration.
• Administer file systems, LVM, NFS, SAN/NAS connectivity and multipathing; troubleshoot CPU, memory, disk I/O, kernel and network issues.
• Perform OS hardening, vulnerability remediation, package/repository management using YUM/DNF and capacity planning.
• Develop Bash/Shell automation for health checks, operational tasks and reporting.

Job Description

Key responsibilities

Linux Administration

• Install, configure, administer, patch, upgrade and troubleshoot RHEL and Oracle Linux servers.
• Manage Linux systems across physical, VMware and cloud environments, including users/groups, sudo, SSH, systemd, cron, DNS, NTP and network configuration.
• Administer file systems, LVM, NFS, SAN/NAS connectivity and multipathing; troubleshoot CPU, memory, disk I/O, kernel and network issues.
• Perform OS hardening, vulnerability remediation, package/repository management using YUM/DNF and capacity planning.
• Develop Bash/Shell automation for health checks, operational tasks and reporting.

Oracle Database Administration

• Install, configure, administer, patch, upgrade and troubleshoot Oracle databases, including supported enterprise versions such as 12c/19c and later.
• Manage instances, schemas, users, roles, privileges, tablespaces, listeners, initialization parameters and database storage.
• Monitor and tune SQL performance using AWR, ASH, ADDM, Explain Plan, SQL Trace, wait events, SGA/PGA and session analysis.
• Manage RMAN backup, restore and recovery, database cloning/refresh, migrations and point-in-time recovery.
• Configure and support Data Guard, replication, DR architectures, ASM and RAC environments where applicable.
• Plan and execute Oracle Release Updates/security patching and troubleshoot archive log, corruption, storage and recovery issues.

PostgreSQL Database Administration

• Install, configure, administer, patch, upgrade and troubleshoot PostgreSQL databases and clusters.
• Manage roles, privileges, schemas, tablespaces, extensions and configuration files including postgresql.conf and pg_hba.conf.
• Tune queries, connections, memory, locks, transactions, indexes, checkpoints, autovacuum and database/storage growth.
• Manage pg_dump/pg_restore, pg_basebackup, WAL archiving and Point-in-Time Recovery.
• Configure and support streaming replication and HA solutions such as Patroni, repmgr or equivalent where implemented.
• Perform major/minor upgrades, migrations, refreshes and troubleshoot replication lag, deadlocks, blocking and table/index bloat.

Microsoft SQL Server Administration

• Install, configure, administer, patch, upgrade and troubleshoot Microsoft SQL Server databases.
• Manage databases, logins/users, permissions, database files, TempDB, SQL Agent jobs and maintenance activities.
• Configure and support Always On Availability Groups, Failover Cluster Instances, log shipping and replication where applicable.
• Manage full, differential and transaction-log backups and point-in-time recovery.
• Monitor and troubleshoot blocking, deadlocks, CPU/memory pressure, disk latency, waits and long-running queries.
• Perform query tuning, index/statistics management, SQL Server cumulative updates and integration with Active Directory authentication.

Backup, Recovery & Disaster Recovery

• Define and maintain database backup standards, retention, restore procedures and recovery runbooks.
• Coordinate with enterprise backup teams and regularly validate restore capability for Oracle, PostgreSQL and SQL Server.
• Participate in DR drills and validate RPO, RTO, replication status and application-consistent recovery.

Performance, Capacity & Availability

• Proactively monitor Linux and database performance across CPU, memory, disk, storage latency, network and SQL workloads.
• Perform capacity forecasting for database growth, tablespaces, file systems, transaction logs, WAL/archive logs and infrastructure resources.
• Work with application teams to optimize SQL and recommend scaling or configuration improvements.

Security, Compliance & Lifecycle

• Implement Linux/database hardening, least-privilege access, privileged/service account reviews and vulnerability remediation.
• Plan and execute Linux patching, Oracle Release Updates, PostgreSQL updates and SQL Server Cumulative Updates.
• Track end-of-support versions and develop upgrade/migration plans; support audit evidence and compliance closure.

Monitoring, Incident & Problem Management

• Configure proactive monitoring and alerts for availability, resource utilization, storage capacity,