Database Design Jobs in Pune
We are looking for a Senior Microsoft SQL Developer to design, develop, test, plan, implement and maintain conceptual and logical database models.
For this role, you should know how to analyze system requirements and implement migration methods for existing data. Hands-on experience with SQL Server 2012 and above is also required. Ideally, you are familiar with database design, reviewing code, writing stored procedures, creating and modifying SQL agent jobs, making structural changes to tables and views.
Ultimately, you will develop database solutions to ensure project information is stored effectively and securely.
We’re a fast-growing company with clients in the United States, UK, and Australia. You will join a team of talented developers, quality engineers, product managers whose mission is to impact above 100 million people across the world with technological services by the year 2030.
Working as Senior Microsoft SQL Developer at Navtech, you will:
- Design conceptual and logical data models and flowcharts.
- Improve system performance by conducting tests, troubleshooting, and integrating new elements.
- Design and Build database systems of high availability and quality depending on each end user’s specialized role.
- Help write and optimize in-application SQL statements.
- Handle common database procedures such as upgrade, backup, recovery, migration, etc.
- Ensure performance, security, and availability of databases.
- Use high-speed transaction recovery techniques and backup data.
- Provide proactive and reactive data management support and training to users.
- Determine, enforce and document database policies, procedures, and standards.
- Perform tests and evaluations regularly to ensure data security, privacy, and integrity.
- Monitor database performance, implement changes, and apply new patches and versions when required.
- 5+ years of experience in SQL Server Development with at least 1 year of Lead experience.
- Advanced experience in database monitoring, troubleshooting, performance tuning, and high availability strategies for SQL Server 2016, SQL Server in Cloud (AWS RDS preferred).
- Advanced skills in resolving database locking conflicts/blocking and resource utilization.
- Ability to work with other developers and engineers to analyze database performance and identify problems in areas such as execution plans, index coverage, and SQL server statistics.
- A thorough understanding of Performance Monitoring, Tuning, and Optimization, using native and third-party monitoring and troubleshooting tools.
- Advanced knowledge of SQL Server Disaster Recovery (DR) options, Always On availability groups, and experience administering Windows Server, including Active Directory, Failover clustering, database partitioning, security, and encryption (a plus).
- Experience supporting SSIS, SSRS, replication, database mirroring (a plus).
- PowerShell scripting experience with the ability to write automated scripts and strong knowledge of system tables and DMV’s is required. (a plus).
- Administering Microsoft SQL Server databases in a high transaction, 24x7 database environment (a plus).
- Experience in Postgres, No-SQL databases (a plus).
- MCSA SQL Server 2012/2016 , MCSE or MCDBA (a plus).
- Should have excellent logical, analytical, and communication skills with client interaction experience.
Benefits
- Working with industry giants while following your passion for technology.
- Competitive pay package with additional bonus and benefits.
- Performance review and Appraisal Twice a year.
- Family Health Insurance cover for self and family.
- Work with US, UK, and Europe-based industry-renowned clients for exponential technical growth.
- Work with a culturally diverse team from different geographies
Our ideal candidate is someone who is an exceptional JS developer with significant experience on React and Node. You should be able to build and support complex applications single-handedly with a keen eye towards UX, design, security and performance. Additionally you will need to have a basic understanding of microservices, API integrations to aid in achieving our vision of building the most robust and scalable integration platform in the B2B Retail + Food verticals. You will be responsible for architecture, design and implementation of the entire system to support thousands of customers globally. Our stack is primarily built around Node, PHP, React, Angular, Mongo, PHP and advanced Infra and DevOps tools such as Kubernetes, Grafana, Prometheus, ELK and more.
Mentoring should come naturally to you, as well as finding the right balance towards process and documentation.
Highlights:
1) You will be working on interesting technical challenges in a product centric and open-source driven environment.
2) You will help set a very high bar on code quality with a focus on test driven development and writing highly performant, fault tolerant and secure code.
3) You will take ownership of product features from conception to implementation, testing deployment and support.
4) A lot of freedom on when and where you work from - just get stuff done.
5) You will open source as much as possible, and blog about cool things that you learnt and built.
6) You will help define who we become as a company.
7) You will get stock options in line with silicon valley standards.
Caveats:
1) We have a strict no-divas rule. There are a lot of smart engineers on the team but no one with an attitude / superiority complex.
2) If you think writing tests for your code, writing docs, doing customer support etc are not your cup of tea, this isn't the right role for you.
3) Similarly, if you're viewing this just as a 20-40% increment opportunity over your current compensation, this isn't the right role or company for you.
This role can be the growth opportunity of a lifetime for anyone who has been operating as a backend lead and wants to grow into a fullstack CTO. Check out the links below if you'd like to learn more about us. We encourage people from underrepresented groups to apply.
1) Why ShoppinPal? - https://www.youtube.com/watch?v=cE7DgtwA0ws" target="_blank">https://www.youtube.com/watch?v=cE7DgtwA0ws
2) Our hiring philosophy and process http://techstory.in/building-startup-team/" target="_blank">http://techstory.in/building-startup-team/
3) Our culture- https://www.shoppinpal.com/culture
Main Duties
Contribute in all phases of the development lifecycle
Write well designed, testable, efficient code
Ensure designs are in compliance with specifications
Support continuous improvement by investigating alternatives and technologies and presenting these for architectural review
Prepare and produce releases of software components
Role & Relationships
We consider ourselves a team & you will be a valuable part of it. You could be reporting to a Senior member or directly to our Founder, CEO
Educational Qualifications
We don’t discriminate. As long as you have the required skill set & the right attitude
Experience
Upto 6 years of experience, preferably working on Java. Freshers are welcome too!
Skills
Good
Strong understanding of Core Java , Servlet, JSP
Knowledge of RDBMS (MySQL, Oracle, SQL Server), NoSQL
Knowledge of RESTful Web Services, XML, JSON
Good team player
Even better
Familiarity with the software development lifecycle
Strong Full stack developer development background with frontend and backend web applications
Competencies
An aptitude to solve problems & learn something new
Highly self-motivated
Analytical frame of mind
Ability to work in fast-paced, dynamic environment
Location
Currently in Pune
Remuneration
Once we meet, we shall make an offer depending on how good a fit you are & the experience you already have
About us
Aikon Labs Pvt Ltd is a start-up focused on Realizing Ideas. One such idea is iEngage.io, our Intelligent Engagement Platform. We leverage Augmented Intelligence, a combination of machine-driven insights & human understanding, to serve a timely response to every interaction from the people you care about.
Get in touch
