Database Administrator

About the Role

We are seeking a Database Administrator to join our team. You will be responsible for testing and implementing computer databases, planning migrations from existing application versions to the latest versions, and ensuring data is accessible to users while protected from unauthorized access.

Database Administrators ensure databases run efficiently, store and organize data (such as financial data and customer shipping records) using advanced software, and develop backup and recovery plans based on industry best practices. You will also monitor databases for performance problems, troubleshoot issues, and control access to database systems.

Responsibilities

• Administer, test, and implement computer databases
• Coordinate changes to computer databases and implement security measures to safeguard them
• Create and manage database schemes, tables, procedures, and permissions
• Execute database mirroring, backups, failover, replication, and disaster recovery tasks
• Restore and recover corrupted tables or databases
• Implement database security, including managing access and permissions
• Install upgrades, patches, and new applications; customize existing applications to fit business needs
• Create shell scripts for task automation
• Proactively install, test, evaluate, and recommend new database technologies
• Communicate and collaborate with staff to ensure database integrity, security, and optimization
• Analyze and maintain capacity and performance requirements
• Work with senior technical resources to document and design database architecture for current and new applications
• Report on the progress of assigned projects clearly and effectively
• Identify database requirements by interviewing customers and analyzing department applications, programming, and operations
• Maintain database performance by calculating optimum values for database parameters and completing maintenance requirements
• Write and maintain database documentation, including data standards, procedures, and definitions for the data dictionary (metadata)
• Develop, manage, and test database backup and recovery plans
• Execute professional and technical knowledge by attending educational workshops, reviewing publications, and participating in professional societies
• Develop and maintain custom SSRS reports that pull data from various applications

Requirements

• Bachelor’s Degree in Computer Science, Information Technology, or equivalent work experience
• Extensive knowledge of Microsoft SQL Server versions 2005, 2008 R2, 2012, 2016, and 2019
• Experience administering Windows Server 2008, 2012, and 2019 Operating Systems
• Experience with scripting (T-SQL, PowerShell, database scripting, etc.)
• Certifications for Microsoft SQL Server Database Administration is a plus
• Experience optimizing database deployments in Cloud environments is a plus
• Excellent written and verbal communication skills in English
• Ability to learn quickly, analyze successes and failures, and adapt to new problems
• Critical thinking skills to recognize patterns, anomalies, and derive actionable conclusions
• Fast-paced, results-oriented work ethic with a track record of exceeding goals
• Strong attention to detail and ability to multitask with conflicting deadlines
• Team player with a collaborative mindset