Sr. Database Administrator

CoStar Realty Information, Inc
Washington, DC
Mar 19, 2019
Mar 22, 2019
Full Time
Sr. Database Administrator Job Description Duties and Responsibilities Demonstrate extensive knowledge of all aspects Microsoft SQL Server including administration, replication, backuprestore procedures and related components such as Reporting Services, Analysis Services and Integration Services. Install, configure, monitor and maintain databases in the production, development, and quality assurance environments. Recommend and implement solutions for SQL performance monitoring and tuning. Understand SAN based storage and related technologies, specifically as applicable and useful to MS SQL Server installations. Work with Operations team planning server hardware, storage and OS configuration upgrades to help get the most out of SQL Server for specific application requirements and performance metrics. Process database change requests, including the creation and modification of databases, tables, views, stored procedures, triggers, jobs, etc. in accordance with change control policies. Analyze problems, anticipate future problem areas and implement solutions. Work outside of normal business hours as required for completing projects, working on deployments and resolving system outages. To be placed on on-call rotation for a week every 3 months and respond to system alerts Requirements 5 years of experience with Microsoft SQL Server 2012 2014 2016 2017 supporting high traffic websites. Experience with the implementation and support of database replication. Experience working with very large databases. Experience with SQL Server High Availability Architecture (AlwaysOn) Understanding of Windows Server (2012 R2 2016) configuration and management, specifically as it relates to MS SQL Server installations and mission critical systems. Excellent understanding of coding with Microsoft T-SQL and stored procedures. Experience with adhering and implementing best practices within an enterprise environment that include using source control for all database related artifacts (including jobs, SSIS packages and replication configuration) and following a change requestnotification policy. Experience with SANs (3PAREMCPure), specifically with aspects related to MS SQL Server. Understands and is able to properly implement backup and disaster recovery procedures. Experience with CommVault Backup software and monitoring and alerting systems like PRTG Excellent work ethic and willingness to put in significant extra time as needed. Experience with PowerShell scripting, TFSVisual Studio Database Projects and SSDT is a plus. Bachelor's degree required. Relevant equal work experience may be considered in lieu of a degree. Nice to have (Big Plus) Experience migrating databases to cloud (AWSAzure). Involvement supporting applications in the cloud. NoSQL database experience (MongoDBHadoopRedisDynamoDBElastic Search). AWS solution architect certification preferred CoStar Group is an Equal Employment Opportunity Employer we maintain a drug-free workplace and perform pre-employment substance abuse testing

Similar jobs