Senior TechOps Engineer

3 - 5 years

6 - 10 Lacs

Posted:-1 days ago| Platform: Naukri logo

Apply

Work Mode

Work from Office

Job Type

Full Time

Job Description

Job Purpose
Database Administrator job consist of installation, database creation, performance monitoring, Data security, troubleshooting, Daily backup tracking, Database Migration & Upgrade, New environment creation, Database Compliance deployment, Issue trouble shooting, Performance/Impact analysis, Database alert tracking, incident tracking, Change Management tracking and data extractions for MIS Reporting/AnalysisDuties and Responsibilities
A-Minimum required Accountabilities for this role
  • Provide 24x7 support for mission critical production databases.
  • Excellent written and verbal communication
  • MS-SQL Database Installation/Configuration, monitoring, managing, and maintaining production databases.
  • MS-SQL database migration and upgrade/patching
  • New environment creation (on Azure and AWS)
  • Experience of DB Backup/Restoration and Disaster Recovery methods
  • Implementing replication solutions such as Always-on, setup monitoring tools, optimizing resources, etc.
  • Tracing of daily backups/incidents/database alerts/Governance & compliance/Support to DR drill/database growth etc
  • SQL query tuning hands-on experience
  • Data Governance, Data security and compliance.
  • Implementation various database automation techniques to reduce operational overhead.
  • Experience in installing, managing, monitoring 2014/2016/2017/2019, & 2022
  • Managing On-premises SQL Servers, and Azure Cloud VM services
  • Monitor the database health using monitoring tools.
  • Experience in SQL Server DB Creation, User creation and Permissions, Object creation etc.
    B-Additional Accountabilities pertaining to the role

  • Key Decisions / Dimensions
  • Only Critical servers are being monitored with existing team member

  • Major Challenges
  • No of Database servers to be monitored are increased up to 100+
  • No of compliance points are 65 to be maintained on all 100+ Servers.
  • No consistent support from Off-Role team
  • Maintaining 100% uptime on all database servers
  • Regular database patching and VA resolution MoM

  • Required Qualifications and Experience
    a)QualificationsMinimum qualification required is B.E./B.Tech/BSC-IT with minimum of 2.5+ Years of experience in MSSQL DBA
  • Work Experience
  • Should have good analytical and problem-solving skills.
  • Should have strong ownership.
  • Should have good communication skills.
  • RDBMS: Experience in MS SQL Server 2014/2016/2017/2019, & knowledge of Postgres is advantage
  • Operating Systems: Experience in Windows 2008 R2/2012/2016/2019 Server, & Linux RedHat, CentOS, Debian
  • Operating Systems: Experience in Windows 2008 R2/2012/2016/2019 Server, & Linux RedHat
  • Backup and Recovery: Experience of DB Backup and Disaster Recovery methods, with DR drill
  • HA/DR: Knowledge of HA\DR concepts.
  • Mock Interview

    Practice Video Interview with JobPe AI

    Start Job-Specific Interview
    cta

    Start Your Job Search Today

    Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

    Job Application AI Bot

    Job Application AI Bot

    Apply to 20+ Portals in one click

    Download Now

    Download the Mobile App

    Instantly access job listings, apply easily, and track applications.

    coding practice

    Enhance Your Skills

    Practice coding challenges to boost your skills

    Start Practicing Now
    Bajaj Finance logo
    Bajaj Finance

    Financial Services

    Pune

    RecommendedJobs for You