Full Job Description
Clarion Technologies is an IT services company providing customized software solutions to small & medium businesses globally in a broad spectrum of industries. With 20+ years of expertise in Digital Transformation, we help our customers to improve their business performance significantly. With cutting-edge technology, Agile development, and best coding practices, we are proud to offer one of the most Usable, Reliable, and Secure software solutions. We are certified as a CMMI level 3 company, Great Place to Work in 2019 & Top Software Developers in India by Clutch. -head office in Pune, India, we have two state-of-the-art delivery centers in Pune and Ahmedabad.
About The Role
We’re looking for an SQL DBA to join our engineering team right now. As an SQL DBA, you will work as part of our engineering team to produce high-quality, user-friendly SQL DBA applications on a timely basis.
Job Responsibilities
The Sr. SQL Developer will lead the development of new AND the maintenance/optimization of existing Ad-Hoc Queries, Stored Procedures, SQL Agent Jobs, Triggers, Indexes, Views and Functions. This role will also be responsible for installing, maintaining and configuring Microsoft SQL Server database instance with SQL Server Integration (SSIS) and Reporting Service (SSRS).
Must have experience with AWS
A Day in the Life
Performance Tuning and Query Optimization using native SQL Server tools
Database backups and recovery, configure replication, db system planning
Ensure performance, security, and availability of databases.
Develop and maintain complex stored procedures
Create documentation and UML diagrams for database processes.
Handle common database server optimization tasks.
Create complex ad hoc queries
Optimize database schemas, maintain database jobs, and dictionaries.
Ability to fix issues related to database performance and provide corrective measures.
Partner with stakeholders to create reports and dashboards for internal departments.
Maintain and develop backend data layer code for internal applications.
What Sets You Apart
Ability to troubleshoot issues with the databases and applications within our environment.
Must have strong critical thinking and problem-solving skills.
Ability to communicate effectively.
The ability to reverse engineer and re-write complex queries
Education and Experience
Database modeling, design, troubleshooting, error handling, and hardware planning
Must have working experience of either one of AWS
Job Requirements
Primary Skills-
Query Optimization, Microsoft SQL Server, SSRS, Reports, SQL Server, Reverse Engineering, SSIS, SQL, Stored Procedures, AWS – Lambda, Azure SQL Server, AWS, Communication
Experience
3 – 5 years
Location
Pune