This site uses cookies. To find out more, see our Cookies Policy
Contact Us 877.823.3669

SQL Developer in Orlando, FL at SNI Technology

Date Posted: 4/5/2019

Job Snapshot

Job Description


We're seeking a self-starting, resourceful and passionate individual with 5+ years of MS SQL Server database development experience. Ideal candidates will have strong T-SQL skills, Business Intelligence experience, and a solid understanding of data integration techniques to support and enhance our database systems. This role will participate in all phases of development of transactional and data warehouse system projects from definition and design through implementation, debugging, testing, deployment and support, ensuring application schemas and development are optimal and consistent across all solutions.

Requirements

    • Perform technical design, development, testing and implementation of SQL Server databases utilizing industry and company specific development standards procedures. Ensure that standards for database performance, availability and security are being met
    • Create, debug, modify & tune SQL statements, stored procedures, triggers, functions, etc.
    • Use ERD to map datapoints from various RDBMS objects accurately to create complete datasets for reporting use
    • Implement complex business logic using functions, and complex stored procedures to support reporting development
    • Develop and enhance SSRS reports
    • Design and implement ETL solutions using SSIS, stored procedures, PowerShell, functions, views etc.
    • Develop system documentation for all developed applications databases, processes, and jobs, including flowcharts and data models. Help maintain architecture and process flow diagrams for data systems
    • Create well-written, clear, concise and accurate document artifacts including functional specifications, mapping documents process diagrams test plans and test scripts for the purposes of data warehouse construction, report development, verification etc.
    • Work closely and diligently with the product development team to proactively review and optimize/tune database code and performance for overall application performance
    • Collaborate with Data Governance, application developers and project leaders in defining, designing, developing and implementing database solutions to improve business functions



Qualifications:

  • 5+ years of experience in MS SQL Server 2016 or later
  • Strong knowledge of T-SQL, database development
  • Good knowledge of database design
  • 2+ years of experience with SSRS
  • Experience with Visual Studio 2015 or above
  • Experience with data modeling techniques, i.e. transactional vs dimensional
  • Experience with SSIS
  • Experience with Datawarehouse design and administration
  • Experience with TFS source control
  • Work with ERD modeling tool such as E/R Studio and ErWin
  • Must be extremely responsive, able to work under pressure in crisis with a strong sense of urgency

U.S. Citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.

CHECK OUT OUR SIMILAR JOBS

  1. Software Engineer Jobs
  2. Project Engineer Jobs