Don't miss any news or updates from BestJobs

Not now Allow
  • Description



  • Essential Job Responsibilities:

    Beginning with the most important, or in a logical sequence, describe 5 to 7 major responsibilities of this job. Provide detail as necessary to give an accurate, complete outline. Indicate the percentage of total working time spent on each essential responsibility. The total should equal 100%.

    Responsibilities include, but are not limited to:

    Responsibility #1 –SQL Database engineering and support (40% time)

    - Performs MS SQL administration and support to achieve stability, performance, security and data integrity

    - Resolves database performance issues, database capacity issues, replication, and other distributed data issues

    - Writes T-SQL Statements using MS SQL– (data derived from multiple large databases, spanned across multiple servers)

    - Creates and maintains intelligent Extraction, Transformation and Load focus on efficiency and resource optimization

    - Develops database relationships maps that describe data in basic terms to business users

    - Reengineers databases and data processes to reduce complexity to leverage existing global solutions such Salesforce, Power BI, Reporting Services and SAS

    - Administers, develops and maintains policies, standards, procedures and comprehensive documentation to ensure security and integrity of all SQL databases

    - Remediates security vulnerabilities on the databases environment

    Responsibility #2 Data Services (40% time)

    - Maintains and support Power BI, SQL Reporting Services, In-House Legacy Reporting systems

    - Identifies, designs, maintains and implements internal process improvements: automates manual processes, optimizing data delivery, re-designs infrastructure for greater scalability.

    - Assembles large, complex data sets that meet functional / non-functional business requirements

    - Translates Business requirements into Power BI, SQL Reporting Services solutions

    - Supports systems data integrations with Salesforce, Legacy Applications and various systems, including third party systems integrations

    - Develops documentation with regards Data Services for functional and non-functional scenarios

    - Ensure data is consumed according data classification company standards and regulatory requirements

    Responsibility #3 In-House Legacy Applications support (15% time)

    - Support .NET, #C VB code of Legacy three-tier applications

    - Resolves application issues, implements small changes ensuring adherence to compliance

    - Tests and deploys applications and systems changes

    - Develops documentation throughout the software development life cycle (SDLC)

    - Maintains and supports SSL Certificates lifecycle for internal and external applications and systems ensuring systems uptime and security according to company standards

    - Remediates security vulnerabilities on the applications environment

    - Develops and maintain applications documentation including functional and non-functional requirements, use cases, system architecture, programming documentation and maintains source code of the In-House Legacy Applications

    Minimum Requirements and Qualifications:

    Training requirements

    - MS SQL Server Database Administration qualification

    - .Net Framework, C# , HTML5 and Visual Basic Developer certification is desired

    - ITIL Service Management experience or qualifications or experience desired

    Knowledge and skills:

    - Analytical skills: Database Engineer must monitor the database performance and evaluate complex information coming from a variety of sources

    - Detail oriented: Working with a database requires the administrator to have an understanding of complex systems, and how a minor error can cause major problems. For example, if customer credit card information is mixed up, it can cause a Compliance and regulatory deficiency.

    - Communication skills: Database Engineer must communicate effectively with managers, developers, and other partners

    - Teamwork: Database Engineer must work effectively with various IT functions to meet the role objectives and delivery quality work

    - Problem-solving skills: Database Engineer must troubleshoot and resolve complex problems

    - Time management and prioritization: Database Engineer must Effectively manage day-to-day tasks to provide support while meet data solution deliverables on schedule for projects

    - Customer oriented: Database Engineer will provide IT Services to the business and is expected to build good and strong relationships with the business users

    - Proactivity: Database Engineer analyzes and evaluates Data Solutions and Application for reengineering to ensure the systems are healthy and most adequate systems are used and provide recommendations to transform the business

    Technical Skills:

    - Excellent knowledge of MS-SQL 2008 onwards, SQL design and architecture

    - SQL Reporting Services and Power BI

    - Strong knowledge of Microsoft Internet Information Service (IIS)

    - Familiarity working with .NET Framework, C# , HTML5 and Visual Basic

    - Familiarity with architecture styles/APIs (REST, RPC)

    - Hands on experience developing TSQL scripts

    - Hand on experience on Data Extraction, Transformation, and Loading

    - Knowledgeable on security involved components, SSL Certificates, Authentication, Data Encryption, Secure FTP, Database encryption, encryption keys management, etc

    Job experience:

    - Minimum 5 years of relevant experience in SQL Administration, SQL architecture, Data Extraction, Transformation, and Loading processes and SQL Reporting services

    - Minimum 2 years of experience on supporting .NET Framework, C# , HTML5 and Visual Basic applications

    - Minimum 2 years of experience on Data Services delivering non-functional data solutions to the business using Power Bi or other Business Intelligence tools

  • Requirements

  • Minimum education level: Bachelor´s Degree
  • Years of experience: 5
  • Knowledge: SQL Server
  • Availability for travel: No
  • Availability for change of residence: No

Similar jobs

Full Time - Permanent contract - Negotiable -

Full Time - Permanent contract - Negotiable -

Home Based - Permanent contract - ₱ 100,000.00 monthly -

machinist

23 September

Full Time - Permanent contract - Negotiable -

Get new jobs on Facebook Messenger

Send to Messenger

Job summary

  • IT Database Engineer

  • Pampanga, Central Luzon

  • Company

    WYNDHAM SERVICES ASIA PACIFIC PHILIPPINES INC
  • Type of contract

    Permanent contract

  • Work type

    Full Time

  • Apply