Database Administrator DBA II

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 meet customer service level commitments.

Basic Requirements:


* Experience with Microsoft SQL Server 2016, 2017, & 2019 and with AWS and Aurora-Postgres.


* Experience in database 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 writing and troubleshooting complex stored procedures and functions for both SQL Server and Aurora/Postgres


* 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.


* Experience in Incident Management and good understanding of SOX and other regulatory compliance


* Good 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 Technologies

Qualifications


* Bachelor's degree in Computer Science or similar field.


* 3+ 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.


* Experience in Managing a Multi-Site (Active-Active) Environment


* Recent graduates arealsowelcome to apply.



* Experience wi...