Assistant General Manager - Infra and IT - SCO

DP World


Date: 9 hours ago
City: Mumbai, Maharashtra
Contract type: Full time
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, replication, backup failures, locks and database growth.
  • Own troubleshooting of P1/P2 production incidents, perform RCA and drive corrective/preventive actions.
  • Participate in on-call support for business-critical production systems.

Automation, Change & Documentation

  • Automate repeatable activities using Bash/Shell, SQL, PL/SQL and PowerShell; Python/Ansible exposure is desirable.
  • Follow ITIL change management, prepare implementation/rollback/validation plans and participate in CAB as required.
  • Maintain server/database inventory, architecture/topology diagrams, SOPs, runbooks, backup/DR procedures, patch schedules and capacity reports.

Qualifications & Competencies

Skills and Competencies

  • Strong hands-on Linux administration: RHEL / Oracle Linux, LVM, multipathing, NFS, SAN/NAS, systemd, SSH, TCP/IP, DNS, NTP and Shell scripting.
  • Strong Oracle DBA skills: RMAN, Data Guard, AWR/ASH/ADDM, SQL tuning, patching, recovery, ASM; RAC knowledge preferred.
  • Strong PostgreSQL skills: streaming replication, WAL, PITR, pg_dump/pg_restore, pg_basebackup, Vacuum/Autovacuum, query optimization and upgrades.
  • Strong Microsoft SQL Server skills: Always On, backup/recovery, SQL Agent, performance tuning, indexes/statistics, blocking/deadlock analysis and patching.
  • Good understanding of VMware, storage, enterprise backup, Active Directory, networking, high availability, disaster recovery and cloud infrastructure.
  • Strong troubleshooting, analytical thinking, ownership, documentation, stakeholder communication and vendor coordination.

Stakeholder Internal: Application Teams, Infrastructure Teams, Cloud Team, Network Team, Storage & Backup Team, Cyber Security/SOC, Service Desk, IT Leadership, Business/BU IT Teams

External: OEMs, Database/OS Support Vendors, Managed Service Providers and Technology Partners

Educational Qualification

(min) Engineering Graduate or Equivalent in Computer Science / Information Technology / Electronics or relevant technical discipline

Preferred Certifications If

any RHCSA / RHCE; Oracle OCP; PostgreSQL certification; Microsoft SQL Server / Azure Database certification; AWS or Azure certification; ITIL Foundation

Range/ Min no of years -

of overall Experience

required 8-12+ Years overall IT Infrastructure / Database Administration experience, including minimum 5 years of hands-on Linux administration and strong production DBA experience in at least two of Oracle, PostgreSQL and Microsoft SQL Server.

Min no of years of

Industry specific

Experience Required, If

any & the industry type Minimum 5 years supporting enterprise production environments. Experience in Logistics, Ports & Terminals, Warehousing, 3PL, Manufacturing or other 24x7 mission-critical environments is preferred.

How to apply

To apply for this job you need to authorize on our website. If you don't have an account yet, please register.

Post a resume

Similar jobs

Audio Engineer - Pro Tools

Alignerr, Mumbai, Maharashtra
6 days ago
Audio Engineer – Pro Tools (AI Training)About The RoleWe're looking for skilled Audio Engineers to help evaluate and improve AI systems built for audio production. Your professional ear and Pro Tools expertise will directly shape how AI understands, processes, and produces sound — making a real impact on the future of AI-driven music and audio tools.Organization: LabelboxType: Hourly ContractLocation: RemoteCommitment:...

Consultant - Risk Consulting - ESG (Environmental, Social and Governance) - Mumbai/ Bangalore

EY, Mumbai, Maharashtra
1 week ago
As a global leader in assurance, tax, transaction and advisory services, we hire and develop the most passionate people in their field to help build a better working world. This starts with a culture that believes in giving you the training, opportunities and creative freedom. At EY, we don't just focus on who you are now, but who you can...

Assistant Manager

Marsh, Mumbai, Maharashtra
1 week ago
We are seeking a talented individual to join our Finance team at Marsh Risk India, a Marsh business. This role will be based in Mumbai This is a hybrid role that has a requirement of working at least three days a week in the officeAssistant Manager - FinanceWe will count on you to:Engage in preparation of annual operating plan, monitoring...