Dba/ Tuner

3 months ago

India Bloom Consulting Services Full time

DBA/ Tuner ( Job

ID :
:

NA

Experience

5 yea - 5+ Ye years
Offered Salary

Notice Period

Not Disclosed
DBA JD below

Primary skills:

  • Database tuning, database troubleshooting, capacity planning, configuration, database design/modelling (on oltp and olap systems). experience designing/tuning an enterprise (mediumlarge) datawarehouse is required.
  • Implement High Availability and Disaster Recovery approaches/procedure
  • Expert in data transformation services and Bulk/Batch Loads into database.
  • Worked on logical and physical data base modeling with ERWIN tools or similar.
  • Experience in using DMV and dynamic management functions for finding out long running queries.
  • Monitoring database performance using SQL Profiler or similar to find performance and dead locks.
  • Experience in database tuning using data compression, online indexing, clustering/horizontal scaling, materialized views, running stats, purging/archiving etc.
  • Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support

Years of experience:
5 years+

Minimum tech skills:
sql, pl/sql, dba skills on rdbms (oracle or mysql), erwin or similar Preferred tech skills: columnar database (redshift or equivalent)