Support daily database development, including testing and defect resolution or data modification requests and investigate and develop new solutions for business operations; involving needs analysis studies and status reports.
Responsible for the overall design of the enterprise wide data/information architecture, which maps to the enterprise architecture and balances the need for access against security and performance requirements.
The primary focus will be development of Extract-Transform-Load logic using CloverETL and Python scripting, migration of legacy scripted solutions to CloverETL, database development in DDL/DML (primarily Oracle), and operational support of the ETL software infrastructure and processes.
Responsible for the overall design of the enterprisewide data/information architecture, which maps to the enterprise architecture and balances the need for access against security and performance requirements.
The SQL Server DBA team is responsible for the 24x7 availability of mission critical databases in production environment and User Acceptance, Development, and Test environments for fast-paced delivery.
Liaising with business and technical teams to understand and gather requirements, design and implement reporting solutions to meet business needs, troubleshoot reporting and data issues, and implement technical solutions for the same.
This resource will be responsible for ensuring the overall health and performance of the SQL Server database and MSFT environment. This person will monitor performance, reliability, availability and recoverability of the databases, ETL and applications.