SUBRAMANI MOHAN RANGTHALE

SR DATABASE ARCHITECT/DEVOPS ENGINEER

EXPERIENCE

Senior Database Architect / DevOps Engineer

March 2008 - Present Citizens Financial Group - Citizens Bank

Working on Online Bill Pay, Deposits, PEP+, Clearing house, Wire Transfer, Risk Management, Commercial, Retail, Treasury Solutions and digitalization projects

Working on OLTP and Datalike, ODS, Data warehouse, Mining, MDM Info sphere applications

Working as DevOps engineer for different Projects

Strong knowledge of Code Commit, Code Deploy, CI/CDPipeline

Strong knowledge with OpenShift, Platform and

Kubernetes and Docker containers

Involved working with AWS Cloud PostgreSQL Memory Size,

EBS Volumes and S3 Bucket.

Working on some of projects on Dynamo DB.

Familiar with IAM Security Policy,KMS Keys and SG Parameters and DB Parameters.

Working with application team to develop Rest API to get data from Postgre for data caching to reduce performance issues.

Extensively using AWS console.

Working on AWS Cloud to Build RDS instances, using the Terraforms.

Terraforms extensively using to build Instances for the database for MYSQL and POSTGRESQL DB,

Git, Bit Bucket and used Data Pipe Line- Jenkins used

Working and building Cloud story in Jira Board and taking onboarding cloud information from Confluence Pages

Daily basis working with Cloud team on Application standard

And automation process of the databases.

Environment: ER Studio, ERWIN,

Good understanding of failover and very strong knowledge on multi avaailbity zones (AZ).

Tested DR in IB Region of the databases and failover from IA to IB Regions.

Created multi clusters for the different databases.

Tested failover in DR Region IB of the databases

Saved $ 3million dollars for the Bank

Also, some project worked on DB2 Z/OZ

PGadmin Tool, MySQL Admin Tool, DB2 Version 12.1, DDF, OLTP, Explain Plan table, AWS Cloud Terraforms, Git, Bit Bucket, Jenkins and Data Pipe Lines, Cloud Watch and Data Dog and, Cloud Trail, Glue, Atenas and Endpoints

Database Architect

January 2007 - January 2008 Computer Science Corporation/Zurich Financial

Involved in Database design, Performance tuning, troubleshooting to monitor the database activities

Worked on Physical Design of Databases – Data ware House and Claims – Z/OS Operating System

Worked on DB2 multi-terabyte database Partitions

Strong Experience on Database Maintenance Activities – Reorg, Runts, Export, Import and Load

Worked on Database Objects

Strong Experience on UDB Physical Design of the database

Strong Experience on SQL Queries and Produced complex Reports

Interacted with the users, Developers, business analyst, storage management group, project managers, server groups and testers

Strong Experience on a Warehouse, OLTP databases and DATAPROP (Replication) projects

Strong experience on Database Maintenance Activities – Reorg, Runts, Export, Import and Load

Involved with Unix Admin to setup the File Systems

Worked with DASD Group related to Storage on Mainframe Environment

Worked on capacity planning on database level

Used different tools to tune SQL queries like Database Advisor

Good exposure on Implementation, tuning and maintenance of the Databases used by the application, Data management policies and Procedures

Version 9.1, DDF, DRDA, OLTP, Data Prop AIX, Replication Center, QUEST Central Db2, Fog light, Snapshot, Third Party Tools, CLP and other monitoring tools, ETL, Explain, Plan table, JCL, TMON, JCLS, SPUFI, SQLS, STROBE, BMC Tool and Apton

Sr, DBA

July 2006 - December 2006 Global Software, American Family Insurance

Involved in Database design, Performance tuning, Trouble shooting, and using different kinds to tool to monitor the thread activates and upgrade

Worked on multi-terabyte database Partitions

Worked on capacity planning on database level

Used different tools like Database Advisor to tune SQL queries

