Postgres DBA – Azure Cloud

Location: Fully Remote – US Pacific or Mountain Time zone alignment

Job Description:

The Integrated Health Practice at IQVIA is seeking to add a Senior Database Administrator (DBA) to their global team of DBAs. This role involves support responsibilities for all relational databases across various technologies and cloud platforms, with a primary focus on PostgreSQL in Azure. The position requires participation in a support rotation, including occasional weekend and off-hours work.

Key Responsibilities:

PostgreSQL/Azure:
- Architecture and Deployment Models: Understand different deployment options in Azure (Single Server, Flexible Server, Hyperscale) and their impact on performance, scalability, and management.
- High Availability and Disaster Recovery: Implement high availability solutions such as geo-redundant backups, automated failover, and read replicas to ensure business continuity.
- Security Features: Utilize Azure’s built-in security features, including encryption at rest and in transit, firewall rules, and role-based access control (RBAC) to protect data.
- Performance Tuning and Optimization: Leverage Azure’s monitoring tools and PostgreSQL’s native features like indexing, query optimization, and vacuuming to maintain optimal performance.
- Backup and Restore: Configure automated backups, understand point-in-time recovery (PITR), and manage backup retention policies to ensure data integrity and availability.
- Scaling and Resource Management: Manage compute and storage resources, scale up or down based on workload demands, and understand the cost implications of different resource configurations.
Snowflake:
- SQL Proficiency: Strong knowledge of SQL for querying and managing data within Snowflake.
- Data Warehousing Concepts: Understand data warehousing principles, including data modeling, ETL processes, and data integration.
- Cloud Computing: Familiarity with cloud platforms like AWS, Azure, or Google Cloud, as Snowflake operates on these infrastructures.
- Snowflake Architecture: Deep understanding of Snowflake’s unique architecture, including its multi-cluster, shared data architecture, and independent scaling of compute and storage resources.
- Performance Tuning: Skills in optimizing query performance and managing resources effectively within Snowflake.
- Security and Compliance: Knowledge of Snowflake’s security features and best practices for data protection and compliance.
- Data Migration: Experience with migrating data to Snowflake from other databases or data warehouses.
- Automation and Scripting: Proficiency in using SnowSQL (Snowflake’s command-line interface) and scripting languages like Python for automation.

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 https://jobs.iqvia.com

We are committed to providing equal employment opportunities for all, including veterans and candidates with disabilities. https://jobs.iqvia.com/eoe

IQVIA’s ability to operate and provide certain services to customers and partners necessitates IQVIA and its employees meet specific requirements regarding COVID-19 vaccination status. https://jobs.iqvia.com/covid-19-vaccine-status

The potential base pay range for this role, when annualized, is $105,800.00 - $176,300.00. The actual base pay offered may vary based on a number of factors including job-related qualifications such as knowledge, skills, education, and experience; location; and/or schedule (full or part-time). Dependent on the position offered, incentive plans, bonuses, and/or other forms of compensation may be offered, in addition to a range of health and welfare and/or other benefits.