Job
Description
We are seeking a highly skilled Administrator with 8+ yearsof experience in database administration, performance tuning, scalability, andreporting. The ideal candidate will be responsible for ensuring the stability,security, and efficiency of our database systems while optimizing performanceand supporting data-driven decision-making. Key Responsibilities: Manage, configure, and maintain MSSQL and Snowflake environments to ensure optimal performance, security, and availability. Identify bottlenecks, optimize queries, indexes, and storage strategies to enhance database performance and efficiency. Implement database scaling strategies, clustering, replication, and high-availability solutions to support business growth. Ensure database security through role-based access controls, encryption, and compliance with data governance standards. Proactively monitor database health, perform troubleshooting, and resolve database-related issues efficiently. Support data warehousing strategies, optimize Snowflake performance, and facilitate seamless ETL processes. Develop and maintain robust backup, disaster recovery, and failover strategies to safeguard business-critical data. Develop and maintain reports, dashboards, and data visualizations to support business intelligence and reporting needs. Utilize scripting languages (PowerShell, Python, SQL scripts) to automate database maintenance, monitoring, and optimization tasks. Work closely with development, infrastructure, and analytics teams while maintaining up-to-date technical documentation. Requirements Required Skills Qualifications: 8+ years of experience in MSSQL and Snowflake database administration. Expertise in performance tuning, query optimization, indexing strategies, and execution plan analysis. Hands-on experience with Snowflake, including virtual warehouses, role-based security, and data sharing. Strong knowledge of database scalability, high availability solutions (AlwaysOn, replication, clustering), and disaster recovery strategies. Experience with database monitoring tools, automation frameworks, and scripting languages (PowerShell, Python, or Shell scripting). Proficiency in SQL, stored procedures, views, and database design principles. Experience with cloud-based database solutions such as Snowflake on cloud platforms is a must. Strong problem-solving skills with the ability to work independently and in a collaborative team environment. Preferred Skills: Experience with BI and reporting tools like Power BI, Tableau, or Looker. Familiarity with data pipelines, ETL tools, and integrations between MSSQL and Snowflake. Understanding of DevOps practices related to database deployments.