Worked on setting up Backup and Recovery procedures

Strong Experience on Database Maintenance Activities – Reorg, Runts, Export, Import and Load

Used to interact with the users, Developers, business analyst, storage management group, project managers, server groups and testers

Worked as a Database Administrator with experience in designing and implementing very large-scale Data Warehouse solution for Insurance Services Customer Relationship Management practice

Good exposure on Implementation, tuning and maintenance of the Databases used by the application, Data management policies and Procedures

Worked on Test, QA and Prod

Environment: Quest Central, Spotlight, CLP, Snapshots, Explain, Control Center, CA Platinum Tool, File AID, ER Studio, DB2 Version 8.1, DDF, DRDA, OLAP, JES2, RACF, OLTP, Z/OS, UNIX AIX, JCL, DB2 SQLS, other Related Tools, Java, people soft HR, COBOL, ETL, Visual Explain, Plan table, SQR, IBM Utilities and, Db2 Monitor tools.

Senior DB2 DBA

September 2001 - June 2006 HTC Global Services Ltd, State Farm, IL

Data Warehouse/Data Mart and Data Mining Projects:

Worked on a Data Warehousing project, which involved designing and implementing large-scale Data Warehouse solution for Insurance Services Customer Relationship Management practice

Good exposure on Implementation, tuning and maintenance of the Databases used by the application, Data management policies and Procedures

Working with Very Large Database (VLDB) environments

Very strong knowledge of Fact, Dimension tables, Data Staging (ETL), BUFFER POOLS, Design, IBM utilities and other vendor products

Closely working with the Storage management, Operating systems, Business Analyst, Developers, testers, Architects and others

Efficiently managed distribution and consolidation configurations

Worked on Test, QA, Sim Prod and Prod

Worked on setting up Backup and Recovery procedures

Worked on capacity planning on database level

Strong Experience on Database Maintenance Activities – Reorg, Stas, Export, Import and Load

Worked on Database Objects

Strong Experience on Physical Design of the database

Sizing of very large Partition tablespaces, partition indexes

Working in a Data Sharing Parallel Sysplex environment with large size databases

Project: OLTP Projects – Different Release Numbers

Performed the Physical design of the database, worked closely with Data modeler of the logical design

Worked on performance tuning

Familiar with IBM Utilities, BMC Utilities, Platinum Tools and other vendor products

Worked Closely with Business Analyst, Developers, Testers and Operating systems

Improved SQL performance by using Plan table and Visual Explain

Worked on Data Recovery, DB2 Monitoring and Maintenance Strategy, Database Utility Recommendations, Tablespace and Index Reorganization, Index Alterations, DB2 Performance Enhancements, DB2 Object Monitoring, partitioning, indexing, and performance tuning

Environment: DB2 ADMIN, JCLS, SPUFI, SQLS, TMON BMC Utilities, Explain, Control Centre, CA Platinum Tool, File AID, ER Studio, DB2 Version 8.1, DB2 Connect, DRDA, RACF, OLTP, Z/OS, JCL, DB2 other Related Tools, COBOL, Visual Explain, Plain Table and Apptune

March 2000 - August 2001 Syntel Inc, American Express Bank

Risk Management System -Euro Conversion (GRMS)

The project involved converting the Native Currency to Euro Currency for the GRS IMS Databases

Involved in euro conversion Project the IMS Databases

To Analysis, Design, Documented, tested and implemented

Used BMC Utilities like BMC Unload, BMC Reload, Sync, PSB, ran BMC utilities and DBRC

Project: Global Financial Technology (GFT)

Involved in supporting Global Financial Technology application on 24/7

Used to give resolution to the problem and fixing the issues

Interact with the customers and users

Environment: CHANGMAN, MVS, OS390, FILEAID, COBOLII, TSO, SQL, JCL, TMON, SPUFI, IBM Utilities, TMON, DB2, IMS DB/DC, BMC UTILITIES, and JCL.

