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

Senior hands-on support manager/lead for enterprise database and cloud platforms hosted on AWS, serving as the L2/L3 escalation point for production issues impacting PostgreSQL, Redshift, Snowflake, data pipelines, and associated AWS services.

Responsibilities

• Act as L3 escalation point for major production incidents, leading 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 administer AWS RDS PostgreSQL, Amazon Redshift, Snowflake, Aurora PostgreSQL, and other enterprise databases, including:
  • Availability management
  • Performance troubleshooting and query tuning
  • Backup and recovery validation
  • Patch management and database upgrades
  • Space and capacity management
  • User administration and access support
• Support AWS platform operations for services including EC2, RDS, Redshift, S3, Lambda, EFS/EBS, Kinesis, CloudWatch, and IAM, covering:
  • Service monitoring and operational support
  • Infrastructure troubleshooting
  • Capacity planning
  • Security remediation
  • Disaster recovery 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 using tools such as Grafana, Kibana, ELK, and CloudWatch.
• Support security, audit, and compliance by:
  • Addressing audit and regulatory requests
  • Implementing vulnerability remediation plans
  • Managing database access reviews
  • Supporting IAM and privileged access controls
  • Ensuring compliance with enterprise security standards
  • Coordinating patching and security upgrades
• Drive platform reliability and continuous improvement by:
  • Identifying recurring issues and implementing permanent fixes
  • Reducing manual operational tasks through automation
  • Improving platform resiliency and recovery capabilities
  • Developing SOPs, runbooks, and knowledge articles
  • Leading problem management initiatives
• Partner with application support teams, data engineering teams, business stakeholders, AWS, Snowflake, and database vendors.
• Participate in change management and release activities; provide technical leadership during production events.

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.

Skills

• 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)

Pay

$90,000 - $157,500 annual. The range applies to the primary location; if the candidate works outside the primary location, the applicable range may differ.

Benefits

• Retirement savings plan (401K) with company match
• Insurance coverage including basic life, medical, dental, vision, long-term disability, and other optional coverages
• Paid-time off including vacation, sick leave, short-term disability, and family care responsibilities
• Employee Assistance Program
• Incentive compensation including eligibility for annual performance-based awards
• Eligibility for certain tax-advantaged savings plans