Senior Database Administrator in Norwalk, CT

View All Retail & Consumer Goods jobs

Industry:

Retail & Consumer Goods   •  

8 - 10 years

Posted 7 weeks ago

Key Responsibilities Include:


  • Proactively analyze and perform advanced administrative tasks to ensure the health of our SQL Server 2012 database environment
  • Proactively analyze and institute safeguards to ensure secure, stable production environments. Towards this end, utilize current in-shop tools and lead analyses to update/enhance DBA Toolsets and cost effectiveness of toolset deployments.
  • Work closely with application developers to design, test, implement, optimize and maintain efficient transactional and analytical data models
  • Lead/engage in tuning, upgrade and configuration projects to enhance performance and ensure stability
  • Optimize and maintain backup jobs and schedules as well as maintain Production, DR and Development environments
  • Troubleshoot database and data issues as they occur
  • Provide Ad Hoc data reporting and data pulls for Analytics teams
  • Perform various ad-hoc data loading and data manipulation tasks
  • Manage routine data exports for clients, partners and SMEs
  • Create and manage scheduled tasks and data processing scripts
  • Document data collection, processing and presentation procedures
  • Help maintain architecture and process flow diagrams for data systems

Required skills:


  • 7-10 years of on-the-job DBA experience
  • Experience administering large SQL Server databases
  • Strong T-SQL skills
  • Stored procedures, UDFs, triggers
  • Strong Performance Tuning Skills
  • Indexing
  • Statistics
  • Query Tuning
  • Partitioning
  • Committed to service excellence, collaboration and added value
  • Proactive; takes initiative; is results-oriented. Asks "why?" - and proposes solutions!
  • Focuses on improving and innovating
  • Excellent written and verbal communication skills
  • Ability to design solutions and accurately estimate level of effort and completion dates
  • Ability to work well and multi-task in a team environment where development is a collaborative effort
  • Ability to scale through process-driven disciplines
  • Ability to produce valuable/usable documentation through various software tools

Optional Valued Knowledge, Skills and Abilities:


  • Proficiency in SQL Server SSAS, SSIS and SSRS a strong plus
  • Knowledge of .net coding – a strong plus