Wanted: Sybase Ase Database Admininstrator

Tata Consultancy Services; Ribeirão Pires; Presencial; BRL 120 000 - 170 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Health coverage

Life insurance

Professional certification support

Learning portal access

Global projects exposure

Resumo da oferta

Tata Consultancy Services is seeking an experienced Sybase ASE DBA to manage large-scale SAP ASE environments on-site in Brazil. The role covers installation, configuration, patching, migrations, and lifecycle management, with emphasis on replication, data movement, and real-time synchronization.

Responsibilities include HA/DR planning, performance tuning, security, and 24x7 production support. The candidate will automate DBA tasks, maintain runbooks, and ensure compliance across environments.

Qualificações

• Experience administering SAP Adaptive Server Enterprise in large-scale environments.
• Knowledge of replication, data movement, and real-time synchronization.
• Proficiency in HA/DR planning, failover testing, and RTO/RPO.
• Strong performance tuning: queries, indexes, statistics, and memory management.
• Experience with database security, access controls, and SOX compliance.
• Proactive monitoring, incident management, and root-cause analysis.

Responsabilidades

• Coordinate outages and change requests with cross-functional teams.
• Participate in 24x7 support and on-call rotations.
• Troubleshoot incidents and perform RCA.
• Automate routine tasks with shell scripting; develop DBA utilities.
• Maintain SOPs, runbooks, and operational docs.
• Ensure SOX configurations and access reviews are up to date.

Conhecimentos

Sybase ASE

Replication Server

HA/DR

Performance tuning

Security RBAC

Monitoring

Backup & Recovery

Scripting

OS & Infra

Formação académica

Ferramentas

Sybase ASE

Sybase Replication Server

SymmetricDS

Shell scripting

Descrição da oferta de emprego

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

This is an on-site position supporting mission-critical infrastructure at premier data center facilities.Project-based or ongoing support.Remote hands and smart hands services.Perform hardware inst... Mostre mais

Clients need a single point of contact who actually understands hardware, not just a relationship manager who has to relay every technical question.Projects span hardware deployment, structured cab... Mostre mais