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.
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.
- 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.
- Participate in agile team development projects.
Skills Required
- Bachelor's degree in a computer-related field and two to five years 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 analytical reasoning and logical problem solving skills.
- Hands-on experience with SQL Server design, build, configuration, administration, and troubleshooting.
- Hands-on development and scripting experience in T-SQL, PowerShell, C#, SSIS, and SSRS.
- 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 advance organizational readiness and capabilities.
What We Do
Pivotal Solutions is a national staffing and consulting firm founded in 2002 that specializes in matching job seekers and companies for roles in IT & Technology and Accounting & Finance. They offer a variety of staffing solutions, including Direct Hire and Contract-to-Hire placements, serving a diverse client base that ranges from innovative startups to Fortune 500 companies across the United States.
