Tóm lược
Mô tả công việc
Tóm tắt công việc
- 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;
Why You'll Love Working Here
- A collaborative and dynamic working environment
- Competitive salary & performance bonus
- Flexible working schedule
- Opportunities to work with the world’s leading IT companies
- Summer trip, year-end party, team building activities
Yêu cầu công việc
Your Skills and Experience
- 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);
Ngôn ngữ
-
English
Nói: Intermediate - Đọc: Intermediate - Viết: Intermediate
Yêu cầu kỹ thuật
- MS SQL
- T-SQL
- Computer Science
- Statistics
- SSIS
- DBMS
- ETL
- SSAS
- SSRS
- Data Warehouse
- BI
- Database Administration
NĂNG LỰC
- Communication Skills
- Documentation
Thông tin doanh nghiệp
Tek Experts, building global websites, we provide support that allows companies to dream.
Do you want to be part of a great team and be responsible for building global websites that change the way we do business?
Do you want to be a key part of a team that redesigns, re-launches and re-invents our business?
We are an international company that has office in 6 countries and supports customers in more than 20 languages. We employ more than 2,000 people worldwide and are looking to recruit one more key member on staff: you.