
Sr. NoSQL Engineer/Administrator
- Noida, Uttar Pradesh
- Permanent
- Full-time
- Create, Administer, Monitor, and Maintain multiple Elasticsearch, MongoDB, and Cosmos and Couchbase environments.
- Work with development teams to design and implement optimized NoSQL databases.
- 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.
- 8+ 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.
- 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.
- 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.
- Service now and Azure DevOps experience