|
|
|
|
Home > Computers & Programming > Databases > MS-SQL > SqlGuru
|
|
|
SqlGuru
|
|
|
This expert is currently unavailable for sessions. We apologize for any inconvenience caused.
|
|
|
Expert in:
MS-SQL
|
Rating:
|
|
Languages:
English,Russian
|
|
R&D / Production DBA MS-SQL 7/2000/2005/2008
|
|
|
|
|
|
|
|
|
|
|
Degrees
|
|
MCP,MCDBA,MCITP
https://mcp.microsoft.com/authenticate/ValidateMCP.aspx
Transcript ID: 738784
Access Code: publicode
|
|
|
My Expert Service
|
|
DBA SQL 2000/2005/2008
• Backup/restore and disaster recovery plans for production servers.
• Ensuring 24 x 7 support of all production databases.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Responsible for database design and application architecture in response to internal client requirements.
• Providing assistance to the development team.
• Installing, configuring, administering and securing database servers.
• Implementing and administering database replication between SQL Server databases as well as other databases.
• Implementing and administering database log shipping/mirroring between SQL Server databases to ensure HA between production and standby servers.
• Release management for all changes to existing systems. Responsible for introducing a new change management process ensuring tracking of all changes.
• Development of stored procedures, views and triggers as and when needed.
• Automating day to day administrative and monitoring tasks.
• Developing policies and procedures governing corporate database operations and ensuring that they are followed.
• Command line knowledge of SQL Server and knowledge of system catalogs and system stored procedures.
• Developing batches by using BCP and data transfer utilities like DTS (SSIS), developing Data Transformation Service packages.
• Developing reporting by using SSRS (Reporting Services)
• Set up and maintenance SQL Server Mirroring and Log Shipping environments .
|
|
|
Experience & Qualifications
|
|
I have been working with SQL for over 5 years in versions 7 --> 2008 in various capacities, mostly Application DBA/ infrastructure DBA & Performance minded development.
|
|
|
Available Modes Of Communication
|
|
email/chat
|
|
|
|
|
Contact
SqlGuru
|
|
|
|
|
|
|