|
|
|
|
Home > Computers & Programming > Databases > MS-SQL > Chandrakant
|
|
|
Chandrakant
|
|
|
This expert is currently unavailable for sessions. We apologize for any inconvenience caused.
|
|
|
Expert in:
MS-SQL
|
Rating:
|
|
Languages:
English
|
|
I can provide the solutions to the Database Software, MS SQL Server.
|
|
|
|
|
|
|
|
|
|
|
Degrees
|
|
Masters in Computer Applications
|
|
|
My Expert Service
|
|
I am working as the Production Support analyst for one of the renowed Organization in the Information technolgy. I have back experience of 5 years in the DBA in MS Sql Server. I can provide solutions related to the DBA roles, and SQL Server.
|
|
|
Experience & Qualifications
|
|
• Hosting and maintaining development databases on SQL Server 7.0 and providing support to development teams in setup and connection configuration and troubleshooting and T-SQL queries, procedure and triggers coding and troubleshooting.
• Being part of technical support, administration and maintenance of Multiple SQL Server and multiple databases. Handling the Maintenance and support to Application Development related problems, in routine activity.
• Handling setup, configuration and any SQL Server related issues at client’s end.
• Installation and configuration of SQL Server.
• Installation and configuration of Windows NT
• Regular complete backups of SQL Server 7.0
• Scheduling Jobs and alerts
• Scheduling DBCC on off peak hours
• Online performance monitoring of online server.
• SQL server tuning
• Tuning In House Application for performance upgrades
• Creation of required back-end procedures and triggers to impart user functional requirements and incorporate most of the business functionalities and practices of the company.
• Database designing for implementation of new applications.
• Preparing Monthly MIS for the imparting details on the Database Activities. Details Analyzed such as Database Growth, Peak Utilization of server, Peak Hours of Database Growth, Comparison with the previous Months Database details etc.
• Reporting on database health and performance.
• Maintaining all backups Media and defining Plans for the Backup activities.
• Maintaining Data Consistency and Data security.
• Analysis of the Database activities on the day-to-day basis for higher activities on the server (CPU Usage, Physical IO, Locking, blocking) through SQL Server Utilities such as Profiler, QA and determining the performance bottlenecks. Determining the Pick duration for the intensive activities on the server.
• Analyzing the Database growth and planning out for the Database tuning for controlling the Database growth.
• Maintaining the Security for the access to the database and objects (users, Roles).
• Securing the consistency of the Data in view of the Business Logic through Database concepts (Primary key, Foreign Key, unique keys, Defaults, Rules, constraints, Null checking, Views, Triggers, Stored procedures, Jobs, and alerts).
• Data transfer services for the uploading the data from the old system as well as exporting the data.
• Setup Transactional Replication, configuration and maintenance of the replication.
• ERP Maintenance and Analysis, Design, Development, Testing for the Release of the New In House ERP
|
|
|
Available Modes Of Communication
|
|
email/chat
|
|
|
|
|
Contact
Chandrakant
|
|
|
|
|
|
|