Senior Software Engineer (Database platfoms)
About the role
Bessemer Trust is seeking a Senior Software Engineer (Database platforms) to develop and optimize our strategic database platforms, focusing on Oracle and Redshift environments. This role involves leveraging your expertise in database development and cloud technologies to drive innovation and contribute to strategic decision-making in a collaborative work environment.
Responsibilities
- Design, develop, and implement database solutions in Oracle and Redshift cloud environments.
- Collaborate with cross-functional teams to obtain requirements and translate into design and implementation of new features and enhancements.
- Optimize database performance through query tuning, indexing strategies, and efficient data modeling.
- Ensure data integrity and security through best practices in database design and implementation.
- Develop and maintain ETL/ELT workflows using database native tools or ETL tools like Informatica IDMC, Glue, dbt etc.
- Develop and maintain automation scripts for database tasks to enhance efficiency and reliability.
- Contribute towards strategic enhancements of our data platform such as implementing automated pipeline products like Liquibase.
- Provide timely production support and issue resolution within a shared, rotating on-call model.
- Participate in code reviews, share knowledge with team members, and contribute to a culture of continuous improvement.
- Stay current with emerging technologies and best practices in cloud computing and database management.
Qualifications
- Bachelor’s degree with 7-10 years of relevant experience preferably in the Finance industry
- Deep expertise in Oracle database development including database design, SQL, PL/SQL, and optimization techniques
- Hands-on experience with cloud-native databases such as Amazon Redshift, PostgreSQL, and Amazon DynamoDB
- Familiarity with cloud platforms like AWS or Azure, and expertise in deploying and managing databases on these platforms
- Ability to migrate on-premises databases to the cloud, ensuring data integrity and optimal performance
- Experience in tuning database performance for both on-premises and cloud environments, optimizing queries and resource utilization
- Proficiency in scripting languages (e.g., Python, Shell) and automation tools for managing database deployments and configurations
- Familiarity with CI/CD pipelines for automating database deployment processes
- Relevant certifications in technology (e.g., Oracle Certified Associate, AWS Certified Database – Specialty) or domain knowledge (e.g., CDMP - Certified Database Management Professional) preferred
- Excellent verbal and written communication skills
- Proven analytical and organizational skills (ability to handle multiple priorities)
Pay
The base salary range for this position is $150,000- $200,000 per year. This range reflects the minimum and maximum base salary we reasonably expect to pay for this role. In addition, this position may be eligible to participate in the relevant business unit’s incentive compensation plan, and other compensation programs as applicable.
Schedule
This position offers a hybrid work environment: 60% in office, 40% remote for most positions.
Benefits
- Competitive base salary plus discretionary annual bonus for select positions
- A 401(k) plan with a generous annual profit-sharing contribution
- Personalized development and career opportunities, including tuition reimbursement support
- Comprehensive medical, dental, and vision plans with zero contributions for employee coverage
- Employee assistance (EAP) and wellness programs
- Hybrid work environment: 60% in office, 40% remote for most positions
- Paid time off and paid parental leave
- Employer-paid life insurance and short- and long-term disability coverage