Database Engineer, hybrid, Assistant Vice President

STATE STREET CORPORATION; Województwo pomorskie; Hybrid; PLN 164,000 - 200,000; Full time

Benefits offered by this job

Permanent contract from day one

Birthday Day Off

Gold Medical Package for employees and

their families

Premium life insurance

Private pension plan

Training programs

Volunteer days

Job summary

STATE STREET CORPORATION's Charles River Development team in Poland seeks a senior database engineer to advance our distributed data platform. The role blends design, optimization, and collaboration to deliver scalable, reliable data solutions for the state-of-the-art investment platform.

You will design architectures, write complex SQL, ensure security, and work with engineering, SaaS operations, and product teams to drive performance and resiliency.

Qualifications

• Solid experience with RDBMS and distributed data platforms in enterprise applications.
• Strong SQL performance tuning and query optimization skills.
• Experience designing scalable, highly available databases and data models.

Responsibilities

• Design scalable, highly available distributed database solutions.
• Write complex SQL queries, stored procedures, and scripts to support applications.
• Optimize performance through indexing, query optimization, and tuning.
• Monitor and maintain database health, security, and disaster recovery.
• Collaborate with cross-functional teams to ensure seamless data systems integration.

Skills

RDBMS

SQL performance tuning

Distributed data platforms

Problem solving

Communication

Education

B.S. in Computer Science, Engineering, Mathematics, Physics or related field

Tools

MS SQL Server

Oracle

Snowflake

Azure SQL Database

AWS RDS

Job description

Who we areCharles River Development (CRD) is the FinTech division of State Street. Together with State Street’s Middle and Back-office services, Charles River’s cloud-based Front Office technology forms the foundation of the State Street Alpha Platform, the first front-to-back solution in the industry.Our vision is to be the world’s leading investment platform, shaping the future of the industry and driving new levels of technology-led innovation, resiliency, efficiency and growth for investors and the people they serve.CRD Engineering organization is innovating and transforming the platform by moving away from monolithic software to utilising next generation cloud-based technology that leverages Microsoft Azure, Kafka, Snowflake, etc.As a digital innovation leader, we invest into our solutions, processes, systems, and talent.SummaryJoin us as a leading technical contributor to the enhancement and maintenance of one or more Charles River IMS modules or components of an agile scrum team. Be a part of strategic development projects and contribute to mission-critical optimization, resiliency, and performance improvement work for our clients. Collaborate with engineering, product, QA and sales teams to drive the platform innovation and modernization.This role requires a hybrid work model with at least 3 days in the office per week.ResponsibilitiesDatabase Design and ArchitectureDesign and implement scalable, performant and highly available distributed database solutionsCollaborate with peers across scrum teams to design and deliver database design conforming to database best practices and meet business and application requirementsCreate and maintain comprehensive documentation of database design, data models, configurations, and processesDatabase Development and optimizationWrite complex SQL queries, stored procedures, and script to support application developmentOptimize performance through indexing, SQL query optimization, and other database tuning techniquesMonitor database performance metrics, analyze and identify bottlenecks, and recommend short-term and long-term solutionsCollaborate with engineering teams to define performance test strategy, and develop toolsets to generate synthetic datasets for effective and repeatable performance testsImplement and manage database security, including access controls, encryption, and auditingDatabase AdministrationCollaborate with production DBA team to troubleshoot and resolve database production issue in timely mannerMonitor and maintain database health to ensure data integrity, availability, and disaster recoveryPerform database installation, configuration, and upgrades in lower environmentsCollaboration and LeadershipProvide thought leadership on the topic of database technologies and data modeling within and beyond the team’s scope of responsibilityCollaborate with cross-functional teams, including engineering, SaaS Operation, support, and implementation, to ensure seamless integration of database systemsProvide technical mentorship to junior database engineersQualificationsRecommended Education:B.S. degree (or foreign education equivalent) in Computer Science, Engineering, Mathematics, and Physics or other technical course of study required. MS degree strongly preferred.What we are looking for5 to 7+ years of professional software engineering experience with enterprise applications backed with RDBMS databases or SnowflakeExtensive hands-on experience in RDBMS and distributed data platforms as a database developerStrong analytical and problem-solving skills with ability to troubleshoot and resolve database related issuesProficiency in SQL performance tuning in MS SQL Server, Oracle, or SnowflakeStrong track record of building high performance, production quality software on scheduleAbility to work independently, handle multiple tasks simultaneously and adapt quickly to changesExcellent communication skills (verbal and written) with the ability to convey complex technical concepts to both technical and non-technical stakeholdersA minimum of 5 years working with an Agile development methodology strongly desiredNice To haveExpert experience with hardware sizing and configuration, operating systems, scripting, and database technologiesExperience in NoSQL databases is preferredExperience with cloud database services such as Azure SQL Database or AWS RDS is a plusExperience with developing applications for the financial markets is a plus (Fixed Income, Trading, FX, Risk, Portfolio/Wealth Management, Market Data, FIX, etc.)Minimum Salary:zł182 004 AnnualThe minimum salary quoted above applies to the role in the primary location specified. If the candidate ultimately works outside of this primary location, the applicable minimum salary may differ.Salary will be determined based on factors such as the position, type of work performed, individual skills, job description, working hours, diligence, initiative, self-management, length of employment, availability, and the quantity and quality of work delivered, as well as other objective and non-discriminatory criteria relevant to State Street employees.In addition to salary, employees are eligible to be considered for discretionary annual performance-based awards.We Offer:Permanent contract from day oneAdditional holidays (Birthday Day Off, 3rd and 5th year anniversary Day Off)Gold Medical Package for employees and their families (partner and children)Premium life insurance package and private pension planWide range of soft skills training, technical workshops, language classes and development programsOpportunities to volunteer your time to company-driven initiatives, employee networks or organizations of your choiceVariety of well-being programsAdditional benefits available depending on the seniority of the roleAbout State StreetAcross the globe, institutional investors rely on us to help them manage risk, respond to challenges, and drive performance and profitability. We keep our clients at the heart of everything we do, and smart, engaged employees are essential to our continued success.We are committed to fostering an environment where every employee feels valued and empowered to reach their full potential. As an essential partner in our shared success, you’ll benefit from inclusive development opportunities, flexible work-life support, paid volunteer days, and vibrant employee networks that keep you connected to what matters most. Join us in shaping the future.As an Equal Opportunity Employer, we consider all qualified applicants for all positions without regard to race, creed, color, religion, national origin, ancestry, ethnicity, age, disability, genetic information, sex, sexual orientation, gender identity or expression, citizenship, marital status, domestic partnership or civil union status, familial status, military and veteran status, and other characteristics protected by applicable law.Discover more information on jobs at StateStreet.com/careersRead our CEO StatementState Street's Speak Up LineZałącznik do standardu Whistleblowing i Speak Up SSBI GmbH dla Oddziału w Polsce