Job Description

Your Role:

As a database administrator, you will be a key member of a high-performance team responsible for maintaining and optimizing enterprise-level databases. You'll collaborate with senior leaders, architects, developers and end users to ensure our systems operate efficiently and securely. Your expertise in database design, performance tuning and administration will support our suite of software solutions, ensuring reliability and scalability across the organization. You'll also help set and enforce standards, mentor team members and drive excellence in data management practices.

Key Responsibilities:

Database management:

Design, maintain and administer databases supporting enterprise software solutions

Performance tuning

: Monitor and optimize database performance, including query tuning, indexing and system diagnostics

Code review:

Evaluate stored procedures, triggers, UDFs and scripts to ensure quality, consistency and adherence to standards

Collaboration:

Partner with the architecture and IT teams to maintain enterprise data models and resolve technical issues

Data integrity:

Implement error handling strategies and ensure data consistency across systems

Process improvement:

Develop and enforce database naming conventions and coding standards

Troubleshooting:

Diagnose and resolve database issues related to performance, access levels and persistence

Mentorship:

Support and mentor associate database administrators, fostering their growth and development

Reporting and analysis:

Provide data insights and create tools to empower end users with self-service reporting capabilities

Continuous learning:

Stay current with evolving database technologies and recommend upgrades and improvements

What You'll Bring:

Technical expertise:

Advanced skills in Microsoft SQL Server (2012-2022), both on-prem and Azure environments

Performance optimization:

Deep knowledge of server tuning, indexing and monitoring using tools such as SQL Sentry and Redgate

System architecture:

Experience with clustered and high-availability solutions, distributed data and replication strategies

Automation skills:

Proficiency in PowerShell scripting to automate and streamline processes

Analytical mindset:

Strong problem-solving abilities with attention to detail and a proactive approach

Team collaboration:

Excellent communication skills and ability to work closely with diverse teams

Qualifications:

Education:

College degree, technical certification or equivalent industry experience

Experience:

More than seven years of SQL Server administration in transactional or data warehouse environments

Technical skills:

Expertise in T-SQL, SSIS, SSAS, SSRS, SQL Profiler, and Management Studio

Preferred experience:

Exposure to Azure SQL PaaS, Cosmos DB, versioning and automated database deployments

Soft skills:

Strong communication, organizational and mentoring capabilities
Benefits:

401(k) Dental insurance Health insurance Paid time off Referral program Vision insurance
Work Location: In person