Sr Azure SQL Postgres DBA at Remote only Dallas, TX

Job Title: Sr Azure SQL Postgres DBA

Location: REMOTE

Job Type: Contract

Job Description:

Top Qualifications:

1. Manage and optimize both Azure SQL (MSSQL) and Azure Database for PostgreSQL databases, ensuring performance, security, and availability.

2. Provision, configure, and maintain Azure SQL and Azure PostgreSQL databases.

3. The ability to design secure Azure environments, all while maintaining excellent communication and problem-solving abilities.

Required Skills:

• MS SQL Server

• Azure

• PostgreSQL DB Administration

• Microsoft Azure SQL Admin

Nice to Have Skills:

• Experience with cloud database migration, specifically to Azure

• Experience in providing support and guidance to junior team members

Qualifications:

• Experience in performance tuning, query optimization using Performance Monitor, SQL Profiler and other related monitoring/troubleshooting tools

• Experience with clustering, replication, virtualization, and high transactional enterprise systems.

• Experience in SQL Server, including replication, HA and DR techniques

• Strong aptitude for tuning T-SQL

• Provide written and verbal recommendations to vendor supplied solutions including, but not limited to indexing, code modifications, process improvements and logical and physical data structures.

• Provide technical assistance to developers, perform code reviews, identify inefficient code, provide suggestions for rewriting queries to ensure optimal execution·

• Responsible for administration, maintenance, performance monitoring and availability of enterprise Production SQL server environments ·

• Strong understanding of cloud computing fundamentals,

• Proficiency with core Azure services like Virtual Machines, Functions, and Active Directory,

• Solid networking knowledge,

• Security best practices,

• Automation skills using Infrastructure as Code (IaC) tools, and the ability to design secure Azure environments, all while maintaining excellent communication and problem-solving abilities.