Overview
SQL DBA Lead Jobs in New Jersey, United States at Net2Source (N2S)
Title: SQL DBA Lead
Company: Net2Source (N2S)
Location: New Jersey, United States
Title : SQL DBA Lead
Location : Remote
Experience: 12+ years
• Provides leadership for the DBA team, identifying work priorities and ensuring effective communication within the team and with external partners/stakeholders.
• Creates a healthy interpersonal and team-oriented environment.
• Should be customer service minded and develops and maintains cordial, effective partnerships with business area and other Services employee-partners.
• Ensures business area satisfaction with regular interaction and by managing expectations, understanding service level expectations and delivering solutions in a timely and cost-effective fashion.
• Supervises vendor performance and contractor resources and ensures they are performing competently and that client is receiving services aligned with contractual terms and conditions.
• Ensures that Cognizant's best practices are followed for the delivery, implementation and maintenance of client DBA by team members and contractors.
• Use critical thinking and project management discipline, tools and techniques in the day to day execution of responsibilities and in resource and workload planning.
• Ensure the timely correction of any bugs and vendor supplied patches and new releases related to DBA infrastructure .
• Develop a common understanding of service level expectations with the business areas and regularly review the business areas’ measures and impressions of service level delivery; work collaboratively to develop solutions to bridge the gap.
• Ensure appropriate resources are in place to meet delivery expectations. Ensure appropriate training, knowledge-transfer takes place to meet these expectations.
• Monitor, and provide effective supervision of, contractor/consultant service delivery and service billings to ensure they are accurate and that performance continues to align with statements of work.
• Collaborate and work effectively with other IS teams/resources in delivering required solutions. Communicate unambiguously and listen effectively, ensure organizational messages are delivered in a timely way to team members, that issues and concerns are addressed and foster open communication among team members.
• Clarify performance expectations and help team members achieve success through coaching, mentoring and providing effective and timely feedback, recognizing accomplishments and providing discipline when appropriate.
• Ensure team adherence to standard DBA practices/policies.
• Should have around 10 years of related experience, including management and operation of enterprise DBA services and DBA infrastructure
Technical Skillset required –
1. SQL DBA – Admin core task – must for all level a. checking health of sql server
a . checking sessions details
b . checking error logs
c. create logins & users and fix any issues
d . knowledge on databases, Objects and DMV
e Monitoring & fixing alerts
2. Database Backup & Restore – must for all level
3. SQL Job creation and fixing any failure – Must for all level
4. Database encryption – for L2/L3 level
5. SQL Server Patching – for L2/L3 level
6. SQL Server upgrade / Migration – for L2/L3 level
7.Understanding SQL Server performance – L2/L3 level a. checking Blocking issues
a . checking Deadlock issues
b. Query tunning
c. Index maintenance
8.Working knowledge on High Availability – L2/L3 level a. Log shipping
a. Mirroring
b. Always-on AG
9. working knowledge on SQL Server Replication – L2/L3 level
10. Linked server issues fixing SPN & Delegation – L2/L3 Level
11. MS Azure (Iaas) working knowledge is a plus
12. Understanding & writing T-SQL ,PowerShell scripts
13. Azure SQL
