Administrator - IMS - MSSQL Database Infratstructu-L2.1
Wipro Limited
Pune
6d ago
source : Shine

Experience in installation of different version of SQL SERVER (2016, 2014, 2012, 2008R2 / 2008) in both OLTP and OLAP lower regions and Production environments.

  • Played a major role in database maintenance, Security, upgrading and Performance Tuning. Implemented High Availability &
  • Disaster Recovery techniques like Always on Availability Groups, Clustering (Both Active-Active and Active-Passive) Database Mirroring, Transactional Replication and Log Shipping.

    Upgraded and Migrated of SQL Server databases from SQL Server 2000 / 2005 / 2008 / 2008R2 / 2012 to SQL Server 2014 / 2016.

    Daily routine DBA tasks like handling user s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.

    Hands on experience in working with MSSQL SERVER 2005, 2008, 2008R2, 2012, 2014 features and extensive knowledge on SQL 2016 new features.

    Exquisite skills in SSMS-Creating and scheduling jobs, alerts and operators with SQL Server Agent, handling Backup / Recovery of databases, Replication, Linked Servers, and databases Maintenance, Database Mails Experience in Performance Tuning, Index Tuning, Maintenance, Troubleshooting, Query Optimization, Client / Server connectivity and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.

    Monitoring the different server including backup, disk space, Job failures, connectivity, and performances. Hands-on experience in resolving locks deadlocks, handling Isolation levels and performance issues like CPU, I / O, Memory bottlenecks.

    Working knowledge in Integration Services (SSIS), Reporting Services (SSRS) and Clustering. Experience in using DMV and dynamic management function for finding out long running Queries.

    Adept at proving database troubleshooting issues like Locking, Blocking and Deadlocking, fail over maintenance and database recovery.

    Extensively used tools like SQL Profiler, Index Tuning Wizard, and Database Engine Tuning Advisor, Windows Performance Monitor for monitoring and tuning MS SQL Server performance.

    Experience in creating Jobs, Alerts, and schedule DTS / SSIS Packages. Identifying waits and bottlenecks at the database and OS level.

    Strong analytical abilities and strong communication skills 3 to 4+ years of experience as SQL server DBA Knowledge of ITIL framework

    Mandatory Skills : MS SQL Admin

    Desirable Skills : Cloud-SQL Azure

    Language Skills : English Language

    Apply
    Add to favorites
    Remove from favorites
    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form