Project Management Oracle Database

Siddharth Chaturvedi

+1-250-***-**** *********.************@*****.*** Victoria, BC

Profile

Over 13 years of experience in IT industry involving Software Analysis, Implementation, Coding, Development, Testing, Maintenance and Project Management with focus on Oracle databases and related technologies. Experience with PowerBI development with a proven track record in BI, Datawarehouse. Experience in database administration and successful management of database projects both on-premise and in Oracle Cloud Infrastructure. Recent experience in Project Management with repeated success in developing process plans and initiatives while driving high customer satisfaction and exceptional team performance. Employment History

Senior Database Administrator at BC Public Service, Victoria December 2020 — Present

● Led multiple Oracle database projects, overseeing all phases from planning and design to implementation and post-implementation support.

● Managed cross-functional teams of database administrators, developers, and system engineers to ensure project goals were met within established timelines and budgets.

● Providing administrative support and maintenance in oracle 12c installations, database creation, security, optimization, and tuning.

● Experience with providing and maintaining high availability and disaster recovery using ORACLE DATA GUARD.

● Created backup and recovery strategies using RMAN and data pump utility for databases.

● Successfully migrated on-premise oracle databases to Oracle cloud infrastructure.

● Oracle database performance tuning using Explain Plan and AWR reports.

● Managing database structures, storage allocation, table partitioning, index segments, rollback segments, constraints, database access, roles and privileges.

● Day to day maintenance including patching, cloning, and administration of concurrent manage process, users, Forms, reports and performance issues.

● Provided 24 x 7 on-call DBA support.

Senior Database Administrator at Fujitsu, Victoria September 2019 — October 2020

● Managed and supported multiple applications for public sector.

● Managed and administered Oracle Database environments, including Oracle Database 12c and 19c, for mission-critical applications.

● Designed and implemented database schemas, ensuring optimal performance and scalability.

● Implemented backup and recovery strategies using RMAN, ensuring data integrity and minimizing downtime.

● Performed regular performance tuning and optimization activities to improve database efficiency and response times.

● Implemented high availability solutions, including Oracle Data Guard to ensure continuous availability of critical systems.

● Led database migration projects to Oracle Cloud Infrastructure (OCI), including planning, execution, and post- migration optimization.

● Collaborated with cross-functional teams to ensure successful migration and integration with existing systems.

● Developed and maintained documentation for database configurations, procedures, and best practices.

● Provided on-call support and troubleshooting for database-related issues, ensuring 24/7 availability of systems.

Technical Lead at BT E-serv India Private Limited, Bengaluru January 2017 — September 2019

● Lead the development and implementation of data analytics strategies to support business objectives.

● Utilize Power BI to create interactive and visually compelling dashboards for executive-level reporting.

● Conduct thorough data analysis using SQL, Python, and other tools to identify trends, patterns, and insights. Collaborate with cross-functional teams to define key performance indicators (KPIs) and develop data-driven solutions.

● Work closely with IT teams to optimize and streamline data extraction, transformation, and loading (ETL) processes.

● Provide actionable insights through in-depth data analysis, statistical modeling, and predictive analytics.

● Developed and maintained PLSQL scripts for data processing and transformation in Oracle databases.

● Managed the budget for the project and also managed the team of 10 resources. Team Lead at Oracle Financial Services, Bengaluru

September 2016 — January 2017

● Understand the requirements, functional design document, ETL requirements from the BA/ onsite counterparts.

● Analyze for gaps, check feasibility from the design perspective and seek any clarifications (iterative process).

● Leading a team of 10 developers.

● Participate in client calls and prepare the clarification list to seek clarifications.

● Prepare the list of requirements and seek review inputs from the key stakeholders.

● Update requirements traceability matrix.

● Create impact analysis document (for simple change) to understand the impact on the existing functionality, as required.

● Provide inputs to testing strategy, configuration, deployment, hardware/software requirement etc. Senior ETL developer at MetricStream Infotech, Bengaluru December 2015 — September 2016

● Implemented workflow logic in Oracle PL/SQL, with front end being Java/JSP for user applications.

● Develop the mappings using needed Transformations in Informatica tool according to technical specifications.

● Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup

(Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.

● Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.

Senior Software Engineer at Accenture Services Private Limited, Bengaluru November 2010 — November 2015

● Managed day-to-day operations of Oracle Database environments, including installation, configuration, and maintenance.

● Implemented database security policies and procedures to ensure data confidentiality and integrity.

● Designed and implemented database backup and recovery strategies to minimize data loss and downtime.

● Performed routine database maintenance tasks, including patching and upgrades, to ensure system stability and security.

● Developed and optimized SQL and PL/SQL queries to support application development and reporting requirements.

Education

Rajiv Gandhi Technical University, Bachelor of Engineering, Bhopal September 2006 — June 2010

Courses

SAFe Practitioner

Oracle Cloud Infrastructure Foundation Associate, Oracle Oracle Cloud Infrastructure Certified Architect Associate, Oracle Professional Scrum Master, Scrum.org

Professional Product Owner, Scrum.org

Skills

• Team management

• Database Administration

• Databases: Oracle, SQL Server, Postgres

• Oracle Cloud Infrastructure

• Languages: PLSQL, SQL, Python, JavaScript

• Version Control: Github, Subversion

• Project Tracking: ServiceNow, Zenhub, JIRA

• Agile

• ETL tools: Informatica

• Data Modelling

• BI: Microsoft PowerBI

Contact this candidate