Talent.com
SENIOR DATABASE ENGINEER

SENIOR DATABASE ENGINEER

Hammerjack Pty LtdQuezon City, Metro Manila, Philippines
1 day ago
Job description

Overview

Your Role :

The Senior Database Developer is responsible for designing, developing, and implementing sophisticated database solutions that drive our business forward. Your expertise will not only contribute to the development of efficient, scalable, and reliable PL / SQL applications but will also help shape the future of our data management practices. The Senior Database Developer is responsible for production support of all software and integrations developed by the Software Engineering teams, including but not limited to EDI, XML and flat file integrations, managed file transfers, and database integrations, web applications, and APIs. The Senior SQL Developer is also responsible for creating new integrations or making changes to existing integrations in accordance with the engineering teams coding standards and best practices.

Main Activities and Responsibilities :

Management and Support of Database Solutions :

  • Perform optimization and tuning to support high transaction volume, complex query workloads, and improve overall database performance.
  • Identify and resolve performance bottlenecks in SQL Queries and database operations.
  • Perform regular database maintenance tasks, including backups, restoration, and upgrades while ensuring minimal downtime.
  • Establish and maintain robust database security practices, including but not limited to role-based access controls, encryption, and vulnerability assessments.
  • Quickly address database-related incidents and provide long-term solutions to prevent recurrence.
  • Uphold best practices in code health, testing, and maintainability.
  • Provide 3rd level escalation for production support issues and customer concerns.

Process Automation Design and Application Builds :

  • Design, develop, and optimize PL / SQL programs to meet business requirements and project timelines.
  • Conduct thorough testing and debugging of PL / SQL procedures to ensure performance and reliability.
  • Design and implement data integration solutions to extract, transform, and load data from various sources into the database.
  • Perform data analysis, mapping, and create migration plans for projects involving application and database migration.
  • Develop ETL processes to ensure data quality, consistency, and accuracy.
  • Implement data integration solutions to synchronize data across different systems.
  • Work with stakeholders to understand data requirements and design scalable ETL workflows.
  • Collaborate with cross-functional teams to gather requirements, design logical and physical database structures, and ensure data integrity and security.
  • Analyze and predict future database capacity requirements and proactively plan for scalable solutions.
  • Implement monitoring, logging, and observability solutions to oversee system performance, troubleshoot issues, and seek opportunities for improvement.
  • Document and maintain comprehensive database logs and records regarding system modifications and updates.
  • Document database designs, schemas, and processes to ensure knowledge
  • Create a job alert for this search

    Senior Engineer • Quezon City, Metro Manila, Philippines