Database Specialist

SNC-Lavalin

Gurgaon, Haryana
Permanent
Full-time

30 days ago

Job DescriptionWe’re AtkinsRéalis, a world-leading Design, Engineering and Project Management organization. Created by the integration of long-standing organizations dating back to 1911, we are a world-leading professional services and project management company dedicated to engineering a better future for our planet and its people. We create sustainable solutions that connect people, data and technology to transform the world's infrastructure and energy systems. We deploy global capabilities locally to our clients and deliver unique end-to-end services across the whole life cycle of an asset including consulting, advisory & environmental services, intelligent networks & cybersecurity, design & engineering, procurement, project & construction management, operations & maintenance, decommissioning and capital. The breadth and depth of our capabilities are delivered to clients in key strategic sectors such as Engineering Services, Nuclear, Operations & Maintenance and Capital.News and information are available at or follow us on LinkedIn.Our teams are proud to deliver on some of the most prestigious projects across the world. It's thanks to our talented people and their diverse thinking, expertise, and knowledge. Join us and you'll be part of our genuinely collaborative environment, where everyone is supported to make the most of their talents and expertise.
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’.Experience and Primary Skills:

10+ years of working experience as a Database Specialist
SQL Server DB Data modelling
Experience working with data security practices and available security software packages
Knowledge of network architecture to develop, implement and maintain highly efficient network systems
Exposure in Graph Database, Document DB and other NoSQL DB
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

Basic Skills

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.
Knowledge of Azure Function, Azure Data Factory.
Database programming (Stored Proc , Functions , triggers , etc)

What We Can Offer You

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.

Why work for AtkinsRéalis?We at AtkinsRéalis are committed to developing its people both personally and professionally. Our colleagues have the advantage of access to a high ranging training portfolio and development activities designed to help make the best of individual’s abilities and talents. We also actively support staff in achieving corporate membership of relevant institutions.Meeting Your NeedsTo help you get the most out of life in and outside of work, we offer employees ‘Total Reward’.
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.

SNC-Lavalin

Apply Now