SCOPE OF RESPONSIBILITIES:
Perform SQL Server/Oracle database administrative tasks in various SQL Server and Oracle database environments.
Work on technologies application development.
Maintain and support multiple projects and deadlines.
Document existing solutions and identify urgent fix/upgrade needs and address the same.
Help multiple teams of developers to design develop and help with performance tuning and writing good SQL.
Expected to perform tasks including but not limited to writing SQL Queries Stored procedures ETLs and perform ETL development work and hands-on SQL Server / Oracle programming Data architecture Linux / UNIX programming.
AI experience would be a plus!
SKILLS:
Ability to complete all phases of software development life cycle including analysis design functionality testing and support.
Ability to design develop and maintain small to large scale databases.
Excellent knowledge of Transact SQL MS SQL and MySQL.
Excellent knowledge of writing Stored procedures user/authentication management performance tuning linked servers ETL SSRS SSIS.
Proven experience with technologies including .
Python development.
Ability to work on multiple projects with multiple deadlines.
Ability to communicate clearly with developers business users and project managers.
Ability to construct user guides and documentation.
Project Management skills are a plus.
Creating and maintaining ETL jobs.
QUALIFICATIONS & RELATED EXPERIENCE:
7 to 10 years of actual experience in the workplace.
Databases: SQL Server Oracle. DB2 will be a plus.
Experience with web application connections and configuration with databases.
Minimum 5 to 8 years in backend software design in SQL Server Stored procedures SQL/T-SQL.
User/authentication management performance tuning linked servers ETL SSRS SSIS.
Development experience with technologies including .
Languages: C# SQL/T-SQL JavaScript/DHTML VBScript HTML XML.
MVC C# Core Python.
Windows Linux with Shell scripting experience is desirable.