SQL Database Administrator/Developer- Remote
SQL Database Administrator/Developer- Remote Please note, this role is not able to offer visa transfer or sponsorship now or in the future* Location: Remote Experience: 6-8+ years Required Skills: Skills: Database Development, PowerShell expertise, AlwaysOn, PostgreSQL DBA, RBAC, Azure Active Directory Responsibilities: Deployment & Configuration Provision SQL Server on Azure/AWS VMs (Windows/Linux). · Configure storage, networking, and backup settings. · Tune operating system settings (e.g., disk alignment, NUMA config) for SQL Server performance. · Provision and configure cloud-native databases using portal, CLI, or templates. · Set performance tiers (DTUs, vCores) and scaling options. · Apply security policies and maintenance windows via platform features. Administer and support SQL Server workloads across Azure/AWS IaaS (VMs) and PaaS (Azure SQL, Managed Instances, AWS RDS). · Preferred to have Knowledge in Attunity and Delphix tools. Monitoring & Performance Tuning IaaS: · Use native tools (SQL Profiler, Extended Events, Performance Monitor) or third-party solutions. · Monitor OS-level performance (CPU, memory, disk I/O) in addition to SQL metrics. · Use built-in tools like Query Performance Insight, Azure Monitor, Log Analytics, or AWS CloudWatch. · Tune queries, manage index usage, and review performance recommendations. · Proactively monitor performance using both native tools and cloud services, identifying and resolving bottlenecks. Backup & Disaster Recovery · Design and automate backup strategies using SQL Server Agent, Ola Hallengren scripts, or third-party tools. · Implement DR using Always On Availability Groups, Log Shipping, or Replication. · Leverage built-in backup capabilities (automated backups, point-in-time restore). · Configure geo-redundant backups and failover groups (Azure) or Multi-AZ deployments (AWS). High Availability and Scalability · Configure traditional HA solutions (AGs, Failover Cluster Instances). · Monitor and manage VM failover policies and availability sets/zones. · Set up Active Geo-Replication, Auto-failover groups, or zone-redundant configuration. · Scale up/down or scale out using platform-native options without downtime. · Implement and manage high availability, disaster recovery, and automated backup strategies in both on-prem and cloud-hosted databases. Security and Compliance · Implement RBAC, Azure Active Directory/AWS IAM integration. · Configure data encryption (TDE, Always Encrypted). · Set up auditing, threat detection, and vulnerability assessments. · Maintain compliance with policies such as HIPAA, SOC 2, GDPR using platform tools. · Design and enforce database security policies, including identity integration (AAD/IAM), encryption, and auditing. · Preferred to know about Thales’s products. Strategic & Leadership Responsibilities · Choose between IaaS and PaaS based on workload requirements. · Optimize licensing (e.g., bring-your-own-license for IaaS). · Monitor and control costs (reserved instances, performance tier selection, automation to pause/scale databases). · Automate deployments using ARM templates, Terraform, or Bicep (Azure) or CloudFormation (AWS). · Implement CI/CD pipelines for database code (Azure DevOps, GitHub Actions). · Use PowerShell, Azure CLI, dbatools, or SQLCMD for repeatable automation. · Work closely with cloud architects, network engineers, and development teams. · Act as SME for SQL Server in cloud planning meetings. · Mentor junior staff and enforce SQL standards across environments. · Act as technical lead in migrations from on-prem to cloud or IaaS to PaaS transitions. · Provide subject matter expertise on cloud cost management, scaling strategies, and service tier optimization. · Collaborate with DevOps teams to automate deployments and manage infrastructure as code. · Scripting Knowledge in different languages Salary and Other Compensation: Applications will be accepted until 09/25/2025 The annual salary for this position is between $79,000– $92,500 depending on experience and other qualifications of the successful candidate. This position is also eligible for Cognizant’s discretionary annual incentive program and stock awards, based on performance and is subject to the terms of Cognizant’s applicable plans. Benefits: Cognizant offers the following benefits for this position, subject to applicable eligibility requirements: · Medical/Dental/Vision/Life Insurance · Paid holidays plus Paid Time Off · 401(k) plan and contributions · Long-term/Short-term Disability · Paid Parental Leave · Employee Stock Purchase Plan Disclaimer: The salary, other compensation, and benefits information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law. #CB #IND123 Apply tot his job