Senior/Staff DBA - SQL Server & Cassandra

TEKsystems
$45.00 - $55.00 / hr
United States, Georgia, Atlanta
Nov 07, 2024
Top Skills' Details *1.) Strong expertise in SQL Server database administration (backup and recovery, performance tuning, security, monitoring). 2.)Hands-on experience with Cassandra in production environments, including configuration, scaling, and performance tuning. 3.) Knowledge of Oracle and Postgres is a plus. Description:* We are seeking an experienced and proactive Staff Database Administrator (DBA) to join our team in supporting our Supply Chain Management (SCM) systems. This role will focus on administering, optimizing, and troubleshooting SQL Server and Cassandra databases in mission-critical environments. Experience with Oracle and Postgres is a plus but not required. The ideal candidate will have strong experience in database administration for large-scale, high-availability environments and a passion for optimizing systems to meet the demands of our fast-paced supply chain operations. Responsibilities: Database Administration: Oversee the installation, configuration, patching, and upgrading of SQL Server and Cassandra database systems. Performance Optimization: Analyze, monitor, and optimize database performance to ensure high availability and rapid response times, particularly in high-transactional environments. Capacity Planning and Scaling: Design and implement scaling solutions for database clusters to support growth and performance demands. Data Security & Compliance: Ensure data integrity, security, and compliance with relevant standards and regulations. Implement backup, recovery, and disaster recovery (DR) strategies. Automation & Scripting: Develop scripts and automation tools to streamline database maintenance tasks, monitoring, and performance tuning. Cross-functional Collaboration: Work closely with application developers, network engineers, and system administrators to resolve issues and implement improvements. Documentation and Best Practices: Develop and maintain documentation for database configurations, processes, and procedures. Provide technical guidance and training to team members as needed. On-call Support: Participate in on-call rotation to ensure 24/7 support for critical database environments. Additional Skills & Qualifications: Education: Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience). Experience: Minimum of 5-7 years of experience in database administration, with a focus on SQL Server and Cassandra. Technical Skills: Required: - Strong expertise in SQL Server database administration (backup and recovery, performance tuning, security, monitoring). - Hands-on experience with Cassandra in production environments, including configuration, scaling, and performance tuning. Optional: Knowledge of Oracle and Postgres is a plus. Problem-Solving Skills: Demonstrated ability to troubleshoot complex issues in high-availability, high-transactional systems. Automation Skills: Proficiency in scripting languages (e.g., PowerShell, Python, Bash) to automate administrative tasks and support DevOps initiatives. Communication: Strong verbal and written communication skills to collaborate effectively across teams. Preferred Qualifications Certifications: Relevant database certifications (e.g., Microsoft SQL Server, Cassandra, or Oracle) are desirable. Supply Chain Experience: Prior experience supporting database systems for SCM, warehousing, or logistics applications. Experience Level: Expert Level 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.