Banfield Pet Hospital Sr. Database Administrator - SQL in Vancouver, Washington
Summary and Qualifications:
The Sr. Database Administrator provides expertise in maintaining the production instances of SQL Server (On prem/DBaaS) at their optimal state, helps create test environment for development, manage database projects in TFS and git using visual studio, maintains the CI/CD pipeline and creates builds, provides stewardship on best practices for sustainable development and securing database infrastructure, provides expertise in designing and maintaining database solutions using the appropriate data store and provides on-call support as required.
Essential Responsibilities and Tasks:
Live and exemplify the Five Principles of Mars, Inc. within self and team.
Support Application development teams with database design, development, code review (TSQL), database build, data analysis and modeling, TSQL programming, performance monitoring, tuning, cloning/refreshing, planning and problem solving.
Install, upgrade, and patch database software, agents, utilities, and options.
Collaborate with development teams on the use of the standard best practices for the database design and implementation.
Provision SQL Server DBaaS, import/export/backup/restore the data using appropriate methods.
Manage multiple database projects in the source control, create a database build for production deployment. Configure the project for continuous delivery.
Create and manage multiple environments with obfuscated data. Maintain data obfuscation process.
On-call production support in rotation.
Prioritize workloads, utilizing project and time management skills.
Use analytical capabilities to effectively identify and resolve problems in high-visibility and high-stress situations.
Other job duties as assigned.
Special Working Conditions:
Ability to work at a computer for long periods of time.
Project timelines and work volume/deadlines may often require more than 40 hours per week to complete essential duties of this job.
Must have mental processes for reasoning, remembering, mathematics and language ability (reading, writing, and speaking the English language) to perform the duties proficiently.
Ability to carry out instructions furnished in written, oral, or diagram form and to solve problems involving several variables.
Ability to stand, walk, stoop, kneel, crouch, and climb as well as manipulate (lift, carry, move) up to 50 pounds.
Requires good hand-eye coordination, arm-hand-finger dexterity with the ability to grasp, and visual acuity to use a keyboard and operate necessary equipment.
The noise level in the work environment is normally moderate.
Environment where pets are present.
Experience, Education and/or Training:
Bachelor’s degree in Computer Science or a related field is required, or the equivalent combination of education, training and experience that provides the required knowledge, skills, and abilities.
Knowledge of SQL Server (2008 - 2019) Database Design, development and maintenance is preferred. Certification is a plus.
Seven years of experience in SQL Server Database Administration in medium to large corporate environments are required.
Experience creating a database solution on-prem and in cloud, database design, development, managing database projects, creating build script, data compare, performance troubleshooting, providing support in setting up database in a lab environment is required.
Performance monitoring, experience managing ETL and ELT solution using SSIS and Databricks, and familiarity with SQL Server Engine and Query Optimizer are required.
On-call support and deployment support are required.
Working experience with PowerShell, configuring database for continuous integration for automatic deployment is required.
Working knowledge of creating Azure SQL DBaaS/Managed instances, managing security, Data Import/Export is required.
Excellent verbal and written communication skills are required.
The ability to present clean, organized, and thorough information and data that is appropriate for intended audiences is required.
WE ARE A DRUG-FREE, SMOKE-FREE, EQUAL OPPORTUNITY EMPLOYER.
Banfield Pet Hospital® strongly supports and values the uniqueness of all individuals and promotes a work environment where diversity is embraced. Banfield Pet Hospital is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, sex, sexual orientation, gender identity, age, genetic information, status as a protected veteran, or status as a qualified individual with disability. Banfield Pet Hospital complies with all applicable federal, state and local laws governing nondiscrimination in employment in every Banfield location.
Job: Information Technology
Title: Sr. Database Administrator - SQL
Requisition ID: BAN001GV