Sybase ASE Database Admininstrator

Tata Consultancy Services; Barueri; Presencial; BRL 150 000 - 260 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Health insurance

Life insurance

International experience opportunity

Reimbursement of Certifications

Free Learning Portal – Online courses

Bring Your Buddy – referral bonus

TCS Gems – recognition program

Resumo da oferta

Tata Consultancy Services seeks a Sybase ASE Database Administrator to manage ASE in large production environments, handle replication, and ensure HA/DR readiness. Responsibilities include performance tuning, security, monitoring, and automation of DBA tasks.

Candidate will support development, QA, UAT, and production environments, with a focus on data integrity and availability across distributed systems.

Qualificações

• Experience administering SAP Adaptive Server Enterprise (ASE) in large-scale environments.
• Knowledge of replication, HA/DR, performance tuning, and security controls.
• Experience with monitoring, automation, and scripting for DBA tasks.

Responsabilidades

• Coordinate outage and change activities across teams and vendors.
• Follow change management and release processes and participate in 24x7 support.
• Troubleshoot incidents and perform root cause analysis; maintain runbooks.
• Automate routine DBA tasks using shell scripting and AI where applicable.
• Ensure SOX compliance configurations and access reviews are up to date.

Conhecimentos

Sybase ASE

Replication

HA/DR

Performance tuning

Security & Compliance

Monitoring

Automation/Scripting

Ferramentas

Sybase Replication Server

Shell scripting

SQL Server replication

SymmetricDS

Descrição da oferta de emprego

Come to one of the biggest IT Services companies in the world! Here you can transform your career!

We are looking for a Sybase ASE Database Administrator who wants to learn and transform his career.

Requirements:

Sybase ASE Administration

• Administration of SAP Adaptive Server Enterprise (ASE) in large-scale production environments
• Installation, configuration, patching, upgrades, migrations, and lifecycle management
• Management of database devices, segments, logs, storage structures, users, roles, and permissions
• ASE architecture, transaction management, locking mechanisms, memory management, and capacity planning
• Support for development, QA, UAT, and production environments

Replication & Data Movement

• Sybase Replication Server administration and monitoring
• Sybase-to-Sybase and Sybase-to-SQL Server replication environments
• Real-time and near real-time data replication and synchronization
• Data migration, ETL support, and heterogeneous database integration
• Replication troubleshooting, performance tuning, and capacity planning
• SymmetricDS experience is a plus

High Availability & Disaster Recovery (HA/DR)

• Sybase ASE High Availability solutions and Cluster Edition environments
• Warm standby, failover, and disaster recovery administration
• RTO/RPO planning, testing, validation, and business continuity support
• Cross-site replication and geographically distributed database environments

Performance Tuning & Optimization

• ASE performance tuning and workload optimization
• Query tuning, execution plan analysis, and index optimization
• Statistics management, locking, blocking, and deadlock resolution
• Memory, cache, I/O, and tempdb optimization
• OLTP database performance analysis and capacity planning

Database Security & Compliance

• Authentication, authorization, access control, and RBAC administration
• Encryption, auditing, and security monitoring
• Vulnerability remediation and security patch management
• SOX compliance support and audit readiness

Monitoring & Troubleshooting

• Proactive monitoring, health checks, and incident management
• Availability, performance, and capacity monitoring
• Root cause analysis and issue resolution
• Enterprise monitoring tools and operational support

Backup, Recovery & Data Protection

• Backup and recovery strategy design and implementation
• Sybase Backup Server administration
• Full, differential, and transaction log backups
• Recovery testing, point-in-time recovery, and data retention management
• Business continuity and data protection initiatives

Automation & Scripting

• Shell scripting (Linux) and DBA process automation
• Automated monitoring, alerting, health checks, and reporting
• Environment provisioning, deployment automation, and job scheduling
• Development of reusable DBA utility scripts
• Database design reviews and schema optimization
• Stored procedures, triggers, views, and SQL performance reviews
• Application release support and change management
• Data modeling, normalization, and CI/CD database deployment support

Infrastructure & Operating Systems

• Storage, SAN, NAS, networking, and virtualization (VMware)
• OS performance analysis and infrastructure troubleshooting
• Exposure to cloud platforms (OCI, AWS, Azure, or GCP)
• Experience working in enterprise ITIL environments

Key Responsibilities:

• Coordinate with application, server, network and other teams during outages and scheduled change request work;
• Follow change management and release processes;
• Participate in 24x7 support and on-call rotations for critical production systems;
• Troubleshoot database incidents and perform root cause analysis;
• Work with vendors and internal teams to resolve complex issues;
• Maintain SOPs, runbooks, and operational documentation;
• Automate routine DBA tasks using shell scripting and AI where applicable;
• Perform proactive monitoring for events and alerts;
• Manage all SOX compliance configurations, access control reviews, reporting, and compliance task completion;
• Stay current on all required internal company training;
• Safeguard digital assets by consistently practicing and promoting safe cyber awareness.

What do we offer?

• Health insurance
• Life insurance
• Total Pass
• TCS Cares – free 0800 that provides psychological assistance (24 hrs/day), legal, social and financial assistance to associates
• Partnership with SESC
• Reimbursement of Certifications
• Free TCS Learning Portal – Online courses and live training
• International experience opportunity
• Discount Partnership with Universities and Language Schools
• Bring Your Buddy – By referring people you become eligible to receive a bonus for each hire
• TCS Gems – Recognition for performance
• Xcelerate – Free Mentoring Career Platform