Design, implement, and maintain robust database solutions ensuring performance, security, and compliance while collaborating with teams on data requirements and solutions.
Position Summary
Assured Guaranty is seeking a database engineer to be responsible for designing, implementing, and maintaining modern database systems to ensure their optimal performance, security, governance, and reliability. They will work closely with other teams to understand data requirements and develop solutions that meet business needs.
Job Responsibilities
- Design, implement, and maintain database solutions using MongoDB, Snowflake, and Confluent Kafka.
- Design, implement, and maintain reporting platforms such as Tableau, Power BI, Sigma
- Design, implement, and maintain data caching solutions such as Redis / ElastCache
- Ensure high availability, performance, and security of database systems.
- Monitor and optimize database performance, including query tuning and indexing.
- Develop and maintain database backup and recovery procedures.Collaborate with development teams to design and implement data models and database schemas.
- Manage database access and security, including user roles and permissions.
- Troubleshoot and resolve database-related issues and provide technical support.
- Implement and manage Business Continuity Planning (BCP) to ensure database systems are resilient and can recover from disruptions.
- Oversee Change Management processes using ServiceNow to ensure smooth and controlled changes to database systems.
- Manage CI/CD pipelines using Harness or other similar tools to automate database deployments and updates.
- Stay up to date with the latest database technologies and best practices.
- Participate in on-call rotation for database support.
- Contribute to standards related to the adoption, implementation, and use of database technologies. This includes security, identity and access management, compliance, cost management, license management, performance management and monitoring.
- Work closely with IT security to ensure the adoption of database resources aligns with the company’s security posture.
Candidate Background & Qualifications
- Bachelor’s degree or higher in Computer Science, Computer Engineering, or equivalent is required
- A minimum of 5 years’ experience in similar role
- Practical work experience in IDLC processes such as Incident, Problem and Change Management.
- Ability to communicate and interact effectively with all stakeholders at all levels of the organization
- Proven experience as a DBA with expertise in MongoDB, Snowflake, and Confluent Kafka.
- Strong understanding of database design, architecture, and performance optimization.
- Experience with database backup and recovery, high availability, and disaster recovery solutions.
- Proficiency in SQL and scripting languages (e.g., Python, Bash).
- Experience with cloud-based database solutions (e.g., AWS, Azure, GCP).
- Knowledge of data warehousing concepts, ETL processes, data streaming.
Compensation
Annual base salary for the position is expected to be from $130,000 per year to $160,000 per year. The actual salary will depend on various factors, including but not limited to a candidate’s experience and credentials, salary expectations of applicable candidates, and other applicable market conditions. This position also provides applicable employee benefits, as well as eligibility for an annual discretionary bonus.
Assured Guaranty New York, New York, USA Office
New York, NY, United States
Similar Jobs
Consulting
Design, build, test, and maintain interactive dashboards and visualizations; prepare and transform data; connect BI tools to data sources; ensure data quality; support users and provide training across environments.
Top Skills:
APIsData WarehouseExcelPower BISharepointSQLTableau
Agency
Manage and optimize databases across development and production environments, focusing on Microsoft SQL Server performance tuning. Support Azure SQL, MongoDB, MySQL, and PostgreSQL. Design and maintain ETL workflows (SSIS), develop reports (SSRS), optimize queries, prepare test data, and collaborate with development and QA teams to ensure scalability, reliability, and data-driven application support.
Top Skills:
Azure Sql DatabaseCypressMicrosoft Sql ServerMongoDBMySQLPostgresSeleniumSql Server Integration Services (Ssis)Sql Server Reporting Services (Ssrs)
Renewable Energy
Own reliability, performance, and scalability of Postgres and ClickHouse databases. Build scalable data pipelines, design analytical schemas and DBT models, migrate data to ClickHouse, implement data quality checks, eliminate duplicates, and manage database infrastructure via IaC.
Top Skills:
Aws CdkAws Step FunctionsCi/CdClickhouseDagsterDbtPostgresPulumiPythonSQL
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
