SQL Database Administrator - Bengaluru, India - Intertrust Group

    Intertrust Group
    Intertrust Group Bengaluru, India

    3 weeks ago

    Default job background
    Description

    Job Title: SQL Server DBA

    Location: Bangalore

    Work Schedule: 12-9 PM

    Hybrid

    *ONLY CANDIDATES WITH NOTICE PERIOD OF 30 DAYS-45 DAYS WILL BE CONSIDERED. *

    Intro:

    The SQL Server DBA will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our corporate applications. This is a "hands-on" position requiring solid technical skills, as well as excellent interpersonal and communication skills.

    The successful candidate will be responsible for the development and sustainment of the SQL Server Warehouse, ensuring its operational readiness (security, health and performance), executing data loads, and performing data modeling in support of multiple development teams. The data warehouse supports an enterprise application suite of program management tools. Must be capable of working independently and collaboratively.

    Some of the things you'll be doing:

    • Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
    • Install and configure new Microsoft SQL Server instances, including AlwaysOn availability groups and failover clustering.
    • Review, analyse, and evaluate business systems and user needs by facilitating brainstorming sessions.
    • Highly skilled at database design, installations, conversions Responsible for database backup and recovery procedures, access security and database integrity, physical data storage design and data storage management.
    • Participates in Database Management System selection and maintains database performance.
    • Engage in ongoing process improvement.
    • Experienced in Database Performance, Maintenance and Development to perform the following:
    • Database management including backups, recovery and maintenance Database management for export, import and mass data loads.
    • Analyses and generation of all tables and index statistics Monitoring and resolving data lock issues.
    • Check all statistics related to memory, locks, I/O, database response time, wait events, top sessions and background processes.
    • On-Line Transaction Processing (OLTP) to capture, validate and store large amounts of transactions.
    • Create indexes to achieve critical dataset response time for time sensitive reports. Install SQL Server service packs and updates.
    • Configure and manage SQL Security settings.
    • Make system design recommendations according to Microsoft SQL Server best practices.
    • Manage database backup & recovery & DR planning in collaboration with IT manager and System Engineer.
    • Create, modify, and optimize SQL Server Agent jobs and maintenance plans.
    • Proactively monitor SQL Server maintenance tasks, troubleshoot failed jobs and resolve issues in a timely manner.
    • Troubleshoot application slowness and performance issues.
    • Responsible for T-SQL query tuning Responsible for database migrations and server upgrades.
    • Develop documentation and training of routine database administration tasks and train server operations staff on these tasks.
    • Responsible for ETL of large data into SQL Server Author and modify SQL Server Reporting Services reports.
    • Perform SQL Server integration with enterprise applications.
    • T-SQL Programming Perform additional tasks as assigned.
    • Provide 24x7 support for critical production systems.

    What technical skills, experience, and qualifications do you need?

    • 7+ years MS SQL Server Administration experience required
    • Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
    • Experience with backups, restores and recovery models
    • Experience of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
    • Experience working with Windows server, including Active Directory
    • Excellent written and verbal communication
    • Flexible, team player, "get-it-done" personality
    • Ability to organize and plan work independently
    • Ability to work in a rapidly changing environment
    • Ability to multi-task and context-switch effectively between different activities and teams