SQL Server Database Engineering/ Administrator (DBA)

ICONMA, LLC

Fort Mill, SC

JOB DETAILS
SALARY
$53.57–$58.57 Per Hour
SKILLS
Amazon Relational Database Service (RDS), Amazon Simple Storage Service (S3), Amazon Web Services (AWS), Automation, CPU (Central Processing Unit), Capacity and Performance Management, Cloud Computing, Code Reviews, Data Recovery, Database Administration, Database Design, Database Programming, Failover, Health Plan, Hybrid Cloud, Information Technology Consulting, Input/Output, Leadership, Memory Hardware, Mentoring, Microsoft SQL Server, Microsoft SQL Server DBA (Database Administration), Microsoft Transact-SQL (T-SQL), MySQL, NoSQL, On Call, Operational Audit, Operations Processes, Performance Analysis, Performance Tuning/Optimization, PostgreSQL, Production Support, Production Systems, Quality Management, Query Analysis, Registered Training Organisation (RTO), Relational Databases (RDBMS), Replication and Remote Mirroring, Reporting Dashboards, SQL (Structured Query Language), SQL Server Reporting Services (SSRS), Software Patches, Windows PowerShell
LOCATION
Fort Mill, SC
POSTED
2 days ago
Our Client, an IT Services and Consultant company, is looking for a SQL Server Database Engineering/ Administrator (DBA) for their Charlote, NC/Remote location.
 
Responsibilities:
  • SQL Server Administration
  • Install, configure, upgrade, patching and maintaining Microsoft SQL Server (2019–2022) in production, non-production, and DR environments
  • Manage Always On Availability Groups, Failover Cluster Instances (FCI), Replication, and Log Shipping
  • Perform capacity planning and proactive performance monitoring.
  • Work with App/Dev teams to perform code reviews and schema validations.
  • Cloud & Hybrid Database Management
  • Manage AWS RDS SQL Server, PostgreSQL, DocumentDB, DynamoDB on hybrid platforms.
  • Should have good experience in migration of SQL Server Onprem databases to Cloud RDS/Aurora.
  • Migration of databases to Aurora Postgres/MySQL and migrating RDBMS/NoSQL databases.
  • Configure MultiAZ, Read replica instances in cloud.
  • Should have good understanding and experience in performing AWS DMS, S3/VPC/IAM/Security groups in AWS
  • Support database migrations using tools like AWS SCT and work with SSMS, SSRS and other SQL tools
  • Optimize RDS/cloud database cost, performance, and scalability.
  • Performance & Optimization
  • Analyze and tune query performance, indexes, execution plans, and blocking/deadlock issues
  • Optimize tempdb, memory, CPU, and I/O configurations
  • Work with developers to improve SQL code quality and database design
  • Backup, Recovery & DR
  • Design and manage backup and restore strategies.
  • Perform recovery in AWS Cloud instances.
  • Perform regular DR drills and recovery testing
  • Support RPO/RTO objectives for business-critical systems
  • Automation & Monitoring
  • Automate routine SQL Installations and DBA tasks using PowerShell, T SQL.
  • Implement and manage monitoring tools (SSMS, CloudWatch)
  • Create dashboards, alerts, and runbooks
  • Production Support & Leadership
  • Provide L3/L4 support for database incidents and outages
  • Participate in on call rotation for critical systems
  • Mentor junior DBAs and review operational procedures
 
Requirements:
  • Years of Experience:   11.00 Years of Experience
 
Why Should You Apply?

About the Company

I

ICONMA, LLC