Data Administrator (Architect)

Data Administrator (Architect)

Eclaro Business Solutions Incorporated
7-10 years
Not Specified

Job Description


Assignment Detail
Industry: Insurance
Job Description
Data Administrator (Architect)
We are looking for a senior/architect-level DBA who will be deeply involved in tuning/optimizing our various databases. The employee will be deeply involved in the redesign of our databases to a MongoDB NoSQL.
Job Responsibilities:
  • SQL Server upgrades/migrations (AMIS DBAs provide a shell database and we need to do the actual data migrations and test)
  • Performance Tuning review critical databases and improve the performance including indexing, SQL tuning
  • Database Jobs Schedules migrate all database jobs to JAMS centralized enterprise scheduling
  • Monitoring and Alerting setup database monitoring, adjust thresholds and alerting
  • Database health checks
  • Database Re-orgs
  • New product/application support activities
  • Database automation automating database tasks
  • Database DevOps identify tools to include database deployments through CI/CDpipelines
  • Database version control ensure the database across all the environments are in synch
  • Disaster Recovery Test and Validate database recovery mechanisms and support DR testing
  • Documentation
  • Knowledge of SQL Server, Oracle, Postgress

Required Skills/Experience:
  • 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/Experience:
  • At least 7 years experience as a DBA
  • 5 years experience as a SQL developer
  • 2&plus years of MongoDB experience

Job Details

Employment Types:

Industry:

Function:

IT

Similar Jobs

People Also Considered

Career Advice to Find Better

Simple body text this will replace with orginal content