Job Description

:We are seeking a highly skilled and experienced Database Administrator (DBA) with expertise in both Sybase and Cassandra database systems. The successful candidate will be responsible for the design, management, optimization, and security of database environments to ensure high availability, performance, and reliability. The role requires in-depth knowledge of relational (Sybase) and NoSQL (Cassandra) database technologies, including their architectures, configurations, and use cases.Key Responsibilities:Database Administration:

• Install, configure, and upgrade Sybase and Cassandra database environments.
• Manage database schemas, objects (e.g., tables, indexes, stored procedures), and clusters.
• Plan and execute database migrations and upgrades with minimal downtime.
• Monitor and analyze the performance of both Sybase and Cassandra databases.
• Optimize queries, indexes, and configurations for efficient data retrieval and processing.
• Conduct capacity planning to ensure databases meet performance and growth demands.
• Design and implement backup strategies for both Sybase and Cassandra databases.
• Develop and test disaster recovery plans and procedures.
• Configure and maintain replication and high-availability setups (e.g., Sybase Replication Server, Cassandra's replication strategies).
• Implement robust security controls including authentication, authorization, and encryption.
• Apply security patches and updates regularly to both Sybase and Cassandra systems.
• Ensure compliance with organizational and regulatory security standards.
• Diagnose and resolve database-related issues, including connectivity, performance, and data integrity.
• Provide on-call support for database incidents and outages.
• Collaborate with application and infrastructure teams to meet database requirements.
• Work closely with developers to design efficient schemas for Sybase (relational) and Cassandra (NoSQL).
• Provide guidance on best practices for data modeling, indexing, and query optimization.
• Review and optimize SQL and CQL (Cassandra Query Language) queries.
• Set up and maintain database monitoring tools for Sybase and Cassandra.
• Automate routine maintenance tasks using scripting languages (e.g., Bash, Python).
• Maintain comprehensive documentation of database configurations, processes, and maintenance activities.
• Generate regular reports on database health, performance, and usage metrics.

Qualifications and Skills:Required Skills:Sybase:

• Expertise in Sybase ASE (Adaptive Server Enterprise) and Sybase Replication Server.
• Strong knowledge of transaction management, indexing, and stored procedures.
• Familiarity with Sybase utilities (e.g., BCP, ISQL, DBCC).

Cassandra:

• Proficiency in Cassandra architecture, including partitioning, replication, and consistency levels.
• Experience with Cassandra tools like Nodetool, CQLSH, and DataStax OpsCenter.
• Understanding of Cassandra's data modeling and distributed nature.

Strong skills in query optimization, performance tuning, and troubleshooting.Experience with backup and recovery tools for both Sybase and Cassandra.Solid understanding of Linux/Unix systems and shell scripting.Preferred Skills:

• Experience with cloud database solutions (e.g., AWS, Azure, GCP) for Sybase and Cassandra.
• Knowledge of automation tools and DevOps practices (e.g., Ansible, Terraform).
• Exposure to Apache Kafka or similar messaging systems for data streaming.

Education and Experience:

• Bachelorxe2x80x99s degree in Computer Science, Information Technology, or a related field.
• 5+ years of experience as a Sybase DBA.
• 5+ years of experience as a Cassandra DBA.
• Relevant certifications (e.g., Sybase ASE Administrator, Apache Cassandra Certified Professional) are a plus.

Skills:

• Sybase
• Cassandra
• Ansible
• Terraform

Skills:Skills:

• Sybase
• Cassandra
• Ansible
• Terraform

About Company:UST is a global digital transformation solutions provider. For more than 20 years, UST has worked side by side with the worldxe2x80x99s best companies to make a real impact through transformation. Powered by technology, inspired by people and led by purpose, UST partners with their clients from design to operation. With deep domain expertise and a future-proof philosophy, UST embeds innovation and agility into their clientsxe2x80x99 organizations. With over 30,000 employees in 30 countries, UST builds for boundless impactxe2x80x94touching billions of lives in the process.

UST