Senior SQL Server Developer

Cox Enterprises is a leading communications, media and automotive services company.

The Senior SQL Server Developer is responsible for designing and maintaining SQL Server 2014 Integration Services packages, relational and dimensional models as well as T-SQL (tables, stored procedures). This position will work within the data services team under the guidance of the Data Architect to ensure consistent application of database best practices and to ensure that all data integration points and models are designed in a manner that efficiently satisfies business needs. This is a significant role that carries responsibility across development teams in the organization.

* Develop according to best practices with scalability and extensibility in mind * Work within the Change Management and Configuration Management processes * Monitor system for slowest queries and provide regular reports to the development teams * Profile T-SQL and fine-tune queries through hints, application of keys or restructuring of query * Plan for future scale and performance needs based upon historical data and projected system growth * Troubleshoot issues in all environments as and when needed * Conduct knowledge transfer sessions to development team, enhancing their understanding of DB Best Practices **Development:** * Own core database models - for OLTP, DW and Cubes * Implement correct process for development changes to DB to be stored and applied when upgrading existing systems * Analyze the current data architecture to identify weaknesses and develop opportunities for improvements. * Participate in design and development meetings that require significant adjustments to DB schema * Setup the physical data model including all physical database configurations such as indexes, table spaces, table partitions, table constraints, relationships, etc. Have understanding of systems that hit the database through the use of LINQ and Entity Framework * Document database solution - schemas, application functionality, scripts * Work with application developers to ensure smooth development of overall solution * Performance tune solution to ensure platform functions within acceptable time limits **Technology Leadership:** * Maintain knowledge of technology trends, standards, and methodologies through extensive reading and online courses. * Evangelize technology thought leadership to constantly improve software development processes/platforms

* Bachelor's degree in Computer Science or a related field of study * 5+ years' experience as a Senior SQL Server Developer * Microsoft certifications are a plus * Experience working in small or startup environment a bonus