Senior Associate - DBA

Davies; Pune District; On-site; INR 800,000 - 1,400,000; Full time

Job summary

Davies in Pune is seeking a Senior Associate - DBA to design and develop backend database solutions in a fast-paced, agile environment. You will collaborate with business users to ensure databases meet requirements and support critical applications.

The role covers building and maintaining SQL Server infrastructure, data migration, performance tuning, and providing on-call production support. A Bachelor's in CS and 3–5 years in software development are required.

Qualifications

• Bachelor’s degree in Computer Science or related field.
• Three to five years’ software development experience.
• Experience with SQL Server SSRS, WPF, or MVC 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.
• Provide Systems Support: Ensure business process integrity is maintained and provide on-call coverage for production systems.
• System Design and Technical Leadership: Evaluate requirements, prepare specs, and develop efficient, cost-effective applications; provide design input for new database development.
• System Development: Review requirements and test plans; provide technical feedback to Business Analysts.
• Testing/Troubleshooting: Ensure quality with thorough unit testing and assist with system testing and demonstrations.

Skills

SQL Server

SSRS

WPF

Web Service Development

MVC

Education

Bachelor’s degree in Computer Science or related field

Tools

Mainframe data experience (COBOL/VSAM/MVS)

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