Database Specialist
SNC-Lavalin
- Gurgaon, Haryana
- Permanent
- Full-time
When it comes to work-life balance, AtkinsRéalis is a great place to be. So, let's discuss how our flexible and remote working policies can support your priorities. We're passionate about are work while valuing each other equally. So, ask us about some of our recent pledges for Women's Equality and being a 'Disability Confident' and 'Inclusive Employer’.Requirements
- 10+ years of working experience as a Database and BI Developer
- In depth knowledge of modeling/architectural patterns and governance methodologies in SQL Server
- Perform SQL Server database level maintenance, optimization, integrity checks, recovery, and handling failover of databases
- Implement and monitor backups of SQL databases using both native functionality, as well commercial packages
- Database performance tuning including identifying bottlenecks with suitable workarounds.
- Optimization of exiting database & business logic source code.
- Implement and perform database encryption algorithms
- Automate and perform database restores/system refreshes of non-Production environments using Production data.
- Recommend and implement best practices for Rest API integration framework/model
- Understand and translate business requirements into technical specifications and build elegant, efficient, and scalable solutions based on specifications
- Experience working with industry standards, regulations and guidelines in database warehousing and other relevant systems
- Experienced in databases like SQL Server, Oracle, MongoDB.
- Experienced in ETL/ELT tools like SSIS, Azure Function, Azure Data Factory.
- Experienced in Azure Function, Azure Data Factory
- Experience working with data security practices and available security software packages.
- Knowledge of network architecture to develop, implement and maintain highly efficient network systems
- Advanced knowledge of Database and Table Partitioning
- Advanced knowledge of database design including table structure, data types, index management, and permissions.
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server including Windows Server clustering and transaction database replication
- SQL Server DB Data modelling
- Database programming (Stored Proc , Functions , triggers , etc)
- SSIS, Azure Function, Azure Data Factory
- Exposer in Graph Database
- Varied, interesting and meaningful work.
- A hybrid working environment with flexibility and great opportunities.
- Opportunities for training and, as the team grows, career progression or sideways moves.
- An opportunity to work within a large global multi-disciplinary consultancy on a mission to change the ways we approach business as usual.
Making sure you're supported is important to us. So, if you identify as having a disability, tell us ahead of your interview, and we’ll discuss any adjustments you might need.
Additional Information
We are an equal opportunity, drug-free employer committed to promoting a diverse and inclusive community - a place where we can all be ourselves, thrive and develop. To help embed inclusion for all, from day one, we offer a range of family friendly, inclusive employment policies, flexible working arrangements and employee networks to support staff from different backgrounds. As an Equal Opportunities Employer, we value applications from all backgrounds, cultures and ability.We care about your privacy and are committed to protecting your privacy. Please consult our on our Careers site to know more about how we collect, use and transfer your Personal Data.Link:Worker Type EmployeeJob Type RegularAt AtkinsRéalis, we seek to hire individuals with diverse characteristics, backgrounds and perspectives. We strongly believe that world-class talent makes no distinctions based on gender, ethnic or national origin, sexual identity and orientation, age, religion or disability, but enriches itself through these differences.