Assistant General Manager - Infra and IT - SCO

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.