SUMMARY:

• Having 10+ years of IT experience as a Mongo DB and Oracle DBA. Experience in Writing MongoDB Schema using Mongos.
• Good experience on MongoDB 3.0, 3.2 and 3.4 scaling across data centers and/or in - depth understanding of MongoDB HA strategies, including replica sets.
• Consult, make recommendations, and design and provide solutions related to the migration to MongoDB.
• Developed enhancements to MongoDB architecture to improve performance and scalability.
• Consulted with the operations team on deploying, migrating data, monitoring, analyzing, and tuning MongoDB applications.
• Excellent experience in database administration, production support, oracle 10g/11g RAC, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, migration, database security, auditing across multiple platforms and environments.
• Hands on experience with installation and support of Oracle RAC 10g/11g R1/R2, 12C with ASM on different platforms such as Solaris and Linux and AIX.
• Implementation of High Availability solutions such as Physical and Logical Standby Databases (Data Guard), active Data guard in 10g/11g RAC and standalone database environment.
• Experience in Materialized views, Oracle Streams and Golden Gate installation and configuration for database replication.
• Experience on building and rolling out new 12c databases for test/dev/qa environments. Implemented oracle 12c active standby database for test database environment.
• Implemented oracle 12c flexi ASM for pre-prod environment.
• Hands on Experience in installation and configuration of OEM grid control … TOAD, Oracle SQLDeveloper in various versions.
• Solid experience in disaster recovery, Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full back up, incremental, cumulative backup and implementing backup and recovery strategies.
• Excellent experience in performance tuning using STATSPACK, AWR, ADDM, EXPLAIN PLAN, SQL TRACE, and TKPROF.
• Hands on Experience in upgradation (9i, 10g to 11g) and Migration of Database by applying patches (CPU, PSU, Interim Patches) using OPatchutility and PatchSet using Universal Installer.
• Proficient in using Flashback Technology, Log Miner, Automatic Storage Manager (ASM) & Automatic Database Diagnostic Manager (ADDM)
• Good Exposure in translating business requirements into creation of database objects: tables, indexes, constraints, packages, Triggers, stored procedures and functions using Oracle tools.
• Proficient in SQL, PL/SQL, Shell Scripting.
• Excellent experience in providing 24x7 on-call support.
• Experience in Data Compression, table Compression, OLTP Compression, Health Check Monitoring, Flashback Data Archive, CRS and ASM

TECHNICAL SKILLS:

Core Proficiency: MongoDB, Oracle Database Administrator, Oracle Golden Gate, RAC, Data Guard, Automation, MS SQL Server, My SQL, MS Access, MS Office, IIS and Apache web server.

Programming Languages: Java, C/C++, PHP, HTML, CSS, Bootstrap, ASP.Net, IIS, LAN, MVC, Java

Operating System: Sun Solaris, Windows XP/Vista/7, 10, Server … …Linux, DNS, Active Directory, DHCP server, User roles and privileges.

Big Data Technologies: Pig, Hive, HDFS, Spark, Data analysis, Pivot table, Power BI.

Others: OPS/MMS, Mongo Compass, JIRA, Informatica. Agile and Waterfall frame work, SDLC.

Sr. NoSql DBA/Mongo DB

Confidential, Norfolk, VA

Responsibilities:

• Configure and monitor numerous MongoDB instance shards and replica sets. Backup and restores (Backups should be automated with shell scripts/Ops Manager)
• Database Health check (Complete review of Database slow queries, fragmentation, index usage etc)
• Index rebuilds. Upgraded to latest Mongo version (3.4) and Maintenance (Data center outages)
• Writing best practices documents for sharding, replication for Dev/App teams
• Log rotation/ maintenance, Segregation of duties (User Management - designing User roles and responsibilities)
• Disk usage, CPU, Memory check Alerting Designing DR (Disaster Recovery) /COB (Continuity of Business) plans as applicable
• Database Profiling, Locks, Memory Usage, No of connections, page fault etc., Export and Import of Data to and From MongoDB, Run time configuration of MongoDB,
• Data Managements in MongoDB Capped Collections Expired data from TTL,
• Monitoring of Various issues related with Database,
• Monitoring at Server, Database, Collection Level, and Various Monitoring Tools related to MongoDB,
• Database software Installation and Configuration in accordance with Client defined standards
• Database Migrations and Updates, Application of database patches, Capacity management
• Hands on experience in Server Performance tuning and Recommendations.
• High availability solutions and recommendations, Hands on experience in Root cause analysis for business impacting issues

Mongo DB/DBA

Confidential, Money, VA

Responsibilities:

