DataBase Developer
IT-SBO -
Nasr City, CairoPosted 6 years ago30Applicants for1 open position
- 27Viewed
- 7In Consideration
- 20Not Selected
Job Details
Experience Needed:
Career Level:
Education Level:
Salary:
Job Categories:
Skills And Tools:
Job Description
Responsibilities:
- Design and deploy data table structures, forms, reports, and queries.
- Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.
- Applying third party upgrades to existing databases.
- Coordinate and work with other technical staff to develop relational databases and secondary databases (i.e. Access).
- Identify inefficiencies in current databases and investigate solutions. Diagnose and resolve database access and performance issues.
- Plan and coordinate data migrations between systems.
- Develop, implement, and maintain change control and testing processes for modifications to databases.
- Development and maintenance of the database stored procedures, views and functions for hosted web applications
- Ensure all database systems meet business and performance requirements
- Produce ad-hoc queries and develop reports to support business needs
- Creation and maintenance of technical documentation
- Development and maintenance of Data Warehouse
- Implementation of data dashboards to display data in differing formats
- Involve in Requirement gathering and analysis.
- Develop an enterprise-class system with multi-tier architecture
- Develop and understand data models and database structure for SQL server.
- Implement and test software/server upgrades as needed to gain better functionality
- Propose and implement database architectural changes to make database infrastructure highly scalable and optimized.
- Demonstrate SQL best practices in regard to security and privacy as well as design.
- Create SQL views, Common Table Expressions (CTEs) and stored procedures to combine/aggregate data needed for reporting purposes.
- Build custom data imports as required.
- Troubleshoot and problem solve SQL database issues.
Job Requirements
Job Requirements
- BSc in computer science
- 1-3 years of experience as Data Base developer
- In-depth understanding of data management (e.g. permissions, recovery, security and monitoring)
- Knowledge of software development and user interface web applications
- Excellent analytical and organization skills
- An ability to understand front-end users requirements and a problem-solving attitude is a plus
- Deep knowledge of SQL Server 2014/2016, design patterns, web and application servers.
- Very Good experience in using Business intelligence tools like SSIS, SSRS, SSAS and Power Bi.
- Very knowledgeable with SQL Server administration.
- Work in a SCRUM AGILE methodology.
- Good Experience in crystal report
- The ability to learn new development tools such as Visual Base
- The Data Modeler / Database/BI Developer will be responsible for the development and data architecture of multiple enterprise data management systems using SQL Server 2016 and Visual Base
- experience with data analysis, enterprise databases, business intelligence and reporting using crystal report