Experience

TranSmart

• United States
• Civil Engineering
• 1 - 100 Employee

• Database Administrator

  • Aug 2018 - Present

  VDOT Project Management team responsible for developing and maintaining Statewide program database. VDOT Project Management team responsible for developing and maintaining Statewide program database.



Chaveran Institute of Technology

• United States
• IT Services and IT Consulting
• 1 - 100 Employee

• Oracle Database Administrator

  • Dec 2017 - Aug 2018

  My duties as an ORACLE DBA at Chaveran are to primarily ensure well-being of the OLTP production systems, schema object management, database deployments and proactive monitoring. • Performed systems monitoring , Upgrades, performance tuning, Backup and recovery. • Proactive Maintenance on the systems by timely patches to the system • Enabling clients to gain the most from there IT investments while staying within their budget • Responsible to guide each project from inception to successful completion • Use of the export to perform logical backup and import to restore inadvertently dropped table. • Perform installations, creating databases, configurations, backup, restore and recovery, troubleshooting errors, and some performance tuning. • Diagnose and resolve the most complex data management problems and issues in oracle & Percona Server MySQL database. • Develop capacity and performance metrics as well as maintain, analyze, and report on a scheduled • Performing installations, creating databases, configurations, backup, restore and recovery, trouble • shooting errors, and some performance tuning • Creating and managing user access and Oracle security to secure database and ensure data integrity • Use of the export to perform logical backup and import to restore inadvertently dropped table • Database instance and schema creation utilizing DBCA, SQL scripts, database, migration, archive, restoration



Sibley Medical Inc.

• Oracle Database Administrator

  • Jul 2014 - Nov 2017

  Designing and documenting the full life-cycle of a database by creating and normalizing ERD using DB Designer Fork and SQL Developer. Installing the Oracle RDBMS software and creating the database for development and testing. Upgrading and migrating Oracle EE Database from 11g FS to 12c ASM and successfully configuring OEM 12c Cloud Control with multiple agent deployments. Creating, maintaining, and documenting automation initiatives for database tasks and batch jobs. Creating processes, procedures, policies, and standards for the database functions. Performed fresh installation of 11.2.0.3 RAC on Automatic storage Management and created databases in RAC environment. Conducted time to time analysis and monitoring of the software and hardware requirements and act accordingly. Responsible for capacity planning, database security, recovery planning and installing patches. Created Tables That Contain Encrypted Columns and Oracle Wallet Management for Transparent Data Encryption. Configured listener for external procedure calls, Worked closely with ETL applications team. Involved in scheduling incremental, cumulative and full backups and configured retention policy using RMAN. Worked closely with the Oracle developers for the better performance in Applications by writing and creating Packages, Triggers and Indexes on the tables, creating database Objects, Tablespaces, Schemas as needed. Created TSM backup scripts and scheduling these on the crontab of both application and database servers.