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
Skills and Competencies
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.
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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
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.
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 resumeSimilar 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...