Application DBA

7 days ago

Gurgaon, Haryana, India People Prime Worldwide Private Limited Full time
Job Description

About Company :
India's exports (both merchandise and services) are expected to be worth $760 billion fiscal, growing by nearly 90 percent over $676 billion in FY-22. Foreign Trade Policy will likely herald a new era of streamlined processes, robust infrastructure and support for Small and Medium Enterprises ( SMEs) to reinforce India's presence in the global exports market.
Job Title : Application DBA (PostgreSQL) with SQL Server Exposure
Exp : 5 to 9yrs
Work Type : Full Time
Work Mode : Work from Office
Location : Gurgaon
Notice Period : Immediate to 15 days
Budget : Upto 20 LPA

Purpose to hire this position: Application DBA (PostgreSQL) with SQL Server Exposure supporting multiple applications at group level

Educational Qualification: Bachelor's degree in computer science or related information technology

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 hands-on 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 pg_stat_statements, 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 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

  • Application DBA

    1 week ago

    Gurgaon, Haryana, India People Prime Worldwide Private Limited Full time

    Job DescriptionAbout 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 ServerExp : 5 to 10yrsBudget : 18 to 20 LPAWork Type : Full TimeWork Mode : Work from OfficeLocation :...

  • PostgreSQL DBA

    5 days ago

    Gurgaon, Haryana, India ScaleneWorks Full time

    Job Description: PostgreSQL Database Administrator (DBA) Position Overview: We are seeking a highly skilled and experienced PostgreSQL Database Administrator (DBA) to join our team. As a PostgreSQL DBA, you will be responsible for the administration, maintenance, and optimization of our PostgreSQL database systems. You will play a critical role in ensuring...

  • Oracle Dba

    2 weeks ago

    Gurgaon, Haryana, India Alphanext Technology Solutions Full time

    About Us Alphanext Technology Solutions is a leading provider of innovative technology solutions We specialize in delivering robust scalable and efficient IT solutions to a diverse range of industries Our commitment to excellence and innovation drives us to seek top talent to join our team Job Overview We are seeking an experienced Oracle DBA with Cloud...

  • dba

    2 weeks ago

    Gurgaon, Haryana, India Oracle Full time

    Customer Success Services (CSS) is a unit within the Oracle's Customer Service Organization that establishes long-term relationships with many of Oracle's customers through annuity-based service contracts and project based one-time services. CSS services team sells from a broad IT-services portfolio both in fixed price and T&M basis. CSS services are...

  • Postgres DBA

    2 days ago

    Gurgaon, Haryana, India TecoreLabs Full time

    Company Description Tecore Labs is an emerging research and development company with over 50+ years of combined executive experience. The company offers best-in-class services in technology and building cohesive solutions across Web, Mobile, Cloud, DevOps, and Data Engineering. Tecore Labs has grown exponentially since its founding in 2017 and is now...

  • DBA/RAC/Dataguard

    4 days ago

    Gurgaon, Haryana, India Oracle Full time

    Job DescriptionThe Advanced Customer Services (ACS) is a unit within the Oracle's Customer Service Organization that establishes long-term relationships with many of Oracle's customers through annuity-based service contracts and project based one-time services. ACS services team sells from a broad IT-services portfolio both in fixed price and T&M basis. ACS...

  • Postgres DBA

    3 weeks ago

    Gurgaon, Haryana, India TecoreLabs Full time

    Company DescriptionTecore Labs is an emerging research and development company with over 50+ years of combined executive experience. The company offers best-in-class services in technology and building cohesive solutions across Web, Mobile, Cloud, DevOps, and Data Engineering. Tecore Labs has grown exponentially since its founding in 2017 and is now...

  • Banner DBAs

    2 weeks ago

    Gurgaon, Haryana, India OculusIT Full time

    Key Responsibilities : DR sync issue 2nd level resolution. Backup and restoration in supported assets- scheduled or adhoc. Performing export and import activities – scheduled or adhoc. Database security patch application. Log calls with vendor for product bugs. Provide timely escalation of complex problems to a technical support resource and/or...

  • Postgres DBA

    7 days ago

    Gurgaon, Haryana, India TecoreLabs Full time

    Company DescriptionTecore Labs is an emerging research and development company with over 50+ years of combined executive experience. The company offers best-in-class services in technology and building cohesive solutions across Web, Mobile, Cloud, DevOps, and Data Engineering. Tecore Labs has grown exponentially since its founding in 2017 and is now...

  • Staff DBA

    2 weeks ago

    Gurgaon, Haryana, India ANSR Summit Consulting Full time

    Role and Responsibilities:Monitor and troubleshoot database instances.Perform root-cause analysis in response to database environment events.Identify opportunities for improved system performance and process improvements.Perform code reviews, and assist teams across the organization with query optimization.Modify and build automated environment installation...

  • PostgreSQL DBA with SQL Server Experience

    7 days ago

    Gurgaon, Haryana, India People Prime Worldwide Private Limited Full time

    We are seeking a seasoned PostgreSQL DBA with experience in SQL Server to join our team at People Prime Worldwide Private Limited.About the RoleThe ideal candidate will be responsible for designing and implementing efficient database solutions using PostgreSQL, with expertise in query optimization and performance tuning. Additionally, they will support...

  • Application Support

    2 weeks ago

    Gurgaon, Haryana, India Virtusa Full time

    Application Support - CREQ193025 Description Application Support Maintaining and improving performance and availability of all clients web applications and platform. Leading high impact incident investigation and recovery in collaboration with various technology teams. Providing technical assistance in guiding the team for incident resolution. Leading...

  • Postgres DBA Only 24h Left

    3 weeks ago

    Gurgaon, Haryana, India TecoreLabs Full time

    Company DescriptionTecore Labs is an emerging research and development company with over 50+ years of combined executive experience. The company offers best-in-class services in technology and building cohesive solutions across Web, Mobile, Cloud, DevOps, and Data Engineering. Tecore Labs has grown exponentially since its founding in 2017 and is now...

  • Staff DBA T500-15730

    2 weeks ago

    Gurgaon, Haryana, India Summit Consulting Services Full time

    Role and Responsibilities: Monitor and troubleshoot database instances. Perform root-cause analysis in response to database environment events.Identify opportunities for improved system performance and process improvements. Perform code reviews, and assist teams across the organization with query optimization.Modify and build automated environment...

  • DBA SQL Server and PostgreSQL

    7 days ago

    Gurgaon, Haryana, India People Prime Worldwide Private Limited Full time

    Job DescriptionAbout Company :India's exports (both merchandise and services) are expected to be worth $760 billion fiscal, growing by nearly 90 percent over $676 billion in FY-22. Foreign Trade Policy will likely herald a new era of streamlined processes, robust infrastructure and support for Small and Medium Enterprises ( SMEs) to reinforce India's...

  • Lead DBA Expert

    3 weeks ago

    Gurgaon, Haryana, India Mrsool Full time

    Who Are We : Welcome to the world of Mrsool Where on-demand delivery meets unparalleled user needs to deliver anything you desire. As one of the largest delivery platforms in the Middle East and North Africa (MENA) region, Mrsool has captivated users with its unique and seamless experience, earning it the highest ratings among all major delivery platforms on...

  • Lead DBA Expert

    7 days ago

    Gurgaon, Haryana, India Mrsool Full time

    Who Are We : Welcome to the world of Mrsool Where on-demand delivery meets unparalleled user needs to deliver anything you desire. As one of the largest delivery platforms in the Middle East and North Africa (MENA) region, Mrsool has captivated users with its unique and seamless experience, earning it the highest ratings among all major delivery platforms on...

  • Application Developer: Oracle eBS

    2 weeks ago

    Gurgaon, Haryana, India IBM Full time

    Job DescriptionIntroductionIn this role, you'll work in one of our IBM Consulting Client Innovation Centers (Delivery Centers), where we deliver deep technical and industry expertise to a wide range of public and private sector clients around the world. Our delivery centers offer our clients locally based skills and technical expertise to drive innovation...

  • Senior Oracle EBS Database Administrator

    2 weeks ago

    Gurgaon, Haryana, India Epam Full time

    Description We are seeking a Senior Oracle EBS Database Administrator to join our team. The Oracle EBS DBA will be responsible for installing, configuring, upgrading, administrating, monitoring, and troubleshooting the entire Oracle EBS system, including custom applications. The role requires a dedicated candidate with experience in a large...

  • 3 Days Left: Cloud Technical Lead

    1 day ago

    Gurgaon, Haryana, India Insight Enterprises Full time

    Requisition Number 96989About Insight Founded in 1998 is headquartered in Chandler Arizona USA and has more and has more than 13000 Teammates worldwide with global presence in Canada United Kingdom Germany Australia India Singapore and many more With offices in the prime location -Gurgaon and Bangalore we have 1000 teammates operating from India...