SQL Developer
2 days ago
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.
-
Software Developer
10 hours ago
Ranchi, Jharkhand, India MICA Educational Co. Full time ₹ 6,00,000 - ₹ 12,00,000 per yearFULL TIMERANCHIJoin our development team to create innovative software solutions for education and business applications. Work with modern technologies and contribute to meaningful projects.Key Highlights:Expertise in PHP/ASP.NET/VB.NET/MySQL/SQL ServerStrong problem-solving and analytical skillsExperience with web development frameworksCompetitive...
-
Backup And Storage Engineer
8 hours ago
Ranchi, Jharkhand, India Diligen Professional Solutions Full time ₹ 4,00,000 - ₹ 12,00,000 per yearPosition: Engineer Storage & Backup ManagementLocation: RanchiExperience Required: 3+ YearsQualification: B.E. / B.Tech / MCACertifications: OEM Certification in Storage / Backup (Oracle / SQL etc.) preferredKey Skills:SAN, NAS, VTLEnterprise Storage AdministrationBackup & Database ManagementJob Responsibilities:Administration of SAN, NAS & backup tools...
-
Data Analyst
2 days ago
Ranchi, Jharkhand, India TechnoRight Full time ₹ 4,20,000 - ₹ 8,40,000 per yearJob description and Understanding :Salary : 12 to 70 LPA Profile : Data Analyst Your key responsibilities : - Ensure accurate calculation of all the Indexes via the execution of all daily production procedures and controls while operating within strict deadlines. - Perform routine quality assurance procedures, which include checking prices and...
-
Cloud Solution Architecture
2 days ago
Ranchi, Jharkhand, India Microsoft Full time ₹ 12,00,000 - ₹ 36,00,000 per yearWith more than 45,000 employees and partners worldwide, the Customer Experience and Success (CE&S) organization is on a mission to empower customers to accelerate business value through differentiated customer experiences that leverage Microsoft's products and services, ignited by our people and culture. We drive cross-company alignment and execution,...
-
Ranchi, India VJ Consultant Part timeoracle 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...
-
IT Faculty
2 days ago
Ranchi, India Aptech Learning Full time_Dear Sir/Mam,_ - Greetings from Aptech Ranchi....!!!!_ - We are proud to introduce ourselves as one of the experts in imparting education in varieties of Career Programs, IT Courses & Computer Courses ; **APTECH COMPUTER EDUCATION.** _ - With the boom in demand of professional & job oriented courses and rise in acceptance of corporate & MNC’s for...
-
Dot Net Developer
2 days ago
Bariatu, Ranchi, Jharkhand, India Csharptek Full time ₹ 10,00,000 - ₹ 16,00,000 per yearJob Title: .NET + Azure DeveloperCompany: CsharptekLocation: Ranchi, IndiaExperience: 4–6 YearsJob Overview:Csharptek is hiring a talented and experienced .NET + Azure Developer to join our team in Ranchi. The ideal candidate will have 4–6 years of hands-on experience developing enterprise-grade applications using .NET Core, C#, and Microsoft Azure...
-
Cloud Solution Architecture
1 week ago
Ranchi, India Microsoft Full timeWith more than 45,000 employees and partners worldwide, the Customer Experience and Success (CE&S) organization is on a mission to empower customers to accelerate business value through differentiated customer experiences that leverage Microsoft's products and services, ignited by our people and culture. We drive cross-company alignment and execution,...