SQL DBA

eTeam Inc; Bernards Township (NJ); On-site; USD 66,000 - 72,000; Full time

Job summary

eTeam Inc. is seeking a seasoned SQL Server Database Administrator in New Jersey to manage installations, tuning, security, and DR for on-prem and cloud platforms. You will lead migration projects to AWS/Azure, implement Always-On replication, and optimize data performance using SSIS/SSRS and PowerShell automation.

Strong scripting, security, and communication skills are essential. The role requires migrating databases to AWS EC2/RDS, sizing, and applying cloud best practices.

Qualifications

• Manage and administer SQL Server databases across versions, including install/configuration/maintenance.
• Monitor and optimize performance via query tuning and indexing.
• Implement high availability and DR solutions (Always-On, Replication) to minimize downtime.
• Ensure security with access controls, encryption, SSL, TDE, and data masking.
• Back up and recover databases with robust strategies.
• Plan and execute migrations/upgrades with minimal disruption.
• Develop automation scripts using PowerShell or similar tools.
• Utilize SSIS/SSRS for data integration and reporting needs.
• Implement monitoring and alerting to proactively address issues.
• Document configurations, procedures and troubleshooting steps.
• Extensive experience migrating SQL Server to AWS EC2/RDS.
• Evaluate on-prem environments and propose best-fit AWS target environment.
• Cloud migration experience with sizing and performance tuning.
• Create AWS/Azure Landing Zones and Security policies.
• Strong AWS/Azure architecture knowledge and best practices.
• Hands-on with cloud-native migration tools (AWS/Azure Database Migration).
• Familiar with Schema Conversion Tool.
• Certifications such as AWS/Azure, MCTS, MCITP, MVP are a plus.
• Proficient in SQL tools: OmniDB, DBeaver, SQL Developer, PGAdmin.
• Extensive DB security, backup/recovery, and performance monitoring expertise.
• AWS Certified Solutions Architect – Associate and AWS Certified Database Specialty are required.
• Strong written and verbal communication to present concepts to management.

Responsibilities

• Manage and administer SQL Server databases across versions (install/configuration/maintenance).
• Monitor and optimize performance through queries, indexing and tuning.
• Implement high availability and disaster recovery solutions (Always-On, Replication).
• Ensure database security with access controls, encryption, SSL, TDE, and masking.
• Develop backup and recovery strategies to safeguard data.
• Plan migrations and upgrades with minimal disruption.
• Develop automation scripts using PowerShell or similar tools.
• Work with SSIS/SSRS for data integration and reporting needs.
• Implement monitoring and alerting to address issues proactively.
• Maintain documentation of configurations, procedures, and troubleshooting.
• Migrate SQL Server to AWS EC2/RDS; evaluate best-fit cloud environment.
• Utilize AWS/Azure migration tools and Landing Zones per best practices.

Skills

SQL Server

AWS

Azure

Data Migration

High Availability & DR

Security & Compliance

Backup & Recovery

Automation (PowerShell)

Monitoring & Performance Tuning

Documentation

Communication

Cloud Architecture Best Practices

Schema Conversion

Certifications (AWS/Azure/MCTS/MCITP/M

Tools

SSIS

SSRS

PowerShell

OmniDB

DBeaver

SQL Developer

PGAdmin

AWS Database Migration

Azure Database Migration

Schema Conversion Tool

Job description

Pay Rate; $48 - $52/Hour

• Manage and administer SQL Server databases in various versions, including installation, configuration, and maintenance.
• Monitor and optimize database performance through query optimization, indexing, and other techniques.
• Implement and maintain high availability and disaster recovery solutions for SQL Server, Always-On, Replication ensuring minimal downtime.
• Ensure the security and integrity of databases by implementing access controls, encryption, SSL, TDE, and data masking.
• Develop and maintain database backup and recovery strategies to safeguard data.
• Plan and execute database migrations and upgrades while minimizing disruption.
• Develop and maintain automation scripts using PowerShell or similar tools to streamline database operations.
• Work with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) for data integration and reporting needs.
• Implement and maintain database monitoring and alerting solutions to proactively address issues.
• Maintain accurate documentation of database configurations, procedures, and troubleshooting steps.
• Significant experience with SQL Server and its migration to AWS EC2 instances and AWS RDS.
• Experience in evaluation an on-premises Data environment and suggest the best fit target environment on AWS.
• Prior cloud database migration experience with sizing and performance tuning.
• Understanding in creating AWS/Azure Landing Zones and Security policies
• Strong understanding of core AWS/Azure services and AWS/Azure architecture best practices
• Hands-on experience cloud native migrations tools such as AWS/Azure Database Migration
• Service and AWS/Azure Schema Conversion Tool
• Good to have AWS/Azure, MCTS, MCITP, and/or MVP certifications.
• Strong experience in SQL tools such as OmniDB, DBeaver, SQL Developer and PGAdmin.
• Extensive experience in database security, backup and recovery, and performance monitoring standards.
• AWS Certified Solutions Architect - Associate and AWS Certified Database Specialty Certifications is a must.
• Strong written and verbal communication skills with the ability to create and present concepts and recommendations to the management.