Banner Image

All Services

Programming & Development

Database Design

$15/hr Starting at $800

Core Members of Techbit has 7+ years working experience in Microsoft .NET technology provided me with solid foundations of knowledge in web development area, ASP.NET, ASP.NET MVC, ASP.NET MVP, .NET technologies. • 4 Years’ experience administering and maintaining replicated Microsoft SQL Server databases in a distributed production environment(reporting experience a plus) • 2+ years of production DBA experience including development, test and production database environments • General understanding of database theory, and database design • Experience with Microsoft environment and tools, such as Enterprise Manager, Query Analyzer, and Profiler • Advanced knowledge of SQL language. Ability to write and deploy effective triggers, stored procedures and user defined functions • Ability to perform SQL query optimization. Must know query optimization tools, query plan analysis, techniques for finding inefficient queries. Experience with DTS Packages, jobs, query planning and optimization tools • General understanding of storage technologies (Disk storage, SAN, NAS, SSD, RAID/Striping) and networking (Ethernet, switching, IP, and routing) • Proven ability to work with large (20 GB+ in size) databases: includes knowledge of partitioned data storage, techniques for optimal loading of large data sets, and how large data volume affects replication in SQL Server environment • Thorough understanding of best practices for database maintenance, including index and file management, backups, failure recovery, database defragmentation, documentation. Ability to analyze disk space requirements and hardware utilization, automate error notification • Experience with database auditing techniques

About

$15/hr Ongoing

Download Resume

Core Members of Techbit has 7+ years working experience in Microsoft .NET technology provided me with solid foundations of knowledge in web development area, ASP.NET, ASP.NET MVC, ASP.NET MVP, .NET technologies. • 4 Years’ experience administering and maintaining replicated Microsoft SQL Server databases in a distributed production environment(reporting experience a plus) • 2+ years of production DBA experience including development, test and production database environments • General understanding of database theory, and database design • Experience with Microsoft environment and tools, such as Enterprise Manager, Query Analyzer, and Profiler • Advanced knowledge of SQL language. Ability to write and deploy effective triggers, stored procedures and user defined functions • Ability to perform SQL query optimization. Must know query optimization tools, query plan analysis, techniques for finding inefficient queries. Experience with DTS Packages, jobs, query planning and optimization tools • General understanding of storage technologies (Disk storage, SAN, NAS, SSD, RAID/Striping) and networking (Ethernet, switching, IP, and routing) • Proven ability to work with large (20 GB+ in size) databases: includes knowledge of partitioned data storage, techniques for optimal loading of large data sets, and how large data volume affects replication in SQL Server environment • Thorough understanding of best practices for database maintenance, including index and file management, backups, failure recovery, database defragmentation, documentation. Ability to analyze disk space requirements and hardware utilization, automate error notification • Experience with database auditing techniques

Skills & Expertise

.NETASP.NETData ManagementDatabase DesignDesignDistributed ComputingEnvironmental ConsultingMicrosoftMongoDBNetworkingRequirements AnalysisServer AdministrationSoftware DevelopmentSpace PlanningSQLStorage EngineeringT SQLWeb Development

0 Reviews

This Freelancer has not received any feedback.