Database Administrator/Developer (DBA)

Pivotal Solutions - Daytona Beach, FL

Full-time

Daytona Beach, FL

Professional, Scientific, and Technical Services

About the position

The Database Administrator/Developer (DBA) at Pivotal Solutions, Inc. is responsible for maintaining and supporting the company's SQL Server database environment, which includes over 100 virtualized instances. This role involves collaborating with the development team on database-related software development tasks and ensuring the performance, security, and reliability of the database systems.

Responsibilities

• Install and configure Microsoft SQL Server database instances.
• Maintain, monitor, and patch existing SQL Server database instances.
• Add, modify, and audit system/user permissions to databases or servers, maintaining appropriate system security levels.
• Maintain, monitor, and audit database backups and jobs.
• Upgrade and migrate legacy SQL versions.
• Perform application capacity planning, set up, performance tuning, and monitoring.
• Work with the infrastructure team for cluster resource planning and participate in purchasing decisions.
• Detect and troubleshoot database slowness, resource contention, locking, and blocking.
• Provide continuous planned uptime and participate in rotating on-call duties, disaster recovery planning, and implementation.
• Assist with SQL database build and task automation.
• Develop new and maintain existing in-house developed queries, views, stored procedures, reports, and ETLs.
• Participate in agile team development projects.

Requirements

• Bachelor's Degree in a computer-related field.
• Two to five years of SQL and/or programming experience or equivalent combination of education and experience.
• Ability to analyze and translate user requirements into specifications and prepare detailed design/implementation documentation.
• Demonstrated ability in analytical reasoning and logical problem solving.
• Hands-on knowledge and experience of SQL Server design, build, configuration, administration, and troubleshooting.
• Hands-on knowledge and experience in development and scripting in T-SQL, PowerShell, C#, SSIS, and SSRS.

Nice-to-haves

• Knowledge of Microsoft Server + CAL and Core licensing models and editions.
• Knowledge and experience in DevOps practices, CI/CD, and Agile.
• Knowledge and experience in advanced SQL Server features and architectures including Cloud, AlwaysOn, and containerization.
• Ability to advocate for appropriate technology solutions and to continually advance the organization's readiness and capabilities.