PROFESSIONAL SUMMARY:

• Over Eleven (11+) years of experience in software development and database administration for real time, live systems.
• Extensive knowledge in administering and securing large scale and High - Volume transaction processing (Stock Exchange) database along with database cluster deployment and administration experience.
• Successfully deployed monolithic application in clustered database increasing web application scalability.
• Years of experience in replication and cluster technology along with hands on experience in state of art Business Intelligence (BI) technologies to facilitate Decision support system.
• Securing Oracle Database 10g, 11g and 12c following best practices
• Administering Oracle 10g, 11g, 12c RAC Dataguard Primary/Physical Standby Database in RedHat/Suse/Oracle Linux environment
• Administering bidirectional 3-way multi master Goldengate replication between RAC Databases
• Tuning Oracle Database for Netapp All Flash FAS Storage and managing it
• Ensuring best practices for Oracle WebLogic 12c Two Phase Commit/XA transactions
• Using log dump to read golden gate trail files to pinpoint replication issues
• Logmine redo log files for granular detection of DML(s) run in specific time
• Analyzing ASH and AWR reports for performance bottlenecks and historical AWR/ASH views to interpolate performance trends
• Analyzing SQL trace using tkprof and trcsess for session, service, client, action and module specific issues
• Automating software provisioning, configuration management and database deployment using Ansible
• Stress Testing using Gatling automated test scripts for major application and database configuration changes or migration
• Implement production load in TEST Database prior to configuration changes or software release installation using Oracle Database Replay
• Detect regressed SQL using oracle SQL performance analyzer
• Performance tuning and capacity monitoring using Oracle Enterprise Manager (OEM) cloud control
• Administer ASM disk groups in FC SAN/iSCSI Storage LUNs
• Using tfactl to analyze overall system logs for proactive monitoring of system issues
• Running oratop to analyze real time RAC performance issues
• Manage Symantec Veritas Cluster Server Storage Foundation
• Manage Database Servers ensuring 99.99% uptime
• Maintain scheduled logical and physical backups using cron scripts
• Design and implement centralized tape and disk backup policy of Netbackup Enterprise Server 7.0 for overall data center via master and media servers
• Automate routine health check, backup check, alert log, Dataguard log shipping, Goldengate lag employing monitoring scripts and OEM Cloud Control alerts
• Perform RCA and apply zero downtime rolling RU(s), RUR(s) or OneOff patches if need be
• Developing SQL Server Integration Service Packages for parsing production data to archive databases
• Administer SQL server 2008, 2012 Databases for data archival
• Design and develop ad hoc Crystal Report for management
• Installation, Configuration, Upgrad ation, Migration of largescale database environment
• Implemented Oracle Advanced Security features of Transparent Data Encryption, Audit Vault and Database Vault for PHI information
• Hands on experience with Oracle BI publisher, server and ODI and OBIEE tool

TECHNICAL SKILLS:

Database: Oracle 10g, 11g, 12c; MS SQL Server 2008, 2012, MySQL 5.0, Sybase

Database High Availability: Oracle 10g/11g/12c RAC, RAC one node

Operating System: HP-UX, Sun Solaris (5. 64), Redhat Enterprise Linux 6.5 Server, Oracle Linux 6.0, SuSe Linux, Ubuntu

Programming Language: C, C++, C#, Java

Framework: Spring, .NET, CodeIgniter

Object relational mapper: N-hibernate, Hibernate, Entity Framework

Scripting Language: SQL, PL/SQL, bash, korn, PHP, Perl, Python

Data Access Tools: Toad, SQL Plus and SQL developer

DB Monitoring Tool: Oracle Enterprise Manager (OEM) 11g and 12c Cloud control, OEM console

Data Backup and Recovery: Recovery Manager (RMAN), DataPump and Export-Import

SQL Tuning and monitoring Tool: Explain Plan, ASH, AWR, ADDM, SQL Trace

Database Replication: GoldenGate, DataGuard

Database Security: Data Masking, TDE, Data Redaction, Database Vault, Audit Vault

Data Warehouse and BI: Oracle Business Intelligence Enterprise Edition

Project Management Tool: JIRA

Source code management system: GIT

IDE: IntelliJ IDEA, Visual Studio 2010, Android Studio, Eclipse, Dreamweaver CS2

Data Modeling Tool: Visio, SQL developer, Oracle BI Admin Tool

Virtualization: VMware, VirtualBox

Orchestration Tool: Ansible

Application Server/ Middle Tier: Tomcat, Weblogic, Oracle Tuxedo 8.1

Build Management System: Gradle, Maven

