- Monitoring: database Servers and Replication Server Memory/IO & CPU usage, locking & deadlocking, system contention file system capacities - User activity housekeeping: add space to the database remove orphaned sessions Restart database server weekly, run DBCC’s, update statistics & re-indexing tune database parameters: analyzed performance & performance tuning, others DBA responsibility: installed and upgraded Sybase SQL Server, created user logins and adding users to databases aliases and allotting roles to users Managed security using grants and revokes performing backup and recovery of databases BCP out and BCP in of tables from one database to another, performed database and transaction log-file dumps on a regular basis - Technologies: Sybase ASE and MS SQL Server Contribution: Scripting: developed automation scripts for performing many housekeeping tasks - Performance and Tuning (server level / database level / query level): Changing configuration parameters using ‘sp_configure’ based on output of ‘sp_sysmons’