Dba access freelance : Principaux profils disponibles et dernières missions publiées

Exemple de missions de Petre,
Dba access habitant la Moselle (57)

• _DBA Oracle

  TELINDUS Luxembourg Oracle DBA >500 employees 5-10 teammates English/French
  Jan 2015 - aujourd'hui

  Project: Oracle Database Administration
  Auditing
  An emerging task is to identify which users are accessing, inserting, updating, or deleting data, and when.
  Application Integration
  While most organizations use third-party applications, very few of these applications work in isolation.
  In other words, disparate applications have to be made to talk to one another, often using the
  database as the means to share data.
  Backup and Recovery
  One of the most fundamental aspects of my job is to protect the organization’s data. This includes making periodic backups of data and keeping it safe from accidental or intentional destruction
  Business Intelligence/Data Warehousing
  One of the fastest growing areas for my daily tasks is Business Intelligence (BI) and data warehousing.
  Capacity Planning
  In most organizations, the number and size of databases grows rapidly. It is my responsibility to watch data growth, and plan how best to deal with it
  Change Management
  Server configurations, database schema, SQL code, and many other facets of the application ecosystem, change over time. It is often my responsibility to perform impact analysis before changes are made, implement changes, test changes, and document them.
  Database Application Development
  One of my tasks it can involve writing other code that is used to access data from the RDBMS.
  Data Modeling and Database Design
  The foundation of all efficient and scalable databases is good database design. One of my tasks as a DBA is to create database designs by performing needs / requirement analysis, creating a logical mode, and them implementing the physical model.
  Developing and Maintaining Best Practices
  The better organized and managed the database operations, the more efficient they will be. Ideally, an organization’s best practices will be documented for all to read and follow.
  High Availability
  My primary goal as a DBA is to ensure that their databases are available to users when they need access to data. There are many different ways to help ensure high availability, including use of log shipping, clustering, database mirroring, and other technologies.
  Installing, Configuring, Patching and Upgrading SQL Server Software
  One of the most time-consuming of all database tasks is installing, configuring, patching and upgrading RDBMS instances.
  Maintaining Documentation
  Writing and maintaining documentation is one of a critical part of my job. If there is no documentation, then there is no easy way to rebuild the current infrastructure should major problems arise.

  Technical Environment Windows/Linux/Solaris Oracle 12c/11g/10g, PlSql MsSQL T-Sql Tina/CommVault/Vmware/Oracle Vm/Control-M

• European Organization for Nuclear Research Oracle DBA/Developer >500 employees 5-10 teammates English/French
  Jan 2012 - Jan 2014

  Project: Development of a web application by using Oracle Apex 4.2
  Context: International Volunteer Program - Switzerland
  Role: Oracle DBA/Developer
  
  Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development,
  testing, implementation and maintenance with timely delivery against aggressive deadlines.
  Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity
  relation modeling and design techniques.
  Expertise in Client-Server application development using Oracle 12c/11g/10g PL/SQL, SQL *PLUS, SQL
  Developer PLSQL Developer.
  Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions,
  Materialized Views, Query Re-Write and Transportable table spaces.
  Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
  Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL
  and PL/SQL.
  Developed materialized views for data replication in distributed environments.
  Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
  Loaded Data into Oracle Tables using SQL Loader and data pump.
  Partitioned large Tables using range partition technique.
  Experience with Oracle Supplied Packages such as DBMS_SQL, DBMS_JOB and UTL_FILE.
  Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
  Worked extensively on Ref Cursor, External Tables and Collections.
  Expertise in Dynamic SQL, Collections and Exception handling.
  Experience in SQL performance tuning using Cost-Based Optimization (CBO).
  Good knowledge of key Oracle performance related features such as Query Optimizer, Execution
  Plans and Indexes.
  Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
  Created Shell Scripts for invoking SQL scripts.
  Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

  Technical Environment Windows 7, Oracle 11G R2, Oracle Apex 4.2

• Role: VBA Developer

  European Investment Bank Trainee >500 employees 5-10 teammates English/French
  Jan 2012 - Jan 2012

  Development of an application to improve the quality of the reports used before from PeopleSoft
  Involved in all phases of the SDLC (Software Development Life Cycle)
  Responsible for collecting project requirements
  Extended Microsoft Office 2010 with VBA programming
  Implemented and maintained a technical solution using VBA
  Created Macros using Visual Basic code

  Technical Environment Windows 7, Office 2010