PROFESSIONAL EXPERIENCE:

Confidential, CT

Senior DBA / Software Architect / Oracle RAC Administrator

Responsibilities:

• Administer large scale 3 node Oracle RAC Database and single instance databases
• Manage database on ASM diskgroup and NFS mounts.
• Maintain Goldengate replication across sites and other Database Servers
• Manage staging, develop and beta context single instance and cluster databases
• Maintain Oracle 12c Data Guard physical standby database for repository database
• Maintain database security using audit vault, TDE, Database Vault and deploy considering overhead
• Deploy data compression and backup compression keeping performance and storage trade off in mind
• Devopsify migration of database contexts using ansible
• RCA of performance bottlenecks using ASH, AWR, ADDM and Trace files
• Preparing least cost and optimized SQL/PLSQL queries, functions and procedures
• Updating monitoring scripts in cron with new release and software features
• Logmine redo log and Logdump trail files for analyzing and resolving replication issues
• Datapump tables for migration purpose and manual sync of databases due to human error/replication issues
• Designing ER Diagrams working with developers
• Configuring and tuning ORACLE BI Server for Data Warehouse and planning replication from source to production database
• Distribute Therap EAR modules based on workload to different database services in Oracle RAC 12c Database
• Run Gatling automated tests to stress test application workload in local test cluster databases prior to go live
• Analyze single instance bottlenecks to appropriately justify deployment in RAC database
• Track performance bottlenecks using Global AWR, ADDM reports
• Run oratop to analyze real time RAC issues
• Logmine redo and Logdump trail files to resolve replication issues
• Run Orachk verify oracle RAC setup
• Run racdiag and procwatcher to detect RAC performance issues

Environment: Oracle Enterprise Linux 6, Oracle Grid Infrastructure 12c, Oracle Database 12c Enterprise Edition, Gatling, Python, Oracle Audit Vault, Transparent Data Encryption

Confidential

Responsibilities:

• Implemented Data warehouse for secure and confidential system which contains confidential and PHI data sizing more than 3TB
• Developed architecture for data warehouse and flattened all transactional schema into reporting schema following data warehouse schema design pattern (Star, Snowflake, Fact constellation)
• Created logical and physical data models for reporting tool following denormalized architecture
• Streamlining the data collection process from transactional database to warehouse database and also from heterogeneous sources by developing ETL process
• Automated ETL process has been developed to collect data on daily or weekly basis based on the volume
• ETL process manipulation has been handled carefully using SQL, Python scripts
• Query Optimization has been taken into account using partitioning, using bitmap index, star transformation query rewrite
• Ensured load tolerance using load testing tool Gatling and Jmeter
• Designed the layering architecture from warehouse to data visualization tool
• Developed analytical report for data visualization tool (OBIEE)
• Developed adhoc reporting for KPI
• Developed a system to restrict usage on analytical/adhoc report access
• Implemented Single Sign On facility with primary application deploying LDAP

Environment: Oracle BI Admin Tool, Oracle Data Integrator, Oracle Business Intelligence Enterprise Edition, Weblogic 12c, Oracle Database 12c Enterprise Edition, Oracle Enterprise Linux 6

Confidential

Responsibilities:

• Review and Collect all the DDL and DML migration scripts from GIT, checking, preparing and running in local and demo Oracle database servers (10gR1, 11gR2 and 12c), integration testing, load testing, implementing Flashback technologies, downtime estimation.
• Final release database migration in Production databases by estimating downtime, running migration scripts, index rebuild, statistics gathering, handling GoldenGate Replication Lag and ggs errors.

Environment: git bash, Oracle Goldengate 12c, Oracle Database Server Enterprise Edition, PL/SQL, Oracle Enterprise Linux 6.0, Gatling, Python

Confidential, BD

DBA / Back end Developer / Front end Developer / Oracle RAC Administrator

Responsibilities:

