What are the responsibilities and job description for the SQL Server Database Administrator (DBA) position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, ITECS, is seeking the following. Apply via Dice today!
Job Title: SQL Server Database Administrator (DBA) Migration to SQL Server 2022 (AWS Environment)
Location: Piscataway, NJ (Hybrid). Onsite from Day1. Need local candidates only.
Overview:
We are seeking an experienced SQL Server DBA to join our team. The ideal candidate will have extensive hands-on experience in managing SQL Server environments across multiple versions and a proven track record of successful migrations to SQL Server 2022. You will be responsible for maintaining, optimizing, and migrating our SQL databases to ensure high availability, security, and performance.
Key Responsibilities:
Job Title: SQL Server Database Administrator (DBA) Migration to SQL Server 2022 (AWS Environment)
Location: Piscataway, NJ (Hybrid). Onsite from Day1. Need local candidates only.
Overview:
We are seeking an experienced SQL Server DBA to join our team. The ideal candidate will have extensive hands-on experience in managing SQL Server environments across multiple versions and a proven track record of successful migrations to SQL Server 2022. You will be responsible for maintaining, optimizing, and migrating our SQL databases to ensure high availability, security, and performance.
Key Responsibilities:
- Manage and support SQL Server environments across various versions.
- Lead and execute database migration projects, including assessments, planning, testing, and implementation of migrations to SQL Server 2022.
- Ensure database performance, stability, and security.
- Develop and implement backup, recovery, and disaster recovery strategies.
- Monitor SQL Server performance and troubleshoot issues proactively.
- Automate routine tasks using scripts and tools.
- Monitor, troubleshoot, and tune SQL Server performance in an AWS environment.
- Develop automation scripts (PowerShell, AWS CLI) for deployment, backup, maintenance, and monitoring processes.
- Ensure security best practices for database access, data encryption, and compliance in AWS.
- Collaborate with development teams to optimize database queries and schema design.
- Maintain documentation of database configurations, policies, and procedures.
- Stay current with industry best practices and SQL Server feature set enhancements.
- Stay abreast of new features in SQL Server 2022 and AWS cloud services.
- Extensive experience with SQL Server versions (2008, 2012, 2014, 2016, 2017, 2019, and 2022).
- Proven experience leading or executing database migrations to SQL Server 2022.
- Strong knowledge of SQL Server installation, configuration, and management.
- Experience with performance tuning, indexing, and query optimization.
- Familiarity with SQL Server clustering, Always On Availability Groups, and replication.
- Proficiency in T-SQL, PowerShell scripting, and automation.
- Strong understanding of AWS services related to SQL Server hosting (RDS, EC2, S3, CloudWatch, IAM).
- In-depth knowledge of SQL Server high-availability, disaster recovery solutions, and performance tuning.
- Proficiency in T-SQL, PowerShell scripting, and automation tools.
- Knowledge of cloud-based database services (AWS RDS, Azure SQL,) is a plus.
- Excellent problem-solving and communication skills.
- Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate, MCSA, MCSE) are preferred.
- Experience with SQL Server Containerization and DevOps practices.
- Familiarity with data security standards and compliance.
- Ability to design and implement high-availability and disaster recovery solutions.
- Bachelor's degree in Computer Science, Information Technology, or related field.