Database Administrator DBA II
Description:
Description
We are looking for database administrator to design, implement, support, administer and maintain relational databases 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 are also welcome to apply.
Responsibilities
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 are also welcome to apply.
#LI-EA1
#LI-Hybrid