2

Lead Software Engineer - Devops DBA

241387-Comp & Ben Admin Prof Fees
Full-time
On-site
United States
Description

We have an exciting and rewarding opportunity for you to take your software engineering career to the next level.

As a Database Administrator (DBA) at JPMorgan Chase within the Employee Platforms team, you will be responsible for the configuration, maintenance, and performance tuning of both SQL and NoSQL database systems, with a primary focus on Oracle and PostgreSQL. The ideal candidate will have extensive experience managing large-scale databases, ensuring their availability, reliability, and security. This role requires a deep understanding of database architecture, advanced troubleshooting skills, and the ability to work collaboratively with cross-functional teams.

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 certified or Dynatrace certified