Lead Software Engineer - SRE, DevOps, Postgres, Teraform

We have an opportunity to impact your career and provide an adventure where you can push the limits of what's possible.

As a Lead Software Engineer at JPMorgan Chase within our Employee Platforms team, you will have the opportunity to configure, maintain, and tune both SQL and NoSQL database systems, primarily focusing on PostgreSQL and Oracle.

Your role will involve managing large-scale databases, ensuring their availability, reliability, and security.

You will need a deep understanding of database architecture, advanced troubleshooting skills, and the ability to work collaboratively with our cross-functional teams.

This is your chance to make a significant impact while pushing the boundaries of what's possible in database management

Job responsibilities:


* Configures, and maintains PostgreSQL and Oracle database systems.


* Manages database instances, including monitoring performance, tuning, and optimizing.


* Performs database backups, restores, and recovery operations.


* Analyzes and optimizes query performance and database resources.


* Monitors and manages database access, permissions, and roles.


* Implements database indexing, partitioning, and other performance-enhancing techniques.


* Develops and maintains automation scripts for database management tasks.


* Utilizes tools and frameworks to automate database deployments and configuration management.


* Provides advanced troubleshooting ,support for database-related issues and building high available resilient data layer platforms.


* Collaborates with IT and development teams to resolve complex technical problems.


* Maintains comprehensive documentation of database configurations, processes, and procedures.

Required qualifications, capabilities, and skills


* Formal training or certification on software engineering

* concepts and 5+ years applied experience


* 7+ years of experience in database administration with a focus on Oracle databases, primarily Postgress, AWS RDS and Oracle databases


* Expertise in Oracle database architecture, RAC, Data Guard, and PL/SQL.


* Strong knowledge of cloud platforms (e.g., AWS, Azure, GCP) and cloud database services.


* Experience with NoSQL databases such as MongoDB, Cassandra, or DynamoDB.


* In-depth knowledge of database security best practices and compliance requirements


* Proficiency in database performance tuning and optimization.


* Advanced scripting skills (Python, Bash, PowerShell).

Preferred qualifications, capabilities, and skills


* Relevant certifications such as PostgreSQL Certified Professional or equivalent are highly desirable


* Relevant certifications (e.g., Oracle Certified Professional, AWS Certified Database - Specialty) are highly desirable.


* Knowledge of reporting tools like Tableau, AWS QuickSight


* Familiarity with modern front-end technologies


* Cloud certification like AWS Solution architect , Terraform certi...