**Who We Are**
MIMS is Asia-Pacific's leading multi-channel provider of trusted, quality medical information, medical education, and knowledge services connecting healthcare communities.
Our work empowers healthcare professionals to improve patient outcomes by facilitating knowledge exchange and better decision-making.
Today, MIMS has a strong regional presence in 17 countries and regions across Asia-Pacific with approximately two million healthcare professionals subscribed to its drug & resource portal, digital and print publications.
We provide solutions to leading pharmaceutical companies and established healthcare institutions across the world.
**Who We are Looking For**
We are looking for a talented, motivated, and passionate engineers with a strong technical background to join the MIMS Marketing Platform Team.
As a Cloud DB Administrator, you will be a significant contributor to the Marketing Platform team as you manage and handle the DB governance for MIMS.
**What Impact You Will Make**
- Be responsible with the MIMS DB Governance together with the MPF IT Director and Cloud Architect
- Support the MPF business in designing database and procuring DB-related resources for new and existing products
- Automate the build, operation, backup, restore, and monitoring of databases used with MIMS digital platforms
- Develop and evaluate database infrastructure performance criteria and measurement methods
- Support day-to-day operations and management of an enterprise level production database in the cloud
- Monitors and audits user access and performance of the databases and its systems
- Be part of DevOps team that supports every process in the CI/CD
- Create, manage and advocates DB policy and guidelines, which includes the best practices and possible technologies and tools for cloud database operations
- Develop and maintain script or tool that can be used to generate report, crawl data and/or sync data from one database to another or to MS Access/Excel
- Creates and maintains documentations relevant to our digital asset's database and systems
- Configure Azure SQL Database for scale and performance
- Evaluate database partitioning techniques, such as database sharing
- Evaluate offline or online data migration strategies
- Configure database access management by using platform and database tools
- Implement security for data in transit and at rest
- Implement compliance controls for sensitive data
- Evaluate and implement an alert and notification strategy
- Plan and implement sizing and scaling for a database created with Azure Cosmos DB
- Plan and Implement a High Availability and Disaster Recovery (HADR) Environment
- Design database in code-first and database-first approaches with Entity Framework Core
- Implement a DevOps process for Azure SQL Database and Azure Cosmos DB solutions
- Automate database deployments with Terraform as part of Infrastructure of Code transformation
**What Skills and Experience You will Bring**
- Degree in Data Science, Computer Science, or Information Technology
- Must have had at least 5 years of working experience
- Strong and solid experience of Azure SQL Database administration and Azure CosmosDB governance
- Experience writing and executing stress tests on databases and services
- Experience in troubleshooting and resolving database problems
- Very good knowledge of indexes, index management, statistics, data-at-rest encryption, secure connectivity
- Having basic knowledge of modern data warehouse solutions, like: Azure Data Lake Storage Gen2, Azure Synapse Analytics, Azure Databricks, and Azure HDInsight
*
- Experienced in automating data (schema) migration process with Azure Web Jobs, Azure DevOps or GitHub Actions
- Programming language required: T-SQL, C#, YAML, and PowerShell.
- It will be more advantageous, if you know Google Analytics, Firebase, and Microsoft Power BI.
- Strong analytical and problem-solving skills, self-motivated and proactive approach
- Possess good communication skills and a strong team player
- Must be a team player and able to work independently as well
- Demonstrate understanding or keen interest in latest database technologies and best practices
- _DP-900: Microsoft Azure Data Fundamentals certified is a must_
- _DP-300: Administering Relational Databases on Microsoft Azure certified, will be a plus_
- _DP-420: Designing and Implementing Cloud Native Applications Using Microsoft Azure Cosmos DB certified will be a plus_
**Job Type**: Permanent
**Salary**: Php45,000.00 - Php50,000.00 per month
Schedule:
- 8 hour shift
Ability to commute/relocate:
- Makati City: Reliably commute or planning to relocate before starting work (preferred)