SUMMARY:

• I have around 11 years of skilful experience working with database technologies in heterogeneous platform for various business domains (Telecommunication Mediation, Billing, Banking, Insurance and data management ) using Oracle, DB2, Mysql, Volt DB databases and tools in Unix and Windows environments.
• I have repeatedly demonstrated the ability to Research / learn / develop/execute/evolve/tune persistence solution for business application to achieve company goals. My biggest strength is my comprehensive experience, Energetic self - starter with excellent analytical and organizational skills, highly adaptable in quickly changing technical environments
• 11 years of hands on experience in design and development software application using C, C++, PL/SQL, Oracle Database, scripting and expertise in design & implementation of replication using oracle GoldenGate.
• Designed and developed Database maintenance automation scripts for handling client databases.
• Having around 11 years of experience, handling Database design for real time application (OLTP), transaction processing (enormous size), in-memory database solutions, active-active database solutions, multi-master replications and scalable Infrastructure.
• Expert in Oracle Goldengate Architecture, Design, development, troubleshooting active-active, multi master replication ( Oracle to Oracle, Oracle to mysql) and knowledge on Oracle GoldenGate for BigData - Cassandra, Kafka.
• AWS - Experience in maintenance and configuration of user accounts for dev, qa, and production servers and created roles for EC2,RDS, s3, Cloud Watch, EBS resources to communicate with each other’s using IAM. Experience in migrating and implementation of multiple applications from one on premise to cloud using AWS services like SMS, DBMS, Cloud Formation, s3, Route53, Glacier, EC2, RDS, SQS, SNS, LAMBA, AND VPC. Public and private subnets, security groups, Route Tables, Elastic Load Balancer. Build servers using AWS, importing volumes, launching EC2, RDS, creating security groups, Auto-scaling, load balancers (ELB’s) in virtual private connection. Experience in designed AWS clound Formation templates to create multi region web applications and databases.
• Hands on experience in handling complex data migration planning, execution, Reusable Data transfer frameworks design and development using Oracle SQL, PL/SQL, Shell script, bash scripts, perl, Oracle DBMS Job scheduler.
• Hands on experience in optimize database performance, sql query tuning, troubleshooting database performance issues.
• Good knowledge and experience in oracle/db2/MySQL database utilities like data pump utility, DB2MOVE, DB2CLI, RMAN, ASM, RAC, Data Guard, Exadata Machine.
• Good knowledge on Mongo DB/ Apache Cassandra - NO SQL Database and Volt DB in-memory database.
• Create processes, common frameworks (APIs) for commonly use persistence methods.
• Programmer analyst having hands on experience in the analysis, design, and development, implementation, troubleshooting and debugging in enterprise applications in windows and UNIX environments using C++/ pl/sql, Proc*c, (Nokia QT), Oracle, Confidential DB2, MariaDB and Mysql RDBMS.
• Hands on experience on all phases of software development life cycle (SDLC)/ Agile, DevOps model.
• Expertise in application design and development using C, C++ with QT, Data structures, UML, Design Patters, SQL, PL/SQL, OCI, Stored Procedures, Database design, programming, tuning and query optimization.
• Strong programming skills in C++, QT, XML, SQL, PL/SQL units of procedures, functions, materialized views, Bulk Collections, Ref cursors and packages in software product Development.
• Strong knowledge in Oracle cursor management and exception handling.
• Extensively involved in developing programs to import data from legacy system into oracle database using SQL*Loader.
• Database Architect for High volume data processing requirements.
• Application architecture review and documentation using Confidential Rhapsody.
• Good knowledge in Awr Reports Analysis, Trace analysis using TK Proof
• Setup, design, development of configurations, maintenance and monitor heterogeneous bi-directional data replication system using oracle golden gate.
• Experience as On-Call 24x7 production DBA support, application/development DBA/ Golden gate Developer/DBA.
• Developed database monitoring/health check alert scripts for database and Golden gate

TECHNICAL SKILLS:

Programming Languages: C, C++/ Datastructurs/Design Patterns, VC++, SQL, Oracle PL/SQLScripting Languages

Shell, DSD, Python, Perl: Operating Systems

Windows NT, Unix, Linux, Solaris: Databases

Oracle8i/9i/10g, 11g, 12c, DB2 UDB, MySQL 5, MS SQL Server, Volt DB.: NO SQL: Cassandra, MongoDB, HBase

Tools: SQL Loader, SQL Developer, Rational Rose, TK Proof, TOAD,PL/SQL, OEM,, DB2 Control centre, DB2 Workbench, DB2Move, DB2Load, MKS, Rhapsody, Visual leak detector, Windbg Oracle Enterprise Manager Plug-in, Oracle GoldenGate Monitor, and Oracle GoldenGate Director, Oracle GoldenGate Veridata 12c, Kafka.

Requirement Management: Confidential Rational DOORS, Atlassian JIRA

Configuration Management: MKS, Visual Source Safe, svn, Git and Github

Static Code Analyser: QAC++

Unit Testing: Qt Unit Testing Framework, Junit

IDE: Visual studio2005, Vi Editor, QT Creator, Eclipse

