- Expertise in Installation, Upgrade & Patching of different components in Sybase,MS SQL Server,Postgres and experience with the other platforms we manage listed in the Duties and Responsibilities.
- Experience with Replication including setup, troubleshooting issues and failovers
- Monitor all systems (work processes, users, system logs, short dumps, locks, developer traces, system traces, disk space, etc.).
- Ensure production uptime service levels are maintained and made available per requirements that include backup, recovery, refresh, performance tuning, and security
- Provide data cleansing services, verify data integrity, and implement access controls
- Provide routine maintenance including problem defect analysis and resolution, space, storage, object management, physical database layout, rollback segment management, and temporary space management
- Experience with Schema creation, deployment and maintenance
- Experience with Setting up and configuration of Auditing, audit trails
- Carry out recovery of databases in an event of log full, system crash Troubleshoot issues related to the installation for our supported platforms
- Should have knowledge of Disaster Recovery setup and maintenance
- Automation using shell-script, python,Ansible, go, etc. Performance & Tuning Related Expertise
- Experience with Performance analysis, monitoring of SQL queries and platform specific tuning.
