SOFTWARE DEVELOPMENT ENGINEER 3

JOB OVERVIEW.
he SQL Database Developer is primarily responsible for the development and maintenance of the Clinical Trial Payments (CTP) systems.
Primary duties include analyzing, designing, development, debugging, and maintaining database system enhancements and/or new products employing Microsoft SQL Server stack of technologies, understanding the underlying business processes and data.
esponsibilities.
esponsible for the development and maintenance of CTP database platform.
mplements enhancements to the CTP database platform based on the product roadmap and prioritized requirements, including integration with other IQVIA applications.
esigns new or modifies existing database structures to solve database processing problems.
erforms database analysis and database design and development tasks of databases.
nsures that database design and code meet required operational standards and performance levels (as measured by reliability, response time, query execution time, etc.).
articipates in database consultations and database design and code reviews.
evelops optimized, reusable, and secure code utilizing stored procedures and functions.
dentify and implement database code optimization, troubleshoot, and mitigate code defects.
esigns ETL processes to acquire data from integrated systems for ingestion.
ebugs and tunes SQL and ETL processes to ensure accurate and efficient movement of data.
ests and prepares SQL code and ETL processes for deployment to production environments.
ssists the Business Analysts with technical requirements and provide effort estimates.
aintain revisions to systems technical documentation.
INIMUM REQUIRED EDUCATION AND EXPERIENCE.
achelor's Degree in Information Technology, Computer Science, or any IT related field3+ years of in-depth experience in an SQL Server development environmentExtensive hands-on experience in SQL Server development, ETL experience with custom coding.
n-depth understanding of SQL Server database management architecture, transactional processing (OLTP) and ETL (Extract, transform, load) methodologies.
orking experience with transactional database systems, and large volume data processing on SQL Server platform.
n-depth knowledge of T-SQL (views, functions, and stored procedures) in SSMS tool and SQL Server Integration Services (SSIS) development in Visual Studio environmentThe knowledge of and experience utilizing SSIS building custom packages is a plus.
xperience in the pharmaceutical clinical trial, financial, or IT development roles is a plus.
trong Microsoft Office skills; including advanced Excel skills.
bility to work in Agile development environment.
roven abilities to take initiative and be innovative.
trong problem-solving, analytical skills and attention to detail.
ossess positive attitude and ability to work in a team environment.
xcellent verbal and written communication skills.
QVIA is a leading global provider of advanced analytics, technology solutions and clinical research services to the life sciences industry.
We believe in pushing the boundaries of human science and data science to make the biggest impact possible – to help our customers create a healthier world.
Learn more at