SQL DBA

SQL DBADatabase AdministratorArlington, VAAsset ManagementJO-1801-553Job Responsibilities:Engage system/storage admins and development teams productivelyDevelop 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 updatesMonitor and maintain transactional replication and Always on configurations.Preferred Qualifications:Bachelor's Degree – a degree in a computer science, engineering, mathematics, or science preferred5+ years related professional experienceRelevant technical certificationsAdvanced knowledge of T-SQL development, SSIS, SQL internalsExperience supporting an environment with significant product and software developmentAbility to proactively identify, troubleshoot and resolve live database systems issues.Knowledge of HA and disaster recovery principles and practices, including planning, testing, backup/restoreKnowledge of Windows Server architecture and patchingUnderstanding and experience with transactional replication, clustering and other HA solutionsExperience installing/upgrading/patching/configuring SQL 2008/2012/2014Knowledge of PowerShellKnowledge and/or experience with 3rd party backup and performance monitoring tools a plusKnowledge of SSRS and SharePoint integration a plusExperience with SAN/Storage technologies, virtual environments and OLAP/SSAS data warehouse solutions a plusExposure to new database technologies such as NoSQL, in-memory databases, graph databases and/or data grids a plusKnowledge of source control and release management systems a plusCandidates must be eligible to work in the US without sponsorshipKey Competencies:Critical thinking and problem solving skillsDecision-makingTeam workStress toleranceAbility to raise difficult issues in a constructive way