This job posting may have expired!
Use our `search` to find similar offers.
Similar jobs

Senior Azure SQL Database Administrator - DBA

IQVIA Holdings Inc.

Primary Location: Buenos Aires, Argentina
Additonal Locations: Marietta, GA,USA; Mexico City, Mexico,MEX

Job Overview

Senior Azure & On Prem MS SQL Database Administrator will be responsible for the management of production and non- production databases; database maintenance activities; troubleshooting database-related issues; monitoring of database capacity and performance; installation, administration, and configuration of database server/instances/databases; installation and configuration of SSRS; Support release/code deployment activities (SSIS Packages, SSRS reports, SQL objects etc) 

*CV must be sent in English*

Essential Functions

  • Conduct the following for Azure SQL/Azure SQL MI/SQL on Azure VM, On Prem SQL Server, SSRS, SSIS, Azure Synapse and other related products as applicable and necessary
  • Install/Configure/Setup/Administer and Maintain production and non-production environments
  • Setup High-Availability and Disaster Recovery 
  • Plan and test high availability and disaster recovery  
  • Create Users and assign/manage permissions based on the level of access the user would need; ensure robust and full proof security of assets 
  • Resolve database integrity, performance, blocking, connectivity, and replication issues.
  • Detect and resolve database-related CPU, memory, I/O, disk space and other contention issues.
  • Perform and manage Database backup/recovery/restore and capacity monitoring
  • Synapse workload management and optimization
  • Setup SQL agent jobs, elastic jobs and runbook automation
  • Identify and setup alerts and logging in Azure 
  • Maintain databases – Statistics, Indexes, fragmentation
  • Upgrade and maintain SQL Server and related software (apply patches and updates when necessary)
  • Coordinate removal and/or archiving of data that is no longer required to be available in the production databases.
  • Deploy and configure SSIS packages and SSRS Reports. Troubleshoot issues with SSRS and SSIS. 
  • Support release/code deployment activities
  • Provide 24x7 support as necessary
  • Implement operational automation using scripts.
  • Conduct Performance tuning and optimization (Stored procedures, Views, Functions, Queries, database) - In-depth SQL database advanced performance tuning experience – Stored Procedures, Views, Functions; skilled in analyzing and assessing query execution plans and DMVs; expertise in assessing and implementing indexes and partitioning; Tuning ETL Jobs - SSIS & Azure Data Factory
  • Design and create databases to support development initiatives
  • Synapse workload management and optimization

Qualifications

  • Bachelor's Degree or related working experience
  • Experience in HA/Failover technologies
  • Experience in log shipping and DR Environments
  • Experience with DataSync in Azure and other technologies used in replicating data
  • Strong Experience in Performance Tuning and Optimization (PTO)
  • Experience with SQL Server versions 2005 to 2019 
  • Experience running and troubleshooting SSIS packages
  • Experience troubleshooting performance issues in the SQL Server environment
  • Good verbal and written communication is a must have.
  • Advanced level of English.

Q² Solutions is a leading clinical trial laboratory services organization with end-to-end laboratory services and secure, enterprise-wide biospecimen and consent management solutions. https://q2labsolutions.com/careers

Job posted: 2023-06-03

3