Rama K MSSQL Server DBA - Realtime Training
No reviews yet

Dear Students,

I have 13 years and 4 months of experience in MSSQL Server and Oracle Database Administration.
I can provide end to end DBA training with real-time scenarios and configuration with clear explanation and real-time examples. I can also assist in your assignment. Please find my below expertise and course content. Please let me now If you are willing to start the training.

My Skillset:

Oracle Database administrator: Install, configure, upgrade, Migrate, Performance tuning, Data guard, RAC, RMAN, cloning, OEM setup and configuration and cloud configuration.

SQL SERVER DBA: Install, configure, upgrading, migration, performance tuning, index management, creating jobs, configuring log shipping, mirroring, Always-on, Clustering and replication.

SQL Server Database Administration - Course content

1)Overview of SQL Servers
•History of SQL Server versions and Editions
•Responsibilities of Database Administrator/DBA Operations
•Over view of SQL Services
•Interview Q&A
2)Installation and Configuration
•Pre-installation process and prerequisites
•SQL Server Installation and configuration
•Post installations steps
•Client installation
•Adding/removing features
•Interview Q&A
3) Patching/Service pack installation
•Over view of SQL Server service packs, CU and hot-fix
•Pre-patch/service pack installation steps
•Patching on standalone servers
•Post patch/service pack installation steps
•Removing the service pack
•Interview Q&A
4) Overview of Databases
•Creating Databases & Over view of database properties
•Over view of System databases
•SQL Server Architecture
•Database Architecture
•Log Architecture
•Interview Q&A
5) Backup and Restoration
•Backup types
•Database Recovery Models
•Database/ database files/database objects - movement methods
Detach/Attach
Import/export
copy only backup
Script Generation
•Performing Backup and Restoration
•Linked server and creation
•Page level restore
•Interview Q&A
6) Security and user management
•Authentication modes
•Creating logins and users
•Understanding server and Database roles
•Assigning/Removing roles to logins/users
•Granting/revoking object level access
•Interview Q&A
7) Migration and Up gradation
•Side by side upgrade
•In-place up grade
•Database Refresh
•Edition upgrade
•Interview Q&A

8)Automation
•Maintenance plan
•Jobs and alerts
•Database mail configuration
•Interview Q&A

9) Disaster Recovery and High Availability
1) Log-shipping
•Overview
•Pre-requisites
•Configuration
•Fail-over process
•File Adding and user adding
•Issues & Interview Q&A
2) Database mirroring

•Overview
•Types of mirroring
•Pre-requisites
•Configuration
•Fail-over process
•File Adding
•Snapshot creation
•Issues & Interview Q&A
3) Replication (Snapshot, Transactional, peer-to-peer and Merge replication)
•Overview
•Pre-requisites
•Types of Replication
•Configuration
•Tables adding & removing
•Issues & Interview Q&A
4) Always ON
•Overview
•Pre-requisites
•Configuration
•Fail-over process
•Patching
•File Adding and users adding
•Issues & Interview Q&A
5)Clustering
•Overview
•Pre-requisites
•Configuration
•Fail-over process
•Disk adding
•Patching
•Issues & Interview Q&A

10) Performance tuning
•Locks
•Blocking
•Dead locks
•Indexes
•Update stats
•Fragmentation
•Query Execution
•Isolation levels
•Interview Q&A
11) SQL Server New features
12) Ticketing Tool: Snow
13) Performance Tool: Perfmon, SQLProfiler and Extended Events

Subjects

  • MS SQL DBA Expert

  • Azure Administration Expert

  • Oracle 12c Expert

  • Oracle 11g Expert

  • ORACLE Database Administration - (OCA) Expert

Experience

  • Senior Technical Lead/Subject Matter Expert (Aug, 2010–Present) at 13.4 years of extensive experience as MSSQL Server and Oracle Database Administrator
    End to End and point of contact for MSSQL Server and Oracle Database

Education

  • BCA (May, 2000–May, 2003) from acharya nagarjuna university, Namburu

Fee details

    ₹10–30/hour (US$0.12–0.35/hour)

    Fee may vary depending on the type of the support or training.

Reviews

No reviews yet. Be the first one to review this tutor.