SQL DBA

Database AdministratorThe Database Administrator will be a part of the team responsible for the operational support of project initiatives surrounding the company's Database environments. This position will play an integral role in the maintenance, support and enhancements of business-critical applications.ResponsibilitiesMonitor and maintain database securityMigrate databases between servers and various platformsReview database object and create and maintain change controlsAnalyze and resolve SQL Server faultsInvestigate and resolve reported application issues, escalating issues as necessary to the application ownersDesign, develop and implement internal data feeds, data reporting extracts and ETL processes between disparate systemsDocument data flows, application specifications from a DB perspective and system proceduresMonitor relational databases to optimize performance, resource use, backup/recovery, and physical implementationImplement and maintain data distribution and disaster recovery solutions, such as mirroring, replication, and log shippingImplement, create reports and provide general support for SQL Server Reporting servicesSupport highly-available and disaster recovery (HA/DR) database technologies (such as SQL Clustering and SQL Server Availability Groups across multiple data centers)Provide 24x7 on-call support on a rotating basisRequirementsBachelor's degree in Computer Science or a related field5+ years of experience with SQL 2012, SQL 2014 and SQL 2016Strong understanding of security implementationExperience with SQL Server performance management and tuning, including understanding of SQL execution plansSQL Server Administration experience including: TriggersStored Procedure Code Development and StandardizationData Integration and MigrationManagement StudioSQL XMLDatabase Auditing and ControlsProven troubleshooting abilitiesStrong planning and analysis skillsStrong documentation skillsPreferred ExperienceAbility to translate Logical Data Models into physical structuresStrong knowledge of Windows 2012 and 2016Strong knowledge of physical and VMWare SQL configuration from an infrastructure perspective 1872 Consulting