Application Support Database Admin(PostgreSQL)

1 day 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

  • 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,...

  • Database Administrator L3

    5 days ago

    Gurugram, Haryana, India Precision Techserve Full time

    **Daily DBMS operation and reporting.** - ** Installing and maintaining the Oracle database software.**: - ** Creating storage database structures with high-level security features.**: - ** Setting up database user accounts.**: - ** Work with users on how to access the information in the database.**: - ** Finding and debugging malfunctioning programs...

  • Rosmerta Technologies

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

  • Mongodb & PostgreSQL Male

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

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

  • Admin Associate

    1 week ago

    Gurugram, Haryana, India Eveez TravelTech Experiences P. Ltd. Full time

    **Job Summary** **Key Responsibilities**: - Manage office supplies, correspondence, and filing systems. - Schedule meetings, appointments, and travel arrangements. - Update databases, prepare reports, and ensure data accuracy. - Assist with onboarding, vendor coordination, and compliance tasks. - Provide general support to teams and maintain...

  • Database Administrator

    2 weeks ago

    Gurugram, Haryana, India Spare Care Solutions Full time

    We are hiring 2+ years database administrator (DBA) is an IT professional responsible for managing, maintaining, and securing an organization's data systems. DBAs often work with various database management systems (DBMS) like MySQL, PostgreSQL, or Oracle. Key Responsibilities of a Database Administrator: - **Database Management**: - Installing,...

  • Database Administrator

    2 weeks ago

    Gurugram, Haryana, India Unlimit Full time

    **About Unlimit** **How you contribute**: - Administer a diverse set of databases including Oracle, MongoDB, PostgreSQL, and MySQL. - Study and evaluate database load profiles. - Identify and mitigate potential bottlenecks, ensuring optimal database performance. - Analyze and optimize slow-performing queries to boost database efficiency. - Implement and...

  • Database Admin

    2 weeks ago

    Gurugram, Haryana, India United Airlines Full time

    Achieving our goals starts with supporting yours. Grow your career, access top-tier health and wellness benefits, build lasting connections with your team and our customers, and travel the world using our extensive route network. Come join us to create what’s next. Let’s define tomorrow, together. **Description**: United's Digital Technology team is...

  • Database Administrator

    2 weeks ago

    Gurugram, Haryana, India Brilliantech Software Full time

    Database Administrator (DBA) Company : (Payroll Position) Location: Gurugram (Onsite) **Job Type**: Contract - 6 Months Budget : Competitive salary package Experience : 5 to 7 years Notice Period : Immediate Joiners Preferred Job Description: Key Responsibilities: - Administer, monitor, and maintain PostgreSQL databases on production environments. -...