Senior Associate - DBA

MDD Forensic Accountants; Pune District; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

MDD Forensic Accountants LLP in Pune seeks a Senior Associate - DBA to design, develop, and optimize backend database solutions supporting business requirements. You will work with business users to ensure data integrity and efficient data flows.

The role covers back-end infrastructure, data conversion, system design, testing, and on-call support, with opportunities to lead database development and improve processes in an agile environment.

Qualifications

• Bachelor's degree in Computer Science or related field.
• 3–5 years of software development experience.
• Experience with SQL Server SSRS, WPF, Web Service Development, MVC is a plus.
• Experience with data from mainframe systems (COBOL, VSAM, and MVS) is a plus.
• Insurance industry experience preferred.

Responsibilities

• Back-End Database Infrastructure: Create and maintain database stored procedures, functions, batch services, Windows Services, and WCF components.
• Data Conversion and Data Migration: Create and maintain integrations to internal and external applications through data feeds; Acquire, understand, manipulate, and organize data from various sources; Create and maintain existing SQL Server Integration Packages.
• Provide Systems Support: Ensure business process integrity; Provide coverage of automated back-end processes during off-production hours on a rotating basis; Maintain and develop IT process documentation.
• System Design and Technical Leadership: Evaluate business requirements, prepare specifications, develop and implement efficient, cost-effective applications; Provide design input for new DB development; Follow change control and migration procedures.
• System Development: Review documented business requirements and test plans; provide technical feedback to Business Analysts.
• Testing/Troubleshooting: Ensure quality with thorough unit testing; assist with system-integrated testing, training, and demonstrations.
• System Support: Provide on-call production support on a rotating basis; Maintain existing applications adhering to architecture and standards.

Skills

3-5 years software development

Mainframe data experience (COBOL/VSAMM

Insurance industry experience

Education

Bachelor's degree in Computer Science or related field

Tools

SQL Server SSRS

WPF

Web Service Development

MVC

Windows Services

Job description

Job Description:

Senior Associate - DBA

Department: IT

Employment Type: Permanent - Full Time

Location: Pune

Description

The SQL Database Developer is responsible for supporting projects in a dynamic, fast paced, scalable, and agile environment. Tasks include the design and development of backend database solutions in support of meeting the goals of the company. The Database Developer will interface with business users to ensure the database is satisfying business requirements.

Key Responsibilities

Back-End Database Infrastructure

• 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.

Data Conversion and Data Migration

• 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

Provide Systems Support

• 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

System Design and Technical Leadership

• 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

System Development

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

Testing/Troubleshooting

• 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

System Support

• 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