Work with a team of passionate data engineers and scientists to enable data mining, deep learning, statistical modeling, predictive analytics, machine learning, and NLP.
Knowledge and strong experience and understanding of database structures, theories, principles, and practices. Knowledge of Microsoft SQL Server/Snowflake.
Ability to demonstrate expertise in relational database administration including configuration, implementation, data modeling, maintenance, redundancy/HQ, security, troubleshooting/performance tuning, upgrades, database, data, and server migrations.
Ability to demonstrate expertise in configuring, implementing, and supporting high availability redundancy strategies on systems including replication, clustering, log shipping, and mirroring.
Ability to demonstrate expertise in relational database design and architectural principles and methodologies. Ability to demonstrate expertise with High Availability and Disaster Recovery options, planning and implementation for MSSQL Server.
Knowledge and understanding of, and experience with, server-client computing and relational database environments. Knowledge and experience with data management and data processing flowcharting techniques. Knowledge of reporting and query tools and practices. Ability to perform the essential functions of this position.
Support Month End/Year End Production Activities
Responsible for providing day-to-day support and maintenance for existing SQL databases that are under support.
Accountable for identifying and tracking all databases by function, owner and application that are business critical in an agreed upon central location.
Assist in the administration, management, and monitoring of all SQL database systems.
Accountable for proper backup and disaster recovery procedures and documentation.
Good understanding of Database Architecture, Performance tuning of databases, pro-actively Identify bottlenecks and resolve them quickly.
Work with developers on performance tuning, query optimization, index tuning
Actively work with developers to solve database/application issues without compromising database best practices and work with them to promote changes to production.
Support SQL database in external cloud and work with various cloud providers as required.
Rotate with other DBAs to be on call to quickly fix issues that arise in our production and non-production environments
Be part of a 24/7/365 on-call rotation
Qualifications
Bachelor's degree in Computer Science, Information Systems or related field.
5 + years of SQL DBA experience
Robust Ops foundation - you're always thinking "What happens if this fails" when you build things.
Proficient in scripting and automation
Worked with Machine Learning experts and Data Scientists to enable self-service data ingestion, transformation, visualization, reporting and advanced analytics (machine learning, AI).
Strategic thinker and thrive operating in a broad scope, from conception through a continuous operation.
Large enterprise database performance tuning experience
Strong communication skills
Experience directing other DBAs
Advanced SQL and PL/pgSQL programming skills, including concepts such as Covering Indexes, Triggers, Functions, Stored Procedures Materialized Views, etc.
Experience with Snowflake or other BI applications
Strong technical expertise in ML, AI, data preferred; experience working closely with data engineers, data science, and product teams to launch data products
Subject matter expert in all aspects of Data Management, Data Analytics and Operations Management