|
Information System Online in Montreal, Quebec
Web System Administration
- Design system infrastructure.
- Establish Web system by planning and executing the installation, configuration, and testing of server hardware, software.
- Maintain Web system performance by performing system monitoring and analysis, and performance tuning.
- Troubleshoot system hardware, software, and operating and system management systems.
- Secure Web system by developing system access, monitoring, control, and evaluation.
- Complete back-ups and restores.
- Maintain documentation.
- Update job knowledge by tracking emerging Internet technologies.
- Configure Storage Area Network.
- Install, configure, and maintain:
- DNS (Domain Name System) services.
- Apache with SSL support, Virtual Hosting.
- Vsftpd (User Management).
- ISCSI mounted drive which combines both Network Attached Storage (NFS over IP Ethernet networks) and Storage Area Network (Fiber Channel Fabrics).
- Qmail for Basic Services, SMTP, Vpopmail virtual POP mail server; Vpopmail and MySql user database.
- MySql database with command line tool or phpMyAdmin.
Database Administration
- Ensure the database environment is designed and managed to meet business and IT demands for availability, performance and manageability.
- Be involved in application development projects to evolve database architecture and design.
- Monitor database operations, analyze and respond to performance and other maintenance issues.
- Have technical hands on a project administration, including inventorying and documenting forms, reports, notice etc.
- Participate in the creation, development, staging and production database instances, and the migration of those instances from one environment to another.
- Design database system infrastructure.
- Establish database specifications by analyzing access, information, and security requirements.
- Install, configure, manage, and maintain multiple MySQL databases.
- Design and create database.
- Manage Memory, CPU and I/O performance as well as assuring database health.
- Perform appropriate back-up, restoration and upgrades of database servers.
- Migrate MySql databases to another RHEL machine using MySql tool in command line.
- Secure MySql server by using Access Privilege System user, db, host tables in mysql database.
- Optimize MySql performance by indexing, optimize complex queries, increase buffer/cache sizes for big, multiple-statement transactions, for better index handling.
- Configure additional MySql slave server to replicate MySql master server and to perform backups.
- Maintain Database documentation.
Web System Analysis, Design and Implementation
- Use latest Open Source Web Technologies: PHP, Apache, MySql, SSL, ADODB that run on Red Hat Enterprise Servers.
- Analyze business processes and take end user and customer requirements.
- Design web site structure and creating web space.
- Register domain names and setting up DNS zone for registered domain name.
- Set up virtual domain in Apache httpd.conf file.
- Set up secure http (https) for transactions where applicable.
- Design relational databases and creating tables - entities, associative entities.
- Prototype and create web site template and settle it with the customer.
- Design and program web forms, information, warnings, and error messages.
- Program libraries, classes and function for the project.
- Program database access functions compatible with ADOdb Database Abstraction Library.
- Create restricted htaccess for the customer and/or end user in some cases.
- Create multi language support for website in such a way that adding new language takes no time.
- Finalize web application.
- Maintain, change, improve, secure, and optimize existing web applications.
- Back up existing code and writing documentation.
- Back up customer data (documents and pictures) and databases.
Projects and Applications
- Build and maintain high availability web server farm that uses external shared storage.
- Configure servers with redundancy at all levels to eliminate single point of failure using Cluster Manager Technology.
- Configure and manage Network Attached Storage instead of costly SAN (Fiber Channel Fabrics) technology.
- Establish Web system specifications by analyzing access, information, and security requirements.
- Build Information Systems Online and Dynamic Web Applications for Different Industries.
- Build multi-user client-server information system by using Visual Basic 6 and Access.
Customer, suppliers, order processing, reporting with enhanced security information system.
Hardware inventory tracking system.
- Migrate Windows NT 4.0 to Windows NT 2000, manage users, and upgrade H/W and Networks.
- Design and program data windows, scripts, events, functions, GUI using PowerBuilder for client.
- Migrate data from legacy system (FileMaker, Macintosh) to newly build (Visual Basic and Access 2000) Database Application.
- Build in-house Information Web Site that replicates Desktop Information System with data synchronization.
- Build Desktop Information System that process orders and keep track of inventory of auto parts for import/export department by using Visual Basic and Access.
- Visual Basic Application connects to Company Database and acquires auto parts and distributor's data for order processing.
Company database is an Oracle that runs on Solaris Server.
Application functionalities include:
Process order.
Lookup required data on the Oracle database.
Store extracted and processed data on the Access database for future reference and reports.
Generate Reports.
|
Compare our services!
Compare our pricing!
|
|
|
|
|