Database Programmer

4 semanas atrás

São Paulo, São Paulo, Brasil IQVIA Solutions do Brasil Ltda (BR01) Tempo inteiro

Job Overview
Under broad guidance, responsible for developing and maintaining mission-critical database code. D esigns and modifies database configurations and programs to solve data processing problems in an innovate manner, expressing a solid understanding of data architecture and efficient database design. Writes complex queries and perform query tuning\troubleshooting.

Essential Functions

  • Performs database analyses and database design tasks of in the development, UAT, and production environments, including:
  • Create data definition language and SQL database objects; apply referential integrity and security enforcement
  • Write complex stored procedures, functions as well as support/enhance existing code
  • Create/modify database schema, tables, indexes, triggers, etc.
  • Administer database backup\restore programs
  • Perform code optimization
  • Perform data denormalization and database sizing and tuning, develop data archival schemes
  • Ensure databases meet required operational standards and performance levels (as measured by reliability, response time, query execution time, etc.).
  • Participates in database consultations and database design reviews.
  • Designs and develops ETL pipelines integrating various sources of data (Excel, text files, XML, SAS, and REST API sources) using SQL Server Integration Services (SSIS) and custom ETL methods
  • Utilizes critical thinking and creativity in coordination with non-IT customers and stakeholders in the development of T-SQL database objects to meet various business requirements.
  • Creates and maintains reports using SQL Server Reporting Services (SSRS), Power BI
  • Design reports in Excel using Power Query and VBA
  • Monitors SQL Server Agent jobs, diagnosing runtime issues and implementing resolutions as needed.
  • Provide additional support IT testing and system validation of Cronos IT products.
  • Activities include: denormalization, developing data archival schemes, sizing, creation of data definition language and database objects, referential integrity and security enforcement and application optimization.

Qualifications

  • Bachelor's Degree in Computer Science, a related field, or equivalent experience
  • Five (5) years of proficient experience using T-SQL (MS SQL Server) for database development
  • Two (2) years of experience using one or more of the following: SSRS, Power BI, Excel Power Query, Windows PowerShell, VBA.
  • Ability to proactively identify complex problems and develop recommended solutions
  • Ability to document requirements-gathering and feasibility analyses in a collaborative team environment

IQVIA is a leading global provider of clinical research services, commercial insights and healthcare intelligence to the life sciences and healthcare industries. We create intelligent connections to accelerate the development and commercialization of innovative medical treatments to help improve patient outcomes and population health worldwide . Learn more at

#J-18808-Ljbffr

  • Full-stack Programmer

    2 semanas atrás

    São Paulo, São Paulo, Brasil PSI CRO AG Tempo inteiro

    We are the company that cares – for our staff, for our clients, for our partners and for the quality of the work we do. A dynamic, global company founded in 1995, we bring together 3000 driven, dedicated and passionate individuals. We work on the frontline of medical science, changing lives, and bringing new medicines to those who need them.We offer an...

  • Full-stack Programmer

    1 semana atrás

    São Paulo, São Paulo, Brasil PSI CRO AG Tempo inteiro

    We are the company that cares – for our staff, for our clients, for our partners and for the quality of the work we do. A dynamic, global company founded in 1995, we bring together 3000 driven, dedicated and passionate individuals. We work on the frontline of medical science, changing lives, and bringing new medicines to those who need them. We offer an...

  • Full-stack Programmer

    Há 2 dias

    São Paulo, São Paulo, Brasil PSI CRO Tempo inteiro R$80.000 - R$120.000 por ano

    Company Description We are the company that cares – for our staff, for our clients, for our partners and for the quality of the work we do.  A dynamic, global company founded in 1995, we bring together 3000 driven, dedicated and passionate individuals.  We work on the frontline of medical science, changing lives, and bringing new medicines to those who...

  • Apps Dev Intmd Programmer Analyst

    Há 3 dias

    São Paulo, São Paulo, Brasil Citi Tempo inteiro US$80.000 - US$120.000 por ano

    The Applications Development Intermediate Programmer Analyst is an intermediate level position responsible for participation in the establishment and implementation of new or revised application systems and programs in coordination with the Technology team. The overall objective of this role is to contribute to applications systems analysis and programming...

  • Autonomous Backend Developer Position

    Há 2 dias

    São Paulo, São Paulo, Brasil beBeePython Tempo inteiro US$50.000 - US$100.000

    Remote Python Programmer OpportunityWe are a cutting-edge software company developing an automated REST API gateway to databases. Web and mobile developers use our platform to save time on application backend, while data scientists benefit from convenient access to databases in the cloud or on-premises.Enterprise architects leverage our resource-oriented...

  • Apps Dev Intmd Programmer Analyst

    Há 3 dias

    São Paulo, São Paulo, Brasil Citi Tempo inteiro

    **Responsibilities**:- Acting as a systems analyst with an emphasis on developing technological solutions, developing new codes, identifying and correcting issues in source code and analyzing legacy codes.- Identify problems, analyze information, and make evaluative judgements to recommend and implement solutions- Has the ability to operate with a limited...

  • Data Systems Developer

    Há 3 dias

    São Paulo, São Paulo, Brasil beBeeSoftware Tempo inteiro US$90.000 - US$125.000

    Job Title:Full-stack ProgrammerAbout the Role:We are seeking a skilled and proactive software professional to join our global Data Management team. As a Full-stack Developer, you will be responsible for the entire spectrum of development activities supporting our in-house data management applications.This is an excellent opportunity to contribute to...

  • Global Clinical Trial Biostatistician

    Há 3 dias

    São Paulo, São Paulo, Brasil beBeeBiostatistician Tempo inteiro R$120.000 - R$180.000

    Senior Biostatistician Role SummaryWe are seeking an experienced Senior Biostatistician to lead our biostatistics activities related to clinical trials. The successful candidate will have a strong background in statistics and a proven track record of delivering high-quality statistical analysis and reports.Key Responsibilities:Lead all biostatistics...

  • Senior Biostatistician

    4 semanas atrás

    São Paulo, São Paulo, Brasil PSI CRO Tempo inteiro

    Company DescriptionWe are the company that cares - for our staff, for our clients, for our partners and for the quality of the work we do. A dynamic, global company founded in 1995, we bring together more than 2,500 driven, dedicated and passionate individuals. We work on the frontline of medical science, changing lives, and bringing new medicines to those...

  • Senior Biostatistician

    Há 3 dias

    São Paulo, São Paulo, Brasil PSI CRO Tempo inteiro

    Company DescriptionWe are the company that cares - for our staff, for our clients, for our partners and for the quality of the work we do. A dynamic, global company founded in 1995, we bring together more than 2,000 driven, dedicated and passionate individuals. We work on the frontline of medical science, changing lives, and bringing new medicines to those...