SUMMARY

• Over 8 years of IT experience, including extensive knowledge and proficiency in Mongo database administration 2.x, 3.0.x and 3.2.x, Oracle database 10g, 11g and SQL in development, test and production environments.
• I can work entirely and very effectively under stressful conditions where speed and accuracy are necessary for mission critical databases.

PROFESSIONAL EXPERIENCE

Confidential, Milbank, SD

Sr. Mongo DBA

Responsibilities:

• Design architecture of MongoDB multiple versions (2.x, 3.0.x and 3.2) of Replicasets, Sharded cluster.
• Load balancing of application request’s by configuring multiple mongos instances in sharded cluster.
• Maintaining Data consistency by enabling Journaling, Read concern and Write concern.
• Monitoring database locks, replication lag, replication oplog window, assertions, queues and page faults.
• Created various types of Indexes and support the efficient execution of queries in MongoDB.
• Having knowledge on Index properties and suggesting development team to build index on required fields.
• Familiar with compression techniques in Wiredtiger storage engine.
• Implemented security in MongoDB cluster. Configured authentication and authorization across all mongod instances.
• Enable sharding on databases and collections by choosing suitable shard keys.
• Configured replicaset across multi data centre nodes.
• Performed initial sync on secondary nodes based on situations. Installed and configured OPS manager monitoring and backup process.
• Efficient use of Aggregation pipeline operations in sharded cluster.
• Enabling journaling for auto recovery of terminated operation in database.
• Developed Mongo DB embedded documents from java code using spring data MongoDB.
• Implementing new enhancements for the application.

Environment: MongoDB,MMS/OPS,mongostat,mongotop,mongofiles,Ruby,LDAP,Puppet, Linux/Unix, LVM Snapshots, Backup scheduler,Dataguard,Pearl,PyMongo,Java script.

Confidential, Sioux Falls, SD

Sr. Oracle DBA

Responsibilities:

• Worked as production support, maintaining Production and Development Oracle databases.
• Supported databases including RAC Production database, a Data warehouse database and lot of Development and Test databases.
• Installed and configured Oracle 11g databases on HP - Unix and RHEL Linux.
• Installed and configured Oracle RDBMS on UNIX and Windows environments. Created primary database storage structures.
• Create and maintain DB templates, RAC environments,
• Involved in database administration including 11g RAC Database cloning, tuning, patching and monitoring concurrent manager processing.
• Perform daily incremental backup and full weekly backup using Oracle backup utility RMAN.
• Setup and configure Standby database (Physical & Logical) for high availability.
• Initiated 10g new feature implementations such as Automatic Storage Management, Flashback features, DBMS Scheduler, ASMM to improve performance and manageability.
• Integrating Oracle Applications 11i with OID/SSO.
• Setting up Physical Standby Database environment using Data guard in Oracle 9i, 10g and 11g.
• Created Dimensional and Relational Physical & logical data modeling fact and dimensional tables using Erwin.
• Created, Configured and Set up RMAN Catalog databases and registered target databases with the Catalog.
• Managed and monitored grants, roles, privileges to users, analyzed tables to generate and gather stats including verifying daily backup logs and alert logs.
• Create and troubleshoot DB Link’s issues in Oracle for communicating with external databases.
• Done performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Worked on POC to implement MongoDB for upcoming projects.
• Worked on CRUD operations in MongoDB.
• Managed undo segments, processes, memory, online redo log files, data files.
• Integrated the backup status, reporting for the entire database in the enterprise to enable the web reporting using oracle, SQL, PL/SQL, UNIX shell scripting.
• Configured and installed one to one replication using GoldenGate between heterogeneous environments.
• Performing all daily maintenance tasks. Interacting with Oracle Customer service as and when required.
• Maintained documents of Oracle database operations. Prepared documentation of database backup and recovery standards.

Environment: Oracle 11g,10g,9i, 11g Grid Infrastructure, Oracle 11g RAC, 11g Grid Control, Oracle 10g, HP-UNIX, AIX, Windows, RAC, Data Guard, TOAD, ASM, VERITAS Net Backup, RMAN, Solaris 10, GoldenGate, STATSPACK, SQL* Loader, SQL/PLSQL.

Confidential, SiouxFalls, SD

