Job has been saved to your Account Portal!

IT Database Engineer

Job Description

  • Design, develop, install, and support all databases (70% Microsoft SQL and 30% Oracle) to support Business Unit and Application Development, both in clustered and stand-alone environments leveraging virtual infrastructure
  • Build and support AWS RDS using Terraform in compliance to AWS Well-Architected Framework.
  • Execute recurring and timely SQL server maintenance to ensure consistent and reliable database environment
  • Monitor and fine tune databases and performance issues as required, this includes proactive monitoring of application SQL to recommend improvements and query optimization
  • Implement and manage high availability solutions such as Always On Availability Groups, log shipping, mirroring, or other technologies
  • Responsible for identifying and implementing improvements to databases to optimize performance
  • Maintain backup/recovery processes and maintenance to ensure recovery timelines are met and assist development in lower environmental restores
  • Monitor and troubleshoot issues with all SQL Server stack products (i.e. SQL Server, SSRS, SSIS, SSAS, etc.)
  • Fluent understanding of database instance maintenance tasks (i.e. DB Integrity Checks, Index Maintenance, etc.) and how to resolve
  • Advise developers on the most efficient database design (tables, data types, stored procedures, etc.)
  • Using profiler trace and other tools to find most frequently ran queries and help resolve issues with those queries
  • Automate and support deployments to different environments
  • Develop and maintain logical and physical database models
  • Install and configure new SQL Server Database Instance to specified guidelines or 3rd party application requirements
  • Build and maintain documentation related to the company’s database environment
  • Review and test database changes, including patches, prior to production deployment in accordance with Change Management practices
  • Investigate and resolve problems related to SQL Server and/or client issues.
  • Configure and manage Linked Servers, data transfer between SQL Server and other heterogeneous relational databases
  • Manage, provision database access and secure data using ABAC, RBAC mechanism to comply HIPAA regulations and align with client’s Business Associate Agreement.
  • Own problems and see to resolution, including when outside support is needed from other teams or outside vendors
  • Maintain the integrity and security of databases, including administration of database access roles and least privilege and performing database auditing tasks
  • Maintain and implement secure databases environments and backups using appropriate encryption at rest and in transit
  • Ensure HIPAA and HITECH compliance of the database environment and participate in third party audits
  •  

    Qualification

    Must Haves:

    • Have at least 2 years of database management

    • Strong knowledge of SQL for managing and querying databases.

    • Knowledge of backup strategies, data recovery techniques, and disaster recovery plans.

    • Ability to optimize database performance, troubleshoot performance issues, and manage indexing and query optimization.

    • Familiarity with database security practices, user management, encryption, and access control.

    • Understanding of database replication, clustering, and high-availability solutions.

    • Skills in designing and managing database schema, relationships, and structures to optimize performance and maintainability.

     

    Good to have:

    • Experience with Large-Scale databases.

    • Handles projects related to Data Warehousing

     

    About The Hospitals and Health Care

    Hospitals and Healthcare is a leading provider of performance management analytics, consulting, extended business office, and revenue recovery services to the healthcare industry.

    IT Database Engineer

    Hospitals and Health Care

    Pasig City

    Visit Profile

    Salary

    80,000-110,000/month

    Position Level

    Staff

    Job Level

    Experienced Hire

    Job Type

    Full Time

    Hiring Until

    03/30/2025