Datastore Admin

Job Overview
Under general supervision, manage and maintain database systems, including back-up, performance tuning, capacity planning, monitoring, and reporting critical events and documentation. This hands-on role requires strong technical expertise combined with effective communication and interpersonal skills.

Essential Functions

• Provision MySQL/MariaDB, MSSQL instances, both in clustered and non-clustered configurations, and manage HA groups.  

• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

• Manage Production, QA, and development database environments.  

• Learn relevant business processes and understand the data flow, criticality, and dependencies.  

• Minimize database downtime and manage parameters to provide fast query responses.  

• Enroll users, maintain system security, and monitor user access to databases.

• Database version upgrades and security patching to comply with security.  

• Allocate system storage and plan storage requirements for database systems.  

• Refine and automate regular processes, track issues, and document changes.  

• Perform periodic health checks and reports on database systems.  

• Develop innovation, strategies, processes, and best practices.

• Configure and maintain Amazon Redshift clusters.  

• Troubleshoot and resolve database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log issues, connectivity issues, and security issues.

Qualifications

• Bachelor's degree or equivalent in Computer Science, Information Technology, or a related field

• Candidates with 1+ year relevant experience in Database Administration are preferred. 

• Good knowledge of database design, administration, and architecture  

• Knowledge of replication and cluster configuration in MySQL/MariaDB, MSSQL

• Knowledge of MSSQL high availability configuration and monitoring  

• Understanding of backups, restores, and recovery models  

• Strong knowledge of stored procedures and query optimization  

• Knowledge and understanding of all aspects of database tuning: software configuration, memory usage, data access, data manipulation, SQL, and physical storage  

• Ability to develop procedure documents and maintain detailed database-related documents  

• Good analytical, time management, troubleshooting, and decision-making skills

• Excellent written and verbal communication skills

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

IQVIA is committed to integrity in our hiring process and maintains a zero tolerance policy for candidate fraud. All information and credentials submitted in your application must be truthful and complete. Any false statements, misrepresentations, or material omissions during the recruitment process will result in immediate disqualification of your application, or termination of employment if discovered later, in accordance with applicable law. We appreciate your honesty and professionalism.