Senior Database Administrator

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.

Skills And Qualifications

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