Source description
About the role
Astellas Global Capability Centres GCCs are strategically located sites that give Astellas the ability to access talent across various functions in the value chain and to co-locate core capabilities that are currently dispersed Our three GCCs are located in India Poland and Mexico The GCCs will enhance our operational efficiency resilience and innovation potential enabling a timely response to changing business demands Our GCCs are an integral part of Astellas guided by our shared values and behaviors and are critical enablers of the company s strategic priorities sustainable growth and commitment to turn cutting-edge science into VALUE for patients www astellas com This is a hybrid position and is based in Bangalore India At Astellas we recognize the importance of work life balance and we are proud to offer a hybrid working solution allowing time to connect with colleagues at the office with the flexibility to also work from home We believe this will optimize the most productive work environment for all employees to succeed and deliver Hybrid work from certain locations may be permitted in accordance with Astellas Responsible Flexibility Guidelines Purpose and Scope As a Database Administrator you will play a crucial role in ensuring the quality and reliability of our pharmaceutical data systems Your expertise in testing methodologies data validation and automation will be essential in maintaining high standards for our data solutions You will play a pivotal role in building maintaining and enhancing our data systems across the organization This is a fantastic global opportunity to use your proven agile delivery skills across a diverse range of initiatives utilize your development skills and contribute to the continuous improvement delivery of critical IT solutions Essential Job Responsibilities Database Management Install configure and upgrade database software on AWS and Azure Monitor performance optimize queries and conduct regular tuning Backup and Recovery Implement and test robust backup and recovery strategies Security Measures Establish and maintain database security including access controls and encryption Collaborate with security teams to ensure compliance Cloud Integration Migrate and replicate data across AWS and Azure platforms High Availability and Scalability Ensure database availability and scalability with failover mechanisms and load balancing Collaboration Work with development teams system administrators and network engineers Participate in cross-functional teams for database design and optimization Technical Support Provide Level 3 and 4 technical support troubleshooting complex issues Qualifications Required Bachelor s or Master s degree in computer science Information Technology or related field Certifications if applicable AWS Certified Database - Specialty or Microsoft Certified Azure Database Administrator Associate 1-3 years proven experience as a Database Administrator Background in pharmaceutical or healthcare domains is advantageous Database Technologies Proficiency in relational MySQL PostgreSQL SQL Server and NoSQL MongoDB Cassandra databases AWS Experience with AWS environments RDS and CI CD methodologies Microsoft Azure Knowledge of Azure services cloud-native databases and integration services SQL Expertise Strong skills in SQL for data manipulation and query optimization Python and Pyspark Proficiency in Python and familiarity with Pyspark for big data testing Data Validation Ability to validate data transformations and understand data lineage Leadership Skills Prior experience leading testing teams or projects Excellent communication and collaboration skills Experience in Agile development environments sprint planning stand-ups retrospectives Familiarity with cloud platforms AWS Google Cloud and their data services Analytical thinking to identify performance gaps and promote continuous improvement Adherence to DevOps principles and CI CD pipelines Business Requirements Ability to understand and interpret business requirements Translate them into technical requirements Data Strategy Contribution Identify data-driven insights and improvements Collaborate with cross-functional teams Technical Support Troubleshoot complex issues for internal users Ensure system uptime Optimize existing data and platform architecture Manage FoundationX backlog Stay informed about data engineering and cloud trends Preferred Subject Matter Expertise possess a strong understanding of data architecture engineering operations reporting within Life Sciences Pharma industry across Commercial Manufacturing and Medical domains Other complex and highly regulated industry experience will be considered across diverse areas like Commercial Manufacturing and Medical Data Analysis and Automation Skills Proficient in identifying standardizing and automating critical reporting metrics and modelling tools Analytical Thinking Demonstrated ability to lead ad hoc analyses identify performance gaps and foster a