Performs DBA functions in all environments including performance tuning and capacity planning. Performs as a team lead or project manager for major projects within the DBA team. Collaborates with development teams supporting the application development lifecycle and/or the production support teams while ensuring system stability.
Responsible for SQL Server Software installation and upgrades.
Performs application security configuration and administration.
Performs logical database design and physical database implementation.
Is instrumental in SQL Server database creation, monitoring and performance tuning.
Is responsible for application/SQL troubleshooting and tuning.
Develops and implements Backup and Recovery Strategies.
Reviews SQL code and database object designs against standards and best practices.
Performs database administration from the command line as well as through graphical tools.
Architects and develops ETL solutions for Business Intelligence solutions.
Administers Analysis Services performance and resources.
Plays active technical role in the planning phase of new projects.
Works closely with customers to determine their strategic business need requirements and measures system performance against expectations.
Supports production systems, as required, by optimizing performance, helping resolve problems, and providing timely follow-up on problem reports.
Will serve as technical lead on projects.
Coordinates implementation activities with other parts of the enterprise.
Participates in presentations to senior leadership.
Communicates plans, status and issues to higher management levels.
Works directly with all areas in IT and has close working relationship with IT peer group.
Assists IT peers and junior engineers in technical issue resolution.
Provides technical direction, and training to other IT personnel.
Mentors employees within the DBA group and other groups within IT offering guidance and sharing business and technical knowledge.
Participates in on-call duty 24/7 pager rotation.
Sets a good example by modeling HSN values and desired behaviors.
Must possess practical Windows OS experience.
Must demonstrate abilities in the following areas: RDMS Software and Tools Installation, Configuration Management, Security Administration, Monitoring and Tuning, Backup and Recovery, Troubleshooting and Efficient use of database storage.
Must have practical experience tuning moderate to large database systems (over 400GB).
Must possess the ability to work independently and with both DBA team and application development groups.
5+ years of SQL Server Database Administration.
5+ years of T-SQL.
5+ years of Backup and Recovery.
Database Design / Data Modeling.
3-5 years Performance Tuning.
1-3 years Analysis Services/Data Mining.
7x24x365 High Availability.
Troubleshooting / Problem Solving Skills.
Monitoring (System / Database).
Ability to establish a high level of customer trust.
SQL Server 2005/2008R2/2012 Administration
SQL Sentry Monitoring
SOX/PCI Audit Experience
Disaster Recovery Planning and Preparation
Load Testing / RML Experience
HSN - 24 months ago
HSN is a leading interactive multichannel retailer, offering a curated assortment of exclusive products and top brand names to its...