SUMMARY

• Oracle Database Administrator 9+ years of experience with strong emphasis on delivering world - class solutions across corporate
• Mainly Oracle Database Administration experience including Oracle Exadata, Oracle Enterprise Manager Cloud Control 12c & 13c Release 2 (12.1.0.2), 11gR2 RAC on LINUX and Sun Solaris, Installation, Upgrading, Patching, sizing, creating Oracle Databases, and Oracle database Objects, data migrations, Troubleshooting, Performance & Tuning, Backup & Recovery, and Database integrity and Security.
• Experience in TDE(Transparent Data Encryption) in both 11g wallet and 12C Keystore.
• DBA and well versed with SQA(Software quality assurance) life cycle, requirement gathering, deploying test cases development
• Hands on experience in Oracle 9i, 10g, 11g and 12c RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation)
• Extensive experience designing and implementing backup and recovery strategy for databases using Recovery Manager (RMAN).
• Experience with various database Backup and Recovery methods like PITR, TSPITR, Export/Import and Flashback Technologies.
• Experience in the field of Database Technology with experience in designing, developing implementing Databases.
• Have ample knowledge in implementing policies, and procedures for disaster recovery and archival processing to ensure data protection.
• Experienced with database security analysis and vulnerability remediation process.
• Expert in delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 11g OEM Grid monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.
• Experience with SQL coding including DDL, DML and fine tuning those sql's for better performance.
• Good knowledge v$ performance views and command line skills to identify information about sessions, wait events, system performance etc
• Exposure to SQL Tuning Advisor, SQL Profiles, SQL Monitoring, SQL Access Advisor, SQL Baselines and SQLTXTRACT tools and utilities.
• Applying Patches, Critical Patch Update/Patch Set update and One-off Patches using OPatch. Experience in patching RAC databases in rolling fashion to maintain high availability.
• Extensive experience in designing Logical and Physical data models for new developments using ERwin modeler.
• Experience in using 11g features Flash-Back Recovery, Data Pump, AWR, ASM, ADDM, ASH, Recycle Bin, 11g&12c Grid Monitoring.
• Skilled in cross platform migrations from Windows to Linux, Solaris, HP and AIX unix
• Excellent Experience in installing and maintaining Oracle Dataguard to implement physical Standby Databases for Disaster Recovery.
• Proficient in setting up Standby Database using shell scripts and RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported by DATAGUARD.
• Migrated databases from Non-ASM file system to ASM file system using RMAN.
• Good experience in RAC Clusterware administration, Configuration and Patching Performing day-to-day database administration tasks like SRVCTL,CRSCTL ASMCMD,CELLCLI and dcli
• Expertise in Configuring RMAN with Catalog /No catalog and worked on Point-In-Time Recovery and flashback.
• Plugging the tablespace between different platforms using Cross platform transportable tablespace Utility.
• Collecting performance statistics using Statspack/AWR (Automatic Workload Repository) and ADDM (Automatic Database Diagnostic Monitor).
• Experience in regular DBA activities such as Upgrades, Patches, TAR support, Cloning, Backups and Recovery Manager, Performance Tuning, Capacity Planning and documentation
• Excellent analytical, problem solving, communication and interpersonal skills
• Experience in Microsoft Database with Strong experience in Visual Studio for ETL process and pulling data from different databases and flat files.
• SQL SEVER database administrator with about 6 years’ experience
• Import access databases tables to load in SQL server, Create link server on SSMS
• Strong Skills in using SSIS Control Flow (Execute SQL task, Foreach Loop Containers, Script Task, File Task, Expression Task, etc.) and SSIS Data Flow (Derived Column, Count, Multicast, Conditional Split, Lookup, Data Conversion, etc.) Administered multiple SQL Server databases, ensuring optimal performance, high availability, and data security.
• Installed and configured SQL Server instances, and applied patches and updates to ensure stability and security.
• Created and maintained database backup and recovery plans, and conducted regular backup and restore testing to ensure data recoverability in case of disasters.
• Monitored database performance using SQL Server Profiler,Performance Monitor, and third-party monitoring tools ( Solarwinds, RedGate, site24*7), and implemented performance tuning measures to optimize database performance.
• Configured and maintained SQL Server AlwaysOn Availability Groups (AAGs) and Failover Cluster Instances (FCIs) for high availability and disaster recovery.
• Developed and maintained PowerShell scripts to automate routine database administration tasks.
• Designed and implemented SQL Server Integration Services (SSIS) packages to import and export data between different systems
• Developed and maintained custom SQL Server Reporting Services (SSRS) reports to meet business requirements.
• Managed security and access to SQL Server databases, and implemented security best practices to ensure data confidentiality, integrity, and availability.

TECHNICAL SKILLS

Hardware Server: Oracle X2/X3/X4 full rack Exadata machine, IBM PowerPC, X64 box, Hitachi, EMC, Dell Servers, Compaq Servers 6000/3000/1600/800 , HP/UX-900

