Idaho State Job Bank
Sr. Database Administrator/ Developer
Idaho State Job Bank, Boise, Idaho, United States, 83708
Sr. Database Administrator/ Developer at Cognizant in Boise, Idaho, United States Job Description We are seeking a highly experienced and technically proficient Senior SQL DBA / Developer to join our cloud engineering team. This role is pivotal in managing and optimizing SQL Server workloads across virtual machines (IaaS) and cloud-native services (PaaS) such as Azure SQL Database, Azure SQL Managed Instance, and AWS RDS for SQL Server. The ideal candidate will bring deep expertise in SQL Server administration, performance tuning, automation, and cloud infrastructure, along with a strategic mindset for cost optimization and scalability. In this role, you will Cloud-Based SQL Server Management (IaaS & PaaS) + Provision and configure SQL Server instances on Azure/AWS VMs (Windows/Linux). + Deploy and manage cloud-native databases using Azure Portal, CLI, ARM templates, or AWS CloudFormation. + Configure storage, networking, backup settings, and performance tiers (DTUs, vCores). + Apply platform-native security policies, maintenance windows, and scaling options. Monitoring & Performance Tuning + Monitor SQL Server performance using native tools (SQL Profiler, Extended Events, Performance Monitor) and cloud services (Azure Monitor, Log Analytics, AWS CloudWatch). + Tune queries, indexes, and system configurations (e.g., NUMA, disk alignment) for optimal performance. + Conduct proactive performance analysis and implement recommendations. Backup & Disaster Recovery + Design and automate backup strategies using SQL Server Agent, Ola Hallengren scripts, or third-party tools. + Implement disaster recovery solutions including Always On Availability Groups, Log Shipping, and Replication. + Configure geo-redundant backups, failover groups (Azure), and Multi-AZ deployments (AWS). High Availability & Scalability + Set up and manage traditional HA solutions (Failover Cluster Instances, AGs). + Configure auto-failover groups, active geo-replication, and zone-redundant deployments. + Scale databases up/down or out using platform-native options with minimal downtime. Security & Compliance + Implement RBAC, Azure AD/AWS IAM integration, and data encryption (TDE, Always Encrypted). + Set up auditing, threat detection, and vulnerability assessments. + Ensure compliance with standards such as HIPAA, SOC 2, and GDPR using platform tools. + Preferred knowledge of Thales encryption products. Strategic & Leadership Responsibilities + Evaluate and recommend IaaS vs. PaaS solutions based on workload requirements. + Opt To view full details and how to apply, please login or create a Job Seeker account