.We help the world see new possibilities and inspire change for better tomorrows. Our analytic solutions bridge content, data, and analytics to help business, people, and society become stronger, more resilient, and sustainable.Job DescriptionJob Description:We are looking for databaseadministrator to design, implement, support, administer andmaintain relationaldatabases such as MS SQL Server, Snowflake, Postgres, etc.As a Database Administrator, you will:Create, administer, monitor, and maintain multiple relational databases such as MS SQL Server, AWS Aurora-Postgres, Snowflake, etc.Work on new and existing logical/physical database designs for applications and infrastructure. Implement relational databases, tables, and table changes, etc.Support application development for problem solving and performance tuning.Assist in administering, monitoring and maintaining SQL Server/Snowflake/Aurora Postgres environments, including for disaster recovery.Be willing to be on-call and occasionally work odd hours to help meeting customer service level commitments.Basic Requirements:Experience with Microsoft SQL Server 2016, 2017, & 2019 and with AWS and Aurora-Postgres.Experience in data base design for data integrity, performance tuning and capacity optimization.Knowledge of the SQL language and its capabilities.Ability to analyze SQL and provide recommendations (performance tuning, tables, views, triggers, indexes, constraints,etc.)and best practices.Experience in application (e.G., timeouts, deadlocks, etc.) and server troubleshooting.Advanced knowledge of SQL Server components and tools (Extended Events, etc.)Ability to automate routine processes with PowerShell and other scripting languages.Experience with installation, configuration, support, and tuning of different complex Microsoft SQL Server installations and setups (Availability Groups, Multi-site Availability Groups, Failover Clusters Instances, etc.)Strong understanding of monitoring: interpretation, actions to take, implementations and administration.Experiencein Incident Management and good understanding of SOX and other regulatory complianceGood communication skills, ability to collaborate in a team.Ability to take initiative instead of waiting for work to be assigned.Active participation in discussions and ability to have and state opinions.Ability and eagerness to learn and to pick-up other Relational and NoSQL Database TechnologiesQualificationsBachelor's degree in Computer Science or similar field.2+ years of experience with creating, administering, monitoring, and maintaining of multiple relational data bases such as Microsoft SQL Server, PostgreSQL, AWS Aurora, etc.Familiarity with working on the AWS Cloud platform with RDS SQL Server and Aurora-Postgres and with EC2 instances and related features
