State Street Global Advisors-Database Developer, Oracle, AWS-AVP

Database Developer

Who we are looking for

State Street Global Advisors is looking for a database Developer and technical team lead with Masters (2+) or Bachelors (4+) years' experience for our Cloud Modernization and Platform Team, a part of Application Technology Solutions. This is a hands-on development position for a candidate with proven record of DB software development and execution excellence.

The candidate has industry experience (preferably in Financial Services) in supporting enterprise applications across various business units and has good exposure to Cloud based database engineering platforms. This is someone who has demonstrable cloud native development experience using backend databases in the cloud. The candidate has excellent development and problem-solving skills, someone with creativity and self-motivation to deliver on mission critical projects with tight timelines and competing priorities.

• Demonstrating strong experience in Oracle RDBMS, PL/SQL, AWS RDS, PostgreSQL, Redshift, Databricks, Python, Shell scripting
• Deploying high performing, quality/bug-free code in production.
• Executing unit test of data populated in target data container, validating expected result and ensuring quality and accuracy.
• Demonstrating strong expertise in AWS Cloud computing services and implementing data integration solutions for multiple platforms in SSGA.
• Design, develop and maintain applications leveraging cloud native architecture principles and technologies.
• Coordinating with business users for User Acceptance Testing and with Operations team for code deployment to upper environments.
• Ensuring all cloud solutions exhibit higher level of cost efficiency, performance, security, scalability, and reliability.
• Following change management team stipulations on path to production requirements and strictly adhering to the compliance and regulatory needs.
• Collaborating with cross functional team members as necessary and producing optimal solutions that meet data demands and standards.
• Participating in technical design, application build, configuration, unit testing, and production deployment.
• Providing technical expertise and ownership in the diagnosis and resolution of issues, including the determination and provision of workaround solution or escalation to service owners.
• Working with a team of BSA, Development, QA and DevOps engineers in agile framework.
• Anticipating, monitoring, managing and reporting all risk and compliance issues, breaches and suspicious activities.
• Acting in accordance with Risk Excellence and role model Ethical behavior and decision making as part of our Way Ahead foundation.

• Performs other duties, as necessary.

• Hands on database development experience with strong skills in designing, developing and deploying complex applications using OLTP and OLAP based databases.
• Strong development experience in PL/SQL programming and creating database objects like Tables, View, Materialized View, Stored Procedures, Triggers, etc.
• Hands on expertise in Data Modeling and DB design with strong skills in performance tuning.
• Hands on experience in setting up data pipelines for ETL jobs across multiple data sources.
• Hands on experience in troubleshooting and resolving database performance issues.
• Hands on working knowledge and experience around Oracle RDBMS, standard AWS services, such has EC2, S3, RDS, PostgreSQL, Redshift, Databricks.
• Hands on experience in building systems using modern, scalable, resilient, cloud native architectures.
• Strong knowledge of Cloud Security in AWS, specifically IAM Roles & Polices, Security Groups and Encryption keys.
• Optimizing database performance, scalability, ensuring data security and compliance; Able to predict database storage and growth.
• Keeping up to date on the latest cloud database technologies
• Experience with event based, micro-batch and batched high volume and high velocity transaction and data processing system.
• Proficiency with CICD and DevOps.
• Ability to work in an on-shore/off-shore model working with development teams across continents.

• Capable and effective in cross team collaboration like Enterprise teams, Architecture and Product Teams.
• Finding opportunities to innovate and take thoughtful risks in order to get things done better and faster.
• Finding opportunities to innovate and take thoughtful risks in order to get things done better and faster.
• Effective in an agile environment and deliver value incrementally, particularly when prioritizing against external dependencies.
• Strong, proven technical skills, with a track record of successfully building complex systems.
• Passionate for learning new skills and capabilities.
• Certified AWS Cloud Practitioner is strongly preferred. Higher certifications such as AWS Solution Architect or Developer is a plus.

• Masters or Bachelor's degree in Computer Science or related field
• Masters with 2+ or Bachelors with 5+ years of experience in Information Technology
• Experience working on enterprise application architecture and development. Experience in Financial Service industry is plus.
• Certifications in Oracle or AWS or any other cloud providers (preferred).
• Experience in agile delivery & adhering to SDLC processes is required.
• Strong team ethics and team player
• Strong communication (verbal and written) both internally and with vendors.
• Focus and desire to deliver high quality services.
• Ability to work in a high pressured and time sensitive environment.