> Markdown version of [/jobs/ext/2694601-mssql-database-administrator](https://www.wearedevelopers.com/jobs/ext/2694601-mssql-database-administrator). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # MSSQL Database Administrator - **Company:** Peaklnk Technologies, Inc. - **Location:** Irvine, CA, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Amazon Web Services, Amazon Elastic Compute Cloud, Amazon S3, Cluster Analysis, Databases, Data Infrastructure, Disaster Recovery, Identity and Access Management, PostgreSQL, Microsoft SQL Server, Performance Tuning, Role-Based Access Control, Sqlprofiler, SQL Databases, Data Streaming, System Availability, Database Optimization, Software Troubleshooting, Change Data Capture, Information Technology, Cloudwatch, Terraform - **Published:** September 3, 2026 - **Apply:** https://www.dice.com/job-detail/54b2f834-e359-4318-a1dd-d15959ea17d0 ## About the Role * Bachelor's degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education. * At least 6 years of Information Technology experience. * At least 5 years of experience in MS SQL server administration and maintenance. * Able to install and configure the MS SQL Server, configure the SQL clustering/ SQL Always On Availability Groups on AWS environment. * Able to do the capacity planning based on the growth pattern of the databases. * Have expert troubleshooting skills on the SQL Clustering (Always On) environment. * Monitor, maintain database systems and troubleshoot problems that may arise. * Strong Analytic skills, Data Modelling & Performance tuning. * Perform Upgrade of databases to different versions of SQL and migration of databases from SQL server to PostgreSQL. ## Description Seeking a MSSQL Database Administrator (DBA). This role requires close partnership and collaboration with other Data Engineers and Subject Matter Experts. This candidate needs to maintain best practices and collaborates with the architecture and application teams to set the technical vision and target architecture. This candidate will be responsible for the day-to-day management of MSSQL Databases in AWS EC2 instance. This role requires deep knowledge of SQL database administration and AWS services, particularly related to daily operations of maintenance, performance tuning, and high availability., * Maintain data integrity and security (manage roles and permissions of database users). * Use tools like SQL Profiler for database tuning. * Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them. * Develop strategies and implement solutions for managing back-ups, restoration and replication. * Should be well versed with the SQL replication functions and Change Data capture process. * Create and manage stats and indexes. * Ensure timely completion of the Databases regular refreshes keeping all the reporting environment in sync. * Create detailed documentation including diagrams of database infrastructure. · Monitor database health and performance using tools like pgAdmin, AWS, CloudWatch, and other monitoring solutions. · Configure and manage PostgreSQL on AWS. · Utilize AWS services such as S3, IAM, CloudWatch, and DMS for database operations and migration. · Design and implement disaster recovery strategies, including Multi-AZ deployments and failover configurations. · Learn relevant business processes and understand the data flow, criticality and dependencies. * Utilize Terraform, Harness pipelines to deploy the codes. * Automate the routine DB management activities. Certifications (Preferred but not mandatory) * MSSQL Certified Professional (or equivalent) * AWS Certified Solutions Architect - Associate/Professional ## Related Videos - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [WeAreDevelopers LIVE - CSS is DOOMed](https://www.wearedevelopers.com/videos/1838-wearedevelopers-live-css-is-doomed) - [Infrastructure as Code: The Developer's Secret Weapon](https://www.wearedevelopers.com/videos/1221-infrastructure-as-code-the-developer-s-secret-weapon) - [Hacking MSSQL on Cloud. All of them. How I became sysadmin on Azure, AWS, GCP and Alibaba.](https://www.wearedevelopers.com/videos/100339-hacking-mssql-on-cloud-all-of-them-how-i-became-sysadmin-on-azure-aws-gcp-and-alibaba) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [Implementing Feature Environments with AWS and Terraform](https://www.wearedevelopers.com/videos/531-implementing-feature-environments-with-aws-and-terraform) ## Related Articles - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [SQL Murder Mystery: A game for hobby detectives who want to learn SQL](https://www.wearedevelopers.com/magazine/38-sql-murder-mystery-a-game-for-hobby-detectives-who-want-to-learn-sql)