700000 - 1000000 INR - Annual
Bangalore, Karnataka, India
Information Technology
Other
ONE Business Consulting Group Private Limited
Overview
How you can make a difference.
- Design, develop, and optimize complex stored procedures, functions, and triggers for performance and scalability.
- Collaborate with developers to design efficient database schemas and write high-performance queries.
- Analyze and optimize query execution plans, indexing strategies, and database partitioning to improve efficiency.
- Troubleshoot and resolve performance bottlenecks in queries and stored procedures.
- Implement best practices for data integrity, normalization, and indexing to ensure database efficiency.
- Work closely with application developers to review and enhance database logic within applications.
- Develop and maintain ETL processes using SSIS for data transformation and integration.
- Assist in designing and implementing replication, partitioning, and archiving strategies for large datasets.
- Provide expert-level SQL scripting support and mentor junior team members in writing efficient T-SQL.
- Stay updated with emerging database technologies and best practices to enhance database performance.
- velopment activities.
What all you need.
- 5+ years of experience in Microsoft SQL Server development, focusing on stored procedures and database optimization.
- Expert-level proficiency in T-SQL and writing complex stored procedures.
- Strong knowledge of query optimization techniques, execution plans, and indexing strategies.
- Experience in database normalization, table partitioning, and query tuning for large-scale applications.
- Hands-on experience with SSIS (ETL), SSRS, and SSAS.
- Familiarity with database performance monitoring tools and techniques.
- Understanding of cloud-based database solutions (Azure SQL, AWS RDS)
- Strong problem-solving and analytical skills.
Job Types: Full-time, Permanent
Pay: ₹700,000.00 - ₹1,000,000.00 per year
Benefits:
- Health insurance
- Paid sick time
Schedule:
- Day shift
- Monday to Friday
Work Location: In person
Similar Jobs
View All
Talk to us
Feel free to call, email, or hit us up on our social media accounts.
Email
info@antaltechjobs.in