MS SQL SERVER Database Administrator
KTP Thermopipe Factory Co
Total years of experience :23 years, 10 Months
•Perform day-to-day Database Administration for MSSQL Server 2005/2008/2012/2014.
•Troubleshooting and resolving database problems.
•Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
•Perform backups, restores and recovery models.
•Configuration of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server.
• Installed & configured database software, associated database tools and performance monitoring software.
• Designing and creating SSIS packages to (ETL) extract, Transform and load data from different files and databases such as Microsoft Excel, Flatfiles, Access, SQL Server.
• Involved in Source Data Analysis and designing mapping for data extraction also responsible for data extraction also responsible for design and development of SSIS packages to load the Data from Various Database and files
• Estimated disk storage requirements for database software, database files & database administration needs.
• Implemented & managed database clustering, failover and load balance technologies.
• Participated in designing, testing and implementing an enterprise Disaster Recovery Plan.
• Handled Logical Data and Index partitioning for large tables in SQL Server 2005 and 2008.
• Monitored data activities (i.e. database status, logs, space utilization, extents, Checkpoints, locks and long transactions).
• Developed & executed scripted changes requests in accordance with change control procedures.
• Proven ability to handle Database of more than 1 TB in Size.
• Expertise in MSSQL SERVER Database Administration.
• Set up Log Shipping, MSSQL Mail, SMTP
• Created, administered & maintained SQL Server Databases (Production, Development, Test and Staging Env.) for various groups such as Developer, QA, DA, User etc and ensured the Availability of the Database Server in a 24X7 Environment.
• Scanned the data pages, Indexes and checked the storage space used by each table.
• Suggested, developed & implemented Scaling out solution with Data partitioning.
• Managed security by defining roles and rights.
• Handled Fine Tuning Operating System in-coordination with Server and Network Administrator to utilize the maximum resources for Database and Applications.
• Monitored the database server performance and if required go for tuning of the TSQL queries, Stored procedures etc.
• Ability to maitain database documentation, including data standards, procedures and definitions for the data dictionary.
• refining the physical design to meet system storage requirements.
Handled data Migration from legacy systems as well other RDBMS such as Sybase and FoxPro, MS Access into SQL server 2000
Involved in Fine Tuning the Procedures After studying the Processing time through SQL Trace.
Modified & created Indexes, Optimizing Indexes.
Migrated data from various sources such as MS Access, flat files etc.
Configured Internet Information Services.
1.Manages and maintains all databases and replication servers.
2.Oversees and/or performs database installation and configure.
3.Schedules and performs upgrades.
4.Extensive knowledge of Database technology (Mainly MS SQL2000).
5.Commissioning and installing new applications
B.Sc Computer science from osmania university,India Post graduation diploma in computer application,AICTU,india diploma in computer application in engineering college of nanded,india Diploma in web desining SAP Basis Consultant,india