Job Details
Experience Needed:
Career Level:
Education Level:
Salary:
Job Categories:
Skills And Tools:
Job Description
- Design stable, reliable and effective databases.
- Optimize and maintain legacy systems.
- Modify databases according to requests and perform tests.
- Solve database usage issues and malfunctions.
- Liaise with developers to improve applications and establish best practices.
- Gather user requirements and identify new features.
- Develop technical and training manuals.
- Provide data management support to users.
- Ensure all database programs meet company and performance requirements.
- Research and suggest new database products, services and protocols.
- Reviewing query performance and optimizing code.
- Writing queries used for front-end applications (websites, desktop applications, or cloud apps).
- Working with application developers to create optimized queries.
- Creating table indexes to improve database performance.
- Programming views, stored procedures, and functions.
- Create Entity Relationship (ER) Diagrams to the proposed database.
- Create database objects such as tables, views, stored procedures, Triggers etc.
- Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
- Identify columns for Primary Keys in all the tables at the design time and create them.
- Create functions to provide custom functionality as per the requirements.
- Be aware of potential blocking, deadlocking and write code to avoid those situations (Isolation Levels).
- Endure that the code is written keeping in mind any security issues such as SQL Injection.
- Design, Develop and Deploy SSIS Packages
Job Requirements
- Bachelor's degree in computer science or related field.
- 3-5 years’ experience with Microsoft SQL Server or Oracle.
- In-depth understanding of data management (e.g. permissions, recovery, security and monitoring).
- Knowledge of software development and user interface web applications.
- Hands on experience with T-SQL or PL/SQL.
- Excellent analytical and organization skills.
- An ability to understand front-end user’s requirements and a problem-solving attitude.
- Excellent verbal and written communication skills.
- Knowledge of Replications and Clustering.
Featured Jobs
Similar Jobs
- Senior Database AdministratorFawry for Banking Technology and Electronic Payments S.A.E - Smart Village, Giza3 days ago