Oracle Data
Resume:
ARTTATRAN PARIDA
Email: ***********@*****.***
Cell: 904-***-****
Jacksonville, Florida,
PROFESSIONAL SUMMARY
An accomplished Database Architect, DBA, Data Modeler, PL/SQL Developer Published Author having 15 years’ experience specialized in the field of Database Administration which includes Oracle database 8i,9i,10g,11g,12c, MS-SQL Server 2005,2008,2012 and MY SQL
Expertise in installation, configuration, upgrades, patches, cloning of Oracle 9i, Oracle 10G, Oracle 11G and Oracle 12C on various platforms like Sun-Solaris, HP-UX, Red Hat Linux, Oracle Enterprise Linux and Windows.
Proficient in Installation, Configuration of Oracle High Availability features like RAC, DATA GUARD and Oracle Grid Infrastructure on UNIX, LINUX and Windows environment.
Specialized on fixing Performance and Tuning problems in Oracle database using tools like AWR, ASH, ADDM, SATSPACK, OEM, Dynamic Performance View, EXPLAIN PLAN and DBA scripts.
Strong experience in Backup and Recovery strategies using RMAN, Export/Import, Data pump, Hot and Cold backups and Created UNIX Shell scripts to automate database operation.
Experience in several multi-tera byte database migration to Exadata X2-2, X3-2 using RMAN, data pump and transportable tablespace.
Solid understanding and working experience with Oracle Exadata smart scan,smart flash cache, hybrid columnar compression and storage index.
Experience with Oracle database security administration, configuration and Implementation which includes Oracle Transparent Data Encryption (TDE), Data Redaction, Virtual Private Database, Privilege Analysis, Conditional Auditing, Oracle Audit Vault, Database Firewall and Privilege User Control.
Experienced in Logical and Physical Data Modeling, and designing online transaction processing OLTP, data decision support DDS, warehouses DW database systems using tools like ER Studio
Solid understanding and working experience with Oracle 12c Multitenant (Container and Pluggable) database.
Proficient in SQL, PL/SQL, Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables, T-SQL, Package, Stored Procedures, Functions, Cursors and Triggers.
Experience in data migration from Oracle to Cloud platform like windows Azure and AWS using data pump, RMAN and AWS Snowball
Experience in database administration, implementation, analysis, modeling, monitoring and performance tuning of SQL Servers 2005,2008, 2012.
TECHNICAL EXPERTISE
Database administration:
Oracle database 12c, 11g, 10g,9i and 8i, Oracle Exadata Database Machine X2-2,X3-2, MS-SQL Server 2005,2008,2012, MYSQL, RAC, Data Guard, RMAN, ASM, AWR, ADDM, Statpack Report, Oracle 10g, 11g, 12c EM, Flashback, Transportable Tablespace, Datapump, Export/Import, DBCA and NETCA, Oracle Stream, Materialized View, Golden Gate, SQL, TSQL and PLSQL,
Modeling Tools:
SQL Developer Data Modeler, ERStudio Data Architect 17.0,Erwin Data Modeler
Operating Systems:
UNIX, Linux, Solaris 10, Windows server
Languages:
C++, Java, C#
Development Tools:
Oracle Developer (Forms 9i,Report 9i), Java Developer (9i,10g), Oracle Apex, Oracle SQL/PLSQL Developer, TOAD.
Oracle Application Server, WebLogic, Apache, Oracle Business Intelligence, Hyperion, JIRA, Citrix, Remote Desktop, PuTTY, HP ALM, WinSCP, TortoiseGit, Lotus Note, Fisheye Crucible, Agile, SDLC, SQL Server Management Studio, SSRS
PROFESSIONAL EXPERIENCE
#Harvest Software Solutions LLC, Jacksonville, Florida, USA
Database Architect/Lead Database Administrator (August 2017-till date)
Roles and Responsibilities:
As a subject matter expert (database), I am helping and fixing mission critical database issue for other database consultants working at another client’s location across the USA.
Created conceptual, logical and physical data models and entity-relationship diagrams for relational database systems
Applied data modeling standardization rules to all data models which includes entity naming, element naming, preferred data typing, required metadata, privacy classifications and data masking rules
Installed and configured Oracle grid infrastructure and ASM for development and test databases
Installed and configured oracle 12c database which include CDB and PDB databases.
Performed database consolidation using oracle 12c pluggable database.
Performed database cloning using RMAN duplicate command data pump.
Reviewed and tuned complex PL/SQL package code change with development team for harvest proprietary product EYE touch.
Performed instance tuning, SQL tuning, database tuning using utilities like EXPLAIN PLAN, AWR, ADDM, Dynamic Performance Views and database scripts.
Created and developed the database objects like Partitioned Tables, Indexes, Triggers, Stored Procedures, functions and packages.
# NIIT Technologies Inc.
During this period, I have worked for several international clients across the globe. I have lead roles of database architect, production and application DBAs.
Client: - SEI, Oaks, Pennsylvania, USA July 2014 - Aug 2017
Database Architect/Lead Oracle DBA
Roles and Responsibilities:
Installed and configure Oracle database 12c, Oracle enterprise manager, Oracle database 11g, Oracle 11g RAC, ASM & Data Guard, RMAN on various OS Platform like Linux, UNIX and Windows.
Performed performance tuning activities using EXPLAIN PLAN, STATSPACK, DBMS_STATS, Automatic Workload Repository (AWR), Active Session History (ASH), Automatic Database Diagnostic Monitor (ADDM) and SQL Tuning Advisor.
Performed Database designing, Sizing tablespace, Create database scripts, Reviewing database scripts, Monitor databases, Interact with developers, Oracle Install, Upgrade, 24x7 DBA Production support, Disaster recovery Automate daily jobs, Schema management, Data Pump, Export/import Database, SQL Tuning, Capacity Planning and Managing Users, Storage allocation and Creation of physical database objects from logical model.
Installation and maintenance of SQL Server 2005,2008,2014 database systems. Managed database backup and recovery, performed performance tuning, maintained database security, created database objects including tables, view, cursor, triggers, stored procedures, indexes, defaults and rule.
Implemented scripts, object naming convention and coding standards for database code in ongoing project.
With Strong programming experience, I have implemented code changes in complex PL/SQL Packages, Stored Procedures and Functions, Database Triggers.
Implemented in-memory option on oracle database 12c for performance of critical database transaction.
Implemented security administration by creating of roles, data encryption, data redaction, views and granting the necessary object/system privileges for users.
Performed database consolidation using Pluggable database in Oracle Database 12c.
Performed Database Backup and Recovery, Database cloning using RMAN and Data Pump.
Completed migration/upgrade from Oracle 11g to Oracle 12c successfully
Installed and configure new features of oracle database 12c like container database and pluggable database compliance with cloud computing.
Working closely with clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues helping to transform business requirements into environment specific databases
Client: DEUTSCHE BAHN AG (Germany Railway), Frankfurt, Germany - Mar 2011- July 2014
Lead Oracle DBA
Roles and Responsibilities:
As a Lead Database Administrator with a team of 20 Oracle DBAs, I was responsible for administration of development, production and test Databases at Germany Railway.
I have made multiple visits to this client during the above period as a key support person related to database administration and database designing.
Performed upgrades from Oracle 10g to 11g and 11g to 12c also applied patches.
Configured and implement the Oracle database 12c features like automatic data optimization and in-memory option for a frequently used table, partitioned and tablespace data on performance critical application.
Configuring database entries and monitoring all of the databases using Oracle Enterprise Manager (OEM).
Responsible for configuring database memory structure, managing storage allocation, creating user accounts, roles and privileges for DB operations and security maintenance.
Monitored OEM alerts, space alerts, alert log errors and performance issues on the production databases.
Managed multiple standalone MS-SQL Server 2005,2008,2014 instances containing system critical databases.
Monitored and maintained all MS-SQL Server 2008,2014 subsystems (SQL Agent)
Ensured backup and recovery processes for all MS-SQL Server 2005,2008,2014 database
Installed, configured, upgraded, backed up, and monitored MYSQL databases
Managed appropriate use of free space within tablespaces, reclaimed space whenever possible.
Performed FLASHBACK features to handle efficient database recovery for human errors
Hands on experience in developing procedures, functions, packages and triggers using complex PL/SQL.
Very good experience in development tools like TOAD, SQL Developer, PL/SQL Developer.
Identify improvement plans and implemented those in the project to enhance the quality of the deliverable
Contacted Oracle corporation for technical support and patches
Coordinated/communicated with customer and offshore to manage day to day DBA activities
Client: LBC TANK TERMINAL, Paris, France - Jan 2008- Mar 2011
Lead Oracle DBA
Roles and Responsibilities:
Performed data warehouse migration from Oracle 8i to Oracle 10g.
Design and implemented 2 TB database and storage for data warehouse using materialized view.
Performed complete multi-master replication with updateable Materialized views.
Performed regular Backups and Recovery as per Organization Strategy to support the database and Troubleshooting with restoring and recovery.
Rebuilding of Indexes and managing the table partitions for better performance, maintenance of Oracle Database.
Experience in Identifying performance bottlenecks on high volume transaction systems. Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
Implemented database security by enforcing roles and profile management
Created the database, tables, tablespaces and data objects, indexes, users and implemented security using data encryption and privilege user control.
Worked on Planning Database, Sizing table space, Create database, scripts, Monitor databases, 24x7 production support
Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
Created routines for Daily, Weekly & Monthly partitioning of tables.
Created/Altered Partitioned tables for large customer related data.
# Sunjray Pty Ltd. North Sydney, Australia
Client : TELSTRA, North Sydney, Australia - Mar 2005- Jan 2008
Sr. Oracle DBA
Roles and Responsibilities:
Worked in Oracle database 8i, 9i, 10g and 11g and interchangeably across multiple O/S platforms (HP/UX, Sun Solaris, Redhat Linux and Windows 2000+ servers supporting 100s of schemas to prevent and/or fix thousands of production problems.
Participated in various critical Oracle production database related meetings.
Worked with both Cost and Rule based optimizer modes in Oracle database instances.
Managed capacity planning for Oracle instances and advised the company accordingly.
Managed a database with 60 partitioned tables which was setup to act as a mini data warehouse.
Used AWR, explain plan for performance related issues.
Worked on Data transferring with export/import utilities and Data pump and RMAN
Managed Database Growth and Space management, distributed the tables, redo logs, archived redo logs table partition and indexes on different disks to optimize data retrieval.
Configuring parameter file to fix sizes of SGA components in conformity to available resources.
Involved in logical backup using and full/ partial export/import and Data Pump.
Used SQL Loader extensively to extract data from flat files and loading into the new application.
Performed database analysis, design, coding, testing and implementation of database structures.
Worked in creating logical and physical data models for large complex applications and translating logical database models into database design
Managed replicated databases using snapshots implementing and managing materialized views in Oracle 9i/10g
Creating Indexes, rebuilding indexes, analyzing indexes to improve the performance of query.
Creating tablespaces and planning the location of data, index and rollback tablespaces redo log files and control files in adherence to the Optimal Flexible Architecture.
# C1 India Pvt. Ltd, New Delhi, India
Client: CANON, Gurgaon,India - Nov 2002- Mar 2005
Sr. Oracle DBA
Roles and Responsibilities:
Installed, configured and upgrade of Oracle server software and related products
Documented coding standards, lessons learned, best practices, problem resolutions and quality improvement documentation for POC
Configured Oracle networking components such as the listener, TNS names and other connection protocols for the Oracle client using NETCA.
Created Oracle database instances using DBCA to conform to Oracle's optimal flexible architecture (OFA) standard
Regularly checked ALERT logs to know types of Bottlenecks recorded during if any, and rising to counter them. Managing Redo logs and Data files like adding, renaming and resizing
Managed Control files like adding, recreating and tracing to physical locations and tracing
Configured Oracle Enterprise Manager and maintain data integrity, managing profiles, resources and password security
Created and managed users, privileges and roles
Documented all security practices and created daily management reports
Used RMAN to perform full and incremental backups and recoveries
Managed Production, Development and Test Database in 24x7 environments
Performed time based incomplete recovery to recover accidentally dropped tables
Monitored the different memory structures such as shared pool, data dictionary cache, library cache, buffer cache
Implemented UNDO table space feature of Oracle 9i database
Performance tuning at database level for the parameters like SGA, PGA, SGA_TARGET PGA_AGGREGATE_TARGET
Implemented multiple Archive log destinations to archive redo logs to support database recovery
Analyzed tables, optimized queries and supported development on using cost base optimizer.
EDUCATION/TRAINING
Master in Computer Application (MCA), Utkal University, INDIA
Oracle 11g Database Administrator certified Professional from Oracle corporation
PUBLICATIONS
I have written the following books on Oracle performance tuning:
Book Title: Oracle 11g Performance Tuning ISBN no. 978**********
Book Title: Oracle 10g Performance Tuning, ISBN no. 813180531X, 978**********
AWARDS AND ACHIVEMENTS
My idea “Creating new service offering around cloud computing” have been recognized and awarded by CEO of NIIT Technologies on 16th June 2009 . This idea was no. 1 among 200 ideas from different branches of NIIT Technologies worldwide.
My work Data Warehouse migration from Oracle 8i to Oracle 10g with zero percent down time have been recognized and awarded by CIO of LBC Tank Terminal 11th September 2009.
Contact this candidate