Database Engineer
Published date: 2024/01/10
- Location: Work from home, Anywhere, India
General Description:
The purpose of this job is to focus on the integration of various platforms, both internally and externally developed, into an efficient omnichannel platform.
Minimum Work Experience
Bachelor of Science Degree with 2-3 years of programming experience or equivalent.
Minimum 2 years of experience developing applications in MS SQL and ETL processes. Knowledge of Salesforce (Optional)different ETL techniques a plus.
Required Technical Skills
• Required Languages: TSQL JSON, XML.
• Technologies: MS SQL Server 2016; Azure
• Strong SQL experience with managing SQL server 2016
• Some experience in Azure environment + Azure DevOps exposure will be helpful
Additional Technical Skills
• Required Languages: TSQL, Knowledge of Triggers, Stored Procedures & Functions are more important.
• Technologies: SQL Server 2016, Always On Availability Groups, GIT, Azure Dev Ops, and other continuous development tools, Microsoft Office, and others as needed.
Primary Responsibilities:
The activities which the person will be directly held accountable for are broken into the following main areas and include:
• Meet the client’s standards for application and database development.
• Work in various team workflows including Agile and Waterfall. Work with functional groups and project management to ensure that the plan reflects the milestones and timing of the projects.
• Document technical designs using Erwin diagrams, flowcharts, data flow diagrams, descriptive software component documentation, etc. as required.
• Design, review, analyze, and provide feedback on data models, ETL and application processes designed to meet the business use cases and workflows.
• Develop database objects, including tables, views, functions, and stored procedures to support business processes.
• Maintain data management compliance and best practices.
• Evaluation of data sets to determine keys and other relationships within the dataset and recommend structures and processes based on the data and business needs.
• Ability to identify, analyze, and resolve database and application performance issues.
• Manage and monitor database backups.
• Manage SQL servers, monitor usage and make and execute efficiency changes.
• Deploy changes to production databases.
• Troubleshooting issues with automated processes and execute changes as needed.
• Performs code review sessions with other developers and suggests improvements or alternative strategies when appropriate.
• Work with internal teams to perform maintenance and upgrades to SQL Servers.
• Creation and maintenance of testing of ETL and data processing processes.
• Review business requirements and suggest solutions based on industry and best practices.
• Learn and implement new software and hardware tools as appropriate.
• Support of internal hardware and software applications through problem-solving/recommendations.
•
The purpose of this job is to focus on the integration of various platforms, both internally and externally developed, into an efficient omnichannel platform.
Minimum Work Experience
Bachelor of Science Degree with 2-3 years of programming experience or equivalent.
Minimum 2 years of experience developing applications in MS SQL and ETL processes. Knowledge of Salesforce (Optional)different ETL techniques a plus.
Required Technical Skills
• Required Languages: TSQL JSON, XML.
• Technologies: MS SQL Server 2016; Azure
• Strong SQL experience with managing SQL server 2016
• Some experience in Azure environment + Azure DevOps exposure will be helpful
Additional Technical Skills
• Required Languages: TSQL, Knowledge of Triggers, Stored Procedures & Functions are more important.
• Technologies: SQL Server 2016, Always On Availability Groups, GIT, Azure Dev Ops, and other continuous development tools, Microsoft Office, and others as needed.
Primary Responsibilities:
The activities which the person will be directly held accountable for are broken into the following main areas and include:
• Meet the client’s standards for application and database development.
• Work in various team workflows including Agile and Waterfall. Work with functional groups and project management to ensure that the plan reflects the milestones and timing of the projects.
• Document technical designs using Erwin diagrams, flowcharts, data flow diagrams, descriptive software component documentation, etc. as required.
• Design, review, analyze, and provide feedback on data models, ETL and application processes designed to meet the business use cases and workflows.
• Develop database objects, including tables, views, functions, and stored procedures to support business processes.
• Maintain data management compliance and best practices.
• Evaluation of data sets to determine keys and other relationships within the dataset and recommend structures and processes based on the data and business needs.
• Ability to identify, analyze, and resolve database and application performance issues.
• Manage and monitor database backups.
• Manage SQL servers, monitor usage and make and execute efficiency changes.
• Deploy changes to production databases.
• Troubleshooting issues with automated processes and execute changes as needed.
• Performs code review sessions with other developers and suggests improvements or alternative strategies when appropriate.
• Work with internal teams to perform maintenance and upgrades to SQL Servers.
• Creation and maintenance of testing of ETL and data processing processes.
• Review business requirements and suggest solutions based on industry and best practices.
• Learn and implement new software and hardware tools as appropriate.
• Support of internal hardware and software applications through problem-solving/recommendations.
•
0 page views
Related listings
-
The best part is you can start online data entry jobs from today without...SAVE IDatabase AdministratorOn the other hand, the employee will be assigned a task and a deadline of the work. In this there is no need to keep login to the companys website for doing work. In online data entry jobs without investment daily payment, an employee can download th...2026/11/07
-
Freelance Database ManagerDatabase AdministratorFreelance Database Manager. We are looking for a highly capable Freelance Database Manager to enhance the performance of our organization's database. You will be creating and implementing standardized database management procedures, and overseeing th...2024/01/10
-
Documentum AdministratorDatabase AdministratorEssential Duties and Responsibilities: · Provide support for development, implementation, and migration of Documentum applications from lower environments through production environments. · Support activities such as app checkouts, upgrades, patching...2024/01/10