Sr. Database Engineer

Hedgeserv Dallas , TX 75201

Posted 3 weeks ago

Company Description

HedgeServ is a fast-growing service-driven global administrator. We feature a unique technology platform with one of the most experienced service teams in the industry. HedgeServ provides fund administration, middle office services, integrated risk & portfolio management, regulatory & compliance reporting, tax support, and complete shadow accounting services, underpinned by SOC 1 certified controls. HedgeServ supports all investment strategies within hedge funds, funds of hedge funds, private equity funds, asset managers, managed accounts and managed account platforms, UCITS funds, and other institutional investment programs such as pensions and endowments. Our services are completely customized for the needs of our individual hedge fund, fund of hedge funds and private equity fund clients. HedgeServ employs professionals globally across offices in the United States (New York & Dallas), Grand Cayman, Ireland (Dublin & Cork), Luxembourg, Poland (Krakow), Bulgaria (Sofia), and Australia (Sydney).

Job Description

The Database Engineering team of HedgeServ Corporation is seeking a mid to senior level SQL Server Administrator/Data Architect working in an AWS cloud environment. The ideal candidate will have an understanding of data modeling best practices in Data Warehousing vs OLTP and an understanding of SQL server to Snowflake ETL process.

Responsibilities

  • Hands on administration and support of Database Clusters on-prem and cloud environments.
  • Supporting all facets of data services in the hybrid environment encompassing AWS pipelines of SQL Server HA Always On clusters using Terraform and Ansible while collaborating with support, it engineering, and development teams.
  • Support and develop new and existing Data Warehouse and OLTP design with dev teams. Working knowledge of ERWIN data model tool.
  • Performance and tuning of SQL queries.
  • Supporting Snowflake and MongoDB cloud environments.

Pre-requisite knowledge, skills and experience

  • Minimum of 6 years database administration & architecture experience working in fast-paced environments (preferably in fintech, but not required).
  • Expertise with Microsoft SQL Server Always-ON and standalone installations and administrations versions 2012 2019.
  • Expertise with ERWIN data modeling tool on new and existing logical and physical data models.
  • Expertise with ETL data transformation.
  • Basic understanding of AWS Cloud environment.
  • Basic understanding of Snowflake Data Warehouse setup and administration.
  • Expertise troubleshooting performance and tuning of the SQL environment and the SQL queries.
  • Proactive monitoring of SQL Servers. Blocking, deadlocks, multithreading, long running queries.
  • Experience with AWS Cloud technologies.
  • Proficient in scripting languages, such as SQL and PowerShell.
  • Knowledge of Terraform and Ansible is a big plus.
  • Understanding connections from Kubernetes EKS clusters is big plus.
  • Experience with Microsoft SQL Server, Automation Tools PowerShell / Ansible / Terraform, Snowflake, MongoDB, Data Warehouse, and Data Modeling
icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Sr Database Engineer ((Oltp/Remote))

Match Group

Posted 3 weeks ago

VIEW JOBS 2/6/2021 12:00:00 AM 2021-05-07T00:00 Hi! We're the Affinity Apps Team. We make dating apps that embrace our users' sense of community. Every month, millions of singles come to our apps, like Upward, BLK and Chispa, to make great connections. We're looking for a Senior Database engineer with great attention to detail who likes working at large scale with a constantly evolving product. We're based in Dallas, TX. However, we are open to considering a remote office for a qualified candidate who can travel periodically to Dallas (when safe to do so). How you'll make an impact: * Architecting solutions, designing databases and tables, writing effective T-SQL stored procedures, and optimizing existing structures and code to ensure our users have the best, fastest experience possible * Advising, guiding, and providing input on a variety of business and technical challenges (we build and maintain complex algorithms that are heavily database driven) * The ability to creatively solve problems and overcome unique challenges with minimal supervision or hand-holding We could be a match if: * Eagerness to write T-SQL code that will perform in a highly-transactional, 24/7/365 environment * A good understanding of SQL Server internals (and why that's important) * Comfort with an agile, fast-paced environment * Curiosity to better understand things like "how the optimizer works" and to learn the "why" that drives implementation choices * The desire to maintain open, consistent communication with peers, business teams, and management * BS in Computer Science (or equivalent experience) * Design: create structures and code to solve complex problems in the best way * T-SQL: create tables, indexes, stored procedures, functions from scratch * SQL Server fundamentals: possess a strong grasp of how SQL Server works * Performance tuning: use instrumentation and DMVs to troubleshoot and optimize * Well-versed in high-volume, highly-transactional systems * Working knowledge of DBA tasks (helps in design and performance tuning) * Experience with version control and deploying changes to QA and production What's the team like? * We are a small but growing team, full of bright and collaborative people who are deeply passionate about making great software * We work cross-functionally with our Product and Design partners to craft exciting new features that will delight our users * We encourage continuous improvement and strive to always learn and grow as engineers and as a team * We love to celebrate Taco Tuesday! Wait, why wasn't this listed first? #LI-CENTRAL #LI-REMOTE Why Match Group? Our mission is simple - to help people find love and happiness! We love our employees too - here are some examples how: Annual training budget for each employee 100% employer match on 401k contributions Specific COVID-19 allowance for home office set-up Matched giving to qualified organizations 100% paid Parental Leave Happy Hours and Company events (they are all virtual now, but still a ton of fun!) We value diversity at our company and will never discriminate based on someone's race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. Match Group Dallas TX

Sr. Database Engineer

Hedgeserv