What are the responsibilities and job description for the Database Administrator position at Advantage Tech?
Advantage Tech is searching for an Database Administrator to join their client's team in Kansas City, MO.
Job Summary:
We are seeking an experienced Microsoft Database Administrator (DBA) to join our team. The ideal candidate will have over 7 years of experience in managing, optimizing, and securing Microsoft SQL Server databases. This role requires a deep understanding of database architecture, performance tuning, disaster recovery, and automation. The DBA will collaborate with developers, system administrators, and business analysts to ensure the availability, reliability, and security of enterprise database systems.
Key Responsibilities:
- Install, configure, and maintain Microsoft SQL Server (2016, 2019, and later versions) in on-premise and cloud environments.
- Monitor and optimize database performance, tuning queries, indexes, and execution plans.
- Implement backup, recovery, and disaster recovery strategies to ensure business continuity.
- Manage and optimize database security, user access, and role-based permissions.
- Design and implement high-availability solutions such as clustering, mirroring, and replication.
- Develop and maintain T-SQL scripts, stored procedures, functions, and triggers to support application requirements.
- Automate administrative tasks using PowerShell, SQL Server Agent, or other scripting tools.
- Conduct database patching, updates, and migrations to ensure compliance with security and industry standards.
- Troubleshoot and resolve database performance issues, locks, deadlocks, and connectivity problems.
- Work closely with developers and system engineers to optimize database-driven applications.
- Implement and maintain data integrity, indexing strategies, and normalization techniques.
- Stay up-to-date with industry best practices and emerging technologies in SQL Server administration and cloud database solutions.
Required Qualifications:
- 7 years of hands-on experience with Microsoft SQL Server (2016, 2019, and newer).
- Strong expertise in database performance tuning, indexing, and query optimization.
- Experience with backup and disaster recovery strategies, including Always On Availability Groups.
- Knowledge of cloud-based SQL solutions (Azure SQL Database, AWS RDS for SQL Server, etc.).
- Proficiency in T-SQL development including writing and debugging stored procedures, views, and triggers.
- Hands-on experience with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
- Experience with PowerShell scripting and SQL Server automation.
- Familiarity with data security best practices, encryption, and compliance standards (GDPR, HIPAA, SOX, etc.).
- Understanding of NoSQL, Big Data, or other emerging database technologies is a plus.
- Strong problem-solving and analytical skills with the ability to troubleshoot complex database issues.
- Excellent communication and collaboration skills.
Preferred Qualifications:
- Microsoft certifications such as MCSA: SQL Server, MCSE: Data Management and Analytics, or Azure Database Administrator Associate.
- Experience working with DevOps methodologies and CI/CD pipelines for database deployments.
- Knowledge of other database systems such as Oracle, MySQL, or PostgreSQL is a plus.
- Experience with AI-driven database optimization and monitoring tools.
