Database Administrator
Willis Towers Watson
Lima
hace 1 día

Responsibilities

  • Managing and administering SQL Server Version 2012 / 2014 / 2019 and Azure SQL Databases, ensuring availability and performance of all SQL Server databases including Microsoft Azure SQL databases, postgres and mysql databases.
  • Managing the database space and allocation planning
  • Implementation of database and data architecture monitoring technologies and procedures and proactively monitor the database systems and resources to ensure secure, stable, high-performing services with minimum downtime.
  • Analyzing and reporting on metrics and trends.
  • Participate in the formulation of policies, procedures and standards relating to database management. Working with the teams in the design and implementation of database security policies and integrity controls.
  • Implementation of database backup and recovery technologies and procedures, as well as monitoring, testing and issue resolution.
  • Working with the development teams on projects and systems in database modeling and design, creating / tuning / optimizing indexes, stored procedures, DTS / SSIS packages and SQL jobs, as well as assisting in troubleshooting, performance tuning and general problem solving of SQL development.
  • Configuring and Managing Data Encryption at Table as well as Database Level
  • Performing all changes and maintenance of the databases, including rollouts and upgrades, as well as testing and approving SQL Server patching.
  • Participating in on-call support and managing SQL Server monitors and alerts.
  • Configuring and Managing Data replication between SQL Servers using native SQL Server replication, SSIS packages.
  • Requirements

  • Must be Microsoft Certified and possess self-motivation and strong communication and problem solving skills.
  • 5+ years of experience of managing multiple Microsoft SQL 2012 / 2014 / 2019, AZURE databases (Standard and Enterprise Editions), Postgres SQL.
  • 4+ years of experience with database modeling, stored procedures, jobs, complex queries and modifications.
  • 4+ years of experience programming in T-SQL.
  • 4+ years of experience troubleshooting database, system, and / or networking issues.
  • Knowledge of backups and recovery, security administration, database and server performance monitoring, tuning and trending, and capacity planning.
  • Experience with partitioning, file group optimization, database mirroring, log shipping, and clustering and expertise in SQL Server database replication is an absolute must!
  • Microsoft SQL clustering / High Availability Configuration experience a must!
  • Hands-on experience with developing, optimizing and maintaining DTS and SSIS packages.
  • Relational data modeling and conceptual, logical and physical database design and implementation experience.
  • At TRANZACT, our hiring processes ensure equal conditions, objectivity and non-discrimination.

    Reportar esta oferta
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Inscribirse
    Mi Correo Electrónico
    Al hacer clic en la opción "Continuar", doy mi consentimiento para que neuvoo procese mis datos de conformidad con lo establecido en su Política de privacidad . Puedo darme de baja o retirar mi autorización en cualquier momento.
    Continuar
    Formulario de postulación