Database Administrator

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.

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 culture of