Home
Communities
Companies
- Companies
  
  Discover best places to work
- Compare Companies
  
  Compare & find best workplace
- Add Office Photos
  
  Bring your workplace to life
- Add Company Benefits
  
  Highlight your company's perks
Reviews
- Company reviews
  
  Read reviews for 6L+ companies
- Write a review
  
  Rate your former or current company
Salaries
- Browse salaries
  
  Discover salaries for 6L+ companies
- Salary calculator
  
  Calculate your take home salary
- Are you paid fairly?
  
  Check your market value
- Share your salary
  
  Help other jobseekers
Interviews
- Company interviews
  
  Read interviews for 40K+ companies
- Campus placements
  
  Interviews questions for 1K+ colleges
- Share interview questions
  
  Contribute your interview questions
Jobs
Awards

WINNERS AWAITED!
- ABECA 2025
  
  WINNERS AWAITED!
  
  AmbitionBox Employee Choice Awards - 4th Edition
- ABECA 2024
  
  AmbitionBox Employee Choice Awards - 3rd Edition
- AmbitionBox Best Places to Work 2022
  
  2nd Edition
- AmbitionBox Best Places to Work 2021
  
  1st Edition

Add office photos

Engaged Employer

Encora

Compare

3.8

based on 666 Reviews

253 Encora Jobs

PostgreSQL DBA Professional

Encora

3.8

based on 666 Reviews

5-7 years

Bangalore / Bengaluru

1 vacancy

PostgreSQL DBA Professional

Encora

posted 1mon ago

Job Role Insights

Flexible timing

Key skills for the job

Virtual Assistant SQL Windows System Administration Database Administration Active Directory Troubleshooting

+ 4 more

Job Description

The DBA will be responsible for the performance of critical SQL Server RDBMS systems and PostgresSQL, to ensure the availability and consistent performance of our enterprise applications. This is a hands-on position requiring solid technical skills, as well as excellent interpersonal and communication skills. The successful candidate will be responsible for the management of high volume, high available enterprise class SQL Server and Postgres SQL database, ensuring its operational readiness (security, health and performance), executing data loads, and performing data modelling in support of multiple development teams. Must be capable of working independently and collaboratively.

.
Responsibilities and Duties

Work with the following tools and technologies: MS SQL server administration, Postgres SQL;performance tuning and optimization (PTO) using native monitoring and troubleshooting tools;backup, restore, and recovery models; windows server, including active directory; high availability (HA) and disaster recovery (DR) options for SQL server; and leading cloud platforms like AWS, Azure or Google Cloud.

Monitors current usage levels of database storage to identify and report growth trends and assists in the forecasting of future storage requirements. Assists with the development of long-term capacity plans. Performs routine maintenance such as data compression,defragmentation, dropping temp tables, clearing transaction logs, archiving inactive databases, load balancing and evaluating server hardware to provide recommendations for performance improvements.

Actively monitors database performance to identify bottlenecks, such as inefficient queries, inconsistent and/or corrupt indexes, database design, and provides recommendations for corrective actions. Performs database statistic reporting on a regularly scheduled basis. Ensures the high availability of the supported database(s).

Works closely with the Applications Team while performing troubleshooting to determine the source of application failures. Assists in the development of solutions to minimize the potential of future application failures. Supports the implementation of solutions.

Produces and maintains operational database documentation, such as SQL Disaster Recovery, SQL Recovery Presentation, Naming Standards, Performance and Tuning, to ensure database configurations are well documented in preparation for disaster recovery.

Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

Apply data modelling techniques to ensure development and implementation support efforts meet integration and performance expectations.

Qualifications and Skills

5+ years of experience in handling MS SQL Server and Postgres Sql.

Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.

Monitor databases to gather resource consuming queries, maintain SQL server replication, Clustering, backups, ETL SSIS jobs, and encryption .

Review and debug SQL Server code including adhoc queries, views, stored procedures, functions and triggers for modernization and performance improvements.

Maintain, review and apply appropriate indexes for new and existing queries.

Analyze SQL query plans, suggest and implement solutions to support developers in the Software Development Life Cycle (SDLC).

Review alerts and remediate any issues that may arise from blocking, deadlocks and poorly performing code using extended events, execution plan analysis .