
Database Developer at Jewelry Television
Knoxville, Tennessee Area

Database Developer at Jewelry Television
Knoxville, Tennessee Area
Microsoft SQL Server 2008 developer, meaning daily modification and creation of stored procedures, triggers, tables, jobs and SSIS packages.
Microsoft SQL Server 2008/2005, SQL Server Integration Services, Transact SQL
(Privately Held; Retail industry)
December 2008 — Present (1 year 4 months)
I work with SQL Server 2008 SSIS configuration and data warehousing to merge analytics, product, subscriber, promotional and an in house Oracle database into one large data warehouse which then crunches numbers and sends feeds to the company website, email campaigns, and back to the in house Oracle database.
My main focus is ETL objects. I write stored procedures, triggers, functions as needed in SQL Server to interface with SSIS.
(Public Company; Computer Software industry)
April 2006 — December 2008 (2 years 9 months)
Responsible for SQL Server coding and maintenance support for a cross-functional product development and maintenance team.
Responsibilities included but were not limited to:
-"Putting out fires"
-Task estimation, risk assessment, coding and maintenance of stored procedures and functions in Transact-SQL.
-Minimal Coding and maintenance of DTS package scripts.
-Setup, maintenance, and support of jobs in SQL Agent.
-Perform peer reviews,data migration, remapping, import/export, and transformation of data.
-Publication of software releases to stage and production servers.
-Diagnose and resolve complex database issues.
-Recommend and/or develop corrective SQL scripts and database fixes.
-Support legacy development, testing, and production code bases.
-Analyze and implement database change requests and enhancements.
-Actively participate in meetings as an advocate for the DBA and development departments.
(Public Company; 51-200 employees; Computer Software industry)
March 2001 — April 2006 (5 years 2 months)
Major code work for large real estate boards. Includes ASP and JavaScript.
Created reports for realtors to provide their clients, implement
prospecting modules, and broker branding for our web based MLS
system.
(Public Company; 1001-5000 employees; ELNK; Internet industry)
August 1998 — March 2001 (2 years 8 months)
• Assist the Reseller Manager in pulling reports, making websites, graphs, suggesting marketing ideas, etc.
• Maintain the secured Reseller website.
I enjoy attending conferences, writing SQL queries, networking at user group meetings, supporting the SQL Server community, roller skating, and singing to my kids until they demand I stop.
Professional Association Of SQL Server(PASS) Chapter Leader in Knoxville, Tennessee