Senior SQL Server DBA

Location: Hingham, Massachusetts US

Apply

Job Number: 6130

Position Title: Data Administrator III

External Description:

The Sr. SQL Server DBA is responsible for maintaining and providing support for Talbots’ database management systems based on Microsoft database technologies and other ancillary technology components.  This position will be involved in installations, upgrade planning, proactive monitoring and tuning, troubleshooting issues, identifying root cause of issues, and participate in a rotating on call schedule for continuous 24x7 support.  The position will require the ability to maintain legacy database systems while at the same time plan and perform the migration to new upgraded database engines.  You will take the lead in monitoring database storage, making recommendations for best practices and enforcing standards, production migrations, as well as, adhere to security compliance via patching and risk analysis.

 

Responsibilities include but are not limited to:

  • Work effectively with a mixture of on/off shore SQL DBAs to configure and manage Microsoft SQL Server 2008/2012/2014/2016/2017 running in a VLAN environment across multiple sites
  • Experience implementing and managing SQL Server high-availability technologies (replication, mirroring, failover clusters, etc.)
  • Monitor the database environment to provide consistent response times to the business systems using them.  Recommend changes to data structures or the DBMS to optimize performance based upon monitoring
  • Troubleshoot and resolve database integrity issues, performance issues, blocking and deadlocking issues, replication issues, connectivity issues, security issues
  • Ability to support/learn other technology systems i.e., Microsoft IIS, Autosys Scheduler, Rubrik Backup System etc.
  • Basic understanding of the .NET Framework, Java Environments running on the JBoss Enterprise Application Platform
  • Implement, document, and maintain methods and procedures for data and database backup and recovery, both on-site and off-site. Participate in disaster recovery tests
  • Create, document, and maintain diagrams of current environments
  • Provide general education and training, along with product support and diagnostic assistance with data access problems to applications development, computer operations, and production assurance utilizing DBMS and related integration tools 
  • Troubleshoot problem programs to obtain most efficient data source connectivity and data access. Suggest specific programming techniques and database access to application areas developing these subsystems. Make changes to data structures or the DBMS to optimize performance 
  • Request product upgrades from vendors. Install, test and implement vendor products. Migrate change into production environments. (i.e. new versions or releases, corrective and preventative maintenance and support for vendor packages). Participate in the Request for Proposal Process (RFP)
  • Track and analyze DISK growth based on application and data usage. Implement the necessary changes to accommodate the growth
  • Create and maintain procedures related to the DBMS subsystems, related software products, and data movement between computing environments
  • Continue to independently stay abreast of the latest database integration technology
  • Works independently with no supervision
  • Perform as a project leader. Create documentation and work plans using applicable project management tools. Schedule, attend and conduct project meetings and provide status updates to management
  • Identify new opportunities to:
    • Improve the efficiency of the data subsystems
    • Reduce company costs
    • Improve existing processes therefore reducing effort or increasing productivity, including automation of tasks

 

 Qualifications:

  • Knowledge at a level normally acquired through the completion of a Bachelor’s degree in Computer Science or equivalent 
  • 7-10 years’ experience in SQL data administration 
  • In depth knowledge of SQL Server, Analysis Services, Integration Services (SSIS), Reporting Services (SSRS), Window OS, virtualized platforms utilizing Microsoft Hyper-V and VMWare ESX
  • Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools 
  • Demonstrate knowledge in physical data modeling data administration and data architectures
  • Microsoft SQL Certification desired
  • Good technical, project management, analytical, and communications skills are required

City:

State:

Community / Marketing Title: Senior SQL Server DBA

Company Profile:

Talbots is a leading omni-channel specialty retailer of women's clothing, shoes and accessories. Established in 1947, the company is known for modern classic style that's both timeless and timely, fine quality craftsmanship and gracious service. At Talbots relationships are the key to our business, we hire individuals who bring new ideas to the table, understand smart risk taking and  can enhance an already thriving culture.  With a commitment to offer modern classic style for every body type, through a  full range of sizes, inclusive to every woman in your life.

EEO Employer Verbiage:

Talbots is an equal opportunity employer and welcomes applications from diverse candidates. Hiring decisions are based upon a candidate's qualifications as they relate to the requirements of the position under consideration and are made without regard to race, sex, national origin, color, age, disability, veteran status, pregnancy, sexual orientation, religion, or any other category protected by applicable law. Talbots is committed to providing reasonable accommodations for job applicants with disabilities. If you require an accommodation to perform the essential duties of the position you are seeking or to participate in the application process please contact recruiting@talbots.com. Talbots will make reasonable accommodations for otherwise qualified applicants or employees, unless such accommodations would impose an undue hardship on the operations of the Company’s business.

PositionType_Description: Full Time

Location_formattedLocationLong: Hingham, Massachusetts US

.linkedin link       instagram link       facebook link      twitter link