Database Administrator — SQL Server, Oracle & PostgreSQL (Goregaon)

Database Administrator — SQL Server, Oracle & PostgreSQL (Goregaon)

19 Nov
|
IDSSPL Technologies
|
Goregaon

19 Nov

IDSSPL Technologies

Goregaon

Role Summary

We are looking for a Database Administrator to support critical production databases across primary data centers and disaster recovery sites.

Key Responsibilities

Database Administration

· Plan and perform database installation, configuration, patching and upgrades.

· Manage databases, schemas, tablespaces, storage, listeners, services and connectivity.

· Establish database configuration, naming, storage and operational standards.

· Perform database, version, platform and data-center migrations.

· Maintain inventories covering database versions, ownership, dependencies and lifecycle plans.

High Availability and Replication

Configure and support the following technologies, as applicable:

· SQL Server: Always On Availability Groups, Failover Cluster Instances, log shipping and replication.

· Oracle: Data Guard, Active Data Guard, RAC.

· PostgreSQL: Physical streaming replication, logical replication, replication slots and automated failover.

Monitor replication health, lag and synchronization; investigate failures and inconsistencies; and execute controlled switchovers, failovers and failbacks.

Backup and Recovery

· Define backup schedules, retention policies and off-site backup arrangements.

· Configure full, differential, incremental, transaction-log and archive-log backups, as supported by each platform.

· Monitor backup completion and integrity.

· Test restoration and point-in-time recovery, and maintain recovery procedures and test evidence.





Data Centre and Disaster Recovery

· Maintain database architecture across primary DC and DR sites.

· Agree recovery point objectives (RPO) and recovery time objectives (RTO) with application and infrastructure teams.

· Prepare and validate DR runbooks covering failover, database validation, application reconnection and failback.

Performance Tuning

· Investigate slow queries, inefficient execution plans, indexing issues and configuration problems.

· Diagnose connection spikes, long-running transactions, locking, blocking and deadlocks.

· Coordinate query, indexing, statistics and partitioning improvements with development teams.

· Prepare database performance reports.

Required Technical Skills

· Production administration experience with at least two platforms: Microsoft SQL Server, Oracle Database or PostgreSQL.

· Working knowledge of Linux and Windows Server environments.

· Understanding of TCP/IP, DNS, firewalls and secure database connectivity.

· Basic scripting skills using SQL, PowerShell, Bash and PL/SQL, as applicable.

Mandatory Access Controls

1. Source IP whitelisting on database ports.
2. Least-privilege access, with read-only access by default for support personnel.

Pay: ₹500,000.00 - ₹700,000.00 per year

Benefits

- Versatile schedule
- Health insurance
- Internet reimbursement
- Paid sick time
- Paid time off
- Provident Fund

Work Location: In person

📌 Database Administrator — SQL Server, Oracle & PostgreSQL (Goregaon)
🏢 IDSSPL Technologies
📍 Goregaon

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: database administrator — sql server, oracle & postgresql (goregaon) / goregaon

Subscribe to this job alert:

Get the latest job offers by email for: database administrator — sql server, oracle & postgresql (goregaon) / goregaon