ORACLE DATABASE/MICROSOFT SQL SERVER ADMINISTRATOR

“SECRET - ACTIVE CLEARANCE”

PERFORMANCE TUNING & OPTIMIZATION RECOVERY PROCEDURES HIGH AVAILABILITY

Accomplished, certified, and innovative Military Veteran with 5+ years of experience working with Oracle Database Administrator and hands-on knowledge as a MS SQL Server Admin. I possess complete life knowledge including production and project support. Worked on Oracle 10g,11g,12C and 19C versions and MS SQL Server 2012-2016. Some areas of expertise include backup and recovery, database security, performance monitoring and tuning, upgrade and patches, database migration, dataguard, GoldenGate, Log Shipping, SQL Server Replication, RAC, Always on availability group and database refreshes. Served in the United States Navy: Honorably Discharged in 2017.

TECHNICAL SKILLS

TUNING TOOLS: TKPROF, STATSPACK, TOAD, SQL DEVELOPER, OEM 13C, AWR, ADDM, ASH, OEM,SQL PROFILER, EXP/IMP/DATA PUMP, DBCA, DBUA, ADDM, PUTTY, WINSCP, VNC, SQL SERVER MANAGEMENT STUDIO, OEM 12C, SSIS, SSRS, MICROSOFT AZURE, WINDOWS SERVER 2012-2016,RMAN, DATABASE MIRRORING

RDBMS: Oracle 11g 12c 18c 19c Microsoft Sql server 2012-2016

OPERATING SYSTEMS: HP-UX, Sun Solaris, AIX, RHEL, Linux Enterprise Server, Windows 2012, 2016

QUERYING LANGUAGE: SQL, PL/SQL, HTML

PROFESSIONAL SKILLS

Snapshot, Materialized views, import/export and Goldengate.

Installed and configured GoldenGate and Replication of data using Oracle GoldenGate.

Resolved/Diagnose Node Eviction issues.

Enhanced Oracle Databases in patch set Level and also in version Level (11g to 19c).

Applied patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations.

Upgraded and migrated Oracle 11gR2 RAC.

Databases running on legacy infrastructure to Oracle 12c Pluggable Databases running on the latest platforms.

Migration of large number of databases from 10g to 11g and implemented ASM on RAC and stand-alone databases and applying PSU Patch and Migration of non ASM database to ASM database.

Experience in Identifying performance bottlenecks on high volume transaction systems.

Experience in coding SQL, PL/SQL package, function, stored procedure, triggers, and materialized view for Oracle database.

Worked with Oracle Databases (12c/11g/10g) on Unix/Windows platforms.

Installation, Configuration, Troubleshooting Golden Gate Replication for Oracle-to-Oracle.

Migration of Database using Golden Gate technology 10G to 11GR2 and 11GR2 to 12C.

Installed and configure the GRID CONTROL SERVER on 11G/12C/13C.

Expertise in database upgrades from 10g,11g and 19C.

Expertise in installation, configuration of DataGuard both in standalone/RAC in both 11g and 12c.

Planned and implemented high availability solutions using Oracle 11g/12c RAC/Standby DataGuard.

Experience in database recovery techniques and implementation of those recovery techniques to ensure business continuity.

Experience in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.

Expertise in using 10g, 11g and 12C features like Data Pump, Flash-Back Recovery, ASM, AWR, ADDM and Active DataGuard. 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.

Install and Administer SQL Server 2016/2014/2012 on production and Non-production servers.

Implement and configure Windows Cluster and Always On Availability Group for High availability and Disaster recovery solution.

Create a database with Project specifications and support application deployments of the new application database.

Upgrade and Migrated the Data Warehouse server from SQL Server 2012 to SQL server 2016.

Upgrade SSRS Servers across all environments.

Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 11gGrid Control.

Create Instance and Database level SQL Auditing, Change Data Capture and Change Tracking.

Implement Business logic by using T-SQL, stored procedures, and triggers.

Set architectural, operational standards and practices for all systems relating to database products and services.

Create Link Ser for data migration from SQL Server to Oracle databases.

Deploy SSIS packages provided by the Developers into the Production environment.

Responsible for Backup and recovery of the databases using RMAN Tool (Recovery Manager), and Database Flashback using GRP (Guaranteed Restore Point)

Performed Export and Import (Data pump) for restoring the specific objects at the database level.

Duplicate target database using RMAN Active Database.

PROFESSIONAL EXPERIENCE

ORACLE DATABASE/MICROSOFT SQL SERVER ADMINISTRATOR

CVS HEALTH, WARWICK, RI DEC 2019-CURRENT

Supporting Multi-tenancy database architecture.

Install and Configure APEX on databases for ORDS setup.

Supported more than 1500 databases for more than 289 production servers for 24/7 support.

