Enterprise Technology Database Administrator
Paylocity
West Columbia, SC, United States
2 days ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on recruiting.paylocity.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Working hours
Regular working hours
Job source
Tech stack
Adaptable Database Systems
Application Programming Interfaces (APIs)
Microsoft Azure
Databases
Computer Engineering
Data Integration
Data Retrieval
Database Design
Database Servers
Linux
Disaster Recovery
Microsoft Visual Studio
+17 more
Microsoft SQL Server
NoSQL
Oracle (Applications)
Windows PowerShell
Server Administration
SQL Stored Procedures
SQL Databases
SQL Server Reporting Services
SQL Server Integration Services
Enterprise Software Applications
Database Performance
Backend
Sentry
Performance Monitor
Redgate
Database Backup
Software Version Control
Job description
NOTE: The primary accountabilities below are intended to describe the general content of and requirements of this position and are not intended to be an exhaustive statement of duties. Incumbents may perform all or most of the primary accountabilities listed below. Specific tasks or responsibilities will be documented in the incumbentβs performance objectives as outlined by the incumbentβs immediate supervisor or manager.
- Database design, construction, & implementation
- Collaborative design & development with programmers and business analysts
- Collaborate with programmers and business analysts to design, develop, and optimize database-driven applications, including writing stored procedures, functions, and scripts; supporting backend development efforts; and ensuring efficient data integration across systems.β
- Contribute to full stack development initiatives by integrating databases with front-end applications, optimizing API interactions, and supporting the development of user-centric features that rely on efficient data retrieval and storage.
- Capacity planning, monitoring, and upgrade implementation
- Performance monitoring & tuning
- Identify and evaluate industry trends in new database related systems and technologies (e.g. Azure, SQL on Linux, NoSQL and PowerShell)
- Review project requests describing database user needs to estimate time, cost and infrastructure required to successfully deliver the database requests
- Research, architect and implement database technologies designs using industry best practices
- Optimize database resources for optimum
- configuration, database performance and cost
- Ensure that Nephronβs SQL Server standards are communicated and enforced
- Ensure architectural, quality, and governance adherence through design reviews
- Problem analysis, diagnosis, and implementation of resolutions
- Provide 24x7 system database administration support
- Be able to adopt to a fast-paced changing environment
Job Specifications and Qualifications:
Knowledge & Skills:
- Hands-on experience with Code Management process
- Strong organizational and time management skills.
- Maintain several database environments; applies updates, maintenance packs, patches, & fixes for all environments.
- Prepare implementation plans for application upgrades and may coordinate rollout.
- Design database reporting infrastructure.
- Monitor server performance and makes changes as needed. May design performance monitoring systems.
- Work closely with developers, support, and QA teams to design and optimize all DB environments.
- Prepare scripts to automate administration tasks.
- Perform advanced database administration activities including: installation, configuration, monitoring, space management, database backup and recovery, and may design disaster recovery procedures.
- Perform installation, configurations, and maintenance for clustered database servers.
- Plan and perform database server upgrade and determines standards for server configuration.
- Perform database reviews and provides input to database design.
- Write and review stored procedures and makes recommendations for optimization.
- May assist less experienced peers.
- Ability to lead team projects
- Leadership & Execution: Able to lead people, projects, and tasks effectively-balancing big-picture thinking with tactical execution.
- Customer Focused: Action-oriented with a strong sense of urgency to support internal and external customers.
- Team Motivation: Naturally encourages others and fosters a mindset of continuous improvement.
- Prioritization & Delegation: Can multitask, identify critical priorities, and delegate with clarity and purpose.
- Communication Savvy: Intuitive about what to say, when to say it, and who needs to hear it.
- Relationship-Driven: Interpersonally adept while staying focused on the work at hand.
- Technical Fluency: Technically capable without being a know-it-all-collaborative and open to learning.
- Self-Starter: Brings high initiative, a love of learning, and a commitment to seeing things through to resolution.
Requirements
- Bachelorsβ degree in Computer Science and Engineering or equivalent preferred
- Minimum 5 yearsβ relevant experience preferred
- MS SQL Server DBA certification preferred
- MS SQL Server experience on versions 2014 and later.
- Cross DB platform experience (e.g. Microsoft Azure SQL, Oracle)
- SQL Sentry, Azure DevOps, Visual Studio, Redgate Utilities, SSIS, and SSRS experience.
Benefits & conditions
- This position requires bending, typing, lifting (up to 40 1bs.), standing, sitting and walking throughout the facility.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Apply on recruiting.paylocity.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