SUMMARY

• Over 11 years of enterprise infrastructure, design, development, operations, implementations, support, databases administration, technology lead experience,
• Teamwork, initiative, ability to learn and teach, customer and quality focus, effectiveness, broad range of experience in project development, utilized in driving profitable and cost - effective collaboration between IT and critical business functions.
• A builder of high-performance team, a natural team leader, mentor, and motivator who thrives in environments requiring a high-level strategist and a big-picture thinker.
• Involved in designing, developing, testing and rolling out of complex enterprise applications to completion in terms of Database as well as front end, with different project development model like SDLC, Agile and SCRUM methodology.
• Experience in cloud infrastructure layout with particular provisioning, security, and management in multiple components of enterprise IT architecture including cloud computing, virtualization, dB management, app design, development and inter-disciplinary teamwork.
• Designed relational (RDBMS), non-relational (NoSQL) infrastructure to move local applications in heterogeneous environment, established security policies and standards to migrate, and manage applications from Oracle and AWS cloud
• Actively participate in development efforts, application design, and QA activities, provided development and operations lead role for Oracle, SQL Server, MySQL, Postgres and MongoDB based applications.
• Established GoldenGate replication in heterogeneous environment, and replicated data between Oracle, SQL Server, MySQL and Amazon RDS /Redshift.
• Established GoldenGate and amazon DMS replication strategies for a zero downtime migration, leveraging change Data Capture (CDC) between Oracles supports sources and targets in Amazon EC2, RDS, and Redshift.
• Involved in migrating and planning physical Linux / SunOS/ Windows servers to Oracle and AWS cloud and testing.

TECHNICAL SKILLS

• SQL Server Sybase PostgreSQL MySQL MongoDB AWS dB OS Storage Languages Web Servers Middleware GoldenGate Data Load Replication ERP systems Domain Data model Cross platform WS, OLTP, OLAP, DWH, data center migration, change release, patch management, administration including design, deploy, tune, trouble-shoot, upgrade and integrations, efficient to manage vis 50+dB's.
• Oracle Application Server, WLS, SOA, Amazon Web Services (AWS)
• Apache, Tomcat, Glassfish, WebLogic
• HTML, DHTML, CSS, REST, SPA, JSON, XML, XSL, XSLT, CGI, SNS, SQF, SWF, SMTP, FTP, HTTPS, DNS emacs, vi, perl, ant, make, awk, sed, csh, sh, tcsh, bash, cron, yum, puppet, sendmail, bind, mail, telnet, ssh, rsync, ftp, tripwire, fail2ban, iptables, sudo, yacc, lex
• Rancher,Docker,Puppet,Ansible,Sysdig,Jenkins,Github,DockerHub,Artifactory,Sourcetree,Confluence/JIRA
• Data Guard (DG) Monitoring Tools Backup's recovery Technology Tuning (Sql's, dB's) dB name Changed Upgrade / patch
• 2c, 11gR2, 11gR1, 10gR2, 10gR1, 9i, 8i 11gR2, 11gR1, 10gR2 (physical standby & active data guard).
• 12c Cloud Control, OGG management pack, OEM, grid control, TOAD, putty RMAN, export/import Data pump utility, Transportable Table space, SQL*Loader ASM, EMC, Hitachi SAN.NAS VERITAS, NFS, OCFS
• Explain plan, AWR, ASH, Sql advisor, TKPROF, stat pack, Analyze, DBMS STAT NID for dB name, CCSCAN for character set.
• From 11g to 12c, CDB, PDB, O-Patch, CPU, PSU.
• 2012, 2008, 2005, TSQL, import/export, Network Utility, Query Analyzer, DTS Packages, server mail agent ASE (15.0.1, 12.5.4, 12.0) v9.5, v9.4 PostgreSQL workbench, OPM (Open PostgreSQL Monitoring)
• V5.6, v5.1, MySQL workbench, Monyog, SQLyog
• 3.2.9, OPS Manager, Backup Manager, MongoDB BI Connector, mongoexport, mongorestore, Robomongo Redshift, Dynamo dB, RDS

PROFESSIONAL EXPERIENCE

Confidential, NY

Database Engineer / Administrator / Architect

Responsibilities:

• Managed over 35 Oracle Real Application Clusters (RAC) databases (12c, 11g, and 10g), optimized Parallel Operations, and configured Container database (CDB) with Pluggable databases (PDB) in Multitenant environment.
• Managed over 50 Oracle Golden Gate real time change data capture replication, routing, transformation, and delivery across heterogeneous business systems between Oracle, SQL Server, MySQL, Amazon RDS and Redshift.
• Handled cross platform migrations between Solaris, Linux, SQL Server, Oracle, Amazon RDS and Arora by using Amazon DMS and Oracle GG in conjunction with Oracle database features, a rolling upgrade or a rolling migration and achieved Zero-Downtime.
• Implemented High Availability solutions with Oracle 12c, 11g and 10g RAC, Physical Standby and Active Data Guard Replication.
• Conducted Database Backup and Restore for Oracle, MYSQL and MS SQL databases, Used RMAN for Oracle Database Backup, Restore, Recovery, Clone and Duplicate, managed RMAN catalog. Used Data pump for schema Refreshes, Backup and Restore.
• Administered Oracle Data Warehouse project (DWH), configured Oracle Workflow (OWF) for DEV, STG and PRD, managed Veritas (VCS) cluster, assisted in the design and implementation of DEV, STG and PRD databases.
• Examined, analyzed, and resolved performance related issues for PeopleSoft Payroll and HR modules, and provided resolution, made database or application level changes as needed to implement security for new pay structure.
• Helped performance related issues by using OEM performance modules, ASH, AWR and ADDM, TKPROF, Statspack, Explain plan.
• Handled SQL Server HA (Active-Active, Active-Passive), data replication techniques, database mirroring, transactional replication, log shipping, backups through SQL Lite Speed and VERITAS, database maintenance, SQL Mail, SQL Server agent, and etc.
• Handled MySQL database migration from MyISAM format to InnoDB storage engine to increase performance, Master-Slave, Master- Master configurations and replications, new server setup, .installation, upgrade.
• Handled NoSQL MongoDB installation, configured MongoDB BI Connector for MySQL and PostgreSQL, created DRDL, managed backups and restoration, used mongodump, mongoexport and mongorestore utility, installed Robomongo.
• Handled Oracle SOA cluster, 12c configuration including installation on Linux, created SOA domain, configured JDeveloper, and created WebLogic administrator account during Oracle Fusion middleware configuration.
• Involved in POC for infrastructure design for multitude applications for utilizing AWS stack (Including EC2, Route53, S3, RDS, Dynamo DB, SNS, SQS, IAM) focusing on high-availability, fault tolerance, auto-scaling, configured Route53 to route traffic in different regions.

Confidential

Oracle consultant

Responsibilities:

• Administered SAP Oracle RAC databases, regular maintenance of SAP systems such as client and system copies, system refreshes, and solution manager
• RAC installation and maintenance, cloned databases, migrated databases to different servers, upgraded databases from 10g to 11g R2, AWR reports for performance tuning, Grid Control installation, SQL Servers databases maintenance and support. Remote support of databases, after hour's on-call duties, client meetings, database backups, patching, upgrades in Solaris and Linux environments.
• Implemented integrated GoldenGate replication for zero-downtime, designed, implemented Fallback scenarios using bi-directional replication from the platform migrations.
• Created Materialized views and logs for fast refresh of real-time pricing information to Data Warehouse.

Confidential

Senior Technical Specialist (Technical Lead)

Responsibilities:

• Installed 12c grid server, agent, 2 node RAC cluster, and added 3rd node on existing RAC cluster to increased Oracle capacity in Linux, patched database with latest patches in Linux, Solaris and AIX environments.
• Managed RMAN and datapump backups, registered database in RMAN catalogs, performed database recoveries, schema refreshes by using custom made shell scripts, moved control files in ASM by using RMAN duplicate utility to duplicate the control file.
• Managed ASM space management storage, dropped, created, added disk group and data files, mounted, and dismounted disk group/file system/mount points.
• Handled static or dynamic parameters of RAC cluster, ASM, Data Guard, Flashback logs, implemented Row level Security used VPD for several Integrated Products.
• Tuned long running queries, used explain plan, tkprof, OEM, statspack, analyze, dbms stat & custom scripts.
• Wrote shell scripts and PL/SQL packages to resolve business problems of various natures.
• Support Oracle Active/Passive setup using VCS, Clone the Oracle Home, database and upgrade the database.
• Handle REDO log group with in primary and stand by RAC cluster, provided 24/7 rotation based on call after hours support.
• Resolved Data Guard log shipping issues between primary and secondary, identified missing logs,, restored missing log to primary and recovered, registered that to standby, identified ORA-00261, 00314 (redo log file corrupted, seq. nnn doesn' Confidential match xxx).
• Handled Sybase ASE databases installation, creation, HA design, database level security privileges including roles, password, grants, full or partial database access, purged transaction logs, performed bcp, dbcc health check, automated multi database refreshes jobs
• Established GoldenGate replication on different database including classic and integrated topology from compressed tables.

Confidential

Lead Database Administrator

Responsibilities:

• Created, installed and maintained Oracle databases and applications supported Oracle databases for versions 9i, 10g and 11g and assisted end-users with database issues.
• Handled RMAN set-up and use for database backups and restoration in Linux, Solaris and AIX environment.
• Administered SQL Server 2008 R2, which had PeopleSoft Application running on them.
• Identified, resolved configuration issues for poor performance and out-of-sync data in bi-directional Shareplex replication database.
• Handled advanced technologies including GoldenGate and Active Data Guard and implemented production data moves from one data center to another with zero downtime.
• Handled fine-grain row level security for masking data, used VPD for integrated products, created physical, logical database.
• Tuned long running queries, used explain plan, tkprof, OEM, stats pack, analyze, dbms stat & custom scripts.
• Handled Data Guard setup, confirmation, used DGMGRL or OEM interface for monitoring, switchover and failover.

Confidential

Oracle & SQL Server DBA

Responsibilities:

• Used Oracle migration workbench for SQL Server migration to Oracle and Upgraded 9.2.0.5 to 10.2.0.4.
• Installed, monitored and troubleshoot Oracle 8i, 9i and 10g databases on Windows, Linux & UNIX environment.
• Implemented and tested disaster recovery strategy using RMAN 9i with catalog & without catalog and VERITAS.
• Refreshed and duplicated database through RMAN and import/export, migrated 32 bit to 64 bit used TTS feature.
• Upgraded SQL Server from 2000 to 2005, created dBs, transaction logs, DTS packages, import, export, data transfer, bulk insert.