Check the Accuracy of the Data being updated and ensure Perfect Reporting and Verify the Data Accuracy through various SQL Queries.

Having Experience working on Data center servers and handling greater than 1.5 TB databases.

Install and Configure Oracle Message Gateway.

Setup and Configure Row Level Security for API secret keys.

Tuning RMAN Backup performance.

Performing refresh dev/stage/test RAC database from production for testing and new Deployments.

Upgrading databases from 12c to 19c.

Used RMAN for backup and recovery. Performed backup validations using RMAN. Able to resolve the performance issue in database 12c using automatic big data caching, full database caching and In-Memory Aggregation features.

Implemented Active Data guard, creating both Logical and Physical Standby databases in 10g,11gRAC& 19C environment for the Production databases.

Configured and managed Data Guard extensively for Production databases of sizes ranging from 50GB to 5TB.

Performance tuning - Gathering stats, creating index and tuning memory settings for optimal performance

Maintenance and Administration of 3 node High availability RAC 11g databases with ASM shared storage, failover and Disaster Recovery procedures using a Physical Standby.

Setup and Configuration of Standby Databases, Active Data guard, Snapshot Dataguard Data guard broker.

Involvement in timely Database and Application releases for Oracle applications. Interacting with the Development team, Application Team, System Administrators and Release Teams.

Tuning of Oracle database, tuning memory, I/O, Resource contention, Database Operation and performance diagnostic tools like TKPROF, SQL Trace utility, Oracle expert and SQL Analyze.

Created new database and tables using scripts.

Maintained User Databases and System Databases.

Performed Tuning of Stored Procedures, SQL Queries and User Defined Functions

Implemented Trigger to maintain data integrity and consistency.

Planned and scheduled automated backups & performed recovery.

Created user logins and add users to respective databases.

Actively involved in hardware and network specification, installation, and configuration.

Continuously monitoring and updating Backup and Recovery strategy to recover data using RPO and RTO solutions based on requirements.

Document requests for change requests and communicate with the development and testing team.

Created a Database Maintenance Plan for Optimal Performance of SQL Server which covers Database Integrity Checks and Index optimization.

Implement and configure a secure and Encrypted connection between the client application and SQL server to comply with PCI DSS compliance rules.

Assisted in deploying ZERTO to replicate data for mission-critical servers to the DR site.

Worked with SCOM team to implement monitoring criteria for Web and SQL servers.

Coordinated physical changes, current space utilization and performance monitoring of two replicated production servers.

Maintained regular monthly backups in Azure for cloud DR.

Involved in troubleshooting and resolving database integrity issues, performance issues, blocking, deadlocks and connectivity issues.

Resolved issues like Locks &Deadlocks using Activity Monitor and SentryOne to improve the performance.

Implemented a job that creates a daily report on every failed and successful SQL Agents jobs.

JUNIOR ORACLE DATABASE ADMINISTRATOR

FOOT LOCKER, SOUTH PORTLAND, ME NOV 2015-DEC 2019

Increased application efficiency and productivity by administering data analysis and database management for Oracle systems.

Accomplished RMAN backups, purge jobs, Maintenance Jobs using DBMS_JOBS, DBMS_SCHEDULER, Crontab and $UNIVERSE.

Performed Database upgrade from Oracle 11g to Oracle 12c and to Oracle 18c RAC database.

Initiated Creating Grants, Privileges, Roles, Profiles and assigning the users to groups.

Proposed annual and preventive service maintenance on all software including system backups and recovery.

Enhanced the security and functionality of the databases using “runInstaller” and perl based utility “opatch”.

Optimized company access by revamping and configuring network equipment and software/hardware.

Spearheaded Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.

Detect corrupted blocks by using DBVERIFY utility.

Implemented and managed optimum physical database design (tablespaces, datafiles, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture.

Cloned schemas, objects and data on new server using exports from 10g database and imported in 11g using data pump.

Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace, TKPROF.

Experience in Backup & Recovery using RMAN which includes hot backups and Cold backups.

Installed and applied various patches which include Critical Patch Update (CPU), Patch Set Update (PSU) and One-off patches using OPatch and runinstaller, also involved in upgrade oracle database 10g to 11g and 11g to 12c.

Administered (12c RAC) environments adding and removing nodes to the cluster and handled performance tuning using AWR.

Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

Implemented Flashback technology of the Oracle 11g, 12c along with Recyclebin for a faster recovery of the databases and database objects.

Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.

CERTIFICATIONS/EDUCATION

Oracle Database 12c Administrator Certified Associate

Oracle Cloud Infrastructure 2019 Architect Associate

SQL Fundamentals

Oracle Autonomous Database

Microsoft SQL Server 2012-2016

AWS Certified Solution Architect

Contact this candidate