Senior Azure DBA & Data Architect

About Us:

Atmosera is full lifecycle cloud technology transformation firm, offering application and data professional services, security & compliance management, Azure operations, and technology training.

Our expertise across applications, data, and the Microsoft Azure platform allows us to accelerate innovation speed, increase operational agility, and vastly improve the return on investment in modern technology and human expertise.

What You'll Do:

The Sr. Azure Database Administrator will work as a part of the Cloud Operations team to support both internal and external customers. This person will help modernize existing applications with Azure SQL Managed Instance, migrate on prem systems into Azure data platforms and design, build and optimize Database systems.

Additionally, the Sr. Azure Database Administrator will work directly with end clients to support and operationalize Atmoseras' DBAaaS offering.

Responsibilities:

• Define and maintain all design documentation on all Internal and External (customer) DBs including schema design, HA, backup, and replication.

• Define and maintain Operational specifications for all Internal and External (customer) DBs. This includes desired maintenance schedules, patching criteria/frequency, order of operations for maintenance, as well as troubleshooting tips

• AD-hoc break/fix support for all Internal and External DBs

• Define and maintain version and upgrade planning for all DBs.

• Development of automated health and performance tuning queries/metrics to improve running performance on all DBs. This includes incorporating of these queries/metrics into periodic reports with subjective interpretation of the general health of the DBs, and if not found healthy, a plan with discrete steps on how to improve health.

• Definition and execution of basic DB day-to-day maintenance for all managed DBs.

Azure migration and DBA Support

• You will plan, design and migrate on prem SQL systems into Azure Data Platforms (PaaS & IaaS) using data migration tools/methods to ensure minimal downtime

• Perform analysis, capacity planning, designing and configuration of Azure SQL database systems

Development and Support of Internal tools:

• Define, develop and maintain internal usage reporting systems for billing-related metrics that must be reported periodically (daily/weekly/monthly) in an automated fashion to the billing system.

• Ensure compliance with business objectives by providing timely and accurate resolution of work assignments; provide regular feedback regarding opportunities and problems.

• Participate in project budget and work assignment preparation by assessing complex requirements, completing cost estimates and outlining proposed expenditures for management approval.

• Ensure that all assignment deliverables are complete, including detailed "As-built" documentation. Ensure high quality and understandable deliverables are produced for the appropriate level.

• Ensure the integrity of corporate data by developing and implementing backup/recovery mechanisms and internal controls. Ensure vaulting processes are implemented to protect corporate data against disasters.

Dedicated Managed Customer Solutions:

• Work with Sales on customer opportunities to gather customer requirements, develop designs and present potential DBAaaS solutions.

• Provide expert technical consulting to Sales team and customers; serve as a technical contact to outside vendors as required. Provide training to Company personnel as required.

• Participate in a walkthrough of deliverable components. Provide feedback to ensure the technical quality of the application or system. Provide technical solutions to design, program and process issues.

• Oversee the analysis of dedicated managed customer system-related performance problems. Recommend and implement changes to improve performance to acceptable levels.

• Research, evaluate and recommend the use of new products and services to support customer applications and system software. Coordinate and participate in the implementation of new support and system software and ensure compliance with company and department standards and processes where they exist or are defined.

The Skills You Need:

• Experience in Azure PaaS SQL services including Azure Data Warehouse as well as Azure Data Lake.

• Strong experience in migrating on prem SQL systems into Azure data platforms (PaaS & IaaS)

• Experience in data migration tools/methods to migrate on prem data to Azure with minimal downtime to applications

• Experience in analysis, capacity planning, designing and configuration of Azure SQL DB systems

• Experience with BI tools such as Dynamics or Tableau.

• Experience with data visualization technologies such as PowerBI and SSIS.

• Experience in designing, building and maintaining large scale MS-SQL geographically diverse HA clusters.

• Excellent oral and written communication skills; including documentation.

• Excellent organizational and time management skills; including tracking of billable hours.

• Ability to generate presentation materials suited to many different audiences, i.e. end users, TACC, NOC, Executives, etc.

Perks & Benefits:

• Health, vision, dental package including options for 100% paid employee coverage

• 401k with generous matching

• Company paid Life, AD&D, Short- and Long-Term Disability

• Performance-based compensation with bonus potential in addition to salary

• Employee Recognition and Reward Programs

• Community Service Leave

This is a full-time position in the United States with the ability to work from home, or from one of our many US offices if local.

Atmosera is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.

We do not discriminate based upon race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.

All employment is decided on the basis of qualifications, merit, and business need.