Primary Responsibilities :
- Installation, administration, upgradation and maintenance of multiple SQL Server instances.
- Setup environments for use within the end-to-end software delivery lifecycle.
- Define, design implement control procedures.
- Backup monitoring and continuous review of the backup strategy.
- Troubleshoot and resolve issues quickly.
- Performance monitoring and tuning.
- Query tuning (Index maintenance and management, housekeeping, memory, CPU, Disk I / O etc.) .
- Planning and execution of Service Pack upgrades.
- Work alongside project teams (analysts, developers, testers and implementation managers) during software release and patching.
- Track and report on regular tasks executed to ensure system availability maintaining a continuous improvement roadmap.
- Pro- actively identify productivity opportunities.
- Experience in a Windows based 24 / 7 environment including 1st / 2nd line support.
- Involved in the design and build of new systems, including high-availability and disaster recovery solutions. Excellent communication skills in both English written and verbal.
- Ability to write Stored Procedures, write complex SQL queries, and ability to analyze the SQL data is desired.
Couchbase JD :
Couchbase cluster Tuning and Configuration.Knowledge on Couchbase high availability and failover capabilities, to meet application requirement.Expertise on XDCR and High availability setup to meet application requirements.Expertise on Backup and Recovery solutions Monitoring of CB Cluster.Couchbase DB performance troubleshootingExpertise on sync-gateway administration including Configuration, Database Security Replication.Good Exposure on Linux Platforms OS level Basic Administrative tasks needed by DBA's.Ability to work effectively in a fast paced, high volume, deadline driven environment.Skills Required
Sql, Query Tuning, Excellent Communication Skills, Linux, Backup