Tech Lead (SQL)
Stratacent
Charing Cross, United Kingdom
4 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
SeniorJob location
Remote
Charing Cross, United Kingdom
Tech stack
Business Software
Databases
Data Integrity
ETL
Data Mining
Data Warehousing
Relational Databases
Python
PostgreSQL
Microsoft SQL Server
MySQL
Oracle Applications
Performance Tuning
Shell Script
SQL Stored Procedures
PL-SQL
SQL Databases
T-SQL
Data Storage Technologies
Job description
We are looking for a skilled Tech Lead to design, develop, and maintain robust SQL databases and queries to support business applications and analytics. You will work closely with data analysts, application developers, and stakeholders to ensure efficient data storage and access., * Develop complex SQL queries, stored procedures, views, and functions.
- Optimize and tune SQL queries for performance.
- Design and maintain relational databases and data models.
- Perform data extraction, transformation, and loading (ETL).
- Ensure data integrity, accuracy, and security.
- Troubleshoot database-related issues and implement solutions., * Develop complex SQL queries, stored procedures, views, and functions.
- Optimize and tune SQL queries for performance.
- Design and maintain relational databases and data models.
- Perform data extraction, transformation, and loading (ETL).
- Ensure data integrity, accuracy, and security.
- Troubleshoot database-related issues and implement solutions
Requirements
Postgresql, Analytical Skills, Etl Tools, Normalization, Microsoft Sql Server, Mysql, Sql, Oracle, Performance Tuning, Rdbms, * Strong proficiency in SQL (T-SQL/PL-SQL).
- 2+ years of experience as a Tech Lead is preferred.
- Experience with RDBMS like Microsoft SQL Server, Oracle, MySQL, PostgreSQL.
- Knowledge of ETL tools and processes.
- Familiarity with data warehousing concepts.
- Understanding of indexes, joins, normalization, and performance tuning.
- Basic knowledge of Python/Shell scripting (optional but a plus).
- Good communication and analytical skills.
About the company
Stratacent is an IT Managed Services firm, headquartered in Jersey City, NJ, with two global delivery centres in New York City area and New Delhi area plus offices in London, Canada and Pune, India.
We are a leading IT services provider focusing in Financial Services, Insurance, Healthcare and Life Sciences. We help our customers in their digital transformation journey and provide solutions around cloud infrastructure, containers, AI, Client & Analytics and Automation.
We have partnerships with SAS, Automation Anywhere, Snowflake, Azure, AWS and GCP.
(To learn more: www.stratacent.com ).
Stratacent is an equal opportunity employer. As such, to the extent defined by federal, state, and municipal law, Stratacent will not discriminate against any employee or applicant for employment on the basis of race, color, creed, religion, age, sex, national origin, ancestry, handicap, or any other factor protected by law