PostgreSQL DBA

PostgreSQL DBA 

Location: Bangalore 

Experience: 5-7 years  

Work Mode: Hybrid 

Job Summary 

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 . 

• Use PowerShell and SSIS to automate monitoring and alerting functions of SQL server. 

• Experience with MS SQL Server (2012 or greater) tools, including Query Analyzer, SQL Agent Jobs and Profiler. 

• Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server. 

• Experience working with Windows server, including Active Directory. 

• Knowledge on Azure DB as a service. 

• Excellent written and verbal communication. 

• Flexible, team player, “get-it-done” personality. 

• Ability to organize and plan work independently. 

• Ability to work in a rapidly changing environment. 

• Ability to multi-task and context-switch effectively between different activities and teams 

About Encora 
Encora is a Sofware development arm of Encora Corporation created specifically to address the growing Sofware needs of the business. Encora offers maintenance and reliability teams the tools, Sofware, and services they need to optimize asset performance. Home to three powerful iconic brands – we serve over 70,000 customers worldwide with a relentless dedication to quality, innovation, and service. Our products inform customers on the health of their assets and our Sofware and services drive better maintenance decisions – improving productivity, driving uptime, and reducing costs.  
We're serious about our commitment to diversity, which is why Encora prohibits discrimination based on race, color, religion, gender, national origin, age, disability, veteran status, marital status, pregnancy, gender expression or identity, sexual orientation or any other legally protected status.