10 Aug
|
data intensity
|
Hyderabad
10 Aug
data intensity
Hyderabad
Job Title: Senior Sybase Database Administrator (DBA)
- Experience:
Require a minimum of 10+ years of dedicated, relevant experience in Sybase Database Administration. Must possess a strong, authoritative command over both enterprise Linux (RHEL/OEL) and Windows Server environments, actively managing database hosting layers, file system structures, and platform-specific performance variables across both operating systems.
- Backup &
- Recovery:
Design, implement, and validate robust database backup, restoration, and disaster recovery processes, ensuring strict alignment with corporate RPO and RTO metrics across physical SAN and cloud-attached storage tiers.
- Capacity &
- Storage Planning:
Handle long-term capacity planning, database device allocations, segment management, and growth forecasting to ensure optimal space management for Very Large Databases (VLDBs).
- Health Monitoring:
Monitor system health and capacity proactively, designing advanced instrumentation using system tables, sp_sysmon, and native diagnostic utilities alongside third-party enterprise monitoring tools.
- Incident Management &
- Corruption Recovery:
Troubleshoot and resolve complex production issues, severe engine locks, spinlock contentions, network log blockages, and lead emergency recovery operations for database page corruption using advanced dbcc utilities.
- Security &
- Compliance:
Implement and enforce rigorous enterprise database security, authentication, role-based access control, encryption standards, and strict auditing protocols to satisfy regulatory and corporate compliance audits.
- User Management &
- Security Hardening
- Performance Tuning:
Perform expert-level engine and database performance tuning,
utilizing deep knowledge of Sybase internals (sp_configure), engine-to-CPU affinity, named data caches, table locking schemes (APL vs. DOL), and complex query plan optimization.
- High Availability &
- Replication Engineering:
Structure, configure, and maintain robust high availability and real-time data distribution networks, troubleshooting complex Sybase Replication Server topologies (warm standby, MSA, secure queue management), failover clusterings, and automated failover setups.
- Migrations &
- Upgrades:
Plan, architect, and execute seamless Sybase ASE/IQ database version migrations, cross-platform upgrades, lifecycle management, and Emergency Bug Fix (EBF) patching with minimal business downtime.
- Automation Engineering:
Develop and maintain unified automation frameworks for routine administrative tasks, automated database consistency checks (dbcc), and automated alerting using UNIX/Linux Shell scripting (Bash/Ksh) or Perl.
- Platform &
- Infrastructure Management:
Manage, configure, and tune Sybase Adaptive Server Enterprise (ASE) and Sybase IQ architectures across physical and virtual enterprise Unix/Linux environments.
- Production Operations:
Provide expert L2/L3 production operational support, leading critical Root Cause Analysis (RCA) investigations, implementing preventive actions, and participating in high-priority on-call frameworks.
- PostgreSQL Administration &
- Migration (Add-on):
Provide secondary operational overview, maintenance support, or target-schema and code mapping compatibility assessments for cloud migration initiatives moving legacy Sybase workloads to PostgreSQL / AWS RDS / Azure PostgreSQL environments.
📌 Senior Sybase DBA (Hyderabad)
🏢 data intensity
📍 Hyderabad