Database Administrator

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. Requirements Qualification: 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. Continuous Improvement: 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 continuous improvement. Technical Proficiency: Strong coding skills in SQL, R, and/or Python, coupled with expertise in machine learning techniques, statistical analysis, and data visualization. Agile Champion: Adherence to DevOps principles and a proven track record with CI/CD pipelines for continuous delivery.