Senior Software Engineer - Postgre

Job Description

Key Skills: PostgreSQL, Pl/SQL

Education Qualification: Any Graduate

Minimum Years of Experience: 2+ Years

Type of Employment: Permanent

Job Description: Our dynamic and growing company is actively seeking an experienced PostgreSQL Database Developer to join our team. As a PostgreSQL Database Developer, you will play a crucial role in designing, implementing, and maintaining our database systems. The ideal candidate should have a strong background in database development, performance optimization, and data modeling.

Job Responsibilities :

• Responsible to design, implement, and maintaining database schemas in PostgreSQL and perform data modeling to ensure efficiency, reliability, and scalability.
  
• Responsible to optimize and tuneSQL queries for improved performance , and also identify and resolve performance bottlenecks in database systems.
  
• Responsible to manage data migration and integration processes between different systems and ensure data consistency. Also, integrity during the migration process.
  
• Responsible for developing and maintaining stored procedures, functions, and triggers to support application requirements and Implement business logic within the database layer.
  
• Responsible to Implement and maintaining database security policies and manage user roles, permissions, and access. Control within the database.
  
• Responsible to implement and oversee database backup and recovery processes and also ensure data availability and reliability.
  
• Responsible to collaborate with cross-functional teams, including application developers, system administrators, and business analysts, to understand database requirements.
  
• Responsible to create and maintain documentation related to database design, processes, and best practices.
  

Requirements

Qualifications :

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
  
• Proven experience as a Database Developer with a focus on PostgreSQL.
  
• In-depthknowledge of database design principles, normalization, and data modeling.
  
• Strong proficiency in writing and optimizing SQL queries.
  
• Experience with performance tuning and query optimization techniques.
  
• Familiarity with database security best practices and access control.
  
• Hands-onexperience with data migration, integration, and ETL processes.
  
• Proficiency in scripting languages (e.g., Python, Bash) for automation tasks.
  
• Knowledgeofbackupandrecovery processes.
  
• Excellent communication and collaboration skills.
  
• Ability to work independently and as part of a team. Preferred Skills:
  
• Experience with PostgreSQL replication and clustering.
  
• Familiarity with NoSQL databases.
  
• Knowledge of cloud database solutions (e.g., AWS RDS, Azure Database for PostgreSQL).
  
• Understanding of DevOps practices and tools
  

Requirements
3-8 years of experience as a Linux System Administrator. Strong knowledge of Linux server distributions (RHEL, CentOS, Ubuntu). Good understanding of networking, DNS, DHCP, VPN, firewalls. Experience with scripting (Bash, Python, Perl) for automation. Hands-on experience with virtualization technologies (VMware, KVM, Hyper-V). (Good to have) Familiarity with cloud platforms (AWS, Azure, or GCP). Working knowledge of monitoring tools (Nagios, Zabbix, Prometheus, Grafana). Experience with version control (Git). Strong troubleshooting and problem-solving skills. Good understanding of IT security principles. Excellent documentation and communication skills.