Wanted: Sybase Ase Database Admininstrator

Tata Consultancy Services; Lucas do Rio Verde; Presencial; BRL 180 000 - 240 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Health insurance

Life insurance

Total Pass

TCS Cares

SESC partnership

Certifications reimbursement

Learning portal access

International experience

University partnerships

Refer a friend bonus

Gems recognition

Xcelerate mentoring platform

Resumo da oferta

Tata Consultancy Services is seeking a Sybase ASE Database Administrator to join our enterprise IT team. You will administer SAP Adaptive Server Enterprise, manage replication, HA/DR setups, and optimize performance in large-scale production environments.

The role involves supporting development, QA, UAT, and production environments, implementing security controls, and driving automation with shell scripting to improve reliability and efficiency.

Qualificações

• Extensive experience administering Sybase ASE in large-scale production environments.
• Installation, configuration, patching, upgrades, migrations, and lifecycle management.
• Manage database devices, segments, logs, storage structures, users, roles, and permissions.
• Knowledge of ASE architecture, memory management, and capacity planning.
• Experience supporting development, QA, UAT, and production environments.
• Experience with Replication Server administration and monitoring.
• Familiarity with real-time data replication and heterogeneous data movement.
• Understanding of HA/DR, cross-site replication, and failover strategies.
• Proactive monitoring and performance tuning of OLTP workloads.
• Database security: authentication, RBAC, encryption, auditing, and SOX compliance.

Responsabilidades

• Coordinate with application, server, network and other teams during outages and change requests.
• Participate in 24x7 support and on-call rotations for production systems.
• Troubleshoot database incidents and perform root cause analysis.
• Maintain SOPs, runbooks, and operational documentation.
• Automate routine DBA tasks with shell scripting and automation tools.
• Ensure SOX compliance configurations and access control reviews.
• Stay current with required training and security practices.
• Support data replication and disaster recovery testing.

Conhecimentos

Sybase ASE

Replication

HA/DR

Performance Tuning

Security & Compliance

Monitoring & Troubleshooting

Automation & Scripting

Data Migration

SQL & Query Tuning

Capacity Planning

Ferramentas

Sybase ASE

Sybase Replication Server

SymmetricDS

Backup Server

VMware

Linux Shell

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