20+years of experience DBA/DBE

Experience/Professional Summary

**+ Years of experience in Programming and DBA/DBE.

Expertise in Database Instance, database, SQL Performance tuning.

Automation expert using Python, Perl, PowerShell, and Unix Shell scripting.

Automated several DBA/DBE workflows using Python like building metrics/visualizations by ORACLE performance, MySQL slow logs from GCP/AWS RDS CloudSql, automating ORACLE DB audit frameworks, reports etc.

Proficient in designing, deploying, and managing AWS infrastructure as code using CloudFormation.

Strong knowledge in Kubernetes, Ansible, Azure data factory, Big Data solutions, Big Query, Dataproc, Dataflow, PySpark, Data Science, and machine learning.

Leading group of onsite/overseas DBAs to manage projects and provide database support/solutions to teams across the globe.

Experienced in performing multiple Proof of concepts to study observations/results on different technologies, solutions available in the market to understand and implement them in products for high performing/cost effective solutions for end customers.

Oversee relationships with different database software and operating system vendors regarding issues and implementation of solutions.

Strong in databases Oracle, MySQL, Postgres, DB2 and Informix Architecture.

Experience in setting up and maintaining Oracle Data guard for production databases.

Oracle Goldengate installation, configuration, and maintenance.

Designing and configuring heterogeneous MySQL replication solutions between GCP CloudSQL to different Clouds/client owned Data centers.

Observability tools: ELK Stack, OEM, Prometheus, Grafana, Wavefront and SolarWinds DPA

Experience in writing PL/SQL procedures/Functions/Packages/Triggers, Collections etc.,

Creating and managing database objects, users, roles, privileges in multiple databases.

Experience in ORACLE TDE and ORDS.

Performance tuning tools like ORACLE [using OEM, STATS PACK, TKProf and AWR reports] and DB2 [using snapshots, events, db2pd and db2top tools].

Expert in using Oracle Utilities [like Explain plan, SQL * Loader, Export/Import and Data Pump Etc DB2 Utilities [like db2pd, db2top, and db2look], and Informix Utilities [like onspaces, onstat, onmode, dbimport/dbexport, oncheck, istats, and dbaccess]

Experience with GIT, GitHub, BITBUCKET, and Jenkin tools

Education Profile

MASTER OF COMPUTER APPLICATIONS from MADRAS UNIVERSITY

BACHELOR OF SCIENCE [Electronics] from NAGARJUNA UNIVERSITY

AWS Certified Cloud Practitioner certification

Projects Experience:

Project #1: (Duration – Jul’23 to Till Date)

Clients : Intuit Mailchimp

Role : Staff Database Engineer

Environment : AWS and GCP cloud and MySQL v5.7 and v8, Postgres, BigQuery, ELK Stack, Shell scripting, and Python Automation

Project Description:

Mailchimp is an email and marketing automations platform for growing businesses. Mailchimp puts data-backed recommendations at the heart of your marketing, so you can find and engage customers across email, social media, landing pages, and advertising—automatically and with the power of AI.

Responsibilities:

●Addition to production availability and scalability responsibilities, Lead a modernization initiative, overseeing a team that upgraded a fleet of 3000 MySQL instances from version 5.7 to MySQL 8 and successfully transitioned from a local datacenter to the AWS public cloud.

●Planned and executed a PostgreSQL modernization project, upgrading from v9 to v16 and migrating to the AWS Aurora service for enhanced database performance and scalability.

●Developed reliable observability dashboards and configured alerts to notify the on-call team promptly in response to critical incidents for corrective action.

●Managed AWS infrastructure using CloudFormation to automate and streamline cloud resource provisioning and deployment.

●Optimized cloud account costs by leveraging knowledge of various instance class types, including Graviton and serverless options, to achieve efficient resource utilization and cost savings.

●Developed a framework to identify and collect top/slow SQL queries from the database layer, facilitating the coordination and triage of these queries to optimize database performance.

Project #2: (Duration – Jan’20 to Jul’23)

Title : MA Active Products

Clients : All MA Active customers.

Organization : Manhattan Associates, Inc.

Role : Senior Principal Database Engineer

Environment : Oracle 19c, AWS and GCP cloud and MySQL v5.7 and v8, postgres, BigQuery, Dataproc, Dataflow, ADF, ELK Stack, Shell scripting, and Python Automation

Project Description:

Manhattan Associates is one of the world leaders in Supply Chain Management Solutions. MA has world class products for various modules in SCM like Distribution Management, Warehouse Management, Transportation Life Cycle Management, Planning & Inventory Optimization and Fleet Management etc. As a R&D-Architecture DBE the team is responsible for Development/Design and Customer support activities.

Responsibilities:

●Maintaining and administrating ORACLE 19c instances both AWS RDS, ORACLE OCI, and Local datacenters; MySQL v5.7 / v8 instances from both AWS and GCP Cloud and inhouse datacenters.

●Designing and configuring heterogeneous MySQL replication solutions between Manhattan stacks hosted in GCP cloud to different Clouds/client owned Data centers.

●Working with R&D Development teams to design and develop highly scalable and reliable applications.

●Automated regular DBE jobs, like performance auditing both external, and internal clients, analyzing and parsing MySQL Slow logs from GCP to generate alerts and analytics Python.

●Leveraged GCP Services to process and manage the data from streaming and file-based sources.

●Performed data extractions using Dataflow streaming from Kafka

●Created spark jobs to extract data from Hive tables and process the same using dataproc.

●Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM).

