Sr. Consultant


  • Company:
    Allstate solutions private limited
  • Location:
  • Salary:
    negotiable / month
  • Job type:
    Full-Time
  • Posted:
    5 days ago
  • Category:
    Financial Services/Stockbroking | Banking

Skill: dml , database , java , technical skills , oracle , technology , mining , ddl , production support , consultant , splunk; Exp: 4-7 years; Sr. Consultant Date Opened May 31, 2018 Location Bangalore, Karnataka, India Company Allstate Insurance Company Application Developer & Database Support Role for Product Technology Band B2 Job Description This role is part of Product Technology (PT) Production Support. The role focuses on common application components and database support, including database support for projects and involvement in initiatives designed to improve availability, stability and performance of PT systems. Specific responsibilities include (but not limited to) Consults with Solution Design and Project teams for needs around database changes, data population, common application components. Identifies opportunities for improvements, primarily in database design and application integrations. Partners with Database Administrators to execute database changes and populate data in Production and non-Production environments in support of projects. Responsible for and/or provides guidance on activities related to Oracle data maintenance and support, including DDL, DML, data load/migration, data validation, performance tuning, index analysis and creation, query optimization and stored procedure development. Participates in and/or drives strategic projects aimed at stabilizing and/or simplifying applications, environments and databases. Utilizes a variety of tools to troubleshoot Production and non-Production issues. Participates in and/or drives ECC and SWAT calls as necessary to resolve Production or non-Production incidents. Represents PT in enterprise-driven initiatives, such as lifecycle projects. Shadows and learns from SMEs on the team. Location Bangalore, India Hours of work Standard hours Mon Fri; Flexibility to meet business needs as required Essential criteria Be able to demonstrate strong communication and interpersonal skills Highly enthusiastic and self-motivated 4 years experience in a Java application development role 2 years experience with relational database design Experience troubleshooting a variety of application and database issues Ability to solve problems in a timely, structured manner with strong analytical approach. Desire to work in dynamic and challenging environments. Desire to further develop technical skills. Ability to work well with people at all levels, empowering collaboration globally. Be able to demonstrate strong communication and interpersonal skills. Highly enthusiastic and self-motivated. Desirable Criteria This may be used where we have a high number of applicants Experience with Splunk or other log mining tools Oracle Database support Travel requirements As required will be limited On-call Requirements Flexibility required For additional information please contact Malathi Rangasamy

Software Engineer

Degree: 

Experience: 4-7

Function: IT Software : Software Products & Services