MS SQL DBA- AWS & PostgreSQL (Contract W2)

Siri InfoSolutions Inc; Irvine (CA); On-site; USD 110,000 - 170,000; Full time

Job summary

Siri InfoSolutions Inc. in Irvine, CA seeks an experienced MSSQL Database Administrator (DBA) to manage MSSQL databases in AWS EC2.

The role emphasizes performance tuning, high availability, and collaboration with data engineers to define the technical vision and target architecture. The candidate will install/configure SQL Server, implement Always On Availability Groups on AWS, perform capacity planning, and migrate databases from SQL Server to PostgreSQL.

Qualifications

• Bachelor's degree or foreign equivalent required; three years of progressive experience in lieu of every year of education
• 8+ years of Information Technology experience
• 5+ years of MS SQL Server administration and maintenance
• Able to install and configure MS SQL Server and Always On Availability Groups on AWS
• Capacity planning based on database growth patterns
• Expert troubleshooting skills on SQL Clustering (Always On)
• Monitor and maintain database systems; troubleshoot issues
• Strong analytic skills, data modelling and performance tuning
• Migrate databases from SQL Server to PostgreSQL
• Manage backups, restoration and replication
• Knowledge of SQL replication and Change Data Capture
• Create and manage stats and indexes
• Monitor health and performance using pgAdmin, AWS CloudWatch, and other tools
• Configure and manage PostgreSQL on AWS
• Use AWS services such as S3, IAM, CloudWatch, DMS for operations and migration
• Disaster recovery design including Multi-AZ and failover
• Familiar with Terraform, Harness pipelines for deployments
• Automate routine DB management activities

Responsibilities

• Manage day-to-day MSSQL databases in AWS EC2
• Collaborate with data engineers and SMEs to set technical vision
• Maintain best practices and target architecture
• Ensure data integrity and security; manage roles and permissions
• Perform upgrades and migrations, including to PostgreSQL
• Implement backup, restoration and replication strategies
• Monitor, tune and troubleshoot database performance
• Design and implement disaster recovery and high availability configurations
• Create detailed documentation of database infrastructure
• Monitor health using pgAdmin, AWS CloudWatch, and other tools

Skills

MS SQL Server administration

AWS experience

Performance tuning

High availability

Troubleshooting

Data modeling

Migration to PostgreSQL

Capacity planning

Documentation

SQL Profiler

Education

Bachelor's degree or foreign equivalent

Tools

pgAdmin

AWS CloudWatch

DMS

Terraform

Harness pipelines

SQL Profiler

Job description

MS SQL DBA with exp on AWS

Irvine, CA

Job Description

Client is 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.

Required Qualifications and Key Requirements :

• 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 8+ 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
• 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