Lead DBA

    • New York, NY

We are looking for someone to provide database administration support for 1,000+ clients in the AWS and on-prem environments. The role needs someone to provide database administration and troubleshooting in a SQL Server environment. Our ideal candidate will be supporting our database applications and data integration solutions. This will be part of a small team building out a DevOps environment. Applicants should have a strong interest in SQL Server & No SQL databases, and be proficient with Windows. Applicants will be supporting scheduled ETL & Reporting processes. Ultimately, you will help increase the overall performance of our sales teams and ensure they have the skills to achieve their goals.

How you'll contribute to our mission:

  • Support a growing environment and migrating to SQL 2016 and later
  • Conducts performance tuning of indexes and databases in general
  • Deploy database with the development team as necessary
  • Maintains security and integrity controls
  • May develop stored procedures and/or triggers
  • Automate common daily jobs using Powershell and similar technologies
  • Implement and maintain smooth operation and physical design of databases and SSIS
  • Engage in special project to solve key problem facing the department
  • Monitor all production systems for performance, error conditions, transaction activity and utilization
  • Manage backup and recovery of databases


How you'll know you're the right fit:

  • 7+ years' experience in the design and administration of logical and relational databases in diverse technological environments
  • Experienced with SQL Server 2008 - 2017.
  • Transact SQL
  • SSIS 2014+ admin and trouble shooting
  • Good communication skills and must work well in a team environment
  • Experience designing, implementing, tuning and maintaining SQL Server Availability Groups for highly available databases
  • Experience providing 24×7 production support on a rotation schedule
  • Strong troubleshooting and analytical skills
  • Experience in performance tuning with high data volumes
  • Ability to work effectively with clients and IT management and staff
  • Experience with SQL Server Replication
  • Bachelor degree in Computer Science or a related discipline or equivalent experience with SQL Server database technologies.
  • Experience with scripting and database automation
  • Experience with AWS hosting, tools and implementation
  • Bonus: Experience with Red Gate tools
  • Bonus: Any experience in a Dev Ops environment

ComplySci is an innovative risk management and compliance platform used to proactively identify risk and complex compliance and regulatory challenges.

ComplySci Company Image


Back to top