hero

Looking for your next challenge?

38
companies
427
Jobs

Senior SQL DBA

WorkFusion

WorkFusion

IT
Hyderabad, Telangana, India
Posted on Tuesday, March 12, 2024

Position

WorkFusion is seeking a Senior-Level Database Engineer to join our Engineering team. The Development and maintenance of our platform presents many technical challenges in the areas of large-scale data processing, enterprise grade solutions and integrations. The ideal candidate is self-driven and can work successfully in a distributed team. You should possess strong knowledge of application support issues and troubleshooting in both cloud and on-premise environments. You will be a part of the Client Support team providing support to customer installations and our own cloud-based and on-premise solutions, including HA/DR solutions. This person will be actively involved in direct communication with customers and our own product team and will help lead issues to resolution.

Key responsibilities

  • Manage the development and performance of SQL databases for web applications
  • Ensure high levels of performance, availability, sustainability and security
  • Designs, installs, upgrade, monitors, maintains, and conducts performance tuning procedures in a production MS SQL Server database environment while ensuring high levels of data availability.
  • Develops, implements, and oversees MS SQL Server database policies and procedures to ensure the integrity and availability of databases and their accompanying software.
  • Create, maintain, and execute scheduled jobs, data extracts, data refreshes, data loads and data replication.
  • Detect and troubleshoot DB Server CPU, Memory, I/O, SQL Profiler and other resource contention
  • Solid knowledge on performance tuning from MSSQL, PostgreSQL and MySQL databases.
  • Develop new Tableau data sources and SQL data objects to support reporting environment.
  • Design, implement, and test backup and recovery strategies that ensure 100% data availability.
  • Develop data scripts, troubleshoot code and assist developers with performance tuning.
  • Manage AWS Managed MSSQL RDS instances , solid understanding to support the AWS cloud database.
  • Create operational runbooks, updating knowledge base, installation guides, learning courses and other types of documentation
  • Support development teams and customers’ requests
  • Closely communicate with customers and partners during installation, support and delivery
  • Troubleshoot and resolve database integrity issues, performance issues, blocking and deadlocking

Qualifications/Experience

  • Bachelor’s degree in computer science or similar degree
  • Practical skills in tuning solutions for performance
  • Root cause analysis experience
  • Experienced in building complex scripts, queries, and stored procedures
  • Proficiency in MS SQL 2016 architecture 10+ yrs
  • Proficiency in RDS SQL, Azure SQL architecture and high availability 3+ yr
  • HA/DR configuration ( Always On / Database Mirroring)
  • Proficiency in AWS RDS MSSQL administration