Query oracle accounting details Jobs

use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days you provide code to simulate input data (both code versions: python and sql)-> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78, 5, 23, 41. When 34 for 20%; 65 for 30%; 12 for 40%; 78 for 10%; 5 for 15%; 23 for 70%; 41 for 30% randomly for e...

I'm in need of a professional QuickBooks Accountant, preferably with a solid background in the services industry. Your main responsibility will be to manage my business's bookkeeping. This isn't a typical bookkeeping role; you must understand the specifics of service-based accounting. Your ability to navigate QuickBooks with ease and deliver accurate results is crucial to this role. Any competent and experienced accountant should apply, but I'll be particularly keen on those with a proven background managing books for service-based businesses.

As a growing company, we've fully set up our QuickBooks Online but it's in need of a thorough review and ongoing management. We're looking for a QuickBooks expert who can help in the following areas on a monthly basis: - Setting up sales and expenses - Managing stock - Budgeting Your responsibilities will involve keeping the system up-to-d...following areas on a monthly basis: - Setting up sales and expenses - Managing stock - Budgeting Your responsibilities will involve keeping the system up-to-date, ensuring financial data consistency, and providing insights to support our decision-making process. The ideal candidate for this role would be an experienced accountant with previous QuickBooks Online experience. Knowledge of other accounting tools and financia...

use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days *****you provide code to simulate input data -> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states randomly 30 to 170 transactions per day for given product for usual price randomly 200 to 600 transactions per day for given product for promotion random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78,...

Being an accountant, I am in immediate need of a basic yet highly professional website serving as my online presence. This website should concisely convey: - The specific services I offer Noteworthy for any freelancer interested in undertaking this project: - Ex...serving as my online presence. This website should concisely convey: - The specific services I offer Noteworthy for any freelancer interested in undertaking this project: - Exceptional command over website design fundamentals is integral - Previous expertise in creating websites for professional services, especially in accounting, would be ideal - Delivering the completed website at the earliest is paramount Bring your A-game and let's create an online footprint for my accounting services. I look forwar...

...bugs and security vulnerabilities in the current project. Ensure the new version adheres to the latest security standards. API Integration: Connect the backend with the frontend using APIs. The APIs should be well-documented, secure, and efficient, allowing seamless communication between the backend and frontend. Requirements: Proven experience with CodeIgniter 3 and 4. Strong knowledge of SQL query optimization. Expertise in identifying and fixing bugs and security issues. Experience with API development and integration. Ability to work with the existing database structure without alterations. Good communication skills and ability to provide regular updates. Deliverables: Fully upgraded CodeIgniter 4 project with all features and functionalities working as expected. Optimize...

...user’s earned by their distributed albums. The encoded tracks need to be stored on cloud storages like amazon S3. The assets can be download from amazon s3 when ever required for distribution. The platform needs a: Distribution software with Release Creation System Catalog management Content tracking Analysis Daily Trends Analysis Audience targeting Monitoring of music lists Video editor Royalty accounting software Neighbouring Rights Collection DMCA automated takedown Min. Requirements: - Must have experience with DDEX music supply chain and infrastructure - Experience with B2B DDEX implementation - Experience with technologies such as JSON/XML, AWS, NoSql, Python, Javascript - Familiar with MEAD standards provided by DDEX, Ruby on rails knowledge. Please only apply if ...

We have a program on C# written on Visual Studio. We want to modify the current program, which read bar codes on a warehouse, for other sections of the company. On this project we will like it to get information from different Oracle tables. Job is to use the original code that we provide and make modifications to adapt to our new requirements.

looks like you're encountering a MySQL error related to an incorrect DATETIME value in your query. This error typically occurs when the format of the date and time being used in the query does not match the expected format in MySQL, or when an empty string is being used where a datetime value is resolve this issue, you should first check the format of the 'date_scheduled' values in your 'banners' table to ensure they are in the correct DATETIME format. You might also need to modify your query to handle cases where 'date_scheduled' might be empty or incorrectly you're not sure how to proceed or need further assistance with checking or adjusting your database, you can manage and review your MySQL databases and their tables from S...