●Maintaining, monitoring an ELK stack environment built using the MySQL slow logs and other related info pulled from several hundreds of client stacks and to keep an eye on performance of the SQLs and instances and address them to maintain the SLAs.

●Worked on several POCs with different cloud vendors and Big Data Solutions.

●Working very closely with implementation and client service teams while supporting the strategic planning, sales, and customer support activities.

Project #3: (Duration – Dec’11 to Jan’20)

Title : Planning and Inventory Optimization.

Clients : GPC, Factory Motor Parts, SP Richards, Cardinal, MKSN, UNFI, UNIS, and ULTA etc

Organization : Manhattan Associates, Inc.

Role : Senior Principal Database Engineer

Environment : RHEL and Unix/Oracle v12c, DB2 v10.5, Python Automation

Project Description:

Manhattan Associates is one of the world leaders in Supply Chain Management Solutions. MA has world class products for various modules in SCM like Distribution Management, Warehouse Management, Transportation Life Cycle Management, Planning & Inventory Optimization and Fleet Management etc. As a R&D-Architecture DBE the team is responsible for Development/Design and Customer support activities.

Responsibilities:

●Other than regular Database development and administration responsibilities like install/upgrade/support, primarily responsible for product performance and VPT on different combinations of workloads/hardware.

●Sizing internal/customer environments for product customers.

●Performing multiple POC for new technologies ORACLE SE2, ORACLE RAC, ORACLE Exadata, CouchDB and Cloudant.

●Design cost effective solutions for product customers.

●Leading group of onsite/overseas DBAs to manage projects and provide database support/solutions to teams across the globe

●Part of design team for custom/product enhancements and new modules.

●Supported development team/services teams and worked on database requests

●Working very closely with implementation and client service teams while supporting the strategic planning, sales, and customer support activities.

Project #4: (Duration – Sep’10 to Dec’11)

Title : https://saas.logistics.com

Client : Sysco Foods Inc, Rite Aid, and PPG

Organization : Manhattan Associates Development Center, Bangalore

Role : Senior Database Administrator

Environment : Linux/Oracle 11g

Project Description:

Manhattan Associates is one of the world leaders in Supply Chain Management Solutions. https://saas.logistics.com is Manhattan Associates transportation management system (TMS) Software-as-a-Service (SaaS) product, where environment’s infrastructure and application shared, hosted, and maintained by Manhattan Associates and registered customers’ access the environment via the Internet. Unlike traditional software, conventionally sold as a perpetual license with an associated up-front fee (and, typically, smaller ongoing support fees), SaaS providers generally price applications using a subscription fee, most commonly a monthly fee or an annual fee. Consequently, the initial setup cost for SaaS is typically lower than the equivalent enterprise software. SaaS vendors typically price their applications based on some usage parameters, such as the number of users ("seats") using the application. However, because in a SaaS environment customers' data resides with the SaaS vendor, opportunities also exist to charge per transaction, event, or other unit of value.

Responsibilities:

●Administrating SaaS Oracle PRODUCTION, STANDBY [Using Data Guard], STAGE, DEVELOPMENT and QA DB servers.

●Defining and monitoring the backup/Restore strategies for the SaaS production environment using Utilities like RMAN, Data Guard and Data pump.

●Maintaining SaaS environment specific Enterprise Data Warehouse [EDW] scripts which fetch and send the full/incremental data of a respective customer to their FTP server, so that they can maintain another optional environment which they can use that for their reporting purpose.

