We provide IT Staff Augmentation Services!

Senior Sql Engineer Resume

2.00/5 (Submit Your Rating)

Boca Raton, FloridA

Hire Now

SUMMARY:

  • Deep understanding of software development and quality assurance best practices
  • Excellent written and verbal communication skills
  • Excellent teamwork and collaboration skills
  • Excellent attention to detail and commitment to quality of work
  • Able to learn quickly and adapt to fast - paced environment

TECHNICAL SKILLS:

  • Microsoft SQL Server 2005/2008/2012/2014
  • Visual Studio 2012/2013 and Team Foundation Server 2010
  • WCF services and AppFabric
  • C# and .Net 4.0
  • Microsoft SSIS,SSAS and SSRS 2013
  • Entity Framework
  • Asp.net MVC
  • XSLT/XML DOM
  • BizTalk Server

PROFESSIONAL EXPERIENCE:

Confidential, Boca Raton, Florida

Senior SQL Engineer

Responsibilities:

  • Developed an ETL Process to replace an Online Data Store (ODS) ETL Process (which run once a day) to update near real-time. This allowed us to eliminate the need for a separate Current Day report in the Transactional Database for each historical report in the ODS. This was developed using SSIS 2013 on SQL Server 2014.
  • Designed and Implemented an Online Archive Database for customer data. This was an exact schema as the Transactional Database. It allowed us to keep the Transactional Database trimmed for optimal operation of connected mobile devices used at customer sites.
  • Worked with team of developers to refactor existing Transactional Database to optimize for performance and increase scalability of the system.
  • Optimized existing Database Stored Procedures and wrote new ones as needed.
  • Maintained existing SSRS reports and developed new ones to meet client needs.
  • Engaged in Production Support. Analyzed performance issues in production environment during outages in order to identify root cause and implemented fixes to restore service to customer. These included Index tuning, Store Procedure Optimizations, etc.
  • Involved in Analysis and Design of new application features to ensure that database requirements and limitations are factored into the design.
  • Worked with Build Engineer to make all database code check-ins gated. This allowed for all internal environments to be updated automatically as code is checked in. Any build failures were detected immediately and resolved, thus ensuring continuous delivery of high quality code.

Confidential, Fort Lauderdale, Florida

Team Lead / Senior ETL Developer

Responsibilities:

  • Led a team of about 5 Backend ETL Engineers to design and implement new applications and services for several clients, ensuring adherence to best practices and ISO standards.
  • Interfaced with Clients during Requirements gathering and converted the requirements into Design Specifications for the Team.
  • Interfaced with internal and External Project Management Teams to plan and review requirements and project schedules
  • Received data feeds in a wide variety of file formats (EDI, XML, Delimited, Fixed Length, SOAP Formats) and loaded them into our internal databases for each client.
  • Assisted in Database Design and Development of new Database Applications as well as troubleshooting issues with existing applications.
  • Involved in the Development, unit testing, and release of completed applications to ensure they meet customer requirements.
  • Implemented systems to generate scheduled outbound Extracts for clients.
  • Created SSIS Packages and WCF Services to process data from clients.
  • Created SSRS Reports to analyze data and to report processing status and results.
  • Created Stored Procedures and scripts to apply specific client business rules to Data Processing.
  • Maintained and periodically upgraded Legacy Applications and Services.
  • Migrated DTS Packages to SSIS 2012 to allow for efficient development and Execution in Production Environment.
  • Interfaced with QA Team During Test Cycles
  • Documented SSIS Packages, WCF Services, and Database Applications that were developed.

Confidential, Fort Lauderdale, Florida

QA Analyst/Support Engineer

Responsibilities:

  • Created Test Cases from Functional specification Document
  • Tested new applications and performed regression testing on existing applications
  • Assisted customers in reporting application issues and helped them troubleshoot where necessary
  • Communicated with Engineers regarding issues reported by customer and relayed feedback to Customers

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship