Mysql DBA MySQL Database Administration MongoDB Db2 Dba...

MySQL/MONGO/DB2/ PostgreSQL/Maria Database Management

L2 Deliverables:

Trouble shoot Disk related I/o error or data and log file error if any Trouble shoot SQL job monitoring issue if any Session / Process Monitoring Client Installation (server) Transaction monitoring during EOD/SOD jobs dependent instance based on the request Trouble shoot critical dead lock or session issues Service pack/Patch updates on Cluster server DBCC CHECKDB or Consistency verification job monitoring Lock and Deadlock Service pack/Patch updates on standalone server Addition of Data or Log file Addition Secondary file group/stream Database properties change Instance properties Change Full Backup plan configuration using the Maintenance plan Backup plan configuration using the T-SQL statement.
Rebuild/ Re-organize index configuration using the Maintenance Plan Rebuild/Re-organize index configuration using the T-SQL statement. Create logins, users and also provide the appropriate privileges for the same.

Shrinking of Data and log files Checking DB fragmentation level and re-org index Taking manual backups based on the request Database restoration based on the request for supported assets.
Data file and log file movement.

Incident and Request Fulfillment Management Linked server creation and configuration on SQL Server DR reconfiguration and setup in case of failure due to incident Service account change and password reset TCP / IP port configuration Named pipe configuration C2 audit enabling sp_configuration changes Database creation Backup restoration drill SQL mail or Database mail configuration jobs Creation of jobs using T-SQL statements based the request from application team Trouble shoot all jobs and maintenance plan issue Trouble shoot login/instance connectivity issues Log Shipping configuration in standby mode.

Log Shipping configuration in no recovery mode Trouble shoot logshipping Issues Mirroring Configuration in asynchronous mode Mirroring Configuration in synchronous mode without automatic failover Mirroring Configuration in synchronous mode with automatic failover Trouble shoot Mirroring Issues Trouble shoot DB cluster Issue Trouble shoot Linked Server Issue Change the recovery model.
TempDB movement. Data file and log file movement.

DR drill activity Login creation with Sysadmin privileges Schema Creation System Performance analysis as per L2 and escalate to L3 in case further analysis is required.
Database performance analysis as per L2 and escalate to L3 in case further analysis is required. Instance performance analysis as per L2 and escalate to L3 in case further analysis is required.

Identify bad growth projections and Identify space-bound objects Capture Performance Statistics using performance monitors Capture Performance Statistics of Instance like IO, Waits, Paging, Buffer Hit Ratio, Full Scans etc., Database Objects Creation / Review Re-cycling of error log Necessary support for restoration or drill Preparation of MIS for Major Incidents Review of daily/weekly/monthly checklist Repeat Incident / Alert Analysis Reinstallations raise due to incidents Incident / Request Fulfillment / Change management Setup new configuration as per application requirement Configuration of Master/Slave setup Configuration of Always on setup Configuration of Sharding Configuration installation of database Cluster DF installation.
Database integration. Daily reports review. Troubleshooting. Application profiling. Patch management. Upgrade of the system to the supported version. Migration of the system to the new machine Data migration Cross platform migration Failover testing. Periodic HA review and testing. Closure of audit requirement. Vendor co-ordination. Compliance as per policy. VA/CA point closer Audit point closer System book creation and periodic review. Inventory Management