What are the responsibilities and job description for the Microsoft SQL Database Administrator - Kansas City, MO position at Pivotal Solutions Inc?
Job Details
Microsoft SQL Database Administrator
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.
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.
