Sr. Data Infrastructure Engineer

Bachelor's degree in Computer Science, Information Technology, or related field (or equivalent experience). Minimum 7+ years of experience managing databases. At least 3 years specializing in MySQL, Snowflake, and Redshift Spectrum. Proficiency in database administration, including replication, clustering, and high availability. Expertise in MySQL, Snowflake, Amazon Redshift, and Redshift Spectrum. Strong understanding of SQL and database internals. Experience with data pipeline tools (e.g., Apache Airflow, AWS Glue). Knowledge of monitoring tools (e.g., CloudWatch, Prometheus). Knowledge of scripting languages (e.g., Python, Bash). Familiarity with cloud infrastructure, particularly AWS (S3, Lambda, IAM, etc.).

Develop and enforce database standards, best practices, and security protocols. Monitor and analyze database performance, identifying bottlenecks and implementing solutions. Perform query optimization and tuning for complex workloads. Manage database caching, indexing, and resource allocation. Collaborate with data engineering teams for seamless integration. Manage data lifecycle policies, including archiving and purging. Administer and optimize environments including user access, roles, and cost controls. Implement and manage backup and recovery strategies. Ensure database systems are highly available and resilient. Perform routine maintenance tasks such as patching and upgrades. Automate database operations using scripts and tools. Implement monitoring solutions to proactively detect and resolve database issues. Ensure compliance with data security policies. Manage access controls, encryption, and auditing. Provide guidance and mentorship to junior team members. Collaborate with software developers, data engineers, and analysts. Participate in capacity planning and strategic decision-making. Collaborate to support ELT/ETL pipelines. Monitor Snowflake usage and implement cost governance policies.