Database Administration Administrator
Resume:
Sangeeta Kumar
**********@*****.***
Professional Summary
I have over 18 years of experience in Database Administration, with expertise in GoldenGate, Cloud Technologies, MongoDB, PostgreSQL, Azure, and AWS. My experience includes database administration on both on-premises and in the cloud, with a strong track record of managing 24x7 mission-critical very large Databases & Applications while ensuring cost-effectiveness.
Certifications
Oracle Certified Professional Cloud Database Administrator (OCP)
Oracle Certified Database professional in Database Administration. (OCP)
Oracle Certified PL/SQL Associate
AWS Certified Cloud Practitioner
Microsoft Certified Developer
Work Authorization: USA Citizen
Industry Served: Leading Healthcare, E-Commerce, Vehicle History & Insurance Clients
Tools:
Oracle, MongoDB, PostgreSQL, Cloud Tooling, AWS, Linux, GoldenGate, ASM, OEM, EXADATA, WebLogic, Oracle Cloud, JAVA,JSON, PL/SQL, Shell Scripting, Azure, AWS
Virtualization, Docker Container.
Technical Skills
Oracle GoldenGate
Cloud Technologies Oracle, Azure & AWS
Oracle GoldenGate Install, Configure & Patching
Goldengate Troubleshooting, Replication Lags, Process Abend issues
GoldenGate Performance troubleshooting
GoldenGate Heterogeneous data replication from Oracle to DB2
Handling bi-directional GoldenGate replication and data issues
GoldenGate Monitoring
Parameter changes and tables additions and modification
GoldenGate Mappings source and target objects
Exception & Error handling in the GoldenGate
GoldenGate Microservices
MongoDB
Installing MongoDB on servers and configuring it for production use.
Setting up configurations like storage engines, replication, and sharding as needed.
Managing snapshots and backups in cloud environments.
Managing user roles and permissions.
Monitoring replica set health and ensuring data consistency.
Monitoring shard health and performance.
Applying patches and updates to keep MongoDB up to date.
Cost Estimation and Resource Planning
Scaling resources up or down based on workload demands.
Migrated oracle databases from on-prem to Oracle OCI in Exadata
Migrated databases to Oracle, AWS RDS and Azure Cloud
Created & set up backup procedures in the secure Cloud Bucket.
Setting up Alerts for to monitor Cost & Service Availability
Used Cloud tools to create various resources in Oracle OCI & Amazon AWS
Created Cloud Infrastructures such as Buckets, Instances, Servers, DBaaS
Created & configured VM Servers in Cloud .
Configured Cloud database with OEM & Added enhanced monitoring
Developed and tested disaster recovery plans and procedures.
PostgreSQL
Installing PostgreSQL database software on servers and configuring
Backup of PostgreSQL database
Test PostgreSQL database restore.
Monitoring database performance and identifying and resolving performance bottlenecks.
Managing database access and security by configuring roles
Configuring high availability solutions such as replication, clustering, or failover.
Applying patches in PostgreSQL
Core Database Administration
MySQL
Installed Oracle 10g to 19c Real application cluster databases.
Created Data Modeling & Schema Designing.
Infrastructure as a service(IaaS), Database as a service DBaaS, PaaS, and Software as a service Model in Oracle cloud.
Administered Oracle Non-RAC and RAC databases.
Managed ASM Disks & Diskgroups.
Physical Standby Databases for Disaster recovery.
Database Flashback.
Applied Oracle Patches for bug fixing and database upgrade.
Upgraded databases from 10g,11g to 12c & 19c
Database Refresh from Production to Other Databases.
Data Extractions, Database Replication.
Oracle Job Queue, Batch Jobs.
User Management, Database Auditing
RMAN, Backup and Recovery
Batch processing using PL/SQL, Java., Control-M
Install and Configure MYSQL Databases in various environments
Database Performance Tuning MySQL Databases.
Trouble shooting and fixing problems using proactive approaches.
Tune queries by rewriting, creating indexes, allocating spaces, studying SQL plans & tracing the execution.
MYSQL Backup and Restore
MySQL Data refresh, Dev test Environments
.
Database Security
Created roles and procedure for database security and Application access.
Wrote script for Securing database by creating user profiles.
Enable Database auditing, monitoring & alerting.
Setup Enterprise database authentication via OID
Fine Grained Access Control, Database Auditing, Data Anonymization
Work History
Client: Accenture USA. OCT 2014. –Mar 2024
Client: Kansas Department of Health
Role: Database Administrator
Environment: Oracle 12c,19c RAC, JAVA, PL/SQL, Oracle Goldengate, Cloud, Exadata,OEM 13c, MongoDB,PostgreSQL
Oracle RAC, Exadata, ASM
Installed and configured Oracle databases (11g, 12c, 18c, 19c) and Oracle 13c grid control on Linux and Aix platforms.
Planning and executing database migrations from on-premises or other cloud platforms to the cloud.
Managed and maintained databases on Oracle Cloud ( Exadata/ExaCS).
Successfully upgraded databases from Oracle 11g to 12c, 18c, and 19c.
Orchestrated database migrations from on-premises to Oracle OCI on Exadata Machines.
Proficiently administered databases in various development, testing, and production environments.
Applied patches to keep databases up to date and secure.
Add/Remove Oracle ASM Disks, Created ASM Diskgroups
Configured Oracle Enterprise Manager (OEM), Added Hosts, Databases and other Targets
Create ACFS from ASM Diskgroups
Applied Java and GoldenGate patches.
Created and managed standby databases using Oracle DataGuard for disaster recovery.
Oversaw Oracle RAC installation, administration, and maintenance.
Wrote SQL and PL/SQL code to support business.
Migrated on-premises databases to Oracle Cloud.
Participated in scalability testing and proactively improved database performance.
Ensured database security and fine-grained access control.
MongoDB
Installed MongoDB on servers and configuring it for production use.
Setting up configurations like storage engines, replication, and sharding as needed.
Managed snapshots and backups in cloud environments.
Managed user roles and permissions.
Added and Removed tables in the Existing Environment
Managed replica set health and ensuring data consistency.
Monitored shard health and performance.
Applied patches and updates to keep MongoDB up to date.
Monitored MongoDB collections and related data on MongoDB Atlas.
Performed MongoDB upgrades on various platforms.
Goldengate
Installing Oracle GoldenGate software on source and target systems.
Configuring GoldenGate instances for various replication topologies.
Setting up GoldenGate parameters to define replication processes.
Tuning GoldenGate parameters for optimal performance based on system resources and network conditions.
Handling filtering and transformation of captured data.
Creating and configuring GoldenGate replication groups, trails, and extracts.
Defining replication paths and mappings for data movement.
Setting up GoldenGate Data Pump processes to move data between source and target databases.
Monitoring GoldenGate processes and components.
Troubleshooting GoldenGate replication issues, such as lag and process failures.
PostgreSQL
Installing PostgreSQL database software on servers and configuring
Backup of PostgreSQL database
Test PostgreSQL database restore.
Monitoring database performance and identifying and resolving performance bottlenecks.
Managing database access and security by configuring roles
Configuring high availability solutions such as replication, clustering, or failover.
Applying patches in PostgreSQL
MySQL
Install and Configure MYSQL Databases in various environments
Database Performance Tuning MySQL Databases.
Trouble shooting and fixing problems using proactive approaches.
Tune queries by rewriting, creating indexes, allocating spaces, studying SQL plans.
MYSQL Backup and Restore
MySQL Data refresh, Dev test Environments
Enterprise Holdings Inc, St. Louis, MO March 2013 - May 2014
Environment: Oracle 12c, RAC, JAVA, PL/SQL, PostgreSQL, Linux, ASM
Role: Database Administrator
Created ASM and standard non-ASM databases to meet varying business requirements.
Designed database schemas and objects, including tables, indexes, triggers, and sequences for E-CAR online and batch systems.
Developed code for database functions and stored procedures using PL/SQL.
Implemented custom scripts for space usage alerts in table spaces, data files, and databases.
Established robust backup and recovery strategies using RMAN and custom scripts tailored to business needs.
Created and maintained roles, procedures, and scripts to enhance database security.
Implemented audits, triggers, and alerts to monitor and secure sensitive data.
Provided day-to-day support to customers, resolving database access issues promptly.
Monitored database performance using custom scripts (e.g., PM3) and documented findings.
Managed data replication from production to other databases using GoldenGate.
Created and scheduled database jobs using tools like Scheduler, Ctrl-m, and Tivoli.
Efficiently performed data export/import using Data Pump.
Monitored and reported on database performance statistics.
Implemented robust database security measures and monitoring protocols.
Assisted developers in code promotion and collaborated with team members for database-related projects.
Facilitated off-hours business and customer support.
Estimated disaster recovery plans, documented scenarios, and communicated with users to define database projects.
Created and maintained ASM Standby databases.
Managed proper backups and maintained comprehensive documentation.
Analyzed AWR reports to troubleshoot performance-related issues and optimized database performance.
Evaluated backup strategies to enhance database recovery and restoration processes.
Designed, implemented, and managed security roles.
Created and maintained Data Guard and RAC setups of different configurations.
Conducted database upgrades to Oracle 11g.
Organized and participated in meetings to explore new database features and plan disaster recovery strategies.
Collaborated with cross-functional teams to support the business and facilitate deployments of TEST, DEV, and PROD databases
during off-cycles and quarterly releases.
Managed multiple PostgreSQL databases.
Created backup plans and tested PostgreSQL
Developed and deployed scripts for various deployments in payment, ECS, and Ecars databases.
University Of Missouri, Columbia Mar 2010 - Mar 2013
Environment: Oracle, SQL Server, .Net, ASP.NET,VB.NET
Role: Database Analyst
Environment: Oracle 10g, 11g, SQL Server, .Net, SQL, PL/SQL
Supported alumni system by creating oracle database objects and wed portal to support alumni business and customers.
Worked on Sunguard portal for campus solutions and support oracle database objects in the backend.
Rewrote and old mally code in ms apps and created and used oracle database object to develop alumni address, student
information product.
Prepared database for RMAN backup and documenting backup Scenarios.
Making Sure all backups are successful and cooperate with system Admin for tape backup
Import export data using oracle data pump.
Worked with Developers to solve problems and promote codes
Created Stored procedures, triggers and other database Objects.
Applied Database patches as necessary
Copy data from Production SQL server to Oracle database
Testing Oracle Databases after any major changes
Created shell scripts to run jobs in windows and Linux.
Used Export/Import and Data pump to move data from one database to other or storing these backup for future use.
Assisted Developers in Design Application Schemas, Data Modeling
Managed Oracle Users, Grants, Roles
Administered all database objects, including tables, indexes, views, sequences, packages and procedures.
Setup and maintain documentation and standards
Replicated Data from one database to other databases using materialized view
Created New Database objects & new Procedures, Scripts
Assisted Solving day to day new development & Production issues related to database & Java web based front end, Data refresh,
Worked with end users and other members of different departments.
Worked as part of a team and provide 7x24 support when required.
CARFAX Inc Oct 2006 - Feb 2010
Role: Oracle Application Developer / DBA in Agile Environment
Environment: Oracle 10g, 11g, JAVA, SQL,PL/SQL, Agile Methodology, Linux, Oracle Designer, MongoDB, ASP.NET,VB.NET
Responsibilities: -
Worked as Database Applications developer role in Agile Environment
Data replication using Database Links and Materialized views
Database Refresh from Production to Test Instances
Database monitoring, Job queues
Create Oracle RAC database.
Managed Real Application Cluster switch over, failover via DataGuard
Created Indexes, rebuild Indexes to save space and Speedup Queries
MongoDB Proof of concepts for Vehicle History document databases
Wrote various SQLs, Stored Procedures, Triggers, Functions
Identified the use of Database Security, Role Management etc
Wrote Batch jobs using PL/SQL
Installed MongoDB on multiple Servers for VHDB databases.
Created MongoDB backup plans
Managed and Troubleshoot MongoDB node replication.
MongoDB user management
SQL tuning by Re-writing queries and adding Indexes
Participation in database design & Modeling, Upgrade & Maintenance process
Making Sure standards are implemented through database objects naming such as Tables, Users, Indexes, Constraints etc,
Performed Automated testing Continuous Integration.
Object Oriented Design and development of Java Classes, Objects etc
Performed off hours On-Call production support responsibilities as needed
Developed Common Classes, Procedures used in various projects
Coordinated with the end user, DBAs and Analysts to ensure the changes in the application is meeting all the requirement and performing well in the production system.
Worked as part of a team and provide 7x24 support when required
Eligible to Work
US Citizen
Contact this candidate