Position: Data Base Reliability Engineer MSSQL
Company: Amach Software
Experience required: 5y
Category: SQL
English level: upper
Published: 2021-09-01T00:00:00+03:00

We offer:

21 vacation days
10 sick leaves
National holidays paid - 10-15 days a year
International trips
Relocation to Ireland support
Learning and development covered by company
Flexible working hours
Opportunity for mixed office/remote work

Duties will include, but not limited to:

Design silent installs, upgrades, patching systems for the MSSQL DBs
Optimizing the performance of the OLTP DB(s) to support 3-tier system architecture, utilizing indexing, partitioning and data lifecycles
Designing and implementing data management processes: security, lifecycle management, and operational readiness
Designing and implementing data conversion solutions via TSQL
Cross functional support of at least 1 other database (Oracle/Mongo)

Skills:

Requires knowledge and prior experience working with the latest versions of the MSSQL DB but specifically Oracle 2008 and newer migrations
Requires knowledge and prior experience working with MSSQL IDE’s like SSMS/SSCM and well as other Oracle/Mongo IDE’s, such as PLSQL Developer, TOAD
Should be well verses and experienced with Always On and Cluster configurations for MSSQL. With a grasp on Primary/Secondary replication in Oracle or Mongo
Solid knowledge AWS, its structure and its DBaaS offers and when they are a good fit.
Bonus for skills with Packer, CIS Hardening, Terraform and other modern CI/CD infrastructure tool sets
Requires knowledge and prior experience of Oracle DB options such as:
Partitioning
Mirroring/ Log Shipping
Backups, Snapshots, Compression
AlwaysOn , Availability Group
RW splitting
Online DML
Best in class security hardening

Requirements:

Background in DBRE or database automation (MS Certification highly desired)
Required knowledge and prior experience working with standard data constructs such as XML, XSD, JSON, 3NF, and YAML.
Strong knowledge and troubleshooting of ODBC and Java 
Requires knowledge and prior experience working in SCRUM agile methodology
Preferred knowledge and prior experience working with Services Oriented Architecture (SOA)
Preferred knowledge and prior experience working with ETL technologies
Experience with Data warehousing, Cubes, and emerging EPP/MPP data designs
Seasons experience in Windows, Linux, AWS, and Storage is required. 
MCTS, MCITP, and/or MVP, MCSA  is desired

Critical to success is “soft skills”, which include: 

Ability to work collaboratively  
Quickly learn new skills to support multi-functional deliverables of SCRUM team
Crisp and succinct communication and social skills to effectively interact with the stakeholders about to receive input into deliverables
Well-developed coaching skills to train and knowledge transfer to internal resources
Positive attitude and flexibility to adjust to the fast-changing environment
Strong believe in 80/20 and SOLID principles
5+ years of experience and expertise with data modelling tools and Oracle databases, Oracle certifications strongly preferred
It is advantageous to have strong programming skills 
Clear, Confident and Effective communications in English, as team is primarily native English speakers and mature writing skills to deliver required documentation
Desire to push back on existing rational to ensure, the right path forward is taken