Abhishekk Siripally’s Post

🔍 Looking for IT solutions? Look no further! Get in touch with us to explore staffing options, business continuity planning, cloud computing, DevOps engineering, and more! 💻 Our team of experts includes IBM DataStage and Informatica developers, Java and .Net developers, and many others! 🌐 #informationtechnology #staffing #businesscontinuity #cloudcomputing #devops #ibmdatastage #informatica #java #dotnet #technology #itexperts #computerscience #digitaltransformation #innovation #techsolutions #ustringsolutions 🚀

Transform your SQL workflow with DBHawk's SQL Job Scheduler! 🔄 Automate tasks seamlessly across Oracle, SQL Server, Redshift, and more. Request a demo today and experience efficient job scheduling. https://lnkd.in/gzdg-akG #SQLAutomation #DatabaseManagement #JobScheduling #DataAutomation #TechInnovation #SQLWorkflow #DatabaseSolutions #DataIntegration #DBHawk #DatabaseOptimization #ITAutomation #DataManagement #SQLTools #CloudDatabase #SQLServer #OracleDB #Redshift #NoSQL

Hello Connections #urgenthiring #c2c #usajobs #usa #remote #plsql #plsqldeveloper Heny U H Babu G Rahul Gandam Venkata Raju Yadav Job Title : PL/SQL Engineer Location: 100% Remote, EST hours Required : PL/SQL Oracle Databases Extracting Data out of Databases Creating Tables Doing Compares between tables of Data Spreadsheets for Analysis with other groups Not just Excel - using spreadsheets currently, but data is too great to utilize spreadsheets Looking to get it put into Tables (PLSQL to fine tune and compare) Mostly PLSQL, not so much ETL/API development "Scripting to call an API"… not so much technical, and not Banner Specific Interfaces, what's in the other systems? What got missed? Comparing Data to Data Creating Tables, statements… Manipulating Data for comparison Creating Stores, extracting core subject matter from a table… 10-12 different data points (800,000+ records) Share profiles at vinay@7kingscode.com

Streamline Your SQL Workflows with DBHawk's SQL Job Scheduler! Introducing DBHawk's industry-leading SQL Job Scheduler, designed to automate and simplify batch scheduling across various databases like Oracle, SQL Server, Redshift, and more. Get real-time status updates, monitor complex jobs, and maintain complete control with comprehensive audit logs. Perfect for database administrators, developers, and business analysts looking to enhance their workflow automation. Learn more: https://lnkd.in/gzdg-akG #SQLAutomation #DBHawk #DatabaseManagement #JobScheduler #TechInnovation #SQLServer #Oracle #Redshift #NoSQL #BatchScheduling

Hi All, I caught-up a situation in my work which required to extract all DataStage jobs into an XML files from my current project so I could see more then 350+ jobs which takes almost 2-3 working days if we do export one at a time. If we export all of them into one time that may take 5-10 mins but we cannot use the individually. So I found a way to split big one XML into small individual DataStage job XML's. To achieve that I develop a Code Snippet in Unix Shell Scripting. I hope this will help someone. Script Name: Separate_XML.ksh All XML file Name : project.xml Way to run: Separate_XML.ksh project.xml Separate_XML.ksh #! /bin/bash set -x # Define the input XML file input_file=/home/user/$1 # Extract job tags fom the input XML file start_lines=$(grep -n "<Job Identifier=" $input_file | cut -d ":" -f 1) # Loop through each extracted job tag for line_number in $start_lines; do # Extract the JobName from the job tag job_name=$(sed -n "${line_number}p" $input_file|cut -d '"' -f 2) # Write the job tag to a Separate XML file like jobName.xml sed -n "$line_number,/<\/Job>/p" "$input_file" > /home/user/project/${job_name}.xml echo ${file_name}.xml Created done

Oracle Database 19c: Essential Tools for Database Management and Development Oracle Database 19c includes powerful tools for database management and development. Here’s a quick look at SQL*Plus, SQLcl, and Oracle SQL Developer: --SQL*Plus :- Command-line Interface: Execute SQL and PL/SQL commands. Scripting: Automate tasks with SQL scripts. Reporting: Generate formatted reports. Database Administration: Manage users and perform maintenance tasks. --SQLcl (SQL Developer Command Line):- Enhanced Command-line: Modern interface with additional functionality. SQL History: Reuse previously executed commands. Inline Editing: Edit commands directly in the terminal. Data Export/Import: Output in JSON and CSV formats. Liquibase Integration: Manage database changes. --Oracle SQL Developer:- Graphical Interface: User-friendly for database management. SQL Worksheet: Execute and view SQL/PL/SQL commands. Database Object Management: Create and manage objects. Data Modeling: Design and model databases. Debugging and Tuning: Debug code and optimize queries. Integrated Reports: Monitor and analyze databases. Version Control: Integrate with Git and Subversion. Want to discuss further or have any questions? Feel free to reach out! #Oracle19c #DatabaseManagement #SQLPlus #SQLcl #SQLDeveloper #DatabaseAdministration #DataDevelopment #DatabaseTools #OracleSQL #OracleDBA #Tech #IT #SoftwareDevelopment #DataModeling #VersionControl