Job Description

Key Responsibilities

Database Administration & Maintenance

• Install, configure, tune, and upgrade SAP ASE (Sybase), Redis, and PostgreSQL databases.
• Ensure high availability, backup, and disaster recovery of all database systems.
• Monitor database health, including performance tuning, space management, and security enforcement.
• Proactively recommend system improvements to optimize database performance and scalability.
• Troubleshoot and resolve replication, failover, and performance issues across platforms.

Database Development & Optimization

• Write, deploy, and maintain SQL patches, database programs, and automation scripts.
• Perform performance analysis and monitoring of queries, indexing, and storage usage.
• Ensure database integrity, data cleansing, and implementation of access controls.

Automation & Scripting

• Develop and maintain automation tools using Shell, Python, Ansible, or Go for database deployments and maintenance.
• Automate database monitoring, backup, and recovery processes to enhance efficiency.

Security & Compliance

• Set up and configure auditing and audit trails to ensure compliance with security policies.
• Implement and maintain disaster recovery solutions, ensuring seamless data recovery.
• Monitor system logs, trace files, and user activity for security risks and potential failures.

Required Skills & Experience

• Expertise in SAP ASE (Sybase), Redis, and PostgreSQL database administration.
• Strong experience with installation, upgrades, patching, and troubleshooting across database platforms.
• Hands-on experience with database replication, failovers, and high-availability configurations.
• Linux proficiency (mandatory) – experience managing databases in Linux environments.
• Knowledge of schema creation, deployment, and maintenance.
• Experience with performance tuning and query optimization.
• Strong scripting skills in Shell, Python, Ansible, or Go to automate database tasks.
• Experience with backup, recovery, and disaster recovery planning.

Preferred Qualifications

• Experience working with large-scale enterprise database environments.
• Strong analytical mindset with a detail-oriented approach to problem-solving.
• Ability to work independently in a fast-paced, high-demand environment.

Job Tags

Similar Jobs