DBA Expert - Oracle, Cassandra DB
DBA Expert - Oracle, Cassandra DB
Posibility to work remotely, Romania
Job Ref. Number
We are looking for a DBA Expert for our team in Romania
- Participates in the development and implementation of software solutions / programs in accordance with customer requirements and job competencies.
- Contributes to the implementation of new IT projects in all stages including the definition of requirements, planning, analysis, estimation and setting priorities and ensures the implementation and testing of software solutions.
- Creates scripts / programs at the database level (PL-SQL, TSQL, Perl, etc.) according to customer requirements or business needs.
- Coordinates highly complex technical activities and assists less experienced colleagues when needed.
- Participates in all stages of IT projects contributing to the implementation of new software solutions by:
- Defining technical requirements
- Evaluation of different IT solutions
- Code / script development
- Implementation of IT applications / platforms in accordance with the competencies of the role
- Develops scripts and programs for IT projects and for automating activities.
- Defines technical requirements, designs, configures and implements solutions that include databases.
- Ensures the optimization of existing solutions by redefining the architecture of the bases in order to increase efficiency or meet new business requirements.
- Provides active support for transformation projects as well as for other technology refresh programs that have the role of ensuring / increasing the availability of services and reducing downtime as well as increasing the quality / performance of applications.
- Designs and modifies the structure of databases by encoding the description of data using relational database management systems
- In case of critical incidents, it carries out technical investigations and analyzes the problems that appeared in order to determine the causes and ensures / proposes solutions to remedy the detected problems.
- Within 10-15% of the time perform proactive maintenance activities based on automatic working tools, alerts and notifications.
- Within 10% of the time it contributes to the evaluation of new technologies or applications in order to adopt them in new projects (POC - proof of concept)
- Participate in 24x7 on-call and hotline services, or shifts, as appropriate.
- Availability for exceptional situations, when asked to work night shifts, to work overtime and standby, as needed.
Competences, knowledge and experience:
- Experience in IT infrastructure management> 10 years
- Office IT systems and technology (hardware and software) - expert level
- Robust documentation capabilities
- Problem solving skills
- Working skills under tight conditions and tight deadlines
- Well organized, setting priorities and rigorous
- Project management
- Effective management of multiple requests; results orientation
- Skills in distributed and remote teams
- Customer orientation; ability to positively influence the customer experience
- English (written and spoken) - fluent
Required technical / professional certifications:
- Knowledge of database administration and programming in a production environment, at expert level: Oracle & Cassandra.
- Very good programming knowledge in PL / SQL and UNIX / Linux shell
- Highly advanced knowledge of SQL tuning
- Very good knowledge of Oracle RAC, Data Guard, GRID / Cloud Control, RMAN, Datapump, Goldengate, Shareplex, etc. technologies.
- ITIL knowledge
- Understanding the concepts of IT Service Management (ISO20000 standard example)
- Good knowledge of SOX principles
- Very good knowledge of general security principles
- SQL / PLSQL programs according to customer requirements
- Scripts (shell scripting / powershell / perl) for automation, backup, monitoring and data transfer of new IT solutions or data integrity checking
- Database upgrade programs, scripts and procedures
- Design of database structures by encoding the description of the data
- Software applications (sql, plsql, php, html etc.) and databases;
- Code modules in programming languages (sql, plsql) using integrated development environments;
- Documentation related to software application development and implementation projects according to the project framework established by the clients (where applicable)
- Documentation specific to internal processes (eg change management)