We are looking for a Senior Database Engineer to administrator and maintain NoSQL and relational SQL Server/MySQL Databases. The candidate will be part of the team providing operations support on multiple No SQL clusters running on Azure and will be responsible to install, configure, monitor, design, implement and support our mission critical MongoDB, Cosmos, Couchbase and SQL Server environments. The ideal candidate should be a fast learner, eager, passionate about automating development and production environments, and enjoy the challenge of working in a highly distributed and dynamic Hybrid Cloud environment. As part of service-oriented team, the role will require the individual to collaborate effectively with other internal engineering teams to gather requirements to deliver on various database platforms. There will be plenty of opportunities for developing your skills, as we look to improve constantly with the latest technologies.
Essential Responsibilities
Create, Administer, Monitor, and Maintain multiple Elasticsearch, MongoDB, and Cosmos and Couchbase environments.
Work with development teams to design and implement optimized NoSQL databases. Implement relational databases, tables, and table changes.
Support application development for problem solving and performance tuning.
Assist in administering, monitoring, and maintaining SQL Server environments, including for disaster recovery.
Work on new and existing logical/physical database designs for applications and infrastructure.
Provides after-hours support for database emergencies, routine scheduled maintenance, and database server patching.
Works closely with the business and engineering teams to understand and plan for storage and database needs.
Implementation, configuration, maintenance, and performance of SQL Server RDBMS systems, to ensure the availability and operational readiness (security, health, and performance) of our corporate applications in cloud (managing Cloud Infrastructure related to SQL Data Services in Azure).
Assist app dev teams with complex query tuning and schema refinement. Utilize various tools to evaluate performance and implement remedies to improve performance, including tuning database parameters and SQL statements.
Required Qualifications
7+ years of experience in working in Database, Data Management, or Engineering roles.
6+ years of progressive experience in high volume/high transaction data administration, with at least 3 years working with Microsoft Azure Cloud technologies.
6+ years of experience managing NoSQL databases such as Couchbase, MongoDB, CosmosDB. 2+ years of experience in ElasticSearch.
6+ years of experience in performance tuning and database monitoring utilizing techniques with query analysis, indexes, statistics, execution plans.
Prior experience working with large (2tb+) transactional databases and across a large environment with hundreds to thousands of databases in-scope.
DESIRED TECHNICAL SKILLS
Ability to troubleshoot performance issues with NoSQL databases (Elasticsearch, MongoDB, Cosmos and Couchbase)
Accurately recommend configuration changes for optimal performance of NoSQL databases (Elasticsearch, MongoDB, and Cosmos and Couchbase)
Experience in the design, testing, implementation, maintenance, and control of the organization's NoSQL databases across multiple platforms, technologies, (for example physical, relational and object oriented) and computing environments.
Ability to develop queries to extract information based on compounded search criteria.
Strong expertise with relational databases (Microsoft SQL Server, MySQL is a plus) with enhanced troubleshooting and performance tuning skills.
Fundamental proficiency in data modeling in practical applications of a moderate nature.
Firm understanding of the most prominent Azure database technologies such as Azure SQL Database and Azure SQL Managed Instance. Backup, restore, secure, scale, monitor and tune an Azure SQL Database
Experience translating environments into Azure Managed Instance and other Azure technologies will be given a strong preference.
Nice to Haves
Certifications in Azure/SQL Server/NoSQL
Experience with Postgres and MySQL is a big plus but not mandatory.
Knowledge of SQL monitoring tools SolarWinds DPA, RedGate etc.
