Senior SQL Server DBA / Lead

SQL Cluster , Database Mirroring , Security, SQL Server Architecture and internals , SQL Server 2016, SQL 2012, MYSQL, Progress, Hadoop , Database design
Contract W2, C2H W2
Market
Work from home not available Travel not required

Job Description

Hi All, 

We have an immediate opportunity for the position of Senior DBA Lead in Oakland , CA with one of our Direct Customer. Please find below the detailed description and send me your updated resume ASAP.

Job Title : Senior DBA / Lead

Location : Oakland, CA

Duration : Contract to Hire

Job Description : 

Responsible for architect, design, implement, and management of SQL Servers in multiple environments using:

▪ High Availability using SQL Cluster and Always On Availability

▪ Identify the best practices to implement and manage SQL Instances

Manage and maintain SQL instances:

▪ Participate and resolve any SQL server performance issues that were reported

Responsible for day to day operations that includes trouble shooting for:

  • System Performance o Manage and monitor SQL instances using tools such as, Idera / Redgate / SCOM etc.
  • Manage maintenance jobs

Lead DBA team

▪ Manage Projects

▪ Job/Task Allocation

Mentoring, Training 

 Coordination with

Infrastructure Team and application teams - Conducting POC

 ▪ SQL Features ▪ Product evaluation - Create/Participate to systems documentation

 ▪ Design, Architecture, Runbooks etc.

Create Management report

▪ Weekly Status

▪ Operational metrics

▪ Security Audit - Ensure that the company information security policies are enforced

Skills Required Mandatory

  • Excellent Communication Skills (written & spoken)
  • Experience in troubleshooting to identify the RCA and resolving performance related issues

Experience in implementing High Availability using:

▪ SQL Cluster

▪ Always-ON availability database groups using Sync and Async replication

▪ Database Mirroring

Experience on handling very large databases and tables (> n TB)

Experience in using the best practices in:

▪ SQL server installation and configuration

Security

 o SQL Hardening

o Low level data access

o Encryption

o Auditlog

Database maintenance

Backup & Restore

 Maintenance jobs 

  • Knowledge of SQL Server Architecture and internals 
  • Hands-on experience in SQL Server 2016, SQL 2012 
  • Experience in installing and configuring Large Database using best practices 
  • Experience in using monitoring tools and manage tickets

Example: o Idera o ServiceNow.

Additional Skills :

MYSQL, Progress, Hadoop - Database design - Microsoft Certification - Windows Server o/s - SAN / SSD/ NVME SSD / NVDIMM

 

Thanks & Regards

Gobinath K

Senior Global Talent Acquistion

Encore IT Services Solutions Pvt. Ltd.,

Unit of Encore Software Services, USA,

Phone : 408-597-4353

Email Id – gkrishnamoorthy@encoress.com

Website - www.encoress.com

Posted By

Gopinath Krishnamoorthy

HTC Towers 4th Floor No 41, GST Road Guindy

Contact
Dice Id : 10115152
Position Id : 621596
Have a Job? Post it