| Job Description: | Job title: Sr Azure SQL/Postgres DBA
Job Location: Atlanta, GA
Work Model: Remote
Shift: Day
Desired Start Date: 5/1/2025
Project Duration: 12 months
Job Summary:
We are seeking an experienced Architect with 10 to 13 years of experience to join our team. The ideal candidate will have a strong background in Microsoft Azure SQL Admin, PostgreSQL DB Administration, and MS SQL Server. This role is hybrid, with a day shift schedule and no travel required. The Architect will play a crucial role in designing and implementing database solutions that align with our company's goals and objectives.
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
Responsibilities:
Manage and optimize both Azure SQL (MSSQL) and Azure Database for PostgreSQL databases, ensuring performance, security, and availability.
Provision, configure, and maintain Azure SQL and Azure PostgreSQL databases.
Identify and resolve performance bottlenecks, optimize queries, and tune database configurations.
Implement and maintain security measures, including user access control, encryption, and network security.
Develop and execute backup and recovery plans to ensure data integrity and business continuity.
Monitor database performance and availability, troubleshoot issues, and implement solutions.
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. |