Bangalore, Karnataka, India
Information Technology
Full-Time
SemperFI Solutions
Overview
Salary : 15 to 20 LPA
Job Description
Database Management and Development :
Job Description
- Advanced proficiency in T-SQL, including complex queries, stored procedures, triggers, Functions and experience with SQL Server tools (e.g., SSMS, Profiler, SSIS).
- Solid experience with ADF ETL processes, data warehousing, and reporting services (SSRS). (preferably Azure cloud)
- Knowledge of performance tuning and query optimization techniques.
- Proficiency in SQL, NoSQL, and NewSQL databases (e.g., MySQL, PostgreSQL, MongoDB, Cassandra).
- Shift Timings - 3 PM to 12 AM
- Preferably candidates from Bangalore Location
- 10+ years of experience
- 15days of maximum Notice period
- Individual Contributor Role
- Excellent Communication
Database Management and Development :
- Design and develop complex SQL queries, stored procedures, triggers, views, and functions.
- Create and optimize database schemas, tables, and indexes to improve data access and performance.
- Develop and maintain Cloud ETL processes to support data integration and migration projects. (preferably Azure Cloud)
- Perform data modelling, schema design, and indexing to enhance query performance.
- Implement data security best practices and compliance with relevant standards (e.g., GDPR, HIPAA).
- Oversee data backup, restoration, and recovery procedures.
- Monitor and troubleshoot database performance, identifying bottlenecks and implementing solutions.
- Optimize queries, indexing, and data storage to ensure efficient data retrieval and minimize response time.
- Implement database tuning recommendations and review execution plans to maximize performance.
- Use SQL Server Profiler, Execution Plans, and Index Tuning to troubleshoot slow-running queries and improve query performance.
- Design and manage cloud-based database systems (e.g., AWS RDS, Azure SQL, Google Cloud SQL).
- Collaborate with DevOps and IT teams to automate deployments and manage cloud environments.
- Ensure data quality, consistency, and integrity through validation checks and error-handling mechanisms.
- Develop and enforce data governance policies, data validation, and integrity checks.
- Design and implement error handling, logging, and auditing for data processes.
- Design scalable database structures and schemas to support high-volume transactions and data growth.
- Mentor junior engineers and support cross-functional team members in database and front-end development best practices.
- Conduct code reviews, enforce standards, and lead efforts to optimize database and application performance.
- Collaborate with business analysts, application developers, and stakeholders to gather requirements and design solutions.
- Advanced proficiency in T-SQL, including complex queries, stored procedures, triggers, Functions and experience with SQL Server tools (e.g., SSMS, Profiler, SSIS).
- Solid experience with ADS ETL processes, data warehousing, and reporting services (SSRS). (preferably Azure cloud)
- Knowledge of performance tuning and query optimization techniques.
- Familiarity with version control (e.g., Git) and Agile methodologies.
- Experience with cloud databases (e.g., Azure SQL, AWS RDS) is an advantage.
- Proficiency in Python, Java, or similar languages.
- Proficiency in SQL, NoSQL, and NewSQL databases (e.g., MySQL, PostgreSQL, MongoDB, Cassandra).
Similar Jobs
View All
18 Hours ago
MTS II - Software Engineer
Information Technology
- 4 - 7 Yrs
- Pune
MAJOR RESPONSIBILITIES
• Design, implement, integrate, and verify software applications and tools using JavaScript, NodeJS, and C++.
• Enhance, optimize, and improve the efficiency and robustness of current software, with a particular focus on OSS ...
1 Day ago
Test Engineer - Functional Testing
Information Technology
- Hyderabad, Telangana, India
Job Description Proven experience of 2 years of hands-on experience of functional testing. Strong knowledge of quality best practices and methodologies for software testing Experience with automation tools such as selenium, Cypress.io Katalon Stu...
1 Day ago
UcodeSoft Solutions - iOS Developer - Xcode
Information Technology
- Hyderabad, Telangana, India
Responsibilities Collaborate with the development team to design and implement new features for our iOS applications using Swift. Write clean, maintainable, and efficient code under the guidance of senior developers. Assist in translating UI/UX d...
1 Day ago
Senior Technical Business Analyst
Information Technology
- Hyderabad, Telangana, India
About the role:As a Senior Business Analyst, you will: Leads the creation & presentation of estimates for overall cost, skill, effort & timeline for new & existing solutions and projects from a functional perspective. Demonstrates solutions to inter...
1 Day ago
Senior QA Engineer
Information Technology
- Hyderabad, Telangana, India
Our Mission SPAN is enabling electrification for all ⚡We are a mission-driven company designing, building, and deploying products that electrify the built environment, reduce carbon emissions, and slow the effects of climate change. Decarbonization ...
1 Day ago
Software Test Engineer
Information Technology
- Bangalore, Karnataka, India
Job DescriptionWe are looking for Software Testing Engineers with the ability to architect and implement modern test automation tools and frameworks to support automated functional testing of mobile and web applications they will also facilitate the...
1 Day ago
Full Stack Developer (JAVA & Angular)
Information Technology
- Bangalore, Karnataka, India
Fullstack Developer must be proficient in Java (Spring Boot) for backend development and Angular for frontend development. The ideal candidate will be responsible for designing, developing, and maintaining scalable web applications, ensuring seamles...
1 Day ago
QA Engineer
Information Technology
- Bangalore, Karnataka, India
We're looking for a...QA EngineerApply Now!Position OverviewYou will participate in the testing effort of a leading SaaS product for small and medium sized hotels. He/she will lead the Quality Engineering effort and help to test and critique softwar...
Talk to us
Feel free to call, email, or hit us up on our social media accounts.
Email
info@antaltechjobs.in