Data Storage & Warehousing Senior Analyst IB972
Job Summary
Job Description We are excited to announce an opening for Data Storage & Warehousing Senior Analyst at Inspire Brands. Please find below the details of the role and its responsibilities.
Skills Required: SQL MongoDB Database Admin DBA Terraform IAC Infrastructure as Cloud Snowflake Azure
Experience Range: 4 - 10 years Job Description:
. RESPONSIBILITIES: Perform setting up deploying and maintaining Azure SQL MongoDB SQL Server and Snowflake cloud platform and administration. Manage security and access controls and tune Azure SQL SQL server and Snowflake for performance and optimize utilization. Build high quality solutions and establish design patterns to implement monitor & maintain complex Snowflake and Azure Data bricks solutions. Implement CICD pipelines for the Cloud Databases deployment. Configure and maintain database servers and processes monitoring of system health and performance to ensure high levels of performance availability and security. Configure and Complete understanding of Azure Data bricks cluster management Snowflake architecture and Azure SQL. Identify and Troubleshoot performance bottlenecks and optimize the problematic SQL queries in Azure SQL Perform DR and DB restore activities and must have strong programming experience in SQL Terraform and Python. Should work on the critical incidents and user service requests and responsible for SLA adherence tracking and reporting. Experience in Configuration changes and Upgrades. Collaborate with application/migration teams with database activities. Should have knowledge of on how data get processed and consumed in Data Platform and how to automate the completed process. Provides migration of database elements and online application components from development to the production environment. Redesigns databases to address change in business needs. Should have experience in python & GitHub. Performs database tuning and makes recommendations to optimize application performance. Collaborate with the development and maintenance of standards processes policy and procedures. Performs support as required adhering to on-call processes and problem escalation processes. Adheres to change management processes. Refine and automate regular processes track issues and document changes. Work as a member of Database Administration Team to provide 24x7 support for critical production systems. Perform scheduled maintenance and support release deployment activities after hours. Share domain and technical expertise providing technical mentorship and cross-training to other peers and team members. Design develop and support database automation solutions using PowerShell Python Terraform Azure Automation and CI/CD pipelines to improve operational efficiency reduce manual effort and standardize database administration processes. Configure maintain and support AI/Copilot-based operational agents for database monitoring health analysis incident response query performance analysis and automated operational workflows. Develop intelligent automation and self-healing solutions for cloud database platforms including Azure SQL Snowflake MongoDB and Databricks environments. Implement proactive monitoring alerting forecasting and automated remediation processes for database performance storage utilization security compliance and operational health. Collaborate with DevOps Data Engineering and Application teams to integrate automation frameworks AI agents governance controls and Infrastructure-as-Code standards across enterprise database platforms.
EDUCATION QUALIFICATION: Required Minimum: BS/BA degree in IT or related field preferred; equivalent experience may be substituted in lieu of education
EXPERIENCE QUALIFICATION: 6 years Administration on SQL Server MongoDB and Snowflake experience required. 6 years of SQL Server and performance tuning experience is required. 8 years of IT Support experience in an enterprise environment Experience with performance tuning and optimization using native monitoring and troubleshooting tools. Experience with backups restores and recovery models Knowledge of High Availability (HA) and Disaster Recovery (DR) options for Snowflake Data Bricks Azure SQL MySQL. Experience working with Windows server including Active Directory Excellent written and verbal communication. Ability to organize and plan work independently. Participate in 24X7 Support DBA On call Rotation. Ability to multi-task and context-switch effectively between different activities and teams Ability to commute to work onsite 5 days a week. Experience with database automation using PowerShell Python Terraform Azure Automation GitHub Actions or similar orchestration tools. Experience configuring and supporting AI/Copilot agents operational assistants or intelligent monitoring solutions for database and cloud platform environments. Experience with Infrastructure-as-Code (IaC) CI/CD automation pipelines and cloud-native operational tooling. Experience implementing proactive monitoring operational analytics performance forecasting and automated remediation solutions. Database Professional certifications a plus
Required Skills:
terraform. MongoDBAzure SQL and SQL Server automationSnowflake and Databricks skills - Proven expertise across OracleMySQLSQL ServerPostgreSQLMongoDBDB2SybaseSalesforceSnowflakeTeradataDB2LUWMandatory to have - MS SQLMongoDBAzureTerraform