SUMMARY:

• Excellent record of accomplishment in designing solutions, improving the environment and resolving IT Infrastructure challenges (About 10 years) with great focus on databases, operating systems, network, storage, and applications.
• Accomplished major projects related to Database Infrastructure in the field of security, monitoring, backups, network etc.
• Highly proficient in setting up and working on with High Availability (HA) environments which are meant to be fast and disaster proof.
• Expert managing data, setting up backups, security, monitoring, analysis performance, exadata, oem, RAC, automation, Linux, release management. Confident working on MySQL, MongoDB, OUD, OID, LDAP, network, storage.
• Eager to take up challenges; I aim to be a very good leader; among the best.
• Very willing to contribute towards the good of society in a large scale.
• An extremely quick and efficient learner, with an intention to develop elegant and cost effective solutions.
• I pay strong attention to details.
• Very willing to take calculated risks.
• Highly appreciated by managers, peers, and colleagues I work with.
• Have worked extensively in small and large teams.
• Diplomatic and tactful with professionals and nonprofessionals at all levels.
• I strive to make sure I know what I know and know what I don’t know.

TECHNICAL SKILLS:

• Oracle Databases
• DB Security, Upgrades, Migration
• Data Guard, setting up HA. DR exercises
• Exadata (Engineered Systems)
• Oracle Enterprise Manager
• Using various DB Backup strategies
• Real Application Clusters, ASM
• Oracle NET services
• Data recovery
• Firefighting and fixing performance
• Automation/scripting
• Guiding team members
• MySQL
• MongoDB
• GoldenGate
• MySQL Enterprise Monitoring
• Mongo OPS Manager
• Network and Storage Admin
• MySQL Enterprise Backup
• Mongo Compass
• Linux Admin, Windows Admin
• Core Java, C#.NET, ASP.NET, Microsoft SQL Server, Confidential Vertica, Google Cloud Platform

PROFESSIONAL EXPERIENCE:

Confidential

Senior Database Administrator

Responsibilities:

• We manage the SMOG databases for California State. Oracle database migration project.
• Implement data security using TDE for data at rest. Implement RMAN backups and database encrpyption.
• Setting up monitoring for critical components though CRON shell scripts.
• Perform migrations using various options for migrations; Transient Logical standby database (poc), Datapump. Goldengate, Dataguard.
• Extensive used of Oracle Datapump for schema and database migrations.
• Setting up Oracle GoldenGate bi - directional, multi-source replication and monitoring.
• Work with developers to handle application bug fixes or one-off processes following release management processes.
• Migrations from standalone Oracle databases to Oracle RAC databases. Setting up RAC parameters as per new setup on Exadata.
• OEM13cR2 installation. Setting up monitoring of targets through inbuilt metrics, metric extensions. Setting up email notifications.

Environment: GoldenGate, Exadata, RAC, RMAN, Data guard, Physical Standby, Logical Standby, TDE Transparent Data Encryption, Security, Deployments, OEM 13cR2, Linux RHEL, wallets, Shell scripting, Monitoring

Confidential

Senior Database Administrator

Responsibilities:

• Oracle, MySQL and MongoDB development and production DBA.
• Exadata DMA tasks, lot of work around Exadata like setting up exadata component monitoring on oem13c, firewalls, oracle net, identifying faulty hardware, support in patching and device replacement, cellcli, ilom, exadata decommissioning, cell scrubbing etc. Migrated tons of databases from old exadata to new ones.
• Tons of work around OEM13cR2 from setting it up (Multi OMS), dynamic groups, metric extensions, monitoring templates, notification rules etc. to OEM13cR2 emcli extensive usage and automation of agent installation and target promotion. I setup AWR warehouse for databases.
• Tons of work around Oracle Dataguard from setting up physical standby databases to migrations, switchovers, and monitoring. Also gave team a presentation on Dataguard Broker.
• Database Architect work like creating and modifying data structures, table partitioning, indexing, optimizing DB parameters etc.
• Identifying and solving performance challenges related to SQL or DB or Infrastructure. Performance tuning.
• Major projects accomplished: RMAN Catalog database migration from 11g to 12c. OEM12c to 13c migration. OID to OUD migration for LDAP, Exadata old to new hardware migration. Setting up Exadata Monitoring, Extensive ECOM database support for ATG, True Value sales, Enterprise Customer Data Management. OEM Agent install-automation, setting up EUS using OUD.
• Some work around MySQL with MySQL Backups, monitoring locks, database refreshes, user management, setting up MySQL monitoring in OEM13c.
• Some work around MongoDB with setting up OPS Manager, setting up the MongoBI connector, database refreshes, script executions.
• Assist team with DR exercises.
• Daily Database support which includes activities like user management, data migration, performance firefighting, giving performance tips, development strategies, backup and recovery, etc. Bit of Goldengate troubleshooting.
• Provide support for high priority work outside office hours.
• Auditing and DB inventory management.
• Working closely with peers, application team members and project managers.

