Database Development and Administration
Encore understands that the backbone of any great application is
an efficient relational database. Encore has extensive experience
with SQL Server, Oracle, Sybase and DB2 databases.
Some examples of the types of database projects we have done:
- Custom Line-of-Business Applications: All companies have one or
more line-of-business applications that use a relational database.
Encore has built and enhanced hundreds of custom applications and
their databases to meet the varied needs of our clients.
- Data Marts - Encore has built data marts focused on customer
invoice data, purchasing trends, shipping history, and many more
- Data Warehouses - Encore has designed and built data warehouses
around customer relationship information, legal data, purchasing
defects and others
Service Offering: Encore SQL Performance Assessment (ESPA)
The Challenge
SQL Server Administrators are challenged with many important decisions about their SQL environment that affect
performance of the corporate applications. Some of the many concerns facing organizations with SQL Server include:
application performance tuning and monitoring, backup and recovery, configuration and licensing.
The Solution
A comprehensive, on-site evaluation of your server environment followed by findings and recommendations to improve
your SQL Server installation. These improvements will improve application performance, mitigate production risks and
provide a more robust environment.
The Offering
Encore will provide the following offering at your location:
|
Definition (At no cost):
- Task: A kickoff meeting to determine project scope
- Duration: 1-2 hours
- Deliverable: A project proposal
Proposal:
- Objective: Determine your SQL Server Administration requirements
- Cost: Fixed Fee
- Location: Your Site
- Duration: Typically Two Days to One Week
- Deliverable: Findings and Recommendations Document
|
Areas of Concern:
- Optimized backup and recovery strategies
- Data replication and mirroring
- Real-time performance and status information
- Business intelligence planning and reporting
- Current and future licensing needs
- Standards and best practices
Typical Recommendations might include:
- Server Configuration Changes
- Backup and Recurring Job Changes
- Database / Table / Index Changes
- Database Software Upgrades
- Database and System tuning and Performance
- Strategy to Define Business Intelligence
- Strategy to Define Data Model and Business Rules
- SQL Auditing and Logging
|
|
