Database SQL Programmer Preferably in Ireland

Budget £20 - £40 GBP
Bids 18
Average Bid £32

Cornerstone Automation Systems are seeking SQL developers. We currently have four or five huge projects which require Database SQL programming using ftp interfaces with Oracle and SA400. This vacancy will be available for 1 year +. If you are interested in working with us, please respond to this post or email as soon as possible.

Kind regards,
Michaela

Post a Project Like This

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • anuragk2007 Profile Picture

    anuragk2007

    New Delhi,  India

    Good experience in Oracle Installations and Oracle Database 10g/11g on Linux platform, Creation through DBCA, Manual Creating and monitoring the tablespaces, allocating tablespaces for users. Creating and managing database objects like tables, views, and indexes. Creating users with restricted access with required privileges Creating profiles and attaching them with users and monitoring the users. Troubleshoot the issue as and when required. Analytical and able to adapt to new environments and learn new technologies quickly. Exporting and Importing database backups using Exp & Imp and EXPDP/IMPDP Utilities. Monitoring alert log files for errors and taking necessary actions to rectify them Rebuilding indexes to rectify segment fragmentation and analyzing indexes for better performance Experience in Hot/Cold Backup and Recover the Database when required. Taking Database table's logical backups using Data pump utility. Monitoring user sessions in regular basis and lock/unlock user accounts as per user requirements Monitoring database activity for users performance issues Resolving database related issues which are sent by the users Working on Unix shell scripting to automatic loading and daily database backups Having good knowledge on database architecture including background processes Experience in monitoring the performance Tuning of database using performance tools such as AWR, ADDM and advisor Extensive Knowledge on RMAN/ASM/ Data Guard Having desirable knowledge of Cloning of Database Change database id and database name using DBNEWID utilities.

    Linux, SQL, Oracle, and Shell Script

  • sankargan88 Profile Picture

    sankargan88

    Bhopal,  India

    Hi, This is Sankar Ganesh, Having 4 Years experience in Oracle Database Development and in Administration. Working at client Location and maintaining 4 Databases, 2 in 10g and 2 in 11g version.

    PHP, Data Processing, Data Entry, and Excel

  • kevnorton100 Profile Picture

    kevnorton100

    Partridge Green,  United Kingdom

    I am a database developer specialising in Oracle and MySQL. I am able to manage analysis, design and build of any size database based application. All my work will be thoroughly unit tested with demonstrable test plans. I also have a good knowledge of Oracle Forms, PHP and Java so have the flexability to develope the front-end of most applications. With a consultancy background I am able to communicate with all levels of any business, either from a technical or strategic perspective. I focus on delivering delivering quality software within agreed timescales.

    PHP, Java, JSP, and Javascript

  • JDKochan Profile Picture

    JDKochan

    DUN LAOGHAIRE,  Ireland

    .

    PHP, Perl, C Programming, and Java

  • amahmoodpucit Profile Picture

    amahmoodpucit

    Lahore,  Pakistan

    I can work in Java EE, Oracle ADF (Web), Oracle ADF Mobile, Java server faces, php+mysql, Javascript, jquery, html5, CSS, WordPress, Code igniter, CSS3,

    PHP, Javascript, J2EE, and AJAX

  • Rajmohan007 Profile Picture

    Rajmohan007

    singapore,  Singapore

    Athena software solutions offers services in ORACLE,SQL,Web development and related services. We have superior customer service with seamless execution of projects and project delivery to make our clients free from any worries.

    PHP, Visual Basic, Data Processing, and Project Management

  • ITProjs Profile Picture

    ITProjs

    Cork,  Ireland

    10+ years of experience in working with SQL Server 2012, 2008, 2005, 2000 and Visual Studio 2003-2010. Senior Designer/Developer and provide consultancy to Development teams. Skill set MS SQL/ SSIS/SSAS/SSRS technologies, ETL/ BI / Data Warehouse.

    .NET, Windows Desktop, Web Security, and Data Processing

  • vasu0devan0k Profile Picture

    vasu0devan0k

    Coimbatore,  Bahrain

    5+ years experience in writing and tuning SQL, PL/SQL and Oracle Database Administration activities and shell programming. 3+ years experience in developing Java, J2EE applications with EJB, Struts and Hibernate frameworks.

    Java, JSP, Javascript, and XML

  • solution222 Profile Picture

    solution222

    NEW DELHI,  India

    HAVING 9 YEARS EXPERIENCE IN HTML CSS XML XSL SQL PLSQL DATABASE DESIGN DEVELOP MENT. I would like to provide a quality work.ALLOW ME AN OPPORTUNITY TO DO WORK WITH U.

    Javascript, XML, Data Entry, and SQL

  • shivamsharma123 Profile Picture

    shivamsharma123

    Taoy?an,  Taiwan

    SHIVAM SHARMA Male | DoB 10th October 1976| ? 21C, Tower-3 Sea view Crescent, Tung Chung, Hong Kong | ? +852 69958496,+886 69958496 | ? Career Objective: To play a proactive role in a dynamic Software Development Environment and contribute with unparallel Commitment and Dedication. Specialized in : Business Consultant in Air Cargo Industry, Database development, Database Architect, Data Modeling, Liaison with Business users, convert business & functional requirement to the effective system. Profile: ? Competent technical & Functional problem-solver with strong technical background and hands-on development experience who can design solutions and provide technical expertise and support to the team members. ? Ability to adapt well with the present work environment which enables me to achieve stated and desired goals, in teams as well as individually. ? Sound knowledge of relational and object design methodologies, well versed with the client-server environment and Web based applications Using Latest Web Technologies. ? Excellent analytical and programming, communication and interpersonal skills that enable me to interact well with end users, managers and technical personnel and capable of working well with teams as well as on an individual basis. Professional Background Master of Science (Specialization in Electronics), having 10 years of experience in Air Cargo, Financial & Logistics projects. Possess a deep understanding of how to utilize the Information Technology with the Project management background in order to deliver enterprise solutions that meet requirements of business. Highly result oriented with right attitudes, integrity, team building skills, exposure to international clients, analytical abilities, proactive approach in problem solving through understanding of business process re-engineering and technical expertise. INDUSTRY EXPERINCE: Total Experience: 10+ NIIT TECNOLOGIES Pte,Hong Kong JAN 2005-TILL DATE Business Solution Specialist / Technical Specialist DCM LTD.,NEW DELHI FEB'03-DEC '04 Assistant Manager- IT GLOBALINFOWAYS,NOIDA MAR '01-JAN'03 Analyst/Programmer BIPS INFOTECH LTD.,JAIPUR JAN'2000-FEB'01 Programmer Technology Exposure Operating System Windows NT,95, 98,XP, HP-UNIX,IBM-AIX Language SQL, PL/SQL, ABAP (SAP R/3), Pro*c, ANSI C, Unix Shell scripting Web Servers IIS, JWS, PWS, Web-sphere, Web logic Database Oracle 7, 8i, 9i, 10g & 11g Tools Front Page 98, TOAD, VSS. Project Management Tools Microsoft Projects, Visio, SVN, GUI/ Oracle Tools Forms and Reports 4.5, 5, 6i/10g, Designer PROJECT SUMMARY Project Business Domain Period Role Warehouse management system (WOS) Air Cargo, Logistics Feb'09- Till Date Business Solution Specialist / Technical Specialist Cargo Management System(CMS) Air Cargo, Logistics Oct'10 - Till Date Project Lead, Functional Manager/ Data Analyst Cargo Operating system(COSYS) Air Cargo, Logistics JAN'05-Jan'09 Team Lead, Business Analyst Molasses Monitoring System Sales, Purchase, Accounts, Finance, Budget & Budgetary control Sep'04-Jan'05 Assistant Manager Sugar Claims Sales, Accounts, Finance, Budget & Budgetary control Mar'04-Jul'04 Assistant Manager Kaizen Information System Human Recourse Jan'04-Jul'04 Assistant Manager Total Integration Module Accounts, Finance, Budget & Budgetary control, Assisted (via remote) with payroll, tax, and account processing. Developed automated monthly sales tax payment system. Implemented Rapid Tax Refund service for individual customers. Aug'03- Mar'04 Programmer Machine Management System Production Sep'02- Mar'03 Programmer Website for Trading Trading Dec'00- Jun'01 Programmer Payroll Management system Human Recourse Ltd Jan 00-Nov00 Programmer Project Title WOS (Jan'09 - Continue ) Cathay Pacific Service Ltd. Hong Kong Description Cathay pacific is the subsidiary of the Swire group U.K. and expanding their business in Air Cargo under the name of "Cathay Pacific Service ltd." For Cathay Pacific, NIIT Technologies has designed, developed and implemented the Warehouse Operating System (WOS) which has tailored to serve the growing demands of the air cargo industry. The e-freight complaint system will be in-line with the terminal's facility design to enable the most efficient flow of cargo and to facilitate speedy processing of all types of cargo. The system is scheduled to go live in the middle of the year 2013. The new terminal for the Cargo services has planned to be ready by FEB'13 in Hong Kong. Terminal will be the capacity of the 3.64 Million tons per years. Being a Cargo management system this system will have various modules like Import, Export, ULD, Flight, SLA Performance monitoring, Tracing etc, it's also have various interfaces with the external parties like Customs, TIDS, SITA, GLS etc. This project has been started in Aug'08 and will have cutover in Jan'2013 My Role Currently project has completed and Preparing for cutover. I'm Involved in timely and quality delivery for all phases. o Providing Functional & DBA support i.e. table-spaces, schema, roles etc setup, managing partitions, Tuning of DB i.e. create indexes, tune existing packages/procedures, monitor DB jobs, checking DB health. o Project leader, BA for Major Modules & DBA support in project. o Understanding process flow and gathering CPSL's warehouse requirements o Analyzing requirements to make the system compatible with multiple interfaces and capability for future enhancements and accommodating change in business flows. o Designing solutions to customize the Cargo system as per CPSL's requirements, Hong Kong Air Cargo Practice & Customs needs. o Leading team of 24 members in Construction and UAT phase to customize the existing system as per customer needs with modular approach and quality along with designing/Building interfaces for other systems like SITA, CUBIC, MHCS, FIDS, ACCS, TRAXON, TIDS and MIS. Tools/RDBMS Oracle 10g, Pro*c, Unix , PL/SQL , Unix, Oracle SQL Loader, RMAN Utilities, MS Word 2003, MS Excel 2003, MS Visio 2007, MS PPT 2003, Oracle server 11g, Web logic, SVN Project Title CMS (Oct'10 - Continue ) Asia Airfreight Terminal, Hong Kong Description Asia Airfreight Terminal (AAT) is an Air cargo terminal based at Hong Kong International Airport, Asia's premier passenger and cargo hub. Operating on a franchise awarded by the Airport Authority Hong Kong, AAT serves the world's leading airlines, offering a comprehensive range of quality services, from physical cargo handling to documentation processing. Capacity of the terminal is 1.1 Million tons per years. NIIT has implemented CMS (Cargo Management system) in 2007 successfully. Being a Cargo management system this system have various modules like Import, Export, ULD, Flight, SLA Performance monitoring, Tracing etc., it's also have various interfaces with the external parties like Customs, TIDS, SITA, GLS etc. My Role Currently project is in Maintenance & Enhancement phase. Involved in timely and quality delivery for new enhancement and performance tuning of CMS system o Technical & Functional project leader o Understanding process flow and gathering AAT's warehouse requirements o Analyzing requirements to make the system compatible with multiple interfaces and capability for future enhancements and accommodating change in business flows. o Designing solutions to customize the Cargo system as per AAT's requirements, Hong Kong Air Cargo Practice & Customs needs. o Leading team of 4 members in Enhancement phase to customize the existing system as per customer needs with modular approach and quality along with designing/Building interfaces for other systems CMS, MHS, and MIS. o Providing DBA support i.e. table-spaces, schema, roles etc. setup, managing partitions, Tuning of DB i.e. create indexes, tune existing packages/procedures, monitor DB jobs, checking DB health. o Developed iPhone application for AAT customers, which is being used by customers to trace & Track their shipments. o Incited the Process of eAWB in AAT system. Tools/RDBMS Oracle 10g, Pro*c, Unix , PL/SQL , Oracle SQL Loader, RMAN Utilities, MS Word 2003, MS Excel 2003, MS Visio 2007, MS PPT 2003, Oracle server 11g, Web logic, SVN Project Title COSYS-EGAC (Feb'05 - Jan'09) Evergreen Air Cargo Services-Taiwan Description It is a Cargo Handling System being developed for Evergreen Air Cargo. The project was successfully implemented. However with the increase in business and stiff competition the client request for major enhancements and support. The main business functionality of COSYS-EGAC application works around the export and import of cargo. Whole of COSYS application is divided into seven modules- Export, Import, Airway Bill Management, Unit Load Device Management, Flight, Accounting and Electronic Data Interchange (EDI). COSYS follows client server architecture with Front end developed in Developer 2000 and business logic implemented through stored procedures, packages. COSYS-EGAC is 24*7 OLTP system, which is running on 100 concurrent machine, handled average 1100 shipments, 100 Flight's per day. My Role Being Part of the Development Team, Complete SDLC, Part of Inception Phase, RA Phase, Elaboration phase, Construction, UAT, Implementation Phase, Now Leading Team of 4, System Support (24*7), Dealing and improving the process flow of the warehouse and Enhancing/changing the application to best suit the customer's needs. Building interfaces for other Systems, Tuning and enhancing the system, write Low Level Design (LLD) specification. Responsible for development and performance tune of the database objects and screens, maintenance of the Quality and process adherence. Major Enhancement: Auto freight in (For XFR Shipment), Barcode system Integration, MINET Implementation (Replacement of SITA Communication System), Air Cargo Handler Concept. Tools/RDBMS Oracle 10g, Pro*c, Unix , PL/SQL , MS Word 2003, MS Excel 2003, MS Visio 2007, MS PPT 2003, Oracle server 11g, Web logic, SVN, VSS Project Title Kaizen Information System (Sep 2004-Jan 2005) DCM LTD. Description This was a client-server based application, which use to keep track of the Ideas and Kaizen feed by the employees of the organization. The employees used to feed the ideas, which came in their mind, which could be beneficial for the company. The corresponding section co-coordinators viewed these ideas. When they found that the idea was O.K. the approved for implementation. After that when the ideas were implemented they were approved once again by the section coordinators to verify that they have been implemented and then they were termed as kaizen, for each Idea and Kaizen an Idea No. And a Kaizen No. was given. The MIS was generated on Employee wise and Section Wise Daily and Monthly. Prizing scheme was also there after certain kaizen nos. for the employees and this was also incorporated in the system My Role Analysis, Designing, Testing, Implementation and Support (24*7), Understanding the process flow of the System and enhancing/changing the application to best suit the customer's needs. Building interfaces for other Systems, Tuning and enhancing the system, write Low Level Design (LLD) specification. Responsible for Development, maintenance of the Quality and process adherence. o Assisted with payroll, tax, and account processing. o Developed automated monthly sales tax payment system. o Implemented Tax Refund service for individual customers. Tools/RDBMS Oracle server 9i, Developer 2000 - Forms 6.0, Reports 6.0 Project Title Molasses Monitoring System (July 2004-Sep 2004) DCM LTD. Description This was a client-server based application, which used to keep track of the sales of Molasses, which is by product of our factory. Briefly the software used to perform the following functions: - (i) Registration of Customers for purchasing Molasses. (ii) Track of data related to each truck i.e. how much Molasses was sold per day to which customers to Which truck nos. etc. (iii) Current balance of Molasses in our factory tank no. Wise. Balance of molasses to be supplied to each Customer My Role Analysis, Designing, Testing, Implementation and Support (24*7), Understanding the process flow of the System and enhancing/changing the application to best suit the customer's needs. Building interfaces for other Systems, Tuning and enhancing the system, write Low Level Design (LLD) specification. Responsible for Development, maintenance of the Quality and process adherence. o Management of A/R Accounts o Billing and Collections o Supervision of Accounting and Administrative Staff o Balance Sheet and Management Status Reports Tools/RDBMS Oracle server 9i , Developer 2000 - Forms 6.0, Reports 6.0 Project Title Sugar Claim Entry Jan 2004- July 2004 DCM LTD. Description This module is basically implemented for the claims of sugar claimed by the sugar agents as the compensation. The finance department makes payments of these types of entries and the module was integrated with the finance module. Integrated modules are Entry Tax, Debit and Credit Note, Claim Payment etc. My Role Analysis, Designing, Testing, Implementation and Support (24*7), Understanding the process flow of the System and enhancing/changing the application to best suit the customer's needs. Building interfaces for other Systems, Tuning and enhancing the system, write Low Level Design (LLD) specification. Responsible for Development, maintenance of the Quality and process adherence. Tools/RDBMS Oracle server 9i, Developer 2000 - Forms 6.0, Reports 6.0 Project Title Total Integration Module Aug 2003- Jan2004 Daurala Sugars Works Ltd. Description This module is basically implemented for the integration of all the existing modules graphically with the use of Oracle and Designer 2000, like Security System (all the Factory plan being displayed on the screen with all floor's information. The location of each employee is also displayed on the screen. HR management group can get the information about the particular employee at any time. The visitors can also restricted by this information, management can send the instant message to their employees. User can change their location so the message will be redirected to the current location of concerned person. My Role Module Leader, Requirement analysis, Application Design, User Acceptance for the Sales, Excise, Production, Inventory modules and implementation of the modules. Tools/RDBMS Oracle server 8.0.1, Developer 2000 - Forms 5.0, Reports 3.0 Project Title Machine Management System Sep 2002-Jul 2003 Daurala Sugars Works Ltd. Description This system was developed to streamline and enhance the efficiency of managing the various machines working in all over plant. This includes the machine maintenance schedule, total costing of machines. Total plants cost, total asset management, and dismantle process information, total recurring cost of Plant/Machines. It also includes the yearly/ Monthly maintenance cost graphically. I was the member of 4 Programmer's team for Machine Management System and Involve in to conduct the company's operational and strategic analysis and Developed an action oriented strategic plan and conduct the system analysis. 1 Designing (32) Database tables and (23) views. 2 Forms (15 Masters and 40 Transactions) and 70 reports. 3 Creating the PDM (Physical Data Model) using case tool S- Designer. 4 Writing 20 Database trigger and stored procedures using Pl/Sql. My Role Module Leader, Requirement analysis, Application Design, User Acceptance for the Sales, Excise, Production, Inventory modules and implementation of the modules. Tools/RDBMS Oracle server 8.0.0, Developer 2000 - Forms 5.0, Reports 3.0 Project Title Website for Trading Dec 2000-Jun 2001 BIPS-ICWORLDWIDE ,LONDON Description This website was developed to Enhance the Business of the Sansarsolutions on the Internet. Through this web site the Any client who is interested to deal in electronic component can purchase the Electronic component and he can also sell their Excess stock on the net by request of quote, web site also have the facility to make the regular client of Sansarsolutions. My Role Coding, Testing , Implementation and Support (24*7), Understanding the process flow of the System and enhancing/changing the application to best suit the customer's needs. Building interfaces for other systems, Tuning and enhancing the system, write Low Level Design (LLD) specification. Responsible for development, maintenance of the Quality and process adherence. Tools/RDBMS Window NT,IIS Web server, Window 95 Client, Active Server pages, Front Page 98,Java Script, VB Script., MS Access Project Title Payroll Management system Jan 2000-Nov 2000 BIPS-Bihilwara synthetics Ltd. Description This system was developed to streamline and enhance the efficiency of managing the various financial activities taken by the client. This encompassed several sub - system viz. Loans, Insurance, Related Pay Bill Management and pay stubs, tax statements, personal Loan information, salary advanced, PF, Bonus and personal information monitoring at activity/ subjectivity level. I was the member of 3-man team for Payroll Management System and Involve in to conduct the company's operational and strategic analysis and Developed an action oriented strategic plan and conduct the system analysis. Designing (52) Database tables and (8) views. Development of pay slip, loan, sanction slip, increments information, deduction detail slip. Timely Reminder Slips and related master modules using forms 4.5 and Report 2.5. Which included over 25 forms (11 Masters and 14 Transactions) and 19 reports. Creating the PDM (Physical Data Model) using case tool S- Designer. Writing 20 Database trigger and stored procedures using Pl/Sql. My Role Coding, Testing, Implementation and Support (24*7), Enhancing and tuning the project Tools/RDBMS Oracle 8.0, forms 5.0, Report 3.0, EDUCATION Year Degree Institute / University %/CGPA 1996-'98 M.Sc.(Electronics) CCS University 68% 1993-'96 B.Sc. CCS University 71% 1999 ADSET (Advanced Diploma in Software Export Technology) ASSET International, Delhi 85% 1996 CIC IGNOU 69% CERTIFICATIONS/Awards ORGANIZATION TITLE SPECELIZATION % OCP ORACLE ORACLE Certified Professional Build Internet Applications1Z0-141- 95% OCA ORACLE Corporation ORACLE Certified Associate Program with PL/SQL 1Z0-147- Introduction to Oracle9i SQL1Z0-007- 90% 88% CIC IGNOU Certified in Computers Certified in Computers 68% ADSET Asset International Ltd. Advance diploma in software export technology Oracle, Developer 2000, C, C++, Power builder, Networking essentials. 85% Excellence Award NIIT Tech. Award of Excellence Global Performer's Bounty Award NIIT Tech. Award of Excellence Unstoppable NIIT Tech. Award of Unstoppable Talent in Company Excellence in Team Guidance NIIT Tech. Award for team guidance during the Critical project execution. PERSONAL DETAILS Nationality Indian Date of Birth 10/10/76 Marital Status Married Address L- 113, Shastri Nagar, Meerut. 250 005 U.P (INDIA) Passport No. A7984557 Valid up to 2/10/2019 Contact Details /Telephone Email : , Mobile : 09760185505 (INDIA) Mobile : +852 69958496 (Hong Kong) ADDITIONAL INFORMATION My interests include solving mathematics puzzles like Su-Doku, Cricket, Swimming and badminton. I hereby declare that all the information provided by me in this application is factual and correct to the best of my knowledge & belief. Place: Hong Kong Date: 10th Sep 2012 SHIVAM SHARMA

    Graphic Design, Project Management, Data Entry, and Engineering