SQL Developer / Software Developer

Austincc; Gaithersburg (MD); Remote; USD 90,000 - 130,000; Full time

Job summary

Austincc is seeking a SQL Developer / Software Developer to monitor and optimize SQL Server environments, backups, and HA/DR configurations. The role includes designing data models, ETL processes with SSIS, and supporting Azure SQL deployments.

You will work from anywhere in the United States when not on client sites, with a base in Gaithersburg, MD for on-site coordination as needed. Strong troubleshooting and cross-team collaboration are essential.

Qualifications

• Bachelor’s degree in CS/IT/Engineering or related field.
• Experience with SQL Server and T-SQL.
• Experience with Azure cloud services for hosting or migration.
• Experience with Windows Server and Linux.
• Experience with high availability technologies (clustering, log shipping, replication, AlwaysOn).
• Strong troubleshooting and problem-solving skills.

Responsibilities

• Monitor SQL Server databases, logs, and SQL Server Agent jobs for errors and performance issues.
• Validate backups and perform recovery testing.
• Perform regular maintenance: index rebuilds, statistics updates, integrity checks, and fragmentation review.
• Analyze and optimize queries, stored procedures, triggers, and objects.
• Manage storage, file growth, and capacity forecasting.
• Support HA/DR configurations: clustering, log shipping, replication, AlwaysOn.
• Design and maintain databases and data models; implement schema changes.
• Develop and support ETL processes using SSIS.
• Monitor cloud databases including Azure SQL and related Azure services.
• Create documentation for configurations and procedures.
• Collaborate with cross-functional teams to support development and integration.

Skills

SQL Server

T-SQL

Azure cloud services

Windows & Linux OS

High availability technologies

Relational database concepts

Troubleshooting

Education

Bachelor's degree in Computer Science/Information Technology/Engineering

Tools

Azure SQL

Job description

Job Position: SQL Developer / Software Developer

Job Description: Monitor SQL Server database instances, system logs, and SQL Server Agent jobs to identify errors, performance issues, or security concerns. Validate completion of full, differential, and transaction log backups and perform routine backup and recovery testing. Perform regular database maintenance, including index rebuilds/reorganizations, statistics updates, integrity checks, and fragmentation review. Analyze and optimize SQL queries, stored procedures, triggers, and database objects to improve performance and reliability. Manage database storage, monitor file growth, and forecast capacity needs. Support high availability and disaster recovery configurations, including clustering, log shipping, replication, and always on environments. Design, develop, and maintain SQL Server databases, data models, and schema changes based on application requirements. Develop and support ETL processes using SSIS or related tools for data integration and migration. Monitor and support cloud based database environments, including Azure SQL and related Azure services. Utilize automation/orchestration tools to streamline database and application workflows and resolve automation errors. Collaborate with cross functional teams to support application development, data integration, and operational requirements. Prepare and maintain technical documentation for database configurations, maintenance procedures, and operational workflows.

Must be willing to relocate to unanticipated client locations in the U.S. 100% telecommuting from home allowed from anywhere in the United States when not at client site.

Job Requirements: Must possess a Bachelor’s degree, or foreign equivalent, in Computer Science, Information Technology, Engineering, or a related field. Must possess experience with: (i) SQL Server and TSQL; (ii) Azure cloud services related to database hosting or migration; (iii) operating systems including Windows Server and Linux; (iv) high availability technologies such as clustering, log shipping, replication, or AlwaysOn; (v) relational database concepts, normalization, and DBMS fundamentals; and (vi) troubleshooting & resolving technical problems.

Work Hours: 9:00 a.m. to 5:00 p.m. 5 day 40 hr/wk.

Work Location:

Gaithersburg, MD 20877