Remote Database support
Core of almost every application in your organization is data and database which holds your vital data. Databases are the underlying backbone of the organization enabling customer service, finance, production operations, sales & marketing, human resources, payroll, and sales & marketing functions. Databases are the engines which facilitate smooth functioning of day-to-day operations, strategic decision-making, planning, and forecasting.
Database administration team at Varchai have rich experience, certifications and skill sets you need to ensure your database environments have high availability, performance, and security.
To enable secure remote DBA support Varchai has secure infrastructure with firewalls, physically secure infrastructure with two level redundant power backups.
Remote Database support service model of Varchai can be tailored to suit your database support requirements. These models include shared resource, dedicated team, on-demand to help our customers optimize on the investments to support databases. Varchai offers 7days a week x 24 hours a day x 365 days a year Support.
Varchai offers the following levels of support remotely to allow our customers to pick and choose based on their support requirements.
Level 1
- Monitoring the Database
- Monitoring trace files
- Free space check at the database level and OS level
- Performance monitoring
- Health checkups of the database
- Daily backup monitoring activities
- Alter log monitoring
- Monitoring the custom log files if any
- Monitoring the Invalid objects at the database level
- Monitoring the third party custom applications
- Monitoring the SR’s
- Downloading the patches and transfer of patches to the required location
- Monitoring the database locks and Application locks
Level 2
- Creating the users
- Assign roles and responsibilities
- Password change for application users
- Configuring the TNS details for the application users/developers
- Changing the file permissions
- Addition/resize of the datafile, if the tablespace free space is less than 10%
- Compressing the archive log files
- Monitor the backups were send to tape or not
- Compressing the trace files and tar the trace files
- Killing the long running session, as per the request
- Compiling the invalid objects at the database level
- Granting permissions to application users at the object level
Level 3
- Database installation
- Database configuration at the application level
- Analysis of the database for upgrade
- Database upgrades from lower version to higher version
- Performance analysis of long running requests
- SQL tuning and analysis of long run operations
- Backup failure analysis and restarting the backups
- Working closely with Users and application developers for understanding the requirements
- Weekly cloning activities
- Working on ad-hoc database refresh activities
- Database growth analysis
- Working on weekly status and monthly status reports send to the client DBA manager
- Working on the code movement objects for the production database
- Production database patching
- Co-ordination with Network administrator and Client Manager for planning outage activities
- On –call support
- Working on Oracle supplied Tuning utilities
- Analysis of AWR and Statspack reports
- Tablespace tuning and datafile I/O
- Tuning contention, Segments and Sorting operations
Level 4
- OS installation for Oracle database
- Configuring backup tapes at the OS level
- Adding and CPU configuration at OS level
- Adding additional/Removal disk drives at the OS level
- Physically restarting the servers
- Monitor the health checkups at the OS level
- Managing the root password
