Job Details
Experience Needed:
Career Level:
Education Level:
Salary:
Job Categories:
Skills And Tools:
Job Description
Main Duties:
- Create and manage multiple databases and assist in capacity planning.
- Monitor, maintain database systems and troubleshoot problems that may arise.
- Maintain data integrity and security (manage roles and permissions of database users).
- Maintain database tuning.
- Develop strategies and implement solutions for managing back-ups, restoration and replication.
- Support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures.
- Support operation team by responding to operation incidents and service requests.
- Proactive housekeeping, archiving and shrinking of databases.
- Manage production, QA and development database environments.
- Create detailed documentation including diagrams of database infrastructure.
- Learn relevant business processes and understand the data flow, criticality and dependencies.
- Effectively coordinate and communicate with all the stakeholders (internal teams and clients).
- Set up and maintain database infrastructure for the company’s BI and reporting needs.
Job Requirements
- Not Less than 5 years’ experience in administering and working with oracle and Microsoft RDBMS
- Bachelors or Master’s degree in computer science or equivalent education and experience.
- Oracle DB certified associate level (11g or 12c) is a must
- Sound knowledge of RDBMS concepts, database architecture
- Sound knowledge of windows and Unix OS and storage components.
- Experience writing PL/SQL and T-SQL stored procedures, query tuning on high transaction systems.
- Experience in ETL development / data integration.
- Experience in monitoring and troubleshooting database activity.
- Experience in query and database tuning.
- Experience in implementing operational automation.
- Experience using HA and DR technologies including RAC, Data-Guard, mirroring, log shipping, fail-over cluster and various replication technologies
- Knowledge of other RDBMS like MySQL and NoSQL databases and In-memory databases
- Knowledge of application server administrations
- Knowledge of working with report server
- Knowledge in a scripting language like PowerShell, UNIX shell
- Ability to develop procedure documents and maintain detailed database related documents.
Featured Jobs
Similar Jobs
- Senior Database AdministratorFawry for Banking Technology and Electronic Payments S.A.E - Smart Village, Giza3 days ago