I'm seeking an experienced software developer to create an accounting application that is compatible with the Windows operating system. It's a high priority that this application seamlessly integrates with Zoho Books. Key Features: - Integration with Zoho Books Required Skills and Experience: - Software development - Familiarity with accounting software - Knowledge in developing Windows applications - Experience working with Zoho Books API would be a significant advantage Timeline: - The project needs to be completed within a month. This role is perfect for a problem solver who has an eye for detail and understands the importance of creating user-friendly applications. If you think this project aligns with your skills, I'd love to hear from you.

Here is the quote of the work I did.

As a growing company, we've fully set up our QuickBooks Online but it's in need of a thorough review and ongoing management. We're looking for a QuickBooks expert who can help in the following areas on a monthly basis: - Setting up sales and expenses - Managing stock - Budgeting Your responsibilities will involve keeping the system up-to-d...following areas on a monthly basis: - Setting up sales and expenses - Managing stock - Budgeting Your responsibilities will involve keeping the system up-to-date, ensuring financial data consistency, and providing insights to support our decision-making process. The ideal candidate for this role would be an experienced accountant with previous QuickBooks Online experience. Knowledge of other accounting tools and financia...

I’m in need of an experienced Excel software engineer who specializes in automation. The project revolves around automating data entry tasks in Excel. We are an accounting firm and I am looking to automate my compliance practices. Tasks include 1) rolling forward previous year excel work papers 2) taking information from. Client data sheets (excel) and importing into new excel workpaper workbook 3) data analytics based on metrics 4) hyperlink to source data Ideal candidates should have: - Proven experience with Excel macro programming and automation - Ability to work with numeric and legal data - Strong attention to detail to ensure data accuracy This will be a valuable addition to our workflow. Looking forward to your proposals.

I'm in need of a proficient expert who can assist me with running queries on DuckDB using data originating from Amazon S3. This task primarily involves: - Interacting with semi-structured data such as XML and JSON - Processing a substantial data volume ranging from 1GB to 1TB The ideal freelancer should have the following capabilities: - Deep understanding and experience with DuckDB and Amazon S3 - Strong skills in handling and querying semi-structured data - Experience in managing and processing large volumes of data Please note: it's critical that the freelancer have experience with managing these sorts of tasks previously and has a solid understanding of large volume data manipulation.

...Outstanding experience and expertise in Odoo implementation and project management. - Proven track record in integrating third-party software and adapting functionalities. - Exceptional familiarity with CRM, Inventory Management, Accounting, and us of Odoo apps to manage food delivery. Key tasks include: 1. Data Migration: -Taking CSV files of my exported sales data from Shopkeep and importing it into Odoo without loss of critical information in order to enable reporting on old sales data. 2. Odoo Implementation: - Doing initial setup for Inventory Management and Accounting, as well as direct to consumer food delivery provided by our own drivers, each with its relevant functions and tools. 3. Third-Party Apps Integration: - Seamless integration of specific third-pa...

I'm in need of a knowledgeable expert to help manage my bookkeeping using FreshBooks. Your tasks will primarily involve: - Maintaining financial records and handling all business transactions - Ensuring accuracy and maintaining systematic order Ideal candidates should be well-versed with FreshBoo...Your tasks will primarily involve: - Maintaining financial records and handling all business transactions - Ensuring accuracy and maintaining systematic order Ideal candidates should be well-versed with FreshBooks and have profound experience in accurate bookkeeping. A strong comprehension of financial statements and the ability to organize large amounts of data are also critical. Previous accounting experience would be a bonus. Prompt, reliable, and detail-oriented professionals...

I'm in need of a professional who not only understands the concept of accrual accounting but can also create captivating PowerPoint presentations. Here are some specifics about the job: - Content: The presentation will solely focus on accrual accounting. It should be educational in nature, but also engaging for the target audience. - Purpose: This is not for a conference or business meeting. The main goal here is to educate the employees in my company who utilize accruals in their day-to-day work. - Design: The PowerPoint should be visually appealing and professional, with a good balance of text and visual elements. Ideal skills for this job include: - Strong understanding of accrual accounting - Previous experience creating educational content - Proficiency in ...