●Developing/maintaining SaaS specific reports and modules as per customer requirements.

●Performance Tuning (Statement Tuning), DB maintenance.

●Upgrading of Oracle software and taking care of required Oracle Patches.

●Data Migration from TMS older versions to higher versions.

●Working with R&D and QA teams on the client’s enhancements and on-demand requests.

●Co-ordination with SaaS Customers for database related incidences, changes, and review meetings.

Project #5: (Duration – Jul’07 to Sep’10)

Title : Transportation Management System.

Clients : Wal-Mart, AFLG, ASDA, Home Depot, DSG, Kroger, Lennox, MWVC, and VISY

Organization : Manhattan Associates Development Center, Bangalore

Role : Senior Database Administrator

Environment : Unix/Oracle 10g, DB2 9.1, and Informix V10

Project Description:

Manhattan Associates is one of the world leaders in Supply Chain Management Solutions. MA has world class products for various modules in SCM like Distribution Management, Warehouse Management, Transportation Life Cycle Management, Planning & Inventory Optimization and Fleet Management etc. As a R&D-Architecture DBA the team is responsible for Development/Design and Customer support activities.

Responsibilities:

●Setting up/Configuring and Supporting product Internal Development, QA DB servers [Oracle and DB2], and some time Customers Production and QA DB servers as well [In case of AFLG Customer, supported the customer production and QA DB2 DB servers from India for several months]

●Part of design discussions team as part of Customer specific enhancements for major customers like AFLG and Sysco.

●Supported development team/Product teams and worked on database requests

●Performing performance engineering as part of both development cycle perspective and customer reported environment specific performance issues.

●Working on customer specific enhancements and customizing the product as per customer requirements by interacting with customer representatives.

●Working with respective customer PSO development teams in gathering the customer requirements and preparing the documents.

●Taking care of customer’s migration requirements by providing customer specific migration scripts in case respective customer has customized product installed in their environment.

Project #6: (Duration – Dec’05 to Jun’07)

Title : Pharbase Europe

Clients : Dendrite International, Europe

Organization : Dendrite India Solutions Ltd., (Aztec Soft)

Role : Sr. Developer

Environment : Linux/Windows/Oracle 9i

Project Description:

Pharbase is a comprehensive worldwide database of healthcare professionals incorporating local country frameworks and organizations. Pharbase plays an integral part in the Dendrite solutions portfolio and assists the pharmaceutical industry in identifying and managing their customers. Information stored on Pharbase is rigorously checked and verified before release to clients, thus ensuring the continued accuracy of the data. Pharbase advanced contains syndicated data for segmentation and targeting (visiting, mailing, and marketing pressure, share of voice, doctor potential, etc). It provides a single view of the customer through consolidation of all customer interactions. Pharbase Advanced supports selection of the correct target audience for promotional activity and tailoring of channels/messages for that audience.

Responsibilities:

●Creating and maintaining DTC (Distributed Transaction Control) Packages, linked servers of SQL SERVER

●Working in different language setting environments.

●Data Migration from One Database to another Database

●Writing Procedures/packages/triggers/collections

●Involved in Data Modeling

●Performance Tuning (Statement Tuning), DB maintenance

●Install Oracle software and Prepare Databases for training and test DB

Project #7 :( From Feb’04- Nov’05)

Title : Implementation of CFST (citizen friendly services of transport department)

Client : Transport department, Government of Andhra Pradesh

Organization : Tera software Ltd.

Role : Software Engineer

Environment : Windows NT, Windows 2000, Oracle 8.1.7, and VB6.0

Project Description:

The client is Road Transport Authority of Andhra Pradesh (RTA. A.P). this project consists of 5 modules. 1. Learner Driving License 2. Driving License 3. Registration of Vehicles and taxation 4. Permits 5. Conductor Driving License. We deal with the implementation and database maintenance part of the project. This project has already been implemented at 4 district head quarters of A.P. We have implemented the remaining 34 centers. The advanced DBA concepts are used to establish the connection between the Central Server at Hyderabad and the remaining centers, which are located at remote places. This project is also planned to establish online information scrutiny at check posts also, so that the taxes or punishments to the vehicle owners can be levied at the spot itself. The database will replicate to the central server on daily basis.

Responsibilities:

Developing Pl/SQL Stored Procedures, Functions, Packages and Triggers

Database performance/Statement tuning.

Contact this candidate