Upwork home
Sign up
Project Catalog
DesignDesign
Video & AudioVideo & Audio
Development & ITDevelopment & IT
MarketingMarketing
Writing & TranslationWriting & Translation
MoreMore

You will get Database Performance Tuning (Oracle/ SQL Server/ MySQL/ PostgreSQL)

Abdul N.Status: Offline
Abdul N.
Rising Talent
Preview image

Let a pro handle the details

Buy Database Optimization & Design services from Abdul, priced and ready to go.
Abdul N.Status: Offline
Abdul N.
Rising Talent
Preview image

Let a pro handle the details

Buy Database Optimization & Design services from Abdul, priced and ready to go.

Project details

We will perform the following items in this project
• System Health Check includes hardware, software, and storage components
• Workload analysis and Tuning
• Analyze and Tune database instance/engine configuration
• Analysis of Database Performance Reports (AWR, ASH, ADDM, Profiler)
• Identification and of CPU, Memory, and IO related issues
• Database connection related issues
• SQL, T-SQL, and PL/SQL rewrite
• Query optimization
o Index requirement
o Query execution plan analysis
o Statistics Gathering
Database Type
MySQL, MS SQL, Oracle, PostgreSQL
What's included
Service Tiers Starter
$500
Standard
$1,000
Advanced
$2,000
Delivery Time 3 days 7 days 10 days
Number of Revisions
123
Schema Diagram
-
-
-
Permissions Setup
-
-
-
Import/Export Data
-
-
-
Admin Panel Setup
-
-
-

Frequently asked questions

Abdul N.Status: Offline

About Abdul

Abdul N.Status: Offline
Database Architect & DBA
Lahore, Pakistan - 4:23 am local time
Over 15 years of experience in the field of database administration, development and managing IT Infrastructure. Having Skill set to manager multi-vendor databases (Oracle, SQL Server, MySQL, PostgreSQL, DB2) over platform Windows, Linux, HP-Unix and Solaris. Key areas that I managed are

• Database Designs and Capacity Planning
• Installation, Configuration and Up-gradation of Standalone and Clustered Databases
• Database health check and Performance Tuning
• Backup and Recovery
• Query Writing and Tuning in SQL and procedural languages (PL/SQL, T-SQL)
• Data Replication Solutions (Oracle Data Guard, Streams, Golden Gates, Replication)
• Disaster Recovery(DR) planning and Implementation
• Migration of Database Structure and Data across different database platforms
• Patching and cloning of database and EBS application
• Administration of Oracle Exadata RAC databases
• Database Security, Auditing and understanding of PCI-DSS standards
• Training and Managing the Team of DBAs
• Configuration and administration of Application for Telecom and Financial Areas


During my Career I have managed over 30+ TB Databases and performed multiple installation (Standalone and Clustered) Databases over private and public cloud, perform hardware upgrades include database and application upgrade, Prepare and Shifted the services to DR site for mission critical applications and database.

Steps for completing your project

After purchasing the project, send requirements so Abdul can start the project.

Delivery time starts when Abdul receives requirements from you.

Abdul works on your project following the steps below.

Revisions may occur after the delivery date.

Gathering data, Analysing and Solution Suggestion

Review the work, release payment, and leave feedback to Abdul.