CASE CREDIT, Analyst

May 1999 - March 2000 Mastck Ltd, WI

M & I System & Credit Application - Maintenance Project

Involved in maintaining and enhancing the existing IMS Subsystem of the M&I loan and Credit application system, used for processing loans and credit advances

Performed Coding, testing, Documentation, Implementations in a production environment

Environment: IBM ES- 9000, MVS/ESA, IMS, JCL, COBOL, Pan Valet and Utilities

March 1998 - April 1999 CIGNA Insurance, Hartford, CT

November 1997 - March 1998 SAFEWAY UK

October 1997 - December 1997 DBS BANK Singapore

April 1997 - October 1997 Ashok Leyland

January 1997 - March 1997 Deadener Bank

February 1996 - January 1997 HAS-KB Conversion Project Belgium

April 1995 - February 1996 HAS-KB Conversion Project Belgium, Hartford, IL

May 1994 - February 1995 Dun & Bradstreet Corporation

December 1989 - December 1993 Sterling Holiday Resorts TIME SHARING

Environment: IBM 3090 MILLENNIUM, VS COBOL 1 to VS COBOL II, CICS, VSAM and JCL.

EDUCATION

Executive Project Management Course

Bryant University

Diploma In IBM

DSRC

DB2 DBA Training – IBM Australia

B Sc in Physics

Madras University

Diploma in Advanced Management

Baroda Productivity Council

Diploma in Chemical Process & Instrumentation Control

Annamalai University

Training in AWS Cloud and Architecture from AWS

SKILLS

Tools TMON, BMC Tool, ER Studio, Erwin, Rexx, CAPlatinum Tool, Dug, Spufi, JES2, Workbench, Endover, PANVALET,, MSPROJECT, PMW and CHANGMAN, MS Projector, BMC Tool, Apptune, Omega Mon and TMON,CA7,RDS, Jenkins, Git, Terraforms, Bit Bucket, Data Pipe Line, Cloud Watch and Data log

Hardware IBM Mainframes, IBM compatible PCs, Windows, AIX,AWS CLOUD, Red Hot Linux

Operating System Z/OS, OS390, MVS/ESA, VM/CMS, DOS/VSE, OS2, DB2 Windows, Windows XP, Windows NT, Windows98, Windows95, DOS and UNIX AIX, LINUX

Languages COBOL, C, Python and CLIST

Databases: PostgreSQL,MYSQL, DB2 Z/OS, UDB, IMS DB/DC, SQL Server, ACCESS and MongoDb

CONTACT

781-***-****

adz9md@r.postjobfree.com

Holliston, MA 01746

USA

CAREER OBJECTIVE

