Jr SQL DBA

$93,600 - $114,400/Yr

Vaco - Charlotte, NC

Full-time - Entry Level

Charlotte, NC

Administrative and Support Services

About the position

We are currently seeking a Jr. SQL Server Database Administrator responsible for managing and monitoring enterprise-level database systems. The ideal candidate will maintain current databases, deploy new ones, troubleshoot issues in production and non-production environments, and support both internal and external projects while aligning with team objectives.

Responsibilities

• Oversee database performance, ensuring optimal availability and functionality.
• Implement and oversee backup solutions to guarantee data recovery in case of failures or corruption.
• Assist with maintaining database security by managing user accounts, roles, and permissions.
• Identify and troubleshoot performance bottlenecks, applying performance tuning techniques to improve database efficiency.
• Support the deployment of new databases, updates, and modifications to existing systems.
• Keep thorough and organized documentation of database configurations, modifications, and procedures.
• Address and resolve database-related issues in a timely manner, working closely with IT staff and developers.
• Actively develop SQL Server knowledge by staying current with new features, industry best practices, and emerging database technologies.
• Work alongside other IT professionals, ensuring that databases are well-integrated and meet business requirements.

Requirements

• 2+ years of experience as a Microsoft SQL DBA.
• Proficiency with SQL Server in an Azure environment.
• Hands-on experience managing SQL Server performance and availability in a 24/7 environment.
• Experience setting up monitoring and alerting systems for SQL Server databases.
• Familiarity with MS SQL upgrades, patch management, and version control.
• Knowledge of security practices, including database/instance security, encryption, and managing service account permissions.
• Experience with high availability and disaster recovery solutions.
• Ability to provide strategic recommendations for SQL Server solutions.
• Understanding of application change management processes.
• Experience with SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).

Nice-to-haves

• Familiarity with Epicor Prophet 21 ERP system.
• Experience with Microsoft BI Development Suite.
• Knowledge of SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).
• Understanding of Master Data Management (MDM) and Data Governance.
• Experience with SQL Server Always-On High Availability.
• Familiarity with database clustering and mirroring.
• Ability to collaborate with contract teams, learning and standardizing their processes.