Beacon Roofing Supply, Inc.
The Developer/DBA's role is to direct, evaluate, review, and manage database resources and services across Allied (A Beacon Company) while ensuring high levels of data quality. This individual is also responsible for working with the Senior Database Administrator in developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability of databases and their accompanying software. Where required, the Database Analyst will design, install, monitor, maintain, and performance-tune production databases. Will assist in completion of Project tasks. Location: East Rutherford, NJ. Duties: 80% development - 20% monitoring and DBA work.Please note: Beacon Roofing will not provide H-1B or other immigration sponsorship.The Responsibilities include: Install, configure, troubleshoot, and maintain multiple database systemsImplement, configure and troubleshoot database instances, replication, backup, partitions, storage, and accessMonitor and optimize system performance using index tuning, disk optimization, and other methodsImplement policies and procedures for ensuring the security and integrity of the company databaseSet user privileges within the database environmentRespond to and resolve database access and performance issuesProvide production support, 24x7x365 on call supportBatch loading of data, modeling, mapping , data conversion, import/export between multiple data repositoriesDocumentation of database and process detailsEnsures that storage, archiving, back-up and recovery procedures are functioning correctlyMonitors capacity on database servers and continues planning to meet growth needsControls access permissions and privileges on pertinent databasesResponsible for the security of pertinent databasesMonitor database system details within the database, including stored procedures and execution time, and implement efficiency improvementsUnderstanding and following company safety rules to foster and maintain a safe work environment Performs other duties as assigned The Ideal Candidate Will Have: A comprehensive understanding of database structures, theories, principles, and practices. Knowledge of database structure and database analyticsAbility to create system administrative procedures and related documentationStrong technical documentation skills.Familiarity with backup and recovery conceptsProven analytical and problem-solving abilitiesAbility to manage multiple tasks, changing priorities, and meet deadlinesHighly self-motivated and directed, with keen attention to detailCommunication skills, both written and verbal BS in Computer Science or Information Technology or equivalent work experience 3 RDBMS experience 5 years MS SQL Server (SQL Server 2008, 2014 and 2016 only) and Oracle experience preferred Experience in a large, multi-location environment Experience in 20 plus server environmentAbility to discuss user requirements and understand the business use of technologyAbility to design and maintain databases to support specific business requirements.Ability to create system administrative procedures and related documentationStrong technical documentation skillsFamiliarity with backup and recovery conceptExperienced in SQL Server Tools: Query analyzer, SQL management studio, SQL Server Data - Tool for Visual Studio 2013/2015.Moderately advanced in T-SQL Data Manipulation Language (DML) to add, modify, query or remove data from a SQL Server Database.Experienced T-SQL Data Definition Language (DDL) to create, alter or drop data structures in an SQL Server instance. seasoned in SQL Server Integrated services(SSIS) development and deploymentAdvanced in Data migration/export/import to and from different data sources and systems.Experienced in TSQL, Stored Procedures, Views, User Defined FunctionsModerately advanced in Installation and configuration of SQL Server 2012, 2014 and 2016Knowledge in SQL Server SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS) Equal Opportunity Employerwww.beaconroofingsupply.com
Beacon Roofing Supply, Inc.
Website : http://www.beaconroofingsupply.com
Beacon Roofing Supply, Inc. is one of the largest distributors of residential and non-residential roofing and complementary building products in North America. We currently consist of 13 regional companies in 39 states and 6 Canadian Provinces with 240 locations and more than 3,000 employees. We are known throughout the building supply industry for having quality people, quality service and quality building products.