SUMMARY

• I is an accomplished, and Certified ORACLE Database Administrator (OCA and OCP), and a MongoDB Administrator wif over 8 years of experience and wif in - depth knowledge and proficiency in Backup & Recovery, Security Implementations, Database Design, Monitoring & Tuning, Migration, Upgrades, Cloning, and Replication.
• I is also proficient in an assortment of technologies including Oracle 10g, 11g and 12c, MySQL and MS SQL Server. I posses extraordinary written, verbal, analytical and organizational abilities.
• I is a proven leader wif motivational management skills, a solid reputation for building and retaining highly motivated teams and development of innovative solutions.
• I is an achiever who can successfully manage multiple priorities and perform well under pressure.
• Extensively used AWR, ADDM, ASH, and Explain plan for periodic Performance tuning.
• Monitored AWR, ADDM, ASH, Alert log, dynamic performance views, DBMS STATS, Trace Files, System Event Logs for unusual events & took appropriate action according to company policies of incident reports.
• Experience in migrating database objects from development through test & into production environments.
• Capacity planning (supported 3 tier architecture, planning of tables, indexes, tablespaces and databases) to allow for growth potential and analyze data growth trends for capacity and resources.

PROFESSIONAL EXPERIENCE

Database Specialist

Confidential - Fort Detrick, MD

Responsibilities:

• Responsible for administration, maintenance, Performance analysis, and Capacity planning for MongoDB clusters.
• Coordinate and plan wif Application teams on MongoDB capacity planning for new applications.
• Created aggregation queries for reporting and analysis.
• Collaborated wif development teams to define and apply best practices for using MongoDB.
• Consulted wif the operations team on deploying, migrating data, monitoring, analyzing, and tuning MongoDB applications.
• Ensure the continuous availability of our mission critical MongoDB clusters using replication across data centers.
• Created capped collection, Grids (Chunks) collection and created shard keys to distribute data across the shards.
• Developed Mongo DB embedded documents from java code using spring data MongoDB.
• Migrate Oracle Databases using Datapump.
• Perform Oracle Backup using the RMAN Utility.

Environment: MongoDB, monostable, Puppet, Mongo, Java scripts.

Oracle Database Admin

Confidential

Responsibilities:

• Applied Oracle's quarterly Critical Patch Update (CPU/ PSU patches) using O-patch utility to install, test, and deploy patches to all 12 database instances.
• Performed Database refresh in Test, Dev and Prod environments.
• Implementing Data-pump, conventional export/import utility of Oracle 11g for re-organizing
• Databases/Schemas/Tables to improve the performance.
• Database monitoring/maintenance, replication process and performance tuning using OEM to Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
• Involved in the installation, configuration and extended support to Oracle 11g two Node RAC wif ASM file system on Sun Linux platform.
• Involved in converting a single instance database to Oracle 12g RAC databases.
• Maintaining highly reliable 24x7x365 Linux production servers for AWS EC2 instances.

Environment: Oracle 10g, 11g and 12, RMAN

Senior Database Administrator

Confidential - Washington, DC

Responsibilities:

• Deployed Database security policy and installation, using passwords, privileges and user profiles, Used Oracle Transparent Data Encryption to encrypt columns, tables and Tablespaces, I also implemented the "triple A" (AAA) and database auditing policies as well as data redaction.
• Managed database security by creating, assigning appropriate roles & privileges to users depending on user activity, auditing, & performing other security related tasks including Transparent Data Encryption.
• Cloned databases using RMAN and DATAPUMP utilities for all database sizes.
• Extensively used AWR, ADDM, ASH, and Explain plan for periodic Performance tuning.
• Monitored AWR, ADDM, ASH, Alert log, dynamic performance views, DBMS STATS, Trace Files, System Event Logs for unusual events & took appropriate action according to company policies of incident reports.
• Experience in migrating database objects from development through test & into production environments.
• Capacity planning (supported 3 tier architecture, planning of tables, indexes, tablespaces and databases) to allow for growth potential and analyze data growth trends for capacity and resources.
• Installed and administered Oracle Cloud Standby Database for single and multiple instances to achieve high availability. (DATA GUARD).
• Capacity planning to meet the demands of the dynamic aspects of storage & memory for the databases.
• Performed database Refreshes from production environments.
• Implement table and index partitioning to Minimize DB time, increase disk load balancing, improve query speed and enable faster parallel query.

