Senior Database Administrator (Local Applicants Only / NO C2C)

Key Responsibilities

Database Administration & Optimization

• Manage, maintain, and optimize MySQL, MariaDB, and Snowflake databases to ensure high availability, security, and performance.
• Develop and implement backup, recovery, and disaster recovery strategies across all database platforms.
• Perform database tuning, query optimization, and indexing strategies to enhance performance.
• Troubleshoot database-related issues and ensure minimal downtime.

Data Architecture & Scalability

• Design and implement scalable database solutions, ensuring reliability and efficiency.
• Configure and manage replication, clustering, and partitioning strategies for MySQL and MariaDB.
• Work closely with data engineers and developers to design efficient database schemas and optimize query performance.

Cloud & Snowflake Administration

• Design and maintain Snowflake data warehouse solutions, ensuring optimal storage and retrieval efficiency.
• Manage ETL processes, data pipelines, and integrations with Snowflake for enterprise reporting and analytics.
• Implement security best practices and access controls for Snowflake environments.

Automation & Monitoring

• Develop and maintain database automation scripts using SQL, Python, or Shell scripting for routine maintenance.
• Implement database monitoring tools and alerts to proactively identify and resolve performance bottlenecks.
• Ensure database security and compliance with industry standards and company policies.

Collaboration & Documentation

• Partner with development, DevOps, and data teams to ensure seamless database integration and best practices.
• Create and maintain detailed documentation for database configurations, policies, and procedures.
• Provide technical guidance and mentorship to junior DBAs and database developers.

Required Skills & Qualifications

• 7 years of experience in database administration with a strong focus on MySQL, MariaDB, and Snowflake.
• Extensive experience with database performance tuning, replication, backup, and disaster recovery strategies.
• Strong expertise in SQL scripting, stored procedures, indexing, and query optimization.
• Hands-on experience with Snowflake administration, including data ingestion, warehousing, and security.
• Proficiency in cloud environments such as AWS, Azure, or Google Cloud, particularly for database hosting.
• Familiarity with ETL processes, data pipelines, and integration tools for Snowflake.
• Experience with automation and scripting using Python, Shell, or PowerShell.
• Strong knowledge of database security best practices and compliance regulations.
• Excellent problem-solving, troubleshooting, and analytical skills.
• Strong communication and collaboration abilities in cross-functional teams.

Preferred Qualifications

• Experience with database migration from on-premise to cloud or Snowflake.
• Knowledge of additional database technologies such as PostgreSQL, NoSQL (MongoDB, DynamoDB).
• Familiarity with CI/CD pipelines and DevOps practices in database deployments.
• Certifications in MySQL, Snowflake, or Cloud Platforms (AWS/Azure/GCP).