DBA in Northport, New York at AccruePartners

Date Posted: 11/10/2019

Job Snapshot

Job Description

COMPANY PROFILE
• Large Services Company with a national footprint, in excess of $4B in assets and 700 locations through the U.S.
• Beautiful corporate offices in South Charlotte
• Consolidating operations
• Dynamic leadership with proven experience in industry
• Financially stable with expected growth

WHAT THE COMPANY HAS TO OFFER
• Opportunity to be part of a growing organization with tremendous exposure
• Opportunity to support applications across all functional departments and provide technical solutions
• Excellent benefits and competitive compensation in a fast-paced yet professional working environment
• Exciting times in IT with a Data Center migration and new cutting edge technologies in place
• An “Enterprise Environment” with an all hands on deck approach to encourage teamwork and maximum technology exposure.

THE ROLE YOU WILL PLAY:
• Define and manage database backups using native tools and Litespeed
• This position will be responsible for administration, backups and monitoring of the SQL Server database environment, comprising approximately 15 total SQL Servers and 2 clusters.
• Coordinate backup and data transfer strategies for disaster recovery at a secondary data center
• SQL health monitoring and on-going performance analysis using both native tools (eg., DMVs) and 3rd party monitoring tools (Foglight)
• Deploy, schedule and monitor SQL Server jobs such as SSIS packages and SSAS cube building
• Setup appropriate maintenance plans and server configurations for optimal SQL Server operation
• Perform database and OS level patching as needed during maintenance windows
• Coordinate and recommend database changes with 3rd party application vendors
• Verify and deploy database change scripts from both vendors and internal employees
• Lead SQL Server troubleshooting and recovery in the event of severe performance issues or a system outage
• Maintain a consistent test environment for key SQL Servers
• Recommend hardware to match work loads
• Work to continually improve database solution with a focus on process improvement
• Work with the other IT team members on establishing and maintaining processes for data security

COMMUNITY:
• South Charlotte Ballantyne Area.

BACKGROUND PROFILE:
• 5 years’ experience with SQL Server, specifically SQL 2005/2008R2/2012
• 2 years of experience with data warehousing/business intelligence specific platforms, including supporting high performance analytical databases in star-schemas; ETL tool set up and administration
• SQL Server programming and development, Stored Procedures, Indexes, Views, Functions, etc.
• Performance tuning and optimization (PTO) Knowledge of:
o Windows 7 and Windows Server OS
o SQL Server Analysis Services (SSAS)
o SQL Server Integration Services (SSIS)
o SQL Server Reporting Services (SSRS)