Database Administrator

Job Description

Overview

We are looking for a professional database administrator (DBA) to keep the databases up and running smoothly 24/7. The goal is to provide a seamless flow of information throughout the company, considering both back-end data structure and front-end accessibility for end-users. An experienced report builder will work collaboratively to deliver targeted data in easy-to-consume reports and dashboards, producing real-time information in support of data analytics and business development.


Responsibilities

  • Assist with schema design, stored procedures, SQL query tuning
  • Maintaining SQL Server Agent Jobs
  • Monitoring windows resource and performance tuning to determine slow points in Thompson Reuters - 3E system
    • Disk space
    • Backup job failures
    • Integrity and other hardware errors
    • SQL Server data and log growth events
    • 3E maintenance jobs
  • Write and deploy SQL jobs for data extraction
  • Build data warehouse for reporting and application integration
  • Create ETL process and data flow to consolidate multiple data sources
  • Install, tune, implement and upgrade DBMS installations
  • Upgrade and improve application schema and data upgrades
  • Monitor storage available for support databases, backups, and batch processes
  • Centralize error handling on all SQL servers
  • Look for opportunities for improvements
  • Implement and manage company data management practices and policies
  • Good understanding of data and schema standards and concepts
  • Good understanding of database design, implementation, troubleshooting and maintenance 
  • Sense of ownership and pride in your performance and its impact on company’s success
  • Critical thinker and problem-solving skills

Qualifications

  • Bachelor’s degree in computer science or a related information technology field , or relevant experience
  • 5+ years of experience with programming languages such PL/SQL coding
  • 5+ years of experience in administering, managing and tuning databases
  • 5+ years of experience with Microsoft MS SQL Server
  • Strong command of SQL and SQL server tools
  • Advanced knowledge of database security, backup and recovery, and performance monitoring standards
  • Understanding of relational and dimensional data modeling
  • Experience with PowerShell and Unix shell scripting skills
  • Experience with SSAS, SSIS, SSRS
  • Experience with Thompson Reuters (3E) is a plus
  • Experience with cloud services (AWS, Microsoft Azure) a plus
  • Experience with other database technologies (MySQL, PostgreSQL Oracle, MongoDB) is a plus
  • Experience with ERP application administration and maintenance is a plus