experiance im microsoft sql
• Having around 6+ yrs experience in Database Designing and Administrating and Programming in SQL Server 2000, SQL Server 2005, and SQL Server 2008.
• Experience in Database administration activities like Installation, Configuration, Backup & Recovery, Database Security, Data Transformation Services and T-SQL.
• Experience in implementing database backup/recovery strategy.
• Creation and maintenance of Databases, creating Roles and managing user permissions.
• Experience in Tuning SQL Queries & improving the performance of the Database.
• Proficient in developing Complex Stored Procedures, Indexes, Triggers, Cursors, T-SQL Statements, and User Defined functions, and Views
• Experience in Performance Tuning, Query optimization, Client/Server Connectivity and Database Consistency Checks using DBCC Utilities.
• Performing data transfer.
• Migrating the databases using Scripts.
• Creating Scheduled jobs for various purposes.
• Creating partitioned tables and indexes.
• Maintaining archive logs, spaces for routine administration and alert and trace monitoring.
• Maintaining the space, monitoring the free space etc.
• Experience in implementing Log shipping, Mirroring and Replication.
• Conversant with all phases of Software Development Life Cycle involving System analysis, Database designing, development and implementation.
• Working with development team.
Work Terms
20 to 30 hour /week,10$/h