Remote Database Administration Services - Variance InfoTech

2. AGENDA Introduction 1 Remote Database Administration Our Services 2 Benifits Of Outsourcing 3 4 7 Esteemed Clientele 5 Facilities 6 Working Methodology

3. INTRODUCTION Variance InfoTech alias Your Database Manager is an organization capable of serving professional remote database administration services to clients of all size without compromising on personal attention to each. We aim at taking care of total database requirements of our clients so that they are free to concentrate on their core business. We have a specialized team assigned to each of our clients so that the administration and monitoring system is smooth and uninterrupted. Customers rely on Variance InfoTech to supplement their staff with 24x7x365 support from our team of database experts. Unlike in-house solutions or typical outsourced models,  Variance InfoTech leverages an innovative service delivery model that not only cuts costs, but also improves service levels. Variance InfoTech has quickly established strong footholds in fields of Offshore Remote Database Administration, Dedicated Development Center, Application Development & Maintenance, Software as a Service, Enterprise Solutions, Product Development & Support, Testing Services and Search Engine Optimization. Expertise in Quality & Project Management has helped us achieve high standards for our clients. Variance has achieved proficiency in offshore software development while improving reliability and speed of delivering solution for our customers.

4. Our Services Database Administration CRM Development SharePoint Development ✓ Branding & Templating ✓ ✓ Design and Architecture Microsoft Dynamic CRM ✓ Enterprise Search ✓ ✓ Proactive Database Administration Sage CRM ✓ Excel Service ✓ Sales Force CRM ✓ Performance Reporting and Problem Tracking ✓ Business Connectivity ✓ Web Based CRM ✓ 24x7x365 Support ✓ Social Computing Software Development Technology Search Engine Optimization ✓ Application Development ✓ Social Media Marketing ✓ Microsoft Technologies ✓ Applicatron Maintenance ✓ Directory Submission ✓ Java ✓ Application Migration ✓ Link Building ✓ Open Source ✓ Product Development ✓ Keyword Analysis ✓ Anroid Development ✓ Website Designing ✓ Video Submission ✓ I-Phone Development ✓ Website Development ✓ Press Release ✓ RFID & GPS

5. Benifits of Outsourcing Offload non-core functions Cost Effective 8 1 Redirect energy and personnel into the core business Time zone Advantage 9 2 Focus scarce resources on mission-critical projects Minimize capital expenditure 10 3 Spread your risks Get access to specialized skills 11 4 Provide the best quality services, products and people Level out cyclical or seasonal fluctuations 5 12 Enhance tactical and strategic advantages Eliminate peak staffing problems 6 13 Reduce the risk of technological obsolescence Avoid the cost of chasing technology 14 7

6. Remote Database Administration Remote DBA service is the practice of managing a database from, well, a remote location. Typically a remote DBA firm will have a service center or NOC (maybe more than one) from which all services are performed. It should go without saying that that technical people working in the NOC are composed of diverse professionals; experts in their field with broad niche knowledge to ensure their customers get answers when they need them. Remote DBAs should log in to your database and systems per your security requirements to perform selected duties – some reactively, some proactively, some as part of agreed-upon projects. Ideally, the remote DBA services firm will have an issue tracking system that transparently records all work performed on your databases, and they should have processes that ensure your issues and projects are handed off cleanly when they need to be worked at odd hours or weekends. Likewise, you should have a single point of contact with your remote DBA firm; when workers are not physically near each other, clear communication is more critical than ever. A remote DBA services firm should wield outstanding monitoring and tools. Any DBA’s goal should be smooth, uninterrupted system performance and reliable, predictive monitoring (with the ability to quickly respond) is the most critical tool in the DBA’s kit. Finally, a remote DBA services firm should be flexible. If you had a full-time person or an on-site consultant, they would work on what you want, when you want, right? Just because you use a team of DBAs who aren’t local to your office doesn’t mean you should compromise on flexibility.

7. Key Challenges Some of key challanges IT Companies faces today are, Variance InfoTech KeyChallenges DBA Staff Attrition 1 24x7x365 Support 1 A lack of Oracle/SQL expertise to support end-user demands 2 3 The high cost of supporting Oracle/SQL software 4 The need for 24 x 7 support of Oracle/SQL applications for worldwide implementations Skilled Resource at lower cost 5 Increasing pressure to reduce maintenance and system administration costs 6 Keeping pace with the technology and skills to manage Oracle technology 7 Keeping system downtime to a minimum &providing consistent and effective service 100% Satisfactory database solution

8. Our Service Model We offer wide range of services Choose only those which you require Cost Effective Package which suites your requirement. Create your own package

9. Database Server Administration Service Backup & Recovery Planning Installation & Up gradation 8 1 Database Mirroring , Log Shipping , Snapshots Managing Database and Log Files 9 2 Configuring Linked Servers Performance Tuning & Migration 10 3 Database Replication , SQL Server Clustering Configuring Recovery Model 11 4 Data Transfer, Database Mail Managing Security & Logins 5 12 Configuring Jobs & Alerts , Transferring Database Handing Blocking & Deadlock 6 13 Implementing High Availability & Disaster Recovery Database Protection & Availability 14 7

10. Database Development Service Error Handling, Transactions, Collations, Scripts Manipulating Relational Data 8 1 XML Database Integration Developing T-SQL DML & DDL 9 2 Indentify & Implement Full Text instead of LIKE Tables, Views, Index, Constraints 10 3 Optimization of long running T-SQL Store Procedure, Functions, Triggers 11 4 Managing data integrity Database Integrity & Optimization 5 12 Reports Development using Reporting Service Manage XML Data , Query & Index Optimization 6 13 Pivot and Matrix Reports Configuring & Managing Database Objects 14 7

11. Database Replication Service Oracle Replication SQL Server Replication Oracle Stream Replication Transactional Replication 1 1 Non- Identical Replicas with Stream Snapshot Replication 2 2 Sub – Setting Stream Merge Replication 3 3

12. Database Migration Service Host Based LVM Migration 1 Third Party Software Based Migration 2 Storage Array Based Migration 3 SAN Based Data Migration 4 Application Based Data Migration 5 Replication of Database across multiple servers 6

13. Facilities at Variance InfoTech ✓ Office in India State of Art Development Center ✓ ✓ Secure Premise Latest Equipment and software ✓ Multiple communication Channels (Phone, Email, IM) ✓ Firewall and latest antivirus ✓

14. Working Methodology

15. THANK YOU! Variance InfoTech www.varianceinfotech.com 202, Nandanvan Complex Subhash Bridge, Ahmedabad, India