Description
Leveraged DBA team supporting 24 *7 for Oracle, MSSQL , DB2, Informix & Sybase. Multiple teams will request for the installation and configuration of the Database and other DBA related activities. DBA to receive the request and process it and complete it as defined.
Responsibilities

    India ANL Microsoft SQL Server Analytic Platform System
    Experience of 24 *7 project support
    o Minimum 10+ Year of SDBA experience (System DBA)
    o Leading the team of 20 members team
    o Experience of 24 *7 project support
    o Installation, Administration and Maintenance of SQL Server Instances
    o Provide Support for multiple versions of SQL server from SQL 2000 to SQL 2016
    o Create Users and assign permissions based on the level of database access the user would need
    o Design database backup and restore strategy
    o Setup High-Availability as part of Disaster Recovery Strategy for the Databases
    o Troubleshoot various problems that arise in the day-to-day operations and fix the issues
    o Monitoring and Performance Tuning; Physical Server Level, Database level (Database settings and options) and query tuning to include index optimizations
    o Failover clustering, SAN replication, and other high availability technologies
    o Database growth vs disk space available, audits, resource monitoring (I/O bottlenecks, memory pressure, CPU use)
    o Manage Maintenance Plans
    o Monitor backups to ensure they are being performed regularly
    o Exposure to AWS Cloud
    o Experience of 24 *7 project support

Skills
Must have

    SQL Server Analysis Services, ETL, SQL Server Reporting Services, SQL Server Integration Services

Nice to have

    Any application with SLA definition and Ticket Processing Tools
    Team Handling experience

Languages
English: B2 Upper Intermediate
Seniority
Regular


Source link