What are the responsibilities and job description for the SQL DBA position at Cortex consultants LLC?
Title : MS SQL DBA
Exp : 12 Yrs
Location : Onsite (Farmington, CT) and King of Prussia PA
Job Description :
Required version 2012,2014,2016 ,2017 and 2019
OS Windows server 2012, 2016,2019
On-Prem, Azure IaaS, Azure PaaS experience
installation, configuration, and maintenance of MS SQL Server instances.
DB Upgrades & Patching
Monitor database performance and take proactive steps to optimize performance.
Implement and manage database backup and recovery strategies.
Ensure high availability and disaster recovery solutions are effectively implemented.
Configure and maintain database servers and processes
Monitor system's health and performance
Ensure high levels of performance, availability, sustainability and security
HA, Replication, Clustering and Mirroring
Analyze, solve, and correct issues in real time
Provide suggestions for solutions
Refine and automate regular processes, track issues, and document changes
Assist developers with query tuning and schema refinement
Provide 24x7 support for critical production systems
Perform scheduled maintenance and support release deployment activities after hours
Work on issues that couldn't be resolved by L2 team.
Manage L2 and L1 teams
Roles and Responsibilities :
Responsible for physical database architecture and design,capacity planning, development, performance tuning, implementation, and support of the applications from a database perspective.
Conduct SQL Code Reviews to ensure coding standards, best practices and avoid potential performance issues.
Attend CAB ( Change Advisory Board) meeting and get proper approvals from product owners to implement DB changes.
Document operational or newly engineered solutions properly to educate and inform the clients and DBAs from the various levels of the organization.
Work on Writing custom stored procedures, sql queries , powershell scripts , Linux Shell Scripts,views, and triggers based on requiremens for DB maintenance and automate tasks.
Work on writing technical and RCA(Root Cause Analysis) documentation.
Join bridge calls to troubleshoot and fix P1(SEV1) and P2 (SEV2) incidents.
work on performance tuning like provide suggestions to crete indexes and tune stored procedures and deadlocks
Keep a pulse on the job market with advanced job matching technology.
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution.
Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right.
Surveys & Data Sets
What is the career path for a SQL DBA?
Sign up to receive alerts about other jobs on the SQL DBA career path by checking the boxes next to the positions that interest you.
