Sr SQL DBA

Overview

On Site
USD 50.00 - 65.00 per hour
Full Time

Skills

SQL
Data Architecture
Project Development
Servers
Scalability
Caching
Database Design
Microsoft SQL Server DBA
Query Optimization
Performance Metrics
Business Plans
Status Reports
Finance
Communication
PDCA
Presentations
Disaster Recovery
SAP BASIS
Backup Administration
Policies and Procedures
Documentation
Regulatory Compliance
Data Security
Database Administration
Budget
Backup
Recovery
High Availability
Database Mirroring
Clustering
Data Modeling
Amazon Web Services
Information Systems
Computer Science
Software Engineering
Information Technology
Database
Cloud Computing
Virtualization
IaaS
Sarbanes-Oxley
Data Analysis
Management
Microsoft SQL Server
Microsoft Windows
Active Directory
Application Support
IT Infrastructure
Privacy
Project Management
Taxes
Life Insurance
Collaboration
Partnership
Business Transformation
Law

Job Details

Description
The SQL Server DBA provides a technical role in maintaining the operational stability and security of AHM's SQL Server database environment, in a cost effective manner. Additional responsibilities include providing DBA resources for database development projects, funded by the application teams/business, act as liaison between the SQL Server database team and application teams, he/she ensures that all project deliverables by the DBA team are completed within schedule and budget. The SQL Server DBA also works closely with Data Architecture team in understanding project requirements leading to the design, build and implementation of SQL Server databases.
Daily Tasks Performed:
Project Development Support:
o Meet with application teams to understand requirements and recommend high-level direction and approach to upcoming projects.
o Install and configure SQL Server instances on servers, ensuring proper settings and options are chosen based on the organization's requirements.
o Fine-tuning database systems to enhance performance, scalability, and reliability. This includes monitoring and optimizing database query performance, indexing, and database caching.
o Collaborate with developers and stakeholders to design and implement database schemas, tables, indexes, and relationships.
o Attend ARB meetings to understand the new project requirements, as related to database design, build and implementation of SQL Server database applications.
o Manage other SQL Server DBA resources that ensures that their availability is aligned with project schedules (supply vs demand).
o Ensure that all DBA deliverables
Tuning, Monitoring and Patching:
o Monitor database performance using built-in tools and third-party solutions. Identify and resolve performance bottlenecks through query optimization, index tuning, and configuration adjustments.
o Configure and utilize monitoring tools to track database health, performance metrics, and security events. Set up alerts to notify administrators of potential issues.
Inter/Intra Organizational Communication:
o Must understand and implement organizational policies and procedures related to the administration of the SQL Server database environment.
o Conduct regularly scheduled meetings with team manager to understand Business Plans and Organization QCD metrics.
o Provide Status reports to team manager; Budget/finance status, project status, etc.
o Build and maintain good relations with other teams by fostering open communication between the application and database teams.
o Track job/process failures (sev-1/2) and conduct appropriate PDCA associated to all failures and 4-Block analysis, documentation and presentation.
o Track portfolio growth, including; space management, database counts, application counts, etc.
Backup and Recovery and DR:
o Develop and implement backup and recovery strategies to safeguard data against loss or corruption. Regularly test backup and recovery procedures.
o Implement high availability solutions such as database mirroring, clustering, or AlwaysOn Availability Groups.
o Develop and test disaster recovery plans.
Security and Compliance of the SQL Server database environment:
o Conduct Periodic Access Reviews on a monthly basis.
o Follow and enforce defined database access policies.
o Maintain daily backup metrics, ensuring all SOX database backups are monitored according to policies and procedures.
o Develop and maintain SOX documentation; security access, backup procedures and target 'ZERO' SOX deficiencies.
o Participate in the implementation of PII initiatives, as defined by Ent. Architecture and application teams.
o Implementing and maintaining security measures to protect sensitive data and ensure compliance with regulatory requirements, such as General Data Protection Regulation (GDPR).
What will this person be working on:
Ensure that all DBA deliverables to the projects, are performed within project schedule and budget.
Develop and implement backup and recovery strategies to safeguard data against loss or corruption. Regularly test backup and recovery procedures
Develop and implement backup and recovery strategies to safeguard data against loss or corruption. Regularly test backup and recovery procedures.
Implement high availability solutions such as database mirroring, clustering, or AlwaysOn Availability Groups.
Skills
Database administrator, Sql server, data modeling, aws
Top Skills Details
Database administrator,Sql server
Additional Skills & Qualifications
Position Success Criteria (Desired) - 'WANTS'
Bachelor's or Master's degree in Information Systems (IS), Computer Science, software engineering, information technology and/or equivalent industry experience.
5-8 years of Microsoft SQL Server Database Administrator experience
2-4 years of experience in working large scale projects.
Should have knowledge of cloud computing concepts, virtualization, and infrastructure-as-a-service (IaaS) platforms.
1-2 YEARS OF EXPERIENCE IN SOX RELATED REQUESTS.
Other Job-Specific Skills
Strong technical knowledge of SQL Server database administration, architecture/design, data analysis and management
Strong technical knowledge of current SQL Server database systems and versions, including other Windows based tools, utilities and active directory
Extensive application support experience working with application teams
High-level understanding of IT infrastructure planning and development.
Excellent understanding of the organization's goals and objectives.
In-depth knowledge of applicable data privacy practices and laws.
Good understanding of Project Management skills.
Pay and Benefits
The pay range for this position is $50.00 - $65.00/hr.
Eligibility requirements apply to some benefits and may depend on your job
classification and length of employment. Benefits are subject to change and may be
subject to specific elections, plan, or program terms. If eligible, the benefits
available for this temporary role may include the following:
Medical, dental & vision
Critical Illness, Accident, and Hospital
401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available
Life Insurance (Voluntary Life & AD&D for the employee and dependents)
Short and long-term disability
Health Spending Account (HSA)
Transportation benefits
Employee Assistance Program
Time Off/Leave (PTO, Vacation or Sick Leave)
Workplace Type
This is a hybrid position in Marysville,OH.
Application Deadline
This position is anticipated to close on Aug 10, 2025.
>About TEKsystems:
We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

About TEKsystems and TEKsystems Global Services

We're a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We're a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We're strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We're building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About TEKsystems c/o Allegis Group