drjobs Application DBA PostgreSQL with SQL Server

Application DBA PostgreSQL with SQL Server

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Gurgaon - India

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

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

We are looking for an experienced Application DBA specializing in PostgreSQL with exposure to SQL Server focusing on query optimization and database performance tuning. The ideal candidate will work closely with development teams to ensure the database layer is optimized for applications ensuring efficient query performance and overall system scalability.

Technical Experience:

  • 5 years of handson experience working with PostgreSQL databases with a focus on query optimization and database performance tuning.
  • Experience with SQL Server and basic query optimization on SQL Server databases.
  • Expertise in writing analyzing and optimizing complex SQL queries stored procedures and views.
  • Knowledge of indexing query execution plans and other optimization techniques.
  • Proficiency in working with performance monitoring and tuning tools such as pgstatstatements EXPLAIN ANALYZE and pgAdmin.
  • Basic knowledge of scripting languages like Python Bash or PowerShell for query automation and monitoring.
  • Familiarity with cloud databases (e.g. AWS RDS Azure) is a plus.

Key Responsibilities:

  • Database Query Optimization:
    • 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 slowrunning 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. pgstatstatements 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 welldocumented 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

Employment Type

Full Time

Company Industry

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.