You will get SQL Server DBA for Installation, Backup, Recovery, and Performance
Project details
Are you struggling with managing your Microsoft SQL Server? Need an experienced Database Administrator to ensure your database performs at its best? I am a certified and highly skilled Microsoft SQL Server Database Administrator with 5 years of experience. I specialize in installing, optimizing, and maintaining SQL Server environments to ensure they are reliable, secure, and performing at optimal levels.
1. Installation and Configuration:
SQL Server Installation: Expert installation of SQL Server 2016, 2017, 2019, and Azure SQL environments.
Configuration: Optimal configuration of SQL Server instances tailored to your system requirements.
Security Setup: Implementing best practices for SQL Server security, including user authentication, encryption, and auditing.
2. Backup and Recovery Solutions:
Backup Strategy: Creation of robust backup strategies, including full, differential, and transaction log backups.
Disaster Recovery Plans: Designing and implementing high-availability (HA) and disaster recovery (DR) solutions like Always On Availability Groups, Log Shipping, and Failover Clustering.
Point-In-Time Recovery: Recover lost data with precise point-in-time recovery techniques.
1. Installation and Configuration:
SQL Server Installation: Expert installation of SQL Server 2016, 2017, 2019, and Azure SQL environments.
Configuration: Optimal configuration of SQL Server instances tailored to your system requirements.
Security Setup: Implementing best practices for SQL Server security, including user authentication, encryption, and auditing.
2. Backup and Recovery Solutions:
Backup Strategy: Creation of robust backup strategies, including full, differential, and transaction log backups.
Disaster Recovery Plans: Designing and implementing high-availability (HA) and disaster recovery (DR) solutions like Always On Availability Groups, Log Shipping, and Failover Clustering.
Point-In-Time Recovery: Recover lost data with precise point-in-time recovery techniques.
Database Type
MySQL, MS SQL, OracleWhat's included
| Service Tiers |
Starter
$200
|
Standard
$500
|
Advanced
$1,000
|
|---|---|---|---|
| Delivery Time | 1 day | 2 days | 3 days |
Number of Revisions | 2 | 3 | 5 |
Schema Diagram | - | ||
Permissions Setup | - | ||
Import/Export Data | |||
Admin Panel Setup | - |
Optional add-ons
You can add these on the next page.
Fast Delivery
+$50 - $100
Additional Revision
+$50
3 reviews
(1)
(1)
(0)
(0)
(1)
This project doesn't have any reviews.
NS
Naveed S.
Oct 17, 2024
looking for someone who is expertise in setting up Oracle 19c enterprise DB
BM
B M.
Sep 17, 2024
DB Developer, DBA, SQL Expert, Performance Tuning, Data Visualisation
AL
Antonio L.
Aug 25, 2024
Data entry for migration mapping
He’s a great guy. We ran out of time on this project no fault of his but we will work again.
About Sajjad
Database Administrator(SQL Server ,Oracle ,MySQL)
33%
Job Success
Islamabad, Pakistan - 10:09 am local time
I’m Sajjad Iqbal, with 5 years of expertise in Oracle , SQL Server and MSSQL databases. I am proficient in:
Oracle DB Versions**: Implementation and management of Oracle DB 10g, 11g R2, 12c, and 19c.
Database Backup and Recovery**: Expertise in planning and executing backup strategies to ensure data integrity.
Real Application Cluster (RAC)**: Implementation and management of RAC for high availability and load balancing.
Physical Standby (Data Guard)**: Configuring Data Guard for disaster recovery and data protection.
Oracle WebLogic**: Administration of Oracle WebLogic 11g and 12c for enterprise applications.
Oracle Grid Infrastructure**: Management and administration of Grid Infrastructure 19c for optimal resource allocation.
RMAN**: Proficient in using RMAN for backup and recovery tasks.
Oracle Import/Export (Data Pump)**: Utilizing Data Pump for efficient data transfer between databases.
Oracle Performance Tuning**: Expertise in diagnosing and optimizing database performance.
MS SQL Server**: Installation and administration, ensuring optimal database operation.
Fusion Middleware**: Familiarity with Oracle Fusion Middleware for application integration.
Oracle GoldenGate**: Implementation for real-time data integration and replication.
Database Upgradation & Migration**: Skilled in planning and executing upgrades and migrations across Oracle versions.
### Additional Points on MySQL and SQL Server
**MySQL Database**:
- **Open Source**: MySQL is widely used and open-source, making it a cost-effective solution for various applications.
- **Scalability**: It handles large datasets efficiently, suitable for web applications and big data environments.
- **Replication**: Offers various replication options (master-slave, master-master) for improved data availability and load balancing.
- **Community Support**: Strong community support with extensive documentation and forums.
**SQL Server Database**:
- **Integration**: Deep integration with other Microsoft products, providing a seamless experience for .NET developers.
- **Security Features**: Advanced security features like Transparent Data Encryption (TDE) and row-level security.
- **Business Intelligence**: Comprehensive tools for analytics, reporting, and business intelligence (SSRS, SSAS).
- **High Availability**: Features like Always On Availability Groups ensure minimal downtime and high availability.
Thank you for exploring my portfolio. I look forward to the opportunity to contribute my expertise to your projects.
Best regards,
Sajjad Iqbal
Steps for completing your project
After purchasing the project, send requirements so Sajjad can start the project.
Delivery time starts when Sajjad receives requirements from you.
Sajjad works on your project following the steps below.
Revisions may occur after the delivery date.
Initial Consultation
Discuss the current database setup, challenges, and goals Identify whether the project requires installation, backup and recovery setup, or performance optimization. Gather necessary details about the client’s infrastructure (e.g., SQL Server version
Environment Review and Assessment
Check system configurations, existing backups, security settings, and performance. Analyze queries, indexes, and execution plans for optimization. Assess the current high availability/disaster recovery (HA/DR) setup, if applicable.