SQL DBA
Arlington, VA

Job Description

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