• Set up and administered large clusters consisting of numerous shards/replica sets. Managed multiple MongoDB (NoSQL) database clusters.
• Delivered full life cycle support of clients. Conducted modeling and provided/implemented shard key recommendations.
• Implemented profiling level and EXPLAIN PLAN analysis. Performed monitoring and capacity planning.
• Recognized by clients for responsive troubleshooting, resolving outages, and improving performance.
• Contributed to improving the development process with alternative solutions to increase efficiency.
• Authored scripts facilitating the identification of missing and candidate indexes.
• Commended for learning new technology quickly and rapidly delivering valuable contributions.
• Excellent communication and analytical skills with good analysis and result oriented skills.
• Created and maintained all databases required for development, testing and production usage.
• Planned and implemented backup and recovery of the Mongo databases.

Senior DBA

Confidential, Staunton, VA

Responsibilities:

• Responsible for installation, up-gradation of oracle (9i, 10g, 11g) software in different Environments, Creating and maintaining oracle development and test databases on AIX and Solaris platforms.
• Supported development and testing databases with database ranging from 100GB to 5TB.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation of Duplicate Databases using RMAN Backups.
• Implemented backup and recovery procedures (Cold/Hot backups, RMAN Incremental backups & Import/Export, expdp/impdp)
• Installation, configuration and maintenance of oracle 10g/11g RAC with ASM.
• Configuration of Oracle OEM (Oracle Enterprise Manager) to monitor database and report on events as defined by the DBA group.
• Data protection and disaster recovery for enterprise data.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.
• Implemented table partitioning to improve performance and data management.
• Implemented Security through Virtual Private Database and Fine grained Auditing.
• Developed RMAN scripts for database backup and recovery.
• Designed and implemented the database servers for two new data centers.
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using EXPLAINPLAN, SQLTRACE, TKPROF, AWR, and ADDM.
• Created users, roles and granted privileges according to the business requirements

DBA

Confidential, Elkton, VA

Responsibilities:

• Oversaw DB server power cycle and space management by defragmentation, index rebuilding, table reorganization etc.
• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
• Scheduling the Physical backups (hot & cold) in CRONTAB using RMAN utility and monitoring the scheduled jobs.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
• Used EXPLAIN PLAN, SQL TRACE, TKPROF utilities for optimizing and tuning SQL queries.
• Responsible for continuous Monitoring of CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck and reorganization for ensuring performance.
• Monitored queries with high response time and high disk read per execution (Top SQLs) and tuning the same using Explain Plan, TKPROF and SQL tuning advisor.
• Involved in Defragmenting data blocks of table spaces for optimized performance. Also partitioned large tables to increase performance.
• Responsible for all database activities such as User management, space management, database security management.
• Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4 and 11.2.0.3-->Opatch
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.

DBA

Confidential, Chesapeake, VA

Responsibilities:

• Performed all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases
• Monitoring database events as part of a Production support and level 1 staff.
• Performed ongoing tuning of database instances and controlled migrations of programs, database changes
• Administered all database objects: tables, clusters, indexes, views, Sequences, packages, and procedures
• Trained up subordinate engineer.
• Experienced with RMAN, BACKUP and RECOVERY, POINT-IN-TIME RECOVERY (PITR) of databases.
• Performed cross platform migrations from Oracle 10g to Oracle 11g (Solaris-Linux)
• Proficient in migrating data base from 9i/10g to 11g by applying latest patch sets.
• Configured RAC on oracle 11g RAC.
• Involved in administration of over 150 Oracle 11g/10g R2 instances.
• Implementing standby database and database replication to provide high availability of database.
• Sizing the SGA, sizing the db buffers, shared SQL area, log buffer based on the requirements.
• Continuous monitoring of database performance during peak and non-peak loads using STATSPACK
• Involved in team management, team building exercises for the DBA team.

DBA

Confidential, Ashburn, VA

Responsibilities:

• Optimized memory parameters, Cursors, Processes, parameters to improve the database performance
• Troubleshot performance issues by identifying bottle necks, wait events generating AWR reports
• Involved in implementing 11g RAC with ASM disk on Linux servers.
• Migrated database Schemas from Single instance to RAC.
• Duplicated RAC Databases in non-production environment through RMAN.
• Implemented and troubleshooting Data Guard (Standby) for high availability/disaster recovery purpose.
• Performed backups and recoveries using RMAN/conventional hot & cold backups.
• Setting up and monitoring RMAN backups that include archive log backups, full database backups, and incremental backups and troubleshooting ORA errors for backup issues.

Infrastructure Administration Services Engineer

Confidential, Chantilly, VA

Responsibilities:

• Support L1 and L2 to the end users,
• Monitored LAN of 150 computers and installed computer network switches across the LAN
• Installed Windows, MS Office, Outlook and antivirus on 150 computers
• Troubleshot hardware and software problems for 150 computers, 20 servers, and 35 Printers
• Installed and configured 5 Microsoft SQL Server and Oracle Database servers