Senior Database Administrator (MS SQL, SQL Server, Business Intelligence)

CÔNG TY TNHH MỘT THÀNH VIÊN TEK EXPERTS
16 FL, East Wing, Lotte Center, 54 Lieu Giai, Ba Dinh, Hanoi
Ha Noi
Salary: Negotiable
MS SQL SQL Server Business Intelligence

Technologies We're using

C++
SQL
.NET

What You’re In Charge?

The prospective employee is responsible for providing operational and engineering database support includes resolving SQL Server database-related incidents and administering our Development, Quality Assurance, Staging, Pre-Production and Production platforms.
Alongside this the candidate will create and maintain service-related reports (such as database backups,
maintenance, monitoring, and ETL status) and respond to database-related alerts and escalations.


Responsibilities:

  • Administer and maintain our company database environments and provide day-to-day operational support;
  • Provide thorough leadership, advice and guidance to the development team on areas of issue and implementation of improvement;
  • Provide inputs in setting governance and standards related to all aspects of our environments;
  • Reduce the frequency and duration of IT database failures;
  • Perform ongoing tuning of database instances;
  • Build and provide actionable reports in support of performance testing to be submitted to all development areas to review and provide follow up actions to ensure optimum support to meet our SLAs;
  • Provide problem and root cause analysis data to the IT support organisation through capacity management tools and techniques;
  • Plan and implement backup and recovery of Microsoft SQL Server databases in all our environments;
  • Control migrations of database changes through the development life cycle;
  • Perform database reorganisations to assist performance and ensure uptime of the database;
  • Put standards in place to ensure that all application database design and code is produced with proper integrity, security and performance.

Key accountabilities:

  • Perform reviews on the design and code frequently to ensure the site standards are being adhered to;
  • Evaluate releases of Microsoft SQL Server and its tools, and third-party products to ensure that the enterprise is running products that are most appropriate;
  • Plan with the developers and system administrators to ensure that new product usage or release upgrades take place with minimal impact;
  • Provide technical support to all the development teams;
  • Upgrade and apply service packs/critical fixes in all our database environments;
  • Assist with impact analysis of any changes made to the database objects;
  • Troubleshoot with problems regarding the databases, applications and development tools;
  • Create new database logins and users as required - manage sharing of resources amongst applications;
  • Contribute to architecture and capacity planning activities - perform root cause analysis on failed components and implements corrective measures;
  • Provide ongoing information to leadership and peers regarding enhancements, innovations and solutions;
  • Follow company specific systems engineering standards;

What We’re Searching?

Qualifications:

  • The ideal candidate will have a degree relevant to Information Technology/Computer Science, Engineering (or equivalent);
  • Minimum 6 years’ experience with database administration using Microsoft SQL Server;
  • Minimum 6+ years' experience with administering and maintaining Microsoft Bl solutions;
  • Experience with administering databases greater than 5 TB;
  • Experience in troubleshooting and resolving problems (performance issues, database integrity issues, blocking and deadlocking issues);
  • In depth understanding of Dimensional Modeling and Data Warehouse design;
  • Experience in MS SQL Business Intelligence Stack (SSIS, SSAS and SSRS);
  • Solid understanding of MS SQL DBMS and T-SQL;
  • Experience deploying ETL processes to a central environment;
  • Experience in Performance Tuning and Optimisation (PTO), using native monitoring and troubleshooting tools;
  • Experience with Microsoft SQL Server backup and recovery scenario;
  • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for Microsoft SQL Server including failover clustering, log shipping, and Microsoft SQL Always On;
  • Experience with Microsoft SQL Server replication;
  • Experience in implementing operational automation using scripts;
  • Knowledge of indexes, index management, and statistics;
  • Excellent communication and documentation skills.
  • Good English language skills (both spoken and written);

Best About This Position

Competitive salary & performance bonus
Opportunities to work with the world’s leading IT companies
Summer trip, year-end party, team building activities
A collaborative and dynamic working environment
Flexible working schedule

CÔNG TY TNHH MỘT THÀNH VIÊN TEK EXPERTS

Why Tek Experts?We at Tek Experts, believe in our team and we want you to be part of us. That means we provide ongoing support for your development and give you exposure to the newest technologies and working environments. We’re a modern, challenging and fast growing, business because of the... See more

Why Tek Experts?
We at Tek Experts, believe in our team and we want you to be part of us. That means we provide ongoing support for your development and give you exposure to the newest technologies and working environments. We’re a modern, challenging and fast growing, business because of the success of our people. They are smart, curious, client-oriented and results-driven.

My Career. My Future. My Tek Experts.
Tek Experts is an equal opportunity employer. We do not and will not discriminate in employment and personnel practices on the basis of race, sex, age, handicap, religion, national origin or any other basis prohibited by applicable law. Hiring, transferring and promotion practices are performed without regard to the above listed items.

Start fulfilling your dreams
If you think you have what it takes to make a difference and want to work for a company that can offer you unlimited potential then apply for this position now and tell us more about what you can bring to our business. You can also check out our other jobs.

Website: https://www.tek-experts.com/en-us/vietnam

Less

16 FL, East Wing, Lotte Center, 54 Lieu Giai, Ba Dinh, Hanoi

500-999