At a Glance
- Tasks: Support and maintain SQL databases while mentoring Child Care developers.
- Company: Join a dynamic team focused on child care initiatives in South Carolina.
- Benefits: Hybrid work model, competitive pay, and opportunities for professional growth.
- Other info: Flexible, collaborative environment with potential for contract extension.
- Why this job: Make a real difference in child care through your database expertise.
- Qualifications: 6+ years of database administration experience and strong SQL skills.
The predicted salary is between 36000 - 60000 £ per year.
Work Location: Role is hybrid (3 days onsite per week). Candidate must be a CURRENT SC resident. No relocation allowed.
Duration of the Contract: 12 Months. Possibility for Extension: Yes.
Interview Process: 1 round, virtual (video required).
Job Description Scope of the Project: This request is for a senior-level database administrator to provide senior-level support and guidance to our Child Care team for several initiatives; assist with the support, maintenance, security, and availability of our SQL environment.
Daily Duties / Responsibilities:
- Provide senior-level support and guidance to our Child Care team, including mentoring Child Care developers on schema and query design, execution-plan review/tuning, and security best practices.
- Assist with the support, maintenance, security, and availability of the agency’s SQL Server environment for other application teams, while prioritising Child Care commitments.
- Design, develop, implement, and maintain database procedures and functions that accommodate changing business priorities and technological changes while ensuring availability, scalability, performance, recoverability, reliability, and security.
- Act as liaison for SQL Server database performance, integration, migration, upgrade, storage, and replication strategies.
- Perform SQL Server performance tuning: waits/Query Store analysis, index & stats optimisation, SARGability fixes, and parallelism tuning.
- Monitor the database systems to ensure secure services with minimum downtime; configure alerts and telemetry for proactive detection.
- Interact with project management and Agile development teams to develop a strong understanding of project and database development objectives.
- Participate in troubleshooting and triaging of issues with different team members to drive towards root cause identification and resolution.
- Document, track and escalate issues as appropriate.
- Participate in Scrum teams in support of Agile projects; end-to-end support for build, deployment, and operational activities.
- Exercise considerable latitude, discretion, and independent judgment in determining technical objectives of assignments.
- Perform routine operations and maintenance including installations, upgrades, patching, monitoring, auditing, and issue resolution.
- Manage and prioritise multiple, diverse tasks simultaneously.
- Must be flexible, independent and self-motivated.
- Work collaboratively to meet team goals/mission.
- Provide after-hours or weekend maintenance as needed.
- Perform other duties as assigned.
Required Qualifications:
- Database Administration: Expert (6+ Years)
- Backup/Recovery: Expert (6+ Years)
- Performance Tuning: Expert (6+ Years)
- RDBMS: Expert (6+ Years)
- SQL Server: Expert (6+ Years)
- T-SQL: Expert (6+ Years)
- Failover Clusters: Expert (2-4 Years)
- High-Availability: Expert (2-4 Years)
- DMVs: Expert (2-4 Years)
- SSIS Services: Expert (2-4 Years)
- SSRS: Expert (2-4 Years)
- Profiler: Expert (2-4 Years)
- SQL Tuning: Expert (2-4 Years)
- Database planning, scaling, and capacity planning: Expert (2-4 Years)
- SQL Server 2008R2: Expert (1-2 Years)
- SQL Server 2012: Expert (1-2 Years)
- SQL Server 2014: Expert (1-2 Years)
- SQL Server 2016: Expert (1-2 Years)
- ETL: Advanced (2-4 Years)
- SSAS: Advanced (2-4 Years)
- Verbal Communication: Intermediate (2-4 Years)
- Written Communication: Intermediate (2-4 Years)
- PowerShell: Intermediate (1-2 Years)
- RedGate Toolset: Intermediate (1-2 Years)
- SDLC: Intermediate (1-2 Years)
Required Education: Bachelor’s Degree.
Seniority level: Mid-Senior level.
Employment type: Contract.
Job function: Information Technology Software Development.
DBA - Database Administrator - Local to SC in Elgin employer: Jobs via Dice
As a leading employer in South Carolina, we pride ourselves on fostering a collaborative and innovative work culture that empowers our employees to excel. Our hybrid work model allows for flexibility while providing ample opportunities for professional growth, particularly for those in the IT sector, with a focus on mentoring and skill development within our Child Care team. Join us to be part of a mission-driven organisation that values your expertise and offers a supportive environment for meaningful contributions.
StudySmarter Expert Advice🤫
We think this is how you could land DBA - Database Administrator - Local to SC in Elgin
✨Tip Number 1
Get your networking game on! Reach out to folks in the industry, especially those who work with SQL and database management. A friendly chat can lead to insider info about job openings or even a referral.
✨Tip Number 2
Prepare for that virtual interview like it’s the final boss level! Make sure you know your stuff about SQL Server and be ready to discuss your past experiences. Practise common interview questions and have examples ready to showcase your skills.
✨Tip Number 3
Don’t forget to follow up after your interview! A quick thank-you email can keep you fresh in their minds and show your enthusiasm for the role. Plus, it’s a great chance to reiterate why you’re the perfect fit for the DBA position.
✨Tip Number 4
Apply through our website for the best chance at landing that DBA gig! We’re always looking for talented individuals, and applying directly can help us see your application faster. Don’t miss out!
We think you need these skills to ace DBA - Database Administrator - Local to SC in Elgin
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the DBA role. Highlight your experience with SQL Server, performance tuning, and any relevant projects you've worked on. We want to see how your skills match what we're looking for!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're passionate about database administration and how you can contribute to our Child Care team. Keep it concise but impactful!
Showcase Your Technical Skills:Don’t forget to list your technical skills clearly. Mention your expertise in T-SQL, backup/recovery, and any other relevant tools or technologies. We love seeing candidates who are confident in their abilities!
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way to ensure your application gets seen by the right people. Plus, it makes the process smoother for both of us!
How to prepare for a job interview at Jobs via Dice
✨Know Your SQL Inside Out
As a DBA, you'll need to showcase your expertise in SQL Server. Brush up on performance tuning, backup/recovery strategies, and the latest features of SQL Server 2016. Be ready to discuss specific scenarios where you've optimised queries or resolved complex database issues.
✨Demonstrate Your Mentoring Skills
Since this role involves mentoring Child Care developers, prepare examples of how you've guided others in schema design or query optimisation. Highlight your ability to communicate complex concepts clearly and effectively, as this will be key in your interactions with the team.
✨Showcase Your Problem-Solving Abilities
Expect questions that assess your troubleshooting skills. Prepare to discuss past experiences where you identified root causes of database issues and how you resolved them. Use the STAR method (Situation, Task, Action, Result) to structure your answers.
✨Familiarise Yourself with Agile Practices
This position requires collaboration with Agile teams, so understanding Agile methodologies is crucial. Be prepared to discuss your experience working in Scrum teams and how you’ve contributed to projects in an Agile environment. This will show your adaptability and teamwork skills.
