SQL Database Administrator

This is a fully remote position, open to applicants in India.

📋 Description

• Create and enhance intricate SQL queries utilizing EXPLAIN plans and indexing methodologies.

• Execute schema modifications through CREATE/ALTER statements along with rollback strategies.

• Set up and verify automated backup and restoration processes.

• Oversee user roles and permissions in accordance with established security protocols.

• Transfer data between systems while ensuring validation checks and encoding integrity.

• Conduct data quality assessments and document violations along with corrective scripts.

• Update statistics, manage transaction logs, and test failover recovery procedures.

• Carry out compliance data extractions, apply patches, and conduct system audits for enterprise applications.

• Record processes and performance observations in straightforward, reproducible formats.

⛳️ Requirements

• Over 5 years of experience as a Database Administrator in production settings.

• Advanced SQL expertise and familiarity with PostgreSQL, MySQL, and/or SQL Server.

• Solid foundation in performance optimization, security, data integrity, and schema development.

• Understanding of compliance standards (e.g., SOX), data export formats, and backup tools.

• Proficient in managing large datasets, interpreting execution plans, and overseeing database infrastructure comprehensively.

• Capability to produce high-quality production scripts and documentation for technical stakeholders.

🏝️ Benefits

• Weekly payments via Stripe Connect, based on logged hours.