Job Description :

Title: Sr. Mem SQL DBA

Location: Remote position

Client: Verizon

Architect maximum availability cluster configuration and implement as feasible

Configure and administer data replication between clusters and generate reports to capture replication status

Deploy Rowstore, Columnstore and Hybrid architectures as required
Setup and manage cluster resources & pools, conduct performance analysis and fine tune

Discuss and implement best practices for partition management

Setup and optimize database backups using S3 or S3 like devices; Validate backups to ensure they can be used for recoverability

Migrate/Copy data across clusters or databases

Analyze query plans using Studio and/or command line interfaces and recommend query rewrite

Implement security best practices - least privileged access, data encryption, access monitoring/logging etc.

Analyze inter-node traffic

Troubleshoot issues for stability/availability/performance by opening service requests with database vendor support

Patch and upgrade database clusters

Generate operational playbook and review with the team

             

Similar Jobs you may be interested in ..