Database Administrator and ETL Developer
Posted on: May 4, 2021
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
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
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
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.
Timeliness with responding to tickets and other duties as
Ability to work independently and as a team player when
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
Didn't find what you're looking for? Search again!