Postgresql Dba Job In Viraaj Hr Solutions
- Mifm Operations
- 3 to 7 Yrs
- Other Maharashtra
- 12 months ago
- Email to a friend
- Report this job
Job Description
- Overview The PostgreSQL Database Administrator (DBA) plays a crucial role in managing, maintaining, and optimizing one of the most powerful relational database systems in the market. This position is essential for ensuring the availability, performance, and security of the company's database environments, directly impacting data integrity and operational efficiency. The PostgreSQL DBA is responsible for setup, configuration, and ongoing support of the PostgreSQL databases, adapting them to meet the specific needs of the organization. As a key member of the IT team, the PostgreSQL DBA will collaborate with developers, system architects, and other stakeholders to design robust database solutions that align with organizational goals. The role demands a proactive approach to database management, requiring thorough monitoring and tuning of database performance, comprehensive backup plans, and effective disaster recovery strategies. Successful candidates should possess both technical acumen and excellent problem-solving skills to swiftly address database issues and optimize performance across various production environments. Key Responsibilities Install, configure, and upgrade PostgreSQL database server versions. Monitor database performance and tune queries for optimal performance. Implement and maintain backup and recovery strategies. Establish user accounts and manage access, roles, and permissions. Develop and implement security measures to safeguard database integrity. Conduct regular database maintenance tasks, including cleanup and optimization. Analyze and resolve database issues with minimal downtime. Collaborate with application developers to optimize application performance. Manage replication configurations and engage in disaster recovery planning. Stay updated on PostgreSQL advancements and evaluate new technologies. Create and maintain comprehensive documentation of database configurations. Provide technical support and guidance to other IT staff members. Participate in the design and implementation of database architectures. Automate routine database tasks through scripting and tools. Prepare reports on database status, performance, and usage metrics. Required Qualifications Bachelor's degree in Computer Science, Information Technology, or a related field. Minimum of 3 years of experience as a PostgreSQL DBA or in a similar role. Strong knowledge of PostgreSQLdb internal architecture and operations. Proficiency in SQL, PL/pgSQL, and database design principles. Experience with performance tuning and optimization techniques. Hands-on experience in establishing backup and recovery processes. Familiarity with monitoring tools like pgAdmin, Zabbix, or Nagios. Understanding of replication methods, including streaming and logical replication. Solid experience in security best practices for database management. Ability to analyze and troubleshoot complex database performance issues. Knowledge of Linux/Unix environments and command-line operations. Strong documentation skills for technical processes and procedures. Excellent communication skills, both written and verbal. Ability to work independently and as part of a collaborative team. Certifications in PostgreSQL or database management preferred. Skills: sql proficiency,pl/pgsql,linux/unix,monitoring tools,problem solving,disaster recovery,sql,backup and recovery,security best practices,database administration,performance tuning,database design,replication methods,postgresql,database management,database,security management,
Employement Category:
Employement Type: Full timeIndustry: IT Services & ConsultingRole Category: Not SpecifiedFunctional Area: Not SpecifiedRole/Responsibilies: Postgresql Dba Job In Viraaj Hr SolutionsContact Details:
Company: Viraaj HR SolutionsLocation(s): Other Maharashtra+ View Contact
Keyskills: monitoring tools problem solving disaster recovery database administration performance tuning database design postgresql database management security management backup recovery
Fraud Alert to job seekers!
₹ Not Specified
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in