Home
Jobs

Principal Consultant SQL DBA

7 - 10 years

12 - 17 Lacs

Posted:6 days ago| Platform: Naukri logo

Apply

Work Mode

Work from Office

Job Type

Full Time

Job Description

We are looking for a skilled Senior SQL DBA with 7 to 10 years of experience to join our team. The ideal candidate will have excellent problem-solving and analytical skills, strong communication and collaboration abilities, and the ability to work independently and as part of a team.
Roles and Responsibility
  • Diagnose and resolve issues related to database performance, capacity, replication, T-SQL, and other technical problems.
  • Proactively monitor databases for errors and respond quickly to troubleshoot and resolve ongoing issues on all CAI environments (DEV/QA/PROD).
  • Maintain and coordinate systems On-Prem or in AWS/Azure.
  • Schedule DB downtimes for maintenance procedures such as patching and upgrades.
  • Define backup and recovery strategies using technologies like NetApp Snapshots, SnapCenter/Snap Manager for SQL, Idera SQLSafe, or Native SQL Server Backup/recovery Tools.
  • Perform advanced database administration activities including performance tuning, T-SQL tuning, backup and recovery, and disaster recovery solutions.
  • Create and update CAI's database documentation about standard procedures, DB technology features, or production issue troubleshooting.
  • Stay current with changes in the technical area of expertise and support highly available production systems using technologies like Database Mirroring, Log Shipping, Windows/SQL clustering, and Availability Groups.
  • Work with development teams to deploy code in production when needed and participate in on-call rotations.
  • Job
  • Bachelor's degree or equivalent work experience in Microsoft Windows/SQL Server Technologies and .Net development.
  • Hands-on experience in Microsoft Windows/SQL Server Technologies and .Net development.
  • Experience working in 24x7 environments oriented towards a zero-downtime target.
  • Working knowledge or previous administration of SQL 2016-SQL 2022 and Windows Server 2019+.
  • Experience with ETL, DTS, T-SQL, and SSRS, SSIS.
  • Ability to work with minimal direction in a team environment.
  • Performance tuning for SQL server, queries, stored procedures, views, etc.
  • Hands-on experience with configuring and administering Log Shipping and SQL Availability Groups.
  • Experience with SQL in virtual, physical, and cloud-based environments.
  • Proven ability to quickly learn and implement new technologies.
  • Experience with Sentry One is a plus.
  • Ability to code PowerShell commands.
  • Mock Interview

    Practice Video Interview with JobPe AI

    Start Job-Specific Interview
    cta

    Start Your Job Search Today

    Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

    Job Application AI Bot

    Job Application AI Bot

    Apply to 20+ Portals in one click

    Download Now

    Download the Mobile App

    Instantly access job listings, apply easily, and track applications.

    coding practice

    Enhance Your Skills

    Practice coding challenges to boost your skills

    Start Practicing Now
    Apptad
    Apptad

    IT Services and IT Consulting

    Alpharetta Georgia

    RecommendedJobs for You