WORK EXPERIENCE:

Senior Software Engineer

Confidential, ATLANTA

Responsibilities:

• New database objects creation and review of database procedures / scrips as per the
• Analysing requirement for data replication
• Goldengate replication design document preparation, identify suitable replication methods.
• Maintenance of goldengate code repository in svn.
• Prepare parameter files, deployment .oby files, release notes, goldengate initial setup and deployment document preparation and maintain up to date as per the new implementation changes.
• Monitoring goldengate processes.
• Develop reusable scripts for goldengate process monitoring and Ad-hoc data sync framework development.
• Troubleshooting all database and goldengate production /QA/ Deveopment /E2E/QC environment issues.
• Handling Database and GG projects projects deployment rolloverss and post deployment validations
• Adopting new oracle and golden gate features into mediation system.
• Project Requirements Understanding and High level design (HLD) Documents preparation and Design document preparation.
• ADD Design document preparation, Add Review with client and other teams involving in the scope of solution, solution implementation, unit testingResponsible for New CSG, S-GW, P-GW Filters Implementation, Data & Voice Mediation summarization, enrichment, and output modules for sending data for Enabler for Billing, Balance Manager, I Care downstream applications.
• Design physical database layer to manage ~5-10 billions transactions/day with scalable infrastructure
• Develop Golden Gate replication & scale to replicate huge dataset with minimum lag.
• Development of Generic GG Framework Templates and standard release structure for database and golden gate objects .
• Prepare templates for DDL objects creation, Installer script for installing database objects in Multiple schema in multiple database based on configurations.
• Common re-usable framework development like Data Transfer, data sync, Installation, DB Snapshot, Online gg data sync.
• DUPS / Error tables Data transfer framework using parallel jobs
• Oracle Goldengate Online Data sync framework .
• Oracle analyse tables framework for effective maintenance of oracle table and index level
• Designed and Involved in writing UNIX Shell Scripts for maintains tasks for oracle database.
• Writing complex PL-SQL Procedures and Functions for business logic implementation and data management, production backlog clearance .
• Worked on data modelling using Oracle SQL Developer Data Modeller/ Toad Data Modeller.
• Database objects Code review, release notes review
• Mentor teammates and build skills to fulfil future project needs, Review code and functional test cases
• Support infrastructure projects including capacity planning, migration of platform and high availability (active-active and active-passive solutions).
• Create new database procedures, functions, optimize Tune / Rewrite PL/SQL solutions to meet performance criteria and aggressive SLA with inter applications.
• Manage multiple environments for various projects
• Participant in companywide major releases to meet business goals. Participate to design automation process and utilities development.
• Performed Data Management activities using Oracle Utilities like SQL Loader, Import and Export.
• Developed shell scripts/Perl/PLSQL scripts to implement data migration.
• Provided 24x7 supports for Confidential & Confidential Data Mediation/ Voice /MVHS mediation streams.
• Work Requests Queue monitoring and resolving high priority Production WR’s
• Release Notes preparation and Review with Client.
• Work requests distribution and code review and mentoring team members.
• Oracle AWRr reports analysis and performance tuning and Database design for new modules.
• Coordination with production DBA to resolve critical issues.
• Subject Matter expert for all Golden gate implementation for various mediation streams.
• Deployment manager for all database related deployments / Production Change requests (CR).
• Deployment Validations and Post deployment database health check.
• Handling Planned and Un-planned data centre Failover / Disaster recovery for production database.
• Managing development / Test database maintenance and upgrades.
• Working with Production PDBA on critical database issues resolutions, User schema design, Privileges required for Business logic schema .
• Developed re-usable oracle table Partition creation and deletion (drop/archive), copy-stats based Analyse tables, bl objects clean-up frameworks and job scheduling framework .
• Data modelling for new project and existing projects optimization/Change requests comes from client.
• Developed Database schema snapshot Utility ( impdp / expdp - DataPump) to clone production version database in development and testing environments.
• SME for Data migration activities
• Monitoring WebTrax/ HP-QC - Work request ticketing system for Incoming work Production Support/ Enhancement Requests from Client Architect / New Project work.
• Involved in monitoring the Database related activities using Oracle Enterprise Manager 11g/ 12c Grid Control (OEM Grid)
• Experience in maintenance and configuration of user accounts for dev, qa, and production servers and created roles for EC2,RDS, s3, Cloud Watch, EBS resources to communicate with each other’s using IAM.
• Experience in migrating and implementation of multiple applications from one on premise to cloud using AWS services like SMS, DBMS, Cloud Formation, s3, Route53, Glacier, EC2, RDS, SQS, SNS, LAMBA, AND VPC. Public and private subnets, security groups, Route Tables, Elastic Load Balancer. Build servers using AWS, importing volumes, launching EC2, RDS, creating security groups, Auto-scaling, load balancers (ELB’s) in virtual private connection.
• Experience in designed AWS clound Formation templates to create multi region web applications and databases.

