Job Description

We are looking for a SQL DBA who will be responsible for designing databases and ensuring their stability, reliability, and performance. You will also work with other developers while optimizing in-application SQL procedures as necessary and establishing best practices. You will help solve all database usage issues and come up with ideas and advice that can help avoid such problems in the future

Responsibilities

• Development of high-quality database solutions
• Monitoring, and troubleshooting database servers and fixing any potential problems
• Mentor/Guide junior DBA engineers and be accountable for their work
• Develop, implement, and optimize stored procedures and functions using T-SQL
• Review and interpret ongoing business report requirements
• Ensure performance, security, and availability of databases
• Prepare documentation and specifications
• Build appropriate and useful reporting deliverables
• Setup monitoring tools and report Database performance statistics periodically and take necessary actions
• Analyze existing SQL queries for performance improvements and suggest new queries
• Develop common database procedures and scripts needed for upgrade, backup, recovery, migration, etc.
• Profile server resource usage, and optimize and tweak as necessary
• Provide timely scheduled management reporting
• Collaborate with other team members and stakeholders
• Investigate exceptions about asset movements
• Day-to-day work involves working with distributed teams so flexibility in work hours is needed.

• 7-8 years of experience as a SQL Developer or similar role
• Strong proficiency with SQL, T-SQL and its variation among popular databases
• B.E/B.Tech in Computer Science, Engineering or a related subject
• Excellent understanding of Microsoft SQL Server and very strong in Database modelling, design concepts
• Good knowledge of Azure/AWS SQL platform as a service
• Good knowledge on MS-SQL Server monitoring tools
• 2-3 years of experience with SQL Server Reporting Services and SQL Server Analysis Services
• Skilled at optimizing large complicated SQL stored procedures
• Knowledge of best practices when dealing with relational databases
• Capable of configuring popular database engines and orchestrating clusters as necessary
• Ability to plan resource requirements from high-level specifications
• Capable of troubleshooting common database issues on production
• Sense of ownership and pride in your performance and its impact on the company's success
• Familiar with tools that can aid with profiling server resource usage and optimizing it
• Proficient understanding of code versioning tool GIT
• Critical thinker and problem-solving skills
• Great team player
• Good time-management skills
• Great interpersonal and communication skills