SQL Developer

3 weeks ago

Ranchi, Jharkhand, India TechnoRight Full time

Job Description :

Job Responsibilities :

- Design, develop, and maintain efficient database solutions using SQL Server, SSIS (SQL Server Integration Services), or other ETL tools.

- Create and manage ETL processes to extract, transform, and load data from multiple sources into databases or data warehouses.

- Develop stored procedures, views, functions, and triggers to support application development.

- Optimize database performance by tuning queries, indexes, and other database components.

- Collaborate with data architects, business analysts, and other teams to ensure that business needs are met through data solutions.

- Create and schedule SSIS packages to automate data workflows.

- Troubleshoot and resolve database performance, data integrity, and data quality issues.

- Ensure proper documentation of database architecture, ETL processes, and reporting requirements.

- Maintain data security and compliance standards, ensuring data privacy regulations are adhered to.

- Implement and maintain database backup, recovery, and disaster recovery strategies.

- Oracle PLSQL Development experience in Oracle SQL Performance Query Tuning

- Good understanding of Oracle Architecture

- Strong experience in writing Functions Procedures packages Function etc

- Strong experience in writing complex SQL Queries using Joins Hints indexes etc

- Should have worked on different file handling techniques SQL Loader UTL File External Tables etc

- Should be aware of Oracle 11g features

- Should have worked on Analytical functions Collections Bulk Data operation etc

- Help write and optimize in-application SQL statements.

- Ensure performance, security, and availability of databases.

- Prepare documentations and specifications.

- Profile server resource usage and optimize and tweak as necessary.

- Collaborate with other team members and stakeholders.

- Translate business needs to technical specifications.

- Design, build and deploy BI solutions (e.g. reporting tools).

- Maintain and support data analytics platforms (e.g. MicroStrategy).

- Create tools to store data (e.g. OLAP cubes)

- Conduct unit testing and troubleshooting.

- Evaluate and improve existing BI systems.

- Collaborate with teams to integrate systems.

Skills and Qualifications:

- Strong knowledge of SQL, including the ability to write complex queries, stored procedures, and triggers.

- Experience with SSIS or any other ETL tool (e.g., Informatica, Talend, Pentaho).

- Expertise in creating and optimizing ETL workflows, automating data loads, and transforming large datasets.

- Experience with database management systems (e.g., SQL Server, Oracle, MySQL).

- Knowledge of data modeling and database design concepts.

- Familiarity with data warehousing concepts and best practices.

- Experience with performance tuning and query optimization.

- Strong problem-solving skills and ability to debug complex database issues.

- Understanding of version control systems and Agile development methodologies.

- Experience with cloud-based ETL tools or cloud data platforms (Azure Data Factory, AWS Glue, etc.) is a plus.

(ref:hirist.tech)

  • PL/SQL Development Position

    5 days ago

    Ranchi, Jharkhand, India beBeeDevelop Part time ₹ 8,00,000 - ₹ 12,00,000

    Job Opportunity">We are seeking a skilled PL/SQL Developer to join our team. The ideal candidate will possess strong knowledge in Oracle Forms & Reports and have excellent skills in development.Strong analytical and problem-solving skillsAbility to work independently with minimal supervisionWe prefer candidates who can commit to working with us for at least...

  • Oracle and SQL Course Completed or Not Completed Fresher

    6 days ago

    Ranchi, Jharkhand, India VJ Consultant Part time

    Oracle and SQL Course completed or not completed Fresher Exp: (0- 2) Yrs Immediate (or) 15- 30 days Edu : Any degree Location: Chennai Salary : company norms 1. The candidate must have strong knowledge in PLSQL Development and Oracle Forms & Reports. 2. Quick learner, looking for new challenges. 3. Should have good Communication skills and shouldn't have...

  • Web Application Developer

    13 hours ago

    Ranchi, Jharkhand, India beBeeBackend Full time ₹ 8,00,000 - ₹ 15,00,000

    Backend Developer PositionThe role of a Backend Developer is crucial in the development, maintenance, and support of web-based applications. As part of our team, you will be instrumental in designing, developing, and maintaining high-performance backend systems using .NET, ASP, and C#.Key Responsibilities:Backend Development: Design and develop...

  • Senior Database Analyst

    14 hours ago

    Ranchi, Jharkhand, India beBeeSqlDeveloper Full time ₹ 7,00,000 - ₹ 11,00,000

    Job SummaryWe are seeking a skilled SQL Developer to join our team.About the Role:This role involves designing, developing, and maintaining efficient database solutions using SQL Server, SSIS, or other ETL tools. The successful candidate will create and manage ETL processes to extract, transform, and load data from multiple sources into databases or data...

  • High-Performance Software Developer

    12 hours ago

    Ranchi, Jharkhand, India beBeeDeveloper Full time ₹ 18,00,000 - ₹ 25,00,000

    About the Role:\As a seasoned Full Stack Developer, you will be responsible for creating scalable and high-performance applications using the MEAN stack. Your expertise in microservices development, Angular, and Node.js will enable you to design and implement robust web applications.\Main Responsibilities:\\Design and implement high-quality, scalable web...

  • Chief Database Architect

    13 hours ago

    Ranchi, Jharkhand, India beBeeDeveloper Full time ₹ 15,00,000 - ₹ 20,00,000

    Database DeveloperJob Description:Our team is seeking a skilled Database Developer to design, develop, and maintain efficient database solutions using SQL Server, SSIS, or other ETL tools. As a key member of our database development team, you will create and manage ETL processes to extract, transform, and load data from multiple sources into databases or...

  • Oracle Database Specialist

    17 hours ago

    Ranchi, Jharkhand, India beBeeDatabaseDeveloper Full time ₹ 7,50,000 - ₹ 15,00,000

    Job DescriptionWe are seeking an experienced Oracle Developer to join our team. The successful candidate will be responsible for designing and creating the structure of Oracle databases, including defining tables, relationships, constraints, and data modeling.The ideal candidate will have a strong proficiency in SQL Development, including writing complex...

  • Data Insights Specialist

    16 hours ago

    Ranchi, Jharkhand, India beBeeDataAnalyst Full time ₹ 12,000 - ₹ 70,000

    Job TitleWe are seeking an experienced Data Analyst to join our team. As a Data Analyst, you will play a key role in providing data-driven insights to support business decision-making.ResponsibilitiesEvaluate and interpret large datasets to identify trends, patterns, and anomalies.Develop and maintain dashboards and reports using tools like Tableau, Power...

  • ConveGenius - Project Manager

    4 weeks ago

    Ranchi, Jharkhand, India Convegenius Full time

    About us: We are a leading Conversational AI company that's revolutionizing education for millions worldwide. Our knowledge bots are already empowering 35 million users, and we're at the forefront of shaping the future of EdTech in Naya Bharat. We're creating an omniverse in Conversational AI, where developers collaborate to innovate together. As part of our...

  • Principal Backend Software Engineer

    15 hours ago

    Ranchi, Jharkhand, India beBeeBackend Full time ₹ 10,00,000 - ₹ 15,00,000

    Senior Java Developer Job DescriptionAs a Senior Java Developer, you will be responsible for designing and developing scalable backend services using Java and Spring Boot.Key Responsibilities:Design and develop scalable backend services using Java and Spring Boot.Implement REST and GraphQL APIs with high performance and reliability.Build and maintain...