Deepak Chandra Email & Phone Number

Lincoln, Nebraska Metropolitan Area

Columbia, South Carolina Metropolitan Area

• Installation and maintenance of Oracle 21c,19c,12c & 11g, managing databases in OLTP and OLAP environment.
• Migrated Oracle Databases from 11.2.0.4 to 12c to 19c and 21c for both production and development instances.
• Database cloning/refreshes and support to development team for each application release
• DB performance monitoring (AWR, Stats pack/tkprof utilities, Analyzing/Reporting)
• Maintained Unix shell scripts
• Providing backup which includes Import/Export using Data pump and restore functions on requirement. Automated RMAN hot, cold & export backups, and performed recovery from backups.

Athens, Georgia, United States

• Installation and maintenance of Oracle 12c, 11g, 10g managing databases in OLTP and ETL environment.
• Migrated Oracle Databases from 10.2.0.3 to 11.1.0.7 to 12c for both production and development instances.
• Performed day-to-day tasks such as monitoring the production servers, resolving conflicts, running stats pack, providing support to end users, security and schema management, space usage monitoring etc.
• Development of policy and procedures as they relate to database maintenance, security and archiving.
• Creating, granting and monitoring user access rights and privileges through roles and profiles.
• Providing instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage with the help of AWR and ADDM Reports.

Tallahassee, Florida, United States

• Responsible for installing, configuring, managing and supporting all Production, Development environments of Oracle Version 10g, 11g databases on Linux and HP-UX.
• Responsible for database sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management and Security Administration.
• Responsible for creating roles, assign system /object level privileges to the roles and assign users to these roles.
• Upgraded databases to Oracle from 10g to 11g.
• Implemented active Datagaurd for standby.
• Responsible for creating tablespaces assigned and granted roles to the users.

Irving, Texas, United States

• Installation and maintenance of Oracle 12c.x, 11.x, 10.x, 9.2, managing databases in OLTP and ETL environment.
• Handled a team of 6 Database administrators and divided work based on their expertise.
• Involved in the analysis of Physical Data model for ETL mapping and processed flow diagrams to develop Datamart design.
• Designing the Star Schema and Snowflake schema for faster effective querying and business analyze requirement.
• Performing the oracle partitioning for the highly volume tables (Range partitions, Hash Partitions).
• Monitoring and optimizing system performance using index tuning, disk optimization, and other methods.

Hyderabad, Telangana, India

• Installation/maintenance of Oracle 10.1.0.2, 9.2.0.5 using GRID features on HP-UX 9 and Windows platforms.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Made performance improvements to the database by building Partitioned tables, Index Organized Tables, Materialized Views and Bitmap Indexes.
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.

Hyderabad, Telangana, India

• Provided 24x7 supports on a rotation basis within a team.
• Migration/Upgrade from 8i/9i to 10g. Cloned and refreshed production database to development, testing and QA environments in regular basis.
• Implemented, configured and maintained Oracle 10g RAC (Real Application Clusters) on Sun Sparc for HA (High Availability) system.
• Designed and implemented database backup/recovery strategy and performed full incremental and cumulative backup/recovery using RMAN/UNIX shell scripts.

Bengaluru, Karnataka, India

• As a DBA Configuration of Oracle Database Server and clients on different platforms. Initial Database Study, Plan & design Database, Database creation (using OMF). Installation of ERP Package at client side..
• Creation of different Database objects (Partition Tables, Materialized View, Refreshing materialized views, Index Rebuilding etc.). Monitoring scheduling backend process (Resolve if it fails).

Bengaluru, Karnataka, India

• Database Refreshes. Database Builds for new clients and Database Unbuilds.
• Installation and configuration of Oracle database 8i (8.1.7), 9i (9.0.2) on various OS platforms like Solaris, Linux, WindowsNT, 2000.
• 24 X 7 Monitoring of Customer Databases, physically located in U.S. and Remote Administration of fifteen Production Databases in UNIX environment.
• Performance tuning of application and database, identification and resolution of contention, defining and implementing Backup Recovery policy, and day-to-day monitoring of the Production database.