Database Administrator II

About the role

This Database Administrator II role manages and administers all aspects of corporate databases and database platforms, including installation, configuration, maintenance, security, performance, ETL, and other support roles.

Responsibilities

• Management and administration of SQL Server database platforms
• Management and administration of PostgreSQL database platforms
• Management and administration of MySQL database platforms
• Manage SQL Server backups and data archiving
• Manage PostgreSQL backups and data archiving
• Provide database support and expertise to report writing, business systems, software development, and other IT functions
• Monitor job execution and server performance, and troubleshoot issues when they occur
• Facilitate database system access to third-party resources when applicable
• Work with other data, security and DevOps teams to implement and maintain source code, pipelines, and security best practices
• Proactively identify optimization opportunities using query performance metrics or other environment bottlenecks

Requirements

• Educational background: Bachelor’s degree in information systems, computer science, or related field, or equivalent work experience
• Experience: 5+ years of experience as a Database Administrator, managing backups, snapshots, and data archival
• Experience: Management of security and separate environments for development, staging, and production
• Experience: Works with ETL tools, SSIS packages or modern cloud data pipelines, writing and troubleshooting SQL scripts
• Experience: Create and maintain indexes, troubleshoot & monitor job execution and system performance issues
• Experience: Strong analytical, problem-solving, and collaboration skills for working with both business and technical teams
• Experience: Strong experience with Amazon Web Services
• Nice to have: Cloud certifications or equivalent experience with AWS, GCP, and/or Azure
• Nice to have: Certifications: PostgreSQL, Microsoft Certified IT Professional (MCITP) Database, Percona Server for MySQL or other equivalent certification
• Nice to have: 3-5 years of experience with creating, utilizing, and maintaining DevOps pipelines
• Nice to have: Familiar with enterprise logging framework best practices
• Nice to have: Experience with DevOps practices, like version control systems (e.g., Git) for code deployment in a CI/CD pipeline
• Nice to have: Previous experience with platforms such as Docker, Bitbucket, GitHub, Terraform, Ansible, Azure DevOps, etc.
• Nice to have: Experience with MDM solutions, Melissa Data address standardization, D&B enrichment, or other data quality, match, merge, & enrich tools
• Nice to have: Experience with other RDBMS, warehouse, or lakehouse database patterns or platforms such as Oracle, RedShift, No SQL etc.

Qualifications

• Strong analytical, problem-solving, and collaboration skills for working with both business and technical teams
• Expertise in SQL Server, PostgreSQL, and MySQL
• Experience with SQL Server Reporting Services (SSRS), Microsoft Fabric, Power BI, Tableau or other BI and reporting platforms
• Experience with RedGate SQL Toolbelt and SQL Clone or other equivalent query & database admin tools
• Experience with Amazon Web Services
• Experience with DevOps practices, like version control systems (e.g., Git) for code deployment in a CI/CD pipeline
• Experience with MDM solutions, Melissa Data address standardization, D&B enrichment, or other data quality, match, merge, & enrich tools
• Experience with other RDBMS, warehouse, or lakehouse database patterns or platforms such as Oracle, RedShift, No SQL etc.

Skills

• Strong analytical, problem-solving, and collaboration skills for working with both business and technical teams
• Expertise in SQL Server, PostgreSQL, and MySQL
• Experience with SQL Server Reporting Services (SSRS), Microsoft Fabric, Power BI, Tableau or other BI and reporting platforms
• Experience with RedGate SQL Toolbelt and SQL Clone or other equivalent query & database admin tools
• Experience with Amazon Web Services
• Experience with DevOps practices, like version control systems (e.g., Git) for code deployment in a CI/CD pipeline
• Experience with MDM solutions, Melissa Data address standardization, D&B enrichment, or other data quality, match, merge, & enrich tools
• Experience with other RDBMS, warehouse, or lakehouse database patterns or platforms such as Oracle, RedShift, No SQL etc.

Benefits

• Comprehensive benefits package including medical, dental, and vision insurance
• 401(k) retirement plan
• Paid time off
• Paid holidays
• Life and disability insurance

Pay

$130,000.00 to $145,000.00 Annually

Schedule

Flexible work schedules

Location

Remote work opportunities