Database Administrator - Architect

Database Administrator - Architect

Eclaro Business Solutions Incorporated
Philippines
7-10 years
Not Specified

Job Description


Assignment Detail
Industry: Insurance
Job Description
Architect Level - DBA
Summary: 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

Similar Jobs

People Also Considered

Career Advice to Find Better

Related Searches

Simple body text this will replace with orginal content