Search by job, company or skills

People Prime Worldwide Private Limited

Application DBA (PostgreSQL) with SQL Server

Early Applicant
  • Posted 2 days ago
  • Be among the first 10 applicants
5-10 Years

IT/Computers - Software

Job Description

About Company :
Our Client Track and Trace. Experience end to end visibility of freight journey across any part of the world. You can easily and conveniently track your goods - right from .
Job Title : Application DBA (PostgreSQL) with SQL Server
Exp : 5 to 10yrs
Budget : 18 to 20 LPA
Work Type : Full Time
Work Mode : Work from Office
Location : Gurugram, Haryana
Notice Period : Immediate to 30days

  • Analyze and optimize complex SQL queries to improve application performance, reduce response times, and optimize resource usage.
  • Review and rewrite queries in collaboration with the application development teams to ensure best practices and efficiency.
  • Implement indexing strategies, partitioning, and other techniques to boost database performance.
  • Identify and troubleshoot slow-running queries and provide recommendations for query refactoring.
  • Collaboration with Application Teams:
    • Work closely with software developers to design efficient database schemas that meet the requirements of the applications.
    • Participate in code reviews, offering guidance on SQL query design and database interactions.
    • Proactively suggest improvements to database usage patterns during development cycles and across various teams.
    • Act as a liaison between the development and database teams, ensuring smooth database integration and optimal performance.
  • Database Performance Tuning:
    • Continuously monitor and assess database performance and provide solutions to bottlenecks.
    • Conduct regular reviews of database usage patterns and optimize the performance of frequently used queries and stored procedures.
    • Use performance monitoring tools (e.g., pg_stat_statements, pgBadger, SQL Server Profiler) to track and resolve performance issues.
  • SQL Server Exposure:
    • Support development teams with query optimization and troubleshooting for SQL Server databases as needed.
    • Provide performance tuning and query analysis on SQL Server, working on improving database performance for applications that use both PostgreSQL and SQL Server.
    • Data Design and Modeling:
    • Collaborate in designing and maintaining database structures, including tables, views, and relationships to ensure optimal performance.
    • Assist with database modeling and schema design to support new application features and upgrades.
  • Automation and Scripting:
    • Develop scripts to automate query analysis and performance tuning processes.
    • Build tools for monitoring query performance, resource usage, and database efficiency.
  • Documentation:
    • Maintain comprehensive documentation related to query optimization, database structures, and best practices for interacting with the database layer.
    • Ensure that application teams have access to well-documented best practices for writing SQL queries and interacting with the database.
  • Secondary Skills:

  • Agile process knowledge will be an added advantage.
  • Good Communication
  • Strong Team player with ability to work across cross functional groups
  • Bachelor Of Technology (B.Tech/B.E)

    Skills Required

    Login to check your skill match score

    Login

    Date Posted: 28/11/2024

    Job ID: 101686003

    Report Job

    Hi , want to stand out? Get your resume crafted by experts.

    Similar Jobs

    People Prime Worldwide Private Limited

    Application DBA (PostgreSQL) with SQL Server

    People Prime Worldwide Private Limited
    Compunnel Technology India Private Limited

    Java Backend Developer with Sql Server / Remote

    Compunnel Technology India Private Limited
    Last Updated: 12-03-2025 07:00:01 AM
    Home Jobs in Gurgaon / Gurugram Application DBA (PostgreSQL) with SQL Server