Environment: Oracle 10g, 11g and 12, RMAN, DATAPUMP, AWR, ADDM, ASH, DBMS, DATA GUARD, Data Encryption, Database security

Database Administrator

Confidential - Atlanta, GA

Responsibilities:

• Supported daily administration, monitoring, tuning and troubleshooting on single instance on Unix/Linux, (Database sizes ranging from 100GB to 89TB).
• Implemented a backup and recovery policy under tight SLA times using RMAN and Data-Pump.
• System Development Life Cycle (SDLC) methodology for designing, analysis, development & implementation.
• Championed database migration from 10g to 11g and database upgrade from 11g to 12c using the Oracle Data-Pump and DBUA utilities respectively.
• Installed and configured software for Oracle 10g, 11g, 12c on both Windows and UNIX platforms using Oracle OFA. Also Installed, Administered and Maintained SQL Server Instances 2008 and 2012.
• Used range, hash and composite table partitioning which greatly decreased the DB time and SQL Execution time. Also performed instance tuning by changing init.oar parameters and managed region parameters such as shared pool size and db cache size wif the use of AMM and ASMM.
• Experience migrating database objects from development through test and into production environments.
• Maintaining Database security policy and installation, using passwords, privileges and user profiles, Used Oracle Transparent Data Encryption to encrypt columns, tables and Tablespaces, I also implemented the "triple A" (AAA) and database auditing policies as well as data redaction.
• Created databases from Entity Relational Diagrams (ERD) in Forward Engineering using the Oracle SQL Developer to OFA Institution and finally to DB launch.
• Installed and administered GOLDEN GATE in a unidirectional, bidirectional, and broadcast configuration to mainly replicate data and ensure high availability, in a heterogeneous environment, also worked wif EXADATA Machines for high performance and availability.
• Installed and configured Oracle 12c database and cloud control 12c to monitor all databases.
• Oracle Fusion Middleware 11g engineering including Weblogic 11g
• Configured Oracle tools like SQL*Net to access the database across the network
• Configure and manage ASM instances on Oracle 11g and 12c.
• Worked in a cross functional team dat oversaw the Oracle RAC installation & configuration for Linux environments.
• Applied Oracle's quarterly Critical Patch Update (CPU/ PSU application) using Patch utility to install, test, and deploy patches to all database instances.
• Installed and configured the Oracle Gloden Gate software on Unix/Linux platform for both Unidirectional and Bidirectional replication.
• Championed database migration from 10g to 11g and database upgrade from 11g to 12c using the Oracle Data-pump and DBUA utilities respectively.
• Installed and configured software for Oracle 10g, 11g, 12c on both Windows and UNIX platforms using Oracle OFA. Also Installed, Administered and Maintained SQL Server Instances 2008 and 2012.
• Supported daily administration, monitoring, tuning, and troubleshooting on single instance on UNIX/Linux, Windows server 2008 and 20012 (Database sizes range 100GB to 21TB).
• Experience working on ORACLE EXADATA Machine X4-2 for the extreme performance of the database.

Environment: Oracle 10g, 11g and 12, RMAN, Gloden gate, CPU/ PSU, DBMS, DATA GUARD, UNIX, OFA,SQL Server, Server 2008 and 2012, ORACLE EXADATA, Weblogic.

Database Administrator

Confidential

Responsibilities:

• Performed monthly and annual performance reports for trend analysis and capacity planning.
• Successfully installed and configured Oracle 11.1.0.7 Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.
• Assist in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Extensively used AWR, ADDM and explain plan for periodic performance tuning.
• Implementing Datapump, conventional export/import utility of Oracle 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Database monitoring/maintenance, replication process and performance tuning using OEM Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
• Involved in the installation, configuration and extended support to Oracle 10g two Node RAC wif ASM file system on Sun Solaris platform.
• Involved in converting a single instance database to Oracle 10g RAC databases.
• Maintaining highly reliable 24x7x365 Linux production servers for AWS EC2 instances.
• Part of the on-call production support team for 24/7 on-call production support.
• Administered a Mongo DB to create, update, delete and read documents, in a limited role.

Environment: Oracle 10g, 11g, OEM, RMAN, Gloden gate, UNIX, OFA,SQL Server, Server 2008 and 2012, AWS, EC2,Solaris