TECHNICAL SKILLS

Operating System: Linux RedHat, Windows, Unix, Window 2012/2008/2003 Server, DOS

RDBMS/Application: Oracle 12c/11g/10g, SQL Server 2012, Oracle SQL Developer, Oracle Enterprise Manager, Toad, SSH,Winscp, Mongodb, Liquibase. Couchbase, Sync Gateway, AWS, Openshift Ansible, Jenkins, appDynamic

Languages: SQL, PL/SQL, Batch and Shell Scripting, Java, C#

Tools: /Utilities: RAC, DBCA, Listener, TNSPING, RMAN, OEM, Export, SQL*Loader, Opatch, Oracle Warehouse Builder, Data Pump, NETCA, DBUA, Oracle Universal installer, Oracle VM Virtual Box, ADRCI, Stata, Database Application, Net Manager, Toad, DBmanager, PVCS Version Manager, Git, Eclipse, Visual Studio 2015, .Net Framework 4.0, SQL Developer, Cdata sql, Opsmanager, RazorSQL, Robo 3T, Mongodb Compass, cbbackup,cbbackupmgr,Curl, Mongo shell

MS Office: Word, Excel, Power point, Access, cmd

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Principal Nosql Lead

Responsibilities:

• Lead my team to complete annual projects to support United commercial Mobile and Web applications.
• Installing, configuring and setting up Couchbase clusters with the highest of 16 nodes.
• Troubleshooting and configuring sync gateway for data synchronization.
• Tuning databases performance, creating and building necessary indexes for high optimization.
• Lead disaster recovery exercise for all united application on mongodb and couchbase databases.
• Repairing corrupted data to a recoverable state and syncing data across other data bearing nodes
• Refreshing databases across multiple environment as part of application migration or troubleshooting.
• Building Disaster Recovery clusters and creating XDCR for data replication across two data centers.
• Keeping development, QA and Production Mongodb and Couchbase servers up to date with necessary upgrades.
• Auditing and configuring both Mongodb and Couchbase clusters to stay in compliance with updated GDPR including Data encryption.
• Maintaining database backup and troubleshooting failures for database recovery and restore.
• Upgrading Mongodb to its current version, creates Mongodb accounts and manages Mongodb clusters for sustainability and performance Optimization.
• Setting up EC2 instances and building cloud formation for Couchbase clusters.
• Upgraded and reconfigured a mobile application 2.6 sync gateway to control the cache size and reduce RAM usage on the node.

Confidential, Frederick, MD

Senior Oracle/Mongodb DBA

Responsibilities:

• Installed Mongodb 4.0, 3.6 and 3.4 on linux 7 servers including development, test, stage and production.
• Refreshed mongo databases for developers to troubleshoot productions issues
• Created mongo - connector for elastic search for data collection
• Configured Opsmanager for data backup, recovery and monitoring.
• Applied periodic patch to Mongodb boxes.
• Upgraded Mongodb version 3.2, 3.4 and 3.6
• Created oracle wallet for application service accounts for secured access to database.
• Cloned Real Application Cluster production database to a test environment
• Maintained, troubleshot, configured and recovered both standalone and RAC databases.
• Applied Oracle security patches quarterly to both software and databases to limit vulnerability on both standalone and cluster servers.
• Upgraded oracle 11g database to oracle 12c on 150 production servers over time using DBUA.
• Set up Rman backup for standalone and Real Application Cluster databases.
• Supported and troubleshot production database upgrades for Sever Support Team on Call basis.
• Successfully installed 11g and 12c Oracle software and created a database.
• Restored and recovered database for development and production servers on both standalone and RAC servers.
• Compiled 32bit, net codes to be compatible with Microsoft 64bit systems.
• Reviewed STIG violation with STIG viewer and applied fixes to reduce vulnerabilities.
• Maintained existing application code by updating and changing code to suit current application request from functional team.
• Created setup installer project for 64bit platform systems to be deployed to thirty-five client systems using InstallShield Limited Edition.

Confidential

Oracle DBA

Responsibilities:

• Administered database objects including indexes, views, tables, clusters, sequences and procedures.
• Monitored the daily status of OTR servers using SCOM and personal scripts. This prevented storage and data errors.
• Monitored scheduled database nightly upgrade on all development servers. Data issues that may cause a failure are researched and fixed before running the job to upgrade the database.
• Successfully Installed Oracle 12c RAC by installing Grid infrastructure and Oracle database software. Applied the latest CPU patch and created documentation for future use.
• Exported and Imported production databases onto Development and Test Servers for research, testing and migration.
• Troubleshot network problems that prevented users from getting access to test, development and production databases.
• Tested and resolved issue that may cause a database upgrade to fail after in-house build. Successful testing is pushed to production database.
• Worked on various trackers to apply schema and null data changes to both RAC and Standalone databases.
• Restored and recovered RAC database from production using RMAN utility and created documentation as part of our COOP project 11GR2 & 12C.
• Successfully performed a RAC database cloning using RMAN backup files 11GR2 & 12C
• Engaged in occurring DBA tasks like managing users including granting and revoking roles and privileges to ensure database security.
• Provided remote support to system administrators and server support team during files transfer, database migration processes and syncing users’ password.
• Involved in database STIG security vulnerability projects to detect and fix “finding”. Reported to Information Assurance Manager
• Worked to test Oracle Transparent Data Encryption on the database. (Column and Tablespace Encryption)

Confidential, Washington, DC

Oracle DBA

Responsibilities:

• Took part in a large number of tuning projects, perform application, SQL, and database instance tuning using a wide range of technologies including AWR, extended SQL trace (event 10046 trace files), OEM Performance Manager, and Custom Scripts
• Developed, designed and implemented the company’s internal DBA Portal using Oracle 11g Application Server.
• Designed and implemented various high availability solutions for a diverse group of clients running oracle 11g using RMAN, Oracle Flashback, and Log Miner.
• Created and automated, enterprise wide monitoring infrastructure using several key technologies including UNIX shell scripts and SQL. This allows our operational DBA team to efficiently gather metadata, exceptions, and performance statistics for remote clients running Oracle using a consolidated Intranet approach.

Confidential, Bowie, MD

DBA Intern

Responsibilities:

• I successfully installed oracle data warehouse and new database upgrades, patches on windows and Linux using ASM.
• Created database objects like table spaces, tables, views, synonyms, snapshots, partitioning, indexes and sizing tables
• Supported a five-gigabyte database by trouble shooting Oracle connectivity problems for performance tuning and system efficiency
• Designed database schemas, set up database users, managed database permissions and set up database roles, and enabled database auditing for security
• Set up range, hash, list and internal partitions for performance, used traditional and data pump utilities to facilitate cross platforms restore operations.