|Reference # : ||19-01663
||Title : ||Senior DBA/Architect [Oracle]|
|Position Type : ||Contract|
|Experience Level : ||
||Start Date : ||01/10/2019
| Description |
|Job title: |
Senior DBA/Architect [Oracle]
Job Description :
9+ years of total industry experience with strong development background using Oracle DBA skills
5+ years of experience as Oracle Database Administration.
3+ years of experience to code, test, debug, and document complex database programs to ensure that data processing in production systems meet user needs.
3+ years of experience with Performance Tuning including tuning/optimizing SQL, PL/SQL code
Strong knowledge of Oracle Database and its features. Identification of performance issues on production and non-production systems. Experience of Core DBA skills such as Partitioning, Server capacity, Storage prediction, DB optimizations techniques using large transactional and DWH databases.
Hands on with installing, managing, patching and regular maintenance of Oracle 12g database.
Understanding of Oracle database foundation architecture and internals, to be able to review and partition tables, review create and rebuild indexes, analyze query's execution plan and fine tune the performance.
Hands on with Linux/UNIX operating systems commands and scripting.
Performance based coding experience.
Experience working with various developers, project managers and analyst for new applications and documents all processes to ensure effective evaluation of all applications.
Proven Experience in SQL and PL/SQL Programming in Oracle 11g/10g in a Unix Environment
Monitor and recommend changes if required to all PL/ SQL packages and provide stored procedures and design and develop various relational database.
Troubleshoot and resolve complex issues.
Design relational models for small and large scale applications.
Review and upload large data sets into Database using tools, and write custom procedures to perform uploads when necessary.
Provide data analysis and validation.
Perform database code reviews and provide recommendations.
Manage database security - Privileges and Synonyms
Develop routines in Oracle using SQL*Loader, third party vendor APIs to load/integrate data between systems
Preparation of development estimates and design documents
Experience working with XML and binary /large data objects.
Experience in Database Schema creation and management.
Experience with Oracle Performance Tuning.
Experience working with development tools like TOAD/SQL developer.
Experience working with Oracle Spatial will be a plus.
Strong analytical and problem solving skills.
Experience with Onshore/Offshore teams and direct customer interactions