• Provide expert advice and assistance in various areas related to database technology • Oversee the administration of all database services in ICT environments • Ensure seamless integration with specific applications • Continue improvement and optimization of requests from applications to database systems • Advise and assist developers in best practices for interfacing with and querying databases • Conduct security studies and assessments related to ICT applications • Review Information Systems Database Architectures

• Administer Amazon Aurora MySQL (OLTP) and Amazon Redshift (OLAP) • Manage full lifecycle: provisioning, configuration, patching, upgrades • Ensure high availability, backup/recovery, and disaster resilience • Configure alerts, logging, and proactive health checks • Monitor and optimize performance for high-throughput transactional workloads and ETL and analytics queries • Support production databases with on-call / incident response • Perform root cause analysis (RCA) and implement fixes • Troubleshoot performance and data issues • Manage user roles, permissions, and RBAC • Ensure compliance with data security and audit requirements • Support databases used by application services, ETL pipelines, reporting and BI tools • Collaborate with engineering teams on schema and data design • Work with DevOps teams on infrastructure changes and deployments • Automate operational tasks using scripting and IaC (Terraform / CloudFormation)

• Manage and maintain our PostgreSQL, DynamoDB and Athena databases running on AWS Cloud, ensuring high availability and reliability. • Monitor the performance and overall health of our databases, proactively identifying and resolving the issues. • Design and implement growth strategies for our databases, ensuring they can handle the rapidly increasing demands of our organization. • Develop, implement and maintain very high security standards to protect our highly sensitive PHI data from both external and internal threats. • Ensure compliance with various database privacy regulations and frameworks like HIPAA, SOC2 etc. • Design and implement Business Continuity Plan(BCP) and Disaster Recovery(DR) Plan. • Develop and maintain a pipeline to restore anonymized data from production to the lower environments. • Work closely with the security team to develop comprehensive risk analysis and response for data infrastructure. • Collaborate with development, architecture, and release teams providing architectural design recommendations to effectively adapt the database environment to support new platform features and capabilities. • Work closely with the Data Engineering team to build, maintain and troubleshoot ETL jobs for downstream applications. • Support software development teams to drive proper coding practices and assist in the development of complex queries, tuning of DML.

**What Your Day Might Look Like:** - **Keep systems running**: Monitor, maintain, and support MS SQL Server environments, including high-availability setups (e.g. Availability Groups). - **Solve real issues**: Troubleshoot performance and availability problems, identify root causes, and prevent them from happening again. - **Optimize performance**: Handle tuning, indexing, and automation to keep databases efficient and scalable. - **Ensure resilience**: Manage backup and recovery processes to guarantee data integrity and disaster readiness. - **Maintain security**: Apply patches, manage upgrades, and enforce database security best practices. - **Support operations**: Respond to incidents and support requests, ensuring minimal disruption to business operations. - **Work across technologies**: Contribute to projects involving other database systems (e.g. MongoDB, CockroachDB). - **Operate in the cloud**: Support and optimize cloud-based database environments (primarily Azure).