SQL Server DBA

Application deadline date has been passed for this Job.
Full Time
  • Post Date: May 7, 2020
Job Description

The client is a global company with one of the most recognized and admired brands in the world. They have become the world’s largest package delivery company and a leading global provider of specialized transportation and logistics services. Every day, they manage the flow of goods, funds, and information in more than 200 countries and territories worldwide.

FPT currently provides L2 and L3 support services to the client. Daily we receive tickets for particular applications’ issues and help resolve them as early as possible. We also maintain the system, verify data flows and ensure data integrity as well as system performance and stability.

 

Responsibilities/ Daily tasks you will take care:

Services support

  • Monitor services and applications across multiple servers and environments. Ensure that all services and applications are up and running smoothly
  • Create alert for solution or service if needed as SQL job.

Database support

  • Monitor all alerts from SQL servers, check and make sure all jobs in SQL server running successfully.
  • Correct code issues in job or SSIS package via documentation of error, correct code via handover with DB development team.

Data support

  • Ensure all Billing files and Tracking files from customer or other team are injected into database successfully.
  • Modify the input file, SQL code or SSIS package when needed to ensure data is processed for solutions.
  • Data related issue for the web applications that the end users use.

Reports

  • Ensure all reports (daily, weekly or month) are generated on time and correctly, any complaint from client, other team, or job failure, dig into data or code to find out the reason and fix it in data side or code side (report for customer solution or internal use)

 

Requirements/ Desired skills and experience

Candidates are required to have the following skills:

  • Strong command of SQL and SQL Server features/tools
  • Advanced knowledge of database security, backup and recovery, and performance monitoring using tools or scripts
  • Familiarity with SSAS, SSIS, SSRS
  • Good written and verbal English communication skills

These are nice to have:

  • Experience in T-SQL programming, including Stored Procedure, Function, Trigger, etc…
  • Experience with migration from external data sources into SQL Server
  • Have hands-on experience on setting up database HA/DR architecture
  • Have understanding on improving database security using various techniques like database hardening or transparent data encryption

 

Benefits:

  • “FPT care” health insurance provided by AON and is exclusive for FPT employees.
  • Annual Summer Vacation: follows company’s policy and starts from May every year
  • Salary review yearly or on excellent performance
  • International, dynamic, friendly working environment
  • Onsite in Korea long-term and short-term opportunities
  • Annual leave, working conditions follow Vietnam labor laws.
  • Other allowances: lunch allowance, working on-site allowance, etc.