1. A portal (website) and Mobile app to accept quotation from customers 2. Customer had to register and must submit following details : a) Mobile Number (Must verify through OTP) b) Email id (Must verify through OTP) c) GST Number (if available ) d) Google map location (if available) after successful registration customer can login and request quotations 3. All the products details like: Product Name, photo, description, features, pdf (data sheet), warranty information, stock (available quantity), sale prices etc. can be uploaded directly through portal and mobile app and also can be uploaded through excel sheet with serial number of all products. 4. Customer can see all the uploaded products and can request for quotation. There is no need to show the available quantity (sto...

I need to use a plugin in word press/woocommerce to provide payments via wire for amounts excceding $xxx in our word press with out exposing our bank details to the customers

...NodeJs/Flutter/React Native/Firebase ONLY Key Features: - Travel Package Booking aimed at solo travelers and families. - Search feature to search for destination - Provide detailed information about the package (including directions) - Wallet system for cash management (only to manage refunds) - accounting history - Vendor payment - Booking/cancellation/notifications/feedback The admin panel should include: - User management - Data uploading for treks - Payment management - app configurations I have more details to share with the chosen developer for further fine-tuning. Ideal Candidate: The ideal freelance candidate should have previous experience in developing similar applications with a portfolio to share. A strong command over modern tech stacks is required. U...

I need an expert in Power Automate who can automate my data entry and reporting processes, notably form and workflow management. Among the tasks will be: - Creating automated workflows that take the data from Microsoft Forms responses primarily for accounting use and emailing the responses and notifications. - Setting up automatic email notifications as a response after the forms are filled out. The perfect candidate for this project should have strong proficiency in Power Automate as well as a good knowledge of accounting processes. They should demonstrate experience with data automation, report generation and workflow management. Understanding the sensitive nature of the data being collected, a strong sense of data privacy is certainly desired.

...aid in accounting and finance. The primary tasks include: - Bookkeeping: This involves accurate record-keeping of all monetary transactions. Your keen attention to detail and remarkable time-management skills would be beneficial. - Financial Reporting: A systematic record of all financial activities is needed for strategic planning. Expertise in preparing income statements, balance sheet reports, and cash flow statements is necessary. - Tax Preparation: Your tax preparation skills should ensure compliance with laws and regulations to avoid penalties. The individual best suited for this role should have a background in accounting, finance, or a related field. Experience working with sole proprietorships is a plus. Excellent analytical skills, familiarity wit...

I'm in need of someone with strong experience in PostgreSQL for some critical tasks. - The ideal candidate should be well-versed in PostgreSQL, with a background in both database administration ...be well-versed in PostgreSQL, with a background in both database administration and development. - You must be able to handle complex issues that may arise with the database and be capable of performance tuning when necessary. - I expect you to understand the nuances of PostgreSQL and be able to provide solutions to potential problems with the database. - Any experience with data migration, query optimization and database design will be a plus. Please make sure to include your past work and experience with PostgreSQL in your application. Your detailed project proposals are high...

i have one php script which used to load in a few seconds now takes 4 minutes not sure why it suddenly lags need optimised - the mysql query hittin some bottleneck somewhere by looks of it

I'm looking...an existing machine learning model into a Discord bot. The bot should cater to three main functionalities - sending daily race predictions, responding to user queries about race outcomes, and providing real-time race updates. Key Requirements: - Integrate an existing machine learning model into a Discord bot - Implement a feature to send daily race predictions on a specific channel - Develop a query system that effectively responds to user queries about race outcomes - Enable the bot to provide real-time race updates Your Skills: - Proficiency in machine learning model integration with Discord bots - Experience in developing chatbots, particularly for Discord - Knowledge of horse racing and related terminologies - Ability to create an efficient and responsive r...

...the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquire about availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the chosen courier to confirm the shipment. Automate File Transfer Based on Client and Project: Implement a system that automatically transfers the transport query from one file to another i...

...obligations on time to avoid penalties and unnecessary stress. Key responsibilities: - Handling monthly VAT filings: You will be responsible for ensuring my VAT returns are accurate and submitted in a timely manner - Managing yearly tax filings: As a sole proprietor, I have a specific set of tax obligations that need to be managed effectively Ideal skills and experience: - Proficient in Polish accounting and tax laws: Having a deep understanding of the local regulations and requirements is crucial - Experience working with sole proprietorships: Being familiar with the specific needs and challenges of sole proprietor businesses can be a significant advantage Please note that while this project is primarily focused on VAT and tax filings, there may be opportunities for addition...

...Windows platform. Ideal Skills & Experience: - Proficiency in Desktop Application Development - Strong MySQL and Database Monitoring Skills - Experience with WYSIWYG Template Management - Previous experience in PDF generation applications - Knowledge of Windows Application Development Additional Notes: a. application will need to determine which template to use based on a query b. Must be able to create, edit templates in an easy wysiwyg way. c. naming convention based on db record. d. Ability to add an option password to the PDF required. e. The resulting PDF must be stored in up to 2 locations (one maybe a unc path with username and password required) f. must be able to use multipl...

I'm looking for a ready-made ERP cloud accounting system like that offers these key features: - Inventory Management - Sales and Purchase Tracking - Financial Reporting I'm specifically seeking a system that has a: - Modern and sleek design I plan to integrate this ERP system with other software via API. Ideal Skills and Experience: - Experience with ERP cloud accounting system development - Proficiency in UI/UX designing - Proven ability in API integration with other tools - Familiarity with inventory management, sales tracking, and financial reporting systems. I want similar to

I need a skilled developer to integrate our custom in-house software with Oracle TimeCard. This is to allow for automated time entry. Key Requirements: - The integration should allow for automatic time entry from our custom in-house software to Oracle TimeCard. - The system should also enable the creation, updating, and deletion of timecard information in Oracle TimeCard. Ideal Skills: - Proficiency in Oracle TimeCard integration. - Experience with automated data transfer between systems. - Strong understanding of custom software integration.

...I've been manually tracking these transactions in spreadsheets, but I now need a more robust and automated system. - **Improved Organization**: The primary goal of this project is to enhance my overall financial organization. - **Investment Tracking**: A secondary but important aspect is to have a system in place for monitoring and evaluating my investment performance. Ideal Freelancer: - **Accounting and Bookkeeping Expertise**: Strong background in personal finance and investment bookkeeping is essential. - **Software Proficiency**: Experience in working with personal finance software is highly preferred. - **Organization Skills**: Ability to set up an intuitive and efficient system for tracking and managing my finances. The successful candidate will be able to streamlin...

I'm currently using Oracle Apex 20.1 and have an issue with Jasper Reports not executing properly. This can be a server side issue in JasperServer because the reports and applications are working fine in our development environment but in UAT are failing. I need a skilled professional who can troubleshoot and fix this issue. Your main tasks will include: - Analyzing the current setup and identifying what's causing the problem with PDF output. - Implementing the necessary changes to ensure Jasper Reports are correctly executed from Oracle Apex The ideal freelancer for this project would have: - Proficiency in Oracle Apex. - Strong experience with Jasper Reports - Past experience in troubleshooting and fixing similar issues, including server side issues. - F...

I came across a minor issue on my website on Digital ocean cloud server. Refer the below error information. I need someone who can fix me immediately in an hour. Error 500 PleskExceptionDatabase DB query failed: SQLSTATE[HY000] [2002] Connection refused

...seeking a competent Illustrator well-versed in the minimalist style of line drawings using digital media. This will be for a card that will be BLIND EMBOSSED. No printing, just a dyeline stamp that is used on white paper. My requirement is primarily for the architectural details of a building to be emphasized. The artwork must be clean, professional, and according to the minimalism ethos. Noteworthy skills include: - Proficiency in digital line drawing, especially in the minimalistic style - A keen eye for architectural details - Ability to interpret and emphasize architectural elements creatively Prior experience with architectural drawings will be highly appreciated. Additionally, the ability to work on a tight deadline is desired. I look forward to collaborating with yo...

website creation per details shared

I need an expert to comprehensively review the quarterly financials of 18 differe...asset in this project. Key Tasks: - In-depth scrutiny of quarterly income statements - Detailed examination of balance sheets - Profound analysis of cash flow statements Please note, a comparative analysis among the organizations is not required for this project. Your focus should solely be on individual organization's financial health. Ideal Skills: - Experience in financial analysis and accounting - Detail-oriented with proven analytical skills - Ability to interpret complex financial data This job will require thorough analysis and a keen eye for detail, hence relevant experience is highly sought after. If you are an analytical individual with a background in finance, then this proj...

A business-centric, data-oriented, and analytical mindset. Comprehensive knowledge of data science concepts and disciplines. Knowledge of enterprise information management processes and methodologies. Skil...management tools, cloud storage, and associated security considerations. . Combinations of experience and education will be considered on a case-by-case basis. Experience in data warehousing and governance. Practical experience in enabling data usability, availability, and efficiency. Experience in data management, quality, metadata management, and modeling. Knowledge of database systems: MS SQL Server, Oracle, or another commercial RDBMS required, Snowflake, or other non-relational database desired. Knowledge of SQL. Experience with scripting languages, especially Python, and P...

...specialist to establish and manage my accounting and auditing company's presence on LinkedIn from the ground up. The absence of a presence on this platform has been a significant missing piece in our marketing strategy. Key Tasks: - Developing and launching our LinkedIn business page - Consistent management and updates to the company profile Our target audience is predominantly local small business owners. consequently, the page should be optimized to attract this demographic. Ideal Skills and Experience: - Proven expertise and experience in setting up successful LinkedIn business pages - A mastery of LinkedIn's algorithms and features - Exceptional marketing skills specifically tailored towards reaching small businesses - A solid understanding of the accounting...

...Relationship Management (CRM): Proficiency in the management of all aspects of customer relationships, with the aim of improving business relationships, assisting in customer retention, and driving sales growth. - Project Management: Capabilities in managing projects, tracking progress, and ensuring smooth workflow in our small team set-up. - Billing and Accounting: Knowledge on maintaining a clean ledger, managing bills, conducting proper accounting, pushing follow-ups, and ensuring no dues remain pending. - Payment Tracking: Expert in tracking incoming and outgoing payments without missing any transactions. Time frame for project completion is within a month. Ideal candidate should have a solid background in business management, specifically for small businesses, and...

I'm seeking a Zoho expert to set up and configure Zoho One for my organization. We currently do not use any specific software or tools that need to be integrated with ...to be integrated with Zoho One. The main objective is to implement Zoho One for less than 10 users. Key Responsibilities: - Customize Zoho One to meet our business needs - Implement CRM, Sales Management, Email and Communication, and Finance and Accounting modules of Zoho One. - Provide necessary training to less than 10 team members on the use of Zoho One. Ideal Skills and Experience: - Extensive experience with Zoho One implementation and customization. - Proficiency in CRM, Sales Management, Email and Communication, and Finance and Accounting modules of Zoho One. - Ability to train small groups ef...

I'm searching for a skilled professional to automate key aspects of my business's accounting procedures. Here's a quick rundown of what I require: - Automation of onboarding and tracking Ideal candidates for this job should possess: - Profound experience with automating business processes - Previous working experience in accounting procedures - Knowledge about onboarding and tracking automation Understanding the requirements of the project and having proficiency in Gohighlevel will be vital. Efficiency, accuracy, and attention to detail are crucial for the successful completion of this project.

Saya mencari web programer yang berpengalaman dana Laravel dan Vuejs. Saat ini saya ada program pernjualan yang ingin saya upgrade agar program tersebut sekarang terintegrasi ...yang ingin saya upgrade agar program tersebut sekarang terintegrasi dengan akuntansi (akun perkiraan) seperti pada Accurate Online atau Key requirements include: - Integrating the current sales program with an accounting system. - The accounting system should be at a medium complexity level, including financial reports. - The primary focus for the integration should be on user-friendliness. Ideal Skills: - Proficiency in Laravel and Vuejs. - Experience in integrating systems, particularly sales programs with accounting software. - An understanding of accounting, especially in generat...

I am looking for a professional accountant, preferably based in Switzerland, to help me streamline and organize my ERP system, particularly ...would be highly beneficial Customizations: - While I do not have any specific requirements at the moment, I am open to suggestions and ideas from the selected candidate on how to further customize and improve the system Preferred Qualifications: - Prior experience with Odoo, particularly in setting up chart of accounts and tax configurations - Strong accounting background, potentially with a CPA qualification - Experience in Swiss accounting standards and practices would be a big plus - Proven track record of delivering similar projects with successful outcomes If you have the skills and experience to help me with this project, ple...

I need immediate assistance with TallyPrime for accounting entries and reconciliation. - Tasks include Sales and Purchase entries and Bank reconciliation specifically. - The completion time is critical as I need the project ready ASAP. Ideal applicants should have: - Proficiency using TallyPrime. - Strong experience with accounting and reconciliation. - Ability to work fast and efficiently. Please provide a brief overview of your relevant experience when applying.

I am looking for a proficient software developer to build an all-inclusive student fee management software. Key Features: • Ability to track multiple types of student fees • Capability to generate detailed fee reports • An automated reminder system. The software must smoothly integrate with our existing systems which include the school management system, attendance system, and our accounting software. Ideal Skills: • Experience in educational software development • Strong background in systems integration • Skilled in automation and report generation.

I require an experienced accountant to prepare a set of financial documents for my company. Last 2 year Audited Financial statements for the previous 2 fiscal year-ends: Income Statement, Balance Sheet, Cash Flow Statement Interim Financial Statements (Balance Sheet, P&L, Cash Flow Statement) Financial statements for the most recent interim period: Income Statement, Balance Sheet, Cash Flow Statement Merchant Processing Statement

I have bank statements from Bank A that I need converted into an Excel spreadsheet. The specific transactions you'll be dealing with are both deposits and withdrawals. Here's what I need: - A thorough and meticulous translation of each individual transaction: both deposits and withdrawals. - Once this data is entered into the spreadsheet, I need you to sort it by t...individual transaction: both deposits and withdrawals. - Once this data is entered into the spreadsheet, I need you to sort it by transaction type. This role requires expertise in Excel and a keen eye for detail is essential, as the integrity of the data will be paramount. Knowledge about financial transactions, specifically deposits and withdrawals, will be useful. A background in bookkeeping or accounting ...

I am looking for an experienced accountant to assist with our monthly bill amount. We want experience accountant to help with calculating and dividing up our yearly invoice into 12 months. The yearly amount is there but we want a skilled accountant who can divide the amount up to 12 months w...dividing up our yearly invoice into 12 months. The yearly amount is there but we want a skilled accountant who can divide the amount up to 12 months with each month amount figure being different from the other. For example, dividing $100,000 by 12 months but each month has a different amount but the the total of 100k is still the same. Ideal Skills: - Proven experience in accounting - Knowledge of relevant accounting software - Strong attention to detail - Effective communication and...

...Other category for miscellaneous expenses or income - I require a simple, user-friendly design that makes manual data entry easy and intuitive. Skills and Experience: - Proficiency in spreadsheet software such as Excel or Google Sheets is essential. - Experience in financial tracking and net worth management is highly beneficial. - Understanding of stock market, investment tracking, and basic accounting principles is a plus. Delivery: - I expect the freelancer to deliver a comprehensive, error-free spreadsheet that meets the specified requirements. - The spreadsheet should be easily updatable and not reliant on external sources for data input. - A brief tutorial or guide on how to use the spreadsheet would be appreciated. Feel free to share any relevant work samples or ...

I am experiencing slow query processing and management issues with large tables in my MySQL database, primarily storing transaction data. I am seeking a DBA specialist to diagnose and resolve these bottlenecks and improve the overall performance of the system. Ideal Skills and Experience: - Proven experience in MySQL database administration and optimization - Knowledge of query execution plans and optimization techniques - Proficiency in managing databases with 10-50 tables - Experience in handling databases primarily housing transaction data Tasks include: - Investigating and diagnosing slow query performance - Optimizing handling of large tables - Implementing necessary changes to enhance overall database performance.