Operating System: Oracle / Redhat Linux, IBM AIX, HP-UX, Solaris, Windows Server 2012 R2, Windows Server 2016

Languages: SQL, PL/SQL, Unix Shell Scripting Bash/Korn, T-SQL, Batch Script

RDBMS: Oracle 9i to 12c RAC/ASM/EXADATA Data Replication, Oracle GoldenGate 11gR2, 12c.18c

Tools: / Utilities: Oracle sql developer,Quest Toad/Spotlight, ERWin, Tivoli, RMAN, Logminer,TKPROF,AWR/ADDM/ASH,OEM12c,OEM 13c,Export,Import,Datapump, RMAN, SQL*Loader,DBCA,DBUA, and TTS, SQL Server Manager Studio, SSRS,SSIS for ETL, Visual Studio, vb.net, C#, SQL SERVER 2008,2012,2016,CSS, HTLM, IIS, oracle and SQL DBA, SQL developer, Front end developer, Strong Skills in using SSIS Control Flow (Execute SQL task, Foreach Loop Containers, Script Task, File Task, Expression Task, etc.) and SSIS Data Flow (Derived Column, Count, Multicast, Conditional Split, Lookup, Data Conversion, Rubrik, Jams, SITE24*7, Solarwinds, RedGate,….)

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, OH

Oracle Database Administrator and Microsoft DB

Responsibilities:

• Import access databases to SQL server, Create link server on SSMS
• Give sudo access to oracle during EXADATA patching, by adding in /etc/sudoers file, enable and disable crowstrike in server
• Mount and unmount volume in exadata linux server
• Research, construct, develop, and test complex SQL and PL/SQL scripts for new reports;
• Coordinate cross-functional projects as assigned and interact with all areas of the organization to achieve timely results;
• Strong experience with oracle functions, procedures, triggers, packages & performance tuning,
• Ensure that database programs are in compliance with V3 standards.
• Hands on development using Oracle PL/SQL.
• Performance tune SQL's, application programs and instances.
• Evaluation of new and upcoming technologies.
• Migrate oracle databases into SQL Server, schedule backup and create jobs to continuous updating databases tables to another server.
• Participe in monthly screening and patch window servers with Sys Admin team
• Manage Integrity, Index Tuning, and Production refresh of SQL Server databases.
• Create, upgrade SQL databases, restore databases
• Upgrading, installing, and configuring application software and computer hardware.
• Configuring a SQL Server Always On High Availability Group
• Configure SQL Server Disaster Recovery( Log shipping, Database mirroring....)
• Creating and managing system permissions and user accounts.
• Monitor front end application and deploy applications on IIS. Manage all application on IIS.
• Writing of complex Stored Procedures, Views, as well as advanced query techniques, report writing and the import/export of data.
• Managing all database maintenance activities from Backup/Recovery, Indexing, Database Integrity and Consistency Checks to Disaster Recovery and High Availability
• Defined and implemented security patching process and kept all DBs and DB servers in compliance with company’s vulnerability remediation requirements.
• Advises on less complex security vulnerabilities and products for clients, security administrators and network operations.
• Support all SQL and Oracle Databases for production and non-production
• Experienced in supporting SQL Server IaaS and PaaS on Azure Clouds.
• Well versed in database performance tuning, especially SQL tuning
• Administer and support Azure Active Directory and Exchange policies
• Troubleshoot and resolve issues with user access to cloud services
• Assist with the migration of data into the Office 365 cloud platform
• Manage Azure subscriptions and resources; implement and manage storage; deploy and manage virtual machines; configure and manage virtual networks; and manage identities.
• Support many databases running Oracle 11g & 12.2.0.1, 18c on Standalones & Exadata environment, running on X6s with the use of Cloud Control 12C in monitoring.
• Create documentation to support the business and satisfy regulatory requirements.
• Plan and execute disaster recovery for company production systems.
• Research and solve Oracle with Oracle Support.
• Provide senior level DBA support for applications, including developing data migration scripts, data validation queries, and a maintenance plan for the various development versions of these applications.
• Provide documentation and support for all aspects of maintenance and development.
• Work with application development team staff to develop & test database architecture and approve all production schema changes.
• Manage movement of data between Dev,Test,UAT and Production.
• Tune database instances and applications and recommend changes to improve database performance.
• Migration of data from sql-server to Oracle12C.
• Plan and implement backup and recovery strategy and write scripts to do nightly RMAN backup.
• Installed, patched, and managed Oracle Database versions 11g on Red Hat Linux

Confidential, Indianapolis, IN

Oracle Database Administrator/Microsoft SQL DBA

Responsibilities:

