What are the responsibilities and job description for the Database Administrator/Developer (DBA) position at Pivotal Solutions Inc?
Job Description
Under the direction of the Automation and Development Manager and the Sr. DBA Dev, the DBA Dev II maintains and supports all aspects of company's SQL Server database environment. The environment consists of 100 on premise virtualized, Microsoft SQL Server instances powering several hundred in-house and third-party enterprise applications. The incumbent will also assist the development team with database level software development tasks.
Job Qualifications
Bachelor's Degree in computer-related field and two to five years SQL and or programming experience or equivalent combination of education and experience.
Evidence of 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 a variety of programming languages, including T-SQL, PowerShell, C#, SSIS, SSRS.
Preferred :
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.
Job Duties and Responsibilities
Install and configure Microsoft SQL Server database instances.
Maintain, monitor, and patch existing SQL Server database instances.
Add, modify, and audit system / user permission to databases or servers, maintain appropriate system security levels and continually improve enterprise threat posture.
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 infrastructure team for cluster resource planning, participate in purchasing decisions, testing and presales due diligence.
Detect and troubleshoot database slowness, resource contention, locking and blocking.
Provide continuous planned uptime and participate in rotating on-call duties, DR 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.
Keep a pulse on the job market with advanced job matching technology.
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution.
Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right.
Surveys & Data Sets
What is the career path for a Database Administrator/Developer (DBA)?
Sign up to receive alerts about other jobs on the Database Administrator/Developer (DBA) career path by checking the boxes next to the positions that interest you.
Not the job you're looking for? Here are some other Database Administrator/Developer (DBA) jobs in the Daytona Beach, FL area that may be a better fit.
We don't have any other Database Administrator/Developer (DBA) jobs in the Daytona Beach, FL area right now.
