Write and Maintain Database Programs- Database engineers write new database programs and maintain existing programs to ensure they can handle the flow of traffic and the amount of data being stored in the database.
Design New Databases- Database engineers help design new databases based on company needs, data storage needs, and the number of users accessing the database.
Write Programs and Scripts- Database engineers write new support programs and scripts for databases to deploy, operate, increase data storage capacity, and fix existing database problems.
Review Database Reports- Database engineers review daily, weekly, and monthly database reports, including user reports and systems information, to spot problems and ensure that all databases and support systems are working at peak levels.
Requirements- Expertise in Installation, Upgrade & Patching of different components in SAP ASE/Sybase, Redis , Postgres and experience with the other platforms we manage listed in the Duties and Responsibilities.-
Experience with Replication including setup, troubleshooting issues and failovers-
Experience with Schema creation, deployment, and maintenance-
Carry out recovery of databases in an event of log full, system crash Troubleshoot issues related to the installation for our supported platforms-
Automation using shell-script, python, Ansible, go, etc.
Performance & Tuning Related Expertise- Experience with Performance analysis and monitoring of querie