Database Platform Engineer- Sql Server

TechClub Inc; United States; Presencial; USD 120.000 - 180.000; Jornada completa

Descripción de la vacante

TechClub Inc. is seeking a Database Platform Engineer / Database Administrator to design, build, and automate enterprise database platforms. You will drive GitOps-based deployments, implement IaC, and work with DevOps, security, and engineering teams to ensure reliability and performance.

The role emphasizes automation, scripting, and strong database expertise to support production and non-production environments with emphasis on scalability and maintainability.

Formación

• Experience with enterprise database platforms and automation.
• Ability to implement changes via CI/CD and IaC.
• Strong focus on performance tuning and reliability.

Responsabilidades

• Implement and manage database changes across development to production.
• Automate database deployments through CI/CD and GitOps.
• Develop tooling and automation for DBA tasks.
• Build scripts using Python, PowerShell, or Bash.
• Apply IaC principles to database operations.
• Automate provisioning, configuration, deployments, and monitoring.
• Reduce manual DBA activities through engineering and automation.
• Develop reusable tooling and operational processes.
• Monitor and optimize database performance and capacity.
• Maintain observability with dashboards and alerts.
• Support high availability and disaster recovery configurations.
• Manage security, access control, and audits.
• Document processes and participate in design reviews.

Conocimientos

Software engineering mindset

Automation mindset

Strong troubleshooting

Collaboration

Herramientas

Git

GitOps

CI/CD

Infrastructure as Code

Python

PowerShell

Bash

SQL performance analysis

Database monitoring

Descripción del empleo

We are looking for a Database Platform Engineer / Database Administrator who is first and foremost an engineer, coder, and automation specialist. The ideal candidate will be highly experienced with GitOps, Infrastructure as Code, scripting, automation, and platform engineering, while also possessing strong enterprise database administration expertise.

This role is responsible for the operational support, maintenance, security, performance, availability, automation, and reliability of enterprise database platforms across production and non-production environments.

The candidate will work closely with application, infrastructure, DevOps, security, and engineering teams to automate database operations, implement database changes, improve platform reliability, and optimize database performance.

Key Responsibilities

Database Administration & Change Management

• Implement and manage database changes including:
• DDL – CREATE, ALTER, DROP
• Schema changes and object migrations
• Index creation and modification
• Review database change requests and ensure adherence to engineering standards.
• Automate and execute database deployments through established CI/CD and GitOps processes.
• Implement database changes consistently across development, testing, staging, and production environments.
• Develop automation and tooling for recurring DBA and database platform tasks.
• Build scripts and automation using Python, PowerShell, Bash, or similar languages.
• Apply GitOps and Infrastructure-as-Code (IaC) principles to database operations.
• Automate database provisioning, configuration, deployments, maintenance, and monitoring.
• Integrate database operations with CI/CD pipelines.
• Reduce manual DBA activities through engineering and automation.
• Develop reusable tooling, frameworks, and operational processes.

Performance Engineering

• Monitor and analyze database performance and proactively identify bottlenecks.
• Tune SQL queries, stored procedures, indexes, and database configurations.
• Diagnose CPU, memory, I/O, locking, blocking, and concurrency issues.
• Perform capacity planning and resource optimization.
• Analyze workload patterns and recommend architectural improvements.
• Develop performance metrics and trend reports.

Observability & Monitoring

• Maintain database monitoring and alerting platforms.
• Develop dashboards, metrics, health checks, and operational KPIs.
• Investigate database alerts and perform root cause analysis.
• Improve database observability through instrumentation and automation.
• Create automated health checks and operational runbooks.

Reliability, HA & Disaster Recovery

• Support high-availability and disaster-recovery database configurations.
• Execute backup, restore, and recovery procedures.
• Participate in production support and incident response.
• Perform root cause analysis and post-incident reviews.
• Implement preventive measures to improve platform reliability.
• Ensure databases meet defined availability and recovery objectives.

Security & Access Management

• Provision and manage database access following least-privilege principles.
• Manage database roles, permissions, and security controls.
• Support security audits, compliance, and regulatory requirements.
• Review privileged access and support access certification processes.
• Partner with security teams on vulnerabilities and remediation.

Database Maintenance

• Perform and automate:
• Statistics updates
• Reorganizations and rebuilds
• Data archival and purging
• Space management
• Database patching and upgrades
• Monitor database growth and storage utilization.
• Maintain database housekeeping jobs and automation.
• Partner with application developers on database design and usage.
• Troubleshoot application/database performance issues.
• Review database models and recommend improvements for scalability and maintainability.
• Support testing and validation of database changes.
• Act as a technical advisor to application engineering teams.

Documentation & Governance

• Create and maintain technical documentation, standards, and runbooks.
• Document production issues, root causes, and lessons learned.
• Participate in architecture and technical design reviews.
• Ensure database platforms comply with enterprise standards.

Required Technical Skills

Database Technologies:

• Microsoft SQL Server
• Python, PowerShell, Bash, or equivalent
• Git / GitOps
• CI/CD
• Infrastructure as Code
• Automation frameworks and tooling
• SQL performance analysis and tuning
• Database monitoring and observability
• Backup and recovery
• High Availability / Disaster Recovery
• Database security and access management
• Production troubleshooting

Operating Systems:

• Windows Server

Preferred Experience

• 5+ years of enterprise database administration or database platform engineering experience.
• Strong software engineering and coding mindset.
• Experience supporting mission-critical production environments.
• Hands-on experience implementing DDL, DCL, schema changes, and database deployments.
• Experience with GitOps, CI/CD, automation, and Infrastructure as Code.
• Experience with high availability, disaster recovery, and performance engineering.
• Strong troubleshooting and root cause analysis skills.
• Experience working in regulated or highly controlled enterprise environments.
• Ability to work closely with application developers, DevOps, infrastructure, and security teams.

Ideal Candidate Profile

The ideal candidate is not a traditional DBA who primarily performs manual database administration. We are looking for someone who:

• Thinks like a Software/Platform Engineer
• Is comfortable writing code and automation
• Understands CI/CD and Infrastructure as Code
• Automates repetitive DBA processes
• Has strong database administration and performance-tuning skills
• Can work across development, infrastructure, DevOps, and security teams
• Treats databases as an engineering platform, not just an operational system