Database Architect
Company: State Street Corporation
Location: Burlington
Posted on: April 23, 2024
|
|
Job Description:
Who we are looking for Leading technical contributor to the
enhancement and maintenance of one or more Charles River IMS
modules or components of an agile scrum team. Provide engineering
troubleshooting assistance to customer support teams and other
development teams within Charles River. Why this role is important
to us The team you will be joining is a part of Charles River
Development (or CRD), that became a part of State Street in 2018.
CRD helps create enterprise investment management software
solutions for large institutions in the areas of institutional
investment, wealth management and hedge funds. Together we have
created the first open front-to-back platform - State Street Alpha
that was launched in 2019. Join us if delivering next generation
infrastructure, using emerging technologies like AI and Blockchain
sounds like a challenge you are up for. What you will be
responsible for --- Database Design and Architecture o Develop and
design database architecture to support Charles River applications,
ensuring system scalability, security, performance and reliability
o Design strategies for distributed database platforms, including
Data Warehouse, Data Mart, Data Lake and Operational Data Storage
(ODS) that support cloud architecture and microservices o
Collaborate with system and software architects to set standards
for operations, programming, security and deployment of the
databases --- Data Modeling o Create and maintain comprehensive
documentation of database design, data models, configurations, and
processes o Establish standard processes to ensure data model
consistency and accuracy across business applications --- Database
Security and Disaster Recovery o Establish and enforce database
security best practices, including access controls, encryption, and
data masking that ensure compliance with data protection
regulations o Collaborate with production DBA to conduct capacity
planning that address future and long-term data storage and
performance requirements o Design and develop high availability,
robust disaster recovery, and data purging and backup strategies
--- Database Performance o Optimize performance through indexing,
SQL query optimization, and other database tuning techniques o
Monitor database performance metrics, analyze and identify
bottlenecks, and recommend short-term and long-term solutions o
Collaborate with engineering teams to define performance test
strategy, and develop toolsets to generate synthetic datasets for
effective and repeatable performance tests --- Collaboration and
Leadership o Provide technical guidance and support to engineering,
SaaS Operation, support and Implementation teams o Collaborate with
cross-functional teams, including engineering, SaaS Operation,
support, and implementation, to ensure seamless integration of
database systems o Provide technical leadership and mentorship to
database engineers What we value --- Extensive hands-on experience
in RDBMS and distributed data platforms as a database architect ---
Strong analytical and problem-solving skills with ability to
troubleshoot and resolve database related issues --- Proficiency in
SQL and database design principles --- Experience with cloud
database services such as Azure SQL Database or AWS RDS ---
Experience in NoSQL databases is preferred --- Programming
experience in Java, C++, C#, JDBC, Sprint boot, and Microservices
is a plus --- Experience with developing applications for the
financial markets is a plus (Fixed Income, Trading, FX, Risk,
Portfolio/Wealth Management, Market Data, FIX, etc.) Education &
Preferred Qualifications --- 7 to 10+ years of experience as a
Database Architect or in a similar role supporting enterprise
applications backed with RDBMS databases or Snowflake ---
Bachelor's degree in computer science, Information Technology, or a
related field. Master's degree is a plus --- Proven experience with
major relational databases such as MS SQL Server or Oracle,
hardware sizing and configuration, operating systems, scripting,
and database technologies --- Strong understanding of database
security best practices and data protection regulations --- Ability
to provide technical leadership and collaborate effectively with
cross functional and organizational teams --- Excellent
communication skills (verbal and written) with the ability to
convey complex technical concepts to both technical and
non-technical stakeholders --- A minimum of 7 years working with an
Agile development methodology strongly desired About State Street
What we do. State Street is one of the largest custodian banks,
asset managers and asset intelligence companies in the world. From
technology to product innovation we're making our mark on the
financial services industry. For more than two centuries, we've
been helping our clients safeguard and steward the investments of
millions of people. We provide investment servicing, data &
analytics, investments research & trading and investment management
to institutional clients. Work, Live and Grow. We make all efforts
to create a great work environment. Our benefits packages are
competitive and comprehensive. Details vary in locations, but you
may expect generous medical care, insurance and savings plans among
other perks. You'll have access to flexible Work Program to help
match your needs. And our wealth of development programs and
educational support will help you reach your full potential.
Inclusion, Diversity and Social Responsibility. We truly believe
our employees' diverse backgrounds, experience and perspective are
a powerful contributor to creating an inclusive environment where
everyone can thrive and reach their maximum potential while adding
value to both our organization and our clients. We warmly welcome
the candidates of diverse origin, background, ability, age, sexual
orientation, gender identity and personality. Another fundamental
value at State Street is active engagement with our communities
around the world, both as a partner and a leader. You will have
tools to help balance your professional and personal life, paid
volunteer days, matching gift program and access to employee
networks that help you stay connected to what matters to you. State
Street is an equal opportunity and affirmative action employer.
Salary Range: $110,000 - $185,000 Annual The range quoted above
applies to the role in the primary location specified. If the
candidate would ultimately work outside of the primary location
above, the applicable range could differ.
Keywords: State Street Corporation, Boston , Database Architect, IT / Software / Systems , Burlington, Massachusetts
Click
here to apply!
|