$90,000 - $142,500 Annual
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 withcreativity and self-motivation to deliver on mission critical projects with tight timelines and competing priorities.
What you will be responsible for
- 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.
What we value
- database development experience with strong skills in designing, developing and deploying complex
- Hands on
- applications using OLTP and OLAP based databases.
- development experience in PL/SQL programming and creating database objects like Tables, View, Materialized View, Stored Procedures, Triggers, etc.
- Strong
- 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 t
- Hands on
- roubleshooting and resolving database performance issues.
- 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.
- Hands on
- 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.
Education & Qualifications
- 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.
Additional requirements
---
Why this role is important to us
Our technology function, Application Technology Solutions (ATS), is vital to State Street Global Advisors and is the key enabler for our business to deliver data and insights to our clients. We're driving the company's digital transformation and modernization initiatives and expanding business capabilities using industry best practices and advanced technologies such as cloud, artificial intelligence and robotics process automation.
We offer a collaborative environment where technology skills and innovation are valued in a global organization. We're looking for top technical talent to join our team and deliver creative technology solutions that help us become an end-to-end, next-generation financial services company.
Join us if you want to grow your technical skills, solve real problems and make your mark on our industry.
Salary Range
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.