Posted:1 week ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

Role Summary

The DBA is responsible for the management of multiple database systems. They will provide support for Oracle databases on Red Hat Linux VMs on Azure, as well as SQL Server databases on Azure VMs and Azure SQL Managed Instances. This includes appropriate backup procedures for both minor data losses as well as for complete disaster recovery, developer and user support, database tuning, security, and general maintenance of the systems. In addition, the DBA will provide their guidance for projects requiring database changes to ensure that the highest standards are used in administering the database system. Duties & Responsibilities:
  • Provide DBA support for SQL server on Azure VMs and Azure SQL Managed Instances

  • Provide Oracle DBA support including patching databases and partitioning tables.

  • Manage SQL server databases on Azure VMs and Azure SQL Managed Instances

  • Backup and restore SQL databases on Azure VMs and Managed Instances.

  • Monitor SQL Agent jobs and respond to critical job notifications. Troubleshoot and resolve the issues and if needed escalate issues and facilitate problem resolution.

  • Troubleshoot SSIS package failures and facilitate problem resolution.

  • Automates common database management tasks.

  • Creating documentation, maintenance plans, assigning and monitoring threshold values


  • What you Bring to the Table:

    • Create and evolve application documentation as required

    • Ensure that technical solutions follow best practices, are reliable and are easily maintainable.

    Requirements
    Basic Qualifications:
    • Bachelor’s degree in computer science, Information Systems, or related field.

    • 3+ years Oracle DBA experience

    • Hands-On Experience managing SQL database on Azure

    • Experience with backup strategies, and DR solutions for Oracle databases

    • Experience with table partitioning and reorg in Oracle

    • Experience with SQL transactional replication

    • Experience in monitoring and tuning MS SQL Server databases for optimum performance

    • Knowledge of indexes, analyzing query plans for performance tuning

    • Knowledge of SQL Server Integration Service (SSIS)

    • Knowledge of Linux shell scripting

    • Knowledge of Oracle Enterprise Manager preferred

    • Experience with ADF will be a plus

    • Proficient understanding of code versioning tools, such as Git / SVN


    Preferred Qualifications:Familiarity with data warehousing concepts and tools (e.g., Snowflake).

    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

    RecommendedJobs for You

    bengaluru, karnataka, india