Experience Summary: Thirty years (30) of extensive experience in the Information Services Industry. Good Experience with AWS Cloud – Build number of RDS instances, Strong experience about Terraform, Bitbucket, Jenkins, Git and Data Pipe Lines, Jera, Board, Confluence and Jump Servers Good experience of the Monitoring tools of AWS Cloud, EBS,S3, EC2, RDS, VPC and PostgreSQL, MySQL and MongoDB Atlas Databases of AWS and Datadog Extensively worked with design changes, new design, know very well OLTP, datalake clusters physical design of DB inAWS,. Strong knowledge with capacity planning Database and configuration management. Implemented the Security(IAM) standards for the database environment and aligned it with enterprise's security standards. Strong experience on SQLS, JCLS, SPUFI, IBM Utilities Backup, Recovery, Reorg, Run stats, DSN1COPY, DSNPRINT and other Vendor Products. Strong experience on Grant appropriate privileges to primary and secondary AUTH IDs. Strong and Specialized experience performing DB2 Z/OS Administration, Coding Structured Query Language (SQL), Using SQL Processing using File Input (SPUFI), executing SPUFI Commands, and DB2 Tools, and completing DB2 Backups and Restores and installing new delivery builds. Strong and specialized experience with very large DB2 Z/OZ databases, DB2 Subsystems, and Performing Z/Operating System Health Checks by using RMF and other Tools. Strong experience creating data definition language (DDL), constructs, DML, DCL and using DB2 Utilities, Job control Languages (JCLs) and TMON and Control M... Managing and assign projects to team and communicating complex technical requirements to not technical personnel and preparing and presenting briefing to senior management officials on complex/controversial issues. Strong experience in the development of Trigger Generation, Store Procedure including SQL optimization, Execution, SQL Analysis & Streamlining, Data Recovery and System Fail-over, DB2 Monitoring and Maintenance Strategy, Database Utility Recommendations, Table space and Index Reorganization, Index Alterations, DB2 Performance Enhancements, DB2 Object Monitoring, partitioning, indexing, and performance tuning. Strong experience providing technical leadership in database design, administration, and support of performance related approach documentation and activities. Worked on Database Maintenance Activities –Backups, Load, Reorg, Rebuild Recovery, Export and Import. Strong Experience on UDB Physical Design of the database. Strong exposure on SQL tuning – Using different tools like Visual Explain, SQL optimizer and Database Design Advisor and Explain. Experience managing both on-shore and offshore teams. Proficient in Project Planning, Project Management, and Implementation. Strong experience on Design, Development and maintenance of DB2 Databases on Z/OZ. Strong experience Monitoring and Optimizing database performance and tuning SQL queries and database operation. Strong experience on SQLs and wrote complex queries and produced reports Participated in Deign Meeting of Data Mining, Data warehouse, Data Mart and ODS Systems. Worked on Development Data Dictionaries, Data Models, Metadata Repositories, and other IBM Management Tools like DB2 ADMIN, OMEGAMON, Data Studio and IBM DB2... Strong Experience on Database Design Schema for integrating source data into IBM Data Management systems... Build MUF for different environment and installed VE servers, Run CXX, PXX and LXX Reports- Datacom Worked as a Datacom DBA and helped application team with performance and other issues Strong Experience on Risk Management and ensured compliance with data management standard. Strong Experience on recommending new or modified standard to increase efficiency. Strong Experience on recommending performance enhancement such as increasing storage capacity or modifying interface of different components. Strong Experience to analyze a number of alternative approaches in the process of advising management concerning major aspects and include defining what system inter-relationships be considered, or Z/OS operating mode, system software (DB2), and /or configuration is most appropriate for a given project. Strong and specialized experience integration of IT programs and services; developing solutions to integration/interoperability issues; designing, developing, and managing IT security systems that meet current and future business requirements, and apply or extend, enhance, or optimize the existing architecture. Performing a wide range of IBM Database Administration function of designing of large database, including running test Queries and QA SQL queries, troubleshooting databases issues, maintaining version control of different environments of the databases entities, advising customers, testers and users on new database features and leading studies to evaluate the effectiveness of current database methods, procedures and standards. Extensively worked with design changes, new design, know very well data ware concept, physical design, IBM utilities and Business and other concepts. Experienced in Recruiting Technical consultant by taking technical interview, gathering and designing the requirement, estimating, creating specifications, building and managing small teams & building strong interpersonal relationship. Guiding junior DBAs in solving different technical and logical problems. Capable of managing multiple projects. Strong knowledge in presenting the solution for different environments. Strong coordination skill with functional and technical teams. Strong ability to convey and present technical concepts to top management. Possess excellent written and verbal communications skills. Strong experience as a Tech Lead to do Planning and coordinating the migration of data to a newer version of DB2 Z/OS – IBM Data Management System... Strong experience in DB2 Z/OZ IBM databases used to store and retrieve data and to develop standards for the handling of data and to lead significant projects assigned to test, QA and Prod installations and the modification of data elements, retrieval, and reporting of information to customers from the databases, and insuring the security of data.

.

Contact this candidate