Database Architect - Up to 200K - Hybrid BGC

weSource Management Consultancy Firm; Taguig; Hybrid; PHP 2,031,120 - 2,432,880; Full time

Job summary

A consulting firm in Taguig is looking to hire a Database Architect to support their client-facing products. This role involves designing and developing databases, evaluating existing structures, and collaborating with product teams to ensure high performance and stability. Ideal candidates should have strong expertise in database technologies and design, along with excellent communication skills. This position offers a hybrid work environment and competitive compensation up to 200K monthly gross.

Qualifications

• 3+ years of relevant experience in Database Design.
• Strong experience with relational databases and big data.
• Ability to develop database strategies for reporting.

Responsibilities

• Design and develop Databases and Data Warehouses.
• Evaluate and improve existing database structures.
• Work with product management to translate requirements into designs.

Skills

Database design

SQL development (TSQL, Views, Stored Procedures)

Data Analysis

Data Modeling

Data Warehousing

Azure SQL and Azure Technologies

Big Data

Excellent verbal and writing skills

Education

Bachelor's degree

Tools

Microsoft SQL Server

Oracle

Azure Data Factory

Azure Databricks

Job description

Database Architect - Up to 200K - Hybrid BGC

About the job Database Architect - Up to 200K - Hybrid BGC

We are hiring for a Database Architect for a client located inBGC. This is a hybrid work following a Day Shift Schedule and pays up to 200K per month gross salary

The Requirements

• Bachelors degree and 3+ years of related experience.
• Strong experience in databases, tools and methodologies
  • Microsoft SQL Server, Oracle
  • Azure Technologies such as Azure SQL, Azure Data Factory, Azure Storage, Azure Data Lake, Azure Synapse, Azure Databricks, Unity Catalog, Azure Purview
  • Data Analysis, Data Modeling, Data Integration, Data Warehousing, Data Lakehouse, Database Design, Big Data, In Memory, No SQL
• Experience with database performance evaluation and remediation
• Develops strategies for data acquisitions, archive recovery and implementation
• Be able to design and develop Databases, Data Warehouses and Multidimensional Databases
• SQL development experience (TSQL, Views, Stored Procedures, Indexes.)
• Experience working with large relational databases, big data, structured and unstructured data sets
• Ability to develop database strategies for flexible high performance reporting and business intelligence
• Excellent verbal and writing skills, including the ability to research, design, and write new documentation, as well as to maintain and improve existing material
• Some functional knowledge in one or more of the following areas is a PLUS: Talent Management Systems, HR Self-Service, HR Shared Services, HRIS/Payroll, Health & Welfare Administration or Pension Administration, HR Survey systems

The Role

As a Database Architect you will play a key role in supporting the companie'sclient facing products. These products include high concurrency highly transactional systems as well as big data systems with complex reporting and business intelligence requirements. The Database Architect will evaluate and improve existing database structures and play a crucial role in creating evolutionary database models for current and future products.

The Database Architect will be required to analyze an array of product offerings and business requirements within the organization. You will work with the product development teams (e.g. engineering, product managers and analysts) to evaluate and identify solutions that meet the needs of the business, utilizing industry standard best practices and creative design techniques to overcome complex business and technical challenges (e.g. maximum performance with complex data sets). Some additional responsibilities include but are not limited to:

• Work with the Senior Database Architect to define database architectures and communicate those designs to business and engineering partners
• Analyze existing data design and suggest improvements that promote performance, stability and interoperability.
• Work with product management and business subject matter experts to translate business requirements into good database design.
• Provide database architecture leadership and mentor projects consisting of TW employees and outside contractors
• Maintain the governance model on the database architecture through training, design reviews, code reviews, and progress reviews.
• Participate in the development of Database Architecture and Roadmaps in support of business strategies
• Establish and maintain database architecture standards and best practices
• Participle in the evaluation of emerging technology and tools