4+ Transact-SQL Jobs in India

 Exp in  product design and support experience
 Required Skills: Angular 11/12, .NET framework, .NET Core, Web APIs, Web Security,
Microservices, Event driven architecture, Clean Code and 12 Factor principles, Azure
PaaS services experience, public facing web application development, web analytics,
Bootstrap v5, Angular Material, jQuery, HTML/CSS, SQL Server, Transact-SQL, Azure
SQL
 Experience working with software design, software development life cycle, and
development methodologies and implementation
 Experience working with product systems design principles
 Experience working with appropriate programming languages, operating systems,
hardware and software
 Experience working with company application development policies and procedures
 Experience working with company software and hardware products and related
business issues that may impact overall business plans

We are looking for Young, Energetic and Experienced Professionals who can join our Team as Senior Database Developer.
• Experience in Database Development and Support in MS SQL Server environments.
• Hands-on End to End Database Development encompassing Database Design and Development
working with cross-functional teams.
• Hands-on experience of Transact SQL(T-SQL) utilizing SQL Server 2016 and above.
• Excellent understanding of T-SQL programming
• Hands-on experience in SQL - writing hands on experience in complex stored procedure, function,
triggers
• Sound knowledge of SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS)
• Develop, implement and optimize stored procedures and functions using T-SQL
Review and interpret ongoing business report requirements
• Analyze existing SQL queries for performance improvements.
• Develop procedures and scripts for data migration Provide timely scheduled manage

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:

1. Design conceptual and logical data models and flowcharts.
2. Improve system performance by conducting tests, troubleshooting, and integrating new elements.
3. Design and Build database systems of high availability and quality depending on each end user’s specialized role.
4. Help write and optimize in-application SQL statements.
5. Handle common database procedures such as upgrade, backup, recovery, migration, etc.
6. Ensure performance, security, and availability of databases.
7. Use high-speed transaction recovery techniques and backup data.
8. Provide proactive and reactive data management support and training to users.
9. Determine, enforce and document database policies, procedures, and standards.
10. Perform tests and evaluations regularly to ensure data security, privacy, and integrity.
11. Monitor database performance, implement changes, and apply new patches and versions when required.

Who Are We Looking For Exactly? 

1. 5+ years of experience in SQL Server Development with at least 1 year of Lead experience.
2. Advanced experience in database monitoring, troubleshooting, performance tuning, and high availability strategies for SQL Server 2016, SQL Server in Cloud (AWS RDS preferred).
3. Advanced skills in resolving database locking conflicts/blocking and resource utilization.
4. 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.
5. A thorough understanding of Performance Monitoring, Tuning, and Optimization, using native and third-party monitoring and troubleshooting tools.
6. 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).
7. Experience supporting SSIS, SSRS, replication, database mirroring (a plus).
8. PowerShell scripting experience with the ability to write automated scripts and strong knowledge of system tables and DMV’s is required. (a plus).
9. Administering Microsoft SQL Server databases in a high transaction, 24x7 database environment (a plus).
10. Experience in Postgres, No-SQL databases (a plus).
11. MCSA SQL Server 2012/2016 , MCSE or MCDBA (a plus).
12. 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

Roles and responsibilities:
1. To strive for continuous improvement of both technical and business knowledge
2. Engage proactively with stakeholders and other cross-functional team members in the
development of IT solutions
3. Ensure new database code meets company standards for readability,reliability and performance
4. Passionate about technology and applying it to business solutions
5. Work closely with business
The Ideal Candidate:
1. 3-6 years development experience with SQL SERVER / MySQL platforms
2. Strong Knowledge of T-SQL
3. A good understanding of data normalization,data modelling and database schema design
principals
4. Knowlegde of database optimization techniques
5. Monitor database performance , implement changes and apply new patches and versions when
required
6. Automate regular process, track issues and document changes
7. Assist developers with complex query tuning and schema refinement
8. Proven working experience as a Database administrator
9. Experience with backups,restores and recovery models

10. Knowledge of High-Availability (HA) and Disaster Recovery(DR) options for SQL Server
11. Experience on AWS technologies (RDS,EC2,EBS,S3,RedShift,Glue)
12. Experience in implementation & support of NoSQL technologies
redis,memcached,mongodb,elasticcache)
13. Hands on programming experience in Python
14. Ability to multi-task and work independently
15. Proficient in Waterfall & Agile development methodology especially when applied to stae-full
data environments
Good to have :
1. Experience with Financial Data, Capital Markets and Mutual funds industry/data
1. Working experience on Data Warehouse projects or exhibits sound knowledge over the concepts
1. Understanding of Distributed Systems and Parallel Processing architecture