Remote Position
[Remote] AWS Infrastructure Engineer / Administrator with SQL DBA
π Remote Β· United States
πΌ Full-time
Note: The job is a remote job and is open to candidates in USA. Lorven Technologies Inc. is seeking an AWS Infrastructure Engineer / Administrator with SQL DBA responsibilities. The role manages AWS infrastructure, SQL Server databases, Windows and Linux systems, automation, monitoring, security, and production support.
Responsibilities
- Design, deploy, configure, administer, and support AWS infrastructure across production and non-production environments
- Manage AWS services including EC2, EKS, ECS, VPC, S3, EBS, RDS, ESX, EFS, IAM, KMS, Cloudwatch, cloudTrail, Systems Manager, Lambda, EventBridge, and Elastic Load Balancing. Administer VPCS, subnets, route tables, Security Groups, NACLS, ENIS, DNS, and network connectivity
- Manage EBS storage including volume provisioning, expansion, snapshots, encryption, IOPS, throughput, and performance optimization
- Administer Microsoft SQL Server databases running on AWS EC2 and Amazon RDS
- Perform database backup, restore, recovery, maintenance, patching, upgrades, and capacity management
- Monitor and troubleshoot SQL Server performance, database connections, blocking, locking, queries, storage, CPU, memory, IOPS, and throughput
- Support database high availability, disaster recovery, migration, replication, and recovery activities
- Administer Windows Server and Linux systems including provisioning, configuration, patching, upgrades, troubleshooting, and decommissioning
- Manage windows services, Task Scheduler, Event Viewer, local users/groups, permissions, Active Directory integration, RDP, WinRM, and firewall configurations. Troubleshoot Linux services, processes, storage, permissions, networking, and system logs
- Manage IAM roles, policies, instance profiles, service roles, trust relationships, cross-account access, and least-privilege permissions
- Manage encryption and security using AWS KMS across S3, EBS, RDS, ESX, and other AWS services
- Configure and maintain Cloudwatch dashboards, alarms, metrics, and logs for infrastructure and application monitoring
- Monitor server and database CPU, memory, disk utilization, IOPS, throughput, network utilization, connections, and storage capacity
- Use Cloudwatch, CloudTrail, operating-system logs, and database logs to troubleshoot infrastructure and production issues
- Develop and maintain automation using PowerShell, AWS CLI, Bash, Python and Terraform
- Utilize AWS Systems Manager for remote administration, automation, patch management, and server configuration
- Provision and maintain AWS infrastructure using Terraform and/or AWS CloudFormation
- Support CI/CD processes using Git, Jenkins, AWS CodePipeline, CodeBuild, and related deployment technologies
- Troubleshoot TCP/IP, DNS, routing, Security Groups, NACLS, load balancers, firewall rules, ports, and application-to-database connectivity. Provide L2/L3 production support for AWS infrastructure, windows/Linux servers, databases, storage, networking, and application dependencies
- Lead technical troubleshooting during production incidents and perform detailed root-cause analysis and corrective actions. Coordinate with application, database, network, security, DevOps, cloud, and vendor teams to resolve complex technical issues
- Manage infrastructure and database backups using AWS Backup, EBS snapshots, RDS snapshots, and SQL Server backup technologies
- Participate in disaster recovery exercises, restore testing, business-continuity planning, and high-availability validation. Support os, database, and infrastructure patching, vulnerability remediation, security reviews, and compliance requirements
- Perform infrastructure capacity planning, performance analysis, optimization, and cost-conscious resource sizing
- Maintain technical documentation, architecture diagrams, SOPS, support procedures, implementation plans, rollback plans, and operational runbooks
- Participate in change management, release management, maintenance activities, and production implementation support
Company Overview
Company H1B Sponsorship