Lead Database Engineer
Depository Trust & Clearing Corporation (DTCC)2 months ago
Dallas, TX, USAStaff+
Responsibilities
- Integrate Snowflake with Azure AD and HashiCorp Vault.
- Integrate Snowflake monitoring with Splunk, Grafana, and Dynatrace.
- Work with Linux batch scheduling using Autosys or an equivalent tool.
- Apply FinOps concepts to optimize cost and performance.
- Administer Snowpark containers, Snowpipe Streaming, and Cortex AI services.
- Package new Snowflake features for enterprise use and validate disaster recovery and backup requirements.
- Collaborate with application teams on seamless integrations.
- Use GitLab, Bitbucket, and Jenkins for CI/CD workflows.
- Perform Snowflake and AWS administration using Terraform and Ansible.
- Provide escalated support and consulting, develop documentation and training materials, and support disaster recovery and operational rotations.
- Report defects and coordinate fixes with Snowflake.
Requirements
- Minimum of 6 years of related experience.
- Bachelor’s degree preferred or equivalent experience.
- Expertise administering Snowflake; SnowPro Core certification is preferred.
- SQL programming and relational database experience with Snowflake, Oracle, Microsoft SQL, MySQL, or PostgreSQL.
- Proficiency with Python and Bash on Linux.
- Basic Terraform and Ansible skills.
- CI/CD experience with GitLab, Bitbucket, or Jenkins.
- Basic AWS IaaS skills; Azure or GCP experience is acceptable.
- Familiarity with Agile/Scrum, JIRA, ITSM processes, and ServiceNow.
Benefits
- Competitive compensation including base pay and annual incentive.
- Comprehensive health and life insurance and well-being benefits, subject to location.
- Pension and retirement benefits.
- Paid time off and personal/family care and other leaves of absence.
- Flexible hybrid work model with three days onsite and two days remote; onsite days are Tuesdays, Wednesdays, and a third team- or employee-specific day.
- Professional development investment and workplace accommodations for applicants and employees with disabilities.
Tech Stack
AnsibleAWSAzureBashGoogle Cloud PlatformGrafanaJenkinsLinuxMicrosoft SQL ServerMySQLPostgreSQLPythonSnowflakeSplunkSQLTerraform
Categories
Data Engineering
About Depository Trust & Clearing Corporation (DTCC)
Depository Trust & Clearing Corporation (DTCC) runs global post-trade market infrastructure, delivering clearing, settlement, securities depository, trade reporting, and data services for broker-dealers, banks, and asset managers. It provides these services through subsidiaries such as DTC, NSCC, FICC, and the Global Trade Repository, with revenue primarily from transaction and service fees. Founded in 1973 and headquartered in Jersey City, NJ, DTCC is industry-owned and privately held, serving markets across multiple regions.