SR DATABASE ADMINISTRATOR
Campusone Education Solutions Pvt. Ltd.
Total years of experience :13 years, 1 Months
Major Responsibilities handling for MS-SQL and MYSQL-
FOR MSSQL
•Installing and maintaining databases.
•Administration of the database including performance monitoring and tuning.
•Taking part in the preparation and execution of technical tests.
•Populating a database with new information or transfer existing data into it.
•Planned and done log shipping for migration configuration of mirroring and maintaince of issue .
•Did backup and restoration of smaller and large databases.
•Scripted all user and jobs and applied the same on the new production.
•Documented SOP for database Migration (SQL Server 2005 & SQL Server 2008).
•Configured 2 node cluster with storage on SAN on Windows Server 2012 E.E
•Restored the Database on all the nodes depending upon their resource utilization.
•Index creation and maintenance.
•Work on high availability Log shipping, mirroring, clustering.
•Tuning database performance, improving query processing performance, Database implementation, Growth and change performance issue on deadlock, Backup and restore on daily, weekly and monthly basis of SQL and IIS Servers.
•Performing sensitive DMLs as and when required.
•Migrating oracle to MS SQL
•Performing End of Day (EOD) Activities For All Projects.
FOR MYSQL: -
•
Responded to database problems and issues relating to applications and systems.
•Installation of MySQL on windows base
•Maintained index, optimization, analysis, partion basis on table, security, backup.
•Replication deployment between primary and secondary server as master -slave and master-master
•Monitoring performance issue in MYSQL
•Maintained system documentation relating to technical platforms.
•Participated in learning of interfaces with systems for resolution of
•Suggested improvement processes for increasing efficiency of applications and current processes.
•Assisted in testing, upgrading and development of new and current database servers.
•Replication deploying using master-slave and master-master
•Coordinated with external vendors for tracking of routine incidents and operational problems.
•Developed new architecture components in collaboration with storage administrative teams.
•Provided technical assistance on installation and maintenance of database software components and related upgrades
FOR MSSQL
•Installing and maintaining databases.
•Administration of the database including performance monitoring and tuning.
•Taking part in the preparation and execution of technical tests.
•Populating a database with new information or transfer existing data into it.
•Planned and done log shipping for migration configuration of mirroring and maintance of issue .
•Did backup and restoration of smaller and large databases.
•Scripted all user and jobs and applied the same on the new production .
•Documented SOP for database Migration (SQL Server 2005 & SQL Server 2008).
•Configured 2 node cluster with storage on SAN on Windows Server 2012 E.E
•Restored the Database on all the nodes depending upon their resource utilization.
•Index creation and maintenance.
•Tuning database performance, Improving query processing performance, Database implementation, Growth and change performance issue on deadlock, Backup and restore on daily, weekly and monthly basis of SQL and IIS Servers.
•Performing sensitive DMLs as and when required.
•Performing End Of Day (EOD) Activities For All Projects
MS SQL
MS SQL
MS SQL
: