mssql dba cum developer having 6+years (4002708)

Administrative & Secretarial

mssql dba cum developer having 6+years

$5/hr Starting at $25

• 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.

About

$5/hr Ongoing

Download Resume

• 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.

Skills & Expertise

Administrative AssistantBackupCreativeData ManagementDatabase DevelopmentDesignLikesManagementMicrosoft SQL ServerMonitoringPerformance EngineeringProgrammingServer AdministrationSoftware DevelopmentSpace PlanningSQLSystems EngineeringT SQLTable Design

sudipta nanda