Browse Jobs
For Employers
Post JobLog inGet Started

Network Architect & Database Developer

Egyptian Red Crescent
Nasr City, Cairo
Posted 6 years ago
26Applicants for1 open position
  • 1Viewed
  • 0In Consideration
  • 0Not Selected
Search other opportunities

Job Details

Experience Needed:
Career Level:
Education Level:
Salary:
Job Categories:

Skills And Tools:

Job Description

  • Creating complex queries on large data sets
  • Creating stored procedures, triggers, and functions
  • Generating codes to extract, transform, and load data from miscellaneous (e.g. XML, flat files...) data sources to SQL Server or Non-SQL Databases
  • Perform on-going tuning for the database engines and instances to improve performance.
  • Plan and implements backup and recovery for the database to protect data against any failures.
  • Reporting required statistics to upper management.
  • Creating database integration processes between multiple DB engines and objects.
  • Good knowledge of console application and web applications.
  • Mentor and develop junior team members of system engineers as required.
  • Pro actively monitor system capacity and produce regular capacity planning reports to show current systems capacity utilization and growth trends, to add capacity as needed.
  • Take lead in resolving operational issues, perform root cause analysis, and implement necessary corrective actions to prevent re-occurrence.
  • Install, upgrade, monitor, and maintain the relevant Database to keep it at high level of availability.
  • Identify and recommend database techniques to support business needs.
  • Troubleshoot problems regarding the databases, applications and development tools to keep the high level of systems availability and data consistency.
  • Maintain the relevant database high availability and disaster recovery procedures using HA tools that manage different DB nodes access and undertake better availability.
  • Administer all database objects, including tables, clusters, views, sequences, packages and procedures.
  • Create and manage multiple databases and assist in capacity planning.
  • Maintain data integrity and security (manage roles and permissions of database users).
  • Support operation team by responding to operation incidents and service requests.
  • Setup and maintain database infrastructure for the company’s BI and reporting needs.
  • Create detailed documentation including diagrams of database infrastructure.
  • Effectively coordinate and communicate with all the stakeholders (internal teams and clients).
  • Reviewing current systems, and Presenting ideas for system improvement.
  • Make sure a database is operational, and providing valid and relevant data.
  • Establishes networking environment by designing system configuration; directing system installation; defining, documenting, and enforcing system standards.
  • Maximizes network performance by monitoring performance; troubleshooting network problems and outages; scheduling upgrades; collaborating with network architects on network optimization.
  • Secures network system by establishing and enforcing policies; defining and monitoring access.
  • Reporting network operational status by gathering, prioritizing information; managing projects.
  • Ensure security of data, network access and backup systems
  • Act in alignment with user needs and system functionality to contribute to organizational policy
  • Configuring and installing various network devices and services (e.g., routers, switches, firewalls, load balancers, VPN, QoS).
  • Performing network maintenance and system upgrades including service packs, patches, hot fixes and security configurations.
  • Troubleshoot and resolve problems encountered by end users of various areas such as, desktop systems, user’s applications, ERP applications, co-location network communications, Internet and other computer technology.
  • Fixing problems and proactive to in trying anticipate likely problems, find malfunctions, interruptions or network such as communications, revision levels, compatibility, configurations and capacities.
  • Installing, configuring, maintenance and troubleshooting network systems.

Job Requirements

  • B.Sc. in Computer Science or equivalent from a reputable university.
  • Good command of both written and spoken English.
  • 4+ years of related experience.
  • Expert skills in SQL programming, stored procedure, writing, debugging, and tuning.
  • Experience in data modeling and database design and being well versed with SQL Server best practices.
  • Hands-on SQL-XML programming skills
  • XML extraction and transformation
  • Big data analytics concepts (preferred)
  • Experience with modeling tools and productivity tools.
  • Experience in monitoring and troubleshooting database activity.
  • Experience in query and database tuning.
  • Experience in implementing operational automation.
  • Knowledge of application server administrations.
  • Knowledge in a scripting language like PowerShell.
  • Ability to develop procedure documents and maintain detailed database related documents.
  • Deep knowledge of computer programming and data manipulation techniques
  • Excellent knowledge of Database Performance Tuning
  • Proficient with Database Backups, Recovery and clustering
  • Support during Deployments
  • Strong DBA skills Microsoft SQL Server.
  • Database engineering and architecture skills are required
  • Ability to document processes.
  • Has the ability to suggest and provide IT solutions to business and management problems.
  • An understanding of confidentiality and data protection issues.
  • Experience in Enterprise Resource Planning (ERP) and Document Management (DMS) systems.
  • Expert-level Microsoft Windows Server OS administration.
  • In-depth knowledge of Microsoft Internet Information Service 6, 7, 7.5, and 10.
  • Excellent knowledge of Microsoft SQL server 2008 R2, 2012, and 2014.
  • Good knowledge of Microsoft SharePoint Services 2010, 2013, and SharePoint online.
  • In-depth knowledge of Active Directory and Domain Name System.
  • In-depth knowledge of Microsoft products.
  • In-depth knowledge of Network.
  • In-depth knowledge of virtualization technology (Microsoft Hyper-V).
  • Security+ required.
  • Microsoft Certified Systems Engineer (MCSE).
  • Cisco Certified Network Professional (CCNP).
  • Project Management, Network Design and Implementation, Network Troubleshooting, Network Hardware Configuration, Network Performance Tuning.
  • Strong technical knowledge in IP, WAN, LAN, VPN connectivity
  • Working Experience with Cisco technologies.
  • Excellent communication, organizational and interpersonal skills required.
  • Very Good Presentation, analytical & Problem Solving Skills.
  • Ability to work under pressure and handling multi tasks at a time.
  • Ability to work with a team environment.

Featured Jobs

Similar Jobs

Search other opportunities
JobsIT/Software DevelopmentNetwork Architect & Database Develop...