Sql Developer Database Specialist
Resume:
M. Srilatha
Distributed Database Specialist
********.**@*****.***
Career Objective:
Having 15+ years of experience in supporting SQL, PL/SQL, PostgreSQL,Oracle databases running on all versions 8.2 - 9.3 on a 24x7 basis. Very strong in administration, installation & configuration, development, version upgrades, data migration, backup and recovery, replication, disaster recovery, performance monitoring & tuning, index optimization, shell scripts, database development, writing stored procedures & triggers. Perform a variety of PostgreSQL tasks related to problem resolution and monitoring, administration, availability, performance, and security. Additionally, experienced in leveraging AI automation tools such as Make.com, Chatbots, and Gamma to optimize workflows, enhance process automation, and deliver intelligent solutions.
Professional trainings and Certifications:
Oracle 12C Certified Associate.
Oracle PL/SQL Developer Certified Associate.
Oracle Advance PL/SQL Developer Certified Professional.
Completed SAP BOBJ and HANA Corporate internal training and Certified Professional from SAP.
AWS Certified Cloud Practitioner.
Educational Qualification:
Masters of Computer Applications (MCA) completed in 2006.
Bachelor of Computer Applications (BCA) completed in 2003.
LinkedIn : wwwwww.linkedin.com/in/srilatha-m-8974301a3
Projects & Responsibilities :
Project 6 : Distributed Database Specialist Atlanta, GA
Client : Global Payments
Duration : July 2022 to Till Date
Environment : PostgreSQL,OracleAWSCloud,GITRepo,Kafka,JenkinsRunbooks,Linux/Unix, Make.com, Chatbots, Gamma (AI Automation Tools)
Windows, Backup Scheduler, Replication, Shell scripting, Dev Op’s.
Accomplishments of PostgreSQL/Oracle DBA:
Implemented AI-driven automation solutions using Make.com, Chatbots, and Gamma to streamline database operations, automate workflows, and improve deployment efficiency.
Provide technical insight during the troubleshooting of existing issues during the formulation of enhancements and reporting.
Review and analyze the effectiveness and efficiency of existing systems and develop strategies for improving or further leveraging these systems.
Create and maintain documentation related to delivering support to existing usage of applications or to proposing new alternatives or process changes.
Prepare and deliver reports, recommendations, or alternatives that address existing and potential trouble areas in operating systems across the platform.
Actively participates in development of new learning activities in emerging delivery techniques like: Agile, Scrum Design Thinking, Blockchain etc.
Creating deployment runbooks plans and integrated into GIT Repo’s.
Working on db performance tuning, Indexing, partitioning, sequence Creation, auditing the seed data tables.
Migrating and Modernizing applications from PostgreSQL to oracle cloud to leverage the performance and converting seed data using DMS.
Consult client/ bid teams on solutions related to Oracle Cloud stack of products - Cloud ERP on financial applications.
Creating Jenkins runbooks to provision the instances and deploy the applications on AWS cloud.
On-Call support for Global Payment financial applications like Loyalty, TCS, auth Debit DB, Mobile Banking, chip card, data subscriptions, customer accounts etc
Coding of new tables, views, Foreign Keys/Primary Keys, and modifications as well as Pl/PgSQL Stored Procedures, Data Types, Triggers and Constraints.
Support Third-Party Applications Such as PG-Admin, AWS Console, RDS, SQL developer tool, DBeaver etc…
Decommissioning the retired instances from AWS cloud by using Jenkin plans.
Project 6 : Sr.PostgreSQL Chicago, IL
Client : Peapod Digital Labs
Duration : Mar - 2020 to June 2022
Environment : PostgreSQL, GITHUB, Linux/Unix, Windows, Microsoft Azure, Postgres on CITUS Clusters, Backup Scheduler, Replication, Shell scripting, Flyway Jenkins Jobs, Dev Op’s, Informix, Pentaho. Make.com, Chatbots, Gamma (AI Automation Tools)
Accomplishments of PostgreSQL DBA:
Installing CITUS on Postgres through the Salt and Configuring CITUS Clusters.
Experience in deploying, managing, and developing PostgreSQL clusters on Windows and Linux environment to improve processes.
Performing test by running pg_autoctl failover, switchover and make sure the replication is working between CITUS primary and secondary Nodes.
Creating a backup strategies plan and deployed scripts in place.
Onboarding Application Databases and standardization of user roles.
Providing the JDBC Connectivity for app Team and granting required Access privileges
Onboarding App Users and AD (Active Directory) users by authenticating LDAP ID/Password.
Provide the technical support for incidents & investigation applications deployed for Peapod Digital labs, Create, and execute scripts.
Maintaining multiple PostgreSQL database servers and services on different platforms.
Integrated Order management, Lockbox (financial db.), Inventory Management Applications with External interfaces in Peapod Digital App.
PostgreSQL Installation, Configuration, Migration, Upgrades and Patches on on-premises standalone servers.
Perform Root Cause analysis, security and data testing strategies and practices.
Environment consists of high-availability customer-facing databases on Azure and application Server versions ranging from PostgreSQL 10.2 to 13. Make.com, Chatbots, Gamma (AI Automation Tools)
Creating AAD (Azure Active Directory) users and groups on Azure.
Optimize postgresql.conf, pg_hba.conf files for performance improvement.
Migrating Informix Databases to Azure Postgres and Database modernization.
DB Performance tuning, Indexing, Disaster recovery planning or Emergency Recoveries and Ensuring Recoverability of Database Back-ups and restores.
Worked on reporting, development, QA, Stage and production database on Azure, On-prem environments.
Documented the Confluence pages for standard process, procedures, and configuration.
Coding of new tables, views, Foreign Keys/Primary Keys and modifications as well as Pl/PgSQL Stored Procedures, Data Types, Triggers and Constraints.
Support Third-Party Applications Such as PG-Admin, Azure Data Studio, DBeaver etc…
Project 5 : Sr.PostgreSQL Atlanta, GA
Client : NAPA GPC (Genuine Parts Company)
Duration : Jan - 2016 to March 2020
Environment : PostgreSQL, GITHUB, Linux/Unix, Windows, AWS RDS, AWS Cloud, AWS SCT,AWS DMS, Backup Scheduler, Replication, Shell scripting. Make.com, Chatbots, Gamma (AI Automation Tools)
Accomplishments of PostgreSQL DBA:
Experience in deploying, managing, and developing PostgreSQL clusters on Windows and Linux environment to improve processes.
Provide technical support for incidents & investigation applications deployed for NAPA GPC and Create and execute scripts.
Maintaining multiple PostgreSQL database servers and services on different platforms.
Integrated ERP & RPM Application with External interfaces like POS, App Launcher, PostgreSQL and Oracle Databases etc.
PostgreSQL Installation, Configuration, Migration, Upgrades and Patches.
Perform Root Cause analysis, security and data testing strategies and practices.
Environment consists of high-availability customer-facing database servers and application Server versions ranged from PostgreSQL 8.2 to 9.3. Make.com, Chatbots, Gamma (AI Automation Tools)
Optimize postgresql.conf for performance improvement.
applied patch set and interim patches whenever required to make the database software up to date.
Responsible for maintaining the reporting, billing, and invoicing databases (PostgreSQL)
DB Performance tuning, Indexing, Disaster recovery planning or Emergency Recoveries and Ensuring Recoverability of Database Back-ups and restores.
Creating Users and Providing DB access privileges.
Organized automated monthly restores (24 databases on three servers).
Worked on reporting, development, QA, and production database environments.
Documented procedures and configuration.
Cloud deployments of PostgreSQL on AWS RDS by using AWS SCT schema conversion Tool.
Migrated Oracle DB to PostgreSQL on RDS by using AWS DMS (Database Migration Service).
Coding of new tables, views, and modifications as well as Pl/PgSQL Stored Procedures, Data Types, Triggers and Constraints.
Involved in UTF-8 testing.
Support Third-Party Applications Such as PG-Admin, Barman, and Query tuning.
Project 4 : PostgreSQL DBA SFO, CA
Client : McKesson
Duration : July - 2014 to Jan-2016.
Environment : PostgreSQL, SQL*Loader, Oracle, Shell Scripts, JAVA, UNIX, Windows. Make.com, Chatbots, Gamma (AI Automation Tools)
Accomplishments of DBA:
Primary responsibility for Inventory & Project Tracking System 24/7/365 high availability Postgres production and development databases.
Install & configure development PostgreSQL 8.1.1 databases on Fedora Core 7 servers.
Updated earlier releases of PostgreSQL to version 8.2.5 on 6 servers running Fedora Core 7.
Ensure night cron jobs for backups, re-Indexing & vacuuming & materialized views executed properly on 24/7/365 high availability Postgres production and development databases.
Bash shell scripts for scheduled maintenance.
Review all PostgreSQL logs for problems.
Create, Backup, Restore & Drop databases per developer’s requirements.
Implement Slony replication for Development, QA & Production databases.
Automated backup scheduling jobs through pgAgent, cron or pg_cron (on Linux)
Respond to database outages caused by equipment failure and coordinate with Network Admin to perform database fail over to standby servers.
Insure high availability of production via Slony replication.
Propagate all database changes (DDL & DML) to multiple databases and servers.
Optimize postgresql.conf for performance improvement.
Coding of Pl/PgSQL Stored Procedures, Data Types, Triggers, Constraints and Constraints.
Review database schema & structure for design improvements and data normalization.
Coordinate with Java developers for changes to schema & table structures.
Project 3 : SQL & Oracle Parsippany, NJ
Client : AIG Charities Insurance
Duration : July - 2010 to June -2014.
Environment : SQL*Loader, Oracle, Shell Scripts, UNIX, Windows, Azure. Make.com, Chatbots, Gamma (AI Automation Tools)
Accomplishments of DBA:
Created a recovery catalog, performed the complete and incomplete recovery using RMAN.
Wrote scripts for backup of databases, maintenance of archive logs for databases.
Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
Scheduled meetings with application team for database migration review to gather legacy information such as type of application, database options, current Oracle configuration, capacity, and oracle outstanding tasks.
Migrated on-premises Oracle database to the SQL Server cloud database, Azure SQL Database.
Involved in pre-Migration, migration, and post migration Phase during the Azure DB Migration.
Having an onsite experience of handling offshore team from IBM, India.
Developed, revised, and implemented policies, standards, procedures, and guidelines necessary to effectively administer the database environments.
Implemented High availability using Golden Gate Replication.
Implemented and managed optimum physical database design (tablespaces, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth, and file system space, in adherence to the optimal flex architecture.
Provided instance-level performance monitoring and tuning for event waits, sessions, physical and logical io, and memory usage.
Implemented OEM in Oracle 11g..
Monitoring the scheduled backup procedures for daily basis using crontab.
Used power designer, e/r studio for data modeling and to estimate the database size, database design reviews.
Project 2 :Oracle Developer Gurgom, India
Client : Hero Honda.
Duration : Jan 2010 – July 2010
Environment : C, C++, UNIX shell scripting, Oracle 10g, PL/SQL, Toad, SQL *Plus. Make.com, Chatbots, Gamma (AI Automation Tools)
Accomplishments of SQL & PL/PLSQL Skills:
Developed PL/SQL Packages, Procedures and Functions in accordance with Business Requirements for loading data into database tables.
Involved in Unit Testing Stored Procedures and Functions.
Created Materialized Views and partitioning tables for performance reasons.
Worked on various backend Procedures and Functions using PL/SQL.
Resolved performance issues and bugs within packages, forms, and reports using DBMS output, Forms debugger, explain plan.
Developed UNIX shell scripts to perform a nightly refresh of the test system from Production databases.
Coordinate with the front-end design team to provide them with the necessary stored package and procedures and necessary insight into the data.
Involved in all phases of the SDLC for Designing & giving recommended approach to satisfy the requirements.
Development of C modules for activation, deactivation, and modification of these plans in Clarify Front End
Created SQL*Loader scripts to load data into the temporary staging tables.
Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team
Used TOAD, PL/SQL developer tools for faster application design and development.
Developed procedures using Dynamic SQL.
Developed database objects including tables, Indexes, views, sequences, packages, triggers, and procedures to troubleshoot any database problems.
Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements.
Created Materialized Views and partitioning tables for performance reasons.
Resolving the issues on a priority basis.
Responsible for Analyzing and Implementing the Change Requests.
Involved in handling the changes in compiling scripts according to the database changes.
Project 1 :SQL Developer Pune, India
Client : UBICS
Duration : Feb 2008 - Dec 2009
Environment : C, C++, UNIX shell scripting, Oracle 10g, PL/SQL, Toad, SQL *Plus. Make.com, Chatbots, Gamma (AI Automation Tools)
Accomplishments of SQL & PLSQL Skills:
Developed database objects including tables, Indexes, views, sequences, packages, triggers, and procedures to troubleshoot any database problems.
Developed procedures using Dynamic SQL.
Created SQL*Loader scripts to load data into the temporary staging tables.
Worked on various back-end Procedures and Functions using PL/SQL.
Resolved performance issues and bugs within packages, forms, and reports using dbms_output, Forms debugger, explain plan.
Involved in Unit Testing Stored Procedures and Functions.
Contact this candidate