Database Developer (SQL Server & Oracle)

5 years

0 Lacs

Posted:3 days ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

Job Title:

Location:

Experience:

Employment Type:

Database Developer/Engineer

Key Responsibilities

  • Database Development & Maintenance:

  • Design, develop, and maintain database objects such as

    tables, views, stored procedures, triggers, functions

    , and

    packages

    .
  • Write complex

    SQL queries and PL/SQL code

    for data extraction, transformation, and reporting.
  • Implement and maintain

    data integrity, consistency, and quality

    across multiple systems.
  • Performance Tuning & Optimization:

  • Analyze and tune SQL queries and database performance for optimal speed and scalability.
  • Identify and resolve bottlenecks, deadlocks, and performance issues.
  • Use tools like

    SQL Profiler, AWR, and Explain Plan

    to monitor and improve query performance.
  • Database Design & Architecture:

  • Collaborate with application and data teams to design logical and physical data models.
  • Implement efficient indexing and partitioning strategies to handle large data volumes.
  • Participate in database schema design reviews and recommend improvements.
  • Backup, Recovery & Security:

  • Implement and maintain

    backup and recovery strategies

    using native tools or third-party utilities.
  • Ensure data security through

    user management, roles, and permissions

    .
  • Work with infrastructure teams on high availability, disaster recovery, and failover setups.
  • Collaboration & Documentation:

  • Collaborate with application developers to ensure smooth integration between application and database layers.
  • Prepare and maintain documentation for database objects, procedures, and standards.
  • Support testing, release management, and production deployment activities.

Required Skills & Experience

  • 5+ years

    of hands-on experience with

    SQL Server and Oracle databases

    .
  • Strong proficiency in

    T-SQL and PL/SQL

    programming.
  • Experience with

    database design, normalization, indexing, and partitioning

    .
  • Proven expertise in

    performance tuning

    , query optimization, and troubleshooting.
  • Solid understanding of

    backup/recovery procedures

    ,

    security

    , and

    database administration concepts

    .
  • Experience working in

    Agile/Scrum

    environments.
  • Excellent problem-solving and communication skills.

Good to Have

  • Experience with

    ETL tools

    (SSIS, Informatica, or similar).
  • Knowledge of

    data warehousing concepts

    and

    BI tools

    (Power BI, Tableau).
  • Familiarity with

    Cloud database services

    (AWS RDS, Azure SQL, or Oracle Cloud).
  • Exposure to

    DevOps/CI-CD pipelines

    for database deployment automation.

Education

  • Bachelor’s or Master’s degree in

    Computer Science, Information Technology

    , or a related field.

Mock Interview

Practice Video Interview with JobPe AI

Start DevOps 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