Performance DBA- Bangalore
Encora Inc.
3d ago
  • 5+ years MS SQL Server Performance tuning experience required
  • Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
  • Monitor databases to gather resource consuming queries, maintain SQL server replication, Clustering, backups, ETL SSIS jobs, and encryption
  • Review and debug SQL Server code including adhoc queries, views, stored procedures, functions and triggers for modernization and performance improvements
  • Maintain, review and apply appropriate indexes for new and existing queries
  • Analyze SQL query plans, suggest and implement solutions to support developers in the Software Development Life Cycle (SDLC)
  • Review alerts and remediate any issues that may arise from blocking, deadlocks and poorly performing code using extended events, execution plan analysis
  • Use PowerShell and SSIS to automate monitoring and alerting functions of SQL server
  • Experience with MS SQL Server (2012 or greater) tools, including Query Analyzer, SQL Agent Jobs and Profiler
  • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
  • Experience working with Windows server, including Active Directory
  • Knowledge on Azure DB as a service
  • Excellent written and verbal communication
  • Flexible, team player, get-it-done personality
  • Ability to organize and plan work independently
  • Ability to work in a rapidly changing environment
  • Ability to multi-task and context-switch effectively between different activities and teams
  • MCTS, MCITP, and / or MVP certifications a plus
  • Key Skills :
  • 1. MS SQL Server Performance tuning experience

    2. Mainly into Performance DBA Role

    3. Optimize Query, recommend to keep the performance of DB at an optimal level, Fine Tuning

    4. Creating Indexes : Maintain, review and apply appropriate indexes for new and existing queries

    Report this job

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Application form