The first question many of us ask ourselves when ever starting a new career, “I am interested in database technologies but which one should I go for, Is it Development, Administration, Architecture..etc?”
YES, that kind of thinking is good and will help you in planning your career carefully.
Below are the various Job profiles currently in the industry, please take a look at them and plan your career accordingly.
You can reach out to me and I can guide you in the right direction.
Oracle Database Administrator (DBA)
DBA’s are the people who manage your database server and keep it running all the time. Their responsibilities include…
- Good Understanding of Database management systems and Relational Models
- Installing Oracle database software
- Oracle Database Architecture
- Maintain Database storage
- Oracle Networking
- User Administration and Security
- Used Managed (Manual) Backup and Recovery
- RMAN Backup and Recovery
- Oracle database upgrades and patches
- Oracle Multitenant Architecture
- Oracle Data Movement Utilities
- Oracle Database Performance Tuning
- Oracle ASM (Automatic Storage Management)
- Oracle Database High Availability (RAC, DataGaurd)
Oracle PL/SQL Developer
PL/SQL Developers are people who develop applications using SQL and PL/SQL. Their responsibilities include…
- Understand Relational Database Model and concepts
- Application development with all stages of System Development Life Cycle (SDLC): Design, Analysis, Coding, and Testing
- Good at SQL and PL/SQL
- Write efficient SQL Queries
- Performance tuning of SQL queries using EXPLAIN PLAN, Hints
- Aggregate data and send reports
- Use Analytical functions to create reports
- Able to create views, synonyms, sequences
- Able to create Materialized Views
- Create Packages, Procedures, Functions, Triggers, Cursors using PL/SQL
- Dynamic SQL in PL/SQL
- Debug PL/SQL programs to address issues
- Basic Unix skills
- Write Unix Shell Scripts for scheduling jobs in Unix/Linux
Enterprise Data Architect
Data architects define how the data will be stored, consumed, integrated and managed by different data entities and IT systems, as well as any applications using or processing that data in some way.
Their responsibilities include…
- Assist in Data Analysis, Data Modelling, Data Integration and Database Design
- Data Migration Tools Knowledge
- Design Data Warehousing environment
- Designs Data Architectures.
- Designs and builds relational databases.
- Develops strategies for data acquisitions, archive recovery, and implementation of a database.
- Cleans and maintains the database by removing and deleting old data.
- Be able to design and develop Databases, Data Warehouses and Multidimensional Databases.
- Understand Kimball dimensional model and Inmon’s relational model
Oracle Architect possesses the skills over the years of experience and the responsibilities include…
- Good understanding of database architecture(cloud, multi-tenant, distributed, SAN, NoSQL)
- Good understanding of servers and appliances.
- Design architecture flow for new applications.
- Able to study current state architecture and suggest future state architecture.
- Able to provide road map to implement the future state architecture.
- Good understanding of various Oracle Products.
- Architect the solutions based on a practical approach.
- Guides to use best practices to reduce operational cost.
- Evaluates various technologies and brings in the best.