SQL Server DBA



Posted Under: Syracuse, New York jobs in IT / Software / Systems; IT / Software / Systems jobs in zipcode 13201
Posted On: 2017-11-20 15:00:00

<span>Job Title: SQL Server DBA, Syracuse, NY<br>&nbsp;<br>Are you a talented SQL Server DBA? Are you interested in working for a company that puts their people first?<br>&nbsp;<br>We are seeking a SQL Server DBA to join our client&#39;s team.<br>&nbsp;<br>The SQL DBA, maintains, develops and implements policies and procedures for ensuring the security and integrity of the company databases. Implements data models and database designs, data access and table maintenance codes; resolves database performance issues, database capacity issues, replication, and other distributed data issues. Responsible for system up-time and disaster recovery planning as it relates to database systems. &nbsp;Manages and monitors ETL data process flows.<br>&nbsp;<br>Job Description:<br>&nbsp;<br>This role is focused on providing hands-on operational deployment and support for commercial and custom software applications, with an emphasis on SQL Server and Data Integration methods and technology. &nbsp;You will be an individual contributor responsible for researching, designing, engineering, implementing, and supporting information security technologies with a focus on MS SQL environments. &nbsp;Your primary duties include leveraging your in-depth technical knowledge to manage and enhance the databases that are within commercial solutions as well as internally developed by providing direct application administration and troubleshooting, code analysis/reviews, and controls management. <br>&nbsp;<br>The successful candidate must be willing to participate in potential 24x7 break-fit situations.<br>&nbsp;<br>&nbsp;<br>SQL SERVER DATABASE ADMINISTRATOR RESPONSIBILITIES<br>&nbsp;<br>&bull;Provide expertise on the implementation of database technologies and disciplines.<br>&bull;Install, upgrade and adjust database management systems.<br>&bull;Work with business experts and application developers to define logical data models.<br>&bull;Transform company logical data model into a database design.<br>&bull;Recommend concessions to support database performance and downstream flexibility.<br>&bull;Construct indices based on application usage patterns.<br>&bull;Design replication and/or ETL strategies to support business continuity and reporting needs.<br>&bull;Review SQL with developers to ensure applications perform at a high level against the database.<br>&bull;Design database access security controls.<br>&bull;Monitor database performance and space allocation.<br>&bull;Plan, organize, implement, and maintain multiple database environments<br>&bull;Design database Backup, Recovery and Restoration Strategy<br>&bull;Perform capacity planning on database servers<br>&bull;Participate in a 24/7 database support rotation.<br>&nbsp;<br>&nbsp;<br>SQL SERVER DATABASE ADMINISTRATOR MINIMUM REQUIREMENTS<br>&nbsp;<br>&bull;5+ years&rsquo; experience with SQL Server 2008 R2 or higher Required<br>&bull;Bachelor&#39;s degree or commensurate years of experience Required<br>&bull;Strong knowledge of Relational Databases and T-SQL Scripting is Required <br>&bull;Experience with SQL server clusters and replication is highly desired<br>&bull;Experience with SSIS / SSRS and data modeling preferred.<br>&bull;Experience with MicroStrategy 9.0 or higher Bonus<br>&bull;Understanding of Software Development Life-cycle<br>&bull;Understanding of Change Control models <br>&bull;Excellent verbal and written communication skills.<br>&bull;Ability to meet multiple deadlines in a multitasking environment<br>&bull;Strong problem solving skills<br>&bull;Positive attitude and strong work ethic<br>&nbsp;<br>Apply today for this exciting SQL Server DBA job based here in Syracuse, New York or call Susan Duenkel at 315-233-4067<br>&nbsp;<br>&nbsp;<br>&nbsp;<br></span>