Support DB SQL Engineer - Senior Associate

Job Description

Who we are looking for

The PAM for Investments development team from India is  looking for a Senior Support Database Engineer. This position is to develop & maintain applications and platforms developed by the PFI team and focus on existing systems, building DataMart's, Help in performance optimization  . The successful candidate will utilize the proper mix of technical experience and interpersonal abilities to work with Development, support teams and ensure the infrastructure modernization needs for the application are met. Right person for this role should have broad knowledge and understanding of emerging technologies, Database technology trends.

What you will be responsible for

As Senior Database Support Specialist one will

• Analyze programming issues and come up with specific solutions to meet developer needs.
• Perform other duties as assigned to meet the goals and objectives of the department
• Be the liaison with project teams on data technologies and solutions
• Expected to learn new technologies and continue to expand expertise

What we value

These skills will help you succeed in this role

• MUST have demonstrated strong application development or technical support skill sets in SQL Server or Similar Database platforms.

• Good Exposure to working on Azure Cloud platform

• Remains flexible to changing priorities, open to new ideas and have the stakeholder success firmly as the focus
• Strong analytical, technical, problem-solving skills along with being detail-oriented, and able to understand complex customer needs and translate them into end-user products/automations.
• Ability to prioritize efforts to deliver maximum consumer value and support key business KPI's; assist with smart trade-offs and sequencing of Application roadmap.
• Ability to manage your own time by appropriately prioritizing design and research tasks while working within deadlines. 
• Proven communication, interpersonal and analytical skills.
• Strong organizational skills and attention to detail.
• Strong Practical experience using Scrum, Agile modelling and adaptive software development.
• Able to work with minimum supervision.
• Team Player
• Knowledge of database architecture and hands on expertise PL/SQL coding with performance tuning
• Software Engineering experience, with SQL as programming languages is required.
• Should be able to write SQL queries using RDBMS Systems like SQL Server
• Having experience in support role/function.
• Experience in using API Development/Debugging Tools for troubleshooting/support. 
• Strong SQL  experience with ETL tools
• Experience with any source control System (Git, SVN )Understanding data modelling, Designing and Implementing big data analytics
• Experience in working with Azure Cloud platform

Education & Preferred Qualifications

• Bachelor’s Degree in technology
• Minimum 3-8  years related experience in financial services technical projects, experience in data integration projects
• Knowledge of financial service industry – Data management, Investment Accounting, Performance experience preferred
• Good with technical troubleshooting and debugging skills.
• Ability to write complex SQL

Additional requirements ( Nice to have)

• Hands-on experience with Cloud-native data platforms like Snowflake is good to have
• Solid understanding of the Software as a Service (SaaS) model in the online environment

State Street's Speak Up Line