SQL Server Audit

Closed Posted 10 months ago Paid on delivery
Closed Paid on delivery

Need someone who can audit SQL Server Databases and provide an audit report.

Details:

The Scope of work, requirements & deliverables from the Freelancer

[login to view URL] of Work: The freelancers will be responsible for the following tasks: a. Analyzing the database structure, including tables, indexes, and relationships. b. Reviewing and evaluating security settings, including user access permissions, roles, and authentication methods. c. Assessing the performance of the databases, identifying any bottlenecks or inefficiencies, and recommending improvements. d. Verifying compliance with SQL Server best practices, including naming conventions, data types, constraints, and indexing strategies. e. Identifying any potential data integrity issues or vulnerabilities. f. Reviewing storage including hard disk and memory utilization g. Documenting findings, recommendations, and any required corrective actions in an audit report.

The freelancer will not have access to the Databases but will need to provide a process & procedure to get the relevant information. The process and procedure will be followed to get the required information and be provided to the Freelancer.

[login to view URL] Skills and Qualifications: a. Extensive experience and expertise in working with SQL Server databases. b. In-depth knowledge of SQL Server architecture, administration, and performance optimization. c. Strong understanding of database security principles and best practices. d. Proficiency in SQL query optimization and troubleshooting. e. Familiarity with auditing methodologies and frameworks. f. Excellent analytical and problem-solving skills. g. Effective communication skills to clearly document findings and recommendations.

[login to view URL]: The following deliverables are expected from the freelancers: a. Audit report: A comprehensive report detailing the findings, recommendations, and corrective actions. b. Documentation: Any supporting documentation, scripts, or queries used during the audit. c. Presentation: A summary presentation highlighting key findings and recommendations (optional).

[login to view URL]: The timeline for the audit and report generation will be mutually agreed upon with the selected freelancers. However the expectation is to complete the Audit as early as possible.

[login to view URL] and Data Security: The freelancers must adhere to strict confidentiality guidelines and ensure the security of the client's data throughout the auditing process. Non-disclosure agreements (NDAs) may be required.

[login to view URL] and Payment: The evaluation of the audit report will be based on its completeness, accuracy, and relevance to the specified scope of work. Payment to the freelancers will be made upon successful completion and acceptance of the audit report.

Database Administration Microsoft SQL Server MySQL SQL Windows Server

Project ID: #36693307

About the project

9 proposals Remote project Active 8 mos ago

9 freelancers are bidding on average ₹11389 for this job

bizmanas

I am Debashree, a database developer and web developer with 15 years of experience. I specialize in SQL Server and ASP.Net, so I am confident that I can help you audit and analyze your SQL Server databases. I have wor More

₹21000 INR in 10 days
(14 Reviews)
4.7
CourserXu

Hello there, I am excited to apply for the job you have posted. With over ten years of experience in Oracle PLSQL, PostgreSQL, MySQL, MS SQL, and other NoSQL databases, I am confident that I have the necessary skills More

₹12500 INR in 7 days
(5 Reviews)
3.8
nekpaldevloper

Hi, We went through your project description and it seems like our team is a great fit for this job. We are an expert team which have many years of experience on SQL, MySQL, Windows Server, Database Administration, M More

₹7000 INR in 7 days
(2 Reviews)
3.2
RococoConsultant

Expert Customer. We are digital transformation and custom software development agency Sinces 2014, At Rococo Consultant we provide Next Generation technologies like Blockchain, Robotics Process Automation (RPA) , Art More

₹7000 INR in 3 days
(7 Reviews)
3.6
shethpinal2019

I have read your requirement and I can easily work on this. I have more than 8 years of experience in IT field. And I have mainly experience on .net and c#. I have vast experience on .net,c#, desktop application, web a More

₹4000 INR in 7 days
(1 Review)
1.0
tmelia78

Hello there! My name is Tony and I manage a large IT department for a bank covering all engineering, data and testing practices. I currently manage and administer over 5000 SQL databases within my main role and am look More

₹12000 INR in 7 days
(0 Reviews)
0.0
sushantcivil

The job sounds very interesting and whole in itself. I am really interested . This will need dedicated time and i am wiling to spend on the same. I can start today.

₹7000 INR in 7 days
(0 Reviews)
0.0
RamaKrishnaB90

Providing the evaluation and report shouldn't be a big deal but to provide such details without having direct access to db would be a challenge to deal with. Hopefully there are licenses to tools to extensively pull su More

₹7000 INR in 30 days
(0 Reviews)
0.0