• Administer 1500 tps 2/3 node Oracle 11g and 10g RAC database in Oracle Enterprise Linux and Suse Linux Enterprise Server (SLES)
• Administer Sybase, MS SQL Server 2008, 2012 Database
• Manage application Cluster of Millennium IT (London Stock Exchange Group Technology) Trading engine
• Administer Veritas Cluster Server Storage Foundation to store data files
• Manage Oracle 10g and 11g Dataguard for DR site replication
• Develop Software Interface for stake holders for data feeds from downstream gateway
• Design Symantec Netbackup 7.0 Enterprise backup policy for all application, web and database servers disk and tape backup
• Develop MS integration service packages to parse Trading engine data and feed other systems
• Develop Web service for heterogeneous client application
• Develop features for Android application of Capital Market Trade Data Information
• Ad hoc Reporting on Crystal Report for Print Media and News channels.
• Maintain batch files and FTP scripts to generate files of different formats for legacy systems
• Switchover and Failover to DR site in order to verify DR Site readiness
• Configuration, patching, and backing up all test and production databases
• Install and configure 2 node Oracle 10g RAC Database for FIX and FAST based MiT Exchange Engine
• Install and configure 3 node Oracle 11g RAC Database for IndigoTx Order management system
• Install and configure Symantec Veritas Cluster Server Storage Foundation to store data file
• Configure application servers in SLES for trading engine
• Monitor Oracle Tuxedo for IndigoTx Order Management System
• Configure Oracle 10g and 11g Data Guard for DR site replication
• Configure Down Stream Gateway and develop TCP listener for dumping daily trading data to historical MS SQL Server 2012 database
• Develop MS SQL Server 2008 Integration Service packages to feed data to other systems
• Develop Web Service for push and pull based service data feeds

Environment: Suse Linux Enterprise Server 11, Oracle Enterprise Linux 5, Oracle Tuxedo 8.1, MS SQL Server 2012, MSMQ, Oracle Grid Infrastructure 10g/11g, Oracle Dataguard 10g/11g, Oracle Database 10g/11g, Tomcat application Server 8.0, Apache Web server

Confidential

Responsibilities:

• Develop TCP Listener for market data feed to Oracle 11g database in RHEL
• Configure Oracle 11g single instance database with proper backup policy to dump captured data
• Develop Spring 4.0 Web service for pull based application client in Tomcat application server to fetch from configured single instance database
• Develop Confidential Cloud Android application using Android Studio for investor and publish in Google Play Store

Environment: Visual Studio 2010, .Net Framework 2010, C#, MS Windows server 2008 R2, Android Studio, Oracle Database 11g, Redhat Enterprise Linux 6, eclipse, Spring 4

Confidential

Responsibilities:

• Develop desktop application using Windows Presentation Foundation
• Design Graphical User Interface using Microsoft Expression Blend and Microsoft Expression Design
• Design User Control with animations using Extensible Application Markup Language (XAML)
• Use Entity Framework 4.0 as Object Relational Mapper
• Develop SQL Server Integration Service packages for running ETL to import data from other databases

Environment: Visual Studio 2010, .Net Framework 2010, C#, MS Windows server 2008 R2, MS SQL Server 2012, SQL Server Integration Service, Entity Framework 4.0, Windows Presentation Foundation, Microsoft Expression Blend, Microsoft Expression Design

Confidential

Responsibilities:

• Develop SOAP based web service using Windows Communication Foundation
• Develop WPF desktop application conforming MVVM
• Develop Android app to fetch data from Web Service
• Design desktop application Using MS Expression Blend

Environment: Visual Studio 2010, .Net Framework 2010, C#, MS Windows server 2008 R2, MS SQL Server 2012, Entity Framework 4.0, Windows Presentation Foundation, Microsoft Expression Blend, Microsoft Expression Design, Windows Communication Foundation 4.0, SOAP, Android Studio

Confidential

Responsibilities:

• Configure Symantec Net Backup 7.0 master server and media server
• Configure HP StorageWork MSL 4048 Tape Library for enterprise backup
• Configure Application backup for direct RMAN backup to tape
• Design backup policy for backing up application data, logs, trace and data to disk and tapes
• Deploy staged backup for faster RTO
• Schedule backup window keeping performance SLA and resource availability in mind throughout the enterprise

Environment: Suse Linux Enterprise Server 10, Netbackup Enterprise Server 7.0, RedHat Enterprise Linux 5.0, RMAN

Confidential, BD

Back end Developer / DBA

Responsibilities:

• Manage Official Website and update contents as and when required
• Develop open credit registration system using php and apache web server
• Design ER diagram and schema for Student Registration system
• Configure and maintain MySQL5.0 database for student and faculty database
• Manage SAMBA server in RHEL 6 for student and faculty file sharing
• Implement and maintain OpenLDAP server for student roaming profile in Computer Labs
• Develop Flash based Ads for third party website and monitor referrals for advertisement budgeting
• Develop web application for open credit registration system using CodeIgnitor and PHP5.0
• Use PHPMyAdmin to manage production data and backup
• MySQL Workbench to design Schema for application
• Configure WAMP to test application before production deployment
• Facilitate Attendance sheet print out system for classes from application

Environment: RedHat Linux, Apache Web Server, PHP5.0, MySQL 5.0, MySQL Workbench, Codeignitor, PHPMy Admin