SQL/.NET Developer
Job Opportunity at Pitisci & Associates

Posted on Mar 13


Location: Oldsmar, FL
Job Type: Full Time
Job ID: W4154849

Direct Hire
Oldsmar, FL

Seeking a strong SQL Server Developer, responsible for writing well documented complex SQL queries, stored procedures and functions.  We are evolving toward using our data more heavily around analytics, reducing our dependency on physical files outside the database and capturing more data to provide better visibility.  We need to design, structure and build our database environment to better support our goals.
Job Responsibilities 
  • Strong technical knowledge in MS SQL Server database and related components, including an emphasis on T-SQL and performance optimization
  • Code SQL Logic, guarantee it meets requirements, well tested and performs efficiently
  • Ensure performance, security and availability of database
  • Evaluated business requirements and help define problems and develop solutions
  • Profile server resource usage, optimize and tweak
  • Collaborate with other team members and stakeholders
  • Understand and work with different database environments (dev/test/prod) and proper deployment practices
Job Specifications
  • Demonstrable track record of building, launching, & maintaining successful products that leverage terabytes of data
  • Expertise database design, complex T-SQL programming, performance tuning and index analysis
  • Experienced in database performance testing and SQL code unit testing strategies and implementation
  • Ability to create/debug stored procedures and SQL views
  • Skilled at optimizing large complicated SQL statements
  • Familiarity with memory optimized tables
  • Familiarity with sql caching techniques?
  • 3-6 years of experience with SQL Server development
  • 2-5 years of C#/.Net development experience
  • Expert command of SQL querying language.  Must be able to easily merge, join, group, sub-query, pivot, handle exceptions and write procedures and functions on large datasets
  • Ability to troubleshoot and resolve database integrity and performance issues
  • Experience building ETL, solutions to load external data into databases, using SSIS or other methodologies
  • Understanding of code versioning tools
  • Excellent communication both written and verbal
DatabaseAnalyst.com is owned, operated, and copyrighted by Career Marketplace (© 2002-2019, All Rights Reserved)