Job Summary: We are looking for a detail-oriented and data-savvy Database Analyst / SQL Developer with hands-on experience in Oracle and SQL Server . The ideal candidate should have a strong understanding of database structures and be proficient in writing and optimizing SQL queries, procedures, and scheduled jobs. A good grasp of data relationships and query logic is essential. Key Responsibilities: Develop, test, and maintain SQL queries , stored procedures , functions , and views in Oracle and SQL Server. Read from and write to database tables for business logic processing and reporting. Design and optimize joins , subqueries , and complex data retrieval logic. Analyze existing database structures and recommend optimizations. Support data quality and integrity across systems. Create and maintain scheduled jobs , ETL processes, or data pipelines. Work with application developers to support backend data needs. Troubleshoot database issues and performance bottlenecks. Required Skills: Proficiency in Oracle PL/SQL and T-SQL (SQL Server) . Strong knowledge of joins , subqueries , and data manipulation . Ability to understand and work with stored procedures , functions , triggers , and scheduled jobs . Experience in reading and interpreting relational database models . Understanding of indexes , constraints , and basic normalization . Familiarity with data profiling and basic data modeling concepts. Preferred: Knowledge of data migration , ETL tools , or SSIS / Oracle Data Integrator . Familiarity with cloud databases (e.g., Azure SQL, Oracle Cloud). Experience with reporting tools or writing queries for dashboards. Soft Skills: Strong analytical and problem-solving mindset. Ability to communicate effectively with business and technical teams. Self-motivated and able to work independently or in a team. Show more Show less

More Jobs at SMC Group

Senior Technical Support Engineer (SQL)

New Delhi, Delhi, India

3.0 - 6.0 yrs

Salary: Not disclosed

Hiring Drive - Tech Support Engineer L3

Delhi, India

2.0 - 2.0 yrs

Salary: Not disclosed

Engineering Manager (Flutter)

New Delhi, Delhi, India

Experience: Not specified

Salary: Not disclosed

Technical Program Manager

Delhi, India

5.0 - 5.0 yrs

Salary: Not disclosed

Walk-In Drive - DevOps Engineer

Delhi, India

5.0 - 5.0 yrs

Salary: Not disclosed

Mock Interview

Practice Video Interview with JobPe AI

Start Sql Interview Now

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.