Senior Associate - DBA

Department: IT

Employment Type: Permanent - Full Time

Location: Pune

Description

Key Responsibilities

• Create and maintain database stored procedures, functions, batch services, Windows Services, and WCF components. 
• Implement and test database design and functionality, and tune for performance. 
• Locate and define new process improvement opportunities.

• Create and maintain integrations to both internal and external applications through data feeds 
• Acquire, understand, manipulate, and organize data from various sources    
• Create and maintain existing SQL Server Integration Packages  

• Ensure business process integrity is maintained 
• Provide coverage of automated back-end processes, especially during off-production hours; this coverage will be on a rotating basis amongst team members 
• Maintain and develop documentation of IT processes  

• Participate in the evaluation of business requirements and processes, preparation of application system specifications and the development, testing and implementation of efficient, cost effective applications solutions 
• Provide design input and direction for new database development 
• Follow procedures for change control and product migration  

• Review documented business requirements and test plans and provide technical feedback to Business Analysts  

• Ensure quality with thorough unit testing of all code and participating in systems integrated testing 
• Assist Business Analysts and End Users with any technical issues during systems integrated testing, parallel testing, training sessions and demonstrations 

• Provide on-call support for the production systems on a rotating basis 
• Maintain existing applications adhering to the established architecture and standards for that application  

Skills, Knowledge and Expertise

• Bachelor’s degree in Computer Science or related field
• Three to five years’ software development experience
• SQL Server SSRS, WPF, Web Service Development , MVC are a plus
• Experience with data sourced from mainframe systems is a plus (COBOL, VSAM, and MVS)
• Insurance industry experience preferred