SQL DBA

Description:Job Responsibilities:

Engage system/storage admins and development teams productively

Develop automation within the environment for SQL server deployment and updates, maintenance, custom software deployments, etc.

Assist with development of standards and policies around data /access security (end-user access vs dev access)

Maintain and monitor database environments for 24/7 availability. Performance of duties will sometimes require work outside of regular business hours. May be expected to act as first contact in a rotating, on-call schedule for database support.

Develop alerts, reports and automated processes for failed jobs.

Collect and analyze database and system performance measurements over time.

Optimize procedures, indexes and table schemas according to trending data.

Enforce security measures and policies by minimizing scope of exposure to logins, applying security patches and performing necessary security audits.

Review design and deployment of any data objects from development environment to production.

Troubleshoot database and hardware-related problems.

Monitor SQL Server activity, performance, error logs, event logs, space usage and security on a daily basis.

Manage and execute daily operational jobs including backups, index/statistics updates

Monitor and maintain transactional replication and Always on configurations. Preferred Qualifications:

Bachelor's Degree - a degree in a computer science, engineering, mathematics, or science preferred

5+ years related professional experience

Relevant technical certifications

Advanced knowledge of T-SQL development, SSIS, SQL internals

Experience supporting an environment with significant product and software development

Ability to proactively identify, troubleshoot and resolve live database systems issues.

Knowledge of HA and disaster recovery principles and practices, including planning, testing, backup/restore

Knowledge of Windows Server architecture and patching

Understanding and experience with transactional replication, clustering and other HA solutions

Experience installing/upgrading/patching/configuring SQL 2008/2012/2014

Knowledge of PowerShell

Knowledge and/or experience with 3rd party backup and performance monitoring tools a plus

Knowledge of SSRS and SharePoint integration a plus

Experience with SAN/Storage technologies, virtual environments and OLAP/SSAS data warehouse solutions a plus

Exposure to new database technologies such as NoSQL, in-memory databases, graph databases and/or data grids a plus

Knowledge of source control and release management systems a plus

Candidates must be eligible to work in the US without sponsorship Key Competencies:

Critical thinking and problem solving skills

Decision-making

Team work

Stress tolerance

Ability to raise difficult issues in a constructive way #LI-MG1