Environment: Convergent Mediation (Middleware), Java, JBoss, Oracle 12c/11g, VoltDB in memory DB, Golden Gate 12c, MariaDB, Cassandra, UNIX Shell Scripting / Linux bash, Toad, HP UX B-11i, SunOS 5.10, RHEL 6.x, Zerto, vSphere and VMWare, Oracle Enterprise Manager Database Control, RDBMS, TOAD, PL/SQL, ASM, AWR, ASH, Data pump, SQL, TOAD, TKPROF, STATSPACK, putty and Winscp, Eclipse, perl.

Confidential

Senior Engineer/ Architect / DBA

Responsibilities:

• Requirements understanding ( Confidential DOORS Documents)
• Analysis and Requirement clarifications, prototype design.
• Design and Development of Core Components in Application and Database design
• Notification Monitoring agent
• Filesystem Watcher
• Database connection Manager
• Database Extraction Engine
• Query Builder
• Customized XML Loader
• Conducting weekly sync meeting with onsite client team
• Code reviews, peer reviews, check list preparation.
• Providing support team members in Planning, Effort Estimation, Process Tailoring and Project Execution
• Database Design and implementation, database Maintenance
• Performance tuning Application and Database.
• MySQL - Developer cum Database administration
• Oracle PL/SQL Objects creation and reports generation.
• Weekly - Software Tools Development Group update - Presentations to Management.
• Study client’s existing business process and Identify scope for Improvements
• Reusable Framework design, development and training to respective team members.
• Helping team members on overcoming technical challenges and mentoring

Confidential

Senior Software Engineer

Dev Env.: C++, QT, Oracle, Mysql, DB2, SQL Server 2000, KEENAN, PLSQL, Windows, AIX, HPUX

Responsibilities:

• Requirements understanding of various discounts applicability process
• Discount implementation priorities.
• Understanding Keenan database structure.
• Designing intense configuration database designing for discounts computations.
• Extraction logic building, Writing SQL Queries, stored procedurs for ValidationsDiscounts calculations. Integration of Stored procedures with product.
• Database Architect, Developer cum Application DBA
• Implemented Database Partition creation And Drop old partitions framework .
• Implemented Bulk data Loading and Unloading API Procedurs .
• Performance tuning of Application level Sql queries and Stored procedures.
• Confidential Application level configurations.

Confidential

Tech Lead

Technologies: C++, QT, SQL, PLSQL,SQLLDR, Oracle Windows, Aix

Responsibilities:

• Query modifications and Tuning Sim Searching, Mobile Number Searching, Show All Functionality.
• Stored procedures Review Check list preparation, bjects tuning guide lines to team members,
• Performance tuning of sql and pl-sql code.
• Review of core database objects, tuning
• Tuning ad-hoc reports.

Confidential

Senior software engineer

Technologies: C++, QT, Shell, Perl ScriptingSQLLDR, DB2, ODBC, ORACLE, DB2, MYSQL, TIMESTEN, AVL DATA, Windows,Aix,HPUX

Responsibilities:

• Designed, developed and implemented IECCM DBE, Query Builder, DB Interface, Custom Indexing Interface and Variable Data Processing and RSMC modules.
• Multiprocessing implementation for Database Extraction.
• Developed interface modules to extract data from Database using C++ and PL/SQL procedures. PL/SQL, SQL, Oracle 8i/9i/10g, DB2, ODBC under Windows/Unix environment.
• Coded, tested and implemented database triggers to enforce business rules using PL/SQL.
• Analyzed, developed and implemented different Database Interaction modules.
• Coded, compiled and debugged C++ applications in Visual studio 2005 environment.
• Controlled Version using Visual SourceSafe.
• Involved in design, coding, unit testing and writing FRD’s.

Confidential

Senior software engineer

Technologies: C++, QT, SQLLDR, DB2 Move, Pro *c, Embedded SQL, ORACLE, Windows, Aix, HPUX

Responsibilities:

• R&D on Bulk Loading activity for Various databases
• Analysis, Design, Development, implementation, Unit Testing and Documentation

Environment: SQL Loader (Direct path Loading, Conventional Path Loading, DB2 Move, Embedded SQLProject

Confidential

Senior software engineer

Technologies: C++, QT, DB2 Windows And Confidential -AixDescription:

Responsibilities:

• Designed, Developed User Interface for Back out process using QT GUI Tool kit, C++, PL/SQL, SQL under Windows / UNIX environment.
• Developed interface modules to extract data from legacy application database using Oracle SQL Loader and PL/SQL procedures.
• Tested application with Quality Testing Engineers using structured testing methodology Tenfold Automated Testing Tools.

Environment: C++ (QT), PL/SQL, Oracle, DB2, Mysql, SQL Server 2000, ODBC, Oracle 9i, SQL, Windows and AIX-Unix.

Confidential

Senior software engineer

Technologies: C++, QT, Windows, Aix Unix

Responsibilities:

• Designed, developed and implemented Env Manager application for manage all Configuration and Licensing Details of Servers, Databases, Clients, Sub Clients Registered Under various Domains Present In IECCM Enterprise Edition .
• Team Member, Sole Responsible for Maintain Data Classes Confidential Client side.
• Involved in coding, unit testing and writing FRD’s.

Environment: C++, QT Library, Windows / Aix UNIX.