Sybase Database Admin

Location: Pune, Hyderabad   •   Experience: Mid Level   •   Openings: 2
Apply on Gojobs

Job description

Job Title :  Sybase Database Admin / Postgres SQL DBA
 
Location : Pune / Hyderabad
 
Candidate Specification: 
 
Any Graduate , 7+ years of Experience
 
Job Description :
 
Design, implement, and maintain Sybase ASE & Sybase IQ database instances, including installation, configuration, upgrades, and patching across Linux/Unix platforms.
 
Perform Sybase & IQ database performance tuning, query optimization, index management, and capacity planning to ensure optimal throughput and minimal downtime.
 
Perform routine Sybase database maintenance activities like housekeeping, reorgs, DBCC checks, index maintenance, statistics updates, and space management.
 
Manage Sybase & IQ database privileges and security configurations to enforce security best practices, including user/role management, database encryption and auditing.
 
Hands-on experience in backup & recovery. Should implement restore strategies using dump/load, replication, or backup server.
 
Maintain large-scale IQ databases with terabyte-level storage and ensure optimal bulk loading performance using BCP, IQ load utilities, or ETL tools.
 
Configure and support high-availability solutions such as Sybase Replication Server, Warm Standby, MSA, Failover Clustering, and disaster recovery strategies.
 
Automate database administrative tasks using Shell/Perl/Python scripts.
 
Good understanding of PostgreSQL – Architecture, security, operational knowledge
 
Deep understanding of how PostgreSQL manages data, including tablespaces, data files, indexes, WAL (Write-Ahead Logging), and key processes like Postmaster and bgwriter
 
Proficiency in installing, configuring, and upgrading PostgreSQL instances.
 
Expertise in identifying and resolving performance bottlenecks, including SQL query optimization, index tuning, and server parameter adjustments.
 
Good to have expertise in automating routine DBA task like log management, backups, schema migration, indexing and monitoring.
 
Strong knowledge of various backup strategies (e.g., pg_basebackup, WAL archiving) and recovery procedures to ensure data integrity and availability.
 
Experience in Applying Patches and troubleshooting patch failure issues.
 
Strong work experience in UnixLinux Operating system and Shell Scripting