SQL Server DBA

Unclassified - Syracuse, NY

Full-time

Syracuse, NY

About the position

The SQL Server DBA position involves maintaining, developing, and implementing policies and procedures to ensure the security and integrity of company databases. The role focuses on operational deployment and support for commercial and custom software applications, particularly in SQL Server environments. The DBA will be responsible for database performance, capacity issues, disaster recovery planning, and managing ETL data process flows.

Responsibilities

• Provide expertise on the implementation of database technologies and disciplines.
• Install, upgrade and adjust database management systems.
• Work with business experts and application developers to define logical data models.
• Transform company logical data model into a database design.
• Recommend concessions to support database performance and downstream flexibility.
• Construct indices based on application usage patterns.
• Design replication and/or ETL strategies to support business continuity and reporting needs.
• Review SQL with developers to ensure applications perform at a high level against the database.
• Design database access security controls.
• Monitor database performance and space allocation.
• Plan, organize, implement, and maintain multiple database environments.
• Design database Backup, Recovery and Restoration Strategy.
• Perform capacity planning on database servers.
• Participate in a 24/7 database support rotation.

Requirements

• 5+ years' experience with SQL Server 2008 R2 or higher
• Bachelor's degree or commensurate years of experience
• Strong knowledge of Relational Databases and T-SQL Scripting

Nice-to-haves

• Experience with SQL server clusters and replication
• Experience with SSIS / SSRS and data modeling
• Experience with MicroStrategy 9.0 or higher
• Understanding of Software Development Life-cycle
• Understanding of Change Control models
• Excellent verbal and written communication skills
• Ability to meet multiple deadlines in a multitasking environment
• Strong problem solving skills
• Positive attitude and strong work ethic