02 nov
|
Zeo Consulting
|
Chubut
02 nov
Zeo Consulting
Chubut
Own the database and data estate end to end assess what we have, run a time-critical upgrade as the first job, and then set the direction and standards that mature the whole environmentOur SQL Server is BYOL on EC2 we install, configure, and operate it ourselves, an on-premise setup that happens to live in AWS.
MySQL runs on RDSFirst 90 days1.
Assess the current estate inventory, backup and recovery posture, high availability configuration, monitoring and alerting gaps, access model, capacity, and cost.2.
Produce a written state-of-the-estate and a prioritized remediation planNear-term priority1.
Upgrade the Windows Server OS hosting our production SQL Server estate — Windows Server **** → **** — across an Always On Availability Group cluster, with no data loss and minimal downtime.
Must do before the end of .
Then upgrade the SQL Server version from our current SQL Server ****, and own the recommendation on whether we stay self-managed on EC2 or move to AWS RDS managed SQL Server after the upgrade.Core ownership1.
Full ownership of administration, operation, and optimization for all relational databases SQL Server (self-managed on EC2) and MySQL (RDS)2.
Performance tuning, monitoring and alerting, backup and recovery, high availability and failover, security and access management, capacity and costMaturing the estate1.
Define and enforce database standards across the C#/.
NET SQL Server and TypeScript/MySQL codebases; act as the technical authority on schema and data- access design for both engineering teams2.
Own data observability monitoring, alerting, and capacity forecasting against agreed service levels3.
Establish backup and DR testing, access governance and change control that stand up to SOC 2 and our cyber insurer4.
Produce and maintain a data platform roadmap covering both relational stacks, Snowflake and the analytics estate5.
Set direction for the data engineering team on database mattersSecondary1.
Snowflake administration, including usage and cost monitoring3.
Data warehouse and data engineering work alongside the data platform team; support internal and external analytics and BI7+ years of professional experienceDeep and current Microsoft SQL Server administrationHands-on experience with SQL Server installation and configuration on a self-managed server (EC2 or on-premise),
including OS-level work beneath a live production instanceExperience with Windows Server administration, including OS upgrades and migrationsRecently performed SQL Server upgrade, including source and target versions, in-place or side-by-side, and the Windows Server version pairingExperience with SQL Server high availability (Always On Availability Groups, failover clustering)Experience with MySQL administrationExperience with AWS (EC2, RDS, S3, IAM, CloudWatch)Proficiency with AI tools (e.g., Claude) applied to daily workPrior end-to-end ownership of a production database estate, including assessing an inherited environment and driving it to a measurably better stateExperience setting data standards and reviewing schema and data-access design across application teamsStrong communication skills in both spoken and written EnglishOwn the database and data estate end to end assess what we have, run a time-critical upgrade as the first job, and then set the direction and standards that mature the whole environmentThe company is the product of a merger, so we run two stacks — C#/.
NET on Microsoft SQL Server, and TypeScript/JavaScript on MySQL — both in AWSOur SQL Server is BYOL on EC2 we install, configure, and operate it ourselves, an on-premise setup that happens to live in AWS.
MySQL runs on RDSFirst 90 days1.
Assess the current estate inventory, backup and recovery posture, high availability configuration, monitoring and alerting gaps, access model, capacity, and cost.2.
Produce a written state-of-the-estate and a prioritized remediation planNear-term priority1.
Upgrade the Windows Server OS hosting our production SQL Server estate — Windows Server **** → **** — across an Always On Availability Group cluster, with no data loss and minimal downtime.
Must do before the end of .
Then upgrade the SQL Server version from our current SQL Server ****, and own the recommendation on whether we stay self-managed on EC2 or move to AWS RDS managed SQL Server after the upgrade.Core ownership1.
Full ownership of administration, operation,
and optimization for all relational databases SQL Server (self-managed on EC2) and MySQL (RDS)2.
Performance tuning, monitoring and alerting, backup and recovery, high availability and failover, security and access management, capacity and costMaturing the estate1.
Define and enforce database standards across the C#/.
NET SQL Server and TypeScript/MySQL codebases; act as the technical authority on schema and data- access design for both engineering teams2.
Own data observability monitoring, alerting, and capacity forecasting against agreed service levels3.
Establish backup and DR testing, access governance and change control that stand up to SOC 2 and our cyber insurer4.
Produce and maintain a data platform roadmap covering both relational stacks, Snowflake and the analytics estate5.
Set direction for the data engineering team on database mattersSecondary1.
Snowflake administration, including usage and cost monitoring2.
Database development — stored procedures, schema design, query optimization3.
Data warehouse and data engineering work alongside the data platform team; support internal and external analytics and BIRequisitos7+ years of professional experienceDeep and current Microsoft SQL Server administrationHands-on experience with SQL Server installation and configuration on a self-managed server (EC2 or on-premise), including OS-level work beneath a live production instanceExperience with Windows Server administration, including OS upgrades and migrationsRecently performed SQL Server upgrade, including source and target versions, in-place or side-by-side, and the Windows Server version pairingExperience with SQL Server high availability (Always On Availability Groups, failover clustering)Experience with MySQL administrationExperience with AWS (EC2, RDS, S3, IAM, CloudWatch)Proficiency with AI tools (e.g., Claude) applied to daily workPrior end-to-end ownership of a production database estate, including assessing an inherited environment and driving it to a measurably better stateExperience setting data standards and reviewing schema and data-access design across application teamsStrong communication skills in both spoken and written EnglishBeneficiosRemote in Argentina, Brazil, Colombia, Mexico, Paraguay, Chile, Peru, Costa Rica, UruguayLong-term40h/weekClient US Company | Medium employees) - Finance Industry
#J--Ljbffr
📌 Senior Dba & Developer (Latam Remote) (Chubut)
🏢 Zeo Consulting
📍 Chubut