Your browser does not support javascript! Please enable it, otherwise web will not work for you.

Principal Consultant SQL DBA @ Apptad

Home > DBA / Data warehousing

 Principal Consultant SQL DBA

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.
  • Job Classification

    Industry: Recruitment / Staffing
    Functional Area / Department: Engineering - Software & QA
    Role Category: DBA / Data warehousing
    Role: Database Administrator
    Employement Type: Full time

    Contact Details:

    Company: Apptad
    Location(s): Noida, Gurugram

    + View Contactajax loader


    Keyskills:   sql server sql ssrs log shipping ssis dts performance tuning database mirroring sql tuning microsoft azure database administration t-sql stored procedures sql dba backup and recovery powershell microsoft windows clustering etl mirroring sentry

     Fraud Alert to job seekers!

    ₹ Not Disclosed

    Similar positions

    Senior Oracle EBS Technical Application Support

    • CAI
    • 10 - 18 years
    • Bengaluru
    • 2 days ago
    ₹ 20-25 Lacs P.A.

    Postgres Database Administrator

    • CAI
    • 5 - 10 years
    • Bengaluru
    • 2 days ago
    ₹ 15-25 Lacs P.A.

    Qlik Developer

    • Exponentia Team
    • 2 - 8 years
    • Chennai
    • 2 days ago
    ₹ Not Disclosed

    Data Architect | 9 To 14 Years | PAN India

    • Capgemini
    • 6 - 10 years
    • Chennai
    • 3 days ago
    ₹ Not Disclosed

    Apptad

    .https://apptad.com/