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