Responsibilities:
• Design, develop, and maintain PL/pgSQL code (functions, procedures, triggers) for mission-critical financial systems.
• Collaborate with application development teams to integrate PostgreSQL with Java/Spring Boot microservices and REST APIs.
• Develop and implement PostgreSQL database solutions ensuring scalability, high availability, and performance.
• Develop the tooling for application and database monitoring, replication, data migration, resiliency, scalability and performance.
• Develop tools or scripts to automate ETL, backup, restore, health checks, and alerting functions.
• Write and optimize complex SQL queries, stored procedures, and indexing strategies.
• Participate in agile development processes, including sprint planning, retrospectives, and daily stand-ups.
• Build and maintain infrastructure-as-code (IaC) modules (e.g., using Terraform, Ansible) to automate PostgreSQL provisioning and configuration.
• Perform database tuning, optimization, query profiling, and capacity planning.
• Plan and execute major version upgrades and schema migrations with minimal downtime.
• Monitor live environments (Linux/Unix based) and troubleshoot incidents in collaboration with DevOps and SRE teams.
• Ensure security best practices are followed in handling sensitive data, access control, and audit logs.
• Contribute to DevOps and CI/CD pipelines as it relates to database deployments and testing.
Requirements:
• Bachelor’s degree in computer science, IT, Engineering, or a related field.
• 8+ years of experience in PostgreSQL development and administration in enterprise environments with agile/DevOps-driven teams using Jira, Git, Jenkins, and CI/CD tools.
• Strong expertise in PL/pgSQL, SQL optimization, and database schema design.
• Experience in application integration using Java-based services (Spring Boot, REST APIs) and PostgreSQL.
• Experience with programming languages like C, C++, or Python, which are often used in database development and extensions, with a good understanding of Agile methodologies.
• Extensive hands-on experience on Containers, Kubernetes, and cloud platforms (AWS/GCP/Azure).
• In depth experience with DevOps automation tools such as Code versioning (git), JIRA, Ansible, database CI/CD tools and their implementation.
• A Proven track record of implementing and leading SRE practices across large organizations or complex teams.
• Hands-on experience with Infrastructure-as-Code tools like Terraform and Ansible.
• Strong Linux/Unix system knowledge and scripting (Bash, Python).
• Excellent problem-solving, documentation, and communication skills.
