Dba/ Tuner

4 weeks ago


India Bloom Consulting Services Full time

Not Disclosed

Experience

**5 yea - 5+ Ye Years**

Offered Salary

**Lakh**

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 (medium-large) 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)