Server and SQL Server Optimisation

Budget $100 - $150 USD
Bids 12
Average Bid $114
Status Closed

We are experiecing about 6gigs a month through our SQL server and are now experiencing SQL timeouts on our web sites. We need a SQL guru to have a look at our server and 1. Prepare a summary of the current load and operations 2. Prepare a roadmap to the next 8 months to what we should do to achieve scalablity 3. Implement the second plan. Further details will be given upon reply :) We would like this done for 3rd Feb 2003 latest.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.

## Platform

Windows 2000

## Deadline information

Need all documentation for 3rd Feb 2003. Will pay for stages 1+2 and then dependent on the report implment stage 3 as a separate project.

Get Free Quotes For 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

  • gbaren Profile Picture


    United States

    ## BIO MCSD, MCDBA Enterprise Architect with nearly 20 years of experience in Infrastructure, Client/Server, DNA, .NET, J2EE and ERP interoperability. Demonstrated outstanding accomplishments in several industries, including financial, manufacturing, computer telephony, audio/visual and human resources. Earned several advanced professional certifications: MSCD, MCDBA, SAP Certified Technical Consultant, NCSE and currently preparing for the SCEA. Led many successful design and development efforts. Systematically pursued balanced hands-on experience in infrastructure, software development and data architecture. SUMMARY OF ACCOMPLISHMENTS · Specified architecture, helped sell, led design and development of the NASDAQ MarketSite · Designed and developed the media-acclaimed NASD Visitor Center presentation system. · Designed and Developed an award-winning Human Resources system · Enabled a manufacturer to increase shipping by over 600% · Designed and implemented within budget and schedule the migration of over 1,000 in-house applications to Windows 2000 · Taught Visual Basic, SQL Server and Oracle · Reduced build and deployment time for a multi-platform n-tier system by 94% · Reduced customer wait time for an on-line transaction by 98% · Designed and developed an in-room billable fax system for hotels · Taught software applications for CPA continuing education SUMMARY OF TECHNOLOGY PROGRAMMING LANGUAGES Visual Basic 6,5,4,3 and 2; Visual Basic .Net; Visual C#; Java 2; Perl; Microsoft J++; ABAP/4; C; Clipper; Smalltalk; Pascal; RPG; Cobol; C196 PLATFORMS Windows 2000/.NET Server, HP-UX, Sun Solaris, Linux, Macintosh, Windows NT 4, 3.51, 3.1, Novel Netware 3.1x, 2.2, 2.1x, 2.0a DATABASES Microsoft SQL Server 2000, 7, 6.5; Oracle 9i, 8i; Sybase 11, 10; IBM Cloudscape DB2; Access; FoxPro/xBase APPLICATION SERVERS/MIDDLEWARE Microsoft Transaction Server, Microsoft COM+, Oracle 9AS, Jakarta Tomcat, IBM Websphere, MSMQ, IBM MQ Series INTERNET DEVELOPMENT ASP, JSP, ASP.NET, VB Script, Java Script, XML, XSLT, HTML, DHTML INFRASTRUCTURE W2K; MS ISA; DNS; IIS; Active Directory; Apache; HP-UX; Solaris; Linux; MS SQL; LoadRunner; SecurePoint; RAID; PBX PROFESSIONAL HISTORY 8/2002 – 2/2003 Fusion Technologies, Inc. Manager Evaluated IIS and J2E web site architectures for stability and scalability. Planned, defined and performed load tests. Designed, documented and coded solutions in ASP, .NET and Java. Designed and documented cross-platform deployment procedures for Windows, HP-UX, Solaris and Linux. Designed and implemented Virtual Private Database data security proof-of-concept in Oracle 9i. Designed and coded stored procedures in Transact SQL and PL/SQL. Defined and coded deployment consistency checking for Oracle and SQL Server. 11/2000 – 6/2002 Compaq Global Services, Inc. Architect/Project Manager Participated in a global corporation’s migration of 14,000 workstations and 600 servers from W95/NT4 to W2K/W2K. Gathered information about applications in use. Automated the information gathering procedures. Defined migration procedures for applications to Windows 2000. Documented and oversaw implementation of standards and procedures. Taught Windows 2000 development guidelines to Visual Basic, Microsoft SQL Server and Oracle developers. Mentored developers throughout the migration effort. Automated test plan generation for Windows 2000 standards compliance. Integrated SMS with Active Directory for application deployment across five continents. 11/99 – 10/2000 Dun & Bradstreet, Inc. Integration Manager Managed integration between several development teams on a multi-platform, n-tier E-Commerce project. Designed and automated build and deployment procedures. Led architecture and design of new components. Directed load and performance testing. Specified development, QA and productions hardware architecture. 1996 – 1999 Independent Consultant · Ernst & Young: secure custom file transfer protocol for tax compliance system. · Global Markets Online: US securities trading web site for foreign traders. · Acsis, Inc.: SAP add-on product for barcode input in Inventory and Warehousing modules. · Becton Dickinson: Human Resources system for career development and succession planning. · Inn Technology, Inc.: In-room fax system for hotels. · Paine Webber: Project office automation. Global integration of project plans and resource allocation. 1986 – 1996 Computer Network Services, Inc. President Developed automated Audio/Visual computer systems for the financial and marketing industries. Purchased, installed and maintained networks. Developed custom software. Developed the NASDAQ MarketSite and the NASD Visitor Center. 1985 – 1986 Beta Lambda, Inc. Programmer Developed software in C and Basic for the control and calibration of electronics test and measurement systems. 1983 – 1985 Crumb & Forster Insurance Senior Mainframe Operator Scheduled batch jobs and monitored their progress. CERTIFICATION 2002 Microsoft Certified Solution Developer 2002 Microsoft Certified DBA 1997 SAP Certified Technical Consultant 1992 Novell Certified System Engineer EDUCATION 1986 New Jersey Institute of Technology Computer and Information Sciences 1982 Steven’s Institute of Technology Computer Science ## Area of Expertise Visual Basic Visual Basic.NET ASP ASP.NET MS SQL Server Oracle Access C# Java 2 VBScript JavaScript Clipper

  • codestrom Profile Picture


    United States

    ## BIO . ## Area of Expertise .

  • tentechnolo Profile Picture



    ## BIO    ## Area of Expertise Dear Sir, We are **TEN Technologies**, a premier software development organization engaged in 100% software export and technical support services. We are having industry wide experience of over 100 Man years in implementing various projects (E-Commerce, Enterprise App., B2B & B2C App., Games & Interactive Animation, Web Design, Development, Hosting & Promotion (Search Engine Submission, SEO Analysis), Spatial Business Systems, Network Applications, Embedded Systems and Device Drivers). We adhere to the industry standards for ensuring quality at every step and provide 24 X 7 X 365 support via Email, Phone and Fax. The maximum response time via email is 1 Business HR. We have a team of 20+ developers/designers having in-depth knowledge in their domain and ample Industry wide experience. We can deliver the complete project as per your requirement to your satisfaction, with in best possible time frame. Contact us to discuss about your project in detail as well as to get the BEST deal in the industry. \*\*\*|\*\*\*|\***| Areas Of Expertise \*\*\*|\*\*\*|\***| We have ample experience in following segments: \***| Internet Application Interfaces : Microsoft .NET, HTML 3.2+, FrontPage, MacroMedia Web Development Suit, Visual Studio, InstallShield and WISE Install Studio, Java, PERL, PHP, Cold Fusion, C/C++, Visual Basic, VBScript, JavaScript, CGI, ActiveX, ISAPI, MFC, ASP and JSP, J2EE, XML, WML, COM/DCOM/COM+, Windows / BSD Sockets, MDAC, DAO, RDS and ODBC. \***| Database Design & Development : SQL Server, Access, Oracle, MySQL. \***| Security Architecture Design and implementation : Authentication, Authorization and Data Protection using: Digital certificates, Smartcards, SET, SSL, PGP, firewalls, application level security. \***| Communications : E-mail hosting and integration, mail distribution (LISTSERV), discussion groups. \***| Business Consulting : Services Business needs analysis, concept development, project planning, project management, constituent segmentation analysis and tracking, marketing analysis and planning. \***| Creative Services : Mac and PC platforms; user interface design, original artwork, illustration, animation and sound using: Adobe Photoshop and Illustrator, Shockwave, Flash. \***| Technical Consultation.

  • timk98 Profile Picture


    United States

    ## BIO Current Job: Internet Software Engineer - IMS Health, Inc. Maintain/develop a set of database-driven web sites. Develop internal web based applications. Database sizes of over 1 million records. ASP/DHTML/JScript/XML based. Previous Job: Web and Database Development - Technology Business Research, Inc. Maintained/developed/tested internal and external web based applications. Also developed desktop data entry applications and data conversion solutions. ## Area of Expertise Web Development, Database Integration, Data Conversion, Database-driven web sites, Desktop applications, Graphical user interface, Visual Basic, C++, Delphi, Assembler, ASP, JavaScript, HTML, DHTML, XML/XSLT, SQL Server, Access

  • evangaline Profile Picture


    United States

    ## BIO | A full service software developer, creating e-solutions ranging from basic web-sites to robust e-commerce / database applications. I am experienced in developing creative and diverse solutions to difficult problems in both single and multi-user environments. An excellent communicator, I will work closely with you to achieve your goals. I will remain focused on your project, provide frequent progress reports, and deliver a product that meets your exact specifications. All code is delivered tested - ongoing technical support is provided for the lifetime of the project. Every project includes either a customized setup program or, in the case of websites, installation of the files on your server. To assist you with disaster recovery I also maintain a repository of all completed projects - if you should ever experience a catastrophic loss of data on your PC or Server, your original project files are readily available to you at no charge. If I can provide any additional information, please don\'t hesitate to ask. I look forward to working closely with you in fulfilling your project\'s needs. **Sample sites** * <a href=\"\"></a> * <a href=\"\"></a> * plus many more... ## Area of Expertise * Client / Server Application Development  * Windows Software Development * Web Site Design & Maintenance * Administration Systems * Database Design & Administration * Graphics Design

  • visiontechvw Profile Picture



    ## BIO Kamalesh P. Shirpurkar Strengths I can effectively lead large and small inter-disciplinary teams, including managing information flow and facilitating quick collaborative problem solving across organizations. I have excellent analytical and entrepreneur skills and a demonstrated ability to complete time-sensitive projects on schedule. My background is an advantage when resolving technical issues; I can grasp and design software in any new technology. My career includes nearly 8 years in various IT positions Current Skills Ability to evaluate and identify new and emerging technologies and/or include some aspects of business development, such as identifying potential technology or marketing partnerships Database Designing, Object Modeling, User Interface Design (GUI), Prototyping, Content Management, Use Case Scenarios, Project Management, Client Handling, Scheduling and Reporting Projects, QA Testing, Designing Templates, Visual Design, Requirements Documentation, Functional Specifications. Familiarity with Windows development environment, SSAD, OOAD, Documentation Software MS Project, VISIO, Rational rose, Erwin. Knowledge of Java and Visual Basic and Web technologies Vertical Domain Banking, Mortgage, Financial Accounting, Inventory, Relocation management, Road Quantity Calculation and Estimation, Shopping Cart, Builder and Real Estate, ERP Experience From 2001 Click Technologies (I) Pvt. Ltd Project Manager/System Analyst Responsible for Client Satisfaction, Analyzing the System, Identifying technology for the user requirement, Scheduling, Reporting, QA Testing, Documentation, Client Point-of-Contact Responsible for the information architecture and interaction design of web-based or Intranet (Client Server) projects including security system, Event logging and application flow. Tasked with translating client requirements into functional designs through the use of user-centered design principles and the creation of user interface models. Responsible for defining and promoting best practices and standards for the managing project life cycle at the company Accomplishments: · Successful implementation of projects in said time · Designed Framework and Architecture · Designed System, Application flow & Database · Successfully implementation of Offshore Development solely by discussing the application with the client in telephone-conference · Designed security system · Developed RAD tools to improve quality as well as to reduce development time · Designed task detail templates to maintain quality, integrity and consistency 1999-2001 ADCC Research & Computing Center Ltd. Project Manager/Technical & Functional Consultant Responsible for Client Handling, Analyzing the System, Scheduling, Reporting, QA Testing and Documentation Responsible for the information architecture and interaction design of Intranet (Client Server) projects including security system, Event logging and application flow. Tasked with translating domain knowledge and user requirement into functional designs through the use of user-centered design principles and the creation of user interface models Accomplishments: · Successfully converted DOS-based application into n-tier windows-based application · Designed Framework and Architecture · Designed System, Application flow & Database · Designed Complete Banking system considering future enhancements · On-site implementation of project 1995-1999 Abacus Softwares, Nagpur, India Project Leader / Sr. Programmer Responsible for Demonstrating Product, Client Handling, Analyzing and designing the System, Scheduling, QA Testing, Programming Responsible for the architecture and interaction design of a banking product Tasked with conversion of user requirement into functional designs through the use of user-centered design principles and the creation of a product Accomplishments: · Successfully designed and implemented complete retail banking application on various sites · Designed System, Application flow & Database · On-site implementation of project 1993-1995 Computer Media, Nagpur, India. Programmer Responsible for Designing and Programming Accomplishments: · Successfully designed and programmed an engineering software · Integrated FoxPro with AutoCAD EDUCATION · B.E. in Computer Technology. PROFESSIONAL CERTIFICATIONS · Microsoft Certified Programmer in Analyzing Requirements and Defining Solution Architecture (84 %). · Sun Certified Java Programmer in Java-2 (86%). SEMINARS DELIVERED · Seminar on “Design Patterns and Framework†at ADCC Research & Computing Centre Ltd. SEMINARS ATTENDED · Seminar on “Microsoft.NET architecture†Organized by Systems Architect Program, Microsoft. ## Area of Expertise We are a team having expertise in Microsoft as well as Linux technologies. We have developed component in C# as well as worked on Commerce server application in ASP. net. We have worked on Component designing, Client server application, web application, PDA application. We are having team of creative and fast designers. We have designed templates for nearly all types of sites. We can send details or can show you all these applications.

  • ClintS Profile Picture


    There,  Australia

    I have more that 9 years software development and project management experience and provided a Software Development consultancy service to my clients. The nature of the work has been dependant on the individual clients business needs. This has included the development of new software applications, the maintenance of existing systems, projects management and analysis and design.

  • qwertypotyt Profile Picture



    ## BIO I'm a lead developer and architect at a leading Bank of Turkey. I've been working on enterprise app. design and development for 4 years(workflow systems, document management etc.) ## Area of Expertise Expert on UML. Expert on architecture design. Expert on SQL 7.0 & 2k Expert on VB 6.0, ADO. Expert on VB.NET, C#, ADO.NET, ASP.NET.

  • dbross Profile Picture


    Plovdiv,  Bulgaria

    Audio chat Video chat Instant Messenger Socks proxy TCP Tunnel UDP Tunnel P2P Tunnel Secure Instant Messaging for companies - Free Secure Instant Messaging -

  • halleyscomet Profile Picture


    United States

    ## BIO EXPERIENCE 8/1998 - Present CONFIDENTIAL Southborough, MA MIS Director Migrated print based Distance Learning platform to Internet based to meet shifting paradigms in Financial Services Continuing Education. Developed more efficient reports to reduce the time and cost of providing clients with the data they required. Designed and implemented automated reporting systems to allow clients to directly import student course data into their system of choice without manually editing data at their end. Reduced time necessary to hand key paper based Needs Analysis Surveys by creating an optimized data entry utility, reducing processing time by 60% Created Automated Online System to allow for flexible creation and reporting of Needs Analysis Data, eliminating 90% of paper based Needs Analysis Surveys. Developed applications to shift major report generation to off-hour usage, to reduce demand on the database server during peak hours. Created optimized student management interface, increasing efficiency, and reducing average Customer Service call time. Created wrapper for login process to eliminate several web design constraints and eliminate several categories of tech support calls. Wrote initial specifications of desired API functions to be added to a vendor's Learning Management System. Implemented system to allow for pass through login processes. Created automated systems to allow students to add courses to their accounts, reducing customer service calls by approximately 70% Wrote initial specifications for new shopping cart system. ## Area of Expertise Skill Name Skill Level Last Used Experience Perl on Win32 Intermediate Currently used 3 years Java / JDBC Beginner Currently used 1 years Java Server Pages Beginner Currently used 1 years Windows 2000 Server Administration Expert Currently used 2 years MS SQL Server 7 / 2000 Administration Expert Currently used 3 years Windows Exchange Administration Beginner 1 year ago 1 years Visual Basic Intermediate 1 year ago 2 years Linux Instillation and Configuration Beginner Currently used 1 years C++ Beginner 2 years ago 1 years Windows 95/98 Troubleshooting and Administration Expert Currently used 5 years IBM OS/2 Beginner 3 years ago 1 years Learning Management System Design Expert Currently used 4 years