Position: MSSQL Database Reliability Engineer
Company: Amach Software
Category: Data Engineer
Experience required: 2y
English level: intermediate
Published: 2022-02-01T00:00:00+02:00

Sr. DB Engineer focuses on designing, coding, and optimizing database structures to operate in concert with application architecture components. S/he works as a member of a multi-functional SCRUM team and serves as an MS SQL DB expert to the team, but could be asked to provide input on other data stores. Most work is built into a project for specific output on new platform features or improvements. An engineer is expected to help automation, simplify, and optimize not just the running database but all of its operations. 

**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
8 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

**What we offer:**

Dynamic blue sky projects – leading edge
Options for career advancement in a expanding, successful fast-growing company
Great learning and development opportunities
Flexible working environment
Competitive rates based on experience