Database Administrator @tss Consultancy Pvt Ltd - Mumbai, India - TSS Consultancy Pvt. Ltd.

Deepika Kaur

Posted by:

Deepika Kaur

beBee Recuiter


Description
Company Description

About Our Company

  • TSS is a fastgrowing company incorporated in 200
  • TSS is a solution provider for the financial industry, with clients in India, South Africa and USA
  • TSS is also known for creating effective products which help in getting complete control of the back office and middle office related functions.
  • Our clients are typically banks, stockbrokers, stock exchanges and hedge funds.

Job Description:


Key Responsibilities:

Database Installation and Configuration:
Install and configure PostgreSQL database software on servers and ensure proper setup.
Perform database migrations, upgrades, and patch installations.

Database Design and Optimization:
Optimize database performance by analyzing query execution plans, indexing strategies, and system resource utilization.
Tune database parameters and configurations to improve overall system performance.

Database Monitoring and Maintenance:
Monitor and maintain the health, availability, and security of PostgreSQL database systems.
Set up database monitoring tools and implement proactive measures to identify and resolve issues.
Perform regular database backups, implement disaster recovery strategies, and ensure data integrity.

Performance Tuning and Query Optimization:
Identify and resolve performance bottlenecks by analyzing SQL queries and suggesting optimizations.
Conduct capacity planning to anticipate future database growth and resource requirements.

Database Security and Access Control:
Implement and enforce security policies and access controls to safeguard sensitive data.
Manage user accounts, roles, and privileges to ensure appropriate data access levels.

Troubleshooting and Issue Resolution:
Investigate and resolve database-related issues, such as connectivity problems, data corruption, and performance degradation.
Maintain documentation and knowledge base to capture troubleshooting steps and solutions.


Qualifications:

Bachelor's degree in computer science, information technology, or a related field (or equivalent experience).
Proven work experience as a PostgreSQL Database Administrator or a similar role.
Strong knowledge of PostgreSQL database architecture, administration, and performance optimization.
Proficiency in SQL and experience with query optimization techniques.
Familiarity with backup and recovery strategies, disaster recovery planning, and high availability configurations.

Additional Information

More jobs from TSS Consultancy Pvt. Ltd.