New

Database Administrator

TEKsystems
$45.00 - $48.00 / hr
life insurance, sick time, 401(k), retirement plan
United States, Tennessee, Knoxville
May 08, 2025
Description Our client in the higher education space is currently looking for a SQL database admin with AWS experience. They have one database that is running in RDS. It is a SQL server database that uses the EAD model. They are going to need someone that can take and ether convert that to a nice relational database or extract it into a data warehouse where we can get our reporting from and make our reporting easier than the way it's being stored right now. They won't be doing reports, but will be working with someone who's designing the actual reports. Success in this role will ensure that the database is running well and helping them redesign or add design features that we need. They will need to work with a reporting designer to extract data that way, and they need to know how to do a data warehouse extraction from the database itself. This DBA will be assigned to the largest grant funded project on the team and that team is in early discussions of migrating this application to AWS. First week, they will immediately start participating in the knowledge transfer sessions with the other team members that will be working on this project. From there they would be mapping out ideas on changing up the database setup. One of their first tasks will be figuring out how to make the data more accessible to reporting so that is easier for people who are not database gurus and do not necessarily understand this data model. Required skills: Database Architecture and Design * Design scalable, normalized, and high-performance database systems. Advanced Performance Tuning and Optimization Advanced index tuning, partitioning strategies, tempdb optimization. Cloud Data Platforms Expertise * AWS RDS (Required) * Security and Access Control:- Managing roles/policies for RDS access, Controlling RDS network access, Configuring firewall rules. * High Availability & Replication:- Understanding replication lag and monitoring. * Performance Monitoring and Tuning:- Amazon CloudWatch, Enhanced Monitoring and Performance Insights, Query optimization and use of slow query logs. * Cost Management:- Cost implications of storage types, IOPS, instance sizes, backups, and snapshots, Using Reserved Instances or Savings Plans for cost optimization, Monitoring with AWS Budgets and Cost Explorer. * Migration strategies: Lift-and-Shift, Re-platforming, Cloud-native deployments. Automation, Scripting, and Infrastructure as Code (IaC) * CI/CD pipelines for databases (e.g GitHub Actions). Security and Compliance at Scale Backup and Restore Strategies Capacity Planning and Forecasting * Analyze growth trends, IO patterns, and forecast storage and compute needs over months/years. Disaster Simulation and Documentation * Create thorough documentation and recovery playbooks for junior DBAs and DevOps. Leadership, Mentorship, and Cross-Functional Collaboration * Lead database team initiatives. * Partner closely with application architects, developers, infrastructure, and cybersecurity teams. * Mentor junior DBAs and build best practices. Nice to have Azure SQL Managed Instance This position is contract to hire and 100% remote. W2 only. Not open to C2C. Pay and Benefits The pay range for this position is $45.00 - $48.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 fully remote position. Application Deadline This position is anticipated to close on May 21, 2025. 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.