Environment: Exadata, cellcli, RAC, RMAN, Data guard, Physical Standby, TDE Transparent Data Encryption, MySQL, InnoDB, MEM, MEB, MongoDB, mongodump, mongorestore, mysqldump, OUD Oracle Unified Directory, OEM 13cR2, Linux RHEL, Shell scripting, Servicenow, PCI, PII, wallets, dataguard broker, GoldenGate, logdump

Confidential

Systems Engineer, Oracle DBA

Responsibilities:

• Install, configure, and maintain Oracle Databases including Oracle RAC, RAC One node, Exadata, Oracle Dataguard, Oracle standalone
• Create/ refresh/ clone databases
• Troubleshooting challenges with database/ node evictions in an Oracle RAC environment using TFA utility and other OS monitoring tools.
• Applying PSU patches to Oracle Standalone databases and Oracle RAC databases in a rolling fashion.
• Oracle RAC database upgrade.
• Logical and Physical standby databases
• Configuring backup and recovery strategies using RMAN and Datapump
• Loading data into database using SQL Loader.
• Coding shell scripts to automate tasks and schedule tasks as per requirements using CRON.
• Proactive and reactive troubleshooting of database performance challenges reported by users and monitoring tools using AWR, ASH interval reports, TKPROF and OS tools like vmstat, top, topas, nmon, sar, mpstat etc.
• Capacity planning of database using historical data and reports.
• Ensuring best practices are being followed along with ensuring security measures are in place.
• BMC Remedy was the primary ticketing tool used across organization.
• Handled Incident Management (IM), Service Requests (SR) and Change Management (CM) process using BMC Remedy tool.

Environment: Oracle database 11g and 12c, Oracle RAC, Oracle ASM, Oracle RMAN, Oracle data guard with logical standby and physical standby databases, RHEL, Sun OS, Shell scripting.

Confidential

ITO Service Delivery Consultant 2, Oracle DBA

Responsibilities:

• Work in a 24X5 production/ beta/ development database support model in a team of 3 along with weekends on call support.
• Manage and maintain Oracle Dataguard Physical standby and Single instance databases - Windows and UNIX.
• Manage and maintain Oracle RAC, RAC One node and Oracle Exadata databases.
• Conversion of Non-ASM instance to ASM instance, implementing OMF.
• Coding automation scripts to automate tasks across the client database environment.
• Setting up new database servers, Database migration from windows to Linux and upgrades.
• Oracle Client installations.
• Configure new host/ non host targets on OEM12c., configure Database jobs like RMAN backups, datapump jobs and reports on OEM12c.
• Synchronizing Physical Standby DR environments.
• Disaster recovery team member.
• Analyzing DB performance challenges using AWR, ASH, ADDM, tracing sessions on demand and generating TKPROF reports. Coding logon triggers if required.
• Maintaining audit requirements including SOX compliance.
• Developed and implemented SOX compliance reports using BI Publisher tool on OEM 12c. These were required for performing SOX audits.

Environment: Oracle RAC One node, Oracle RAC, Oracle ASM, Oracle RMAN, Oracle data guard Physical standby, Oracle database 9i, 10g, 11g, Oracle datapump, Oracle Flashback, Oracle Enterprise Manager Cloud Control 12c, Service Now, Red Hat Enterprise Linux, Solaris, IBM AIX, Windows 2008R2, Windows 2012, Shell scripting, Batch scripting, EDW, Oracle Client, ODBC

Confidential

Consultant, Oracle DBA (FTE)

Responsibilities:

• SOP documentation.
• Project and environment training for new candidates. Built a team.
• Manage Oracle RAC/ RAC One node/ Data guard/ Single instance databases,
• Ensure availability of production systems and internal instances.
• Configuring database backups, performed disaster recovery, cloning of databases.
• Setting up OEM12c and monitoring databases on OEM 12c, OEM11g and OEM 10g.
• Export / Import of data using datapump as per requirements, database user management, performing database health checks.
• Troubleshooting ORA errors found in the alert log.
• Generating explain plan for queries and AWR reports.
• Contact Oracle Support for unknown Oracle errors/ help.

Environment: Oracle RAC 11gR2, Oracle ASM, Oracle database 10g, 11g, Oracle Enterprise Manager 10g, 11g, 12c, Oracle Datapump, Oracle RMAN, NFS, RHEL, IBM AIX, Solaris, Windows 2003, Altiris helpdesk, Microsoft System Center, SQL, Shell scripting.

Confidential

DBA/ Programmer

Responsibilities:

• Homebrew and College developer using .NET, SQL, SQL Server 2005, and Oracle RDBMS.
• Worked on developing Hotel Management suites.
• Developed solutions and app modules using the .NET framework 2.0. ADO.NET, ASP.NET, C#.NET.
• Coded various application modules, such as employee management, room booking and restaurant management on .NET C# 2.0.
• Designed database running on MS SQL Server 2005, which was the background for the application using OLEDB data provider
• Administer and configure Oracle 9i and 10g databases as part of a different project.
• Worked as a team on developing the application.
• Learnt Core Java, Javascript.

Environment: Windows XP, .NET Framework 2.0, .NET C# 2.0, SQL Server 2005, Oracle 9i/ 10g, OLEDB, Core Java, Javascript.