• Support many databases running Oracle 11g & 12.2.0.1, 18c on Standalones & Exadata environment, running on X6s with the use of Cloud Control 12C in monitoring.
• Create documentation to support the business and satisfy regulatory requirements.
• Plan and execute disaster recovery for company production systems.
• Research and solve Oracle with Oracle Support.
• Provide senior level DBA support for applications, including developing data migration scripts, data validation queries, and a maintenance plan for the various development versions of these applications.
• Provide documentation and support for all aspects of maintenance and development.
• Work with application development team staff to develop & test database architecture and approve all production schema changes.
• Manage movement of data between Dev,Test. UAT and Production.
• Tune database instances and applications and recommend changes to improve database performance.
• Migration of data from sql-server to Oracle12C.
• Plan and implement backup and recovery strategy and write scripts to do nightly RMAN backup.
• Installed, patched, and managed Oracle Database versions 11g on Red Hat Linux
• Able to resolve the performance issue in database 12c using full database caching and In-Memory Aggregation features.
• Hand on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.
• Have implemented two type of standby databases supported by Data Guard, logical standby and physical standby databases in 11gR2 .
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup.
• Implemented Active Data guard, creating both Logical and Physical Standby databases in 10g,11gRAC & 12C environment for the Production databases.
• Experiencing in Installing OEM 12c and 13c Cloud Control and upgrading the 11g management agents to 12c agents.
• Implemented Golden Gate in moving large volumes of transactional data, with minimal impact to online systems.
• Cloning/duplicate of database with RMAN and user-managed (hot/cold) backups.
• Migration of databases to 12C from Oracle 10g&11g.
• Implemented and maintained Oracle 11g Data Guard/standby databases for fail-over purposes.
• Also, worked on Network data encryption to improve the security and implemented SSL wallet to secure the connections.
• Performs investigation and data loss prevention, data manipulation, and coordination of activities. Performs actions to address or mitigate risks and vulnerabilities.
• Migrated OLAP databases close to 8TB with minimal downtime using GoldenGate and verified data integrity using Goldengate Veridata tool for Linux 3 Node RAC.
• Database Services creation for distributing the applications across multiple nodes, extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD,
• Partitioned tables Maintenance, adding new partitions, exchanging one year old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.
• Implemented Range,list and interval Partitioning for monthly partitioning of large tables.
• Developed RMAN Backup strategies for cloning the test databases with the production environment and worked on RMAN active-active duplication.
• Experience with Logical backups EXPDP/IMPDP and extensively used for Re-hosting the application using Golden Gate and worked with conventional EXP/IMP for migrating data from 9i to 10G.
• Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS JOBS, DBMS SCHEDULER, Crontab.
• Designed and implemented different backup strategies like Cold, Hot, MAN with Flash Recovery Area and Logical Backups EXPDP/IMPDP.
• Handled Chained Rows and Row migration, and solved the database performance issues.
• Experienced with ASM, adding, deleting disks to the disk group.
• Supported development teams for all the database related issues and handled the critical issues like network failures and ASM DISK group errors.
• Generated Statspack/AWR reports using OEM 12C from Oracle 11g database and analysed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth.
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements.
• Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries
• Coordinated maintenane activities including shutdown and startup of db's and ec2 instances
• Completed RDS backups before and after maintenance activies including upgrades and patching
• Tools Used: Oracle RMAN, Oracle 11g (11. 2.0.2), DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Confidential, St. Louis, MO

Oracle Database Administrator

Responsibilities:

• DBA supported 6 Node Exadata on X4s from Development, Test, UAT to Production environments, involving daily configuration, administration, all running on Red Hat Linux 6.5.
• Database sizes range from 500GB to 7TB (in MANHATTAN,ODS & FIN,OC11,SCI & EDW environments).
• Both tables and schemas refreshes using Datapump, expdp and impdp.
• Database refreshed using expdp, impdp, RMAN Duplicate and cloning.
• Used RMAN Duplicate and EXPORT/IMPORT data from 9i to 11.2.0.4.
• Created a standby database by using RMAN Duplicate in order to reduce the down time for the PROD database during the migration process.
• Planned Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Installation of oracle enterprise manager 12c, oracle management repository and deployed agents.
• Managed agents using emctl utility and creating incident rules in enterprise manager 12c.
• Configuring administration groups, and creating template collections in oem 12c.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
• Worked closely with the Oracle developers for the better performance in Applications, in writing the Packages, Triggers and Indexes on the tables.
• Used Secure SCP & FTP extensively for the File transfers from machines to remote server.
• Cloning & duplicating databases using scripts as well as RMAN for test and developments instances.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Responsible for setup and implementation of 2 Node RAC on Linux in 11g R2.
• Implemented Dataguard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
• Worked closely with Systems Analysts, Systems Engineers/Admins & Application Developers through the SDLC from Development to Production, via Tech-Test in Needs Assessment, Requirements Gathering (Server hardware/OS specifications for Oracle Installs), Database Designing (Physical & Logical) and Implementation, database user creation and database access both at role & table levels, as well as final Project Performance Assessment/Evaluation.
• Created database Objects, Tablespaces, Schemas as needed.
• Database refresh from Production to dev, test and uat.