Senior Database Architect

Posted on March 25, 2020

Location

Madison, WI
16567

Position Details

Full-Time

Job Summary

Beacon Technologies is looking to hire a Senior Database Architect to work in Madison, Wisconsin.

Job Description

We are seeking an enthusiastic and motivated candidate who thrives in a fast-paced environment to join our team as a SQL Database Architect - with a proven track record in the design, build, test, and deployment of quality database solutions that are consistent with project objectives, technology architecture standards and best practices.

Responsibilities include:

  • Designs and builds relational databases.
  • Create and administer database objects from design to deployment utilizing subject matter expertise to design or re-use, configure, and implement database solutions/processes that maximize system availability, efficiency, effectiveness, integrity, recoverability, and supportability.
  • Installation, configuration, upgrades, patching, migration, capacity planning, performance tuning, backup and recovery.
  • 24x7 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.
  • 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.

Service Ownership Responsibilities

  • Provide subject matter expertise (SME) on the technical aspects of the application or service when asked by peers, management, or Divisional partners for information or status.
  • Validate that the application or service is available or unavailable in the event of a critical service disruption.
  • Assist with troubleshooting the application or service upon request or when activated.
  • Define recommendations for application-specific upgrades, releases, and compliance with company quality standards, including security, high availability, and performance.
  • Respond to the on-call phone for incidents
  • Respond to the on-call staff

 

About Beacon Technologies

Are you looking to advance your career in information technology? Beacon Technologies offers career advancement opportunities, extensive training, and excellent benefits including paying for health and dental premiums for salaried employees. In addition to providing interesting opportunities, Beacon Technologies provides that old fashioned, personal touch, so you feel like a part of the Beacon team.