Senior Database Engineer

Senior Database Engineer

Location: Chicago, IL (Hybrid, Onsite 2 days a week)

Job Type: 6 Month Contract to hire

Position Summary:

We are seeking a highly skilled and experienced Senior Database Administrator (DBA) with deep expertise in Snowflake to join our data infrastructure team. The ideal candidate will be responsible for the design, implementation, performance tuning, and maintenance of our analytical database environments, ensuring high availability and optimal performance across platforms.

Key Responsibilities:

• Administer, monitor, and optimize Snowflake database environments.
• Lead and execute the migration of data and workloads from Vertica to AWS/Snowflake.
• Design and implement data models, schemas, and storage strategies for large-scale analytics.
• Perform database performance tuning, query optimization, and capacity planning.
• Implement and manage space management strategies and proactive space monitoring.
• User Management: Create, manage, and delete users; grant roles and permissions.
• Role-Based Access Control (RBAC): Implement and maintain role hierarchies for granular access control.
• Security: Configure security policies, monitor access, and manage secrets.
• Performance Tuning: Monitor virtual warehouses, optimize queries, and ensure efficient resource utilization.
• Data Loading and Management: Manage data loading processes, data replication, and data backup.
• Monitoring and Auditing: Track activity, monitor query performance, and audit access.
• Cost Management: Identify and optimize storage costs and virtual warehouse usage.
• Automation: Implement automated tasks for routine database management and monitoring.
• Collaborate with data engineers, analysts, and DevOps teams to support data pipelines and ETL processes.
• Troubleshoot and resolve database-related issues in a timely manner.
• Evaluate and recommend new database technologies and tools.

Required Qualifications:

• Bachelor s or Master s degree in computer science, Information Systems, or a related field.
• 7+ years of experience as a Database Administrator, with 3+ years of hands-on experience in Snowflake.
• Proven experience in migrating data platforms, especially from Vertica to Snowflake or AWS.
• Strong expertise in SQL, query optimization, and performance tuning.
• Solid understanding of data warehousing, ETL processes, and data modeling.
• Experience with cloud platforms (AWS, Azure, or Google Cloud Platform) and cloud-native database services.
• Proficiency in scripting languages (e.g., Python, Bash) for automation and monitoring.
• Experience with RBAC, user management, and security best practices.
• Familiarity with cost optimization strategies in cloud-based data environments.
• Strong analytical and problem-solving skills with attention to detail.
• Excellent communication and collaboration skills.
• Maintain controls, reporting and transparency necessary to comply with customer and BCBSA confidentiality, HIPAA, PHI and PII standards, as well as SOC2 and HiTrust certifications.

Preferred Qualifications:

• SnowPro Core or Advanced Certification and/or Vertica DBA Certification.
• Experience with CI/CD pipelines and Infrastructure as Code (IaC) tools like Terraform.
• Familiarity with BI tools (e.g., Tableau, Power BI, Looker).
• Experience with data orchestration tools like Apache Airflow or dbt.
• Knowledge of Kafka, event streaming, or real-time data processing.

Brooksource provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, national origin, age, sex, citizenship, disability, genetic information, gender, sexual orientation, gender identity, marital status, amnesty or status as a covered veteran in accordance with applicable federal, state, and local laws.