Job TitleProvide technical expertise to application development teamsAssist in tuning complex business analytical queriesCollaborate with data Tech leads and Architects on the logical models and translate into an optimal physical model that performs efficiently under various load profilesSupport end-to-end data solution delivery for multiple Agile product teamsHands-on design, development and delivery for Enterprise-level Oracle, MS SQL Server and NO-SQL databasesWrite queries, views, stored procedures and other DB objectsPerform daily detailed analysis of logs and monitoring tools, recognizing baseline vs change in behavior and not just when troubleshooting production issuesCreate metrics, graphs, and reports when applicableWork effectively with scrum teams towards the common goal of delivering top-notch solutions to our Advisor services customersSupport and Monitor database environments to ensure optimum performanceProvide tier-2 production support and participate in on-call rotationMentor and train Associate, Staff and offshore developers as neededAssist with streamlining and organizing documentation, share knowledge, ideas and concepts with the team, collaborate and truly believe in the concept of team workHave excellent SQL Server and Design and development skills – PL/SQL, T-SQL, Stored Procedures, Packages, Triggers, Unix/Linux Shell scripting. Strong ability to effectively manage multiple, competing, high-priority projects with varying deadlines and be able to work under pressure during production issuesAbility to work independently and also well together as a member of cross-functional teams in a fast-paced Agile environmentMust be passionate about data and for delivering high-quality data solutions in an agile fashionExcellent problem solving and troubleshooting skills, coupled with a desire to take on responsibilitiesMust have a growth mindset, be able to think big picture, a yearning to learn all Advisor Services Products and applications, rather than just the data requirementsExperience writing good documentation - detailed design, functional specifications or technical requirementsExperience working with Microsoft Team Foundation Server, Jira, Remedy, Jenkins, Bamboo and BitBucket are nice to haveMust have a track record of being detailed oriented, self-starter and deliverables with minimal defectsMust be solutions-oriented, a critical thinker and an excellent communicator – both written and verbal communicationMust be able to communicate technically and non-technically, tailoring communication to audienceStrong analytical and problem-solving skillsAble to quickly grasp complex concepts and learn new technologiesHave strong database development skills gained through 7+ years hands on experience working with relational and non-relational databasesOracle DB knowledge is a plus. MongoDB experience is a plusExperience working in Agile teamsProficiency with Unix/Linux Shell scripting (Korn Shell (KSH), BASH, etc.)Experience with job scheduling systems (Control-M, ESP, Autosys, Cron, etc.)Experience with Microsoft TFS; C#/