Senior Sql Database Administrator

3 weeks ago

Bengaluru, India LTIMindtree Full time

Role: Senior Sql Database Administrator

Experience: - 5-9


  • Excellent Hands-on experience Installing, configuring, managing, monitoring and troubleshooting SQL 2005 – SQL 2022
  • Installing Service Packs, Cumulative Updates, Hotfixes (GDR, QFE).
  • Patching hierarchy and clarity on SQL Build numbers and Internal Database build numbers.
  • Upgrading/Migrating SQL Server from older (from SQL 2005) to newer (till SQL 2022)
  • Configuring Linked Servers between same/different SQL Server versions.
  • Setting up contained databases and utilizing them for effective migrations
  • Configuring recovery models and designing backup strategies.
  • Fine tuning backups by using Backup Encryption, Compression and special parameters (like MAXTRANSFERSIZE, BUFFERCOUNT, BLOCKSIZE & CHECKSUM).
  • Handling Master, Model, MSDB, TEMPDB and Resource database corruptions.
  • Configuring HADR like Log Shipping, Mirroring, Clustering, Always-On AG & Replication
  • Hands on knowledge on Windows Cluster, Quorum, Dynamic Quorum, Voting Mechanism, Failovers through Cluster Administrator and commands.
  • Hands on knowledge on SQL Server Cluster scenarios Failover, Adding Disk to existing instance with dependencies, Advanced Cluster Parameters like Failure Condition Level, Health check timeouts, patching clustered instances (SQL 2005 till 2022
  • Configuring Always-On AG on standalone instances across Windows Cluster in Synchronous mode and Asynchronous mode.
  • Handling advanced Always-On AG scenarios like Failover, adding new data/log files, understanding of Lease Timeout, Health check timeout and Failure Condition Level parameters, configuring Read-Only Routing, listeners and backup configurations.

Mandatory Leaf Skills to Hire

  • Strong knowledge on SQL Server Architecture, parameters, T-SQL, Triggers and Procedures
  • Administration and configuration HA/ DR solutions – Clustering, Always-ON Group etc
  • Configuring and manage all types of Replications and troubleshooting
  • Patch management
  • Always On AG scenarios – Failover
  • Server capacity monitoring, analysis and tuning activities
  • Automation using scripts and tools in the area of Backup, Monitoring, Resource Utilization, HA alerts, capacity plan management
  • SQL Server Tuning

  • Senior Sql Database Administrator

    3 weeks ago

    Bengaluru, India LTIMindtree Full time

    Role: Senior Sql Database Administrator Experience: - 5-9 - Excellent Hands-on experience Installing, configuring, managing, monitoring and troubleshooting SQL 2005 – SQL 2022 - Installing Service Packs, Cumulative Updates, Hotfixes (GDR, QFE). - Patching hierarchy and clarity on SQL Build numbers and Internal Database build numbers. -...

  • Senior Sql Database Administrator

    5 hours ago

    Bengaluru, India LTIMindtree Full time

    Role: Senior Sql Database Administrator Experience: - 5-9Excellent Hands-on experience Installing, configuring, managing, monitoring and troubleshooting SQL 2005 – SQL 2022Installing Service Packs, Cumulative Updates, Hotfixes (GDR, QFE).Patching hierarchy and clarity on SQL Build numbers and Internal Database build numbers.Upgrading/Migrating SQL Server...

  • Senior Sql Database Administrator

    2 weeks ago

    Bengaluru, India LTIMindtree Full time

    Role: Senior Sql Database AdministratorExperience: - 5-9- Excellent Hands-on experience Installing, configuring, managing, monitoring and troubleshooting SQL 2005 – SQL 2022- Installing Service Packs, Cumulative Updates, Hotfixes (GDR, QFE).- Patching hierarchy and clarity on SQL Build numbers and Internal Database build numbers.- Upgrading/Migrating SQL...

  • Senior Sql Database Administrator

    1 week ago

    Bengaluru, India LTIMindtree Full time

    Role: Senior Sql Database AdministratorExperience: - 5-9Excellent Hands-on experience Installing, configuring, managing, monitoring and troubleshooting SQL 2005 – SQL 2022Installing Service Packs, Cumulative Updates, Hotfixes (GDR, QFE).Patching hierarchy and clarity on SQL Build numbers and Internal Database build numbers.Upgrading/Migrating SQL Server...

  • Senior Sql Database Administrator

    2 weeks ago

    Bengaluru, India LTIMindtree Full time

    Role: Senior Sql Database AdministratorExperience: - 5-9- Excellent Hands-on experience Installing, configuring, managing, monitoring and troubleshooting SQL 2005 – SQL 2022- Installing Service Packs, Cumulative Updates, Hotfixes (GDR, QFE).- Patching hierarchy and clarity on SQL Build numbers and Internal Database build numbers.- Upgrading/Migrating SQL...

  • Senior Sql Database Administrator

    3 weeks ago

    Bengaluru, Karnataka, India LTIMindtree Full time

    Role: Senior Sql Database Administrator Experience: - 5-9 Excellent Hands-on experience Installing, configuring, managing, monitoring and troubleshooting SQL 2005 – SQL 2022 Installing Service Packs, Cumulative Updates, Hotfixes (GDR, QFE). Patching hierarchy and clarity on SQL Build numbers and Internal Database build numbers. Upgrading/Migrating SQL...

  • Senior Sql Database Administrator

    5 days ago

    Bengaluru, India LTIMindtree Full time

    Role: Senior Sql Database Administrator Experience: - 5-9 Excellent Hands-on experience Installing, configuring, managing, monitoring and troubleshooting SQL 2005 – SQL 2022 Installing Service Packs, Cumulative Updates, Hotfixes (GDR, QFE). Patching hierarchy and clarity on SQL Build numbers and Internal Database build numbers. Upgrading/Migrating SQL...

  • Senior Sql Database Administrator

    6 days ago

    Bengaluru, India LTIMindtree Full time

    Role: Senior Sql Database Administrator Experience: - 5-9 Excellent Hands-on experience Installing, configuring, managing, monitoring and troubleshooting SQL 2005 – SQL 2022 Installing Service Packs, Cumulative Updates, Hotfixes (GDR, QFE). Patching hierarchy and clarity on SQL Build numbers and Internal Database build numbers. Upgrading/Migrating SQL...

  • SQL Database Administrator

    3 weeks ago

    Bengaluru, India Datacore Technologies Full time

    Role: Database Administrator Job Location: Bangalore Job Type: Contract Job Description: · 5 years previous experience in a complex corporate IT infrastructure role is essential. · 5 years previous experience in a Senior Database Administrator role is essential. · 2 years previous experience of supporting failover clustering, SAN replication,...

  • SQL Database Administrator

    2 weeks ago

    Bengaluru, India Datacore Technologies Full time

    Role: Database AdministratorJob Location: BangaloreJob Type: ContractJob Description:· 5 years previous experience in a complex corporate IT infrastructure role is essential.· 5 years previous experience in a Senior Database Administrator role is essential.· 2 years previous experience of supporting failover clustering, SAN replication, Database...