Sr Datastore Admin at IQVIA. - Turkey

Hyderabad, Telangana, India -

Full Time

Start Date

Immediate

Expiry Date

19 Jan, 26

Salary

0.0

Posted On

21 Oct, 25

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Oracle, SQL Server, Database Administration, Disaster Recovery, Performance Tuning, SSIS, PL/SQL, Linux Shell Scripting, PowerShell Scripting, VB .NET, C# .NET, SSRS, Data Migration, High Availability, Mentoring, Database Backup

Industry

Hospitals and Health Care

Description

Job Overview This position will be approximately 25% Development DBA and 75% Production DBA work. Responsibilities include work on both Oracle and SQL Server platforms. Essential Functions • Provide 24x7 coverage for Database environment • Maintain database backups and perform test recoveries in SQL Server and Oracle environments. • Plan and test disaster recovery processes as they relate to the databases • Monitor and address database related application issues on production databases • Upgrade and maintain Oracle and related software (apply Oracle CPUs, upgrade database version) in coordination with IT staff • 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. • Software Development and Support • Design and create databases to support develop initiatives • Maintain development database environments for programming and new solutions teams • Refresh and cloning of production databases into test environments • Develop software to support development initiatives • Develop and co-develop (with the programming group) new applications • Consult on data access queries (SQL) for ad hoc analysis. • Configure and maintain different High availability options for either Oracle (oracle RAC) or SQL Server(Always ON, sql clustering) • Configure and maintain DB replicas for either oracle (dataguard, golden gate) or SQl Server (mirroring, log shipping) • Research various data migration techniques to efficiently migrate DBs from one DC to another for datacenter consolidation • Research and incorporate new features to improve DB services • Mentor junior/new DBA team members • May be required to manage a team of DBAs Qualifications • Bachelor's Degree • Experience with SQL Server versions 2005 to 2016 • Experience running and troubleshooting SSIS packages • Experience troubleshooting performance issues in the SQL Server environment • Experience with performance tuning on SQL Server 2008 R2 and SQL Server 2016. • Scripting and coding Pref • Linux shell scripting Pref • Perl scripting / programming Pref • PowerShell scripting Pref • VB and C# .NET programming • SSRS 2008 R2 and SSRS 2016 • Oracle Advanced • Oracle Enterprise Edition (11g and 12c) running on Oracle Enterprise Linux 7 Advanced • Oracle Enterprise Manager Advanced • ASM Advanced • PL/SQL • Package writing and maintenance • Materialized Views • Message Queue/Advanced Queueing/AQ • RMAN Advanced • Knowledge of installing ORACLE CPUs Intermediate • TOAD and Oracle Enterprise Manager • Experience with SQL Server versions 2005 to 2016 Advanced • Experience running and troubleshooting SSIS packages Intermediate • Experience troubleshooting performance issues in the SQL Server environment Advanced • Experience with performance tuning on SQL Server 2008 R2 and SQL Server 2016. Advanced • Scripting and coding Intermediate • Linux shell scripting Intermediate • Perl scripting / programming Intermediate • PowerShell scripting Intermediate • VB and C# .NET programming • SSRS 2008 R2 and SSRS 2016 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 a leading global provider of clinical research services, commercial insights and healthcare intelligence to the life sciences and healthcare industries. We create connections that accelerate the development and commercialization of innovative medical treatments. Everything we do is part of a journey to improve patient outcomes and population health worldwide. To get there, we seek out diverse talent with curious minds and a relentless commitment to innovation and impact. No matter your role, everyone at IQVIA contributes to our shared goal of helping customers improve the lives of patients everywhere. Thank you for your interest in growing your career with us.

How To Apply:

Incase you would like to apply to this job directly from the source, please click here

Responsibilities

The Sr Datastore Admin will provide 24x7 coverage for database environments, maintaining backups and performing test recoveries for SQL Server and Oracle. Responsibilities also include monitoring production databases, upgrading software, and supporting development initiatives.