Data Services OfferingYear 2015Nippon IT Solutions 1About Nippon ITS Company Founded and Managed by Team with 10+ years Experience on Different Database and Oracle Applications Products. We have one of best team of Experts (In house ,Freelancers and Contracts) We follow SLAs and Security polices of customers and if not available we help building them. Our team is highly Motivated ,Customer friendly and Passionate about their work. We provide Services at reasonable prices and with very professional approach. We are not YES MAN , we are honest , Straight forward and Even sometimes Blunt but all this is for benefits of our Customer. Our aim is to use experience to help you run your business effectively. Nippon IT Solutions 2Database Services Key Offerings Administration Remote/onsite/Shared/DedicatedDatabase ImplementationDatabase Migration and UpgradeDatabase Assessment and performance tuningDatabase ConsolidationDatabase Infrastructure and Oracle Engineered SystemsDatabase DesigningNippon IT Solutions 3DBA services Round the clock DBA Availability Single point of contact for each shift. Experience and Expertise of team of DBAs at cost of 1 Providing daily / weekly reports of database issues Solution for different Database Product under one roof. Industry Experience / Certified DBAs Strictly follows customers security guidelines We maintain confidentiality of Customer data. Suggesting how can we get more out of existing infrastructure.DatabaseNippon IT Solutions 4 Remote DBA From Nippon ITS locations Dedicated Services Dedicated Team of DBA Assigned Shared Services A team of DBA maintaining Multiple Clients and Multiple Database. Onsite DBA At Client Side Dedicated DBA On Demand Vacation DBA For existing customers - if they need project based ramp up or when their primary DBA is on Vacation. Staffing Services Provide DBA as Contract to Hire.Why DBA from Nippon ITS?Models We OfferDatabase Administration Saving in Infrastructure cost ,Recruitment, Training cost and payroll costs Multiple Shift resources taken care by us. SME available for inability of frontline DBAs Multiple platforms support. Multiple Products SupportWhy Remote DBA?Why Dedicated DBA? Complex Projects or Development Setups High availability Requirements Walking support required by Client teams Unstable Environments Heterogeneous Environments Initial Implementation. One Dedicated DBA at onsite as point of contact.DatabaseNippon IT Solutions 5Customers Premise or Datacenter Nippon IT Solutions OfficeTeam of DBAsContract Manager Customer SpocDatabase systemVirtualized MachineGateway Infrastructure Cloud / EnvironmentManagementInformation / Alerts / TicketsAdministrationCustomer SpocDatabase systemVirtualized MachineGateway Infrastructure Cloud / EnvironmentManagementInformation / Alerts / TicketsAdministrationImplementationDatabase Basic Database Implementation. Heterogeneous connected Database systems. Golden Gate Setup for heterogeneous Environment for different Database products Physical or logical Standby Database system for oracle database. Real Application Clusters for Oracle Database. Clustered MYSQL Database implementation. Microsoft SQL Server Failover Database Implementation. Database As Services Implementation using Oracle Engineered system and Oracle Enterprise Manager 12cOur Approach Implementation Capabilities Nippon IT Solutions 6Migration and UpgradeDatabase Database version Upgrade Oracle 9i to 12c MySQL 5.x Microsoft SQL Server 2000 to 2014 Oracle Applications Upgrade Migrating environments to high-availability environments Migrating database to EXADATA Oracle Applications version Upgrades Zero downtime upgrades and Migration.Capabilities Our ApproachNippon IT Solutions 7Database AssessmentDatabase Installation using Default configuration Old backup Strategy Unused users in application database making it vulnerable. Change in Security Policies Evaluation of Stability of DatabasesWhy Database AssessmentCapability All versions of databases for Oracle / MYSQL / MSSQL Engineered Systems. Traditional Infrastructure.Our ApproachNippon IT Solutions 8Database Performance TuningDatabaseDatabase Server Memory TuningDatabase Memory TuningOperating System TuningStorage DefragmentationDatabase Query TuningClusterReplication TuningBackup Recovery Tuning Is your Application Users are raising requests for timeouts? Is your batch processes takes longer than usual. Have you upgraded your Database? Have you added more users and more functionalities on applications? Have you consolidated Schemas of different applications?Do I need Performance tuning?If answer to all these questionsis YES . You need Performance Tuning Services.Our CapabilityNippon IT Solutions 9Hi g herS er v i c e L ev el sFaster upgradesStandardizing the Database operating systems.Easy Manageability of Database infrastructure Less servers less Capital investmentLess Server Operations costSavings on PowerEnvironment friendlyFaster aligning business need.Faster provisioningFaster / Automaticscale up and scale down Bound to have better service levels due to Standardized infrastructure Higher up timeduring patchingI nc r eas ed a g i l i t yReduc ed Compl ex i t yCos tReduc t i onDatabase Consolidation Business DriversDatabaseNippon IT Solutions 10Database Consolidation Our ApproachDatabaseDatabase Grouping.Security requirements.Server requirementsStorage requirements.Tool for DaaS for faster implementation and better support.Present infrastructure Detail studySpecific requirements of certain application if anySecurity setup for this infrastructure Monitor the database growthOptimize storage and CPU utilization on basis of real usage.Monitor security BreechCreate Seed database for adding new database groups.What is objective of consolidation Probability of successful consolidationWhat is the present InfrastructureWhat is present SLA ?What is present support cost?ImplementationImplementing Storage and infrastructureImplementing database provisioning applicationsGroup Database and create Seed Database for each.Provision databases as per application needsMigration of the DatabasesSetup monitoring tools.Test the load and fine tuning of the Database Infrastructure.Performance monitor and changes as per requirementsNippon IT Solutions 11Database Consolidation Our CapabilityDatabaseCloud ImplementationImplementation and Support of database on Cloud products MS SQL server on AzureOracle Database Cloud solutionsDatabase on AWS CloudDBaaSConsolidation of multiple database server to one Engineered Database Infrastructure.Faster Provisioning of databaseEfficient and controlled Self service Database provisioning.Schema ConsolidationSchema consolidation Fitment AnalysisPerformance and Database Parameter changes to suit consolidated schemaSchema Migrations and Consolidation Planning.Database ConsolidationConsolidation using Oracle Database 12cConsolidation of databases onMicrosoft SQL ServerNippon IT Solutions 12Database InfrastructureDatabaseHardwareCloud VirtualizationCapabilityInfrastructure Services and Consulting. Design Database Infrastructure Procurement Consulting. Implementation at site Database on Cloud server Implementation and Support Virtualization Design and Implementation and support. Operating System Installations of Windows / Linux .Nippon IT Solutions 13Oracle Engineered SystemsDatabaseEngineered system FitmentFeasibility StudyImplementation Plans and Roadmaps.ConsultingHigh AvailabilityExadata Machine Configuration Backup strategy ImplementationInstallation & ConfigurationMigration Process and DocumentationNon Oracle / oracle to Exadata MigrationOracle EBS on ExadataMigration ServicesDatabase as a service implementationZero downtime migration using Golden GateDatabase and application performance tuning after implementation Tuning & Value Add ServicesNippon IT Solutions 14Database DesigningDatabaseNippon IT Solutions 15Discussion with Functional TeamsRequirement Document AnalysisDiscussion with Technical Team -Frameworks and TechnologyCreating Logical / Functional ModelCreation of Physical modelCreation of ScriptsSupport during developmentDocumentation and Final Delivery of model ERWIN PowerDesigner by SYBASE MySQL Workbench Microsoft SQL Management Studio SQL Developer Microsoft VisioDatabase Modelling Tools Our ApproachData Warehouse &Business IntelligenceConsultingNippon IT Solutions 16Data warehouse and BI offeringsAdvisory DW & BI Strategy Business requirements Dimensional Modelling Dimensional Model Design ReviewImplementation DW-Database BI and Reporting ToolsDevelopment DW Management ETL package Development Reports Development Analytics DevelopmentSupport DW Database Changing ETL Packages Performance issues Manual loading of data if needed. Monitoring Nippon IT Solutions 17Consulting DW& BI Strategy BusinessRequirements DimensionalModelling Dimensional Model Design Review Existing DWBI Setup Existing Strategy Reviews Existing Requirements Review Dimensional Model Review DW Architecture AlternativesReview Dimensional DatabaseModelling IntuitiveModel Logical Database Design Physical Database Design Joint Design Workshop with Customer Modelling Interview Key Stake holders Build business focusedRequirement Discussion with key stake holders for their views. Setup project Success CriteriaRequirements Readiness Assessment Strategy Prioritization Scope Management Analytics Need Reporting Need StrategyNippon IT Solutions 18Implementation DW-Database BI and Reporting ToolsData warehouse - Database InstallationsWe have capability to install and configure Oracle 10g to 12C, Microsoft SQL server 2008 to 2014 for DWHWe provide high availability solutions for Databases DWHWe Provide services to implement DWH on EXADATA which provides capability to have HOT data in-memory for faster loading.Our Approach Our CapabilitiesNippon IT Solutions 19Implementation DW-Database BI andReporting ToolsConsulting Select best suited Tool for BI and Reporting as per client requirements. Implementation Roadmap and Documentation.Implementation of the BI and Reporting tools Infrastructure setup. Installations and Configuration.Connectivity Tests with DWH and Other sources and DB servers.Post implementation and configurationsupport for preliminary setup of the Development and deployment team.Documentation of implementation and Configuration.Nippon IT Solutions 20Development DWH Management ETL package Development Reports Development Analytics DevelopmentDeveloping DWH Management Scripts for Monitoring DWH environment Monitoring Connectivity with Connected Databases.Design / ImplementExtraction packages from different databases.Design and Implement Customized Data Cleaning and Transformation packages.Developing Reports Solutions Reports can be emailed from DWH to list of users. Providing support for External reporting system solution.ProvidingAnalytics development for Complex Reports Massaging data, AggregatingData, Computationfrom dataNippon IT Solutions 21Support DW Database Changing ETL Packages Performance issues Manual loading of data if needed. Monitoring Database Administration SupportBI Tools Administration and Configuration supportReporting server / Tools SupportDeployment Management SupportData loading monitoring and support Performance management for optimized DWH , Extraction , Loading and ReportingLoading data manually for offline process. And Atomization ofthe manual process for faster data availability.Daily monitoring and health check for proactive maintenance. Nippon IT Solutions 22Implementation ,Development and SupportDatabase ProductsBI and ETL ProductsNippon IT Solutions 23Oracle ApplicationsConsultingDesigningImplementationGlobal RolloutsRemote and Onsite Technical SupportDevelopmentCustomer Relationship ManagementService ManagementFinancial ManagementHuman Capital ManagementProject Portfolio ManagementAdvance ProcurementSupply Chain ManagementNippon IT Solutions 24Oracle ApplicationsSalesMarketingCommerceServiceSocialSiebel CRM TechnologyConsultingDesigningImplementationGlobal RolloutsRemote and Onsite Technical SupportDevelopmentNippon IT Solutions 25Nippon IT Solutions 26Address5, Vishal Apartment, S. V. P. Road,Kandivali West,Mumbai - 400 067.Maharashtra.India.Direct Contact+91 (0) 9821 884629+91 (0) 22 28633327Fax+91 (0) 22 28085940EmailFor general information and feedback information@nipponitsolutions.comFor Database Services,sales-database@nipponitsolutions.comFor Application Services,sales-application@nipponitsolutions.comSocial MediaNippon IT SolutionsNippon IT Solutions 27Nippon ITS Delivery Centers We have delivery centers across India Mumbai:Head office and Marketing office.Oracle Applications Stack, Remote Database implementation and SupportServices , Data Science services (DW/BI and Bigdata), Web applications , Enterprise Mobile Applications and Gaming Solutions , Web portals United States: Onsite Data Services , DW/BI and BigData Advisory and Delivery Ahmedabad :Android Mobile Applications.Nippon IT Solutions 28