Our client has an immediate opening for a
Senior SQL Developer / DBA
who will be responsible for SQL Server based solutions, data warehouse, business intelligence, and data integration needs. You will be responsible for the development, administration and maintenance of ETL processes and SQL procedures, triggers, views, functions and reports; database and related asset backups and recovery; SQL query optimization; index management; System performance and tuning/ optimization and production support for database problem resolution, recovery and Emergency off-hour support.
Job type: Fulltime Employee
Location: Wilton, CT
Comprehensive benefits, plus very nice additional perks
Skills and Qualifications
7 + years working knowledge of MS SQL Server 2008R2 or newer versions
Experience implementing maintaining and automating backup and recovery plans.
Experience in database design, development, implementation and methodologies for Data warehouses and OLTP business systems.
Comprehensive knowledge of Transact SQL, Stored procedures, Views, Triggers, Functions.
Experience automating data Import/Extraction using SQL Server tools such as SSIS, BCP, bulk insert.
Ability to examine and optimize query execution plans and index/data usage.
Experience analyzing hardware, software, network ecosystems to optimize database server performance.
Experience resolving locking, dead lock issues.
Experience with Microsoft Reporting and Analysis Services (SSRS, SSAS)
Ability to work with internal customers, including the ability to read and interpret what the internal customer is saying to proactively identify potential issues and problems and advise the internal customer on best practices and/or be able to suggest and deliver product enhancements
Excellent oral and written communications skills
Familiarity with: IBM System i (i5, AS400), IBM DB2 for i, Adobe Campaign marketing automation system, Accounting/Financial Systems (AR, GL, AP), Data Integration with external sources using Web Services/SFTP, Managing Virtual Server Environments with SAN’s (VMWare, XENServer), Travel Industry Systems is a big plus
Familiarity with various programming and/or scripting languages such as: C#, VB/VBA, PowerShell, batch/cmd files, XML, BIML, JSON.
Expertise with creating maintaining data sources