Database Administrator and ETL Developer

Company: CMP.jobs
Location: Middletown
Posted on: May 4, 2021

Job Description:

Reports To: Manager of Database Operations Department: IT, Business Intelligence Full Time Role based in Middletown, Rhode Island Description: Reporting directly to the Manager of Database Operations, this role will employ database and windows server skills to build, manage, document, maintain and optimize operational and reporting databases. The role will ensure that data is accurately sourced, mapped, readily accessible, timely, and relevant to business' needs. It will work closely with staff in management, marketing, sales and operations and 3rd party suppliers. Position Responsibilities: Manage the data extract and load processes for all operational and reporting databases. Create metadata, data maps and definitions for all source system data.
Manage windows server instances and maintain all operating system and application software.
Create and manage all data transfers from internal systems Manage data flows to the data warehouse and across systems as needed. Participate in development and management of data governance, adhering to all policies and procedures.
Create and maintain effective documentation
Position Skills and Requirements The successful candidate will have experience liaising between data analytics and marketing, sales, operations and customer experience functions. 5 to 10 years of experience in Database Administration. Extensive knowledge of SQL Server (2008 R2/2014/2016)
Hands on knowledge with Microsoft SQL Server Business Intelligence offering of products - Reporting Services, Integration Services or other ETL tools
Knowledge of high availability architecture including data replication, transaction log shipping and database mirroring
Knowledge of Windows Server (2008 R2/2012/2016) maintenance and administration
Extensive knowledge of software maintenance lifecycle
Extensive knowledge of FTP and production data transfer mechanisms including PGP encryption
Direct experience managing large databases
Experience with configuration management tools, i.e. Azure DevOps.
Excellent communication skills, written and verbal; able to communicate with technical and non-technical audiences
Experience working with the project management function
Bachelor's degree or equivalent experience
Mortgage industry experience a plus
Collaborator and Team player who goes the extra mile to help the teams and the business even if the exact problem is not in his/her leadership purview
Should be prepared to demonstrate the above prior to a hiring decision. Competencies: Empowered: Operate effectively, even when things are not certain or the way forward is not clear. Accountable: Take personal responsibility for decisions, actions, and failures and keep open to coaching, feedback and self-development. Customer Focused: Build strong customer relationships and delivers customer-centric solutions. Collaborative: Work cooperatively with others across the organization to achieve shared objectives. Communicative: Provide timely and helpful information to customers and teammates across the organization, verbally or in writing. Tech Savvy: Adopt new technologies with a sense of vigour and excitement. Measurements of Success: Ability to follow instructions.
"Customer" Satisfaction.
Timeliness with responding to tickets and other duties as assigned.
Ability to work independently and as a team player when required.
Work Environment & Demands: Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Work Environment: Office Possible Work Hazards: Minimal Physical Demands: Light

Keywords: CMP.jobs, Fall River , Database Administrator and ETL Developer, Other , Middletown, Massachusetts