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 CommunicationStrong Team player with ability to work across cross functional groups