Oracle Engineer

Responsibilities:

• Provided System support for both development and 24/7 production environments.
• Experienced in ORACLE Software Installation, DBCA to create database and DBUA to upgrade Oracle database on the Red Hat LINUX and Windows environment.
• Experience in implementing and maintaining Virtual machine (VM).
• Tuning for performance at Operating system level and Database Level.
• Performance tuning with ASH, AWR, ADDM Reports.
• Monitors database activity and file usage, and ensures necessary resources are present.
• Perform daily incremental backup and full weekly backup using Oracle recommended backup utility, RMAN.
• Built and configured RMAN Recovery Catalog for Backup and Recovery strategy.
• Developed RMAN scripts for database backup and recovery including hot and cold backup.
• Database migration using Data Pump as well as RMAN.
• Operating system CPU average, Load average, IDLE time average monitoring by TOP, IOSTAT, NETSTAT, and VMSTAT.
• Creating and dropping of users, granting and revoking permissions to users/roles.
• Using Oracle Enterprise Manager (OEM) for routine administration, database monitoring, replication process and performance tuning.
• Monitoring Oracle RDBMS availability, database exports, tablespace, and extents reports.
• Develop and enforce database related policies, standards, naming conventions, operating procedures and best practices.
• Create and maintain multiple databases, users, roles and privileges.
• Administer database user accounts. Create, modify, reset username/password, lock and unlock user accounts.
• Familiar with Fine Grain Access (FGA) and Fine Grain Access Control (FGAC).
• Experience in schema management, Tablespace, datafile and extent management, as well as user and privilege management.
• Tablespace management including, adding/resizing data files, allocated quotas to user and managed disk space.
• Extensively used data moving utilities like export/import, Data Pump.
• Familiarity of Oracle High Availability Architecture (HA) involving Oracle RAC, ASM, Golden Gate, Data Guard and EXADATA.
• Optimized database performance by analyzing tables and indexes.

Environment: Oracle 10g, RMAN, Virtual machine (VM), Agile/Scrum Windows, MS-Project, MS-Office Suite, MS Visio, MS PowerPoint, Quality Center 10, UNIX, SQL, Data Analysis.

Confidential, Huron, SD

SQL Developer

Responsibilities:

• Installing and Configuring Sql Server on Windows systems.
• Creating and maintaining various databases on production/development servers and provide 24x7 support
• Capacity Planning for new databases and setting up environments.
• SQL Server installation, configurations, backup/restore, Maintenance Plans and handled databases Monitoring SQL Server agent jobs and troubleshooting the failed job
• Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, integrity verification, replication verification, and indexing updates.
• Involved in designing and creating Databases, Tables, Views, Stored Procedures and Triggers.
• Identified, tested and resolved database performance issues to ensure data optimization.
• Implementation of system wide security policies and trouble shooting.
• Managed Logins and Users like adding logins, roles, groups to the Windows Server and MS SQL Server and maintaining proper security procedures.
• Created Schemas, Tables, Stored Procedures, Triggers, Functions, Indexes, Views and other T-SQL code and SQL joins for applications.
• Assisted on the Adhoc -Query Requests based on the requirement by using Joins, Sub Queries
• Integrating the Database projects with TFS and Red gate Source Control from SSMS.
• Created a DTSX\SSIS solution to feed an OLAP database from different environments.
• Created SSIS Packages to Extract and load data from and to different sources and targets like Oracle, SQL Server, Text Files, Excel and CSV.
• Created scripts to assign values to variables at runtime.
• Worked with Integration services Event Handlers, Log Providers.
• Reviewing/Validating Data across all the Source and Target databases as the ETL Packages Execute.
• Logging the DTSX\SSIS packages to maintain consistency between source and target.
• Working on regular maintenance activities, creating/maintaining PBIs( Production Backlog Items) and Tasks, regular support for internal incident/ change management system.
• Worked on Weekly DBA on call/email support.

Environment: SQL Server, ORACLE, MS Access, SSIS, SSRS, T SQL, MS Visual, SQL Server Data Tools/BI (SSDT), Redgate SQL Source Control, TFS, Remote Desktop Connection (RDC), Windows Server 2008 R2, SharePoint and Windows 7 Enterprise.