Application Support Database Admin(PostgreSQL)

2 days ago

Gurugram Haryana, India Cloudesign Technology Solutions Full time

**Role Title: Application DBA (PostgreSQL) with SQL Server Exposure**

**Location: Gurgaon, Haryana**

**Employment Type: Permanent**

**Reporting to IT organization: IT Team, DTE**

**Purpose to hire this position: Application DBA (PostgreSQL) with SQL Server Exposure**

**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**:

- 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**:

- 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

**Data Design and Modeling**:

- Collaborate in designing and maintaining database structures, including tables, views, and relationships to ensure optimal performance.

**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.

**Secondary Skills**:

- Agile process knowledge will be an added advantage.
- Good Communication
- Strong Team player - with ability to work across cross functional groups

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

  • PostgreSQL Database Administrator

    1 week ago

    Gurugram, Haryana, India Adriyana Solutions Pvt Ltd Full time

    **PostgreSQL Database Administrator (DBA) Job Description** As a PostgreSQL DBA, you’ll play a critical role in managing and optimizing PostgreSQL databases. Your responsibilities will include: - **Database Administration**: - Set up, configure, and maintain PostgreSQL databases. - Perform backups and restores using tools like pg_dump and...

  • postgresql database

    1 week ago

    Gurugram, India Rosmerta Technologies Limited Full time

    We are Hiring! Rosmerta Autotech Limited: Rosmerta Technologies Limited( Position Name: Database Administrator(PostgreSQL,MYSQL) Skills Set: Manage, Maintain, Support PostgreSQL,MySQL,MSSQL Database systems, Ensuring High Availability and performance, Analyse database performance, implement query otimization and performance, tuning strategies, Configure...

  • postgresql database

    2 weeks ago

    Gurugram, India Rosmerta Technologies Limited Full time

    We are Hiring! Rosmerta Autotech Limited: Rosmerta Technologies Limited( Position Name: Database Administrator(PostgreSQL,MYSQL) Skills Set: Manage, Maintain, Support PostgreSQL,MySQL,MSSQL Database systems, Ensuring High Availability and performance, Analyse database performance, implement query otimization and performance, tuning strategies, Configure and...

  • PostgreSQL Dba

    2 weeks ago

    Gurugram, Haryana, India Iksha Labs Full time

    Design, deploy, and maintain PostgreSQL database instances on Amazon Web Services, ensuring high availability and optimal performance. - Implement and oversee database backup, disaster recovery, and failover strategies to maintain data integrity and availability. - Monitor database performance metrics and adjust configurations to improve efficiency and...

  • Database Administrator

    2 weeks ago

    Gurugram, Haryana, India Simpplr Full time

    at Simpplr Gurugram, India **Who We Are**: Simpplr delivers exceptional AI-powered employee experiences at scale. It is the only platform that unifies employee engagement, enablement, and self-service to provide every employee with a seamless and personalized experience so they can do their best work from anywhere. Organizations use our forward-looking,...

  • Application Support Lead

    3 weeks ago

    Gurugram, India Airtel Full time

    Role Overview The Application Administrator is responsible for the installation, configuration, monitoring, and maintenance of enterprise applications. The role ensures applications are secure, reliable, and performing optimally, while supporting business users and development teams with issue resolution and system improvements. Key Responsibilities...

  • Mongodb & PostgreSQL Male

    4 days ago

    Gurugram, Haryana, India Adriyana Solutions Pvt Ltd Full time

    A MongoDB or PostgreSQL job description may include responsibilities such as: - **Database administration**: Configuring, maintaining, and monitoring databases - **Data management**: Creating, reading, updating, and removing data - **Performance**: Ensuring databases are available and performing well - **Security**: Performing security measures and...

  • Rosmerta Technologies

    3 weeks ago

    Gurugram, India Rosmerta Technologies Limited Full time

    Database Administrator (PostgreSQL, MySQL, MSSQL)About Rosmerta Autotech Limited :Rosmerta Autotech Limited, a part of the Rosmerta Technologies group, is a leader in India's automotive technology and mobility solutions sector.With a strong presence in areas like High-Security Registration Plates (HSRP), Smart Driving Licenses, and Intelligent Transport...

  • Office Admin

    2 weeks ago

    Gurugram, Haryana, India Groyyo Full time

    **Join Our Team at Groyyo** Groyyo is seeking experienced and driven **Office Admin & IT Support professionals** to join our dynamic team in **Gurugram**. "Major Focus will be on Administration Task" **Position**: Office Admin & IT Support **Experience**: Minimum 1 years **Key Responsibilities**: - **Coordinate domestic and international travel...

  • Database Administrator

    2 weeks ago

    Gurugram, Haryana, India S&P Global Full time

    **About the Role**: OSTTRA India **The Role**: Database Administrator **The Impact**: Together, we build, support, protect and manage high-performance, resilient platforms that process more than 100 million messages a day. Our services are vital to automated trade processing around the globe, managing peak volumes and working with our customers and...