SQL Server DBA

Job Description: 

smartShift Technologies is looking for a Senior SQL Server DBA to join our Cloud Managed Services team.

Responsibilities

  • Lead and architect all client database projects
  • Prepare high level and low level database design documentation
  • Determine database structural requirements by analyzing client operations, applications, and programming; reviewing objectives with clients; evaluating current systems
  • Develop database solutions by designing proposed system, defining database physical structure and functional capabilities, security, back-up, and recovery specifications.
  • Install database systems by developing flowcharts, applying optimum access techniques, coordinating installation actions, documenting actions
  • Troubleshoot SQL Server service outages as they occur, including some after-hours and weekend support as needed
  • Configure SQL Server monitoring utilities to help communicate risks proactively
  • Create and deploy database change scripts
  • Performance tune databases - determine the most effective way to increase performance and recommend hardware purchases, server configuration changes, or index/query changes
  • Document client’s database environments
  • Maintain database performance by identifying and resolving production and application development problems, calculating optimum values for parameters, evaluating, integrating, and installing new releases, completing maintenance, responding to user queries
  • Conduct user training on usage of databases
  • Provide database support by coding utilities, responding to user questions, and resolving problems
  • Update skills by participating in educational opportunities; reading professional publications; completing certifications

Skills & Experience

  • Experience architecting and designing databases using MSSQL, T-SQL Server
  • Experience in troubleshooting and resolving database problems
  • Experience in performance tuning and optimization (PTO), using native monitoring and troubleshooting tools
  • Experience with database backups, restores and recovery models
  • Experience in implementing MSSQL in clustered environment on premise, Azure or AWS cloud platforms
  • Experience in DBA automation such as Backup, Monitoring, and Reporting
  • Project experience involving High Availability (HA) & Disaster Recovery (DR) options for MSSQL Server
  • Experience in implementing operational automation using scripting, T-SQL skill is mandatory
  • Knowledge of indexes, index management, and statistics
  • Technical Expertise in Solutions Stack (Compute, Storage, Network, Security, Backup, Process, Compliance, MA, HA & DR)
  • SQL Server Cloud experience will be given preference
  • Excellent communication, documentation and presentation skills. Should be able to educate and influence clients on database architecture and design
  • Experience using project management tools, ITIL and SDLC methodologies
  • Experience with Data Warehouse and BI systems, extensive experience in collecting business requirements from customers, and transforming the requirements into DB data processes and data schema
Region: 
Bengaluru, India