نبذة عني
Oracle Certified DBA (OCP) offering 20+ years of rich 24x7 Production Support experience in Data Engineering, Data Modelling, Data Warehousing, Data Science, Data Analytics, Data Architecture, Database Administration, Da…
Oracle Certified DBA (OCP) offering 20+ years of rich 24x7 Production Support experience in Data Engineering, Data Modelling, Data Warehousing, Data Science, Data Analytics, Data Architecture, Database Administration, Data Migration, Design, Management & Performance Tuning of 24x7 large databases to ensure a high-availability Database Environment
الخبرة
Sr. DBA
ACCOMPLISHED IT PROFESSIONAL
LEAD DBA / DEVELOPER (OCP), DATA ENGINEER, DATA
MODELER, DATA SCIENTIST & CLOUD SPECIALIST
Oracle Certified DBA (OCP) offering many years of rich 24x7 Production
Support experience in Data Engineering, Data Modelling, Data Warehousing,
Data Science, Data Analytics, Data Architecture, Database Administration,
Data Migration, Design, Management & Performance Tuning of 24x7 large
databases to ensure a high-availability Database Environment
SR. CLOUD DATA ARCHITECT (ORACLE)
Working as a Senior Oracle Cloud Data Architect for Fedex Supply Chain
Expertise in designing data platforms on big data technology (Hadoop, Kafka, Splunk) and developing / tuning the data processing stack (Spark, Talend) and implementing data pipelines for ingestion and transformation
Working on Data Classification and Encryption / Masking, Oracle Cloud Infrastucture (OCI), Oracle Data Integrator (ODI)
Setup realtime harvesting of streaming and batch data from Oracle DB to Object Storage on OCI using Oracle Golden Gate Big Data Adapter 19c
Designed optimal data file formats like parquet/json for data unloading and data ingestion
Worked on Operational Data Store (ODS) Data Modeling on Autonomous Database
Pivotal in architecting and designing Big Data Platforms, on-prem and cloud, Data Tiering, Kubernetes
Strong understanding of Microservices architecture, SOA, EAI, EDI and EIP & well-developed analytical & problem-solving skills
SR. DBA (APPLICATION DEVELOPMENT ASSOCIATE MANAGER)
Worked as a Senior Database Developer and Data Warehouse Specialist, responsible for Credit Apps Decision Support System (DSS), and 24x7 monitoring of Oracle, PostGreSQL, Cassandra, MySQL, MariaDB Production Databases on Linux, AWS & Azure Cloud platforms
Worked on Golden Gate Multi Master Bi-Directional Replication, developed updateable materialized views for data replication in distributed environments
Write and Transportable table spaces, ER modeling for OLTP and dimension modeling for OLAP
Good knowledge on logical and physical Data Modeling using normalizing techniques
Resolving database start-up problems; analysing and rebuilding tables & indexes, partitioning tables using range partition techniques
Reporting on Project Status to Client & all Stakeholders through Dashboards/ MIS Reports/ Project Walkthroughs
Pivotal in Database Design (worked on complex PL/SQL Procedures and Oracle Supplied Packages such as DBMS_SQL,DBMS_JOB and UTL_FILE), Database Migration (Loaded Data into Oracle Tables using SQL Loader
Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-
SR. DBA (DATA ENGINEER)
Worked as a Senior Oracle DBA managing databases for Credit Apps Decision Support System (DSS), and 24x7 monitoring of various Oracle databases.
Managed MySQL, MariaDB, SQL Server & Azure SQL DB databases.
SR. DBA (APPLICATION)
Managed the troubleshooting and fine-tuning of SQL Queries
Developed tools to automate monitoring the performance of the Production and Standby Databases
Performed monitoring using Oracle tools like Statspack & AWR
Performed routine maintenance of Production databases and set-up auto-refreshing snapshots in QA, DEV, Training environments based on tables in Production
SYSTEM ANALYST (SR. ORACLE DBA)
Worked as Sr. Oracle Production DBA, on 24/7 on-call rotation and supported SSP (Retail) / RX (Wholesale) / L3 (Conversion) Projects and used Oracle Streams extensively
Worked on monitoring and troubleshooting Shareplex data transfer from Production to Report Servers and Snap backups that created backup images of the Production databases that are about 1 Tera Byte in size, in about 30 minutes
SYSTEM ANALYST (SR. ORACLE DBA & PRECISE CONFIGURATOR)
Assisted in installation & configuration of Veritas (Precise) i3 In-depth for Oracle (6.2.1), Transactions (SQL Server), J2EE, Clarify and Enabler on 100+ Production Databases on 73+ UNIX Servers as these databases were being upgraded from Oracle 8i to 9i
Wrote Shell & Perl Scripts to automate the database monitoring and subsequent alerts
SYSTEM ANALYST (SR. ORACLE DBA & PRECISE CONFIGURATOR)
As the Site DBA Team Lead, I was in charge of performance fine tuning and monitoring of Ensemble (Telegence) Production databases.
Worked extensively with migrating databases using Partitioned tables on Raw devices, implementing RMAN backups (both manually and through OEM), Flashback Query, online table re-orgs and FGAC (Fine Grained Access Control or Row Level Security)