MS SQL Developer

SECURITAS GROUP

Securitas is a world-leading safety and security solutions partner that helps make your world a safer place. By leveraging technology in partnership with our clients, we offer a broad portfolio of value-enhancing services and solutions integrated across the security value chain from on-site services to advanced monitoring, comprehensive risk prediction, and advisory services.

With around 341,000 employees in 44 markets, our innovative, holistic approach with local and global expertise makes us a trusted business partner to many of the worlds best-known companies. Benefitting from almost nine decades of deep experience and guided by our values of integrity, vigilance, and helpfulness, we create sustainable value by helping our clients optimize their operations and protect what matters most - their people and assets.

Securitas IT in AMEA delivers IT services to our 12 countries within the region. We provide the technology needed to fulfill the Securitas business strategy to be client centric, data driven, and people focused. We transform, build, and protect our IT landscape in a professional and cost-efficient way. We are a diverse and inclusive team that all help each other out and have a great deal of fun together.

We are seeking a skilled Microsoft SQL Developer and Administrator with a strong foundation in database administration, design, development, and complex query preparation and optimization. In addition, you should have a basic understanding of Power BI and the ability to create modeling for dashboards and optimization. You should be comfortable in administering SQL databases for business applications, testing and validating the numbers for dashboards. Other than that, experience with Azure and SSIS technologies to enhance the data pipeline and cloud-based solutions is also something you should be familiar with.

• Developing and maintaining SQL scripts and complex queries for data extraction. Developing stored procedures and functions to generate various drill-through reports, matrix reports through SSRS, and generate various views to support business requirements.

• Optimizing database performance through indexing, query tuning, and data modeling. Working closely with the Finance function to enhance existing tools and data architecture supporting reporting.

• Translating business requirements into technical solutions.

• Collaborating with business users to understand data requirements and translate them into effective database solutions.

• Performing thorough testing of Power BI dashboards to ensure data accuracy, consistency, and performance.

• Developing and maintaining data pipelines using Azure Data Factory, SSIS, and ETL.

• Migrating existing data workloads to Azure Cloud platforms.

• Optimizing data pipelines for performance and scalability.

• Identifying and resolving data quality issues and inconsistencies.

• Working closely with the reporting team to ensure data integration and alignment with business requirements.

• Staying up to date with the latest SQL, Power BI technologies, and best practices.

In addition to SQL development, you would also perform database administration tasks, such as:

• Managing SQL server databases for critical applications, configuring and maintaining database servers and processes, and monitoring systems health and performance.

• Ensuring high levels of performance, availability, sustainability, and security.

• Analyzing, solving, and correcting issues in real-time.

• Managing database consistency between DC and DR environments via RHA technology.

• Refining and automating regular processes, tracking issues, and documenting changes.

• Performing scheduled maintenance and support release development activities after business hours.

• Proven experience in SQL development, including writing complex queries, stored procedures, and functions.

• Experience in managing and administering SQL databases in a business-critical environment.

• Strong understanding of database design principles and normalization.

• Knowledge in Power BI, including data modeling and optimization.

• Experience with Azure cloud platform and Azure Data Factory or SSIS.

• Experience in testing and validating data-driven applications.

• Excellent analytical and problem-solving skills.

• Attention to detail and ability to work independently.

• Strong communication and interpersonal skills.

• Experience with data warehousing and ETL processes.

• Understanding of Agile development methodologies.

Location: Gurugram, India

At Securitas, we believe in doing the right thing and doing it well. For our customers and our employees. Our employees come from all walks of life and bring with them a multitude of talents and perspectives. We aim for diverse representation throughout the company, and we are committed to equal pay, safe working conditions, gender balance, and an inclusive work environment with a wide range of skills and development opportunities.

If this sounds good to you, dont hesitate and apply

Locations - Gurugram, India