Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
InfosysSenior Consultant
Oct. 2020Richardson, Texas, United States• Daily Support and Maintenance of Oracle Databases 10g, 11g, 12c and 19c with RAC and Physical Standby also Managing of tickets on the ServiceNow ticketing system ensuring there is no traffic of tickets on the queue. Tablespace Management. Handled large DB of up to 100TB.
• Work on Upgrades (from 10 to 19c) and Migration projects for On-premises Database as well as Migration to the Cloud (both OCI and AWS). Upgraded the database from 11.2.0.4 to 12.1.0.2 with Non-ASM to ASM conversion and Non-RAC to RAC setup. VCS clusters as well.
• Onboarding of new databases, backup setup using crontab and Schedulers. • Lead my team in the quarterly PSU automation. • Refresh of QA databases with Prod data using Data Pump.
• Monitoring backups ensuring they run successfully and if any failures, Checking the alert logs and then fix the issues/rerun the backups.
• Database and schema/table restore. User management and Permissions ensuring Security. • Worked on setting up environment Portal using APEX for easy monitoring, aligning of Databases/Servers given who can have access or not, Tablespace monitoring, Password expiration and more. • TDE encryptions and ACLs. • For AWS I have leveraged S3 buckets as storage solutions. I ensured security and access to these storage buckets through various techniques (ACL, MFA, Encryption, IAM roles etc.). • Managed customers infrastructures through EC2 instances with EBS volumes and EMR (Elastic Map Reduce). For structure setup leveraged VPCs, Subnets (Public and Private) using Route Tables as they flow through the Internet Gateway as well as Nat Gateway. • Worked on setting up VPC Peering, VPC Endpoints. And for connection security NACLs (at Subnet level) and Security groups (at EC2 level). • Lead Team Meetings, Client Meetings with best practice suggestions, product and services enhancement options and possible cost optimization. • Versed with Oncall rotations
CapgeminiSenior DBA/AWS Architect
Sep. 2018 - Dec. 2020Atlanta, Georgia, United States• Upgrading all 11g databases to 19C and migrating them to OCI.
• My environment is predominantly RAC hence setting up new RAC builds and ensuring ASM is well set up for storage management.
• Enforcing and managing Security and Audit requirement compliance. Setup of TDE and wallets for better security.
• TDE encryptions and ACLs. • For AWS I have leveraged S3 buckets as storage solutions. I ensured security and access to this storage buckets through various techniques (ACL, MFA, Encryption, IAM roles etc.). • Managed customers infrastructures through EC2 instances with EBS volumes and EMR (Elastic Map Reduce). For structure setup leveraged VPCs, Subnets (Public and Private) using Route Tables as they flow through the Internet Gateway as well as Nat Gateway. • Worked on setting up VPC Peering, VPC Endpoints. And for connection security NACLs (at Subnet level) and Security groups (at EC2 level). • Performance tuning by Fine Tuning Initialization parameters, I/O, Memory, storage and Operating System kernel parameters, Oracle SQL, optimizer, and query plan, optimize queries and performing PL/SQL code profiling. Also Troubleshooting the Database Performance issues by analyzing Automated Workload Repository (AWR), Active Session History (ASH), Automatic Database Diagnostics Monitor (ADDM) reports, using SQL Adviser & UNDO Adviser tools, OEM GRID, TOAD Tracing Blocking / Locking and Long Running sessions, Wait Interface. • Capacity Planning as per Data growth and workload by working closely with other decision-making Teams such as Development, Business / Clients. • Generating Monitoring shell Scripts and creating Cron jobs for OGG gaps, DR setup and monitoring as well as ensuring no Log Gaps. Also written SQL scripts to create database objects like tables, views and sequences.
Abercrombie & FitchOracle DBA
Mar. 2016 - Jul. 2018Columbus, Ohio AreaInvolved in Installing, Configuring and Administration of Oracle 10g/11g RAC on ASM.
Upgraded databases from 11.1.0.7, 11.2.0.2 to 11.2.03 and to the new 12c.
Worked on 2 node RAC databases from 200GB – 10 TB
Installed 10g /11g binaries on HP-UX and Linux servers and configured new production databases for the same.
Proficient in writing UNIX Shell scripts to automate business process and daily backups.
Exposure to new 12c Features, Container and Pluggable Database, FAR-SYNC Instance, Cascade Redo Transport Destination, allowed usage of SYNC and NOAFFIRM to extend Data Guard Range, Moving online Data file, etc.
Implemented scripts to monitor and get information on free space, alert log errors. Provided maintenance of user accounts, privileges, profiles and roles.
2 Years experience using 11g and 12c Golden Gate, Oracle Instance tuning, and SQL tuning was done using OEM GC, AWR, ASH, ADDM, SQLT, TKPROF, SQL Tuning Advisor and SQL Tuning Sets.
Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
Refreshing Dev and Test instances with data from Production. Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
Resolving issues related to Network Congestion, Memory (SGA and PGA), CPU & IO and other oracle related issues.
Migration of database from one server to another server.
Responsible for configuring dataguard physical and standby database setup for disaster recovery and handling synchronization issues between primary and standby.
Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
Expedia GroupOracle DBA
Aug. 2012 - Feb. 2016 Bellevue, WA Responsible for continuous Monitoring of CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck and reorganization for ensuring performance. Monitored queries with high response time and high disk read per execution (Top SQLs) and tuning the same using Explain Plan, TKPROF and SQL tuning advisor. Involved in De fragmenting data blocks of table spaces for optimized performance. Also partitioned large tables to increase performance. Responsible for all database activities such as User management, space management, database security management. Implemented the resizing the online redo logs in production and in standby database. Automated Database refresh from the Host system to Oracle using, SQL and PL*SQL procedures. Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 10g R2 Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs. Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups. Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files. Used to run the scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc. Performed space management, capacity planning, disaster recovery and overall maintenance of the databases. Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries. Maintained the data integrity and security using integrity constraints and database triggers. Provided 24X7 support for all the production and development databases.
Intch is a Professional Networking App for the Future of WorkSee more people like Mildred on Intch
100k+ people
130+ countries
AI matching
Get Intch if you'd like to
65023 people
8
CEO @ AssetData
15
Business analysts @ National Flood Services
15
CEO @ Gadgetgts
1631 people
15
Partner @ First Serve Healthcare Consulting
24
Data Architect @ BI Visions
15
CEO @ Free Mountain Inc