Apply on Employer Site

Bessemer Trust · 9 hours ago

Senior Software Engineer (Database platfoms)

Woodbridge, NJ

Full-time

Hybrid

Senior Level

$150K/yr - $200K/yr

7+ years exp

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.

Financial ServicesWealth Management

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

Qualification

Oracle database developmentAmazon RedshiftCloud platforms AWSCloud platforms AzureSQLPL/SQLDatabase optimization techniquesETL/ELT workflowsScripting languages PythonScripting languages ShellCI/CD pipelinesDatabase certificationsAnalytical skillsCommunication skillsOrganizational skills

Required

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

Excellent verbal and written communication skills

Proven analytical and organizational skills (ability to handle multiple priorities)

Preferred

Relevant certifications in technology (e.g., Oracle Certified Associate, AWS Certified Database – Specialty) or domain knowledge (e.g., CDMP - Certified Database Management Professional)