We are looking for a Senior Database Administrator who will manage and maintain our Snowflake cloud data platform, ensuring high availability and performance. This role involves advanced responsibilities, including designing and implementing complex data solutions, optimizing database performance, and leading database projects. The Senior Database Administrator will collaborate closely with data engineers to design, implement, and maintain data pipelines that feed into Snowflake. They will work with data analysts to fine-tune SQL queries, create efficient views, and improve overall data retrieval speed. Additionally, they will ensure data access is appropriately restricted based on roles and responsibilities.
Responsibilities:
- Administer Snowflake database environments for CIA.
- Maintain Snowflake architecture and ensure new database objects are built according to that architecture.
- Design, develop, and test scripts to import and blend data/bring in data from different source systems and ensure it is modeled appropriately.
- Monitor Snowflake database performance and troubleshoot any data issues that arise.
- Ensure all queries are optimized and monitor Snowflake usage to ensure allotted credits are not exceeded.
- Conduct performance tuning where and when needed.
- Identify opportunities for cost optimization within the Snowflake environment and implement them upon receiving management approval (e.g., auto-scaling policies, resource utilization optimization, etc.).
- Assists in the development of new data assets and services in accordance with the needs of our clients and internal customers.
- Ensure the highest level of data integrity within Snowflake and automate data monitoring.
- Stay up to date on the latest Snowflake features and best practices & recommend adjustments/enhancements when possible.
- Author and maintain internal documentation around Snowflake architecture & administration.
- Provide technical and consultative support to partnering teams as appropriate.
- Identify automation opportunities for internal processes and procedures.
- Provide after-hours support for system issues and/or key deployments as needed.
- Oversee the management and maintenance of the Snowflake cloud data platform, ensuring high availability, performance and security.
- Design and implement complex data solutions including data warehousing, ETL processes, and data integration.
- Lead efforts to optimize database performance, including query tuning, indexing, and resource management.
- Lead database related projects, coordinating with cross-functional teams to ensure successful implementation.
- Ensure data access is appropriately restricted based on roles and permissions. Implement and enforce security policies and procedures.
Requirements:
- 8-10 years of experience in database administration, with at least 3-5 years in a senior or lead role
- Practical, hands-on experience using Snowflake and fluency in ANSI SQL and Snowflake extended SQL.
- Experience troubleshooting authentication and access related issues.
- 7+ years of experience in database architecture.
- 7+ years of experience in database performance tuning.
- Strong understanding of Snowflake architecture, administration, and performance optimization.
- Knowledge of Snowflake security features. Extensive knowledge of Snowflake features and capabilities.
- Strong understanding of Snowflake data security protocols.
- Strong leadership and project management skills. Ability to work collaboratively with cross functional teams.
- Strong troubleshooting and problem-solving skills.
- Strong analytical skills.
- Strong interpersonal and written communication skills.
- Experience working with multiple data sources preferred.
- Bachelors degree preferred.
