Database & Cloud Platform Support Lead, AVP - State Street Investment Management

State Street•Boston, MA

3d•Onsite

About The Position

The AVP Database & Cloud Platform hands-on Support Manager/Lead will be responsible for providing L2/L3 operational support, reliability engineering, and technical leadership for enterprise database and cloud platforms hosted on AWS. The role serves as the senior escalation point for production issues impacting PostgreSQL, Redshift, Snowflake, data pipelines, and associated AWS services. The individual will drive platform stability, incident reduction, performance optimization, vulnerability remediation, disaster recovery readiness, and operational excellence while partnering with application, infrastructure, security, and cloud engineering teams.

Requirements

8–12+ years of database administration and production support experience.
5+ years supporting cloud-hosted database platforms.
Strong experience in Incident, Problem, Change, and Capacity Management.
Experience supporting mission-critical financial applications.
Experience working within 24x7 operational support environments.
Databases: PostgreSQL, Amazon Redshift, Snowflake, Aurora PostgreSQL.
Cloud Platforms: AWS RDS, EC2, S3, Lambda, CloudWatch, IAM.
Monitoring: Grafana, Kibana, ELK.
Automation & Scripting: SQL, Python, Shell Scripting.
Ansible, Terraform (preferred).

Nice To Haves

Terraform (preferred)

Responsibilities

Act as L3 escalation point for major production incidents.
Lead troubleshooting of database, platform, and cloud infrastructure issues.
Perform root cause analysis (RCA) and implement preventive actions.
Coordinate incident communications and stakeholder updates.
Participate in on-call support rotations and major incident bridges.
Monitor platform SLAs and operational KPIs.
Support and administration of: AWS RDS PostgreSQL, Amazon Redshift, Snowflake, Aurora PostgreSQL, Other enterprise databases.
Responsibilities include: Availability management, Performance troubleshooting, Query tuning, Backup and recovery validation, Patch management, Database upgrades, Space and capacity management, User administration and access support.
Support AWS services including: EC2, RDS, Redshift, S3, Lambda, EFS/EBS, Kinesis, CloudWatch, IAM.
Responsibilities include: Service monitoring, Operational support, Infrastructure troubleshooting, Capacity planning, Security remediation, DR testing and validation.
Configure and maintain monitoring solutions.
Investigate alerts and recurring operational issues.
Develop operational dashboards and health reports.
Improve observability across database and cloud platforms.
Support audit and regulatory requests.
Implement vulnerability remediation plans.
Manage database access reviews.
Support IAM and privileged access controls.
Ensure compliance with enterprise security standards.
Coordinate patching and security upgrades.
Identify recurring issues and drive permanent fixes.
Reduce manual operational tasks through automation.
Improve platform resiliency and recovery capabilities.
Develop SOPs, runbooks, and knowledge articles.
Drive problem management initiatives.
Work closely with application support teams, data engineering teams, and business stakeholders.
Coordinate with AWS, Snowflake, and database vendors.
Participate in change management and release activities.
Provide technical leadership during production events.

Benefits

our retirement savings plan (401K) with company match
insurance coverage including basic life, medical, dental, vision, long-term disability, and other optional additional coverages
paid-time off including vacation, sick leave, short term disability, and family care responsibilities
access to our Employee Assistance Program
incentive compensation including eligibility for annual performance-based awards
eligibility for certain tax advantaged savings plans
inclusive development opportunities
flexible work-life support
paid volunteer days
vibrant employee networks