Role/Team Summary :
- Provide database administration service along with Team Lead.
- Coordination with Global customers.
- Following standard team processes and defines new ones with corrections.
- The individuals will be expected to be fully-functional DBAs who can perform traditional DBA activities independently
and guide team members too.
- Able to provide escalation support whenever required.
- From an operational perspective, responsibilities include troubleshooting problems, working maintenance windows
and providing 24x7 on-call supports on a rotational basis. Pre-installation Tasks
- Database automation for MSSQL using Ansible
- Pre-installation Tasks
- Installing SQL Server and Patch Mgmt
- Installing & Maintaining DB Tools
- Uninstallation
- Database Upgrade
- Database Migration
- Database Patch Installation
- Physical Database Design and Implementation
- Database Setup in 32 and 64 architecture
- Database Clean up / Removal
- DB Cloning
- Design Database, RAID configuration & Capacity Planning for Large Databases
- Setup and implement Cluster Setup in multiple nodes setting
- Implement High Availability configuration like replication and log shipping
- Start up and shutdown of Database instances
- Maintaining Database replication / standby / clusters
- Job scheduling
- Verify all Instances and dependent services are running
- Look for any new error log entries
- Session / Process Monitoring
- Query or Transaction monitoring
- Lock and Deadlock monitoring
- Activity / Transaction Log monitoring
- Job monitoring and Purging Job history
- Replication / Log shipping monitoring
- Monitor Space usage /growth of Database objects
- Verify free space in filegroups / databases
- Monitor transaction log growth and truncate schedule
- Reorganization of DB to remove fragmentation
- Update Stats for hot objects • Purging of DB logs and trace files • Schedule maintenance plans for maintenance like DBCC REINDEX / INDEX DEFRAG • Creation and schedule maintenance pla