Database Administrator

Position: Database Administrator Location: Madison, WI Duration : 6+ months Design, develop, and maintain relational databases for data storage and data mining.  Perform data warehouse design and testing, including data design, database architecture, metadata, and repository creation.  Develop processes and procedures for entering information into data warehousing systems and for ensuring reliability of information entered.  Seek continuous improvement in performance of data warehouse and ensure security of data.  Career-Level position within field.  Requires experience and proficiency in discipline.  Conducts complex work important to the organization.  Works with minimal supervision with wide latitude for independent judgment.  Typically requires six to nine years’ experience or equivalent education.  Nice to Have: Oracle DB experience  & MCSA for SQL 2016  Work Location is remote during COVID restrictions, once restrictions have been lifted work will return to on-site. Specific responsibilities include: · All aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning, backup and recovery. · rotational on-call support, including driving Root Cause Analysis (RCA), Preventative action follow-through, and participation in weekly operations reviews. · Change management including maintenance of multiple development, staging, and production environments. Responsible for deploying approved changes to production. · Proactive database monitoring and issue resolution. Specific professional experience and expertise with Idera database tools. · Database optimization including performance tuning, query optimization and supportability. · Actively participate and contribute to projects involving enterprise database systems enhancements to meet business requirements. · Participate in project design and SQL Server database design decisions. · Develop and implement Database security policies and procedures, in line with organizational objectives. · Responsible for evaluating patch releases and patching requests from development, and communicating constraints, issues, and timelines for deployment. Requirements: · Requires a depth and breadth of database knowledge that will help with formal design of relational databases and provides insight into strategic data manipulation. · Database Architect capabilities with 6+ years of experience, independently designs and builds relational databases. · Develops strategies for data acquisitions, archive recovery, and implementation of a database. Cleans and maintains the database by removing and deleting old data. · Familiar with a variety of the field's concepts, practices, and procedures. · Relies on extensive experience and judgment to plan and accomplish goals. · Performs a variety of tasks. A wide degree of creativity and latitude is expected