BD (Becton, Dickinson and Company) Senior Database Developer in Chandigarh, India

Job Description Summary

The Database Developer position will be responsible for the development of database objects and procedural code supporting various products developed by D&A. The developer will create programs to maintain data integrity in the online transaction processing and data warehouse schemas. Additionally, the database developer will be responsible for creating the stored procedures, triggers, constraints and ETL (extraction, transformation and data loading) programs. The position requires extensive hands-on experience developing stored procedures, ETL code and associated code in a MS-SQL Server and Windows environment.

Job Description

Position Description

I. Department Overview:

The Data & Analytics department is responsible for developing and maintaining commercial grade software products, that are in compliance and supportive of the overall architectural and product strategy. Utilizing best practices within the industry, as well as the currently defined technology stack, this department is responsible for delivering high quality, highly stable, and robust applications that perform to present and future expectations.

II. Purpose:

The Database Developer position will be responsible for the development of database objects and procedural code supporting various products developed by D&A. The developer will create programs to maintain data integrity in the online transaction processing and data warehouse schemas. Additionally, the database developer will be responsible for creating the stored procedures, triggers, constraints and ETL (extraction, transformation and data loading) programs. The position requires extensive hands-on experience developing stored procedures, ETL code and associated code in a MS-SQL Server and Windows environment.

III. Specific Duties, Activities, and Responsibilities:

1.

Understand database design principles, including normalization and aggregation, for both on-line and data warehouse schemas to support the needs of application developers.

2.

Design, plan, and develop programs to optimally extract, transform and load data between data sources.

3.

Diagnose and resolve database performance issues.

4.

Maintain developed source code in the repository for all databases and keep all build programs up to date.

5.

Responsible for overall development success (inclusive of peer/code reviews, adherence to corporate standards, build process guidelines, maintainability, unit tests) of the project.

IV. Position Requirements:

Education or Equivalent:

  • BS in Computer Science or Information Systems.

Experience or Equivalent:

  • 4+ years experience working on relational database platform with emphasis on database code development.

  • 2+ working on experience application development.

Knowledge, Skills, and Abilities Requirements: List unique knowledge, skills, or problem-solving requirements.

  • MVC, C# and Web API

  • Data modeling tools like ER/Studio or ERWin

  • Database design skills including normalization and data warehouse design

  • Strong TSQL skills

  • Strong SSIS skills

  • Strong analytical skills

  • Structured troubleshooting skills

  • SQL query performance tuning experience

  • Experience in the healthcare industry, a plus

Toolset :

  • Microsoft SQL Server 2014 RDBMS

  • Microsoft SQL Server 2014 Integration Services (SSIS)

  • Microsoft SQL Server 2014 Reporting Services (SSRS)

  • Knowledge and experience with Transact SQL (stored procedure, trigger and constraint development)

  • MS-Windows

Physical/Mental Requirements:

  • Ability to communicate clearly both verbally and in writing.

  • Ability to analyze complex application and business operational issues.

Primary Work Location

IND Chandigarh - DLF IT Park

Additional Locations

Work Shift

BD is a leading global medical technology company that creates medical technology, devices and laboratory equipment for a variety of needs across the healthcare continuum. At BD, we are looking for candidates who possess passion, innovative solutions and a commitment to our one mission of improving access to groundbreaking medical and biotechnology services for people near and far, delivering state-of-the-art technology and cutting-edge research in the battle to fight and cure infectious diseases. With a global reach that extends across 50 countries worldwide, our network of professionals collaborates on effective measures to deliver enhanced patient quality such as lower health care delivery costs, improved health care and safety, and expanded health care for all. Join our company and see how you can become a part of one global mission to make a difference in human health.