Accord Technologies Inc ยท 2 months ago
SQL Server Database Administrator Migration to SQL Server 2022 AWS Environment
Piscataway, NJ
Full-time
Onsite
Senior Level
$55/hr - $60/hrAccord Technologies Inc is seeking an experienced SQL Server DBA to join their team. The role involves managing SQL Server environments, leading migrations to SQL Server 2022, and ensuring high availability and performance of databases in an AWS environment.
Information Technology & Services
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
Qualification
Required
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
Excellent problem-solving and communication skills
Bachelor's degree in Computer Science, Information Technology, or related field
Preferred
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
Knowledge of cloud-based database services (AWS RDS, Azure SQL,) is a plus
Company
Accord Technologies Inc
We are one of the pioneers in Information technology consulting and staffing industry.
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase