You will get database administration for oracle, mysql, sql server
Project details
I can work as Solution Architect for your Physical Database and offer you proper solutions.
I will offer you services related to Oracle (and mysql, sql server) Database Administration such as:
Oracle Database Installation on Windows, Linux and Solaris OS Platforms
SQL Tuning
PL/SQL Tuning
Oracle Database Backup and Restore i.e. RMAN, Data Pump, External Tables
SQL Loader,
Data Pump (IMPDP, EXPDP)
External Tables
DBMS Scheduler
Oracle Database Performance Tuning
Oracle Database Security
Oracle SQL Queries
Oracle Pl-SQL Codes
Oracle PL/SQL
Oracle Stored Procedures
Oracle Functions
Oracle Triggers
Database Stored Procedures (Oracle, MySQL, MS SQL, PostgreSQL)
Database Functions (Oracle, MySQL, MS SQL, PostgreSQL)
Database Triggers (Oracle, MySQL, MS SQL, PostgreSQL)
Thanks & Regards
Dinesh Vishwa
I will offer you services related to Oracle (and mysql, sql server) Database Administration such as:
Oracle Database Installation on Windows, Linux and Solaris OS Platforms
SQL Tuning
PL/SQL Tuning
Oracle Database Backup and Restore i.e. RMAN, Data Pump, External Tables
SQL Loader,
Data Pump (IMPDP, EXPDP)
External Tables
DBMS Scheduler
Oracle Database Performance Tuning
Oracle Database Security
Oracle SQL Queries
Oracle Pl-SQL Codes
Oracle PL/SQL
Oracle Stored Procedures
Oracle Functions
Oracle Triggers
Database Stored Procedures (Oracle, MySQL, MS SQL, PostgreSQL)
Database Functions (Oracle, MySQL, MS SQL, PostgreSQL)
Database Triggers (Oracle, MySQL, MS SQL, PostgreSQL)
Thanks & Regards
Dinesh Vishwa
Database Type
MySQL, MS SQL, MS Access, Oracle, SQLite, PostgreSQL, MongoDB, Couchbase, Teradata, Realm Database, Azure Cosmos DB, LevelDBWhat's included
| Service Tiers |
Starter
$20
|
Standard
$40
|
Advanced
$100
|
|---|---|---|---|
| Delivery Time | 1 day | 2 days | 7 days |
Number of Revisions | Unlimited | Unlimited | Unlimited |
Query Debugging | - | - | - |
Query Optimization | - | - | - |
Query Scheduling | - | - | - |
Query Analysis | - | - | - |
Source Code | - | - | - |
About Aththanayakage Dinesh Vishwa
professional in Microsoft SQL Server Database Administrator
Kegalle, Sri Lanka - 10:54 pm local time
Here Are my major skills,
- MS-SQL Server
- Database Administration
- Data migrating to MS-SQL Server
- Implementing database backups/recovery
- Database performance tuning
- Configuring High Availability Solutions (Always-On Availability Groups)
- Programing with TSQL
- SQL Query optimizing
The process of moving data from different sources into a Microsoft SQL Server database is known as data migration to MS-SQL Server. To guarantee data consistency and integrity, meticulous planning, implementation, and validation are needed. Data sources must usually be identified, fields must be mapped, data must be transformed as needed, and the migrated data must be accurately validated.
Database backups are necessary to safeguard data from corruption or loss. Setting up regular backup schedules, selecting suitable backup kinds (full, differential, or transaction log backups), and safely storing backups are all necessary steps in the implementation of database backups. In the event of database failures—which can be caused by anything from hardware malfunctions to human mistake or natural disasters—recovery solutions entail restoring data from backups.
By locating and addressing performance bottlenecks, database performance optimization seeks to maximize a database system's performance. To increase overall performance and responsiveness, this process entails tracking system performance indicators, spotting unproductive queries or procedures, refining database configuration parameters, and improving database schema and indexing techniques.
Redundancy and failover capabilities are provided by high availability systems, such as MS-SQL Server's Always-On Availability Groups, to guarantee uninterrupted data access and reduce downtime. Setting up numerous database replicas, enabling automatic failover, and guaranteeing synchronization between primary and secondary replicas to preserve data consistency are all necessary when building Always-On Availability Groups.
The proprietary SQL extension used in MS-SQL Server for database programming is called Transact-SQL (T-SQL). Using T-SQL, programmers and database managers can create functions, triggers, stored procedures, and scripts to manage and manipulate data in the SQL Server environment. To conduct a variety of database-related operations, including data queries, object modifications, and administrative job automation, one must be proficient in T-SQL.
SQL query optimization seeks to increase query execution speed and minimize resource usage in order to enhance database query efficiency and performance. In order to maximize query performance, this entails examining query execution plans, pinpointing areas for optimization, rewriting queries to make advantage of effective algorithms and indexing methods, and taking into account variables like data distribution, join types, and indexing strategies.
A wide range of activities, including data migration, backup management, performance optimization, and high availability configuration, are included in efficient database administration. Mastery of SQL query optimization and T-SQL programming is essential to guaranteeing optimal database performance and dependability. Database administrators may efficiently manage and maintain database systems to fulfill the demands of their businesses by putting best practices into practice and making use of the right tools and approaches.
Thanks & Regards
Vishwa
Steps for completing your project
After purchasing the project, send requirements so Aththanayakage Dinesh Vishwa can start the project.
Delivery time starts when Aththanayakage Dinesh Vishwa receives requirements from you.
Aththanayakage Dinesh Vishwa works on your project following the steps below.
Revisions may occur after the delivery date.
Step 01
Gathering all details from the client.
Step 02
Start the work and send first draft for changes.