Postgresql Database Administrator Numentica

5.0 - 10.0 years

0 - 2 Lacs

Bengaluru

Work from Office

Job Summary: We are seeking a skilled and experienced PostgreSQL Database Administrator to join our team. The ideal candidate will be responsible for ensuring the performance, availability, security, and reliability of our PostgreSQL database environments. You will play a key role in architecture design, system tuning, data replication, and support for mission-critical systems. MySQL DBA Experience is strong plus. Key Responsibilities: Monitor and maintain PostgreSQL database systems, ensuring high availability and performance. Manage database backup, restore, archiving, and disaster recovery procedures. Perform database upgrades, patching, and version control with thorough testing. Design and implement database architecture, schema, indexing strategies, and replication setups. Develop and maintain stored procedures, functions, and performance-optimized SQL queries. Identify and resolve performance bottlenecks, including query tuning and system-level optimizations. Support developers with database integration, schema changes, and data migrations. Define and enforce database security, access control, and compliance best practices. Participate in On-Call rotations for critical support and incident resolution. Collaborate with DevOps and infrastructure teams for automation and monitoring solutions. Requirements: Minimum 5 years of experience administering enterprise-scale PostgreSQL environments. In-depth knowledge of PostgreSQL internals, configuration, performance tuning, and replication (e.g., logical, streaming). Strong experience with backup and recovery tools (e.g., pgBackRest, WAL-G) and high availability configurations. Proven skills in SQL and PL/pgSQL development, including stored procedures and triggers. Familiarity with monitoring tools (e.g., pg_stat_statements, Prometheus, Grafana). Experience with Linux/Unix systems administration as it pertains to PostgreSQL. Ability to work independently, prioritize tasks, and own technical challenges and solutions. Strong analytical, problem-solving, and communication skills. Knowledge of cloud-based PostgreSQL services (e.g., AWS RDS, Azure Database for PostgreSQL) is a plus. MySQL DBA Experience is a Big plus.

Posted 1 week ago

Apply

PostgreSQL Administrator Hitachi Systems

5.0 - 10.0 years

9 - 13 Lacs

Mumbai

Work from Office

Role & responsibilities Perform routine database maintenance tasks, including backups, restores, and updates. Monitor database performance and implement optimizations to ensure efficient operation. Diagnose and resolve database-related issues promptly. Collaborate with the support team to address and solve customer-reported problems. Implement and maintain database security measures to protect sensitive information. Ensure compliance with relevant data protection regulations and industry standards. Analyze and optimize SQL queries for improved database performance. Collaborate with developers to enhance application performance. Implement and maintain high availability solutions. Develop and test disaster recovery plans to minimize downtime. Create and maintain detailed documentation related to database configurations, processes, and procedures. Work closely with development and infrastructure teams to address database-related requirements. Participate in cross-functional teams to implement new database solutions. Preferred candidate profile Proven experience as a PostgreSQL Database Administrator (L2) or similar role. In-depth knowledge of PostgreSQL architecture, configuration, and best practices. Proficient in SQL and scripting languages (e.g., Bash). Experience with database security and compliance. Strong problem-solving and troubleshooting skills. Excellent communication and collaboration abilities. Open source migration oracle to Postgres, DB2 to Postgres Familiarity with other database management systems. Knowledge of cloud database services (e.g., AWS RDS, Azure Database for PostgreSQL).

Posted 1 month ago

Apply

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.