Assignment Detail
Industry: Insurance
Job Description
Architect Level - DBASummary: We are looking for a senior/architect-level DBA who will be deeply involved in tuning/optimizing our Archlink database. The employee will be deeply involved in the redesign of the Archlink database to a MongoDB NoSQL database.
Responsibilities:
- Optimize our current Archlink database
- Redesign the Archlink database to MongoDB NoSQL database
- Ensure backups are finished successfully and resolve issues.
- Installation and maintenance of Database Clusters (Always-On)
- Database (SQL) Service Packs / PSU Patches/ One Off Patches.
- Deployments of Database Scripts, Jobs, Schema Changes, compliance changes
- Support Database Upgrade (SQL)
- Ensure database is functioning as expected.
Required Skills:
- SQL Server TSQL/DDL Development, SQL Functions, Stored Procedures Expertise
- SQL Server Always On
- Deep Understanding of Triggers
- Deep Understanding of Full Text indexes
- Database tuning & Optimizing Index Tuning (Clustered and non-clustered) Use of database tuning tools SQL Tracing, SolarWinds DPA, Spotlight On SQL, RedGate, etc
- Database design 3rn Normal for traditional databases
- Data Transformation Expertise using SSIS, Python
- Database design for NOSQL databases MongoDB
- MongoDB shards
- Document DB design
- JSON, XML
- Expertise with ELK Stack Elastic Search
- DEVOPS CI/CD, Jenkins, Bitbucket, GitHub
Desired Skills:
- At least 7 years experience as a DBA
- 5 years experience as a SQL developer
- 2+ years of MongoDB experience
Education: 4-year IT degree or equivalent