MSSQL Database Admin- L1 - Noida, India - Outworks Solutions Private Ltd.

    Outworks Solutions Private Ltd.
    Outworks Solutions Private Ltd. Noida, India

    1 week ago

    Default job background
    Full time
    Description

    JD

    Microsoft SQL L1 deliverables:

    Account Bharti (Dish TV)

    Skill - MSSQL Database Admin L1

    Location Noida

    Verifying the SQL services on single and cluster server

    SQL core/base file path partition management

    SQL user defined database data and log file path partition management

    Database Backup path partition management

    Data file management

    Log file management

    Full Backups monitoring

    Differential Backups monitoring

    Log Backups monitoring

    Index Rebuild

    Update statistics monitoring

    DBCC CHECKDB or Consistency verification job monitoring

    Predefined critical application jobs monitoring

    Log shipping Jobs monitoring

    Replication Jobs monitoring

    Mirroring status jobs monitoring

    Lock and Deadlock

    Service pack/Patch updates on standalone server

    Database creation

    Addition of Data or Log file

    Addition Secondary file group/stream

    Database properties change

    Instance properties Change

    SP, View or any object creation with in the DB based on the request from application team

    Full Backup plan configuration using the Maintenance plan

    Backup plan configuration using the T-SQL statement

    Rebuild/ Re-organize index configuration using the Maintenance Plan

    Rebuild/Re-organize index configuration using the T-SQL statement

    Check DB and Update statistics configuration using the maintenance plan

    Check DB and Update statistics configuration using the T-SQL statement

    Housekeeping jobs configuration

    Differential backup configuration

    Log backups configuration

    Database backup using compression mode.

    Taking split backup

    Restore the split backup files.

    DBCC related jobs monitoring

    Create logins, users and also provide the appropriate privileges for the same.

    Shrinking of Data and log files

    Checking DB fragmentation level and re-org index

    Login Password reset

    DB Maintenance and I/O error reports

    Checking the lock and blocks on the instance.

    Taking manual backups based on the request

    Running jobs based on the request

    Database restoration based on the request for supported assets.

    Start up and shutdown of Database instances

    Data file and log file movement.

    Application Patch execution

    Incident and Request Fulfillment Management

    Vendor coordination