On-call availability for approximately 7 days per month and during outages.
Sitting for extended periods of time.
Dexterity of hands and fingers to operate a computer keyboard, mouse, power tools, and other computer components.
Lifting and transporting of moderately heavy objects, such as computers and peripherals.
Strategy & Planning
Assess and develop long-term strategic goals for production databases in conjunction with data owners and department managers.
Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.
Acquisition & Deployment
Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.
Respond to and resolve database access and performance issues.
Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.
Plan and coordinate data migrations between systems.
Plan and coordinate database engine upgrades.
Develop, implement, and maintain change control and testing processes for modifications to databases.
Perform database health status and security audits.
Establish appropriate end-user database access control levels.
Develop routines for end users to facilitate best practices database use and assist with determining best practices for change management and code review processes.
Manage and/or provide guidance to all members of the team.
Formal Education & Certification
College diploma or university degree in the field of computer science and/or 8 to 10 years equivalent work experience.
Knowledge & Experience
Strong understanding of database structures, theories, principles, and best practices.
Extensive technical experience with designing, building, installing, configuring, and supporting Database servers, including SQL Server 2012, 2016, 2017.
Extensive knowledge supporting Oracle Database environments.
Extensive experience with developing and deploying SSIS packages.
Extensive experience deploying and troubleshooting SQL Server Service Broker.
Extensive experience setting up and troubleshooting SQL Server Availability Groups.
Experience administering SQL Server Databases in an OLAP Environment and familiarity with Data Warehousing Concepts.
Experience managing assigned query plans for repeat processes.
Preferred exposure and familiarity with Database Administration in a cloud environment.
Hands-on database tuning and troubleshooting experience.
Agile Scrum Project management methodology experience.
Ability to quickly understand the organization's goals and objectives.
Knowledge of applicable data privacy practices and laws including Payment Card Industry compliance.
Good written and oral communication skills.
Strong technical documentation skills.
Good interpersonal skills.
Ability to conduct research into database issues, standards, and products as required.
Ability to present ideas in user-friendly language.
Highly self-motivated and directed.
Keen attention to detail.
Proven analytical and problem-solving abilities.
Ability to effectively prioritize and execute tasks in a high-pressure environment.
Strong customer service orientation.
Experience working in a team-oriented, collaborative environment with the understanding that some low level tasks may be required at times.