Sr. Associate Support Engineer

Sr. Analyst Support Engineer

Job description:

We are looking for a SQL Server developer DBA who will be responsible for designing databases and ensuring their stability, reliability, and performance. You will also work other developers optimizing in-application SQL statements as necessary and establishing best practices. You will help solve all database usage issues and come up with ideas and advice that can help avoid such problems in the future.

Responsibilities

• Project team member responsible for delivering technical upgrade/implementation tasks for customers
• Help write and optimize in-application SQL statements
• Ensure performance, security, and availability of databases
• Prepare documentations and specifications
• Handle common database procedures such as upgrade, backup, recovery, migration, etc.
• Profile server resource usage, and optimize and tweak as necessary
• Collaborate with other team members and stakeholders
• compare and merge the database objects between two different databases
• create and execute database upgrade plan
• Expected to understand and be able to explain basic upgrade/implementation concepts while working under general supervision.
• Participates in designing the software configuration to meet the business process design and application requirements.
• Provides upgrade support, solution planning, product management expertise and customer support.
• Works with other developers, designers, and architects to ensure configuration and custom components meet application requirements and goals.
• Participates in code analysis, reviews, fixes any defects, and performance problems discovered in testing, & participates in transitions of the application components to the testers.
• Design, code, and/or configure solutions for moderate to high complexity Agile stories independently.
• Should understand and be able to contribute in all phases of the development lifecycle
• Write well designed, testable and efficient configuration scripts
• Configure applications for critical systems, delivering high availability and performance

Skills Desired

• Bachelor’s degree strongly preferred, in area with analytic emphasis
• 3 to 5 yrs. exp preferably in a technology, insurance, or otherwise related environment
• Ability & exp performing analytical or quantitative activities in spreadsheet/database types of software applications.
• Excellent Communication and interpersonal skills (listening, speaking and able to write clear and easy to understand specs) to effectively interact with team members and business users
• Good background in database design using SQL Server
• Strong proficiency with SQL and its variation among popular databases
• Experience with some of the modern relational databases
• Skilled at optimizing large complicated SQL statements
• Knowledge of best practices when dealing with relational databases
• Capable of troubleshooting common database issues
• Familiar with tools like RED Gate Compare
• Proficient understanding of code versioning tools such as {{Git / Mercurial / SVN}}
• Experienced in defining and implementing strategies and industry best practices
• Proven experience with agile methodologies (Scrum, Kanban) 
   

Preferred

• Bachelor’s/Master’s in Computer Science, Computer Information Sciences, and/or related field; related work experience can be substituted for educational requirement
• Understanding of the Insurance domain and processes
• Strong analytical and problem-solving skills.
• Experience in relational data modeling principles and techniques.
• Proven ability to be flexible and work hard, both independently and in a team environment
• Exp with implementation of DCT DMS a plus
• Preferred exp in implementing DMS software applications preferred