SQL Server DBA

  • Jersey City, NJ
  • Posted 22 hours ago | Updated 22 hours ago

Overview

Hybrid
Depends on Experience
Accepts corp to corp applications
Contract - Independent
Contract - W2

Skills

SQL Server instances
SQL Server Administration
AWS RDS
AWS RDS SQL Server databases
SSIS
SSRS
database security
IAM roles
VPC setup
security groups
data migration strategies
T-SQL
Disaster Recovery
EC2
S3
IAM
CloudWatch
RDS
PowerShell
shell scripting

Job Details

Candidate reports onsite 3 days a week (Tuesday, Wednesday and Thursday) and work from home on Mondays and Fridays.

Job Description

SQL Server Administration and AWS RDS:

* Install, configure, and maintain SQL Server instances (2016 2022) and AWS RDS SQL Server databases.

* Install, configure, and manage SQL Server 2017/2019/2022 on Ubuntu and other Linux distributions.

* Optimize performance of SQL Server databases hosted in Linux environments using best practices.

* Monitor and tune database performance using native and third-party tools (e.g., SQL Profiler, Performance Monitor, CloudWatch).

* Manage database backups, restores, and high availability solutions (e.g., Always On, Log Shipping, RDS Multi-AZ).

* Knowledge of SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

* Apply service packs, hotfixes, and cumulative updates as needed.

* Implement and manage database security, including encryption, auditing, roles, and permissions.

* Design, deploy, and maintain SQL Server databases on AWS RDS.

* Monitor cost, storage, and performance metrics of RDS instances and optimize accordingly.

* Perform RDS snapshot management, point-in-time recovery, and storage scaling.

* Perform IAM roles, VPC setup, security groups, and data migration strategies.

* Develop and optimize T-SQL queries, stored procedures, triggers, and views.

* Provide production support, including on-call rotation for critical issues.

* Create and maintain comprehensive documentation for all database environments.

* Assist in cloud migration projects, data replication, and cross-region setups.

* Support BI/reporting and application teams with data access, schema changes, and performance issues.

* Strong knowledge of T-SQL, database design, indexing, partitioning, and query optimization.

* Experience with SQL Server High Availability and Disaster Recovery strategies (e.g., Always On, RDS Multi-AZ).

* Familiarity with AWS ecosystem: EC2, S3, IAM, CloudWatch, RDS and AWS Secrets Manager.

* Working knowledge of PowerShell or shell scripting for automation.

* Create and maintain documentation for database architecture, configurations, and procedures.

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.

About TriosysIT Inc.