TECHNICAL SKILLS

Cloud Infrastructure: AWS, Oracle Cloud, Azure

Database Administration: Oracle, MySQL, SQL Server

Fusion Middleware: GoldenGate, WebLogic, SOA Suite, OEM

NoSQL Database: Cassandra, Hadoop (HBase)

Engineered System: Superclusters, EXADATA, Veritas

DevOps Tools: Jenkin, Autopilot, Git, DBLM

PROFESSIONAL EXPERIENCE

Confidential, Mountain View, CA

Sr. Database consultant

Responsibilities:

• Orchestrated and implemented GoldenGate Infrastructure for client Enterprise data warehousing platform for Oracle ERP and Teradata databases. Also engineered GoldenGate auto - monitoring using OEM and shell scripts.
• Active-Active configuration of Golden Gate replication for e-commerce application, provide end to end support for active-active replication and involved in troubleshooting of Golden Gate issues.
• Implementation of Oracle Security tools such as Audit Vault, TDE and DB Firewalls. Implemented GDPR/SOX/PCI guidelines in database for data protection and security.
• Coordinated and executed Cloud Migration project from on-premise datacenter to Azure/AWS Cloud platform for suite of e-commerce application’s databases using GoldenGate, RMAN, TTS and data-pump.
• Established myself as key contributor for supporting, patching, upgradation, end to end management of Symantec Database Infrastructure for Oracle, MySQL databases using RAC, ASM, Data-Guard, PSU, OEM, InnoDB, NDB on Superclusters, ZFS and EXADATA storage.
• Installation, configuration and end to end management of Oracle SQL Server databases.
• Planned and implemented Cassandra database for client’s No-SQL implementation initiative which involved setup infrastructure and migration of data into Cassandra DB using GoldenGate and Informatica.
• Setup and maintain OEM Cloud Control for R12 and R13 from scratch. Configured database provisioning and fleet maintenance for database stack. Configured and enabled alert and monitoring mechanism for OEM.

Confidential, Tampa, FL

Infrastructure Specialist

Responsibilities:

• Established myself as key contributor for supporting, patching, upgradation, end to end management of Prepaid and healthcare databases as well setting up GoldenGate Infrastructure for data migration projects.
• Contributed and Implemented Cloudera Hadoop Infrastructure for 21+ nodes for Client’s decision support system reporting using HBase, Zookeeper, YARN, HIVE, HDFS and Kerberos.
• Successfully configured SQL Server database system for client ticketing application used for problem tracking.
• Organized design/implementation documents and performed various infrastructure implementations and Upgrade processes such as Informatica/Oracle/Java upgrades.
• Successful automated database scripts deployment using DevOps tools like Jenkin, autopilot, Git, Shell Scripts.
• Improved various DW and OLTP system by implementing performance techniques using, OEM, SQL Advisory, performance diagnostic reports and performance views.
• Implemented migration of DSS based application to AWS cloud using S3, Glacier, EC2, VPC and Load Balancer.
• Responsible for reviewing Infrastructure implementations and Upgrade processes. Performed POC with Infrastructure team, making solution document for processes and co-ordination for end to end implementation.
• Setting up GoldenGate replication for unidirectional and bidirectional to migrate data among various systems as per the requirements from client.
• Implemented Database Oracle Advanced Security in critical applications and databases.
• Database Tuning using Oracle Advisor, ASH Reports, ADDM, AWR SQL Reports and Cloud Control.
• Build and configured up Disaster Recovery (DR)system for client OLTP and OLAP applications.

Confidential, Dallas, TX

Sr. Oracle DBA

Responsibilities:

• Administered Oracle Database Infrastructure by installing Oracle 10g/11g/12c databases using RAC, ASM, Data Guard instances and GoldenGate Infrastructure to increase high availability, scalability and disaster recovery.
• Implemented Oracle EBS 11i suite for client ERP financial module. Involve in cloning, patching, refresh and end to end management for E-business suite application and databases.
• Database and SQL Tuning using Oracle Advisor, ASH Reports, ADDM, AWR SQL Reports and Cloud Control.
• Installation and Configuration of Oracle Data Integrator (11.1.1.6) for ETL purpose. Deployment through ODI Studio for ODI code, patching, up gradation of ODI Tool and Maintenance.
• Installation and Configuration of Fusion Middleware Components like Oracle SOA Suite (SOA/OSB/JMS) (11.1.1.5), ODI Infrastructure, 12c Cloud Control using WebLogic, Tomcat.
• Installation and Configuration of Oracle 12c Cloud Control setup monitoring for all Database and Middleware applications. Implemented Metrics, proactive notifications for all Oracle Systems.
• Led a team of DBAs working on database upgrades, applying patches, data model changes, and security administration.
• Worked closely with ETL developers and tuned data loading techniques and SQL queries.
• Installation and Configuration of Oracle 12c Cloud Control setup monitoring for all Database and Middleware applications. Implemented Metrics, Notifications for all Oracle Systems.

Confidential Atlanta, GA

Team Lead (Database Technologies)

• Demonstrated Leader capabilities and guided team of 12+ DBAs for sustain support of Oracle Database Infrastructure, migration/upgradation projects. Implemented database security using TDE and DBMS CRYPTO.
• Pioneered myself in migrating multiple Oracle Databases from Sun Solaris/AIX to Linux based system.
• Database Memory/SQL Tuning using STATSPACK, SQL Profile, ASH/AWR reports, and custom scripts.
• Worked very closely in implementing Oracle OEM Grid control and mentoring all the database through the grid. Also, analyzed AWR reports daily and resolved the issues, if any.
• Pioneered myself into database performance analysis, capacity planning, system sizing and ongoing maintenance/tuning to ensure maximum performance.
• Helped the DBA team to implement, tested and maintain backup and recovery procedures using RMAN.
• Instrumental in creating the backup/recovery and Disaster recovery strategies and helped the DBA team to follow them.