-Data Modelling and Database Design Create database designs by performing needs / requirement analysis, creating a logical mode, and then implementing the physical model. -Backup and Recovery Making periodic backups of data and keeping it safe from accidental or intentional destruction. Testing recovery plans so that when problems do arise, data can be restored quickly. -Capacity Planning Watch data growth, and plan how best to deal with it. This may include archiving it, increasing the size of current hardware, or adding new hardware. -Change Management Server configurations, database schema change over time. Perform impact analysis before changes are made, implement changes, test changes, and document them. -High Availability Ensure high availability, including use of log shipping, clustering, database mirroring, and other technologies. -Monitoring Monitoring performance, monitoring server disk space, monitoring logs, ensuring jobs have run successfully, checking for errors, and so on. -Needs/Requirements Analysis Perform needs/requirements analysis. Talking to users, finding out their needs and requirements, and determining the best way to meet them. -Performance Tuning Monitor performance to determine ways to optimize database performance. -Report Writing Writing reports against databases in transact-SQL code to extract the data, or creation and formatting physical reports. -Security Control who can access data and what they can do with it. Creating SQL Server login IDs, database IDs, assigning permissions, moving security between servers. -Testing Testing servers, testing databases, testing applications, testing management tools, and so on. Ensure that data integrity and high availability, is maintained at all times. -Training Users Sharing knowledge with other DBAs, developers, or end-users. -Working with colleagues Interacting with other DBAs, developers, end users, product-knowledge specialists, vendors, accountants, hardware experts, and networking experts.
Oracle PLSQL Job Cost Overview
Typical total cost of oDesk Oracle PLSQL projects based on completed and fixed-price jobs.
oDesk Oracle PLSQL Jobs Completed Quarterly
On average, 7 Oracle PLSQL projects are completed every quarter on oDesk.
Time to Complete oDesk Oracle PLSQL Jobs
Time needed to complete a Oracle PLSQL project on oDesk.
Average Oracle PLSQL Freelancer Feedback Score
Oracle PLSQL oDesk freelancers typically receive a client rating of 4.78.
Dwi Fitrianty Kurnia Agency Contractor
Dear my potential client, I am one of Indonesia's IT developer. I have enough experience in oracle as professional PL/SQL developer for 3 years also web development. The most challenging project for me was when I was doing project LARAS (Legal Application Replicated Access Support System) for PT. Telekomunikasi Indonesia in 2012. On that project, my role was became Team Leader of 3 people, business process analyst, and PL/SQL Programmer. The project is about how to make online contract between PT. Telekomunikasi Indonesia as a service provider, client, and third partner. It’s very big application because they use it to handle all contracts for the entire regions in Indonesia and every region has own complexity. The application built using RAD Framework as API, and Oracle as database. I and team did all modules in PL/SQL part include initialize contract, amendment, create new contract template, versioning contract etc. The difficulties were not only about how to transform business process into a system but also how to treat each regional’s complexity as well as possible without changing the process. I look foward for another challenging project from you
Financial and analytical Modeling using Excel. Creation of system interfaces for Oracle based software and MS-SQL server. Triggers, PL/SQL packages, views and sequences to facilitate the near real-time transfer of data between databases to facilitate Order Management and Accounting systems. Reports and log files captured in custom tables assist the administrator to maintain and troubleshoot the interface. Requirements analysis, project management, software development, reporting, testing, debugging, and implementation after acceptance.
I am an Oracle Developer with experience in Java. Linked to this I have worked extensively with XML and XSL. Trained ISO 9001:2008 auditor with numerous internal audits under the belt. I have written specifications (from user requirements to database design) and have done client support. I was system architect of one of the systems at my previous company.
I am an industrious goal-oriented individual who understands the necessity of good work ethics. I am adaptable, efficient, cooperative and organized. My goal is to help clients achieve their business objectives by delivering high quality work. My basic fundamental principle of ensuring client satisfaction and success is by identifying and conforming to the needs of clients. This saves my clients the time and money that it would cost to redo poorly done work. My qualifications: •I have a huge writing experience with great variety in topics and consistency in content quality •I maintain both the superiority of content as well as the specified deadlines •Great skill of elaboration as well as concision of content as per the article needs •High speed typing with great accuracy and reading capabilities •Studying and understanding orientation of the website under consideration and relevancy of the current topic with it •Searching the web for related information and data •Searching for the keywords useful to achieve excellent "Search engine optimization" of a website •Writing articles using the gathered information and inserting the keywords as per the context •Writing product descriptions •Social media management – I have worked with BuzzBundle and Hootsuite Social Media Management Software •Proficiency in the use of Microsoft Office Suite (Word, Excel, Access and PowerPoint) Additional skills: Oracle (Query writing - SQL and PL/SQL) Website Design and Development In short, I will deliver work that is of very high quality. Cheers, Anne "talent means nothing, while experience, acquired in humility and with hard work, means everything.” ― Patrick Süskind
I am a senior tester at Logigear testing company. http://www.logigear.com/index.php Have experience in both manual and automation testing (win-form, web-based, mobile) Have experience in Quality Center, People Soft, Jira, Test architect, Oracle, Red hat Linux OS, Windows OS Have knowledge about Action based testing, ABT test design, Agile I have very good searching, debugging skill and can learn new things very well (testing tool, development process...) I believe that you will get surprise and satisfied when working with me. Regards, Lam Nguyen
Abdullah Al Noor Agency Contractor
I have more than 12 years of experience of working in Oracle Technology in three Life Insurance companies. My best work includes: 1 - Life Insurance ERP, 2 - Deposit & Pension Scheme Systems 3 - Payroll with Access Control Systems and 4 - Learning Center Management Systems. I have hands on skills on : 1 - Oracle Forms (6i,9i,10g,11g Fusion Middleware). 2 - Oracle Reports (6i,9i,10g,11g Fusion Middleware). 3 - SQL (8i,9i,10g,11g,12c Database). 4 - PLSQL (8i,9i,10g,11g,12c Database). 5 - Oracle Application Server 10g,11g. 6 - Oracle Database Performance Tuning (8i,9i,10g,11g,12c Database). 7 - Oracle Database and Forms Installation in Windows and Linux. 8 - Web Logic. 9 - Data Migration from Access, Excel and Foxpro to Oracle. 10 - Data Migration from Oracle to MS. Access, Excel and Foxpro. 11 - Foxpro, MS Access & Excel 12 - SEO & SMM 13 - Wordpress I am a full time professional contractor and always available online to maintain easy and fast communication on skype or email to provide quality work. I am seeking the related job to use my skills and experiences in the best possible way. Based on my skill and previous experience, I am 100% confident to do a great work for you. Looking forward to work with you with Cheers !!! Abdullah Alnoor.