Skip navigation

Senior MS SQL Database Administrator

  • Kyiv, Ukraine
  • hot
Job #: 43650
(83933102)

Striving for excellence is in our DNA. Since 1993, we have been helping the world’s leading companies imagine, design, engineer, and deliver software and digital experiences that change the world. We are more than just specialists, we are experts.

DESCRIPTION


The team is currently working on a Data Warehouse and Big Data project for our client, the most trusted and esteemed source of visual content in the world, with over 200 million assets available through its industry-leading sites. It serves creative, business and media customers in almost 200 countries and is the first place people turn to discover, purchase and share powerful content from the world’s best photographers and videographers. The company cooperates with over 200,000 contributors and hundreds of image partners to provide comprehensive coverage of more than 130,000 news, sport and entertainment events, impactful creative imagery to communicate any commercial concept and the world’s deepest digital archive of historic photography.

Currently, we are searching for a strong MS SQL DBA to support SQL Server Data warehouse in AWS while the team is focusing on re-platforming to Snowflake/Looker technology.

On this role, you will be responsible for the development, configuration, maintenance, and performance of critical SQL Server Data warehousing systems, ensuring its operational readiness (availability, security, health and performance).

This role’s focus will be on the implementation of tools, databases administration including back-up and Restore, troubleshooting, performance tuning, monitoring critical events and documentation. You will also have an opportunity to hold a developer hat in understanding the code, data flow and looking for improvement of the system. The position is expected to cover 60% DBA and 40% Developer tasks.

Responsibilities

  • SQL Server administration, Configure and maintain database servers and services (SSIS, SSAS, SSRS services), including monitoring of system health and performance, to ensure high levels of performance, availability, and security
  • Setup monitors and alerts to detect blockings, long running queries/transactions, troubleshoot SQL Server related CPU, memory, throughput and other resource contentions
  • Actively engaged with code-refactoring for optimizations and new development efforts
  • Independently analyze, solve, and correct issues in real time. Perform problem resolution and root cause analysis along with recommendation and implementing preventive techniques
  • Check the fragmentation and rebuild/ reorganize the indexes
  • Refine and automate regular processes, track issues, and document changes
  • Provide support for critical production systems
  • Perform scheduled maintenance and support release deployment activities after hours
  • Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members
  • Assist developers, business analyst with complex query tuning and schema refinement
  • Understand the current utilization of AWS instances related to EC2 Memory, CPU, IO, throughputs and Resizing of AWS instances to optimize on the cost
  • Demonstrate SQL best practices and SQL in AWS best practices for the team

Requirements

  • Solid hands-on technical and development skills
  • Expertise in AWS
  • Excellent interpersonal and communication skills
  • Excellent problem-solving skills
  • Intermediate or higher English level (B1+)

We offer

  • Competitive compensation depending on experience and skills
  • Individual career path
  • Social package - medical insurance, sports
  • Compensation for sick lists and regular vacations
  • English classes with native speakers (certified English teachers)
  • Flexible work hours
Узнать больше о EPAM Украина

Здравствуйте, чем мы можем вам помочь?


Наши офисы

  • Канада

    • Оттава

      343 Preston Street,
      ON K1S 1N4, Ottawa
      Canada

      Карта
    • Торонто

      5 Park Home Avenue,
      Suite 400,
      ON M2N 6L4, North York,
      Toronto
      Canada

      Карта
      Тел: +1-416-591-4004
      Факс: +1-416-595-1551
  • Мексика

  • США

    • Ньютаун

      41 University Drive,
      Suite 202,
      Newtown, PA 18940
      USA

      Карта
      Тел: +1-267-759-9000
      Факс: +1-267-759-8989
    • Белвью

      110 110th Ave. NE,
      Suite 310
      Bellevue, WA 98004
      USA

      Карта
    • Бостон (Массачусетс)

      21 Drydock Avenue,
      Suite 410 W,
      Boston, MA 02210
      USA

      Карта
    • Вашингтон

      7901 Jones Branch Drive,
      Suite 400,
      McLean, VA 22102
      USA

      Карта
    • Кембридж (Массачусетс)

      One Mifflin Place
      Cambridge, MA 02138
      USA

      Карта
      Тел: +1-267-759-9000
      Факс: +1-267-759-8989
    • Коншохокен (Пенсильвания)

      101 East 8th Ave,
      Suite 201,
      Conshohocken, PA 19428
      USA

      Карта
      Тел: +1-484-382-1300
    • Маунтин-вью

      465 Fairchild Dr,
      Building B, Suite 221,
      Mountain View, CA 94043
      USA

      Карта
    • Нью-Йорк (Нью-Йорк)

      24 West 25th Street,
      New York, NY 10010
      USA

      Карта
      Тел: +1-267-759-9000
      Факс: +1-267-759-8989
    • Филадельфия (Пенсильвания)

      30 South 15th Street,
      9th Floor,
      Philadelphia, PA 19102
      USA

      Карта
  • Австралия

  • Гонконг

  • Индия

    • Бангалор

      Smartworks,  
      Global Technology Park,
      Block C, Outer Ring Rd,
      Adarsh Palm Retreat, Bellandur,
      Bengaluru, Karnataka 560103
      India

      Карта
    • Пуна

      Level 6,
      Pentagon Tower P-2,
      Magarpatta City,
      Hadapsar,
      Pune - 411013,
      Maharashtra
      India

      Карта
    • Хайдарабад

      North wing,
      JVP Building, Plot No. 5,
      Software Units Layout
      Madhapur,
      Hyderabad - 500081
      India

      Карта
      Тел: +91-40-47979900
  • Китай

    • Гуанчжоу

      Unit B01, 23/F
      Yuexiuxinduhui Building
      No. 236, 6th Zhongshan Road
      Yuexiu District
      510180 Guangzhou, China

      Карта
    • Сучжоу

      18F, Phase 3
      Science Plaza
      1355 Jinjihu Avenue
      Suzhou Industrial Park
      215021 Suzhou, China

      Карта
    • Шанхай

      Room B509, 5th Floor,
      48 Weihai Road,
      Huangpu District, Shanghai,
      China 200000

      Карта
    • Шэньчжэнь

      Vision Shenzhen Business Park
      No. 9 Gaoxin 9th South Road
      Building 5, Floor 3
      Shenzhen Hi-Tech Industrial Park
      Nanshan District
      518057 Shenzhen
      China

      Карта
  • ОАЭ

    • Дубай

      EPAM Systems FZ-LLC Dubai Branch
      2307 Arenco Tower, Dubai Media City
      PO Box 501929 Dubai
      United Arab Emirates

      Карта
      Тел: +971-4-568-3569
  • Сингапур

    • Сингапур

      6 Raffles Quay
      #16-01,
      Singapore 048580

      Карта
      Тел: +65-6812-7843
      Факс: +65-6812-7889
  • Япония

    • Токио

      Floor 1-10-11
      Shibadaimon Centre Building 10th
      Shibadaimon Minato-ku
      Tokyo 105-0012
      Japan

      Карта
      Факс: +81-03-6880-9201